|
Problem IC89736
|
Status: Closed |
FMP TRAP ON SQLOXLTC_APP EXECUTING SYSPROC.SNAP_GET_DB_V97 |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
When executing Non Federated stored procedures the FMP thread
might crash with the following stack showing on
nonEDU.app_trap.txt file:
<StackTrace>
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00002AAAACBDF407 ossDumpStackTraceEx + 0x01ef
(/db2home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00002AAAACBDA1C6 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00cc
(/db2home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00002AAAAB9521F2 sqlo_trce + 0x040a
(/db2home/db2inst1/sqllib/lib64/libdb2.so.1)
0x00002AAAAB953ED2 sqlo_db2fmp_trca_nokill + 0x013e
(/db2home/db2inst1/sqllib/lib64/libdb2.so.1)
0x00002AAAAD0A8D60 address: 0x00002AAAAD0A8D60 ; dladdress:
0x00002AAAAD09B000 ; offset in lib: 0x000000000000DD60 ;
(/lib64/libpthread.so.0)
0x00002AAAAB163A23 sqloxltc_app + 0x0039
(/db2home/db2inst1/sqllib/lib64/libdb2.so.1)
0x00002AAAAB783096
_Z17sqlerTakeLibLatchP27SQLER_LOADED_LIB_HASH_TABLEii + 0x0066
(/db2home/db2inst1/sqllib/lib64/libdb2.so.1)
0x00002AAAAB78F969 sqlerLibraryLoad + 0x0189
(/db2home/db2inst1/sqllib/lib64/libdb2.so.1)
0x00002AAAAB790476 sqlerRoutineLoad + 0x013c
(/db2home/db2inst1/sqllib/lib64/libdb2.so.1)
0x00002AAAAB77EBA1 sqlerFmpListener + 0x0ab9
(/db2home/db2inst1/sqllib/lib64/libdb2.so.1)
0x00002AAAAB78134B _Z22sqlerWorkerThreadEntryPv + 0x020d
(/db2home/db2inst1/sqllib/lib64/libdb2.so.1)
0x00002AAAAD0A1193 address: 0x00002AAAAD0A1193 ; dladdress:
0x00002AAAAD09B000 ; offset in lib: 0x0000000000006193 ;
(/lib64/libpthread.so.0)
0x00002AAAAD6D70DD __clone + 0x006d
(/lib64/libc.so.6)
</StackTrace>
The calling agent will show in the db2diag.log errors like:
EDUID : 43034 EDUNAME: db2agntp (DW) 0
FUNCTION: DB2 UDB, routine_infrastructure,
sqlerInvokeFencedRoutine, probe:88
DATA #1 : String, 37 bytes
Routine failed with termination error
Other Stored procedures might be affected. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.1 and Fix Pack 3 *
**************************************************************** |
| Local Fix: |
Retry execution of the Stored procedure as this is due a timing
hole and next execution will be likely successful. |
| available fix packs: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in DB2 Version 10.1 and Fix Pack 3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.01.2013
18.10.2013
18.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
