[710] in Moira
Deadlock bug during AFS.incr
daemon@ATHENA.MIT.EDU (Darrin E. Robinson)
Fri Mar 11 17:17:16 1994
To: bug-moira@MIT.EDU
Cc: gio@MIT.EDU
Date: Fri, 11 Mar 94 17:16:59 EST
From: Darrin E. Robinson <darrin@MIT.EDU>
From the critical log file... (moira2:/moira/critical.log)
Feb 4 12:49:29 <9326> Couldn't retrieve full membership of list ug-chair: Database deadlock; try again later
caused the group to not be updated in AFS... AFS.incr did run but got the
deadlock and didn't do the incremental;
Feb 4 12:48:19 moirad[#3299]: query[2]: "get_list_info", "ug-chair"
Feb 4 12:48:19 moirad[#3299]: Query complete.
Feb 4 12:49:00 moirad[#3299]: query[2]: "get_alias", "ace_type", "TYPE", "*"
Feb 4 12:49:00 moirad[#3299]: Query complete.
Feb 4 12:49:19 moirad[#3299]: query[2]: "update_list", "ug-chair", "ug-chair","1", "0", "0", "1", "1", "create unique GID", "LIST", "ug-chair", "Chair of theUnderground Guide"
Feb 4 12:49:20 moirad[#3299]: setting ID gid to 1897
Feb 4 12:49:20 moirad[#3299]: setting ID list_id to 38862
Feb 4 12:49:22 moirad[#3299]: Query complete.
Feb 4 12:49:22 afs.incr: Creating visible group ug-chair (gid 1897)
moirad[#3299]: Closed connection (now 1 client, 10932 new queries, 0 old)
Feb 4 12:49:27 moirad[#3304]: New connection from 18.72.0.22 port 2101 (now 2 c
lients)
Feb 4 12:49:27 moirad[#3304]: auth[2]: "\004\007\002ATHENA.MIT.EDU", "afs.incr"
Feb 4 12:49:28 moirad[#3304]: Auth to sms@ATHENA.MIT.EDU using afs.incr, uid 10
284 cid -32876
Feb 4 12:49:28 moirad[#3304]: query[2]: "get_end_members_of_list", "ug-chair"
Feb 4 12:49:28 moirad[#3304]: INGRES deadlock detected
Feb 4 12:49:28 moirad[#3304]: Database deadlock; try again later (Query failed)
Feb 4 12:49:28 moirad[#3304]: Query complete.
Feb 4 12:49:29 afs.incr: Couldn't retrieve full membership of list ug-chair: Da
tabase deadlock; try again later
moirad[#3304]: Closed connection (now 1 client, 10933 new queries, 0 old)
Darrinp
