Carsten_Schmitz

U000006 DEADLOCK: All WP try to update EH, anyone had this before?

Discussion created by Carsten_Schmitz on Jan 10, 2018
Latest reply on Jan 10, 2018 by Carsten_Schmitz
Hi,

We just had an outage of our production AE system (in it's last weeks of being a version 10.0.3+hf2), because all WP tried to do this simultaneously:

SELECT EH.*,ROWID FROM EH WHERE EH_AH_Idnr = :A0001 FOR UPDATE

Deadlock hilarity ensued, no new jobs could be started, and the "Messages" window printed nothing but "U000006: DEADLOCK".

I resolved it by killing all but one WP. I was then able to restart the WP and the problem was gone.

An incident has been filed with Automic, but out of curiosity: Anyone had this before?

Cheers,
Carsten

Outcomes