[144] in Moira
dcm INGRES ERROR 5932
daemon@ATHENA.MIT.EDU (Mark Rosenstein)
Fri Aug 3 11:28:51 1990
Date: Fri, 3 Aug 90 11:27:56 -0400
From: Mark Rosenstein <mar@MIT.EDU>
To: jtkohl@ATHENA.MIT.EDU
Cc: jtkohl@CRL.DEC.COM, bug-moira@ATHENA.MIT.EDU
In-Reply-To: John T Kohl's message of Fri, 3 Aug 90 07:07:41 -0400 <9008031107.AA13740@LYCUS.MIT.EDU>
*DO*NOT* set autocommit on in the Moira server. This causes each quel
operation to be treated as a commitable transaction, rather than the
groups of operations between "begin transaction" and "end transaction"
as Moira expects them to be treated. Doing this will produce a
corrupt database in short order. For example, Moira will start a
transaction, go allocate ID's for a new object to store, then it might
discover a conflict and abort the transaction. If autocommit is on,
the ID's it allocated will stay allocated even though it failed to
create the new object. There are worse things that can happen during
delete and register user operations.
For now, the workaround that I've been suggesting is to just remove
the "set lockmode" statements. This way, there is a chance of
deadlock, but the database can't get corrupted.
-Mark
