DB2 - Problem description
Problem IT33691 | Status: Closed |
ON DPF INSTANCE APPLICATIONS MAY HANG WHILE DOING A COMMIT | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
The diaglog can have a message like: 2020-03-19-18.20.12.746861+540 I28835813E666 LEVEL: Info PID : 11413 TID : 17592823509344 PROC : db2sysc 5 INSTANCE: db2inst1 NODE : 005 HOSTNAME: XXXX EDUID : 148 EDUNAME: db2pdbc 5 FUNCTION: DB2 UDB, base sys utilities, sqlePdbProcessRequest, probe:70 DATA #1 : Request discarded for reason: 33 Type of request discarded: 80000017 Return code for request discarded: -952 Sender node of request discarded: 8 Counter of request discarded: 26 Reply type of request discarded: 2 app handle: 0-9190; app stamp: 1339535110; app state: 1 Interrupt request: 80000055 Interrupt type: 8300000a The coord on Member 0 is in this stack: semtimedop + 0x0038 sqkfChannel::WaitRecvReady(int, int, int) + 0x1104 sqkfChannel::ReceiveBuffer(sqkfBuffer**, int) + 0x0d48 sqkdBdsBufferTable::getNextBuffer(sqkfBuffer**, SQLKD_CB*) + 0x1198 0x000010000CFBE954 0x000010000CFB5E60 0x000010000CFB7848 sqlkdReceiveReply(SQLKD_RQST_REPLY_FORMAT*) + 0x0820 sqlkdInterrupt(SQLKD_INTERRUPT_FORMAT*, sqlca*, sqlrr_cb*) + 0x1b10 sqlrr2pd(sqlrr_cb*, SQLR_PE_TRAN_RQST*, int, int*, SQLR_PE_TRAN_RPLY**) + 0x0a40 sqlrkprp(sqlrr_cb*, SQLXA_CALL_INFO*, int, int, int, unsigned int, char*, int*, int*) + 0x1560 sqlrrcom_dps(sqlrr_cb*, int, int, SQLXA_CALL_INFO*) + 0x37e8 sqlrrcom(sqlrr_cb*, int, int) + 0x1464 sqlrr_commit(db2UCinterface*) + 0x0134 pvmPackage::executeSection(sqlca*, unsigned int, bool) + 0x0628 PVM::executeQuery(unsigned int, bool) + 0x0280 The member which is not responding any more can have a stack like: 0x00001000186CBF78 semtimedop + 0x0038 0x000010000D0141D4 _ZN11sqkfChannel13WaitRecvReadyEiii + 0x1104 0x000010000D023E88 _ZN11sqkfChannel13ReceiveBufferEPP10sqkfBufferi + 0x0d48 0x000010000CFD3D88 _ZN18sqkdBdsBufferTable13getNextBufferEPP10sqkfBufferP8SQLKD_CB + 0x1198 0x000010193B7EB350 0x000010000CFBE954 0x000010193B7EB3C0 0x000010000CFB5E60 0x000010193B7EB4F0 0x000010000CFB7848 0x000010000CFB8CA0 _Z17sqlkdReceiveReplyP23SQLKD_RQST_REPLY_FORMAT + 0x0820 0x000010000C5D4364 _Z26sqleReceiveAndMergeRepliesP24SQLE_RECEIVE_MERGE_INPUTP25SQLE _RECEIVE_MERGE_OUTPUTP5sqlcaP8sqlrr_cb + 0x05f4 0x000010000CFB2DB0 _Z14sqlkdInterruptP22SQLKD_INTERRUPT_FORMATP5sqlcaP8sqlrr_cb + 0x2760 0x000010000FA9E960 _Z16sqlrr_sub_rrsvptP8sqlrr_cbi + 0x1b40 0x000010000FA7A0C8 _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x1068 0x000010193B7EDB80 0x000010000C49BB60 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.5.5.0 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 24.07.2020 20.11.2020 20.11.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |