[MonetDB-users] "merovingian" usage
Recent installation of MonetDB showed the following text at the end of the installation. ==================================== You can start using MonetDB/SQL by starting /root/countdb/bin/merovingian in the background. Read the merovingian(1), monetdb(1) and mclient(1) manpages to learn how to create a database and afterwards connect to it. ==================================== Is "merovingian" ready for usage? When I type "merovingian" I am getting the following error: =============================================================================== unable to create .merovingian_lock file in /root/countdb/var/MonetDB5/dbfarm: No such file or directory =============================================================================== That's because there is no MonetDB5 directory yet. This may be of importance to us as I need to do the following: - Run MonetDB in background - Create the database directory, LOG, CheckPoint and any other files related to any database in a user specified directory. Right now I am using mserver5 executable in a script to start MonetDB in the background. This script was provided by you (Fabian) Please let me know if I need to start using "merovingian" for my needs. Thanks, -Venks
On 30-10-2007 15:07:16 -0400, Venks wrote:
Recent installation of MonetDB showed the following text at the end of the installation.
==================================== You can start using MonetDB/SQL by starting /root/countdb/bin/merovingian in the background. Read the merovingian(1), monetdb(1) and mclient(1) manpages to learn how to create a database and afterwards connect to it. ====================================
Is "merovingian" ready for usage?
This release includes it for the first time. It was, however, included and referred to by the script because it should be working well as far as we have tested it.
When I type "merovingian" I am getting the following error:
=============================================================================== unable to create .merovingian_lock file in /root/countdb/var/MonetDB5/dbfarm: No such file or directory ===============================================================================
That's because there is no MonetDB5 directory yet. This may be of importance to us as I need to do the following:
Indeed there is a slight chicken/egg problem here, that needs polishing. merovingian(1) is not the tool that should create directory structures, monetdb(1) does that. However that merovingian(1) wants to place its lock in the dbfarm is because it needs to assure it is the only one working with it. I think as workaround the dbfarm directory should be created as part of the installation, like the var/log directory is created as well.
- Run MonetDB in background - Create the database directory, LOG, CheckPoint and any other files related to any database in a user specified directory.
Right now I am using mserver5 executable in a script to start MonetDB in the background. This script was provided by you (Fabian)
Please let me know if I need to start using "merovingian" for my needs.
merovingian(1) is capable of: - (re)starting a database (e.g. after a crash or cold start) - stop a database - put a database into maintenance mode - reinstantiate a database from maintenance mode - stop all used databases when merovingian stops. - keep a log of activities by merovingian regarding databases The monetdb(1) client utility makes merovingian perform certain tasks. Making snapshots of a database is /not/ supported by monetdb(1) as tool, however, it can be used to make a snapshot of any flavour you like, e.g.: % monetdb lock mydatabase % mclient --language=sql --dump --database=mydatabase \ --user=administrator --password=very-sekrit > /var/tmp/myfile % monetdb release mydatabase or % monetdb lock mydatabase % monetdb stop mydatabase (check/wait for it to be shut down) % monetdb status mydatabase | grep stopped % rsync -a /path/to/var/MonetDB5/* /my/backup/var/MonetDB5/ % monetdb start mydatabase % monetdb release mydatabase (But I admit, I just wrote these down, didn't test them, so don't blindly copy 'n' paste ;) )
Consider the following setup: CREATE TABLE parent (key int PRIMARY KEY); CREATE TABLE child (parent_key int REFERENCES parent (key) ON DELETE CASCADE); INSERT INTO parent VALUES (1); INSERT INTO child VALUES (1); Issuing from the JDBC terminal: DELETE FROM parent WHERE key = 1; properly results in deletion of both records. However, when issued over mapi, either from my custom C++ code or from the provided Monet SQL client console, the same statement only deletes the row from 'parent', ignoring the cascading constraint. Kind regards, Sander Kruseman
Hi Sander, Please don't hijack threads. Thanks. On 30-10-2007 21:23:58 +0100, Sander Kruseman wrote:
Consider the following setup:
CREATE TABLE parent (key int PRIMARY KEY); CREATE TABLE child (parent_key int REFERENCES parent (key) ON DELETE CASCADE);
INSERT INTO parent VALUES (1); INSERT INTO child VALUES (1);
Issuing from the JDBC terminal: DELETE FROM parent WHERE key = 1; properly results in deletion of both records.
However, when issued over mapi, either from my custom C++ code or from the provided Monet SQL client console, the same statement only deletes the row from 'parent', ignoring the cascading constraint.
Kind regards, Sander Kruseman
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Sander Kruseman wrote:
Consider the following setup:
CREATE TABLE parent (key int PRIMARY KEY); CREATE TABLE child (parent_key int REFERENCES parent (key) ON DELETE CASCADE);
INSERT INTO parent VALUES (1); INSERT INTO child VALUES (1);
Issuing from the JDBC terminal: DELETE FROM parent WHERE key = 1; properly results in deletion of both records.
However, when issued over mapi, either from my custom C++ code or from the provided Monet SQL client console, the same statement only deletes the row from 'parent', ignoring the cascading constraint. I just used my mclient to execute the queries on my MonetDB5 (5.21 current cvs branch) with the SQL module loaded and it works.
Which version are you using and platform? Regards, Romulo
Kind regards, Sander Kruseman
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Hi Romulo, Thanks for your response. I downloaded the latest Windows installer today, and installed on XP. # MonetDB server v5.2.0, based on kernel v1.20.0 ... # MonetDB/SQL module v2.20.0 loaded Good to hear that apparently this has been fixed in the CVS trunk. Regards, Sander Romulo Goncalves wrote:
Sander Kruseman wrote:
Consider the following setup:
CREATE TABLE parent (key int PRIMARY KEY); CREATE TABLE child (parent_key int REFERENCES parent (key) ON DELETE CASCADE);
INSERT INTO parent VALUES (1); INSERT INTO child VALUES (1);
Issuing from the JDBC terminal: DELETE FROM parent WHERE key = 1; properly results in deletion of both records.
However, when issued over mapi, either from my custom C++ code or from the provided Monet SQL client console, the same statement only deletes the row from 'parent', ignoring the cascading constraint. I just used my mclient to execute the queries on my MonetDB5 (5.21 current cvs branch) with the SQL module loaded and it works.
Which version are you using and platform?
Regards, Romulo
Kind regards, Sander Kruseman
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Sander Kruseman wrote:
Hi Romulo,
Thanks for your response. I downloaded the latest Windows installer today, and installed on XP. Me too and everything works fine. I used the SQL client (which is the mclient -lsql) from the start menu to execute the queries on the Mserver5 with SQL module loaded (also from the start menu).
I did a select after the delete and both tables are empty. You need to find a solution to simulate this in my machine if not I am not able to help you. Regards, Romulo
# MonetDB server v5.2.0, based on kernel v1.20.0 ... # MonetDB/SQL module v2.20.0 loaded
Good to hear that apparently this has been fixed in the CVS trunk.
Regards, Sander
Romulo Goncalves wrote:
Sander Kruseman wrote:
Consider the following setup:
CREATE TABLE parent (key int PRIMARY KEY); CREATE TABLE child (parent_key int REFERENCES parent (key) ON DELETE CASCADE);
INSERT INTO parent VALUES (1); INSERT INTO child VALUES (1);
Issuing from the JDBC terminal: DELETE FROM parent WHERE key = 1; properly results in deletion of both records.
However, when issued over mapi, either from my custom C++ code or from the provided Monet SQL client console, the same statement only deletes the row from 'parent', ignoring the cascading constraint. I just used my mclient to execute the queries on my MonetDB5 (5.21 current cvs branch) with the SQL module loaded and it works.
Which version are you using and platform?
Regards, Romulo
Kind regards, Sander Kruseman
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Romulo, I can confirm your results when setting up the tables from mclient. But I still get the failure when setting up the tables over JDBC and then delete the parent record from mclient. (Not that this is my intended way of working. I just stubled upon this, developing my mapi client code and using the JDBC terminal for import of SQL scripts.) Sander Romulo Goncalves wrote:
Sander Kruseman wrote:
Hi Romulo,
Thanks for your response. I downloaded the latest Windows installer today, and installed on XP. Me too and everything works fine. I used the SQL client (which is the mclient -lsql) from the start menu to execute the queries on the Mserver5 with SQL module loaded (also from the start menu).
I did a select after the delete and both tables are empty.
You need to find a solution to simulate this in my machine if not I am not able to help you.
Regards, Romulo
# MonetDB server v5.2.0, based on kernel v1.20.0 ... # MonetDB/SQL module v2.20.0 loaded
Good to hear that apparently this has been fixed in the CVS trunk.
Regards, Sander
Romulo Goncalves wrote:
Sander Kruseman wrote:
Consider the following setup:
CREATE TABLE parent (key int PRIMARY KEY); CREATE TABLE child (parent_key int REFERENCES parent (key) ON DELETE CASCADE);
INSERT INTO parent VALUES (1); INSERT INTO child VALUES (1);
Issuing from the JDBC terminal: DELETE FROM parent WHERE key = 1; properly results in deletion of both records.
However, when issued over mapi, either from my custom C++ code or from the provided Monet SQL client console, the same statement only deletes the row from 'parent', ignoring the cascading constraint. I just used my mclient to execute the queries on my MonetDB5 (5.21 current cvs branch) with the SQL module loaded and it works.
Which version are you using and platform?
Regards, Romulo
Kind regards, Sander Kruseman
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Sander Kruseman wrote:
Romulo,
I can confirm your results when setting up the tables from mclient. But I still get the failure when setting up the tables over JDBC and then delete the parent record from mclient. Ok I will debug that problem tomorrow morning. I just need to know how do you connect with your JDBC. Which user do you use? The same as mclient? Give me the commands and then I will debug the problem.
Regards, Romulo
(Not that this is my intended way of working. I just stubled upon this, developing my mapi client code and using the JDBC terminal for import of SQL scripts.)
Sander
Romulo Goncalves wrote:
Sander Kruseman wrote:
Hi Romulo,
Thanks for your response. I downloaded the latest Windows installer today, and installed on XP. Me too and everything works fine. I used the SQL client (which is the mclient -lsql) from the start menu to execute the queries on the Mserver5 with SQL module loaded (also from the start menu).
I did a select after the delete and both tables are empty.
You need to find a solution to simulate this in my machine if not I am not able to help you.
Regards, Romulo
# MonetDB server v5.2.0, based on kernel v1.20.0 ... # MonetDB/SQL module v2.20.0 loaded
Good to hear that apparently this has been fixed in the CVS trunk.
Regards, Sander
Romulo Goncalves wrote:
Sander Kruseman wrote:
Consider the following setup:
CREATE TABLE parent (key int PRIMARY KEY); CREATE TABLE child (parent_key int REFERENCES parent (key) ON DELETE CASCADE);
INSERT INTO parent VALUES (1); INSERT INTO child VALUES (1);
Issuing from the JDBC terminal: DELETE FROM parent WHERE key = 1; properly results in deletion of both records.
However, when issued over mapi, either from my custom C++ code or from the provided Monet SQL client console, the same statement only deletes the row from 'parent', ignoring the cascading constraint. I just used my mclient to execute the queries on my MonetDB5 (5.21 current cvs branch) with the SQL module loaded and it works.
Which version are you using and platform?
Regards, Romulo
Kind regards, Sander Kruseman
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Nothing fancy: I use the default user monetdb in both clients, working in the sys schema. I start the JDBC client using: java -jar "C:\Program Files\CWI\MonetDB5\share\MonetDB\lib\jdbcclient.jar" -l sql -u monetdb (java version "1.6.0_02") Happy hunting! Sander Romulo Goncalves wrote:
Sander Kruseman wrote:
Romulo,
I can confirm your results when setting up the tables from mclient. But I still get the failure when setting up the tables over JDBC and then delete the parent record from mclient. Ok I will debug that problem tomorrow morning. I just need to know how do you connect with your JDBC. Which user do you use? The same as mclient? Give me the commands and then I will debug the problem.
Regards, Romulo
(Not that this is my intended way of working. I just stubled upon this, developing my mapi client code and using the JDBC terminal for import of SQL scripts.)
Sander
Romulo Goncalves wrote:
Sander Kruseman wrote:
Hi Romulo,
Thanks for your response. I downloaded the latest Windows installer today, and installed on XP. Me too and everything works fine. I used the SQL client (which is the mclient -lsql) from the start menu to execute the queries on the Mserver5 with SQL module loaded (also from the start menu).
I did a select after the delete and both tables are empty.
You need to find a solution to simulate this in my machine if not I am not able to help you.
Regards, Romulo
# MonetDB server v5.2.0, based on kernel v1.20.0 ... # MonetDB/SQL module v2.20.0 loaded
Good to hear that apparently this has been fixed in the CVS trunk.
Regards, Sander
Romulo Goncalves wrote:
Sander Kruseman wrote:
Consider the following setup:
CREATE TABLE parent (key int PRIMARY KEY); CREATE TABLE child (parent_key int REFERENCES parent (key) ON DELETE CASCADE);
INSERT INTO parent VALUES (1); INSERT INTO child VALUES (1);
Issuing from the JDBC terminal: DELETE FROM parent WHERE key = 1; properly results in deletion of both records.
However, when issued over mapi, either from my custom C++ code or from the provided Monet SQL client console, the same statement only deletes the row from 'parent', ignoring the cascading constraint. I just used my mclient to execute the queries on my MonetDB5 (5.21 current cvs branch) with the SQL module loaded and it works.
Which version are you using and platform?
Regards, Romulo
Kind regards, Sander Kruseman
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Simple check. Are you running both JDBC and mclient in parallel? And what are your commit option settings? Beware that running both in parallel are different users from a database point off view. At least during the transaction. Sander Kruseman wrote:
Nothing fancy: I use the default user monetdb in both clients, working in the sys schema. I start the JDBC client using:
java -jar "C:\Program Files\CWI\MonetDB5\share\MonetDB\lib\jdbcclient.jar" -l sql -u monetdb (java version "1.6.0_02")
Happy hunting! Sander
Romulo Goncalves wrote:
Sander Kruseman wrote:
Romulo,
I can confirm your results when setting up the tables from mclient. But I still get the failure when setting up the tables over JDBC and then delete the parent record from mclient.
Ok I will debug that problem tomorrow morning. I just need to know how do you connect with your JDBC. Which user do you use? The same as mclient? Give me the commands and then I will debug the problem.
Regards, Romulo
(Not that this is my intended way of working. I just stubled upon this, developing my mapi client code and using the JDBC terminal for import of SQL scripts.)
Sander
Romulo Goncalves wrote:
Sander Kruseman wrote:
Hi Romulo,
Thanks for your response. I downloaded the latest Windows installer today, and installed on XP.
Me too and everything works fine. I used the SQL client (which is the mclient -lsql) from the start menu to execute the queries on the Mserver5 with SQL module loaded (also from the start menu).
I did a select after the delete and both tables are empty.
You need to find a solution to simulate this in my machine if not I am not able to help you.
Regards, Romulo
# MonetDB server v5.2.0, based on kernel v1.20.0 ... # MonetDB/SQL module v2.20.0 loaded
Good to hear that apparently this has been fixed in the CVS trunk.
Regards, Sander
Romulo Goncalves wrote:
Sander Kruseman wrote:
> Consider the following setup: > > CREATE TABLE parent (key int PRIMARY KEY); > CREATE TABLE child (parent_key int REFERENCES parent (key) ON DELETE > CASCADE); > > INSERT INTO parent VALUES (1); > INSERT INTO child VALUES (1); > > Issuing from the JDBC terminal: DELETE FROM parent WHERE key = 1; > properly results in deletion of both records. > > However, when issued over mapi, either from my custom C++ code or from > the provided Monet SQL client console, the same statement only deletes > the row from 'parent', ignoring the cascading constraint. > I just used my mclient to execute the queries on my MonetDB5 (5.21 current cvs branch) with the SQL module loaded and it works.
Which version are you using and platform?
Regards, Romulo
> Kind regards, > Sander Kruseman > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > MonetDB-users mailing list > MonetDB-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users > ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Concurrency is not an issue here, since I am using autocommit all the time, and synchronizing my client usage, or even restarting the server doesn't change the reported behavior. Martin Kersten wrote:
Simple check. Are you running both JDBC and mclient in parallel? And what are your commit option settings?
Beware that running both in parallel are different users from a database point off view. At least during the transaction.
Sander Kruseman wrote:
Nothing fancy: I use the default user monetdb in both clients, working in the sys schema. I start the JDBC client using:
java -jar "C:\Program Files\CWI\MonetDB5\share\MonetDB\lib\jdbcclient.jar" -l sql -u monetdb (java version "1.6.0_02")
Happy hunting! Sander
Romulo Goncalves wrote:
Sander Kruseman wrote:
Romulo,
I can confirm your results when setting up the tables from mclient. But I still get the failure when setting up the tables over JDBC and then delete the parent record from mclient.
Ok I will debug that problem tomorrow morning. I just need to know how do you connect with your JDBC. Which user do you use? The same as mclient? Give me the commands and then I will debug the problem.
Regards, Romulo
(Not that this is my intended way of working. I just stubled upon this, developing my mapi client code and using the JDBC terminal for import of SQL scripts.)
Sander
Romulo Goncalves wrote:
Sander Kruseman wrote:
Hi Romulo,
Thanks for your response. I downloaded the latest Windows installer today, and installed on XP.
Me too and everything works fine. I used the SQL client (which is the mclient -lsql) from the start menu to execute the queries on the Mserver5 with SQL module loaded (also from the start menu).
I did a select after the delete and both tables are empty.
You need to find a solution to simulate this in my machine if not I am not able to help you.
Regards, Romulo
# MonetDB server v5.2.0, based on kernel v1.20.0 ... # MonetDB/SQL module v2.20.0 loaded
Good to hear that apparently this has been fixed in the CVS trunk.
Regards, Sander
Romulo Goncalves wrote:
> Sander Kruseman wrote: > >> Consider the following setup: >> >> CREATE TABLE parent (key int PRIMARY KEY); >> CREATE TABLE child (parent_key int REFERENCES parent (key) ON DELETE >> CASCADE); >> >> INSERT INTO parent VALUES (1); >> INSERT INTO child VALUES (1); >> >> Issuing from the JDBC terminal: DELETE FROM parent WHERE key = 1; >> properly results in deletion of both records. >> >> However, when issued over mapi, either from my custom C++ code or from >> the provided Monet SQL client console, the same statement only deletes >> the row from 'parent', ignoring the cascading constraint. >> > I just used my mclient to execute the queries on my MonetDB5 (5.21 > current cvs branch) with the SQL module loaded and it works. > > Which version are you using and platform? > > Regards, > Romulo > >> Kind regards, >> Sander Kruseman >> >> ------------------------------------------------------------------------- >> This SF.net email is sponsored by: Splunk Inc. >> Still grepping through log files to find problems? Stop. >> Now Search log events and configuration files using AJAX and a browser. >> Download your FREE copy of Splunk now >> http://get.splunk.com/ >> _______________________________________________ >> MonetDB-users mailing list >> MonetDB-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/monetdb-users >> > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > MonetDB-users mailing list > MonetDB-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users > ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
On Tue, Oct 30, 2007 at 10:40:14PM +0100, Sander Kruseman wrote:
Nothing fancy: I use the default user monetdb in both clients, working in the sys schema. I start the JDBC client using:
java -jar "C:\Program Files\CWI\MonetDB5\share\MonetDB\lib\jdbcclient.jar" -l sql -u monetdb (java version "1.6.0_02")
please note that JDBCclient cannot be compiled with Java 1.6 (only with 1.4 & 1.5) --- not being a Java expert, I have no idea whether running JDBCclient with Java 1.6 is hence supposed/guaranteed to work correctly... Stefan
Happy hunting! Sander
Romulo Goncalves wrote:
Sander Kruseman wrote:
Romulo,
I can confirm your results when setting up the tables from mclient. But I still get the failure when setting up the tables over JDBC and then delete the parent record from mclient. Ok I will debug that problem tomorrow morning. I just need to know how do you connect with your JDBC. Which user do you use? The same as mclient? Give me the commands and then I will debug the problem.
Regards, Romulo
(Not that this is my intended way of working. I just stubled upon this, developing my mapi client code and using the JDBC terminal for import of SQL scripts.)
Sander
Romulo Goncalves wrote:
Sander Kruseman wrote:
Hi Romulo,
Thanks for your response. I downloaded the latest Windows installer today, and installed on XP. Me too and everything works fine. I used the SQL client (which is the mclient -lsql) from the start menu to execute the queries on the Mserver5 with SQL module loaded (also from the start menu).
I did a select after the delete and both tables are empty.
You need to find a solution to simulate this in my machine if not I am not able to help you.
Regards, Romulo
# MonetDB server v5.2.0, based on kernel v1.20.0 ... # MonetDB/SQL module v2.20.0 loaded
Good to hear that apparently this has been fixed in the CVS trunk.
Regards, Sander
Romulo Goncalves wrote:
Sander Kruseman wrote: > Consider the following setup: > > CREATE TABLE parent (key int PRIMARY KEY); > CREATE TABLE child (parent_key int REFERENCES parent (key) ON DELETE > CASCADE); > > INSERT INTO parent VALUES (1); > INSERT INTO child VALUES (1); > > Issuing from the JDBC terminal: DELETE FROM parent WHERE key = 1; > properly results in deletion of both records. > > However, when issued over mapi, either from my custom C++ code or from > the provided Monet SQL client console, the same statement only deletes > the row from 'parent', ignoring the cascading constraint. I just used my mclient to execute the queries on my MonetDB5 (5.21 current cvs branch) with the SQL module loaded and it works.
Which version are you using and platform?
Regards, Romulo > Kind regards, > Sander Kruseman > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > MonetDB-users mailing list > MonetDB-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ 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-4312 |
On Tue, Oct 30, 2007 at 10:40:14PM +0100, Sander Kruseman wrote:
Nothing fancy: I use the default user monetdb in both clients, working in the sys schema. I start the JDBC client using:
java -jar "C:\Program Files\CWI\MonetDB5\share\MonetDB\lib\jdbcclient.jar" -l sql -u monetdb (java version "1.6.0_02")
please note that JDBCclient cannot be compiled with Java 1.6 (only with 1.4 & 1.5) --- not being a Java expert, I have no idea whether running JDBCclient with Java 1.6 is hence supposed/guaranteed to work correctly... Bug confirmed. I used the mjclient from the current branch to create the
Stefan Manegold wrote: tables and insert the tuples. Then I start mclient to delete the tuples from the parent and I can see the the child still has the tuple. I will open bug and kill it (time to have fun) ;) Regards, Romulo
Romulo Goncalves wrote:
Nothing fancy: I use the default user monetdb in both clients, working in the sys schema. I start the JDBC client using:
java -jar "C:\Program Files\CWI\MonetDB5\share\MonetDB\lib\jdbcclient.jar" -l sql -u monetdb (java version "1.6.0_02")
On Tue, Oct 30, 2007 at 10:40:14PM +0100, Sander Kruseman wrote: please note that JDBCclient cannot be compiled with Java 1.6 (only with 1.4 & 1.5) --- not being a Java expert, I have no idea whether running JDBCclient with Java 1.6 is hence supposed/guaranteed to work correctly... Bug confirmed. I used the mjclient from the current branch to create the
Stefan Manegold wrote: tables and insert the tuples. Then I start mclient to delete the tuples from the parent and I can see the the child still has the tuple.
I will open bug and kill it (time to have fun) ;) The fun is over. The bug was fixed in the cvs stable branch. Now we just need to wait for the propagation to have in the current cvs branch.
Regards, Romulo
Regards, Romulo
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (6)
-
Fabian Groffen -
Martin Kersten -
Romulo Goncalves -
Sander Kruseman -
Stefan Manegold -
Venks