DB2 - Problem description
Problem IT24539 | Status: Closed |
INSTANCE MAY CRASH IN SQLRH_FREE_HANDLE | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
When running a query the instance may crash in sqlrh_free_handle. The db2diag.log will show the following error: 2018-02-27-12.46.19.618372+060 I291624A1578 LEVEL: Error PID : 2490950 TID : 3600 PROC : db2sysc 3 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-66 APPID: 9.1.1.1.52400.180227114612 AUTHID : DB2INST1 HOSTNAME: host EDUID : 3600 EDUNAME: db2agntp (SAMPLE) 3 FUNCTION: DB2 UDB, runtime interpreter, sqlrhFreeInternalHandles, probe:2950 MESSAGE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT "SQLCA has already been built" CALLED : DB2 UDB, runtime interpreter, sqlrh_free_handle RETCODE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT "SQLCA has already been built" DATA #1 : String, 42 bytes sqlrhFreeInternalHandles: Unexpected error DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -423 sqlerrml: 0 sqlerrmc: sqlerrp : SQLRI0A7 sqlerrd : (1) 0x801A006D (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0xFFFFFFF6 (6) 0x00000003 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: DATA #3 : Pointer, 8 bytes 0x0a0001000006b780 DATA #4 : unsigned integer, 4 bytes 18560 DATA #5 : Dumped object of size 74248 bytes at offset 0, 58 bytes /home/db2inst1/sqllib/db2dump/2490950.3600.000.dump.bin DATA #6 : Pointer, 8 bytes 0x0a0001000006c788 DATA #7 : Hex integer, 4 bytes 0xFAB0A000 DATA #8 : Pointer, 8 bytes 0x0a0001000007d984 DATA #9 : Hex integer, 4 bytes 0x00000000 The stack for the crash will similar to the following: sqlrh_free_handle(sqlrr_cb*,unsigned int*,int,unsigned char*,unsigned int,unsigned long,bool) + 0x208 sqlrhFreeInternalHandles(sqlrr_cb*,sqlrh_InternalHandleList**) + 0x1A8 sqlricls_complex(sqlrr_cb*,int,long,long,long) + 0x2AE4 Nested signal handlers detected This crash is dependent on the data that is being processed as part of the query. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All DB2 users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 for Linux Unix and Windows 10.5 Fix Pack 10 * * or later * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : follow-up : IT24624 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.03.2018 12.07.2018 12.07.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |