DB2 - Problem description
Problem IT40019 | Status: Closed |
DB2 GOT CRASHED WITH SIGINAL #11 AT SQLRILITERALREPLACE() | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
db2diag.log reported following error. 2021-05-13-20.12.19.238052+480 I77478945E922 LEVEL: Severe PID : 1655343 TID : 140309421876992 PROC : db2sysc 0 INSTANCE: xxxxx NODE : 000 DB : XXXXX APPHDL : 0-14013 APPID: xx.xx.xx.xx.55378.210512115015 UOWID : 789822 ACTID: 1 AUTHID : xxxxx HOSTNAME: MYHOST1 EDUID : 259 EDUNAME: db2agent (XXXXX) 0 FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:300 DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0 sqlerrmc: sqlerrp : SQL11055 sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: 2021-05-13-20.12.19.238086+480 I77479868E211 LEVEL: Severe PID:1655343 TID:140309421876992 NODE:000 Title: SQLCA Dump File:/istmm8/db2fodc/FODC_Trap_2021-05-13-20.12.19.051174_0000/1 655343.259.000.dump.bin Stack trace is similar to following: -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00007F9CBFF693E4 _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP9siginfo_tPvmm + 0x00d4 (/istmm8/sqllib/lib64/libdb2osse.so.1) 0x00007F9CBFF6A152 ossDumpStackTraceV98 + 0x0022 (/istmm8/sqllib/lib64/libdb2osse.so.1) 0x00007F9CBFF65A4A address: 0x00007F9CBFF65A4A ; dladdress: 0x00007F9CBFCEA000 ; offset in lib: 0x000000000027BA4A ; (/istmm8/sqllib/lib64/libdb2osse.so.1) 0x00007F9CCA2B87F9 sqlo_trce + 0x0829 (/istmm8/sqllib/lib64/libdb2e.so.1) 0x00007F9CCA438709 sqloEDUCodeTrapHandler + 0x03a9 (/istmm8/sqllib/lib64/libdb2e.so.1) 0x00007F9CD0C6CB20 address: 0x00007F9CD0C6CB20 ; dladdress: 0x00007F9CD0C5A000 ; offset in lib: 0x0000000000012B20 ; (/lib64/libpthread.so.0) 0x00007F9CCAF93C9A _Z22sqlriLiteralReplaceBNIP8sqlrr_cb + 0x007a (/istmm8/sqllib/lib64/libdb2e.so.1) 0x00007F9CCB10828F _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x04ef (/istmm8/sqllib/lib64/libdb2e.so.1) 0x00007F9CCAB3D1AC _Z19sqlriExecOpenThreadP8sqlrr_cb + 0x002c (/istmm8/sqllib/lib64/libdb2e.so.1) 0x00007F9CCAB33EED _Z10sqlrr_openP14db2UCinterfaceP15db2UCCursorInfo + 0x250d (/istmm8/sqllib/lib64/libdb2e.so.1) 0x00007F9CC867EA38 _Z16sqljs_ddm_opnqryP14db2UCinterfaceP13sqljDDMObject + 0x0518 (/istmm8/sqllib/lib64/libdb2e.so.1) 0x00007F9CC86645C3 _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U Cinterface + 0x0343 (/istmm8/sqllib/lib64/libdb2e.so.1) 0x00007F9CC8664FEA _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x082a (/istmm8/sqllib/lib64/libdb2e.so.1) 0x00007F9CC8659253 address: 0x00007F9CC8659253 ; dladdress: 0x00007F9CC02C0000 ; offset in lib: 0x0000000008399253 ; (/istmm8/sqllib/lib64/libdb2e.so.1) 0x00007F9CC865D334 _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0x0be4 (/istmm8/sqllib/lib64/libdb2e.so.1) 0x00007F9CC7FF3E79 _ZN8sqeAgent6RunEDUEv + 0x05f9 (/istmm8/sqllib/lib64/libdb2e.so.1) 0x00007F9CCC153CA4 _ZN9sqzEDUObj9EDUDriverEv + 0x01a4 (/istmm8/sqllib/lib64/libdb2e.so.1) 0x00007F9CCA43B9E6 sqloEDUEntry + 0x02a6 (/istmm8/sqllib/lib64/libdb2e.so.1) 0x00007F9CD0C6214A address: 0x00007F9CD0C6214A ; dladdress: 0x00007F9CD0C5A000 ; offset in lib: 0x000000000000814A ; (/lib64/libpthread.so.0) 0x00007F9CBF072F23 clone + 0x0043 (/lib64/libc.so.6) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Db2 11.5 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to latest Fixpack * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Db2 11.5 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to latest Fixpack * **************************************************************** | |
Comment | |
Db2 got crashed with Siginal #11 at sqlriLiteralReplace() | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 21.02.2022 22.04.2022 22.04.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |