Subject | Re: [firebird-support] conflict when update table |
---|---|
Author | Milan Babuskov |
Post date | 2008-07-23T10:52:50Z |
mugi yanto wrote:
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
> Anyone can help me why my fb server raise this exception when I run my app for more than 1 machines?http://www.firebirdfaq.org/faq151
> (it works well when I run only on 1 machine)
>
> *deadlock*
> *update conflicts with concurrent update*
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