IBM Support

Federation Server flash catch caused deadlock

Troubleshooting


Problem

Federation Server flash catch caused deadlock. If if this happens, the applications will hang.

Symptom

When a deadlock occurs, you see the error message below reported
in db2diag.log:

2011-12-26-02.44.33.229005-300 I2314012968E474 LEVEL: Error
PID : 11676 TID : 47258607282496PROC :
db2sysc 1
INSTANCE: nyqxt160 NODE : 001 DB : ATHENA
EDUID : 115 EDUNAME: db2dlock (ATHENA) 1
FUNCTION: DB2 UDB, lock manager, sqlpKillIfWaiting, probe:670
DATA #1 : <preformatted>
Cannot kill deadlock victim (with DLpriority 50 tidhdl 123
tentryState 4 holder_hdl 34) because it is doing rollback or
commit.

From the db2pd output, you can see lock contention on FEDServerNm as shown below:

94081 [001-28545] 34 5B160000000000000000000073
FEDServerNm ..S ..X C 312021 db2ts MSDB2
10.172.100.232.15750.1112260741

The stack of hanging agent can be like the following example:

semtimedop + 0x000a
sqloWaitEDUWaitPost + 0x0199
_Z8sqlplfndP9sqeBsuEduP14SQLP_LOCK_INFOP8SQLP_LCBP9SQLP_LHSHP15S
QLP_LTRN_CHAINP8SQLP_LRBSA_P8SQLP_AWBbb + 0x112c
_Z7sqlplrqP9sqeBsuEduP14SQLP_LOCK_INFO + 0x0cd9
_Z16sqlqgFlushServerPhPvS_ + 0x00be
_ZN14UnfencedServer20flush_cached_objectsEv + 0x0080
_ZN15UnfencedWrapper20flush_cached_serversEv + 0x007b
_ZN15UnfencedWrapper20flush_cached_objectsEv + 0x0091
_Z16sqlqgFedRollbackP8sqeAgentP12SQLQG_F2PC_Tm + 0x0997
_Z8sqlpxrbkP8sqeAgentP15SQLXA_CALL_INFOPiP9SQLP_GXIDPP11sqlo_xla
tch + 0x07d7
_Z8sqlrkrbkP8sqlrr_cbP15SQLXA_CALL_INFOi + 0x025f
_Z12sqlrrbck_dpsP8sqlrr_cbiiiP15SQLXA_CALL_INFOP9SQLP_GXIDb +
0x0a22
_Z8sqlrrbckP8sqlrr_cbiiiiP15SQLXA_CALL_INFO + 0x0546
_Z21sqlrr_rds_common_postP14db2UCinterfaceiil + 0x1797
_Z14sqlrr_execimmdP14db2UCinterfaceP16db2UCprepareInfo + 0x014c
_Z19sqljs_ddm_excsqlimmP14db2UCinterfaceP13sqljDDMObject +
0x00fa
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
Cinterface + 0x03d5
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x035b
_Z19sqljsDrdaAsSPDriverP14db2UCconHandleP17SQLCC_COMHANDLE_TPPhl
+ 0x0278
_Z24sqlerInvokeFencedRoutineP13sqlerFmpParms + 0x0713
_Z18sqlriInvokeInvokerP10sqlri_ufobb + 0x0753
_Z9sqlricallP8sqlrr_cb + 0x0122
_Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x00eb
_Z29sqlrr_process_execute_requestP8sqlrr_cbi + 0x1948
_Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x0115
_Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject +
0x04e7
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
Cinterface + 0x007d
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x035b

[{"Product":{"code":"SS2K5T","label":"InfoSphere Federation Server"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Runtime","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF012","label":"IBM i"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.5;9.7;10.1;10.5","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
25 April 2025

UID

swg21694704

Page Feedback