|
Problem IT02027
|
Status: Closed |
DB2 MIGHT CRASH IN SQLBUNCHAINBPDFROMBUCKET WITH SEGV |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
DB2 might crash in sqloPGRPRegisterOneCrash wit a segmentation
violation. The symptoms in db2diag.log will be similar to the
following:
2014-04-30-01.13.08.398417+120 I5598391E2676 LEVEL:
Event
PID : 4909 TID : 46958177675584 PROC :
db2sysc
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-1104 APPID: *LOCAL.DB2.140429224502
AUTHID : db2inst1 HOSTNAME: testmachine
EDUID : 4017 EDUNAME: db2stmm (SAMPLE)
FUNCTION: DB2 UDB, oper system services,
sqloPGRPRegisterOneCrash, probe:2154
MESSAGE : lastCrashCount
DATA #1 : unsigned integer, 8 bytes
0
DATA #2 : String, 10 bytes
inRecovery
DATA #3 : Boolean, 1 bytes
false
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x00002AB539E565FE pdLog + 0x38E
[1] 0x00002AB53C2B325D sqloPGRPRegisterOneCrash + 0x17D
[2] 0x00002AB53C2F9B11 sqloEDUCodeTrapHandler + 0x871
[3] 0x00002AB538DFEE00 /lib64/libpthread.so.0 + 0xDE00
[4] 0x00002AB53CFADCE6
_Z24sqlbUnchainBPDFromBucketP13SQLB_BPD_BASEiP15SQLB_BufferPoolP
12SQLB_GLOBALS + 0x76
[5] 0x00002AB53B6A17AE
_Z27sqlbMovePinnedPageToNewSlotjP8SQLB_BPDP15SQLB_BufferPoolS0_P
22SQLB_HASH_BUCKET_GROUPP12SQLB_GLOBALS + 0x42E
[6] 0x00002AB539F3AEBD
_Z33sqlbRemInvalidPagesFromBufferPoolP15SQLB_BufferPooljjjjP12SQ
LB_GLOBALS + 0xCDD
[7] 0x00002AB539F36424
_Z26sqlbDecreaseBufferpoolSizeP15SQLB_BufferPoolP21SQLB_BP_UC_AL
TER_INFOP12SQLB_GLOBALS + 0x304
[8] 0x00002AB539F35FC9
_Z20sqlbResizeBufferPoolP15SQLB_BufferPoolP21SQLB_BP_UC_ALTER_IN
FOP12SQLB_GLOBALS + 0x89
[9] 0x00002AB53B698C08
_Z28sqlbAlterAutomaticBufferPoolPcjiP8sqeAgent + 0xB38
[10] 0x00002AB53C88968C
_Z24sqlrlStmmAlterBufferPoolP8sqeAgentPciiP14db2UCinterfaceP5sql
ca + 0x31C
[11] 0x00002AB53CE4C128 _Z19stmmAlterBufferPoolP8sqeAgentPcii
+ 0x78
[12]
0x00002AB53B13E3AF_Z16stmmResizeRecordP21stmmCostBenefitRecordP1
6sqeLocalDatabase + 0x1AF
[13] 0x00002AB53B13E171
_Z36stmmDecreaseEntriesAndRemoveFromListP16sqeLocalDatabasePP21s
tmmCostBenefitRecordPj + 0xE1
[14] 0x00002AB53B13DF8A
_Z34stmmResizeEntriesAndRemoveFromListPP21stmmCostBenefitRecordP
16sqeLocalDatabase + 0x7A
[15] 0x00002AB53B154D8C
_Z14stmmTuneMemoryPP21stmmCostBenefitRecordP16sqeLocalDatabase +
0x6C
[16] 0x00002AB53B134E8B stmmMemoryTunerMain + 0x4CB
[17] 0x00002AB53B133C1E stmmMemoryTunerGlobalStartHandling +
0x7E
[18] 0x00002AB53A12B243
_Z26sqleIndCoordProcessRequestP8sqeAgent + 0x513
[19] 0x00002AB53A13C961 _ZN8sqeAgent6RunEDUEv + 0x161
[20] 0x00002AB53B122213 _ZN9sqzEDUObj9EDUDriverEv + 0xF3
[21] 0x00002AB53B122119 _Z10sqlzRunEDUPcj + 0x9
[22] 0x00002AB53ABAEFC1 sqloEDUEntry + 0x2A1
[23] 0x00002AB538DF72A3 /lib64/libpthread.so.0 + 0x62A3 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to version 10.1 fix pack 5 *
**************************************************************** |
| Local Fix: |
|
| Solution |
First fixed in version 10.1 fix pack 5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.05.2014
13.07.2015
13.07.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.5
|
 |
