|
Problem IC75475
|
Status: Closed |
DBARTISAN CAUSE THE DB2 INSTANCE TO CRASH ON THE DATABASE SIDE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
dbArtisan cause the DB2 instance to crash on the database side.
The issue is not with DB2 but with dbArtisan, this has been
fixed on the dbArtisan side.
Output from the StackTrace:
---FUNC-ADDR---- ------FUNCTION + OFFSET------
0000002A9B7C91AF ossDumpStackTraceEx + 0x01f7
(/ms/dist/ibmdb2/PROJ/ds/9.5.4.7/.exec/x86_64.linux.2.6.
glibc.2.3/lib64/libdb2osse.so.1)
0000002A9B7C4CEA _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00b4
(/ms/dist/ibmdb2/PROJ/ds/9.5.4.7/.exec/x86_64.linux.2.6.
glibc.2.3/lib64/libdb2osse.so.1)
0000002A9B7C4DB1 _ZN11OSSTrapFile4dumpEmiP7siginfoPv + 0x0009
(/ms/dist/ibmdb2/PROJ/ds/9.5.4.7/.exec/x86_64.linux.2.6.
glibc.2.3/lib64/libdb2osse.so.1)
0000002A97D1EC4B sqlo_trce + 0x03f3
(/ms/dist/ibmdb2/PROJ/ds/9.5.4.7/.exec/x86_64.linux.2.6.
glibc.2.3/lib64/libdb2e.so.1)
0000002A97D5EB0D sqloEDUCodeTrapHandler + 0x0101
(/ms/dist/ibmdb2/PROJ/ds/9.5.4.7/.exec/x86_64.linux.2.6.
glibc.2.3/lib64/libdb2e.so.1)
0000002A956784F0 address: 0x0000002A956784F0 ; dladdress:
0x0000002A9566C000 ; offset in lib: 0x000000000000C4F0 ;
(/lib64/tls/libpthread.so.0)
0000002A9B7AA888 _ZN12OSSHIPCQueue3getEPvmPmi + 0x028c
(/ms/dist/ibmdb2/PROJ/ds/9.5.4.7/.exec/x86_64.linux.2.6.
glibc.2.3/lib64/libdb2osse.so.1)
0000002BBC9F7D3C _ZN12CPsmdRoutern9GetStatusEPcPjjS0_S1_jiPi +
0x003c
(/var/ibmdb2/nytxt200/sqllib/bin/routine/db2psmdr)
0000002BBC9F78E0 sdbg_GetReport + 0x007c
(/var/ibmdb2/nytxt200/sqllib/bin/routine/db2psmdr)
0000002A96A8D440 sqloInvokeFnArgs + 0x0040
(/ms/dist/ibmdb2/PROJ/ds/9.5.4.7/.exec/x86_64.linux.2.6.
glibc.2.3/lib64/libdb2e.so.1)
0000002A96BE8AE9
_Z19sqlriInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntf +
0x065d
(/ms/dist/ibmdb2/PROJ/ds/9.5.4.7/.exec/x86_64.linux.2.6.
glibc.2.3/lib64/libdb2e.so.1)
0000002A96BE4E43 _Z9sqlricallP8sqlrr_cb + 0x082f
(/ms/dist/ibmdb2/PROJ/ds/9.5.4.7/.exec/x86_64.linux.2.6.
glibc.2.3/lib64/libdb2e.so.1)
0000002A98925EEE _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm +
0x00b2
(/ms/dist/ibmdb2/PROJ/ds/9.5.4.7/.exec/x86_64.linux.2.6.
glibc.2.3/lib64/libdb2e.so.1)
0000002A9890C65B _Z29sqlrr_process_execute_requestP8sqlrr_cbi +
0x0699
(/ms/dist/ibmdb2/PROJ/ds/9.5.4.7/.exec/x86_64.linux.2.6.
glibc.2.3/lib64/libdb2e.so.1)
0000002A9890B338 _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo +
0x00f8 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DBARTISAN CAUSE THE DB2 INSTANCE TO CRASH ON THE DATABASE *
* SIDE *
****************************************************************
* PROBLEM DESCRIPTION: *
* dbArtisan cause the DB2 instance to crash on the database *
* side. *
* The issue is not with DB2 but with dbArtisan, this has been *
* *
* fixed on the dbArtisan side. *
* *
* Output from the StackTrace: *
* *
* ---FUNC-ADDR---- ------FUNCTION + OFFSET------ *
* *
* 0000002A9B7C91AF ossDumpStackTraceEx + 0x01f7 *
* *
* *
* (/ms/dist/ibmdb2/PROJ/ds/9.5.4.7/.exec/x86_64.linux.2.6. *
* glibc.2.3/lib64/libdb2osse.so.1) *
* *
* 0000002A9B7C4CEA _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + *
* 0x00b4 *
* *
* *
* (/ms/dist/ibmdb2/PROJ/ds/9.5.4.7/.exec/x86_64.linux.2.6. *
* glibc.2.3/lib64/libdb2osse.so.1) *
* *
* 0000002A9B7C4DB1 _ZN11OSSTrapFile4dumpEmiP7siginfoPv + *
* 0x0009 *
* *
* *
* (/ms/dist/ibmdb2/PROJ/ds/9.5.4.7/.exec/x86_64.linux.2.6. *
* glibc.2.3/lib64/libdb2osse.so.1) *
* *
* 0000002A97D1EC4B sqlo_trce + 0x03f3 *
* *
* *
* (/ms/dist/ibmdb2/PROJ/ds/9.5.4.7/.exec/x86_64.linux.2.6. *
* glibc.2.3/lib64/libdb2e.so.1) *
* *
* 0000002A97D5EB0D sqloEDUCodeTrapHandler + 0x0101 *
* *
* *
* (/ms/dist/ibmdb2/PROJ/ds/9.5.4.7/.exec/x86_64.linux.2.6. *
* glibc.2.3/lib64/libdb2e.so.1) *
* *
* 0000002A956784F0 address: 0x0000002A956784F0 ; dladdress: *
* *
* 0x0000002A9566C000 ; offset in lib: 0x000000000000C4F0 ; *
* *
* (/lib64/tls/libpthread.so.0) *
* *
* 0000002A9B7AA888 _ZN12OSSHIPCQueue3getEPvmPmi + 0x028c *
* *
* *
* (/ms/dist/ibmdb2/PROJ/ds/9.5.4.7/.exec/x86_64.linux.2.6. *
* glibc.2.3/lib64/libdb2osse.so.1) *
* *
* 0000002BBC9F7D3C _ZN12CPsmdRoutern9GetStatusEPcPjjS0_S1_jiPi *
* + *
* 0x003c *
* *
* (/var/ibmdb2/nytxt200/sqllib/bin/routine/db2psmdr) *
* 0000002BBC9F78E0 sdbg_GetReport + 0x007c *
* *
* *
* (/var/ibmdb2/nytxt200/sqllib/bin/routine/db2psmdr) *
* 0000002A96A8D440 sqloInvokeFnArgs + 0x0040 *
* *
* *
* (/ms/dist/ibmdb2/PROJ/ds/9.5.4.7/.exec/x86_64.linux.2.6. *
* glibc.2.3/lib64/libdb2e.so.1) *
* *
* 0000002A96BE8AE9 *
* *
* _Z19sqlriInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntf *
* + *
* 0x065d *
* *
* (/ms/dist/ibmdb2/PROJ/ds/9.5.4.7/.exec/x86_64.linux.2.6. *
* glibc.2.3/lib64/libdb2e.so.1) *
* *
* 0000002A96BE4E43 _Z9sqlricallP8sqlrr_cb + 0x082f *
* *
* *
* (/ms/dist/ibmdb2/PROJ/ds/9.5.4.7/.exec/x86_64.linux.2.6. *
* glibc.2.3/lib64/libdb2e.so.1) *
* *
* 0000002A98925EEE *
* _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + *
* 0x00b2 *
* *
* (/ms/dist/ibmdb2/PROJ/ds/9.5.4.7/.exec/x86_64.linux.2.6. *
* glibc.2.3/lib64/libdb2e.so.1) *
* *
* 0000002A9890C65B *
* _Z29sqlrr_process_execute_requestP8sqlrr_cbi + *
* 0x0699 *
* *
* (/ms/dist/ibmdb2/PROJ/ds/9.5.4.7/.exec/x86_64.linux.2.6. *
* glibc.2.3/lib64/libdb2e.so.1) *
* *
* 0000002A9890B338 *
* _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + *
* 0x00f8 *
****************************************************************
* RECOMMENDATION: *
* First fixed in fix pack 5 of v9.7 *
**************************************************************** |
| Local Fix: |
N/A |
| available fix packs: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in fix pack 5 of v9.7 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 31.03.2011
07.03.2012
07.03.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
