DB2 - Problem description
Problem IT21717 | Status: Closed |
INSTANCE MAY PANIC WHEN TRYING TO DROP AN OBJECT IF ANOTHER AGENT HAS ACCESS ON THE OBJECT WITH ERROR TCB FIX COUNT != 1 IN DB2D | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
When dropping an object, if another agent has access to the object being dropped, the instance can panic and the following entry will be logged in db2diag.log. 2016-08-11-06.47.24.246563-300 I74175532A1462 LEVEL: Error (Origin) PID : 27198258 TID : 33654 PROC : db2sysc 27 INSTANCE: db2bofa1 NODE : 027 DB : CRD_PROD APPHDL : 130-40397 APPID: *N130.db2bofa1.160811203405 AUTHID : DBADMIN EDUID : 33654 EDUNAME: db2agntp (CRD_PROD) 27 FUNCTION: DB2 UDB, data management, sqldDropObj, probe:415 MESSAGE : TCB fix count != 1 when dropping data object! DATA #1 : String, 10 bytes FixCount: DATA #2 : Hexdump, 8 bytes 0x070000010F253080 : 0000 0000 0000 0002 ........ CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x090000000824F520 pdLog + 0xE4 [1] 0x0900000005813CD8 pdLog@glue420 + 0xFC [2] 0x0900000005F6A1E8 sqldDropObj__FP8sqeAgentP12SQLB_GLOBALSP8SQLD_TCBP16SQLB_OBJECT_ DESCi + 0x298 [3] 0x090000000820E33C sqldDropTable__FP8sqeAgentP12SQLB_GLOBALSP8SQLD_TCBi + 0x154 [4] 0x09000000047FC43C sqldDropTable__FP8sqeAgentP12SQLB_GLOBALSP8SQLD_TCBi@glue3E5 + 0x78 [5] 0x09000000062C2B0C sqldTableDrop__FP8sqeAgentUsT2UciPcT5T6T5 + 0x1F8 [6] 0x09000000043E8750 sqlrlDataPartDrop + 0x148 [7] 0x090000000441C80C sqlrldtc__FP8sqlrr_cbP16sqlkdRqstRplyFmtisP13SQLR_RPC_DTOK + 0x700 [8] 0x090000000441B65C sqlrl_rpc_dms_router__FP8sqlrr_cbP16sqlkdRqstRplyFmtiP15SQLR_RPC MESSAGE + 0x57C [9] 0x0900000004DD9E44 sqlrr_rpc_router__FP8sqlrr_cb + 0x444 .... 2016-08-11-06.47.24.420558-300 E74240548A914 LEVEL: Critical PID : 27198258 TID : 33654 PROC : db2sysc 27 INSTANCE: db2bofa1 NODE : 027 DB : CRD_PROD APPHDL : 130-40397 APPID: *N130.db2bofa1.160811203405 AUTHID : DBADMIN EDUID : 33654 EDUNAME: db2agntp (CRD_PROD) 27 FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10 MESSAGE : ADM14001C An unexpected and critical error has occurred: "Panic". The instance may have been shutdown as a result. "Automatic" FODC (First Occurrence Data Capture) has been invoked and diagnostic information has been recorded in directory "/db2dump/FODC_Panic_2016-08-11-06.47.24.419186_0027/". Please look in this directory for detailed evidence about what happened and contact IBM support if necessary to diagnose the problem. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 V11.1 m2fp2 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : IT17028 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 03.08.2017 13.10.2017 13.10.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |