|
Problem IC70576
|
Status: Closed |
DB2 CLP(DB2BP) CAN TRAP WITH SEGV OR CONSUME CPU WITH NESTED SEGV CONDITIONS |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - 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 Linux/Unix Platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2 CLP(db2bp) process can trap with SEGV or consume CPU *
* with nested SEGV conditions. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v9.1FP10 or later *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Solution |
Upgrade to v9.1FP10 or later |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC70577 IC70578
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.08.2010
20.06.2011
20.06.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.10
|
 |
