DB2 - Problembeschreibung
Problem IT10184 | Status: Geschlossen |
UPDATE TO COLUMNAR TABLE CAN SOMETIMES LEAD TO DB2 CRASH | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
Update to columnar table can sometimes lead to DB2 crash The following will be seen in the trap diagnostics: </Siginfo_t> Signal #11 (SIGSEGV): si_addr is 0x0000000000000008, si_code is 0x00000001 (SEGV_MAPERR:Address not mapped to object.) </SignalDetails> <POFDisassembly> _ZN7ibm_cde5query21LoadColValueEvaluator20cdeFastLoadColValueTIN S_5types7IntegerIlLb0EEEEEvmPKNS_4data13TableAccessorEPKNS6_6Col umnERKNS3_22TypeAllocatorResourcesERbP10sqlz_valuePPNS3_10ValUnc odedE + 0x026d (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4CDE363ED : 498B4608458B6604 </POFDisassembly> <StackTrace> -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00007FB4CB6AB205 _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 0x0385 (/db2/home/db2inst1/sqllib/lib64/libdb2osse.so.1) 0x00007FB4CB6AAE0C ossDumpStackTraceV98 + 0x002c (/db2/home/db2inst1/sqllib/lib64/libdb2osse.so.1) 0x00007FB4CB6A5F0D _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00fd (/db2/home/db2inst1/sqllib/lib64/libdb2osse.so.1) 0x00007FB4D1B4A964 sqlo_trce + 0x0404 (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4D1B9FE9A sqloEDUCodeTrapHandler + 0x027a (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x000000380720F710 address: 0x000000380720F710 ; dladdress: 0x0000003807200000 ; offset in lib: 0x000000000000F710 ; (/lib64/libpthread.so.0) 0x00007FB4CDE363ED _ZN7ibm_cde5query21LoadColValueEvaluator20cdeFastLoadColValueTIN S_5types7IntegerIlLb0EEEEEvmPKNS_4data13TableAccessorEPKNS6_6Col umnERKNS3_22TypeAllocatorResourcesERbP10sqlz_valuePPNS3_10ValUnc odedE + 0x026d (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4D0EC70E2 _ZN7ibm_cde5query21LoadColValueEvaluator19cdeFastLoadColValueEmP KNS_4data13TableAccessorEPKNS2_6ColumnERKNS_5types22TypeAllocato rResourcesERbP10sqlz_valuePPNS9_10ValUncodedE + 0x0152 (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4D0E91CE5 _ZN25cdeTableAccessorInterface6getPRTEmPm + 0x0095 (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4D0E84114 _ZN12cdeInterface6getPRTEmPm + 0x00b4 (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4D28579FE address: 0x00007FB4D28579FE ; dladdress: 0x00007FB4CBBC8000 ; offset in lib: 0x0000000006C8F9FE ; (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4D2857D25 address: 0x00007FB4D2857D25 ; dladdress: 0x00007FB4CBBC8000 ; offset in lib: 0x0000000006C8FD25 ; (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4D285A641 address: 0x00007FB4D285A641 ; dladdress: 0x00007FB4CBBC8000 ; offset in lib: 0x0000000006C92641 ; (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4D2BFFF60 address: 0x00007FB4D2BFFF60 ; dladdress: 0x00007FB4CBBC8000 ; offset in lib: 0x0000000007037F60 ; (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4D2BFDF22 _Z8sqlischfP7SQLI_CBtj + 0x1122 (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4D2BEE0F7 _Z7sqlirdkP8sqeAgentP10SQLI_IXPCRP9SQLD_IXCBmP8SQLD_KEYP12SQLI_K EYDATAP9sqli_scanPi + 0x07e7 (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4D2A67BAB _Z14sqldIndexFetchP8SQLD_CCBP8SQLZ_RID + 0x013b (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4D2A656F8 _Z12sqldRowFetchP8sqeAgentP8SQLD_CCBmmPP10SQLD_VALUEP8SQLZ_RIDmP 12SQLD_ID_LISTP9SQLP_LSN8 + 0x0588 (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4D2BA8B51 _Z17sqlritaSimplePermP8sqlrr_cb + 0x00d1 (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4D2B9F6B7 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x01b7 (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4CFE1E803 _Z23sqlrr_execute_immediateP8sqlrr_cbi + 0x0553 (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4CFE0FD0F _Z14sqlrr_execimmdP14db2UCinterfaceP16db2UCprepareInfo + 0x012f (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4CEFB35A2 _Z19sqljs_ddm_excsqlimmP14db2UCinterfaceP13sqljDDMObject + 0x0552 (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4D2AC4C76 _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U Cinterface + 0x03f6 (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4CEF8ED2B _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x036b (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4CEF88BBD address: 0x00007FB4CEF88BBD ; dladdress: 0x00007FB4CBBC8000 ; offset in lib: 0x00000000033C0BBD ; (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4CEF87079 address: 0x00007FB4CEF87079 ; dladdress: 0x00007FB4CBBC8000 ; offset in lib: 0x00000000033BF079 ; (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4CEF840E9 address: 0x00007FB4CEF840E9 ; dladdress: 0x00007FB4CBBC8000 ; offset in lib: 0x00000000033BC0E9 ; (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4CEF83CDB _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0x00eb (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4CEC8A9D0 _ZN8sqeAgent6RunEDUEv + 0x0cb0 (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4D044FEF7 _ZN9sqzEDUObj9EDUDriverEv + 0x00f7 (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FB4CFC37741 sqloEDUEntry + 0x0301 (/db2/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00000038072079D1 address: 0x00000038072079D1 ; dladdress: 0x0000003807200000 ; offset in lib: 0x00000000000079D1 ; (/lib64/libpthread.so.0) 0x0000003806EE8B6D clone + 0x006d (/lib64/libc.so.6) </StackTrace> | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All users of column-organized tables * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 10.5.0.7. * **************************************************************** | |
Local-Fix: | |
Lösung | |
The problem is first fixed in DB2 version 10.5.0.7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 20.07.2015 20.01.2016 20.01.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |