[MonetDB-users] Fwd: MonetDB Error
Niels/Fabian/Romulo, Thanks for all your replies. I rebooted the server and was able to bring up the database again. Next time, if this happens I will try to remove the locks. I tried to remove the file ".gdk_lock" but Linux wouldn't allow me to remove it. Meanwhile, let me do more tests and see why this is becoming an issue. If necessary as Niels suggested I will open a bug as the query actually crashed the server instead of just returning an error. Niels, Though I am joining all these tables, I have WHERE conditions on each table and the end result is actually 16,384 rows. I will do some more testing by changing the syntax of the query and see if it helps. Forwarded Conversation Subject: MonetDB Error ------------------------ From: Venks <venkatesh.mantha@gmail.com> To: monetdb-users@lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:12 AM 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 How can I re-start the server? Thanks, - Venks -------- From: Romulo Goncalves <R.A.Goncalves@cwi.nl> To: Venks <venkatesh.mantha@gmail.com> Cc: monetdb-users@lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:19 AM [Quoted text hidden]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
-------- From: Venks <venkatesh.mantha@gmail.com> To: Romulo Goncalves <R.A.Goncalves@cwi.nl> Cc: monetdb-users@lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:27 AM If I remove /var/* that will wipe-out my entire database. Correct? [Quoted text hidden] -------- From: Romulo Goncalves <R.A.Goncalves@cwi.nl> To: Venks <venkatesh.mantha@gmail.com> Cc: monetdb-users@lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:30 AM Venks wrote:
If I remove /var/* that will wipe-out my entire database. Correct? Yes.
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 This kernel message seems to indicate that monet run out of memory. 10M^10 is really big, so unless you had a very selective join condition
Regards, Romulo [Quoted text hidden] -------- From: Venks <venkatesh.mantha@gmail.com> To: Romulo Goncalves <R.A.Goncalves@cwi.nl> Cc: monetdb-users@lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:31 AM Is there any way I can restart MonetDB without loosing all my data? [Quoted text hidden] -------- From: Niels Nes <Niels.Nes@cwi.nl> To: Venks <venkatesh.mantha@gmail.com> Date: Fri, Jun 8, 2007 at 9:34 AM On Fri, Jun 08, 2007 at 09:12:50AM -0400, Venks wrote: this will blow up to extreme big tables.
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 Afcourse a crash shouldn't happen. $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. and after restarting it should normally work even with a crash.
So these are bugs, could you report them. Together with a script or so which triggers it? Many thanks.. Niels
!FATAL: GDKlockHome: Database lock '.gdk_lock' denied
How can I re-start the server?
Thanks,
- Venks
[Quoted text hidden]-- 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 -------- From: Romulo Goncalves <R.A.Goncalves@cwi.nl> To: Venks <venkatesh.mantha@gmail.com> Cc: monetdb-users@lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:35 AM 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..
[goncalve@amelia 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 [goncalve@amelia Triggers]$ kill -9 27450 [goncalve@amelia Triggers]$ ps aux | grep mserver goncalve 27491 0.0 0.0 60244 708 pts/2 S+ 15:34 0:00 grep mserver [goncalve@amelia Triggers]$ [Quoted text hidden] -------- From: Fabian Groffen <Fabian.Groffen@cwi.nl> Reply-To: monetdb-users@lists.sourceforge.net, monetdb-users@lists.sourceforge.net To: monetdb-users@lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:36 AM 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. [Quoted text hidden] -------- From: Niels Nes <Niels.Nes@cwi.nl> To: Venks <venkatesh.mantha@gmail.com> Date: Fri, Jun 8, 2007 at 9:36 AM On Fri, Jun 08, 2007 at 09:31:45AM -0400, Venks wrote:
Is there any way I can restart MonetDB without loosing all my data?
After the above error, I am unable to start the MonetDB database. I get the following error.
!FATAL: GDKlockHome: Database lock '.gdk_lock' denied
If the lock is the only problem you could simply remove this, ie
do a find $prefix/var/ -name .gdk_lock | xargs rm -f This will remove all gdk_lock files, so be sure there are no running Mserver/mserver5s. niels
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
[Quoted text hidden] --------
participants (1)
-
Venks