Re: [Firebird-devel] Stuck transaction in 2.5.6

2016-09-27 Thread Jiří Činčura
>Yes, send it to me. But better is to have reproducible example, or, at > least, memory dump before attachments are killed - i.e. when transaction > stuck is detected. Sending link privately. When that happens again I'll try to take the dump early. > PS Stack shows that EXECUTE STATEMENT is u

Re: [Firebird-devel] Stuck transaction in 2.5.6

2016-09-27 Thread Vlad Khorsun
26.09.2016 13:02, Jiří Činčura wrote: > Hi *, > > I've had quite a few occurrences of transaction being stuck on Firebird > 2.5.6 in last 7 days. Even trying to close the connection from > monitoring tables was not working. I had to kill the process. > > I was able to take a dump (actually 2, from

[Firebird-devel] Stuck transaction in 2.5.6

2016-09-26 Thread Jiří Činčura
Hi *, I've had quite a few occurrences of transaction being stuck on Firebird 2.5.6 in last 7 days. Even trying to close the connection from monitoring tables was not working. I had to kill the process. I was able to take a dump (actually 2, from different processes), but given it's a production