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

Romulo Goncalves R.A.Goncalves at cwi.nl
Thu Nov 9 22:44:09 CET 2006


monetdb-developers-request at lists.sourceforge.net wrote:
> Send Monetdb-developers mailing list submissions to
> 	monetdb-developers at 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 at lists.sourceforge.net
> 
> You can reach the person managing the list at
> 	monetdb-developers-owner at 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 at cwi.nl>
> Subject: [Monetdb-developers] Mserver including SQL module....
> To: monetdb-developers at lists.sourceforge.net
> Message-ID: <4552F1EC.5050701 at 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 at cwi.nl>
> Subject: Re: [Monetdb-developers] Mserver including SQL module....
> To: Romulo Goncalves <R.A.Goncalves at cwi.nl>
> Cc: monetdb-developers at lists.sourceforge.net
> Message-ID: <20061109095822.GG30793 at 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 at cwi.nl>
> Subject: Re: [Monetdb-developers] Mserver including SQL module....
> To: Fabian <Fabian.Groffen at cwi.nl>,
> 	monetdb-developers at lists.sourceforge.net
> Message-ID: <45532F0D.4030403 at 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 at cwi.nl>
> Subject: Re: [Monetdb-developers] Mserver including SQL module....
> To: monetdb-developers at lists.sourceforge.net
> Message-ID: <20061109133823.GQ30793 at 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 at cwi.nl>
> Subject: Re: [Monetdb-developers] Mserver including SQL module....
> To: Romulo Goncalves <R.A.Goncalves at cwi.nl>
> Cc: Fabian <Fabian.Groffen at cwi.nl>,
> 	monetdb-developers at lists.sourceforge.net
> Message-ID: <45533125.6010600 at 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 at cwi.nl>
> Subject: Re: [Monetdb-developers] Mserver including SQL module....
> To: monetdb-developers at lists.sourceforge.net
> Message-ID: <20061109134859.GS30793 at 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 at cwi.nl>
> Subject: [Monetdb-developers] sql.start() is not reconized
> 	anymore.....
> To: monetdb-developers at lists.sourceforge.net,	Martin Kersten
> 	<Martin.Kersten at cwi.nl>
> Message-ID: <45538091.40809 at 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 at cwi.nl>
> Subject: Re: [Monetdb-developers] sql.start() is not reconized
> 	anymore.....
> Cc: monetdb-developers at lists.sourceforge.net
> Message-ID: <455386F2.2060200 at 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 at cwi.nl>
> Subject: Re: [Monetdb-developers] sql.start() is not reconized
> 	anymore.....
> To: monetdb-developers at lists.sourceforge.net
> Message-ID: <20061109200353.GB16767 at 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-developers
> 
> 
> End of Monetdb-developers Digest, Vol 6, Issue 14
> *************************************************





More information about the developers-list mailing list