Subject | Finding a deadlocked transaction |
---|---|
Author | PenWin |
Post date | 2011-04-14T09:03:07Z |
Hi!
Is there some way to list currently active transaction on a given
database? I keep getting a deadlock at a certain place in my code, and I
can quite understand *why* I am getting it, but I just can't find which
transaction is left active - obviously I am overlooking one, but I just
can't find it, everywhere I look, I see started transactions properly
committed (or rollbacked). So I thought I would place breakpoints at
critical moments of my code, listing active transactions at each
breakpoint, until I located the forgotten transaction.
I had great hopes in the -list parameter of gfix, but apparently I don't
have any limbo transactions, even just before I get the deadlock :-(
Pepak
Is there some way to list currently active transaction on a given
database? I keep getting a deadlock at a certain place in my code, and I
can quite understand *why* I am getting it, but I just can't find which
transaction is left active - obviously I am overlooking one, but I just
can't find it, everywhere I look, I see started transactions properly
committed (or rollbacked). So I thought I would place breakpoints at
critical moments of my code, listing active transactions at each
breakpoint, until I located the forgotten transaction.
I had great hopes in the -list parameter of gfix, but apparently I don't
have any limbo transactions, even just before I get the deadlock :-(
Pepak