|
Problem IC77128
|
Status: Closed |
DB2 INSTANCE CRASHED WITH SIGSEGV |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problem description: |
This problem occurs when a reorg recommended operation alter
column is performed on a partitioned table which has outstanding
asynchronized Index Cleaning (AIC) jobs. DB2 instance crashed
with the following in db2diag.log:
2011-05-09-00.15.50.106430-300 E8796E1368 LEVEL: Severe
PID : 21982 TID : 47712760678304PROC :
db2taskp (TWHPR1) 0
INSTANCE: twhpr00 NODE : 000 DB : TWHPR1
APPHDL : 0-20 APPID: *LOCAL.DB2.110509051557
AUTHID : TWHPR00
FUNCTION: DB2 UDB, SQO Memory Management,
sqloDiagnoseFreeBlockFailure, probe:999
MESSAGE : Memory validation failure, diagnostic file dumped.
DATA #1 : String, 28 bytes
Corrupt pool free tree node.
DATA #2 : File name, 24 bytes
p21982t0_diagnostics.mem
CALLSTCK:
[0] 0x00002B64F715C0DF
_ZN8SMemPool32diagnoseMemoryCorruptionAndCrashEmPKc + 0x1EF
[1] 0x00002B64F8466AE3
_ZN8SMemPool10MemTreeGetEmmPPvPP17SqloChunkSubgroupPP12SMemLostN
ode
+ 0x57B
[2] 0x00002B64F84672E6
_ZN8SMemPool19allocateMemoryBlockEmmmjmPPvPP17SqloChunkSubgroupP
P12SMemLostNodeP12SMemLogEvent
+ 0xCE
[3] 0x00002B64F84653BE sqlogmblkEx + 0x3DE
[4] 0x00002B64F6B9B6DA
_Z18sqliGetKeyWorkAreaP17SQLI_KEY_WORKAREAP10SQLI_IDXCBm + 0x10A
[5] 0x00002B64F7E2B7B3 _Z20sqliReorgCleanupKeysP7SQLI_CB +
0x2C3
[6] 0x00002B64F7E833E7
_Z21sqliAsyncIndexCleanupP20sqle_agent_privatecbP6AIC_CBm +
0x1B7
[7] 0x00002B64F826E971 aicTaskProcessor + 0x1B9
[8] 0x00002B64F8262A6D
_ZN8ABPAgent19taskProcessorDriverEP17ABPTaskProContext + 0x1ED
[9] 0x00002B64F8262EA9 _ZN8ABPAgent4mainEP17ABPTaskProContext
+ 0xC9 |
| Problem Summary: |
Users Effected:
All users
Problem Description:
DB2 INSTANCE CRASHED WITH SIGSEGV
Problem Summary:
This problem occurs when a reorg recommended operation alter
column is performed on a partitioned table which has outstanding
asynchronized Index Cleaning (AIC) jobs. DB2 instance crashed
with the following in db2diag.log:
2011-05-09-00.15.50.106430-300 E8796E1368 LEVEL: Severe
PID : 21982 TID : 47712760678304PROC :
db2taskp (TWHPR1) 0
INSTANCE: twhpr00 NODE : 000 DB : TWHPR1
APPHDL : 0-20 APPID: *LOCAL.DB2.110509051557
AUTHID : TWHPR00
FUNCTION: DB2 UDB, SQO Memory Management,
sqloDiagnoseFreeBlockFailure, probe:999
MESSAGE : Memory validation failure, diagnostic file dumped.
DATA #1 : String, 28 bytes
Corrupt pool free tree node.
DATA #2 : File name, 24 bytes
p21982t0_diagnostics.mem
CALLSTCK:
[0] 0x00002B64F715C0DF
_ZN8SMemPool32diagnoseMemoryCorruptionAndCrashEmPKc + 0x1EF
[1] 0x00002B64F8466AE3
_ZN8SMemPool10MemTreeGetEmmPPvPP17SqloChunkSubgroupPP12SMemLostN
ode
+ 0x57B
[2] 0x00002B64F84672E6
_ZN8SMemPool19allocateMemoryBlockEmmmjmPPvPP17SqloChunkSubgroupP
P12SMemLostNodeP12SMemLogEvent
+ 0xCE
[3] 0x00002B64F84653BE sqlogmblkEx + 0x3DE
[4] 0x00002B64F6B9B6DA
_Z18sqliGetKeyWorkAreaP17SQLI_KEY_WORKAREAP10SQLI_IDXCBm + 0x10A
[5] 0x00002B64F7E2B7B3 _Z20sqliReorgCleanupKeysP7SQLI_CB +
0x2C3
[6] 0x00002B64F7E833E7
_Z21sqliAsyncIndexCleanupP20sqle_agent_privatecbP6AIC_CBm +
0x1B7
[7] 0x00002B64F826E971 aicTaskProcessor + 0x1B9
[8] 0x00002B64F8262A6D
_ZN8ABPAgent19taskProcessorDriverEP17ABPTaskProContext + 0x1ED
[9] 0x00002B64F8262EA9 _ZN8ABPAgent4mainEP17ABPTaskProContext
+ 0xC9 |
| Local Fix: |
When encountering the problem, after crash, use the following
to by pass AIC in crash recovery:
1) set DB2_DISABLE_ABP=yes
2) drop index and recreate the index
3) unset DB2_DISABLE_ABP
Use the following to avoid the problem:
Check if there are outstanding index cleanup jobs from SYSTASKS
before ALTER a column. |
| available fix packs: |
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Solution |
defect wsdbu00844839
CSD First fixed in DB2 UDB Version 9, FixPak 11
module engn_sqx |
| Workaround |
Upgrade to DB2 Version 9, Fix Pack 11 |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC78409 IC78410
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.06.2011
07.12.2011
07.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.0.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.11
|
 |
