DB2 - Problembeschreibung
Problem IT02670 | Status: Geschlossen |
TRAP IN SQLPKILLIFWAITING AFTER DEADLOCK | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
DB2 might trap with the following stack when there is a deadlock and at least one of the involved transactions is in one of these states (shown in db2pd -db <dbname> -transactions output collected as part of FODC): Prepare (PREP), Abort (ABORT), Commit (COMMIT), or Rollback to Save Point (SAVEPNT). 0 ossDumpStackTraceInternal 1 ossDumpStackTraceV98 2 OSSTrapFile::dumpEx 3 sqlo_trce 4 sqloEDUCodeTrapHandler 5 __PRETTY_FUNCTION__.6093 6 sqlpKillIfWaiting 7 sqlpCheckAndKillTransaction 8 sqlplLDDResolveLocalDeadlocks 9 sqlpldl 10 sqpLLMEdu::RunEDU 11 sqzEDUObj::EDUDriver 12 sqloEDUEntry 13 pthread_tryjoin_np 14 clone Note the agent that will be trapping is the deadlock detector EDU (db2dlock). EDUNAME: db2dlock (<database_name>) 0 FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:90 MESSAGE : ADM14011C A critical failure has caused the following type of error: "Trap". The DB2 database manager cannot recover from the failure. First Occurrence Data Capture (FODC) was invoked in the following mode: "Automatic". FODC diagnostic information is located in the following directory: | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.5 and Fix Pack 5 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Problem was first fixed in DB2 Version 10.5 and Fix Pack 4 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 19.06.2014 08.09.2014 08.09.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.4 |