|
Problem IC68205
|
Status: Closed |
A SORT THAT ENCOUNTERS AN ERROR MIGHT ALSO SEGFAULT IN STMMSTOPSORTLISTMONITORONFAILURE() |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
A operation require SORT services that encounters an error (such
as disk full when the sort spills to a temp tablespace, or other
legitimate others) might segfault and bring down the instance.
You will likely see some kind of legitimate sort related error,
like so:
2010-01-01-19.45.03.278076+480 I45881212A2803 LEVEL: Severe
PID : 471692 TID : 14788 PROC : db2sysc
30
INSTANCE: db2inst1 NODE : 030 DB : SAMPLE
APPHDL : 0-4287 APPID:
132.228.87.19.40456.09122910292
AUTHID : DB2INST1
EDUID : 14788 EDUNAME: db2agntp (SAMPLE) 30
FUNCTION: DB2 UDB, sort/list services, sqlsusda, probe:50
MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
DIA8312C Disk was full.
DATA #1 : String, 14 bytes
SRT file error
DATA #2 : Hexdump, 296 bytes
0x0700000010605310 : 0000 0003 0000 0004 0700 0001 1DBC CC80
0x0700000010605320 : 0000 00AA 0000 0000 0700 0000 104F 7A20
0x0700000010605330 : 0001 0005 2F64 6232 6461 7461 2F64 6232
<...skipped...>
The stack trace will show stmmStopSortListMonitorOnFailure()
near the top of the stack:
<StackTrace>
@102@3@stmmStopSortListMonitorOnFailure__FP8sqeAgentP10SQLS_SLDE
Si
+ 0x460
.sqlrsinsr__FP8sqlrr_cbP10sqlri_iudo_fdprpro_clone_1685 + 0x3C
</StackTrace>
<StackTrace>
stmmStopSortListMonitorOnFailure__FP8sqeAgentP10SQLS_SLDE
sqlsinsr__FP8sqeAgentPcPUcP12sqlri_vectorPP10SQLD_VALUE + 0x44
sqlrsinsr__FP8sqlrr_cbP10sqlri_iudo + 0x44
sqlrisr2__FP8sqlrr_cb + 0xFC
sqlischf__FP7SQLI_CBUsUi + 0x184
sqliFirstTreeSearch__FP7SQLI_CBP11SQLI_SFGLOB + 0x4C
sqlirdk__FP8sqeAgentP10SQLI_IXPCRP9SQLD_IXCBUlP8SQLD_KEYP12SQLI_
sqldIndexFetch__FP8SQLD_CCBP8SQLZ_RID + 0x38
sqldIndexFetch__FP8SQLD_CCBP8SQLZ_RID@glueC17 + 0x70
sqldRowFetch__FP8sqeAgentP8SQLD_CCBUlT3PP10SQLD_VALUEP8SQLZ_RIDT
sqlritaSimplePerm__FP8sqlrr_cb - 0x4C8
sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm@glue10AA + 0x30
sqlrihsjn__FP8sqlrr_cb + 0xC
sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm@glue10AA + 0x3C
sqlrihsjn__FP8sqlrr_cb + 0xC
sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm@glue10AA + 0x3C
sqlrihsjn__FP8sqlrr_cb + 0xC
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm - 0x814
sqlrr_dss_router__FP8sqlrr_cb + 0x464
sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xF68
sqleSubRequestRouter__FP8sqeAgentPUiT2 + 0x7E8
sqleProcessSubRequest__FP8sqeAgent + 0x120
RunEDU__8sqeAgentFv + 0x300
EDUDriver__9sqzEDUObjFv + 0x94
sqloEDUEntry + 0x57C
</StackTrace> |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All. *
****************************************************************
* PROBLEM DESCRIPTION: *
* A operation require SORT services that encounters an error *
* (such as disk full when the sort spills to a temp *
* tablespace, or other legitimate others) might segfault and *
* bring down the instance. *
* *
* You will likely see some kind of legitimate sort related *
* error, like so: *
* *
* 2010-01-01-19.45.03.278076+480 I45881212A2803 LEVEL: *
* Severe *
* PID : 471692 TID : 14788 PROC : *
* db2sysc 30 *
* INSTANCE: db2inst1 NODE : 030 DB : *
* SAMPLE *
* APPHDL : 0-4287 APPID: *
* 132.228.87.19.40456.09122910292 *
* AUTHID : DB2INST1 *
* EDUID : 14788 EDUNAME: db2agntp (SAMPLE) 30 *
* FUNCTION: DB2 UDB, sort/list services, sqlsusda, probe:50 *
* MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full." *
* DIA8312C Disk was full. *
* DATA #1 : String, 14 bytes *
* SRT file error *
* DATA #2 : Hexdump, 296 bytes *
* 0x0700000010605310 : 0000 0003 0000 0004 0700 0001 1DBC CC80 *
* 0x0700000010605320 : 0000 00AA 0000 0000 0700 0000 104F 7A20 *
* 0x0700000010605330 : 0001 0005 2F64 6232 6461 7461 2F64 6232 *
* <...skipped...> *
* *
* The stack trace will show stmmStopSortListMonitorOnFailure() *
* near the top of the stack: *
* *
* *
* <StackTrace> *
* @102@3@stmmStopSortListMonitorOnFailure__FP8sqeAgentP10SQLS_SL
* + 0x460 *
* .sqlrsinsr__FP8sqlrr_cbP10sqlri_iudo_fdprpro_clone_1685 + *
* 0x3C *
* </StackTrace> *
* *
* <StackTrace> *
* stmmStopSortListMonitorOnFailure__FP8sqeAgentP10SQLS_SLDE *
* sqlsinsr__FP8sqeAgentPcPUcP12sqlri_vectorPP10SQLD_VALUE + *
* 0x44 *
* sqlrsinsr__FP8sqlrr_cbP10sqlri_iudo + 0x44 *
* sqlrisr2__FP8sqlrr_cb + 0xFC *
* sqlischf__FP7SQLI_CBUsUi + 0x184 *
* sqliFirstTreeSearch__FP7SQLI_CBP11SQLI_SFGLOB + 0x4C *
* sqlirdk__FP8sqeAgentP10SQLI_IXPCRP9SQLD_IXCBUlP8SQLD_KEYP12SQL
* sqldIndexFetch__FP8SQLD_CCBP8SQLZ_RID + 0x38 *
* sqldIndexFetch__FP8SQLD_CCBP8SQLZ_RID@glueC17 + 0x70 *
* sqldRowFetch__FP8sqeAgentP8SQLD_CCBUlT3PP10SQLD_VALUEP8SQLZ_RI
* sqlritaSimplePerm__FP8sqlrr_cb - 0x4C8 *
* sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm@glue10AA + 0x30 *
* sqlrihsjn__FP8sqlrr_cb + 0xC *
* sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm@glue10AA + 0x3C *
* sqlrihsjn__FP8sqlrr_cb + 0xC *
* sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm@glue10AA + 0x3C *
* sqlrihsjn__FP8sqlrr_cb + 0xC *
* sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm - 0x814 *
* sqlrr_dss_router__FP8sqlrr_cb + 0x464 *
* sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xF68 *
* sqleSubRequestRouter__FP8sqeAgentPUiT2 + 0x7E8 *
* sqleProcessSubRequest__FP8sqeAgent + 0x120 *
* RunEDU__8sqeAgentFv + 0x300 *
* EDUDriver__9sqzEDUObjFv + 0x94 *
* sqloEDUEntry + 0x57C *
* </StackTrace> *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v97fp3 or later. *
**************************************************************** |
| Local Fix: |
|
| 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 |
This problem is first fixed in version 9.7 fixpack 3. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.04.2010
24.09.2010
24.09.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
