On 17-06-2008 13:14:19 -0700, Rt Ibmer wrote:
> > Please look into your merovingian.log file, it will contain
> > more
> > information why the database "does not allow
> > connections".
> 
> The logs simply have this:
> 
> error.log:
> 
> TME 2008-06-17 16:06:43
> ERR merovingian[941]: client error: database 'mydb' does not allow connections

Ok, this error indicates that the server is running, but the sql module
has not been properly loaded (it may not have finished loading).

> msg.log:
> 
> TME 2008-06-17 16:06:43
> MSG merovingian[941]: Merovingian 0.7 starting ...
> MSG merovingian[941]: monitoring dbfarm /mnt/MonetDB5/dbfarm
> MSG merovingian[941]: listening for TCP connections on xyz:50000
> MSG bhtg[948]: executing '/usr/bin/mserver5' for database 'mydb'

This seems to be a very early start, do you use pre-starting of database
mydb?

> MSG merovingian[941]: listening for UDP messages on xyz:50000
> MSG merovingian[941]: starting database mydb due to control signal

here the database is started again

> MSG merovingian[941]: starting database 'mydb', up min/avg/max: 0/0/0, crash 
> average: 0.00 0.00 0.00 (0-0=0)
> MSG merovingian[941]: database 'mydb' already running since 2008-06-17 
> 16:06:43, up min/avg/max: 0/0/0, crash average: 0.00 0.00 0.00 (1-0=0)

however it was already started, log might look confusing here, but this
is due to different processes

> MSG bhtg[948]: !WARNING: BBPdir: initializing BBP.
> MSG bhtg[948]: # MonetDB server v5.6.0, based on kernel v1.24.0
> MSG bhtg[948]: # Serving database 'mydb'
> MSG bhtg[948]: # Compiled for i686-pc-linux-gnu/32bit with 32bit OIDs 
> dynamically linked
> MSG bhtg[948]: # Copyright (c) 1993-2008 CWI, all rights reserved
> MSG bhtg[948]: # Visit http://monetdb.cwi.nl/ for further information
> MSG bhtg[948]: # Listening for connection requests on 
> mapi:monetdb://xyz:50001/

the database reports here that it's ready and waiting, having a
"connection" available.

> > Also, check with `monetdb status` if the database is
> > online, and not
> > under maintenance.
> 
> Yes the status if fine. The output just before the failure even says it was 
> started successfully. And this is happening during boot up so there is no way 
> for the db to be in maintenance mode.

Maintenance mode is persistent.  However, if you start the database, do
you use `monetdb start -w mydb` or without "-w"?

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Monetdb-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-developers

Reply via email to