|
Problem IC70576
|
Status: Geschlossen |
DB2 CLP(DB2BP) CAN TRAP WITH SEGV OR CONSUME CPU WITH NESTED SEGV CONDITIONS |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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: |
|
| verfügbare FixPacks: |
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
|
| Lösung |
Upgrade to v9.1FP10 or later |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC70577 IC70578
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 16.08.2010
20.06.2011
20.06.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.1.FP10
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.10
|
 |
