Thanks Bryan.
I guess what I was expecting to see was the statement(s) were 50631 was
getting a lock on the MANAGED_HARDWARE_SUMMARY. I turned on statement logging
and see the issue. Your help here on how to read this output has help quite a
bit though. I did not understand that the output:
>> Granted XID : {50631, X}
meant that the transaction 50631 had acquired
>> Lock : ROW, MANAGED_HARDWARE_SUMMARY, (47,8)
Now I understand how to read this better. Thanks again!
> On Sep 2, 2015, at 7:03 PM, Bryan Pendleton <[email protected]>
> wrote:
>
>> Lock : ROW, MANAGED_HARDWARE_SUMMARY, (47,8)
>> Waiting XID : {50633, S} , CSEM, SELECT CHASSIS_9145E10G_ID, IP_STR,
>> DS.TEMPLATE, DS.SYSTEM_TEMPLATE, DS.ADMIN_ENABLED, DS.ALIAS_NAME, DS.MODEL,
>> DS.HARDWARE_VERSION, DS.ACTIVE_FIRMWARE, DS.INACTIVE_FIRMWARE, DS.BOOTCODE,
>> CONTACT, CIRCUIT, CIRCUIT_2,
>> LOCATION, HAS_MGMT_PORT, HAS_CONSOLE_PORT, POWERSUPPLY_A_MODEL,
>> POWERSUPPLY_B_MODEL, HAS_FANS, HAS_TEMP_SENSOR, HAS_USER_XFP_CONNECTOR,
>> USER_XFP_MODEL, HAS_NET_XFP_CONNECTOR, NET_XFP_MODEL, IP, SYNCHRONIZING,
>> LAST_SYNCHRONIZED_TIMESTAMP, CREATED_TIMESTAMP,
>> ADMIN_STATE_TIMESTAMP, MACADDRESS_STR, PEER_MACADDRESS_STR, ZTP_STAGED,
>> ZTP_STAGED_TIMESTAMP, ZTP_PROVISIONING_STATE,
>> ZTP_PROVISIONING_STATE_TIMESTAMP, R2_MODEL FROM --DERBY-PROPERTIES
>> joinOrder=FIXED
>> PKG_9145E10G.DEVICE_SUMMARY DS JOIN CORE_V1.MANAGED_HARDWARE_SUMMARY MHS ON
>> DS.CHASSIS_9145E10G_ID = MHS.MANAGED_HARDWARE_ID WHERE
>> DS.CHASSIS_9145E10G_ID = ?
>> Granted XID : {50631, X}
>
> 50631 has an exclusive lock on row 8 of page 47 of table
> MANAGED_HARDWARE_SUMMARY.
>
> 50633 is trying to get a share lock on that same row, and is hence blocked.
>
>> Lock : ROW, DEVICE_SUMMARY, (4,8)
>> Waiting XID : {50631, X} , CSEM, UPDATE PKG_9145E10G.DEVICE_SUMMARY SET
>> ZTP_STAGED_TIMESTAMP = ?, ZTP_STAGED = ? WHERE (ID = ?)
>> Granted XID : {50633, S}
>
> 50633 has a share lock on row 8 of page 4 of table DEVICE_SUMMARY.
>
> 50631 is trying to get an exclusive lock on that same row,
> and is hence blocked.
>
> So in the MANAGED_HARDWARE_SUMMARY table, 50633 is waiting on 50631.
>
> And in the DEVICE_SUMMARY table, 50631 is waiting on 50633.
>
> Deadlock.
>
> thanks,
>
> bryan
>
>
Canoga Perkins
20600 Prairie Street
Chatsworth, CA 91311
(818) 718-6300
This e-mail and any attached document(s) is confidential and is intended only
for the review of the party to whom it is addressed. If you have received this
transmission in error, please notify the sender immediately and discard the
original message and any attachment(s).
