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 <R.A.Goncalves@cwi.nl>
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 <Fabian.Groffen@cwi.nl>
Subject: Re: [Monetdb-developers] Mserver including SQL module....
To: Romulo Goncalves <R.A.Goncalves@cwi.nl>
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 <R.A.Goncalves@cwi.nl>
Subject: Re: [Monetdb-developers] Mserver including SQL module....
To: Fabian <Fabian.Groffen@cwi.nl>,
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 <Fabian.Groffen@cwi.nl>
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 <R.A.Goncalves@cwi.nl>
Subject: Re: [Monetdb-developers] Mserver including SQL module....
To: Romulo Goncalves <R.A.Goncalves@cwi.nl>
Cc: Fabian <Fabian.Groffen@cwi.nl>,
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 <Fabian.Groffen@cwi.nl>
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 <R.A.Goncalves@cwi.nl>
Subject: [Monetdb-developers] sql.start() is not reconized
anymore.....
To: monetdb-developers@lists.sourceforge.net, Martin Kersten
<Martin.Kersten@cwi.nl>
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 <Martin.Kersten@cwi.nl>
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 <Fabian.Groffen@cwi.nl>
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
Romulo Goncalves