|
Problem IT05753
|
Status: Closed |
APPLICATION HUNG DOING INSERT/SELECT ON TABLE WITH XML COLUMNS AND COMPRESS YES |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
An application running inserts/updates and selects on a
table with XML columns and compression might hang and not able
to be forced off.
The scenario is :
open transaction
insert ..
select..
db2pd -latches will show a deadlatch on
SQLO_LT_SQLB_BPD__bpdLatch_SX S (i.e a two threads waiting on
each other)
Database Member 0 -- Active -- Up 0 days 00:06:43 -- Date
2014-11-21-12.16.25.721195
Latches:
Address Holder Waiter Filename
LOC LatchType HoldCount
0x0780000001588440 1029 0
../include/sqle_workload_disp.h 1389
SQLO_LT_sqeWLDispatcher__m_tunerLatch 1
0x0700000047C2F468 13391 0
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649
SQLO_LT_SQLB_BPD__bpdLatch_SX S
0x0700000053E99768 13391 0
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649
SQLO_LT_SQLB_BPD__bpdLatch_SX S
0x0700000047D5BC28 13391 13134
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649
SQLO_LT_SQLB_BPD__bpdLatch_SX S
0x0700000047D5BC28 13391 13648
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649
SQLO_LT_SQLB_BPD__bpdLatch_SX S
0x0700000047D5BC28 13391 14162
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649
SQLO_LT_SQLB_BPD__bpdLatch_SX S
0x0700000047D5BC28 13391 14419
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649
SQLO_LT_SQLB_BPD__bpdLatch_SX S
0x0700000047D5BC28 13391 14676
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649
SQLO_LT_SQLB_BPD__bpdLatch_SX S
0x0700000047D5BC28 13391 14933
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649
SQLO_LT_SQLB_BPD__bpdLatch_SX S
0x0700000047D5BC28 13391 15190
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649
SQLO_LT_SQLB_BPD__bpdLatch_SX S
>>>>>>>>>>
0x0700000047D5BC28 13391 15447
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649
SQLO_LT_SQLB_BPD__bpdLatch_SX S
<<<<<<<<<<
0x0700000047D5BC28 13391 15704
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649
SQLO_LT_SQLB_BPD__bpdLatch_SX S
0x0700000047D5BC28 13391 15961
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649
SQLO_LT_SQLB_BPD__bpdLatch_SX S
0x0700000047D5BC28 13391 16218
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649
SQLO_LT_SQLB_BPD__bpdLatch_SX S
0x0700000047D5BC28 13391 16475
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649
SQLO_LT_SQLB_BPD__bpdLatch_SX S
0x0700000047D5BC28 13391 16732
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649
SQLO_LT_SQLB_BPD__bpdLatch_SX S
0x0700000047C50A28 15447 0
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649
SQLO_LT_SQLB_BPD__bpdLatch_SX S
0x0700000047E8D9A8 15447 0
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649
SQLO_LT_SQLB_BPD__bpdLatch_SX S
>>>>>>>>>>
0x0700000047D35DE8 15447 13391
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649
SQLO_LT_SQLB_BPD__bpdLatch_SX S
<<<<<<<<<<
0x0700000047D35DE8 15447 13905
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649
SQLO_LT_SQLB_BPD__bpdLatch_SX S
Stacks for the threads will show the wait is on XML code.
31 (1) SQLO_SLATCH_CAS64::getConflictComplex
32 (2) SQLO_SLATCH_CAS64::getConflict
33 (3) sqlbfix
34 (4) sqldcsl_fetchDirect
35 (5) sqldcsl_fetchRow
36 (6) xmls_FetchRegion
37 (7) XmlrnNodeMgr::fetchNode
38 (8) XmlrnTreeWalker::resolveContinuationNode
39 (9) XmlrnSerializer::serialize
40 (10) XmlrnSerializer::serialize
41 (11) XmlrnSerializer::serialize
42 (12) sqlriMaterializeXml
43 (13) sqlribnoLobCbDrda
44 (14) sqlribno_work
45 (15) sqlribno_work
46 (16) sqlribno
47 (17) sqlriSectInvoke
48 (18) sqlrr_process_fetch_request
49 (19) sqlrr_fetch
50 (20) sqljsParseRdbAccessed
51 (21) sqljsSqlam
52 (22) sqljsSqlam
53 (23) sqljsSqlam
54 (24) sqljsDriveRequests
55 (25) sqljsDrdaAsInnerDriver
56 (26) sqeAgent::RunEDU
57 (27) sqeAgent::RunEDU
58 (28) sqzEDUObj::EDUDriver
59 (29) sqloEDUEntry |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.5 and Fix Pack 7 *
**************************************************************** |
| Local Fix: |
Do not use compression on Tables with XML columns or
when insert - update XML tables , place a commit before doing a
select on the table on the same transaction:
open transaction
insert ..
commit
open transaciton.
select..
intead of :
open transaction
insert ..
select... |
| Solution |
Problem was first fixed in DB2 Version 10.5 and Fix Pack 7 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 24.11.2014
19.01.2016
27.04.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
