|
Problem IC79235
|
Status: Closed |
ENGINE TRAPS DUE TO SEGV HIT IN SQLEREMOVEENTRYFROMRESYNC() |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Engines traps with the following stack showing
sqleRemoveEntryFromResync() hitting SEGV (Signal #11):
EDU name : db2agent (SAMPLE) 0
EDU ID : 109928
Signal #11
......
0x0900000005A1617C
sqleRemoveEntryFromResync__FP11sqlxa_xid_t14sqleResyncTypePc +
0x148
0x0900000005A147A8
sqljsSyncctlReply__FP13sqljsDrdaAsCbP14db2UCinterfacei + 0x1D04
0x09000000051BDC10
.sqljsDrdaAsCBCompletion.fdpr.clone.252__FP14db2UCinterfacei +
0x32C
0x09000000051BD1FC sqlrr_rds_common_post__FP14db2UCinterfaceiT2l
+ 0x13BC
0x0900000006FECEA0 sqlrr_xcommit__FP14db2UCinterface + 0x1F48
0x0900000005B3ADF4 sqljsSyncCommitted__FP14db2UCinterface +
0x4D0
0x0900000005B88530
sqljs_ddm_syncctl__FP14db2UCinterfaceP13sqljDDMObject + 0x3C8
0x0900000004B36F34
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface
+ 0x178
0x09000000051A15E4
.sqljsParse.fdpr.clone.168__FP13sqljsDrdaAsCbP14db2UCinterfaceP8
sqeAgentb
+ 0x408
0x090000000519C600 @64@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
+ 0xC50
0x0900000005006BAC
@64@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
0x09000000056F3754
@64@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x178
0x0900000005006444 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
0x1F8
0x09000000050658E8 RunEDU__8sqeAgentFv + 0x7C
0x0900000005060DB4 EDUDriver__9sqzEDUObjFv + 0xD8
0x0900000005073EEC sqloEDUEntry + 0x264
Before the trap, db2diag.log may have following message
indicating Resync List has been full:
2011-09-23-15.08.39.785187-420 E1503306A441 LEVEL: Severe
PID : 758298 TID : 110442 PROC : db2sysc
0
INSTANCE: test NODE : 000 DB : SAMPLE
APPHDL : 0-40210 APPID:
USPCCW01.INA400.C86AD450D8A8
AUTHID : user
EDUID : 110442 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, base sys utilities, sqleAddEntryToResync,
probe:20
MESSAGE : Out of ResyncEntries! |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 LUW Version 9.7 Fix Pack 6 *
**************************************************************** |
| Local Fix: |
A larger Resync List by increasing NUMDB in DBM CFG may reduce
risk of hitting this APAR |
| available fix packs: |
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 |
Problem was first fixed in Version 9.7 Fix Pack 6 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.10.2011
11.06.2012
11.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
