Venks wrote: > Is there any way I can restart MonetDB without loosing all my data? Of course. Just kill your server and start it again..
[EMAIL PROTECTED] Triggers]$ ps aux | grep mserver goncalve 27450 1.8 4.8 338904 99192 pts/0 Sl+ 15:34 0:00 mserver5 goncalve 27484 0.0 0.0 60240 708 pts/2 R+ 15:34 0:00 grep mserver [EMAIL PROTECTED] Triggers]$ kill -9 27450 [EMAIL PROTECTED] Triggers]$ ps aux | grep mserver goncalve 27491 0.0 0.0 60244 708 pts/2 S+ 15:34 0:00 grep mserver [EMAIL PROTECTED] Triggers]$ Regards, Romulo > > 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 >> >> > MonetDB-users@lists.sourceforge.net >> >> > 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 MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
