DB2 - Problem description
Problem IT36232 | Status: Closed |
HANDLE THE ISSUE WHEN 'NULL' VALUE RETURNED FOR NO SHREDDER WORKER, TO AVOID A MEMBER CRASH IN PURESCALE. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
PS member crashed on stack: -------Frame------ ------Function + Offset------ 0x090000000F8E3584 sqlpshrFlushLogBufForOnlineMembers__FP8sqeAgentP19sqlpDbcbLookup TableRUlPsUlPv + 0x340 0x090000000F9532C4 sqlpGroupOperationDriver__FP8sqeAgentP19sqlpDbcbLookupTablePFP8s qeAgentP19sqlpDbcbLookupTableRUlPsUlPv_iT3PvCUi + 0x60C 0x090000000F8257A0 executeOperationOnLocalView__15sqlpDbcbsHandleFP9sqeBsuEduPFP8sq eAgentP19sqlpDbcbLookupTableRUlPsUlPv_iT2PvCUi + 0x3A0 db2diag: ========= 2020-04-27-07.35.21.958712-240 I224852457A533 LEVEL: Severe PID : 16973950 TID : 78780 PROC : db2sysc 6 INSTANCE: db2xxxxs NODE : 006 DB : xxxxxx APPHDL : 6-63885 APPID: 1.2.2.1.1.2 AUTHID : db2db2 HOSTNAME: xxxxxxxxx0 EDUID : 78780 EDUNAME: db2agent (xxxxxx) 6 FUNCTION: DB2 UDB, buffer dist serv, sqkdBdsBufferTable::getNextReply, probe:20 RETCODE : ZRC=0x81590016=-2124873706=SQLKF_NODE_FAILED "Node Recovery" 2020-04-27-07.35.21.959692-240 I224853526A514 LEVEL: Error PID : 16973950 TID : 78780 PROC : db2sysc 6 INSTANCE: db2xxxxs NODE : 006 DB : xxxxxx APPHDL : 6-63885 APPID: 1.2.2.1.1.2 AUTHID : db2db2 HOSTNAME: xxxxxxxxx0 EDUID : 78780 EDUNAME: db2agent (xxxxxx) 6 FUNCTION: DB2 UDB, buffer dist serv, sqlkd_rcv_init, probe:30 RETCODE : ZRC=0x81590016=-2124873706=SQLKF_NODE_FAILED "Node Recovery" 2020-04-27-07.35.21.960214-240 E224854041A402 LEVEL: Error PID : 16973950 TID : 2057 PROC : db2sysc 6 INSTANCE: db2xxxxs NODE : 006 HOSTNAME: xxxxxxxxx0 EDUID : 2057 EDUNAME: db2fcms 6 FUNCTION: DB2 UDB, fast comm manager, sqkfTcpLink::closeConn, probe:25 DATA #1 : Link info: node 5; type 6; state 2; session 1; activated 1 2020-04-27-07.35.23.366726-240 I224854444A8827 LEVEL: Error PID : 16973950 TID : 2057 PROC : db2sysc 6 INSTANCE: db2xxxxs NODE : 006 HOSTNAME: xxxxxxxxx0 EDUID : 2057 EDUNAME: db2fcms 6 FUNCTION: DB2 UDB, fast comm manager, sqkfTcpServices::identifyUntrustedIncomingEvent, probe:41 MESSAGE : Error while waiting for connect() completion with node 5. rc = -2129723367. status = 3; port = 60000 DATA #1 : Hexdump, 1648 bytes 0x0780000004FE6FE8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ .......... ......... 2020-04-27-07.35.23.375995-240 I224863272A474 LEVEL: Error PID : 16973950 TID : 2057 PROC : db2sysc 6 INSTANCE: db2xxxxs NODE : 006 HOSTNAME: xxxxxxxxx0 EDUID : 2057 EDUNAME: db2fcms 6 FUNCTION: DB2 UDB, fast comm manager, sqkfSendConduit::HandleConnectLostEvent, probe:10 MESSAGE : Node link dropped by remote peer: DATA #1 : Hexdump, 2 bytes 0x0A0000000E3FE842 : 0005 .. 2020-04-27-07.35.23.376309-240 I224863747A479 LEVEL: Error PID : 16973950 TID : 2057 PROC : db2sysc 6 INSTANCE: db2xxxxs NODE : 006 HOSTNAME: xxxxxxxxx0 EDUID : 2057 EDUNAME: db2fcms 6 FUNCTION: DB2 UDB, fast comm manager, sqkfSendConduit::HandleConnectLostEvent, probe:20 MESSAGE : Handling conn lost due to event: DATA #1 : Hexdump, 8 bytes 0x0A0000000E3FE9E8 : 0780 0000 04FE 6F80 ......o. 2020-04-27-07.35.23.376661-240 I224864227A479 LEVEL: Error PID : 16973950 TID : 2057 PROC : db2sysc 6 INSTANCE: db2xxxxs NODE : 006 HOSTNAME: xxxxxxxxx0 EDUID : 2057 EDUNAME: db2fcms 6 FUNCTION: DB2 UDB, fast comm manager, sqkfSendConduit::HandleConnectLostEvent, probe:30 MESSAGE : Informing node failure. link state = DATA #1 : Hexdump, 4 bytes 0x0A0000000E3FE844 : 0000 0002 .... 2020-04-27-07.35.23.376988-240 I224864707A428 LEVEL: Event PID : 16973950 TID : 2057 PROC : db2sysc 6 INSTANCE: db2xxxxs NODE : 006 HOSTNAME: xxxxxxxxx0 EDUID : 2057 EDUNAME: db2fcms 6 FUNCTION: DB2 UDB, base sys utilities, sqleSendNodeFailure, probe:6390 DATA #1 : SD: Requested synchronous member failure recovery for member = [5] with seq. no = 87 ..... ... 2020-04-27-07.36.19.607769-240 E224897726A824 LEVEL: Error PID : 16973950 TID : 77041 PROC : db2sysc 6 INSTANCE: db2xxxxs NODE : 006 DB : xxxxxx APPHDL : 6-63891 APPID: 1.2.2.1.1.2 AUTHID : ATTNYADM HOSTNAME: lxdbd2t059 EDUID : 77041 EDUNAME: db2agent (xxxxxx) 6 FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:30 MESSAGE : ADM14005E The following error occurred: "Trap". First Occurrence Data Capture (FODC) has been invoked in the following mode: "Automatic". Diagnostic information has been recorded in the directory named "/home/db2xxxxs/sqllib/db2dump/DIAG0006/FODC_Trap_20xx-xx-xx-07. 36.19 .605200_16973950_77041_006/". | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Crash recovery * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * update to Db2 11.5 Mod 4 Fixpack 0 or higher * **************************************************************** | |
Local Fix: | |
N/A | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Crash recovery * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * update to Db2 11.5 Mod 4 Fixpack 0 or higher * **************************************************************** | |
Comment | |
First fixed in Db2 11.5 Mod 4 Fixpack 0 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 15.03.2021 25.08.2021 25.08.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |