MON$TRANSACTION not returning the expected transactions in combination with C# UDR ----------------------------------------------------------------------------------
Key: CORE-6455 URL: http://tracker.firebirdsql.org/browse/CORE-6455 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0.7 Environment: win64 Reporter: Alexander Muylaert Attachments: 2020-11-30 19_49_11-[#CORE-6455] MON$TRANSACTION not returning the expected transactions in combinat.png Hi I have mon$transactions completely not returning what I expect it to return. I do understand that mon are snapshot tables and I understand the consequences. I also can't simply simulate it, I can easily show it and attached is a logfile. The problem is that I have a Tx open, but the mon$ is NOT returning this Tx. Because I have a setup with a Db and a Bulk db, I'm accessing mon$transactions through an SP that uses autonomous transactions to get the list of current transactions. This should solve the problem with the snapshot as well. t1: I open Tx1 t2: I open Tx2, call function in c# Udr, this asks to the db a list of active transactions. This call uses autonomous Tx to get a list from mon^transactions. But Tx1 is not returned. I honestly can't see why and both Jiri Cincure (guy from ado.net and c# udr) are done a bit with debugging. Do you mind having a quick look at this explanation and the attached log file? -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel