|
Problem IC74477
|
Status: Closed |
INSTANCE TRAP IN AUDIT: SQLR_AUDIT |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
Instance trap in sqlr_audit.
call stack:
0x00002AAAB00FFAF3 ossDumpStackTraceEx + 0x01ef
(/db2home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00002AAAB00FA8BA _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00cc
(/db2home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00002AAAAD3FECC2 sqlo_trce + 0x040a
(/db2home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAAAD444D1C sqloEDUCodeTrapHandler + 0x025a
(/db2home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAAAABD4CB0 address: 0x00002AAAAABD4CB0 ; dladdress:
0x00002AAAAABC7000 ; offset in lib: 0x000000000000DCB0 ;
(/lib64/libpthread.so.0)
0x00002AAAAD6398F0 _Z10sqlr_auditP8sqlrr_cbP14sqlexAuditDataPii
+ 0x01a8
(/db2home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAAAD63A81A
_Z18sqlr_audit_executeP8sqlrr_cbsP19sqlrr_curr_activitymP5sqlcai
+ 0x0b4e
(/db2home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAAABFC386F _Z8sqlrrbckP8sqlrr_cbiiiiP15SQLXA_CALL_INFO +
0x0a83
(/db2home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAAAE15DEDD _Z21sqlrr_rds_common_postP14db2UCinterfaceiil
+ 0x17b3
(/db2home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAAABFB709F
_Z11sqlrr_fetchP14db2UCinterfaceP15db2UCCursorInfo + 0x053d
(/db2home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC2B6A22
_Z13csmDriveFetchP14db2UCinterfaceP15db2UCCursorInfobb + 0x06a4
(/db2home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC2B4908 _Z16csmCursorBlasterP14db2UCinterfacejjPjjj +
0x1070
(/db2home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC0AED71
_Z19sqlriInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntf +
0x0a27
(/db2home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC0A8898 _Z9sqlricallP8sqlrr_cb + 0x0e04
(/db2home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAAAE1747D5 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm
+ 0x00e5
(/db2home/db2inst1/sqllib/lib64/libdb2e.so.1)
Upon rollback of running stored procedure, all sections are
closed by sqlra_close_sections.
Later in audit the sibling pointer is being accessed when it
already is freed. Thus cause the trap. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* see ERROR DESCRIPTION *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.5 Fix Pack 8. *
**************************************************************** |
| Local Fix: |
Temporarily disable audit for the instance and database |
| available fix packs: |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 Version 9.5 Fix Pack 8. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.02.2011
01.07.2011
01.07.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.8
|
 |
