Subject Re: [firebird-support] SELECT WITH LOCK, WAIT transaction, deadlock
Author Dimitry Sibiryakov
Post date 2016-04-29T09:46:59Z
29.04.2016 11:26, Gabor Boros gaborboros@... [firebird-support] wrote:
> The transaction do other work before grab the number and after grab the
> number. The whole thing is in a (one) stored procedure. (Works like a
> charm except deadlocks.)

You need transaction with explicit exclusive lock on generator table.

--
WBR, SD.