Subject | RE: [firebird-support] Re: Lock conflict |
---|---|
Author | Alan McDonald |
Post date | 2007-11-08T11:53:46Z |
> > LI-V6.3.2.4731 1.5 Classic, RedHat Enterprise, 9G databaseDoesn't the -g switch STOP garbage collection?
> >
> > In the evenings when gbak -g is running the clients are encountering
> lock
> > conflict on no wait transaction
> >
> > Deadlock
> >
> > Update conflicts with concurrent update
>
> This is a normal exception in a multi-user environment that
> has 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
>
Alan