Subject Re: [firebird-support] server 2.5.8 deadlocked
Author Hamish Moffatt
On 13/02/18 13:07, Hamish Moffatt hamish@... [firebird-support] wrote:
 

I'm getting the Firebird 2.5 superclassic server on Linux deadlocking
regularly at the moment. Twice in one day last week, and again today
after uptime of less than 6 hours.

I just upgraded to 2.5.8 today, from 2.5.6. Our workload isn't huge, but
we do have a lot of small databases and maybe up to 100 client
connections at once.


For what it's worth, I have occasional remote connections over the Internet with latency of about 160ms (US east coast to Australia).

This is very slow with Firebird 2.5 but we only need to fetch one row from a db so it's acceptable to us.

Twice I think the deadlock condition has coincided such with a remote request.

Could this be a factor?

Hamish