On Wed, Oct 22, 2014 at 11:56:39AM +0200, Guillaume Bassot wrote:

Thank you for answer,

I don't think we encounter the same problem here. You get duplicate entries inside table while Pierre is getting duplicate tables inside database. But the catalog is also kept in tables.

Niels

Regards,

Guillaume BASSOT Web Developer +33 (0)1 55 48 02 82  gbassot@inbox.fr 

30, rue Vincent Moris 92240 Malakoff - France  Fax : +33 (0)1 55 48 02 79

2014-10-22 11:43 GMT+02:00 Sjoerd Mullender :

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

Could this be bug 3474 [1]? This bug is fixed in the Oct2014 branch, but it requires recreating multi-column constraints.  We will do that during the upgrade, but if there are duplicates, manual intervention will be needed (somebody will have to fix the duplicate keys).

[1] https://www.monetdb.org/bugzilla/show_bug.cgi?id=3474

On 22/10/14 10:48, Pierre-Adrien Coustillas wrote: > Hello, > > (google translate) > > We had a crash monetdb following a full disk. We had already found > that the bug not uniq table (corrupt catalog) could be related to > these crash. And indeed this command will return no rows before the > crash, but 20 lines after the crash : echo "SELECT name FROM > SYS.TABLES WHERE system=false;" | mclient base | grep " " | grep -v > " name " | grep -v " tuple" | sed 's/[| ]//g' | sort | uniq -c | > grep -v " 1 " 5 bdm__lm__agregats 4 bdm__lm__agregats_temp 5 > bdm__tra__agregats 4 bdm__tra__agregats_temp 5 ci__data__agregats 6 > ci__data__reporting .. ... ... > > > Is the October 2014 release will fix this trouble? We are > Jan2014-SP3 > > 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 >

- -- Sjoerd Mullender -----BEGIN PGP SIGNATURE----- Version: GnuPG v1

iQCVAwUBVEd8Jz7g04AjvIQpAQJAwwP9HDefykbPzxAwH02WHnpMqxRgZJWtlb2j SdAIeSCYD+z6tx+RXVOG0u/ChqfCjvM/oiLPiuvEbDoKgjo4fG1DMJ5Ode30MYqq u4cKfbcKihHYVR1fp4ddBJcCZ1Ot/4y/4KEPIOBXYlWgseW2V4ozwU5SXTjoDY8W Z761AEDO/Ho= =grTT -----END PGP SIGNATURE----- _______________________________________________ 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

-- Niels Nes, 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: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl