Hi,

I have written a multi-threaded app that consumes multiple logs simultaneously and generates DDL/DML statements for monetdb.

It uses JDBC and the threads write to a single table.

However I am getting "COMMIT: transaction is aborted because of concurency conflicts, will ROLLBACK instead" very frequently. Also when it retries the insert there is some inconsistency that I have not been able to try and debug yet. Eventually there are more rows than inserts. Weird thing is I also have a unique key constraint on the table.

I am guessing this happen as monetdb doesn't use locking for serialization.