Subject AW: [firebird-support] RE: Firebird SuperClassic hangs
Author Paul Beach
<<that's the question, that I have: How to find out what causes the deadlock scans. I have thousands of transactions per minutes,
doing all possible kind of things. What to look for? Where?>>

Thats what a lock print is for - when it "hangs the next time" get a lock print
fb_lock_print -a -d database > lock.txt
Once you have it - you can analyse it.

https://www.ibphoenix.com/resources/documents/how_to/doc_402
http://www.ibphoenix.com/files/conf2011/Lock-Print-Yemanov-2011.pdf

Regards
Paul