|
Problem IT10184
|
Status: Closed |
UPDATE TO COLUMNAR TABLE CAN SOMETIMES LEAD TO DB2 CRASH |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* All users of column-organized tables *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 10.5.0.7. *
**************************************************************** |
| Local Fix: |
|
| Solution |
The problem is first fixed in DB2 version 10.5.0.7. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.07.2015
20.01.2016
20.01.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
