G
George Potemkin
Guest
9.1E is old version. It has the issue with jump notes in bi file. Just a guess: one of the remote sessions undoes a large transaction that, for example, deletes a lot of records. Undo restores these records and locks them until the end of undo. It causes the "lock wait timeout" errors. If undo faced the jump notes then it makes the server that serves the session very busy. It causes the "unresolved pending connections". Check db log for transaction backout messages with long time between begin and end phases. During new incident check the current activity: if bi reads exceed bi writes then it caused the jump notes. MTX latch will often owned by the client that undoes its transaction.
Continue reading...
Continue reading...