|Subject||RE: [firebird-support] Re: Lock conflict|
> > LI-V18.104.22.16831 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
> > 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.
> 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