|
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) |
