|
Problem IT32507
|
Status: Closed |
ON RARE OCCASIONS, DB2 MAY CRASH/TRAP IN SQLOGETTIDFROMEDUID()
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
The problem is difficult to reproduce. The function which
trapped was sqloGetTIDFromEDUID() and the leading trigger was a
call to table function env_get_db2_edu_system_resources()
In the db2diag.log we see:
EDUID : 20511 EDUNAME: db2agent (dbname) 0
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler,
probe:30
MESSAGE : ADM14005E The following error occurred: "AppErr".
First Occurrence
Data Capture (FODC) has been invoked in the following
mode:
"Automatic". Diagnostic information has been recorded
in the
directory named
"/db2/path/db2dump/FODC_AppErr_2020-03-03-09.36.38.022000_20054_
20511_
000/".
EDUID : 20511 EDUNAME: db2agent (dbname) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh,
probe:1
MESSAGE : Error in agent servicing application with coor_node:
DATA #1 : Hexdump, 2 bytes
0x00007DBAA700F822 : 0000
The stack trace shows Trap in sqloGetTIDFromEDUID :
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00007F5A49A16F85
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
0x0385
(/db2/db2pjr/sqllib/lib64/libdb2osse.so.1)
0x00007F5A49A16B8C ossDumpStackTraceV98 + 0x002c
(/db2/db2pjr/sqllib/lib64/libdb2osse.so.1)
0x00007F5A49A12C2D _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00fd
(/db2/db2pjr/sqllib/lib64/libdb2osse.so.1)
0x00007F5A500D1114 sqlo_trce + 0x0404
(/db2/db2pjr/sqllib/lib64/libdb2e.so.1)
0x00007F5A5015B299 sqloEDUCodeTrapHandler + 0x02b9
(/db2/db2pjr/sqllib/lib64/libdb2e.so.1)
0x0000003D6CC0F7E0 address: 0x0000003D6CC0F7E0 ; dladdress:
0x0000003D6CC00000 ; offset in lib: 0x000000000000F7E0 ;
(/lib64/libpthread.so.0)
0x00007F5A4E01A75E sqloGetTIDFromEDUID + 0x005e
(/db2/db2pjr/sqllib/lib64/libdb2e.so.1)
0x00007F5A4E07FFDC sqloGetCPUUsage + 0x020c
(/db2/db2pjr/sqllib/lib64/libdb2e.so.1)
0x00007F5A504D043F
_Z50sqlrwGatherEnvDB2EduSystemInformationForThisMemberP8sqeAgent
PPcPl + 0x031f
(/db2/db2pjr/sqllib/lib64/libdb2e.so.1)
0x00007F5A50439844
_Z30sqlrkGetWLMTableFunctionResultP8sqeAgentP20sqlrw_rpc_tf_requ
estPPvPl + 0x0184
(/db2/db2pjr/sqllib/lib64/libdb2e.so.1)
0x00007F5A4E32EE41 _Z36sqlrwGetWLMTableFunctionMergedResultjPPv
+ 0x0661
(/db2/db2pjr/sqllib/lib64/libdb2e.so.1)
0x00007F5A4D304B7C _Z29sqlerTrustedRtnCallbackRouterjPPv +
0x00bc
.
. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5m4fp0 or higher *
**************************************************************** |
| Local Fix: |
Avoid a call to table function ENV_GET_DB2_EDU_SYSTEM_RESOURCES |
| Solution |
|
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner :
follow-up : IT32586 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.04.2020
30.06.2020
30.06.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
