On 08-06-2007 09:31:45 -0400, Venks wrote: > Is there any way I can restart MonetDB without loosing all my data?
Make sure there are no running mservers any more. If there still are, kill 'em all. Find the .gdk_lock file in your var/monetdb/... and remove it. Try to start MonetDB. (Preferably without the script so you can see what happens.) If it fails to load the BATs, the database has been corrupted. > On 6/8/07, Romulo Goncalves <[EMAIL PROTECTED]> wrote: > > Venks wrote: > > > If I remove /var/* that will wipe-out my entire database. Correct? > > Yes. > > > > Regards, > > Romulo > > > > > > On 6/8/07, Romulo Goncalves <[EMAIL PROTECTED]> wrote: > > >> Venks wrote: > > >> > I got the following error while trying to run a query joining 10 > > >> > tables. These tables are all 2 or 3 column tables but do have on an > > >> > average 10M rows in each table. > > >> > > > >> > =================== > > >> > > > >> > lin5 kernel: journal_get_undo_access: No memory for committed data > > >> > mserver5: > > >> /scratch/monet.GNU.64.64.d.5883/MonetDB5/src/optimizer/opt_joinpath.mx:227: > > >> > > >> > ALGjoinPath: Assertion `b' failed. > > >> > ./startmonet.sh: line 2: 9488 Aborted > > >> > $MONETDB5_PREFIX/bin/mserver5 --dbname=csdb --dbinit='include sql;' > > >> > > > >> > ====================== > > >> > > > >> > After the above error, I am unable to start the MonetDB database. I > > >> > get the following error. > > >> > > > >> > > > >> > !FATAL: GDKlockHome: Database lock '.gdk_lock' denied > > >> You need to remove your dbfarm and dblogs. > > >> > > >> Just do > > >> rm -fr $MONETDB5_PREFIX/var/* > > >> > > >> Regards, > > >> Romulo > > >> > > > >> > > > >> > How can I re-start the server? > > >> > > > >> > Thanks, > > >> > > > >> > - Venks > > >> > > > >> > > > >> ------------------------------------------------------------------------- > > >> > This SF.net email is sponsored by DB2 Express > > >> > Download DB2 Express C - the FREE version of DB2 express and take > > >> > control of your XML. No limits. Just data. Click to get it now. > > >> > http://sourceforge.net/powerbar/db2/ > > >> > _______________________________________________ > > >> > MonetDB-users mailing list > > >> > [email protected] > > >> > https://lists.sourceforge.net/lists/listinfo/monetdb-users > > >> > > >> > > > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > MonetDB-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/monetdb-users ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ MonetDB-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-users
