Hi,

It is not possible to create multiple tables simultaneously, because this causes a transaction conflict on the table sys.tables.

If you log the error messages you see

!40000!COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead

Pierre

---

De: "Anthony Damico" <ajdamico@gmail.com>
À: "Communication channel for MonetDB users" <users-list@monetdb.org>
Envoyé: Vendredi 25 Mars 2016 17:28:49
Objet: simultaneously-created tables not generating

i have three clients connected to one mserver.  they are simultaneously running these three commands, which share table `z` but not the x or y tables--

CREATE TABLE y1 AS SELECT x1.* FROM x1 LEFT JOIN SELECT col FROM Z ON x1.id = z.id WITH DATA ;

CREATE TABLE y2 AS SELECT x2.* FROM x2 LEFT JOIN SELECT col FROM Z ON x2.id = z.id WITH DATA ;

CREATE TABLE y3 AS SELECT x3.* FROM x3 LEFT JOIN SELECT col FROM Z ON x3.id = z.id WITH DATA ;

when all three commands complete, tables y2 and y3 do not exist

if i run the commands sequentially, everything works.

am i making a mistake in how sql transactions should behave, or is this potentially a bug that i should figure out how to reproduce for bugzilla?

thanks!

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list