COMMIT: transaction is aborted because of concurency conflicts, will ROLLBACK instead
Hello,
is this a bug or a feature I do not understand ?
I have a script bash : ------------------------------------
pcoustillas@monetdb:~$ cat bug_commit.sh #!/bin/bash
i=1
while [ $i -le 3 ] do create="CREATE TABLE tmp_schampy_odc__lemondeclient_$i AS ( SELECT datamart__lemonde.id_unique, ( departement IN ( '08','10','67','42','10','15' ) ) AS top_departement FROM datamart__lemonde ) WITH DATA " echo $create mclient lemonde --statement="$create" &
i=$(($i+1))
done ------------------------------------ I monetdb restarts before : service monetdb5-sql stop ; sleep 10 ; service monetdb5-sql start
And i run script :
pcoustillas@monetdb:~$ ./bug_commit.sh CREATE TABLE tmp_schampy_odc__lemondeclient_1 AS ( SELECT datamart__lemonde.id_unique, ( departement IN ( '08','10','67','42','10','15' ) ) AS top_departement FROM datamart__lemonde ) WITH DATA CREATE TABLE tmp_schampy_odc__lemondeclient_2 AS ( SELECT datamart__lemonde.id_unique, ( departement IN ( '08','10','67','42','10','15' ) ) AS top_departement FROM datamart__lemonde ) WITH DATA CREATE TABLE tmp_schampy_odc__lemondeclient_3 AS ( SELECT datamart__lemonde.id_unique, ( departement IN ( '08','10','67','42','10','15' ) ) AS top_departement FROM datamart__lemonde ) WITH DATA pcoustillas@monetdb:~$ operation successful operation successful COMMIT: transaction is aborted because of concurency conflicts, will ROLLBACK instead operation successful
why is there a conflict while they are different tables that are created?
I use the last version Database: MonetDB v11.19.7 (Oct2014-SP1) I have the same bug on : MonetDB v11.17.21 (Jan2014-SP3)
Thank
Pierre
Hello this is precisely the case covered in our recent post; https://www.monetdb.org/blog/monetdb-sql-transaction-management-scheme
You attempt a large number of updates on the system catalog, which will lead to aborts due to multi-version concurrency conflicts.
regards, Martin On 07/12/14 13:41, Pierre-Adrien Coustillas wrote:
Hello,
is this a bug or a feature I do not understand ?
I have a script bash :
pcoustillas@monetdb:~$ cat bug_commit.sh #!/bin/bash
i=1
while [ $i -le 3 ] do create="CREATE TABLE tmp_schampy_odc__lemondeclient_$i AS ( SELECT datamart__lemonde.id_unique, ( departement IN ( '08','10','67','42','10','15' ) ) AS top_departement FROM datamart__lemonde ) WITH DATA " echo $create mclient lemonde --statement="$create" &
i=$(($i+1))done
I monetdb restarts before : service monetdb5-sql stop ; sleep 10 ; service monetdb5-sql start
And i run script : pcoustillas@monetdb:~$ ./bug_commit.sh CREATE TABLE tmp_schampy_odc__lemondeclient_1 AS ( SELECT datamart__lemonde.id_unique, ( departement IN ( '08','10','67','42','10','15' ) ) AS top_departement FROM datamart__lemonde ) WITH DATA CREATE TABLE tmp_schampy_odc__lemondeclient_2 AS ( SELECT datamart__lemonde.id_unique, ( departement IN ( '08','10','67','42','10','15' ) ) AS top_departement FROM datamart__lemonde ) WITH DATA CREATE TABLE tmp_schampy_odc__lemondeclient_3 AS ( SELECT datamart__lemonde.id_unique, ( departement IN ( '08','10','67','42','10','15' ) ) AS top_departement FROM datamart__lemonde ) WITH DATA pcoustillas@monetdb:~$ operation successful operation successful COMMIT: transaction is aborted because of concurency conflicts, will ROLLBACK instead operation successful
why is there a conflict while they are different tables that are created?
I use the last version Database: MonetDB v11.19.7 (Oct2014-SP1) I have the same bug on : MonetDB v11.17.21 (Jan2014-SP3)
Thank
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
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Hi,
Is 3 queries simultaneously is considered " a large number of updates " ?
Pierre
On 07/12/14 14:05, Pierre-Adrien Coustillas wrote:
Hi, Is 3queriessimultaneouslyisconsidered " a large number of updates " ?
It is not the number of queries per se, but their concurrent execution in your case!
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
*De: *"Martin Kersten" martin@monetdb.org *À: *users-list@monetdb.org *Envoyé: *Dimanche 7 Décembre 2014 13:47:55 *Objet: *Re: COMMIT: transaction is aborted because of concurency conflicts, will ROLLBACK instead
Hello this is precisely the case covered in our recent post; https://www.monetdb.org/blog/monetdb-sql-transaction-management-scheme
You attempt a large number of updates on the system catalog, which will lead to aborts due to multi-version concurrency conflicts.
regards, Martin On 07/12/14 13:41, Pierre-Adrien Coustillas wrote:
Hello,
is this a bug or a feature I do not understand ?
I have a script bash :
pcoustillas@monetdb:~$ cat bug_commit.sh #!/bin/bash
i=1
while [ $i -le 3 ] do create="CREATE TABLE tmp_schampy_odc__lemondeclient_$i AS ( SELECT datamart__lemonde.id_unique, ( departement IN ( '08','10','67','42','10','15' ) ) AS top_departement FROM datamart__lemonde ) WITH DATA " echo $create mclient lemonde --statement="$create" &
i=$(($i+1))done
I monetdb restarts before : service monetdb5-sql stop ; sleep 10 ; service monetdb5-sql start
And i run script : pcoustillas@monetdb:~$ ./bug_commit.sh CREATE TABLE tmp_schampy_odc__lemondeclient_1 AS ( SELECT datamart__lemonde.id_unique, ( departement IN ( '08','10','67','42','10','15' ) ) AS top_departement FROM datamart__lemonde ) WITH DATA CREATE TABLE tmp_schampy_odc__lemondeclient_2 AS ( SELECT datamart__lemonde.id_unique, ( departement IN ( '08','10','67','42','10','15' ) ) AS top_departement FROM datamart__lemonde ) WITH DATA CREATE TABLE tmp_schampy_odc__lemondeclient_3 AS ( SELECT datamart__lemonde.id_unique, ( departement IN ( '08','10','67','42','10','15' ) ) AS top_departement FROM datamart__lemonde ) WITH DATA pcoustillas@monetdb:~$ operation successful operation successful COMMIT: transaction is aborted because of concurency conflicts, will ROLLBACK instead operation successful
why is there a conflict while they are different tables that are created?
I use the last version Database: MonetDB v11.19.7 (Oct2014-SP1) I have the same bug on : MonetDB v11.17.21 (Jan2014-SP3)
Thank
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
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
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
thank you answer, i understand.
participants (3)
-
Martin Kersten -
Martin Kersten -
Pierre-Adrien Coustillas