[firebird-support] Commit MON$TRANSACTIONS by TRANSACTION_ID

[Jaume Llunell Gómez [e-mail] [firebird-support]]

Hi,

is it possible to commit a transaction that is hanged in the
MON$TRANSACTION table by ID?

I've seen that i can close a connection in MON$ATTACHMENTS by deleting a
record, but if i want to commit some of the transactions of this hanged
connection, can i do it in any way?

Thank you
Jaume

[Dimitry Sibiryakov [e-mail] [firebird-support]]

Post by Jaume Llunell Gómez ***@gmail.com [firebird-support]
can i do it in any way?

No.

[liviuslivius [e-mail] [firebird-support]]

Hi,
 
did you mean rollback? not commit?
 
regards,
Karol Bieniaszewski
 
W dniu 2016-12-14 17:44:16 uÅŒytkownik Jaume Llunell Gómez ***@gmail.com [firebird-support] <firebird-***@yahoogroups.com> napisał:
 
Hi,
 
is it possible to commit a transaction that is hanged in the MON$TRANSACTION table by ID?
 
I've seen that i can close a connection in MON$ATTACHMENTS by deleting a record, but if i want to commit some of the transactions of this hanged connection, can i do it in any way?
 
Thank you
Jaume

 

[Jaume Llunell Gómez [e-mail] [firebird-support]]

Well I would prefere to do a commit in this case. It's a hanged connection
because power went out and could not commit some large transaction.

But i guess i can't do it as they answer it.

Thanks anyway
Jaume

Post by liviuslivius ***@poczta.onet.pl [firebird-support]
Hi,
did you mean rollback? not commit?
regards,
Karol Bieniaszewski
W dniu 2016-12-14 17:44:16 uŌytkownik Jaume Llunell Gómez
Hi,
is it possible to commit a transaction that is hanged in the
MON$TRANSACTION table by ID?
I've seen that i can close a connection in MON$ATTACHMENTS by deleting a
record, but if i want to commit some of the transactions of this hanged
connection, can i do it in any way?
Thank you
Jaume