|
Problem IT19553
|
Status: Closed |
DB2 OPERATIONS MAY HANG AND NOT RESPOND TO INTERRUPTS WHILE EXECUTING QUERIES AGAINST COLUMNAR TABLES
|
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
In some rare conditions, db2 may hang or not respond to
interrupts while executing queries against column organized
tables.
The stack dump of the agent executing the query may look as
follows:
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00007FFFEC90D205
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
0x0385
(/UDB/nyf37pi8/home/sqllib/lib64/libdb2osse.so.1)
0x00007FFFEC90CE0C ossDumpStackTraceV98 + 0x002c
(/UDB/nyf37pi8/home/sqllib/lib64/libdb2osse.so.1)
0x00007FFFEC907F0D _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00fd
(/UDB/nyf37pi8/home/sqllib/lib64/libdb2osse.so.1)
0x00007FFFF2DAC194 sqlo_trce + 0x0404
(/UDB/nyf37pi8/home/sqllib/lib64/libdb2e.so.1)
0x00007FFFF2E023FE sqloDumpDiagInfoHandler + 0x010e
(/UDB/nyf37pi8/home/sqllib/lib64/libdb2e.so.1)
0x00000038B8A0F710 address: 0x00000038B8A0F710 ; dladdress:
0x00000038B8A00000 ; offset in lib: 0x000000000000F710 ;
(/lib64/libpthread.so.0)
0x00000038B8A0EF3D __nanosleep + 0x002d
(/lib64/libpthread.so.0)
0x00007FFFF0E0471D sqloSpinLockConflict + 0x043d
(/UDB/nyf37pi8/home/sqllib/lib64/libdb2e.so.1)
0x00007FFFF16E637C
_Z34stmmRegisterReserveSharedSortSpaceP8sqeAgent16SQLS_MEMCONSUM
ERjjjjjjPjPmPP19STMM_OpAllocMonitor + 0x076c
(/UDB/nyf37pi8/home/sqllib/lib64/libdb2e.so.1)
0x00007FFFF16E4F7E
_Z37stmmReserveUnthrottledSharedSortSpaceP8sqeAgent16SQLS_MEMCON
SUMERjjjjjjPP19STMM_OpAllocMonitor + 0x0a6e
(/UDB/nyf37pi8/home/sqllib/lib64/libdb2e.so.1)
0x00007FFFF14539EC
_Z26sqlsReserveSharedSortSpaceP8sqeAgent16SQLS_MEMCONSUMERjjjjbP
jPP19STMM_OpAllocMonitor + 0x020c
(/UDB/nyf37pi8/home/sqllib/lib64/libdb2e.so.1)
0x00007FFFF122CD91
_Z21sqlriReserveSortSpaceP8sqlrr_cbjm16SQLS_MEMCONSUMERjjljlPjlP
lPP19STMM_OpAllocMonitor + 0x00a1
(/UDB/nyf37pi8/home/sqllib/lib64/libdb2e.so.1)
0x00007FFFEF76A075
_ZN7ibm_cde5query21WorkUnitVectorMemInfo28increaseWorkUnitVector
MemResEmm + 0x0215
(/UDB/nyf37pi8/home/sqllib/lib64/libdb2e.so.1)
0x00007FFFEF768D2D
_ZN7ibm_cde5query21WorkUnitVectorMemInfo24checkWorkUnitVecMemUsa
geEv + 0x0c2d
(/UDB/nyf37pi8/home/sqllib/lib64/libdb2e.so.1)
0x00007FFFF3D16613
_ZN7ibm_cde5query9Evaluator8evaluateEbbRNS1_21EvaluatorRestartSt
ateEPNS0_19OptPredicateTrackerE + 0x10d3
(/UDB/nyf37pi8/home/sqllib/lib64/libdb2e.so.1)
0x00007FFFEEBE521C
_ZN7ibm_cde5query17EvaluationRoutine8evaluateEjP15sql_static_dat
a + 0x023c
(/UDB/nyf37pi8/home/sqllib/lib64/libdb2e.so.1)
:
In db2pd -latches output, we can see agent waiting for the latch
SQLO_LT_stmmSort__allocationMonitorLatch with no holder agent. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All Users on DB2 V105 FP6 and earlier fixpacks *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v105 FP7 or later *
**************************************************************** |
| Local Fix: |
No Local Fix |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 06.03.2017
06.03.2017
06.03.2017 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
