On Thu, Jun 17, 2010 at 03:29:47PM +0800, 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.
How did you start your server, i.e., did you activate the SQL server? If you use merovignian to start your server, the SQL server should be activated by default. If you start mserver5 by hand, you also need to start the SQL server by hand, e.g., mserver5 --dbinit='include sql;' ...
Moreover, only "mclient -l mal -d dbname" is OK, sql, xquery, mil all got the error above. Any idea ?
mserver5 (version 5) only supports mal & sql. xquery & mil are only supported by the "legacy" Mserver (version 4).
BTW: 1. MonetDB is installed by ./monetdb-install.sh --enable-sql --enable-debug 2. mapi_port is set to 50003 in etc/monetdb5.conf;
mclient does not (yet?) read etc/monetdb5.conf; hence, you need to specify the port on the commandline: mclient -p50003 (this holds for both mal & sql!) Stefan
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
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4199 |