|
Problem IT29447
|
Status: Closed |
CRASH IN SQLPISROSIMPACTLOCK()
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
Db2 can crash in function sqlpIsRosImpactLock(). This problem
only occurs on a HADR primary database.
The following is a sample stack dump of the trap:
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00002B8548A77CA6
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
0x0356 (/home/db2eba/sqllib/lib64/libdb2osse.so.1)
0x00002B8548A778EB ossDumpStackTraceV98 + 0x002b
(/home/db2eba/sqllib/lib64/libdb2osse.so.1)
0x00002B8548A73AD7 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00d7 (/home/db2eba/sqllib/lib64/libdb2osse.so.1)
0x00002B8540E99187 sqlo_trce + 0x03c7
(/home/db2eba/sqllib/lib64/libdb2e.so.1)
0x00002B85410051DB sqloEDUCodeTrapHandler + 0x03cb
(/home/db2eba/sqllib/lib64/libdb2e.so.1)
0x00002B85395FDC10 address: 0x00002B85395FDC10 ; dladdress:
0x00002B85395ED000 ; offset in lib: 0x0000000000010C10 ;
(/lib64/libpthread.so.0)
0x00002B854112A0C2 _Z19sqlpIsRosImpactLockPK8SQLP_LRB + 0x0002
(/home/db2eba/sqllib/lib64/libdb2e.so.1)
0x00002B854137D3C4
_Z15sqlpUpgradeLockP9sqeBsuEduP14SQLP_LOCK_INFO + 0x0ce4
(/home/db2eba/sqllib/lib64/libdb2e.so.1)
0x00002B853BEDF1ED _Z17sqldEscalateLocksP8sqeAgenti + 0x11fd
(/home/db2eba/sqllib/lib64/libdb2e.so.1)
0x00002B853BC72F5F
_Z13sqldLockTableP8sqeAgentP14SQLP_LOCK_INFOjti + 0x041f
(/home/db2eba/sqllib/lib64/libdb2e.so.1)
0x00002B853BC6F480
_Z19sqldLockTableFixTCBP8sqeAgenttthmiiimmiPciS1_iP14SQLP_LOCK_I
NFOPP8SQLD_TCBjj + 0x01c0
(/home/db2eba/sqllib/lib64/libdb2e.so.1)
0x00002B853BD1E814
_Z22sqldLockTableForInxBldP8sqeAgentP17SQLD_CREATEINX_CBPjtPP8SQ
LD_TCB + 0x0464 (/home/db2eba/sqllib/lib64/libdb2e.so.1)
0x00002B853BD2007E
_Z20sqldBeginIndexCreateP8sqeAgentP17SQLD_CREATEINX_CB + 0x046e
(/home/db2eba/sqllib/lib64/libdb2e.so.1)
0x00002B8541F33905
_Z24sqlrlRecreateIndexObjectP8sqlrr_cbP8sqlrg_idP17SQLD_CREATEIN
X_CBjtmP25sqlyk_keyXform_threadListP23SqlthJobProgressMonitor +
0x0065 (/home/db2eba/sqllib/lib64/libdb2e.so.1)
0x00002B8541F31798
_Z20sqlrlRecreateIndexesP8sqlrr_cbttP8sqlrg_idiPhiS3_ijPshP8Sqlt
hJobtP9SQLP_LSN8tP14SQLP_LOCK_INFOS3_ + 0x05a8
(/home/db2eba/sqllib/lib64/libdb2e.so.1)
0x00002B854248D070
_Z24sqluRecreateIndexObjectsP13SQLUCACB_TYPEP8sqeAgentb + 0x0400
(/home/db2eba/sqllib/lib64/libdb2e.so.1)
0x00002B854248F4F5
_Z23squInitInxObjForRebuildP13SQLUCACB_TYPEP18SQU_EDU_ESSENTIALS
+ 0x01e5 (/home/db2eba/sqllib/lib64/libdb2e.so.1)
0x00002B85424834B9 address: 0x00002B85424834B9 ; dladdress:
0x00002B8539B8F000 ; offset in lib: 0x00000000088F44B9 ;
(/home/db2eba/sqllib/lib64/libdb2e.so.1)
0x00002B85424816BC
_Z15squBuildIndexesP13SQLULACB_TYPEP13SQLUCACB_TYPEP18SQU_EDU_ES
SENTIALSihP17SQLU_FUNCPTR_LIST + 0x0acc
(/home/db2eba/sqllib/lib64/libdb2e.so.1)
0x00002B85424D97A7 _ZN11sqluCRidder4iRunEv + 0x0bd7
(/home/db2eba/sqllib/lib64/libdb2e.so.1)
0x00002B85424E5173 _Z17sqluLoadEDUDriverPhj + 0x0743
(/home/db2eba/sqllib/lib64/libdb2e.so.1)
0x00002B85410026BA sqloEDUEntry + 0x057a
(/home/db2eba/sqllib/lib64/libdb2e.so.1)
0x00002B85395F5724 address: 0x00002B85395F5724 ; dladdress:
0x00002B85395ED000 ; offset in lib: 0x0000000000008724 ;
(/lib64/libpthread.so.0)
0x00002B8549BF4E8D clone + 0x006d (/lib64/libc.so.6) |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All Platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 v11.1 Mod 5 Fixpack 5 or Later. *
**************************************************************** |
| Local Fix: |
Disable HADR feature. |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.06.2019
20.10.2019
20.10.2019 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
