That's ok when we have a large database, but I was trying this with a blank database right after switching the dbfarm location to /data/MonetDB5 when I pointed back to the original config file, and started it up, i was able to connect right away, but after one \q and reconnect got a credentials issue. so at that point (while back in original configuration), I destroyed the database and recreated it. then connecting worked fine. so there are 2 issues: 1. monetdb does not support changing the dbfarm location 2. monetdb does not support moving the database to another location. something was not working when db files were moved ... could this be because of some issue in memory -mapped files? may be kernel had some references to these files by their old locations? Fabian Groffen wrote:
On 17-04-2008 06:29:08 -0700, mobigital1 wrote:
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
I tried the above example switching like this:
gdk_dbfarm=/data/MonetDB5/dbfarm sql_logdir=/data/MonetDB5/sql_logs
left everything else unchanged in the log file.
1. merovigian starts ok. does not complain in log about anything 2. database starts ok, i see mserver5 running.
when I try connecting to client it says "database does not accept connections"
That means the sql module has not finished starting (yet).
NOTE: my monetdb5.conf says mapi_open=false, however, the ps shows that mserver5 is running with -set mapi open true. ?? how come?
Merovingian overrides this because otherwise redirection won't work. The next version of Merovingian will make this not any more necessary.
------------------------------------------------------------------------- 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-tp16715294p16747... Sent from the monetdb-users mailing list archive at Nabble.com.