|
Problem IC77070
|
Status: Closed |
ASSIGNING STRING DATA TYPES TO LARGE OBJECT DATA TYPES IN AN INLINED SQL FUNCTION MAY ABEND DB2 INSTANCE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Assignment operations from values of string data types to
variables of large object data types in an inlined SQL function
may abend DB2 instance.
The problem may produce the following (call stack / error
message) in db2diag.log
2011-05-17-10.13.30.231132+570 E9427244E1456 LEVEL: Severe
PID : 5681 TID : 47343927814464PROC :
db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-32 APPID:
172.30.0.211.64932.110517004257
AUTHID : DB2INST
EDUID : 67 EDUNAME: db2agent (SAMPLE)
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, 39 bytes
5681.47343927814464.mem_diagnostics.txt
CALLSTCK:
[0] 0x00002B0F116F1F52 pdLog + 0x398
[1] 0x00002B0F131DA847
_ZN13SQLO_MEM_POOL32diagnoseMemoryCorruptionAndCrashEmPKc +
0x241
[2] 0x00002B0F13F19C0B
_ZN13SQLO_MEM_POOL10MemTreePutEP8SMemNodemP17SqloChunkSubgroup +
0x4AB
[3] 0x00002B0F13F18F5A sqlofmblkEx + 0x25A
[4] 0x00002B0F11DF0F4E _Z8sqlristmP8sqlrr_cbP9sqlri_shdi +
0x84
[5] 0x00002B0F11D5C958
_Z32sqlra_sqlW_mem_free_sibling_listP8sqlrr_cbP23sqlra_workspace
_siblingPm
+ 0x17E8
[6] 0x00002B0F11D5AEA1
_Z24sqlra_sqlW_mem_freespaceP8sqlrr_cbmPmi + 0x3B5
[7] 0x00002B0F11D57093
_Z29sqlra_sqlW_get_static_sectionP8sqlrr_cbi + 0x10E9
[8] 0x00002B0F13F42BEF
_Z17sqlra_get_sectionP8sqlrr_cbPhsS1_sS1_tmP16db2UCprepareInfoP1
5db2UCCursorInfo
+ 0x61F
[9] 0x00002B0F13F34C45
_Z21sqlrr_sql_request_preP14db2UCinterfacejiP16db2UCprepareInfoP
15db2UCCursorInfo
+ 0x4DB |
| Problem Summary: |
Assignment operations from values of string data types to
variables of large object data types in an inlined SQL function
may abend DB2 instance.
The problem may produce the following (call stack / error
message) in db2diag.log
2011-05-17-10.13.30.231132+570 E9427244E1456 LEVEL: Severe
PID : 5681 TID : 47343927814464PROC :
db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-32 APPID:
172.30.0.211.64932.110517004257
AUTHID : DB2INST
EDUID : 67 EDUNAME: db2agent (SAMPLE)
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, 39 bytes
5681.47343927814464.mem_diagnostics.txt
CALLSTCK:
[0] 0x00002B0F116F1F52 pdLog + 0x398
[1] 0x00002B0F131DA847
_ZN13SQLO_MEM_POOL32diagnoseMemoryCorruptionAndCrashEmPKc +
0x241
[2] 0x00002B0F13F19C0B
_ZN13SQLO_MEM_POOL10MemTreePutEP8SMemNodemP17SqloChunkSubgroup +
0x4AB
[3] 0x00002B0F13F18F5A sqlofmblkEx + 0x25A
[4] 0x00002B0F11DF0F4E _Z8sqlristmP8sqlrr_cbP9sqlri_shdi +
0x84
[5] 0x00002B0F11D5C958
_Z32sqlra_sqlW_mem_free_sibling_listP8sqlrr_cbP23sqlra_workspace
_siblingPm
+ 0x17E8
[6] 0x00002B0F11D5AEA1
_Z24sqlra_sqlW_mem_freespaceP8sqlrr_cbmPmi + 0x3B5
[7] 0x00002B0F11D57093
_Z29sqlra_sqlW_get_static_sectionP8sqlrr_cbi + 0x10E9
[8] 0x00002B0F13F42BEF
_Z17sqlra_get_sectionP8sqlrr_cbPhsS1_sS1_tmP16db2UCprepareInfoP1
5db2UCCursorInfo
+ 0x61F
[9] 0x00002B0F13F34C45
_Z21sqlrr_sql_request_preP14db2UCinterfacejiP16db2UCprepareInfoP
15db2UCCursorInfo
+ 0x4DB |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 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 5. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC77493
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.06.2011
01.03.2012
01.03.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
