DB2 - Problem description
Problem IT20089 | Status: Closed |
ERROR MESSAGE "NON-FATAL ASSERTION FAILED!!!" FILLING UP DB2DIAG.LOG | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
1. Problem description Error message "NON-FATAL ASSERTION FAILED!!!" keeps appearing in db2diag.log. 2. Operating system and level: DB2 10.1 + DB2 Spatial Extender 3. Diagnostic information 2017-03-25-16.19.25.473000-240 I1408F1146 LEVEL: Severe PID : 892 TID : 3528 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : GISDB01 APPHDL : 0-3663 APPID: GA32C135.P396.170316024116 AUTHID : USER001 HOSTNAME: GISPRODSRV EDUID : 3528 EDUNAME: db2agent (GISDB01) 0 FUNCTION: DB2 UDB, global services, sqlzAssertFailed, probe:10 DATA #2 : String, 149 bytes NON-FATAL ASSERTION FAILED!!! ASSERTION EXPRESSION: Invalid block eye-catcher (0xF9C24ADC) found at: SOURCE FILENAME: db2/gseOss.cpp LINE NUMBER: 61 CALLSTCK: [0] 0x000007FEF81A028B pdLog + 0x3BB [1] 0x000007FEF824D526 sqlzAssertFailedValist + 0x2A6 [2] 0x000007FEF9C1937C ossAssertFailureAction + 0xCC [3] 0x000007FEF9C19725 ossAssertFailed + 0x35 [4] 0x000007FEF9C1AFCF ossMemAllocCheck + 0x72F [5] 0x000007FEF9C1A7B5 ossMemFree + 0x55 [6] 0x000007FEE2089726 0x000007FEE2089726 + 0x0 [7] 0x0000000A8B752F50 0x0000000A8B752F50 + 0x0 [8] 0x000007FEE2185DB3 0x000007FEE2185DB3 + 0x0 [9] 0x0000000000000001 0x0000000000000001 + 0x0 2017-03-25-16.19.26.081000-240 I2556F1130 LEVEL: Severe PID : 892 TID : 3528 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : GISDB01 APPHDL : 0-3663 APPID: GA32C135.P396.170316024116 AUTHID : USER001 HOSTNAME: GISPRODSRV EDUID : 3528 EDUNAME: db2agent (GISDB01) 0 FUNCTION: DB2 UDB, global services, sqlzAssertFailed, probe:10 DATA #2 : String, 133 bytes NON-FATAL ASSERTION FAILED!!! ASSERTION EXPRESSION: Invalid pad type (0x0) found at: SOURCE FILENAME: db2/gseOss.cpp LINE NUMBER: 61 CALLSTCK: [0] 0x000007FEF81A028B pdLog + 0x3BB [1] 0x000007FEF824D526 sqlzAssertFailedValist + 0x2A6 [2] 0x000007FEF9C1937C ossAssertFailureAction + 0xCC [3] 0x000007FEF9C19725 ossAssertFailed + 0x35 [4] 0x000007FEF9C1AF8D ossMemAllocCheck + 0x6ED [5] 0x000007FEF9C1A7B5 ossMemFree + 0x55 [6] 0x000007FEE2089726 0x000007FEE2089726 + 0x0 [7] 0x0000000A8B752F50 0x0000000A8B752F50 + 0x0 [8] 0x000007FEE2185DB3 0x000007FEE2185DB3 + 0x0 [9] 0x0000000000000001 0x0000000000000001 + 0x0 DB2 trace indicates the function gseBuildUnionAggr() is where the problem occurs. 29610063 | | | | | | | | | | | | | | | gseBuildUnionAggr entry [eduid 3528 eduname db2agent] ... 29728837 | | | | | | | | | | | | | | | gseBuildUnionAggr data [probe 200] ... 29757641 | | | | | | | | | | | | | | | | GseOssFree entry [eduid 3528 eduname db2agent] 29758263 | | | | | | | | | | | | | | | | GseOssFree exit 29759263 | | | | | | | | | | | | | | | | GseOssFree entry [eduid 3528 eduname db2agent] 29760391 | | | | | | | | | | | | | | | | | pdLog entry [eduid 3528 eduname db2agent] 29761373 | | | | | | | | | | | | | | | | | | pdIsDiagLevelOk entry [eduid 3528 eduname db2agent] 29762488 | | | | | | | | | | | | | | | | | | pdIsDiagLevelOk data [probe 10] 29763773 | | | | | | | | | | | | | | | | | | pdIsDiagLevelOk data [probe 20] 29764646 | | | | | | | | | | | | | | | | | | pdIsDiagLevelOk data [probe 500].. 29809058 | | | | | | | | | | | | | | | | | | | sqlzAssertFailed data [probe 10] | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 10.5 Fix Pack 9 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
First fixed in Db2 10.5 Fix Pack 9 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 06.04.2017 27.09.2017 27.09.2017 |
Problem solved at the following versions (IBM BugInfos) | |
9.0. | |
Problem solved according to the fixlist(s) of the following version(s) |