Subject Re: [firebird-support] conflict when update table
Author Milan Babuskov
mugi yanto wrote:
> Anyone can help me why my fb server raise this exception when I run my app for more than 1 machines?
> (it works well when I run only on 1 machine)
>
> *deadlock*
> *update conflicts with concurrent update*

http://www.firebirdfaq.org/faq151

In short, when two transactions are updating the same record at the same
time, one of them has to fail - to ensure data consistency. You should
treat deadlock as 'regular' events and handle them properly (depending
on the application type, it should either retry the operation or give up
or do something else).

--
Milan Babuskov
http://www.guacosoft.com