On Wed, May 13, 2009 at 02:07:31AM -0700, Alex Bo. wrote:

Hi,

Newly created tables disappear if I follow this sequence of actions:

1. Create a new table and insert data into it. 2. Shut down MonetDB. 3. Manually remove the sql_logs folder. 4. Start MonetDB 5. Now the newly created table is gone.

What exactly is the purpose if the sql_logs folder, and when is it safe to delete it?

The sql_logs give you persistency, ie its never safe to delete them for a server with important tables. The server it self takes care of removing those sql log files it doesn't need anymore. Niels

The reason I deleted the sql_logs folder in the first place, is that a while ago I got into a corrupt DB state, and the mserver prompted me to remove the log folder. Doing so fixed the DB and it was usable again, so I assumed deleting the sql_logs folder would always be ok before starting Monet. -- View this message in context: http://www.nabble.com/deleting-sql_logs-and-disappearing-tables-tp23518145p2... Sent from the monetdb-users mailing list archive at Nabble.com.

------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl