Hi,

I know this topic has been discussed last year, but with the
MonetDB-Feb2010-SuperBall-SP2 installed, I repeatedly got
the error like MALException:setScenario:Scenario not initialized 'sql'
almost every time when I try to start mclient with "mclient -l sql -d dbname",
even when i try it later on.

Moreover, only "mclient -l mal -d dbname" is OK,
sql, xquery, mil all got the error above.
Any idea ?

BTW:
1. MonetDB is installed by ./monetdb-install.sh --enable-sql --enable-debug
2. mapi_port is set to 50003 in etc/monetdb5.conf;

Thanks.

----
Best Regards
Ye Liang

Sjoerd Mullender-2 wrote:

> Alex Bo. wrote:
> > Hi,
> >
> > Sometimes I get !MALException:setScenario:Scenario not initialized 'sql'
> > from the server when I try to start it in scenarios that usually work
> > without any problems. I can't reproduce it consistently, but sometimes I get
> > it. What does this exception mean?
> >
> > Thanks.
>
> This exception means that the server is not yet ready for accepting SQL
> connections.  The solution is to try again later.
>
> When the server starts up, it pretty quickly starts accepting
> connections, but initially only for MAL.  When the SQL engine is
> initialized (which may take a while if there was any recovery to be
> done), it starts accepting SQL connections as well.  You get this
> exception when you connect before the SQL engine is ready.
>
> --
> Sjoerd Mullender