On Thu, Apr 17, 2008 at 06:24:57AM -0700, mobigital1 wrote:
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.
We could like to debug this. As we expect this to be a problem of the database server (possibly related with your os filesystem), we should start running without the monetdb script and merovigian. Ie start your mserver5 with mserver5 --dbinit="include sql;" --dbname=X The last part is added to make sure it will be an empty new database with the name X. Could you repeat the process of starting, loading, stopping and restarting to check if that still fails. Also could you find out where in the columns the 'zeros' start appearing, ie in which rows. Maybe its related to page boundaries etc Al these tests are done on a fedora linux system? Could give (possibly repeat) the exact details of your system? Niels PS we could take this of the list and return once we found an answer.
-- 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.
------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao... _______________________________________________ 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) Kruislaan 413, 1098 SJ 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