Re: [MonetDB-users] Meaning of: Scenario not initialized 'sql'
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
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:
- MonetDB is installed by ./monetdb-install.sh --enable-sql --enable-debug
- 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
On 17-06-2010 09:47:06 +0200, Sjoerd Mullender wrote:
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.
Please note that we "fixed" this issue in the upcoming Jun2010 release. Starting from that release sql will automatically become available if you installed it without requiring any actions from your side.
Thanks all.
"include sql;" command is typed and everything is OK.
---- Best Regards Ye Liang
On Thu, Jun 17, 2010 at 4:09 PM, Fabian Groffen Fabian.Groffen@cwi.nlwrote:
On 17-06-2010 09:47:06 +0200, Sjoerd Mullender wrote:
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.
Please note that we "fixed" this issue in the upcoming Jun2010 release. Starting from that release sql will automatically become available if you installed it without requiring any actions from your side.
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
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:
- MonetDB is installed by ./monetdb-install.sh --enable-sql --enable-debug
- 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
participants (4)
-
Fabian Groffen -
Sjoerd Mullender -
Stefan Manegold -
Yel