Re: [firebird-support] lock conflict deadlock

2016-04-05 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Sergio, Definitely there should transaction which produces conflict, probably your query does not catch it. You can track it with Monlogger - download HQbird, install it and register as trial (14 days), then connect with MonLogger to your database and at the moment of error message click

Re: [firebird-support] lock conflict deadlock

2016-04-05 Thread shg_siste...@yahoo.com.ar [firebird-support]
sorry, I just copied a part of the select in the message. I do include that flag in the actual select. Here it is the complete select. I'm sending '-1' in "in_trans" select ma.mon$attachment_id, mt.mon$transaction_id, ma.mon$server_pid,

Re: [firebird-support] lock conflict deadlock

2016-04-05 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Hi,   chow do you check that transaction is readonly? in your select this field is not included   regards, karol Bieniaszewski     W dniu 2016-04-05 15:29:11 użytkownik shg_siste...@yahoo.com.ar [firebird-support] napisał:   Hello! I'm having a problem which I