On 11/5/20 2:24 PM, Dimitry Sibiryakov wrote:
05.11.2020 12:10, Alex Peshkoff via Firebird-devel wrote:
They want to modify same record. When that happens in 2 different transactions, started from 2 different attachments (specially pay attention that one is started and committed in DFW of another one) - you see, deadlock is unavoidable.

  Why deadlock if it is an ordinary update conflict? Starting NOWAIT transaction in plugin would be a natural solution, no?

That will resolve a conflict but will not make user's code work as expected and as it does with separate sec.db.


The only issue is that it's high time to rewrite everything related to metadata in this plugin to make it use FB_MESSAGE instead local templates - it was written before FB_MESSAGE arrived.

  I see FB_MESSAGE already used in SrpServer, reusing it in SrpManagement shouldn't be so hard but still ugly.





Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to