One thing from mobigitall's message is unclear to me:
then I stopped the database, and wanted to start it back up to see how quickly it would come up. it took a few minutes to come up while it was comitting uncomitted transactions. When i started it up the space usage looked like this: [snip] There is nothing in the merovingian.log file at all since stop/start of database.
I assume you start your database using merovingian in this case. One thing that I know is that merovingian doesn't wait minutes for a database to come up. Instead it waits for at max 10 seconds. Due to a bug that I fixed yesterday (stable CVS), merovingian would not log anything about the database not starting up within 10 seconds. The intentions of merovingian are to terminate a database that takes to long, however due to the same bug, this didn't happen actually.
yes, started via merovigian, but I don't think that it tried to kill mserver5. it went like this: 1. i loaded a ton of data and then stopped the server. - at this point sql_log had a leftover 24GB of logs in it. (see my prev messages) 2. i started the server via monetdb start <> command 3. the mserver5 on "top" was showing small memory footprint and no cpu activity. 4. i tried to connect via mclient. 5. the mserver5 started high CPU activity and quickly growing in virtual and res memory usage. it took may be 20 min to 30 min to get a prompt on the mclient. until then client did not show a prompt but simply hung. 6. by the time prompt appeared on mclient, the sql_log went down to 16k (from 24GB). I thought it means it committed some uncomitted data into the database by that time. I suppose the corruption happened during that commit. NOTE: it didn't make sense to me then, but knowing there is a corruption it mean something - the size of the dbfarm folder went down a couple of gigs just when the committ was complete. I would think it should not drop any size at that point since it's moving data from log to dbfarm. -- View this message in context: http://www.nabble.com/corruption-on-db-restart-tp16737747p16743999.html Sent from the monetdb-users mailing list archive at Nabble.com.