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 -- 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
maybe duplicated row?
2016-03-14 20:34 GMT-03:00 Pierre-Adrien Coustillas
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
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
-- Niels Nes, Manager ITF, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: https://www.cwi.nl/people/niels e-mail: Niels.Nes@cwi.nl
participants (3)
-
Niels Nes -
Pierre-Adrien Coustillas -
Roberto Spadim