Subject | AW: [firebird-support] RE: Firebird SuperClassic hangs |
---|---|
Author | Paul Beach |
Post date | 2017-05-09T13:26:01Z |
<<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
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