Date: 2010-04-08 03:02:06 +0200
From: @grobian
To: SQL devs <>
Version: 2.40.1 (Oct2010) [obsolete]

Last updated: 2011-03-28 17:31:32 +0200

Comment 13194

Date: 2010-04-08 15:02:06 +0200
From: @grobian

When batching the airtraffic database (air3 file) using a prepared statement to the server, a transaction rollback happens when the server is in autocommit mode. When not in autocommit mode, the loading process finishes successfully.
Also when commits are done inbetween the batches a transaction abort failure is returned. It feels like a commit in the process makes every next exec fail.

The attached java file can be compiled using:
% javac PrepareBatchCrash.java
And then run:
% java -cp .:$INSTALL_DIR/share/MonetDB/lib/monetdb-1.14-jdbc.jar PrepareBatchCrash "jdbc:monetdb://localhost/somedb?user=monetdb&password=monetdb" /var/tmp/air3

You can find the air3 file in /var/tmp on volund

Comment 13195

Date: 2010-05-04 09:32:09 +0200
From: Pseudo user for Sourceforge import <>

This bug was previously known as tracker item 2983861 at http://sourceforge.net/support/tracker.php?aid=2983861

Comment 15427

Date: 2011-01-25 15:19:38 +0100
From: @grobian

This bug has to do with the cleanup of prepared handles on the server. It has been improved and fixed in the current development branch.

Comment 15629

Date: 2011-03-28 17:31:32 +0200
From: @sjoerdmullender

The Mar2011 version has been released.