|
Problem IC70578
|
Status: Closed |
DB2 CLP(DB2BP) CAN TRAP WITH SEGV OR CONSUME CPU WITH NESTED SEGV CONDITIONS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
DB2 CLP(db2bp) process can trap with SEGV or consume CPU with
nested SEGV conditions.
Ensure DFT_MON_STMT = ON.
1) db2pd -db <db> -appl to get the CoorPid.
2) db2trc on -p <CoorPid-from-#1> -debug
DB2.SQLR.sqlrr_stmt_exe_start.exit -suspend
Session 1:
3) db2 -f <the big SQL>
Session 2:
4) db2 get snapshot for applications on <db>
[...]
Dynamic SQL statement text:
DB21017E The Command Line Processor encountered a system error
with the
front-end process output queue. Reason code = -2029060033.
Possible Stack:
2878: /db2/db2iwp/sqllib/bin/db2bp
-------------------------------- lwpid : 1701541
-------------------------------
0: c00000001827c0f0 :
_Z13pdLogInternalmjmjmmmmPvmP11__va_list__() + 0x44e0
(/db2/db2iwp/fp7_sb23796/lib64/libdb2.so)
1: c0000000184de6f0 : pdLogSysRC() + 0xd0
(/db2/db2iwp/fp7_sb23796/lib64/libdb2.so)
2: c000000018f1df50 : _Z21sqloLogAndMapQueErrorjjim() + 0x70
(/db2/db2iwp/fp7_sb23796/lib64/libdb2.so)
3: c0000000183aac30 : sqlocque() + 0x250
(/db2/db2iwp/fp7_sb23796/lib64/libdb2.so)
4: 400000000011f350 : _Z15clp_bp_exitlistj() + 0xf0
(/db2/db2iwp/sqllib/bin/db2bp)
5: 400000000011f870 : clp_bp_sigterm() + 0x170
(/db2/db2iwp/sqllib/bin/db2bp)
5: e0000001208828e0 : [ sendsig : signal 11 : SIGSEGV ]
7: c000000018282b40 : sqlogmblkEx() + 0x15b0
(/db2/db2iwp/fp7_sb23796/lib64/libdb2.so)
8: c00000001829b170 :
_Z15sqlowqueWrapperP13SQLO_QUE_DESCP12SQLO_MSG_HDRib() + 0xe0
(/db2/db2iwp/fp7_sb23796/lib64/libdb2.so)
9: c000000018266bf0 : sqlowque() + 0x30
(/db2/db2iwp/fp7_sb23796/lib64/libdb2.so)
10: 40000000000513a0 : _Z8clp_wqueP12SQLO_MSG_HDR() + 0xc0
(/db2/db2iwp/sqllib/bin/db2bp)
11: 40000000001201f0 : _Z16clp_send_msglinei() + 0x190
(/db2/db2iwp/sqllib/bin/db2bp)
12: 40000000000f8e90 :
_Z17clp_stmt_snapshotP14sqlm_collectedP20sqlm_recording_groupPcj
()
+ 0x1bf0 (/db2/db2iwp/sqllib/bin/db2bp)
13: 40000000000d87e0 : _Z18clpbp_exe_sqlmonssv() + 0x22c0
(/db2/db2iwp/sqllib/bin/db2bp)
14: 400000000004eb40 : _Z10clp_bp_conv() + 0x6a0
(/db2/db2iwp/sqllib/bin/db2bp)
15: 4000000000056d60 :
_ZN6DasAPI13setOutputArgsER13DasOutputArgs() + 0x2a0
(/db2/db2iwp/sqllib/bin/db2bp)
16: c00000000002be30 : main_opd_entry() + 0x50
(/usr/lib/hpux64/dld.so)
WORKAROUND:
None |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All Platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2 CLP(DB2BP) CAN TRAP WITH SEGV OR CONSUME CPU WITH NESTED *
* SEGV CONDITIONS *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v9.7 Fixpack 4 or higher. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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 DB2 v9.7 Fixpack 4 or higher. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.08.2010
09.05.2011
09.05.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
