On 2010-06-17 09:29, Yel wrote:
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 ?
Yes. Did you actually start the SQL scenario in the server? How did you start the server. If you're not using merovingian to control your server, you need to start it correctly by using: mserver5 --dbinit 'include sql;' Or you can type the command include sql; at the server console after the server started up.
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
------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Sjoerd Mullender