If I remove /var/* that will wipe-out my entire database. Correct? On 6/8/07, Romulo Goncalves 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

Is there any way I can restart MonetDB without loosing all my data? On 6/8/07, Romulo Goncalves wrote:

Venks wrote:

...

If I remove /var/* that will wipe-out my entire database. Correct? Yes.

Regards, Romulo

...

On 6/8/07, Romulo Goncalves 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

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 wrote:

...

Venks wrote:

...

If I remove /var/* that will wipe-out my entire database. Correct? Yes.

Regards, Romulo

...

On 6/8/07, Romulo Goncalves 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