postgresql-interfaces/psqlodbc GitHub issues and pull requests (mirror)help / color / mirror / Atom feed
[postgresql-interfaces/psqlodbc] issue #31: While executing more than 2 queries in single transaction giving MSG: internal SAVEPOINT failed 3+ messages / 2 participants [nested] [flat]
* [postgresql-interfaces/psqlodbc] issue #31: While executing more than 2 queries in single transaction giving MSG: internal SAVEPOINT failed @ 2024-07-08 17:54 "ajayn249 (@ajayn249)" <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: ajayn249 (@ajayn249) @ 2024-07-08 17:54 UTC (permalink / raw) To: postgresql-interfaces/psqlodbc <[email protected]> 1865:[7f750f6af500]statement.[ParseAndDescribeWithLibpq]2948: entering plan_name=_PLAN0x243f340 query=SAVEPOINT PIPECMD 1868:[7f750f6af500]statement.[ParseWithLibpq]2809: entering plan_name=_PLAN0x243f340 query=SAVEPOINT PIPECMD 1912:[7f750f6af500]connection[CC_send_query_append]1809: conn=0x24253d0, query='DEALLOCATE "_PLAN0x243f340"' 1969:[7f750f6af500]connection[CC_send_query_append]1809: conn=0x24253d0, query='SAVEPOINT _EXEC_SVP_0x24253d0' 1995:[7f750f6af500]statement.[ParseAndDescribeWithLibpq]2948: entering plan_name=_PLAN0x243f340 query=select count() from carrier 1998:[7f750f6af500]statement.[ParseWithLibpq]2809: entering plan_name=_PLAN0x243f340 query=select count() from carrier 2051:[7f750f6af500]connection[CC_send_query_append]1809: conn=0x24253d0, query='DEALLOCATE "_PLAN0x243f340"' 2118:[7f750f6af500]statement.[ParseAndDescribeWithLibpq]2948: entering plan_name=_PLAN0x243f340 query=ROLLBACK TO PIPECMD 2121:[7f750f6af500]statement.[ParseWithLibpq]2809: entering plan_name=_PLAN0x243f340 query=ROLLBACK TO PIPECMD 2165:[7f750f6af500]connection[CC_send_query_append]1809: conn=0x24253d0, query='DEALLOCATE "_PLAN0x243f340"' 2231:[7f750f6af500]statement.[ParseAndDescribeWithLibpq]2948: entering plan_name=_PLAN0x243f340 query=RELEASE SAVEPOINT PIPECMD 2234:[7f750f6af500]statement.[ParseWithLibpq]2809: entering plan_name=_PLAN0x243f340 query=RELEASE SAVEPOINT PIPECMD 2278:[7f750f6af500]connection[CC_send_query_append]1809: conn=0x24253d0, query='DEALLOCATE "_PLAN0x243f340"' 2343:[7f750f6af500]statement.[ParseAndDescribeWithLibpq]2948: entering plan_name=_PLAN0x243f340 query=SAVEPOINT PIPECMD 2346:[7f750f6af500]statement.[ParseWithLibpq]2809: entering plan_name=_PLAN0x243f340 query=SAVEPOINT PIPECMD 2390:[7f750f6af500]connection[CC_send_query_append]1809: conn=0x24253d0, query='DEALLOCATE "_PLAN0x243f340"' 2447:[7f750f6af500]connection[CC_send_query_append]1809: conn=0x24253d0, query='RELEASE _EXEC_SVP_0x24253d0;SAVEPOINT _EXEC_SVP_0x24253d0' 2467:[7f750f6af500]connection[CC_send_query_append]1809: conn=0x24253d0, query='ROLLBACK' 2548:[7f750f6af500]connection[CC_send_query_append]1809: conn=0x24253d0, query='BEGIN 2572:[7f750f6af500]statement.[ParseAndDescribeWithLibpq]2948: entering plan_name=_PLAN0x243f340 query=ROLLBACK TO PIPECMD 2575:[7f750f6af500]statement.[ParseWithLibpq]2809: entering plan_name=_PLAN0x243f340 query=ROLLBACK TO PIPECMD While executing 3rd query 'RELEASE _EXEC_SVP_0x24253d0;SAVEPOINT _EXEC_SVP_0x24253d0' is coming and letting it to ROLLBACK and because of this SAVEPOINT _EXEC_SVP_0x24253d0 is giving error for MSG: internal SAVEPOINT failed. In code i have observed in file execute.c #ifdef _RELEASE_INTERNAL_SAVEPOINT is defined which is actually responsible for RELEASE _EXEC_SVP_0x24253d0 command to execute. Macro is defined in connection.h file. If i dont want to use RELEASE query or undefined that macro how i can do that.???? Is there any alternative way i can avoid this. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [postgresql-interfaces/psqlodbc] issue #31: While executing more than 2 queries in single transaction giving MSG: internal SAVEPOINT failed @ 2024-07-10 13:43 ` "davecramer (@davecramer)" <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: davecramer (@davecramer) @ 2024-07-10 13:43 UTC (permalink / raw) To: postgresql-interfaces/psqlodbc <[email protected]> What is the code you are trying to execute ? ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [postgresql-interfaces/psqlodbc] issue #31: While executing more than 2 queries in single transaction giving MSG: internal SAVEPOINT failed @ 2024-07-10 17:33 ` "ajayn249 (@ajayn249)" <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: ajayn249 (@ajayn249) @ 2024-07-10 17:33 UTC (permalink / raw) To: postgresql-interfaces/psqlodbc <[email protected]> [TestBaseMain.txt](https://github.com/user-attachments/files/16166988/TestBaseMain.txt) This is the code where we are simply creating savepoint executing query rolling back savepoint executing query rolling back savepoint executing query rolling back Also find the attached logs [mylog_TestBaseMain_ssuser1668331.log](https://github.com/user-attachments/files/16166944/mylog_TestBaseMain_ssuser1668331.log) This is odbc logs ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-07-10 17:33 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-07-08 17:54 [postgresql-interfaces/psqlodbc] issue #31: While executing more than 2 queries in single transaction giving MSG: internal SAVEPOINT failed "ajayn249 (@ajayn249)" <[email protected]> 2024-07-10 13:43 ` "davecramer (@davecramer)" <[email protected]> 2024-07-10 17:33 ` "ajayn249 (@ajayn249)" <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox