|
Problem IT37102
|
Status: Closed |
APPLICATION HANG IN DPF AFTER ISSUING DDL, CANNOT BE FORCED
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
In a DPF configuration, if DDL is issued from an application
that has connected at a non-catalog partition, then a subsequent
hang may occur under certain timing conditions if the
transaction ends up being rolled back shortly after the DDL was
issued (either due to an internal rollback or external
rollback).
The coordinating EDU for this application will be in a stack
similar to:
0x0900000000113894 thread_wait + 0x94
0x090000007E72F060 sqloWaitEDUWaitPost + 0xA00
0x090000007F0DFF40 WaitRecvReady__11sqkfChannelFiT1Ci + 0x1220
0x090000007F0EFCA4
ReceiveBuffer__11sqkfChannelFPP10sqkfBufferi + 0xDC4
0x090000007F175938
getNextBuffer__18sqkdBdsBufferTableFPP10sqkfBufferP8SQLKD_CB +
0x1398
0x090000007F163BF4 sqlkd_rcv_buffer__FP8SQLKD_CBPP10sqkfBuffer
+ 0x54
0x090000007F15A994
IPRA.$sqlkd_rcv_get_next_buffer__FP8SQLKD_CB + 0x54
0x090000007F15C6A0 sqlkd_rcv_init__FP8SQLKD_CBiN22 + 0x240
0x090000007F15D9DC
sqlkdReceiveReply__FP23SQLKD_RQST_REPLY_FORMAT + 0x89C
0x090000007F4946B4
sqlkdInterrupt__FP22SQLKD_INTERRUPT_FORMATP5sqlcaP8sqlrr_cb +
0x20B4
0x090000008040F880
sqlrr2pd__FP8sqlrr_cbP17SQLR_PE_TRAN_RQSTiPiPP17SQLR_PE_TRAN_RPL
Y + 0xA40
0x090000008042860C sqlrkrbk__FP8sqlrr_cbP15SQLXA_CALL_INFOi +
0xF0C
0x09000000809521F0
sqlrrbck_dps__FP8sqlrr_cbiN22P15SQLXA_CALL_INFOP9SQLP_GXID +
0x1090
0x090000008094DDB0 sqlrrbck__FP8sqlrr_cbiN32P15SQLXA_CALL_INFO
+ 0x1970
0x09000000806DB6EC sqlrr_rollback__FP14db2UCinterface + 0x10C
0x0900000085B11544
sqljs_ddm_rdbrllbck__FP14db2UCinterfaceP13sqljDDMObject + 0xAC4
0x0900000085A7CD40
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x2E0
0x0900000085A7FD64
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x2264
0x0900000085A4AD3C
IPRA.$sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xE9C
0x0900000085A53454
sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
0x0900000085A48DF0
IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x13F0
0x0900000085A4623C sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
0x33C
0x0900000085A48DF0
IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x13F0
0x0900000085A4623C sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
0x33C
0x090000007E750C20 RunEDU__8sqeAgentFv + 0xB60
0x090000007E72AE40 EDUDriver__9sqzEDUObjFv + 0x300
0x090000007E60BE00 sqloEDUEntry + 0x360
At the catalog node, there will be an EDU working on behalf of
the application with a stack similar to:
0x0900000000113894 thread_wait + 0x94
0x0900000076B1A060 sqloWaitEDUWaitPost + 0xA00
0x09000000774CAF40 WaitRecvReady__11sqkfChannelFiT1Ci + 0x1220
0x09000000774DACA4
ReceiveBuffer__11sqkfChannelFPP10sqkfBufferi + 0xDC4
0x0900000077560938
getNextBuffer__18sqkdBdsBufferTableFPP10sqkfBufferP8SQLKD_CB +
0x1398
0x090000007754EBF4 sqlkd_rcv_buffer__FP8SQLKD_CBPP10sqkfBuffer
+ 0x54
0x0900000077545994
IPRA.$sqlkd_rcv_get_next_buffer__FP8SQLKD_CB + 0x54
0x09000000775476A0 sqlkd_rcv_init__FP8SQLKD_CBiN22 + 0x240
0x09000000775489DC
sqlkdReceiveReply__FP23SQLKD_RQST_REPLY_FORMAT + 0x89C
0x090000007753FF48
sqleReceiveAndMergeReplies__FP24SQLE_RECEIVE_MERGE_INPUTP25SQLE_
RECEIVE_MERGE_OUTPUTP5sqlcaP8sqlrr_cb + 0x8C8
0x09000000778804D4
sqlkdInterrupt__FP22SQLKD_INTERRUPT_FORMATP5sqlcaP8sqlrr_cb +
0x2ED4
0x0900000077866854 sqlrRpcInterruptSubAgents__FP8sqlrr_cbbPUc
+ 0x454
0x0900000077869420
sqlrkrpc_nl__FP8sqlrr_cbiN22PCsP15SQLR_RPCMESSAGEP13SQLO_MEM_POO
LP18SQLR_RPC_REPLY_HDRPbPlUlP19SQLR_BDSREPLY_STATE + 0x1B40
0x0900000078F7142C
sqlra_broadcast_request_cat__FP8sqlrr_cbP20SQLR_RPC_APM_REQUESTP
b + 0xBEC
0x090000007B68F678
sqlrk_apm_router__FP8sqlrr_cbP23SQLKD_RQST_REPLY_FORMATUiPP15SQL
R_RPCMESSAGE + 0x4F8
0x090000007B68BDDC sqlrr_rpc_router__FP8sqlrr_cb + 0x9FC
0x090000007B689800
sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xF80
0x090000007B674E94
IPRA.$sqleSubRequestRouter__FP8sqeAgentPUiPUl + 0x7B4
0x090000007B66EF38 sqleProcessSubRequest__FP8sqeAgent + 0x2C38
0x0900000076B3BAAC RunEDU__8sqeAgentFv + 0x9EC
0x0900000076B15E40 EDUDriver__9sqzEDUObjFv + 0x300
0x09000000769F6E00 sqloEDUEntry + 0x360 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5 FP7 or later *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5 FP7 or later *
**************************************************************** |
| Comment |
Upgrade to 11.5 FP7 or later |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.06.2021
22.11.2021
22.11.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
