|
Problem IT03443
|
Status: Closed |
ENABLE EXTENDED INDICATOR AND REOPT ALWAYS MAY CAUSE INSTANCE CRASH |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
When extended indicator and REOPT ALWAYS are enabled, db2
instance may trap in stacks as below:
StackTrace1:
0x00002ABAD80BE625
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
0x0385
(/home/db2sdin1/sqllib/lib64/libdb2osse.so.1)
0x00002ABAD80BE22C ossDumpStackTraceV98 + 0x002c
(/home/db2sdin1/sqllib/lib64/libdb2osse.so.1)
0x00002ABAD80B932D _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00fd
(/home/db2sdin1/sqllib/lib64/libdb2osse.so.1)
0x00002ABAD270C5CF sqlo_trce + 0x03ef
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002ABAD2761BFF sqloEDUCodeTrapHandler + 0x025f
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002ABACB5777C0 address: 0x00002ABACB5777C0 ; dladdress:
0x00002ABACB568000 ; offset in lib: 0x000000000000F7C0 ;
(/lib64/libpthread.so.0)
0x00002ABAD05E32CE
_Z14sqlra_load_varP8sqlrr_cbP16sqlra_cached_var + 0x024e
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002ABAD062C075 _Z13sqlra_get_varP8sqlrr_cbiibPbS1_ + 0x0be5
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002ABAD37473D3 _Z29sqlrr_process_execute_requestP8sqlrr_cbib
+ 0x0293
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002ABAD3745C7B _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo
+ 0x026b
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002ABAD3695E26
_Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject +
0x04c6
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002ABAD369362E
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
Cinterface + 0x007e
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002ABAD3693D77
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x0377
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002ABACF83D8E4 address: 0x00002ABACF83D8E4 ; dladdress:
0x00002ABACB788000 ; offset in lib: 0x00000000040B58E4 ;
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002ABACF83BEC9 address: 0x00002ABACF83BEC9 ; dladdress:
0x00002ABACB788000 ; offset in lib: 0x00000000040B3EC9 ;
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002ABACF838F69 address: 0x00002ABACF838F69 ; dladdress:
0x00002ABACB788000 ; offset in lib: 0x00000000040B0F69 ;
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002ABACF838B5B _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T +
0x00eb
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002ABACF55EE91 _ZN8sqeAgent6RunEDUEv + 0x08b1
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002ABAD0B00CA4 _ZN9sqzEDUObj9EDUDriverEv + 0x00f4
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002ABAD0354617 sqloEDUEntry + 0x02f7
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002ABACB56F7B6 address: 0x00002ABACB56F7B6 ; dladdress:
0x00002ABACB568000 ; offset in lib: 0x00000000000077B6 ;
(/lib64/libpthread.so.0)
0x00002ABAD8E579CD clone + 0x006d
(/lib64/libc.so.6)
StackTrace2:
0x00002B3C61456625
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
0x0385
(/home/db2sdin1/sqllib/lib64/libdb2osse.so.1)
0x00002B3C6145622C ossDumpStackTraceV98 + 0x002c
(/home/db2sdin1/sqllib/lib64/libdb2osse.so.1)
0x00002B3C6145132D _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00fd
(/home/db2sdin1/sqllib/lib64/libdb2osse.so.1)
0x00002B3C5BAA45CF sqlo_trce + 0x03ef
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002B3C5BAF9BFF sqloEDUCodeTrapHandler + 0x025f
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002B3C5490F7C0 address: 0x00002B3C5490F7C0 ; dladdress:
0x00002B3C54900000 ; offset in lib: 0x000000000000F7C0 ;
(/lib64/libpthread.so.0)
0x00002B3C5BED479F
_ZN32sqlraExtendedIndicatorDescriptor13selectiveCopyEPS_P8sqlrr_
cb + 0x002f
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002B3C5997B34A
_Z14sqlra_load_varP8sqlrr_cbP16sqlra_cached_var + 0x02ca
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002B3C599C4075 _Z13sqlra_get_varP8sqlrr_cbiibPbS1_ + 0x0be5
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002B3C5CADF3D3 _Z29sqlrr_process_execute_requestP8sqlrr_cbib
+ 0x0293
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002B3C5CADDC7B _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo
+ 0x026b
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002B3C5CA2DE26
_Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject +
0x04c6
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002B3C5CA2B62E
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
Cinterface + 0x007e
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002B3C5CA2BD77
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x0377
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002B3C58BD58E4 address: 0x00002B3C58BD58E4 ; dladdress:
0x00002B3C54B20000 ; offset in lib: 0x00000000040B58E4 ;
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002B3C58BD3EC9 address: 0x00002B3C58BD3EC9 ; dladdress:
0x00002B3C54B20000 ; offset in lib: 0x00000000040B3EC9 ;
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002B3C58BD0F69 address: 0x00002B3C58BD0F69 ; dladdress:
0x00002B3C54B20000 ; offset in lib: 0x00000000040B0F69 ;
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002B3C58BD0B5B _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T +
0x00eb
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002B3C588F6E91 _ZN8sqeAgent6RunEDUEv + 0x08b1
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002B3C59E98CA4 _ZN9sqzEDUObj9EDUDriverEv + 0x00f4
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002B3C596EC617 sqloEDUEntry + 0x02f7
(/home/db2sdin1/sqllib/lib64/libdb2e.so.1)
0x00002B3C549077B6 address: 0x00002B3C549077B6 ; dladdress:
0x00002B3C54900000 ; offset in lib: 0x00000000000077B6 ;
(/lib64/libpthread.so.0)
0x00002B3C621EF9CD clone + 0x006d
(/lib64/libc.so.6)
In order to hit the trap, both extended indicator and REOPT
ALWAYS need to be enabled. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* When extended indicator and REOPT ALWAYS are enabled. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V10.1 FP5 or later version. *
**************************************************************** |
| Local Fix: |
1) disable extended Indicator, an example in JCC application:
String url = "jdbc:default:connection";
Properties prop = new Properties();
prop.put("enableExtendedIndicators", "2");
try {
con = DriverManager.getConnection(url, prop);
...
or
2) disable REOPT ALWAYS, use either NONE or ONCE instead. |
| Solution |
This problem is firstly fixed on V10.1 FP5. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.07.2014
14.07.2015
14.07.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.5
|
 |
