Re: [Monetdb-developers] Monetdb-developers Digest, Vol 6, Issue 14

9 Nov 2006

      monetdb-developers-request@lists.sourceforge.net wrote:
...
Send Monetdb-developers mailing list submissions to
  monetdb-developers@lists.sourceforge.net
To subscribe or unsubscribe via the World Wide Web, visit
  https://lists.sourceforge.net/lists/listinfo/monetdb-developers
or, via email, send a message with subject or body 'help' to
  monetdb-developers-request@lists.sourceforge.net
You can reach the person managing the list at
  monetdb-developers-owner@lists.sourceforge.net
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Monetdb-developers digest..."
Today's Topics:
1. Mserver including SQL module.... (Romulo Goncalves)
   2. Re: Mserver including SQL module.... (Fabian Groffen)
   3. Re: Mserver including SQL module.... (Romulo Goncalves)
   4. Re: Mserver including SQL module.... (Fabian)
   5. Re: Mserver including SQL module.... (Romulo Goncalves)
   6. Re: Mserver including SQL module.... (Fabian)
   7. sql.start() is not reconized anymore..... (Romulo Goncalves)
   8. Re: sql.start() is not reconized anymore..... (Martin Kersten)
   9. Re: sql.start() is not reconized anymore..... (Fabian Groffen)
----------------------------------------------------------------------
Message: 1
Date: Thu, 09 Nov 2006 10:16:28 +0100
From: Romulo Goncalves 
Subject: [Monetdb-developers] Mserver including SQL module....
To: monetdb-developers@lists.sourceforge.net
Message-ID: <4552F1EC.5050701@cwi.nl>
Content-Type: text/plain; charset=UTF-8; format=flowed
Dear developers.
I checked out the last SQL version.
I start a mserver including the SQL module with the following alias:
...
gdb --args ~/scratch/MonetDB/monetdb5/bin/mserver5 --dbname=demo --set mapi_port=50000 --dbinit="module(sql_server); clients.setTrace(true);"
and I got this error:
...
[Thread debugging using libthread_db enabled]
[New Thread 46912510627904 (LWP 13853)]
!WARNING: GDKlockHome: created directory /ufs/goncalve/scratch/MonetDB/monetdb5/var/MonetDB5/dbfarm/demo/
!WARNING: GDKlockHome: ignoring empty or invalid .gdk_lock.
!WARNING: BBPdir: initializing BBP.
[New Thread 1082132832 (LWP 13856)]
# MonetDB Server v4.99.19
# Copyright (c) 1993-2006 CWI, all rights reserved
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked
# config:/ufs/goncalve/scratch/MonetDB/monetdb5/etc/MonetDB5.conf
# dbfarm:/ufs/goncalve/scratch/MonetDB/monetdb5/var/MonetDB5/dbfarm
# dbname:demo
# Visit http://monetdb.cwi.nl/ for further information
[New Thread 1090525536 (LWP 13857)]
!ERROR: module(sql_server); clients.setTrace(true);
!             ^<module path> expected
There is something wrong with my alias?
I used the example in the file HowToStart-SQL.
Regards,
Romulo
------------------------------
Message: 2
Date: Thu, 9 Nov 2006 10:58:22 +0100
From: Fabian Groffen 
Subject: Re: [Monetdb-developers] Mserver including SQL module....
To: Romulo Goncalves 
Cc: monetdb-developers@lists.sourceforge.net
Message-ID: <20061109095822.GG30793@cwi.nl>
Content-Type: text/plain; charset=utf-8
On 09-11-2006 10:16:28 +0100, Romulo Goncalves wrote:
...
...
# MonetDB Server v4.99.19
# Copyright (c) 1993-2006 CWI, all rights reserved
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked
# config:/ufs/goncalve/scratch/MonetDB/monetdb5/etc/MonetDB5.conf
# dbfarm:/ufs/goncalve/scratch/MonetDB/monetdb5/var/MonetDB5/dbfarm
# dbname:demo
# Visit http://monetdb.cwi.nl/ for further information
[New Thread 1090525536 (LWP 13857)]
!ERROR: module(sql_server); clients.setTrace(true);
!             ^<module path> expected
include sql;
------------------------------
Message: 3
Date: Thu, 09 Nov 2006 14:37:17 +0100
From: Romulo Goncalves 
Subject: Re: [Monetdb-developers] Mserver including SQL module....
To: Fabian ,
  monetdb-developers@lists.sourceforge.net
Message-ID: <45532F0D.4030403@cwi.nl>
Content-Type: text/plain; charset=UTF-8; format=flowed
Fabian Groffen wrote:
...
On 09-11-2006 10:16:28 +0100, Romulo Goncalves wrote:
...
...
# MonetDB Server v4.99.19
# Copyright (c) 1993-2006 CWI, all rights reserved
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked
# config:/ufs/goncalve/scratch/MonetDB/monetdb5/etc/MonetDB5.conf
# dbfarm:/ufs/goncalve/scratch/MonetDB/monetdb5/var/MonetDB5/dbfarm
# dbname:demo
# Visit http://monetdb.cwi.nl/ for further information
[New Thread 1090525536 (LWP 13857)]
!ERROR: module(sql_server); clients.setTrace(true);
!             ^<module path> expected
include sql;
Sorry, but in the file HowtoStart and example shows that include sql; is 
not needed.
Mserver --set 
monet_mod_path=<monetdb-prefix>/lib(64)/MonetDB:<sql-prefix>/lib(64)/MonetDB 
--dbinit="module(sql_server); sql_server_start();"
This sentence is in my HowToStart (development SQL trunk)
I just followed my HowToStart, so someone should fix it.
Regards,
Romulo
------------------------------
Message: 4
Date: Thu, 9 Nov 2006 14:38:23 +0100
From: Fabian 
Subject: Re: [Monetdb-developers] Mserver including SQL module....
To: monetdb-developers@lists.sourceforge.net
Message-ID: <20061109133823.GQ30793@cwi.nl>
Content-Type: text/plain; charset=utf-8
On 09-11-2006 14:37:17 +0100, Romulo Goncalves wrote:
...
This sentence is in my HowToStart (development SQL trunk)
I just followed my HowToStart, so someone should fix it.
"someone"?
YOU!
------------------------------
Message: 5
Date: Thu, 09 Nov 2006 14:46:13 +0100
From: Romulo Goncalves 
Subject: Re: [Monetdb-developers] Mserver including SQL module....
To: Romulo Goncalves 
Cc: Fabian ,
  monetdb-developers@lists.sourceforge.net
Message-ID: <45533125.6010600@cwi.nl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Romulo Goncalves wrote:
...
Fabian Groffen wrote:
...
On 09-11-2006 10:16:28 +0100, Romulo Goncalves wrote:
...
...
# MonetDB Server v4.99.19
# Copyright (c) 1993-2006 CWI, all rights reserved
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs 
dynamically linked
# config:/ufs/goncalve/scratch/MonetDB/monetdb5/etc/MonetDB5.conf
# dbfarm:/ufs/goncalve/scratch/MonetDB/monetdb5/var/MonetDB5/dbfarm
# dbname:demo
# Visit http://monetdb.cwi.nl/ for further information
[New Thread 1090525536 (LWP 13857)]
!ERROR: module(sql_server); clients.setTrace(true);
!             ^<module path> expected
include sql;
Sorry, but in the file HowtoStart and example shows that include sql; is 
not needed.
Mserver --set 
monet_mod_path=<monetdb-prefix>/lib(64)/MonetDB:<sql-prefix>/lib(64)/MonetDB 
--dbinit="module(sql_server); sql_server_start();"
This sentence is in my HowToStart (development SQL trunk)
I just followed my HowToStart, so someone should fix it.
Regards,
Romulo
Well, I just realized that the HowToStart is created only for MonetDB4 
and not MonetDB5.
Sorry for the inconvenience.
Regards,
Romulo
------------------------------
Message: 6
Date: Thu, 9 Nov 2006 14:48:59 +0100
From: Fabian 
Subject: Re: [Monetdb-developers] Mserver including SQL module....
To: monetdb-developers@lists.sourceforge.net
Message-ID: <20061109134859.GS30793@cwi.nl>
Content-Type: text/plain; charset=utf-8
On 09-11-2006 14:46:13 +0100, Romulo Goncalves wrote:
...
...
This sentence is in my HowToStart (development SQL trunk)
I just followed my HowToStart, so someone should fix it.
Regards,
Romulo
Well, I just realized that the HowToStart is created only for MonetDB4 
and not MonetDB5.
Sorry for the inconvenience.
:)
Maybe it's time to make a section in the file for M5?
------------------------------
Message: 7
Date: Thu, 09 Nov 2006 20:25:05 +0100
From: Romulo Goncalves 
Subject: [Monetdb-developers] sql.start() is not reconized
  anymore.....
To: monetdb-developers@lists.sourceforge.net,	Martin Kersten

Message-ID: <45538091.40809@cwi.nl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Dear monetdb developers.
After the last update in M5 from Martin I start to have the following 
problem:
Starting program: 
/net/amelia/export/scratch1/goncalve/MonetDB/monetdb5/bin/mserver5 
--dbname=demo --set mapi_port=50000 --dbinit=include\ sql\;\ 
clients.setTrace\(true\)\;\ sql.start\(\)\;
[Thread debugging using libthread_db enabled]
[New Thread 46912510627904 (LWP 3435)]
!WARNING: GDKlockHome: created directory 
/ufs/goncalve/scratch/MonetDB/monetdb5/var/MonetDB5/dbfarm/demo/
!WARNING: GDKlockHome: ignoring empty or invalid .gdk_lock.
!WARNING: BBPdir: initializing BBP.
[New Thread 1082132832 (LWP 3438)]
# MonetDB Server v4.99.19
# Copyright (c) 1993-2006 CWI, all rights reserved
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically 
linked
# config:/ufs/goncalve/scratch/MonetDB/monetdb5/etc/MonetDB5.conf
# dbfarm:/ufs/goncalve/scratch/MonetDB/monetdb5/var/MonetDB5/dbfarm
# dbname:demo
# Visit http://monetdb.cwi.nl/ for further information
[New Thread 1090525536 (LWP 3439)]
#MALexception:malInclude:could not open file: sql
!ERROR: 'sql.start' undefined in user.main[2] _3:any := sql.start()
...
I am using M5 development trunk and the same for SQL. This changes 
related to sql.start() are to be applied in M4 and not in M5, right?
Regards,
Romulo
------------------------------
Message: 8
Date: Thu, 09 Nov 2006 20:52:18 +0100
From: Martin Kersten 
Subject: Re: [Monetdb-developers] sql.start() is not reconized
  anymore.....
Cc: monetdb-developers@lists.sourceforge.net
Message-ID: <455386F2.2060200@cwi.nl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Romulo Goncalves wrote:
...
Dear monetdb developers.
After the last update in M5 from Martin I start to have the following 
problem:
This problem is not (yet) confirmed.
mserver5 --dbinit="include sql;sql.start();"
seem to work in my setting.
An independent confirmation is needed.
Starting program: 
/net/amelia/export/scratch1/goncalve/MonetDB/monetdb5/bin/mserver5 
--dbname=demo --set mapi_port=50000 --dbinit=include\ sql\;\ 
clients.setTrace\(true\)\;\ sql.start\(\)\;
[Thread debugging using libthread_db enabled]
[New Thread 46912510627904 (LWP 3435)]
!WARNING: GDKlockHome: created directory 
/ufs/goncalve/scratch/MonetDB/monetdb5/var/MonetDB5/dbfarm/demo/
!WARNING: GDKlockHome: ignoring empty or invalid .gdk_lock.
!WARNING: BBPdir: initializing BBP.
[New Thread 1082132832 (LWP 3438)]
# MonetDB Server v4.99.19
# Copyright (c) 1993-2006 CWI, all rights reserved
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically 
linked
# config:/ufs/goncalve/scratch/MonetDB/monetdb5/etc/MonetDB5.conf
# dbfarm:/ufs/goncalve/scratch/MonetDB/monetdb5/var/MonetDB5/dbfarm
# dbname:demo
# Visit http://monetdb.cwi.nl/ for further information
[New Thread 1090525536 (LWP 3439)]
#MALexception:malInclude:could not open file: sql
!ERROR: 'sql.start' undefined in user.main[2] _3:any := sql.start()
...
I am using M5 development trunk and the same for SQL. This changes 
related to sql.start() are to be applied in M4 and not in M5, right?
Regards,
Romulo
------------------------------
Message: 9
Date: Thu, 9 Nov 2006 21:03:53 +0100
From: Fabian Groffen 
Subject: Re: [Monetdb-developers] sql.start() is not reconized
  anymore.....
To: monetdb-developers@lists.sourceforge.net
Message-ID: <20061109200353.GB16767@cwi.nl>
Content-Type: text/plain; charset=utf-8
On 09-11-2006 20:52:18 +0100, Martin Kersten wrote:
...
Romulo Goncalves wrote:
...
Dear monetdb developers.
After the last update in M5 from Martin I start to have the following 
problem:
This problem is not (yet) confirmed.
mserver5 --dbinit="include sql;sql.start();"
seem to work in my setting.
An independent confirmation is needed.
Starting program: 
/net/amelia/export/scratch1/goncalve/MonetDB/monetdb5/bin/mserver5 
--dbname=demo --set mapi_port=50000 --dbinit=include\ sql\;\ 
clients.setTrace\(true\)\;\ sql.start\(\)\;
[Thread debugging using libthread_db enabled]
[New Thread 46912510627904 (LWP 3435)]
!WARNING: GDKlockHome: created directory 
/ufs/goncalve/scratch/MonetDB/monetdb5/var/MonetDB5/dbfarm/demo/
!WARNING: GDKlockHome: ignoring empty or invalid .gdk_lock.
!WARNING: BBPdir: initializing BBP.
[New Thread 1082132832 (LWP 3438)]
# MonetDB Server v4.99.19
# Copyright (c) 1993-2006 CWI, all rights reserved
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically 
linked
# config:/ufs/goncalve/scratch/MonetDB/monetdb5/etc/MonetDB5.conf
# dbfarm:/ufs/goncalve/scratch/MonetDB/monetdb5/var/MonetDB5/dbfarm
# dbname:demo
# Visit http://monetdb.cwi.nl/ for further information
[New Thread 1090525536 (LWP 3439)]
#MALexception:malInclude:could not open file: sql
This indicates something is wrong unrelated to sql.start(): "sql" can't
be included at all.  Are you sure SQL was installed properly and all
(mod?) paths point into the right directions?  I saw some changes
recently related to monet_mod_path...
I update all my sources and now I do not have problems.
I will tomorrow update the HowToStart. It should also include M5. ;)
If someone does not agree please let me know.

Thanks for the help.

Regards,
Romulo
...
------------------------------
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
------------------------------
_______________________________________________
Monetdb-developers mailing list
Monetdb-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-developers
End of Monetdb-developers Digest, Vol 6, Issue 14
*************************************************

Romulo Goncalves

tags

participants (1)