Message: 5 Date: Tue, 15 Mar 2016 21:27:10 +0100 (CET) From: Stefan Manegold To: Communication channel for MonetDB users Subject: Re: Duplicate and reappearing tables.

Hi Nicolas,

could you please share which version of MonetDB you're using on which OS?

Also, did you initially create your database with the very same version of MonetDB that you're using now, or did you create it with an earlier version (which) and then upgrade it to the one you're using now (directly or via intermetiate release steps)?

Stefan, It's Jul2015-SP2 running on Debian 8 (jessie). We loaded it from scratch, two daily files 100-250MB in size. Earlier we were running Jul2015-SP1 with the same issue.

Message: 7 Date: Wed, 16 Mar 2016 08:02:47 +0000 From: Marcel Blok To: Communication channel for MonetDB users Subject: RE: Duplicate and reappearing tables.

Hi Nicolas,

We have (and unfortunately sometimes still do) experience similar issues. The issues appear most often at stopping and starting the database. In an earlier thread (named "WAL read files") Pierre-Adrien found out that underscores in table and/or column names could cause conflicts, and cause similar issues. Maybe this is related to the issue you are experiencing?

See also the bug report: https://www.monetdb.org/bugzilla/show_bug.cgi?id=3912

I am aware of this report. However, I do not have any tables where _ conflicts. The WAL files would be in db/sql_logs/sql, yes? I see a 12 byte file "log" and a 513K file "log.791". Can I inspect or understand what those files contain? What is in this numbered log file? I also tried loading a msqldump of the data into a new MonetDB instance, which eventually crashes with "Illegal input sequence". Are there any ways of making mserver5 more verbose? Clearly, something is happening at database startup. Cheers, Nicolas.