On Thu, Apr 17, 2008 at 10:21:19AM -0700, mobigital1 wrote:
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
If you don't also reset the sql_logdir (or clean it), this will not work. So be sure that both directories are empty or both contain the nessecary files like the existed on the working locations. Also the dbfarm and sql_logdir cannot be exactly the same directory!
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.
This problem was fixed recently, ie the second login failed because the password was overwriten during the first check. Non persistently, ie on the next restart it worked again once!
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?
We haven;t verified this. Please send us your full monetdb5.conf file which which you think we could repeat the problem. Niels
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.
------------------------------------------------------------------------- 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