why "INSERT INTO ... SELECT" is concurrency conflicts with "CREATE TABLE"
Hi,
Why is that the query INSERT INTO io__selection_top (id_navigateur) SELECT id_navigateur FROM bdm__index_client_cookies_id_navigateur;
has a "COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead"
whith this query : DROP TABLE pierre;
What is the table that a conflict ? SYS.TABLES ?
Thanks
Pierre
maybe duplicated row?
2016-03-14 20:34 GMT-03:00 Pierre-Adrien Coustillas pcoustillas@1g6.biz:
Hi,
Why is that the query INSERT INTO io__selection_top (id_navigateur) SELECT id_navigateur FROM bdm__index_client_cookies_id_navigateur;
has a "COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead"
whith this query : DROP TABLE pierre;
What is the table that a conflict ? SYS.TABLES ?
Thanks
Pierre
-- 1G6 52 route de bischwiller 67300 Schiltigheim Société de Services et de Formations en Logiciels Libres http://1g6.biz Tél : 06 64 63 70 35 // 09 54 38 70 90
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
On Mon, Mar 14, 2016 at 10:02:54PM -0300, Roberto Spadim wrote:
maybe duplicated row?
The reason is that 'ddl' statements (such as the drop table) trigger a schema change which at the moment will always conflict with other updating transactions.
Niels
2016-03-14 20:34 GMT-03:00 Pierre-Adrien Coustillas < pcoustillas@1g6.biz>:
Hi, Why is that the query INSERT INTO io__selection_top (id_navigateur) SELECT id_navigateur FROM bdm__index_client_cookies_id_navigateur; has a "COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead" whith this query : DROP TABLE pierre; What is the table that a conflict ? SYS.TABLES ? Thanks Pierre -- 1G6 52 route de bischwiller 67300 Schiltigheim Société de Services et de Formations en Logiciels Libres http://1g6.biz Tél : 06 64 63 70 35 // 09 54 38 70 90 _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list-- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (3)
-
Niels Nes -
Pierre-Adrien Coustillas -
Roberto Spadim