Please have a careful look at https://www.monetdb.org/blog/monetdb-sql-transaction-management-scheme. regards On 13/11/15 14:45, Vijay Krishna wrote:
Hi,
I am running a setup on MonetDB where in concurrent transactions take place. Everything works very fine but for a few transactions getting aborted due to SQLExceptions.
I have set *auto commit to false* for all these transactions. I am getting frequent SQLExceptions with the message as *java.sql.SQLException: COMMIT: failed*
But if I retry the same transaction, this works fine. Any idea on what would be the reason for frequent commit fails?
When I set *auto commit to true* for the transactions, I get similarly frequent Exceptions but the message becomes *java.sql.SQLException: COMMIT: transaction is aborted because of concurrency conflicts*
Is it like both the exception thrown be for the same cause?
Any help much appreciated.
Thanks in Advance.
Vijayakrishna.P. Mobile : (+91) 9500402305.
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list