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