[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.
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:
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 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