|
Problem IC67240
|
Status: Closed |
POSSIBLE HANG DUE TO INFINITE LOOP IN SQLMON_CONN::LOOKUP_STMT() |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
There is a possible hang situation due to one agent looping in
sqlmon_conn::lookup_stmt() holding the
SQLO_LT_sqlmon_conn__rds_latch.
Here is a typical stack:
EDU name : db2agent (XXXXXX) 0
<StackTrace>
-------Frame------ ------Function + Offset------
0x09000000065C8784
lookup_stmt__11sqlmon_connCFPCUcN21CUsN24CUiT4CbT7 + 0x11C
0x09000000065D2E80
stmt_start__11sqlmon_connFRC8sqeAgentCUiPCUcN23CUsN26T2T6N22CiT1
3_RP11sqlmon_stmtRP10sqlmon_uow + 0x474
0x090000000688A27C
agent_stmt_start__10sqlmon_acbFCUiPCUcN22CUsT1N35N21CiP8sqlrr_cb
+ 0x1394
0x09000000068909F0
agent_stmt_start__10sqlmon_acbFCUiPCUcN22CUsT1N35N21CiP8sqlrr_cb
@glue921 + 0xD0
0x0900000004E072CC
sqlrr_sql_request_pre__FP14db2UCinterfaceUiiP16db2UCprepareInfoP
15db2UCCursorInfo + 0x7C
0x0900000004E0359C sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo
- 0x148
0x0900000007E481E4 executeSection__10pvmPackageFP5sqlcaUi +
0x870
0x0900000007E449BC executeQuery__3PVMFUi + 0xEC
0x0900000007E4421C run__3PVMFv + 0x9BC
0x0900000007E42508 pvm_entry + 0x314
0x0900000004E232F4 sqloInvokeFnArgs + 0xC0
0x0900000004FC2DB0 sqloInvokeFnArgs@glue5F9 + 0x74
0x0900000005129178
sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf +
0xD14
0x0900000004F1BE04 sqlriInvokeInvoker__FP10sqlri_ufob + 0x90
0x09000000052C2EFC sqlricall__FP8sqlrr_cb + 0x7C
0x0900000004DCAA40 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm -
0x788
0x0900000004DF8ACC sqlrr_process_execute_request__FP8sqlrr_cbi +
0x344
0x0900000004E03744 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo
+ 0x60
0x0900000007E481E4 executeSection__10pvmPackageFP5sqlcaUi +
0x870
0x0900000007E449BC executeQuery__3PVMFUi + 0xEC
0x0900000007E4421C run__3PVMFv + 0x9BC
0x0900000007E42508 pvm_entry + 0x314
0x0900000004E232F4 sqloInvokeFnArgs + 0xC0
0x0900000004FC2DB0 sqloInvokeFnArgs@glue5F9 + 0x74
0x0900000005129178
sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf +
0xD14
0x0900000004F1BE04 sqlriInvokeInvoker__FP10sqlri_ufob + 0x90
0x09000000052C2EFC sqlricall__FP8sqlrr_cb + 0x7C
0x0900000004DCAA40 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm -
0x788
0x0900000004DF8ACC sqlrr_process_execute_request__FP8sqlrr_cbi +
0x344
0x0900000004E03744 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo
+ 0x60
0x0900000004E086A4
sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x8B0
0x0900000004E08FAC
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x78
0x0900000004E08DC0
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface - 0x124
0x0900000004E0A3F0 @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
+ 0x224
0x0900000004ED3EF8
@63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x98
0x0900000004ED3C04
@63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0xE0
0x0900000004ED398C sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
0x13C
0x0900000004EB0850 RunEDU__8sqeAgentFv + 0x11C
0x0900000004EB05B0 EDUDriver__9sqzEDUObjFv + 0x94
0x0900000004EAB2EC sqloEDUEntry + 0x54C
</StackTrace>
<LatchInformation>
Holding Latch type: (SQLO_LT_SQLP_TENTRY__applLatch) - Address:
(700000dfb783e08), Line: 709, File: sqlpxreg.C
Holding Latch type: (SQLO_LT_sqlmon_conn__rds_latch) - Address:
(7800000020f7978), Line: 368, File: sqlmacb.C
</LatchInformation> |
| Problem Summary: |
USERS AFFECTED: All
PROBLEM DESCRIPTION:
see ERROR DESCRIPTION
PROBLEM SUMMARY:
see ERROR DESCRIPTION |
| Local Fix: |
n/a |
| available fix packs: |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
The complete fix for this problem first appears in DB2 UDB
Version 9.7 FixPak 3. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.03.2010
24.09.2010
24.09.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
