On 17-06-2008 14:38:31 -0700, Rt Ibmer wrote:
Ok, this error indicates that the server is running, but the sql module has not been properly loaded (it may not have finished loading).
Interesting. Is there a way I can make merovingian not return until modules are loaded? This way I can put the commands in succession like I have them and be sure then when the next line runs that everything is loaded and ready.
merovingian not, but the monetdb tool can.
I'm not sure what you mean by that. This is what I do (and this is the first monetdb related code/processes that are kicked off at the time the server boots):
merovingian monetdb create mydb monetdb start mydb mclient -lsql --time --database=mydb < /sql/schemas.sql
Ok, you might get into a time shortage problem here.
database, do you use `monetdb start -w mydb` or without "-w"?
Without. I just use this: monetdb start mydb
In your case, `monetdb start -w mydb` will make an good difference. The "-w" stands for "wait", which means it will block until the database has a connection available. The mclient in your example above should always succeed to at least connect to the database if you use the "-w" flag to `monetdb`. See also the monetdb(1) man-page.