Hi Pierre,
We are experiencing a very similar situation. We are also experiencing duplication in tables (and also in columns) and we also use quite a lot of create and drop table statements, specifically after a shutdown (or crash...)
We use JDBC to connect and have experienced this behaviour on different Linux distributions as well as on Windows. So it seems not to be related to a specific build or environment.
I have a feeling you are on the right track here. I would also be very interested in being able to see into these WAL files, in order to detect some correlation...
Best regards, Marcel Blok
________________________________________ Van: users-list users-list-bounces+m.blok=chs.nl@monetdb.org namens Stefan Manegold Stefan.Manegold@cwi.nl Verzonden: donderdag 21 januari 2016 22:39 Aan: Communication channel for MonetDB users Onderwerp: Re: WAL read files
Pierre,
about your duplicate table problem:
did you by any chance fill this/these table(s) using multiple COPY INTO bulk-load operation (per table)?
Thanks! Stefan
----- On Jan 21, 2016, at 10:21 PM, Pierre-Adrien Coustillas pcoustillas@1g6.biz wrote:
Hi,
is it possible to read WAL files ? sql/ log.<transaction id>
why ? We still have a problem of duplicate table . All our monetsdb are updated with the latest version of the repository debian8 , and that several server. We have learned to remove duplicate tables and a stable production. But I want to understand this bug Duplication of tables are always created after a restart monetdb
After reading this page https://www.monetdb.org/blog/monetdb-sql-transaction-management-scheme, and particularly this ""By default, persisted transactions are cleaned up from the WAL. During database startup, all transaction still left in the WAL are read and any that are not yet applied are written into the persistent BAT storage"" . I think that the drop or create commands are not cleaned up from the WAL
We used the library php _ map.inci and we run a lot of command drop / create ( ... I know this is not recommended ... ) We used autocommit.
If I can read and understand what is in the WAL file, can help me understand this bug
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 // 09 54 38 70 90
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) | _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list