Subject | RE: [firebird-support] Re: Lock conflict |
---|---|
Author | bogdan |
Post date | 2007-11-08T11:49:55Z |
> LI-V6.3.2.4731 1.5 Classic, RedHat Enterprise, 9G databaselock
>
> In the evenings when gbak �g is running the clients are encountering
> conflict on no wait transactionThis is a normal exception in a multi-user environment that has
>
> Deadlock
>
> Update conflicts with concurrent update
absolutely nothing to do with gbak. It means two concurrent
transactions are trying to modify or delete the same record.
A backup only reads data (so no risk of lock conflict). A restore must
be done with exclusive access, so again no risk of lock conflict.
Adam
This particular table is being accessed all day, but only between 22.00 and
24:00 when gbak �b �g is running and there are approximately 3 users
connected (otherwise 30 � 50) the problem arises, so i assume that this two
things are correlated.
Regards Bogdan
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.503 / Virus Database: 269.15.24/1117 - Release Date: 7.11.2007
22:52
[Non-text portions of this message have been removed]