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 -- 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
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
-- 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 (2)
-
Niels Nes -
Pierre-Adrien Coustillas