I am trying to execute in parallel a few queries in MonetDB.

I have read in the documentation that Monet uses the OCC transaction model so read operations should not block the table.

I have 3 CREATE TABLE queries that read from the same source table, I launch 3 different mclient processes and launch one query on each client.

The queries execute in parallel as expected, I can see them running in sys.queue().

The first query that completes, creates the table and commits fine. When the other two queries finish their job I can see the message “operation successful” but right after the client prints "COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead”.

What am I doing wrong? Apart from the newly created table, I did non write anything to the db so it should work fine.

Any suggestion would be much appreciated,

Thanks,

Stefano