DB2 - Problembeschreibung
Problem IT09017 | Status: Geschlossen |
INSTANCE CAN CRASH RUNNING A SQL ON COLUMN BASED TABLES(CDE). | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
Instance can crash running a SQL on Column Based Tables(CDE). The trap look like the following: 2015-04-22-16.15.04.814251+120 I33801238E2318 LEVEL: Event PID : 20934 TID : 140685860660992 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-37247 APPID: 255.255.255.255.57615.150422140056 AUTHID : db2inst1 HOSTNAME: db2host1 EDUID : 2096 EDUNAME: db2agntcol (SAMPLE) 0 FUNCTION: DB2 UDB, oper system services, sqloPGRPRegisterOneCrash, probe:2159 MESSAGE : lastCrashCount DATA #1 : unsigned integer, 8 bytes 0 DATA #2 : String, 10 bytes inRecovery DATA #3 : Boolean, 1 bytes false CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00007FFFF28F02BC sqloPGRPRegisterOneCrash + 0x17C [1] 0x00007FFFF2941719 sqloEDUCodeTrapHandler + 0xA49 [2] 0x00007FFFF7BCF710 /lib64/libpthread.so.0 + 0xF710 [3] 0x00007FFFF1C21963 _ZN7ibm_cde5query24LoadNestedQueryEvaluator23getCseNestedQueryOu tputERmRSt6vectorINS_8services18CountedPtrWithCopyIKNS_5types10 + 0xEC3 [4] 0x00007FFFF1C1FF01 _ZN7ibm_cde5query24LoadNestedQueryEvaluator26processInputsSynchr onouslyEv + 0x251 [5] 0x00007FFFF38427A2 _ZN7ibm_cde5query9Evaluator8evaluateEbbRNS1_21EvaluatorRestartSt ateEPNS0_19OptPredicateTrackerE + 0x402 [6] 0x00007FFFEE69775E _ZN7ibm_cde5query17EvaluationRoutine8evaluateEjP15sql_static_dat a + 0x31E [7] 0x00007FFFF1C2D8F3 _ZN7ibm_cde5query9Scheduler13runThreadTaskEPvPi + 0x3C3 [8] 0x00007FFFF1C35A6E _ZN7ibm_cde5query17cdeEntryPointImplEP8sqeAgentPvS3_ + 0x6E [9] 0x00007FFFF1BE5FB3 _ZN12cdeInterface16startCdeSubagentEP8sqeAgent + 0x83 [10] 0x00007FFFF0D32071 _Z14sqlriInvokeCdeP8sqlrr_cb + 0x41 [11] 0x00007FFFF3933071 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x1B1 [12] 0x00007FFFF0B3D9F8 _Z16sqlrr_smp_routerP8sqlrr_cb + 0x2C8 [13] 0x00007FFFF0B3C8FE _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x58E [14] 0x00007FFFEF97657D /bbdd_idisarbl/sqllib/lib64/libdb2e.so.1 + 0x30C057D [15] 0x00007FFFEF97503C _Z21sqleProcessSubRequestP8sqeAgent + 0x2DC [16] 0x00007FFFEF990580 _ZN8sqeAgent6RunEDUEv + 0x4A0 [17] 0x00007FFFF1176047 _ZN9sqzEDUObj9EDUDriverEv + 0xF7 [18] 0x00007FFFF094F181 sqloEDUEntry + 0x301 [19] 0x00007FFFF7BC79D1 /lib64/libpthread.so.0 + 0x79D1 [20] 0x00007FFFEB6F6B6D clone + 0x6D | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All Platforms * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 LUW v10.5 Fixpack 7 or Later. * **************************************************************** | |
Local-Fix: | |
Lösung | |
First Fixed in DB2 LUW v10.5 Fixpack 7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 21.05.2015 21.01.2016 21.01.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |