DB2 - Problem description
Problem IC75164 | Status: Closed |
CRASH AFTER APPLYING CONNECTION CONCENTRATOR | |
product: | |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 | |
Problem description: | |
The instance may crash after using connection concentrator. The affected platforms are HP and Linux. If you encounter this problem, the following db2diag.log messages will appear, and the instance will go down. The key message to watch out for is the errno at the probe 15 of sqeDomainSocketPair::WriteConn. If the errno is 0xB (11), then you have encountered this problem. 2011-03-21-09.05.02.438346+540 I4253A417 LEVEL: Severe PID : 1190 TID : 1 PROC : db2agent (SAMPLE) INSTANCE: DB2INST1 NODE : 000 APPID : 111.222.333.444.37043.110319210800 AUTHID : DB2USER FUNCTION: DB2 UDB, base sys utilities, sqeDomainSocketPair,WriteConn, probe:10 RETCODE : ZRC=0x80050158=-2147155624=SQLE_RC_SYSTEM_ERR "Unexpected system error." 2011-03-21-09.05.02.438788+540 I4671A439 LEVEL: Severe PID : 1190 TID : 1 PROC : db2agent (SAMPLE) INSTANCE: DB2INST1 NODE : 000 APPID : 111.222.333.444.37043.110319210800 AUTHID : DB2USER FUNCTION: DB2 UDB, base sys utilities, sqeDomainSocketPair::WriteConn, probe:15 MESSAGE : Errno = DATA #1 : Hexdump, 4 bytes 0x9FFFFFFFFFFF8A54 : 0000 000B 2011-03-21-09.05.02.439065+540 I5111A447 LEVEL: Severe PID : 1190 TID : 1 PROC : db2agent (SAMPLE) INSTANCE: DB2INST1 NODE : 000 APPID : 192.168.0.206.37043.110319210800 AUTHID : DB2USER FUNCTION: DB2 UDB, base sys utilities, sqeConnQueueAgentEndPoint::EnqueueConn, probe:10 MESSAGE : Errno = DATA #1 : Hexdump, 4 bytes 0x9FFFFFFFFFFF8B10 : 0000 0009 <snipped...> 2011-03-21-09.05.02.612298+540 I11776A437 LEVEL: Severe PID : 1190 TID : 1 PROC : db2agent (SAMPLE) INSTANCE: DB2INST1 NODE : 000 APPID : 111.222.333.444.37043.110319210800 AUTHID : DB2USER FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10 MESSAGE : sqle_panic: Panic/sleep = The following is the sack of panickng agent. (5) 0xc000000000429350 _kill + 0x30 [/usr/lib/hpux64/libc.so.1 (6) 0xc000000016f5bea0 sqloDumpEDU + 0x40 [/TOOLS/NPPDDB2/lib6 (7) 0xc00000001685cc60 _Z10sqle_panicv + 0xe0 [/TOOLS/NPPDDB2/ (8) 0xc0000000169574d0 _ZN25sqeConnQueueAgentEndPoint11Enqueue ConnEP19sqle_coordinator_cb + 0x1f0 [/TOOLS/NPPDDB2/lib64/libdb (9) 0xc00000001694ece0 _ZN17sqeConnDispatcher20XferConnToDispa tcherEP19sqle_coordinator_cb + 0x140 [/TOOLS/NPPDDB2/lib64/libd (10) 0xc00000001693c340 _ZN15sqeConcentrator22XferConnToConcent ratorEP19sqle_coordinator_cb + 0x100 [/TOOLS/NPPDDB2/lib64/libd | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Version 91 on HPUX and Linux with concentrator enabled. * **************************************************************** * PROBLEM DESCRIPTION: * * DB2 v91 may panic leading to a crash with connection * * concentrator turned on for Linux and HP platforms. * **************************************************************** * RECOMMENDATION: * * Upgrade to version v91fp11. * **************************************************************** | |
Local Fix: | |
If you encounter this problem, disable the connection concentrator until the fix is installed. | |
available fix packs: | |
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows | |
Solution | |
db2 version 91 fixpack 11 includes the fix for this issue. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 22.03.2011 20.12.2011 20.12.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.1.FP11 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.1.0.11 |