DB2 - Problem description
Problem IC75707 | Status: Closed |
ST_BUFFER SPATIAL FUNCTION CRASHED DB2 WITH MEMORY CORRUPTION FAILURE | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
Due to data-specific conditions which have not yet been identified, the ST_Buffer spatial function very occasionally results in memory corruption which can cause the DB2 instance to hang or crash. The db2diag.log file shows a stack trace similar to the following: 2011-03-21-11.32.01.075143-300 I71420A958 LEVEL: Severe PID : 1810594 TID : 772 PROC : db2fmp (C) 0 INSTANCE: db2engr6 NODE : 000 EDUID : 772 EDUNAME: db2fmp (C) 0 FUNCTION: DB2 UDB, global services, sqlzAssertFailed, probe:10 DATA #1 : String, 142 bytes NON-FATAL ASSERTION FAILED!!! ASSERTION EXPRESSION: Invalid block eye-catcher (0x0) found at: SOURCE FILENAME: db2/gseOss.cpp LINE NUMBER: 61 CALLSTCK: [0] 0x09000000175A598C pdLog + 0x88 [1] 0x0900000016FE9DEC sqlzAssertFailedValist + 0x164 [2] 0x090000000360F3B0 ossAssertFailureAction + 0x130 [3] 0x090000000363A744 _ossMemAllocCheck + 0x764 [4] 0x090000000363A81C _ossMemFree + 0x5C [5] 0x090000000195C014 _GseOssFree + 0x94 [6] 0x0900000001AA5D18 SgsShapeBuffer + 0x9D8 [7] 0x09000000019CBD60 SgShapeGenerateBuffer + 0x1E0 [8] 0x0900000001B539B8 gseBuffer + 0xA18 [9] 0x0900000017472768 sqloInvokeFnArgs + 0xCB8 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DB2 Spatial Extender * **************************************************************** * PROBLEM DESCRIPTION: * * Due to data-specific conditions which have not yet been * * * * identified, the ST_Buffer spatial function very occasionally * * * * results in memory corruption which can cause the DB2 * * instance to * * hang or crash. The db2diag.log file shows a stack trace * * similar * * to the following: * * * * * * * * 2011-03-21-11.32.01.075143-300 I71420A958 LEVEL: * * Severe * * PID : 1810594 TID : 772 PROC : * * db2fmp * * (C) 0 * * * * INSTANCE: db2engr6 NODE : 000 * * EDUID : 772 EDUNAME: db2fmp (C) 0 * * * * FUNCTION: DB2 UDB, global services, sqlzAssertFailed, * * probe:10 * * DATA #1 : String, 142 bytes * * * * NON-FATAL ASSERTION FAILED!!! * * * * ASSERTION EXPRESSION: Invalid block eye-catcher (0x0) found * * at: * * SOURCE FILENAME: db2/gseOss.cpp * * * * LINE NUMBER: 61 * * * * CALLSTCK: * * * * [0] 0x09000000175A598C pdLog + 0x88 * * * * [1] 0x0900000016FE9DEC sqlzAssertFailedValist + 0x164 * * * * [2] 0x090000000360F3B0 ossAssertFailureAction + 0x130 * * * * [3] 0x090000000363A744 _ossMemAllocCheck + 0x764 * * * * [4] 0x090000000363A81C _ossMemFree + 0x5C * * * * [5] 0x090000000195C014 _GseOssFree + 0x94 * * * * [6] 0x0900000001AA5D18 SgsShapeBuffer + 0x9D8 * * * * [7] 0x09000000019CBD60 SgShapeGenerateBuffer + 0x1E0 * * * * [8] 0x0900000001B539B8 gseBuffer + 0xA18 * * * * [9] 0x0900000017472768 sqloInvokeFnArgs + 0xCB8 * **************************************************************** * RECOMMENDATION: * * Install V9.7 fix pack 5 * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
Solution | |
Install V9.7 fix pack 5 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.04.2011 13.12.2011 13.12.2011 |
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 |