Bug : msqldump, drop, create
Hello,
I finally get to reproduce a table conflict bug still present in the 2014 version of OCT SP1
I run these commands simultaneously in two terminals : ---------------------------------------------------------------------------- terminal 1 : $ msqldump --database=lemonde --table=test_integrite_tra > backup_test_integrite_tra.sql
terminal 2 : $ mclient lemonde --statement="SELECT count(*) FROM test_integrite_tra" +----------+ | L1 | +==========+ | 19681703 | +----------+
$ mclient lemonde --statement="DROP TABLE test_integrite_tra" operation successful
$ mclient lemonde --statement="CREATE TABLE test_integrite_tra AS SELECT id_unique,device,nbvisistes FROM sys.visiteurs_device_2 WITH NO DATA" operation successful
---------------------------------------------------------------------------- I count the number of table test_integrite_tra
sql>SELECT count(*) FROM SYS.TABLES WHERE name='test_integrite_tra'; +------+ | L1 | +======+ | 1 | +------+
And I restart monetdb : # service monetdb5-sql stop ; sleep 30 ; service monetdb5-sql start Stopping MonetDB SQL server: monetdbd. Starting MonetDB SQL server: monetdbd.
I count the number of table test_integrite_tra sql>SELECT count(*) FROM SYS.TABLES WHERE name='test_integrite_tra'; +------+ | L1 | +======+ | 2 | +------+
Pierre
On Mon, Feb 02, 2015 at 11:32:29PM +0100, Pierre-Adrien Coustillas wrote:
Hello,
I finally get to reproduce a table conflict bug still present in the 2014 version of OCT SP1
To reproduce your problem we also need the backup_test_integrite_tra.sql file. Could you send this or could you create a small example with dummy data?
Niels
I run these commands simultaneously in two terminals :
terminal 1 : $ msqldump --database=lemonde --table=test_integrite_tra > backup_test_integrite_tra.sql
terminal 2 : $ mclient lemonde --statement="SELECT count(*) FROM test_integrite_tra" +----------+ | L1 | +==========+ | 19681703 | +----------+
$ mclient lemonde --statement="DROP TABLE test_integrite_tra" operation successful
$ mclient lemonde --statement="CREATE TABLE test_integrite_tra AS SELECT id_unique,device,nbvisistes FROM sys.visiteurs_device_2 WITH NO DATA" operation successful
I count the number of table test_integrite_tra
sql>SELECT count(*) FROM SYS.TABLES WHERE name='test_integrite_tra'; +------+ | L1 | +======+ | 1 | +------+
And I restart monetdb : # service monetdb5-sql stop ; sleep 30 ; service monetdb5-sql start Stopping MonetDB SQL server: monetdbd. Starting MonetDB SQL server: monetdbd.
I count the number of table test_integrite_tra sql>SELECT count(*) FROM SYS.TABLES WHERE name='test_integrite_tra'; +------+ | L1 | +======+ | 2 | +------+
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
participants (2)
-
Niels Nes
-
Pierre-Adrien Coustillas