is it supported to move dbfarm after the database has been created? i tried that before by changing the dbfarm and sql_log parameters together but database would not come up. Niels Nes wrote:
On Wed, Apr 16, 2008 at 12:38:45PM -0700, mobigital1 wrote:
I am sure I have tried the change below. In addition to that I had mapi_open set to true, and mapi_port set to 5000, also tried 50000. could port cause instability?
All of your changes shouldn't cause instability at all. The only thing which could cause this is only changing the dbfarm and not the log directory (or vice versa). This would possibly give a inconsistent db, leading to crashes.
I am testing a fresh build/install now will see how it works.
recreated db partition as Linux, formatted as mkfs -t ext3
Niels
Niels Nes wrote:
On Wed, Apr 16, 2008 at 12:19:35PM -0700, mobigital1 wrote:
I tried replacing the {prefix} and also just changing specific
in monetdb5.conf that reference {prefix}....
the latest thing I tried is replacing /var/monetdb/var with a new
mount
to a larger disk. I formatted the disk as NFTS - it mounts fine, but monetdb crashes.
I believe I had imported the same data before into an originally built installation and it imported ok. I think had around 200M rows there.
completely buffled why this is crashing now. I have rebuilt monetdb from the tarball - it kept crashing.
I am running Fedora 8 64 bit edition with 32GB ram.
Does it care what is the filesystem type of share on which dbfarm
variables lives?
Can someone give some guidance on what is a working configuration? nothing seems to make monetdb happy!!!!
Example which works here.
gdk_dbfarm=/scratch/var/MonetDB5/dbfarm sql_logdir=/scratch/var/MonetDB5/sql_logs
Else could you include your current (anonymized) monetdb5.conf
Niels
Niels Nes wrote:
On Tue, Apr 15, 2008 at 07:34:06PM -0700, mobigital1 wrote:
i am trying to setup the dbfarm location to be on a different share
from
/opt/monetdb/var directory. i modified the /opt/monetdb/etc/monetdb5.conf file to reflect the alternate path to dbfarm location, and also sql-log location. Where do the point to now, ie you only replaced the prefix /opt/monetdb/var by you new partition?
Niels
i am able to start the server with >> merogivian start <dbname> but it is very unstable and crashes when i try to import some data.
I
have been able to import the same data when dbfarm was under /opt/monetdb/var directory. is there something else I need to do to relocate dbfarm to another folder? the new folder is mounted to another disk. (ext3 partition)
any advice would be appreciated.
-- View this message in context:
http://www.nabble.com/alternate-dbfarm-location-not-working-tp16715294p16715...
Sent from the monetdb-users mailing list archive at Nabble.com.
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao...
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
--
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
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao...
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- View this message in context:
http://www.nabble.com/alternate-dbfarm-location-not-working-tp16715294p16731...
Sent from the monetdb-users mailing list archive at Nabble.com.
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao...
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
--
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
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao...
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- View this message in context: http://www.nabble.com/alternate-dbfarm-location-not-working-tp16715294p16731... Sent from the monetdb-users mailing list archive at Nabble.com.
------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao... _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
--
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
------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao... _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- View this message in context: http://www.nabble.com/alternate-dbfarm-location-not-working-tp16715294p16732... Sent from the monetdb-users mailing list archive at Nabble.com.