In XA connection, declare global temporary table WITH REPLACE
option might cause double free as below:
2010-10-18-23.47.52.225880+120 I1182384A1848 LEVEL: Severe
PID : 1421654 TID : 25962 PROC : db2sysc
0
INSTANCE: db2inst NODE : 000 DB : SAMPLE
APPHDL : 0-262 APPID:
192.168.1.1.4032.1010182147
AUTHID : DB2INST
EDUID : 25962 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, SQO Memory Management,
sqloDiagnoseFreeBlockFailure, probe:10
MESSAGE : Possible memory corruption detected.
DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes
0x820F0002
DATA #2 : Corrupt block address, PD_TYPE_CORRUPT_BLK_PTR, 8
bytes
0x07000000e0208020
DATA #3 : Block header, PD_TYPE_BLK_HEADER, 24 bytes
0x07000000E0208008 : FAB0 7000 000E 0200 0000 0000 0000 0000
..p.............
0x07000000E0208018 : 0700 0000 E020 80A8
..... ..
DATA #4 : Data header, PD_TYPE_BLK_DATA_HEAD, 48 bytes
0x07000000E0208020 : 0000 0000 0000 0040 0000 0000 0000 0000
.......@........
0x07000000E0208030 : 0000 0010 0000 0D00 0000 0000 0000 0000
................
0x07000000E0208040 : 0100 0000 0000 0000 DB2C AFE8 0000 0038
.........,.....8
CALLSTCK:
[0] 0x0900000012970948 pdLog + 0xD4
[1] 0x090000000F360D64
@79@sqloDiagnoseFreeBlockFailure__FP8SMemFBlk + 0x150
[2] 0x0900000012AC53FC sqlofmblkEx + 0x90
[3] 0x090000000EB15B78
sqlrl_userTempDrop__FP8sqlrr_cbP19sqlrl_userTempEntryPUciT3T4UsT
7T4
+ 0xC30
[4] 0x0900000010D7F0B0
sqlrl_userTempDropAll__FP8sqlrr_cbP16sqlr_usertemp_cb + 0x1C4
[5] 0x0900000010D7E8A8
sqlrl_userTempDropAll__FP8sqlrr_cbP16sqlr_usertemp_cb@glueB8A +
0x74
[6] 0x09000000105F9AF8
sqlrr_cleanup_tran_before_DPS__FP8sqlrr_cbiN62PiT9b + 0x200
[7] 0x090000001270EA94
sqlrxend__FP8sqlrr_cbP15SQLXA_CALL_INFOi + 0x638
[8] 0x0900000012727868 sqlrr_xend__FP14db2UCinterface + 0x1D0
[9] 0x0900000010AC5D54 sqljsSyncEnd__FP14db2UCinterface +
0x5F8
2010-10-18-23.47.52.234609+120 I1184233A461 LEVEL: Severe
PID : 1421654 TID : 25962 PROC : db2sysc
0
INSTANCE: db2inst NODE : 000 DB : SAMPLE
APPHDL : 0-262 APPID:
192.168.1.1.4032.1010182147
AUTHID : DB2INST
EDUID : 25962 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, SQO Memory Management,
sqloDiagnoseFreeBlockFailure, probe:30
DATA #1 : String, 12 bytes
Double free.
This problem happens only in v9.7 fp3. |
****************************************************************
* USERS AFFECTED: *
* Users who use DGTT WITH REPLACE on XA connections. *
****************************************************************
* PROBLEM DESCRIPTION: *
* n XA connection, declare global temporary table WITH REPLACE *
* option might cause double free as below: *
* *
* 2010-10-18-23.47.52.225880+120 I1182384A1848 LEVEL: *
* Severe *
* PID : 1421654 TID : 25962 PROC : *
* db2sysc *
* 0 *
* INSTANCE: db2inst NODE : 000 DB : *
* SAMPLE *
* APPHDL : 0-262 APPID: *
* 192.168.1.1.4032.1010182147 *
* AUTHID : DB2INST *
* EDUID : 25962 EDUNAME: db2agent (SAMPLE) 0 *
* FUNCTION: DB2 UDB, SQO Memory Management, *
* sqloDiagnoseFreeBlockFailure, probe:10 *
* MESSAGE : Possible memory corruption detected. *
* DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes *
* 0x820F0002 *
* DATA #2 : Corrupt block address, PD_TYPE_CORRUPT_BLK_PTR, 8 *
* bytes *
* 0x07000000e0208020 *
* DATA #3 : Block header, PD_TYPE_BLK_HEADER, 24 bytes *
* 0x07000000E0208008 : FAB0 7000 000E 0200 0000 0000 0000 0000 *
* ..p............. *
* 0x07000000E0208018 : 0700 0000 E020 80A8 *
* ..... .. *
* DATA #4 : Data header, PD_TYPE_BLK_DATA_HEAD, 48 bytes *
* 0x07000000E0208020 : 0000 0000 0000 0040 0000 0000 0000 0000 *
* .......@........ *
* 0x07000000E0208030 : 0000 0010 0000 0D00 0000 0000 0000 0000 *
* ................ *
* 0x07000000E0208040 : 0100 0000 0000 0000 DB2C AFE8 0000 0038 *
* .........,.....8 *
* CALLSTCK: *
* [0] 0x0900000012970948 pdLog + 0xD4 *
* [1] 0x090000000F360D64 *
* @79@sqloDiagnoseFreeBlockFailure__FP8SMemFBlk + 0x150 *
* [2] 0x0900000012AC53FC sqlofmblkEx + 0x90 *
* [3] 0x090000000EB15B78 *
* sqlrl_userTempDrop__FP8sqlrr_cbP19sqlrl_userTempEntryPUciT3T *
* 4UsT *
* 7T4 *
* + 0xC30 *
* [4] 0x0900000010D7F0B0 *
* sqlrl_userTempDropAll__FP8sqlrr_cbP16sqlr_usertemp_cb + *
* 0x1C4 *
* [5] 0x0900000010D7E8A8 *
* sqlrl_userTempDropAll__FP8sqlrr_cbP16sqlr_usertemp_cb@glueB8 *
* A + *
* 0x74 *
* [6] 0x09000000105F9AF8 *
* sqlrr_cleanup_tran_before_DPS__FP8sqlrr_cbiN62PiT9b + 0x200 *
* [7] 0x090000001270EA94 *
* sqlrxend__FP8sqlrr_cbP15SQLXA_CALL_INFOi + 0x638 *
* [8] 0x0900000012727868 sqlrr_xend__FP14db2UCinterface + *
* 0x1D0 *
* [9] 0x0900000010AC5D54 sqljsSyncEnd__FP14db2UCinterface + *
* 0x5F8 *
* *
* 2010-10-18-23.47.52.234609+120 I1184233A461 LEVEL: *
* Severe *
* PID : 1421654 TID : 25962 PROC : *
* db2sysc *
* 0 *
* INSTANCE: db2inst NODE : 000 DB : *
* SAMPLE *
* APPHDL : 0-262 APPID: *
* 192.168.1.1.4032.1010182147 *
* AUTHID : DB2INST *
* EDUID : 25962 EDUNAME: db2agent (SAMPLE) 0 *
* FUNCTION: DB2 UDB, SQO Memory Management, *
* sqloDiagnoseFreeBlockFailure, probe:30 *
* DATA #1 : String, 12 bytes *
* Double free. *
* *
* This problem happens only in v9.7 fp3/3a. *
****************************************************************
* RECOMMENDATION: *
* Please upgrade to V9.7 FixPack 4 or later. *
**************************************************************** |
