ADSM-L

A server database deadlock situation

1999-07-26 08:11:10
Subject: A server database deadlock situation
From: Henk ten Have <hthta AT SARA DOT NL>
Date: Mon, 26 Jul 1999 14:11:10 +0200
We have problems with 'Expire Inventory', which we run once every week.
(AIX server 3.2.1.20, AIX 4.2.1.0):

07/10/99   18:00:21  ANR0811I Inventory client file expiration started as
                      process 50.
...
07/11/99   03:45:32  ANR0390W A server database deadlock situation has been
                      encountered: lock request for transaction 0:786432987
                      will be denied to resolve the deadlock.
07/11/99   03:45:32  ANR9999D afutil.c(962): Lock acquisition (xLock) failed
                      for PoolId=-4, cluster SrvId=0, Ck1=753, Ck2=1
07/11/99   03:45:32  ANR1181E aftxn.c201: Data storage transaction 0:786432987
                      was aborted.
07/11/99   03:45:32  ANR2183W imexp.c2629: Transaction 0:786432987 was aborted.
07/11/99   03:45:32  ANR2369I Database backup volume and recovery plan file
                      expiration starting under process 50.
07/11/99   03:45:33  ANR0860E Expiration process 50 terminated due to internal
                      error: examined 652381 objects, deleting 365678 backup
                      objects, 0 archive objects, 0 DB backup volumes, and 0
                      recovery plan files. 0 errors were encountered.
07/11/99   03:45:33  ANR0987I Process 50 for EXPIRE INVENTORY running in the
                      BACKGROUND processed 365678 items with a completion state
                      of SUCCESS at 03:45:33.


07/24/99   18:00:21  ANR0811I Inventory client file expiration started as
                      process 408.
...
07/25/99   09:29:43  ANR0390W A server database deadlock situation has been
                      encountered: lock request for transaction 0:786982550
                      will be denied to resolve the deadlock.
07/25/99   09:29:43  ANR9999D afutil.c(962): Lock acquisition (xLock) failed
                      for PoolId=-3, cluster SrvId=0, Ck1=537, Ck2=2
07/25/99   09:29:43  ANR1181E aftxn.c201: Data storage transaction 0:786982550
                      was aborted.
07/25/99   09:29:46  ANR2183W imexp.c2629: Transaction 0:786982550 was aborted.
07/25/99   09:29:47  ANR2369I Database backup volume and recovery plan file
                     expiration starting under process 408.
07/25/99   09:29:48  ANR0860E Expiration process 408 terminated due to internal
                      error: examined 1216067 objects, deleting 1022716 backup
                      objects, 0 archive objects, 0 DB backup volumes, and 0
                      recovery plan files. 0 errors were encountered.
07/25/99   09:29:48  ANR0987I Process 408 for EXPIRE INVENTORY running in the
                      BACKGROUND processed 1022716 items with a completion
                      state of SUCCESS at 09:29:48.

Anyone see this before?

Cheers,
Henk ten Have
Academic Computing Services Amsterdam
<Prev in Thread] Current Thread [Next in Thread>