home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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
DB2 Version 9.7 Fix Pack 6 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
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 FixList