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