- users-list - monetdb.org

[MonetDB-users] Errors after executing "set history=true" for saving the query history
by Roberto Fernandez 05 Nov '11

05 Nov '11

Hi, I was trying to save my history based on this documentation http://www.monetdb.org/Documentation/Cookbooks/SQLrecipies/History http://www.monetdb.org/Documentation/Cookbooks/SQLrecipies/History And this is what is happening: $ mclient -dtest-db -umonetdb password: Welcome to mclient, the MonetDB/SQL interactive terminal (Aug2011-SP2) Database: MonetDB v11.5.7 (Aug2011-SP2), 'test-db' Type \q to quit, \? for a list of available commands auto commit mode: on sql>select 1; +--------------+ | single_value | +==============+ | 1 | +--------------+ 1 tuple (0.623ms) sql>select count(*) from narvq.narvq where zip5 = '81657'; +------+ | L5 | +======+ | 2785 | +------+ 1 tuple (1.6s) sql>set history=true; sql>select 1; +--------------+ | single_value | +==============+ | 1 | +--------------+ 1 tuple (0.232ms) sql>select count(*) from narvq.narvq where zip5 = '81657'; TypeException:user.s0_1[1]:'user.keepquery' undefined in: _23:any := user.keepquery(_24:wrd, _25:str, _26:lng, _27:lng) TypeException:user.s0_1[32]:'user.keepcall' undefined in: _73:any := user.keepcall(_24:wrd, ctime:timestamp, args:str, xtime:lng, rtime:lng, foot:lng, memory:lng, tuples:wrd, inblock:lng, oublock:lng) SQLException:SQLengine:Program contains errors sql>select * from queryHistory; TypeException:user.s5_1[1]:'user.keepquery' undefined in: _43:any := user.keepquery(_44:wrd, _45:str, _46:lng, _47:lng) TypeException:user.s5_1[48]:'user.keepcall' undefined in: _111:any := user.keepcall(_44:wrd, ctime:timestamp, args:str, xtime:lng, rtime:lng, foot:lng, memory:lng, tuples:wrd, inblock:lng, oublock:lng) SQLException:SQLengine:Program contains errors sql>select 1; TypeException:user.s0_1[1]:'user.keepquery' undefined in: _12:any := user.keepquery(_13:wrd, _14:str, _15:lng, _16:lng) TypeException:user.s0_1[24]:'user.keepcall' undefined in: _55:any := user.keepcall(_13:wrd, ctime:timestamp, args:str, xtime:lng, rtime:lng, foot:lng, memory:lng, tuples:wrd, inblock:lng, oublock:lng) SQLException:SQLengine:Program contains errors sql>set history=false; TypeException:user.s0_1[1]:'user.keepquery' undefined in: _2:any := user.keepquery(_3:wrd, _4:str, _5:lng, _6:lng) TypeException:user.s0_1[19]:'user.keepcall' undefined in: _41:any := user.keepcall(_3:wrd, ctime:timestamp, args:str, xtime:lng, rtime:lng, foot:lng, memory:lng, tuples:wrd, inblock:lng, oublock:lng) SQLException:SQLengine:Program contains errors sql> SERVER INFORMATION: It is a Amazon Web Services Linux distribution (based on CentOS) $ mserver5 --version MonetDB 5 server v11.5.7 "Aug2011-SP2" (64-bit, 64-bit oids) Copyright (c) 1993-July 2008 CWI Copyright (c) August 2008-2011 MonetDB B.V., all rights reserved Visit http://www.monetdb.org/ for further information Found 7.3GiB available memory, 2 available cpu cores Libraries: libpcre: 7.8 2008-09-05 (compiled with 7.8) openssl: OpenSSL 1.0.0e 6 Sep 2011 (compiled with OpenSSL 1.0.0e-fips 6 Sep 2011) libxml2: 2.7.6 (compiled with 2.7.6) Compiled by: ec2-user@domU-12-31-39-0E-8D-F2 (x86_64-unknown-linux-gnu) Compilation: gcc -g -O2 Linking : /usr/bin/ld -m elf_x86_64 I will really appreciate any help provided. Thanks, Roberto F -- View this message in context: http://old.nabble.com/Errors-after-executing-%22set-history%3Dtrue%22-for-s… Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] Errors saving query history
by Roberto Fernandez 05 Nov '11

05 Nov '11

Hi, I was trying to save my history based on this documentation http://www.monetdb.org/Documentation/Cookbooks/SQLrecipies/History http://www.monetdb.org/Documentation/Cookbooks/SQLrecipies/History And this is what is happening: $ mclient -dtest-db -umonetdb password: Welcome to mclient, the MonetDB/SQL interactive terminal (Aug2011-SP2) Database: MonetDB v11.5.7 (Aug2011-SP2), 'test-db' Type \q to quit, \? for a list of available commands auto commit mode: on sql>select 1; +--------------+ | single_value | +==============+ | 1 | +--------------+ 1 tuple (0.623ms) sql>select count(*) from narvq.narvq where zip5 = '81657'; +------+ | L5 | +======+ | 2785 | +------+ 1 tuple (1.6s) sql>set history=true; sql>select 1; +--------------+ | single_value | +==============+ | 1 | +--------------+ 1 tuple (0.232ms) sql>select count(*) from narvq.narvq where zip5 = '81657'; TypeException:user.s0_1[1]:'user.keepquery' undefined in: _23:any := user.keepquery(_24:wrd, _25:str, _26:lng, _27:lng) TypeException:user.s0_1[32]:'user.keepcall' undefined in: _73:any := user.keepcall(_24:wrd, ctime:timestamp, args:str, xtime:lng, rtime:lng, foot:lng, memory:lng, tuples:wrd, inblock:lng, oublock:lng) SQLException:SQLengine:Program contains errors sql>select * from queryHistory; TypeException:user.s5_1[1]:'user.keepquery' undefined in: _43:any := user.keepquery(_44:wrd, _45:str, _46:lng, _47:lng) TypeException:user.s5_1[48]:'user.keepcall' undefined in: _111:any := user.keepcall(_44:wrd, ctime:timestamp, args:str, xtime:lng, rtime:lng, foot:lng, memory:lng, tuples:wrd, inblock:lng, oublock:lng) SQLException:SQLengine:Program contains errors sql>select 1; TypeException:user.s0_1[1]:'user.keepquery' undefined in: _12:any := user.keepquery(_13:wrd, _14:str, _15:lng, _16:lng) TypeException:user.s0_1[24]:'user.keepcall' undefined in: _55:any := user.keepcall(_13:wrd, ctime:timestamp, args:str, xtime:lng, rtime:lng, foot:lng, memory:lng, tuples:wrd, inblock:lng, oublock:lng) SQLException:SQLengine:Program contains errors sql>set history=false; TypeException:user.s0_1[1]:'user.keepquery' undefined in: _2:any := user.keepquery(_3:wrd, _4:str, _5:lng, _6:lng) TypeException:user.s0_1[19]:'user.keepcall' undefined in: _41:any := user.keepcall(_3:wrd, ctime:timestamp, args:str, xtime:lng, rtime:lng, foot:lng, memory:lng, tuples:wrd, inblock:lng, oublock:lng) SQLException:SQLengine:Program contains errors sql> SERVER INFORMATION: It is a Amazon Web Services Linux distribution (based on CentOS) $ mserver5 --version MonetDB 5 server v11.5.7 "Aug2011-SP2" (64-bit, 64-bit oids) Copyright (c) 1993-July 2008 CWI Copyright (c) August 2008-2011 MonetDB B.V., all rights reserved Visit http://www.monetdb.org/ for further information Found 7.3GiB available memory, 2 available cpu cores Libraries: libpcre: 7.8 2008-09-05 (compiled with 7.8) openssl: OpenSSL 1.0.0e 6 Sep 2011 (compiled with OpenSSL 1.0.0e-fips 6 Sep 2011) libxml2: 2.7.6 (compiled with 2.7.6) Compiled by: ec2-user@domU-12-31-39-0E-8D-F2 (x86_64-unknown-linux-gnu) Compilation: gcc -g -O2 Linking : /usr/bin/ld -m elf_x86_64 I will really appreciate any help provided. Thanks, Roberto F -- View this message in context: http://old.nabble.com/Errors-saving-query-history-tp32786364p32786364.html Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] Errors saving query history
by Roberto Fernandez 05 Nov '11

05 Nov '11

Hi, I was trying to save my history based on this documentation http://www.monetdb.org/Documentation/Cookbooks/SQLrecipies/History http://www.monetdb.org/Documentation/Cookbooks/SQLrecipies/History And this is what is happening: $ mclient -dtest-db -umonetdb password: Welcome to mclient, the MonetDB/SQL interactive terminal (Aug2011-SP2) Database: MonetDB v11.5.7 (Aug2011-SP2), 'test-db' Type \q to quit, \? for a list of available commands auto commit mode: on sql>select 1; +--------------+ | single_value | +==============+ | 1 | +--------------+ 1 tuple (0.623ms) sql>select count(*) from narvq.narvq where zip5 = '81657'; +------+ | L5 | +======+ | 2785 | +------+ 1 tuple (1.6s) sql>set history=true; sql>select 1; +--------------+ | single_value | +==============+ | 1 | +--------------+ 1 tuple (0.232ms) sql>select count(*) from narvq.narvq where zip5 = '81657'; TypeException:user.s0_1[1]:'user.keepquery' undefined in: _23:any := user.keepquery(_24:wrd, _25:str, _26:lng, _27:lng) TypeException:user.s0_1[32]:'user.keepcall' undefined in: _73:any := user.keepcall(_24:wrd, ctime:timestamp, args:str, xtime:lng, rtime:lng, foot:lng, memory:lng, tuples:wrd, inblock:lng, oublock:lng) SQLException:SQLengine:Program contains errors sql>select * from queryHistory; TypeException:user.s5_1[1]:'user.keepquery' undefined in: _43:any := user.keepquery(_44:wrd, _45:str, _46:lng, _47:lng) TypeException:user.s5_1[48]:'user.keepcall' undefined in: _111:any := user.keepcall(_44:wrd, ctime:timestamp, args:str, xtime:lng, rtime:lng, foot:lng, memory:lng, tuples:wrd, inblock:lng, oublock:lng) SQLException:SQLengine:Program contains errors sql>select 1; TypeException:user.s0_1[1]:'user.keepquery' undefined in: _12:any := user.keepquery(_13:wrd, _14:str, _15:lng, _16:lng) TypeException:user.s0_1[24]:'user.keepcall' undefined in: _55:any := user.keepcall(_13:wrd, ctime:timestamp, args:str, xtime:lng, rtime:lng, foot:lng, memory:lng, tuples:wrd, inblock:lng, oublock:lng) SQLException:SQLengine:Program contains errors sql>set history=false; TypeException:user.s0_1[1]:'user.keepquery' undefined in: _2:any := user.keepquery(_3:wrd, _4:str, _5:lng, _6:lng) TypeException:user.s0_1[19]:'user.keepcall' undefined in: _41:any := user.keepcall(_3:wrd, ctime:timestamp, args:str, xtime:lng, rtime:lng, foot:lng, memory:lng, tuples:wrd, inblock:lng, oublock:lng) SQLException:SQLengine:Program contains errors sql> SERVER INFORMATION: It is a Amazon Web Services Linux distribution (based on CentOS) $ mserver5 --version MonetDB 5 server v11.5.7 "Aug2011-SP2" (64-bit, 64-bit oids) Copyright (c) 1993-July 2008 CWI Copyright (c) August 2008-2011 MonetDB B.V., all rights reserved Visit http://www.monetdb.org/ for further information Found 7.3GiB available memory, 2 available cpu cores Libraries: libpcre: 7.8 2008-09-05 (compiled with 7.8) openssl: OpenSSL 1.0.0e 6 Sep 2011 (compiled with OpenSSL 1.0.0e-fips 6 Sep 2011) libxml2: 2.7.6 (compiled with 2.7.6) Compiled by: ec2-user@domU-12-31-39-0E-8D-F2 (x86_64-unknown-linux-gnu) Compilation: gcc -g -O2 Linking : /usr/bin/ld -m elf_x86_64 I will really appreciate any help provided. Thanks, Roberto F -- View this message in context: http://old.nabble.com/Errors-saving-query-history-tp32786363p32786363.html Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] Errors saving query history
by Roberto Fernandez 05 Nov '11

05 Nov '11

Hi, I was trying to save my history based on this documentation http://www.monetdb.org/Documentation/Cookbooks/SQLrecipies/History http://www.monetdb.org/Documentation/Cookbooks/SQLrecipies/History And this is what is happening: $ mclient -dtest-db -umonetdb password: Welcome to mclient, the MonetDB/SQL interactive terminal (Aug2011-SP2) Database: MonetDB v11.5.7 (Aug2011-SP2), 'test-db' Type \q to quit, \? for a list of available commands auto commit mode: on sql>select 1; +--------------+ | single_value | +==============+ | 1 | +--------------+ 1 tuple (0.623ms) sql>select count(*) from narvq.narvq where zip5 = '81657'; +------+ | L5 | +======+ | 2785 | +------+ 1 tuple (1.6s) sql>set history=true; sql>select 1; +--------------+ | single_value | +==============+ | 1 | +--------------+ 1 tuple (0.232ms) sql>select count(*) from narvq.narvq where zip5 = '81657'; TypeException:user.s0_1[1]:'user.keepquery' undefined in: _23:any := user.keepquery(_24:wrd, _25:str, _26:lng, _27:lng) TypeException:user.s0_1[32]:'user.keepcall' undefined in: _73:any := user.keepcall(_24:wrd, ctime:timestamp, args:str, xtime:lng, rtime:lng, foot:lng, memory:lng, tuples:wrd, inblock:lng, oublock:lng) SQLException:SQLengine:Program contains errors sql>select * from queryHistory; TypeException:user.s5_1[1]:'user.keepquery' undefined in: _43:any := user.keepquery(_44:wrd, _45:str, _46:lng, _47:lng) TypeException:user.s5_1[48]:'user.keepcall' undefined in: _111:any := user.keepcall(_44:wrd, ctime:timestamp, args:str, xtime:lng, rtime:lng, foot:lng, memory:lng, tuples:wrd, inblock:lng, oublock:lng) SQLException:SQLengine:Program contains errors sql>select 1; TypeException:user.s0_1[1]:'user.keepquery' undefined in: _12:any := user.keepquery(_13:wrd, _14:str, _15:lng, _16:lng) TypeException:user.s0_1[24]:'user.keepcall' undefined in: _55:any := user.keepcall(_13:wrd, ctime:timestamp, args:str, xtime:lng, rtime:lng, foot:lng, memory:lng, tuples:wrd, inblock:lng, oublock:lng) SQLException:SQLengine:Program contains errors sql>set history=false; TypeException:user.s0_1[1]:'user.keepquery' undefined in: _2:any := user.keepquery(_3:wrd, _4:str, _5:lng, _6:lng) TypeException:user.s0_1[19]:'user.keepcall' undefined in: _41:any := user.keepcall(_3:wrd, ctime:timestamp, args:str, xtime:lng, rtime:lng, foot:lng, memory:lng, tuples:wrd, inblock:lng, oublock:lng) SQLException:SQLengine:Program contains errors sql> SERVER INFORMATION: It is a Amazon Web Services Linux distribution (based on CentOS) $ mserver5 --version MonetDB 5 server v11.5.7 "Aug2011-SP2" (64-bit, 64-bit oids) Copyright (c) 1993-July 2008 CWI Copyright (c) August 2008-2011 MonetDB B.V., all rights reserved Visit http://www.monetdb.org/ for further information Found 7.3GiB available memory, 2 available cpu cores Libraries: libpcre: 7.8 2008-09-05 (compiled with 7.8) openssl: OpenSSL 1.0.0e 6 Sep 2011 (compiled with OpenSSL 1.0.0e-fips 6 Sep 2011) libxml2: 2.7.6 (compiled with 2.7.6) Compiled by: ec2-user@domU-12-31-39-0E-8D-F2 (x86_64-unknown-linux-gnu) Compilation: gcc -g -O2 Linking : /usr/bin/ld -m elf_x86_64 I will really appreciate any help provided. Thanks, Roberto F -- View this message in context: http://old.nabble.com/Errors-saving-query-history-tp32786355p32786355.html Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] compile error when build MonetDB 11.5.7 on CentOS 5.5
by Allen Zhang 04 Nov '11

04 Nov '11

Hi, When compile on CentOS 5.5, following error pop up, can any one tell me which version of libcom_err.so is needed for this MonetDB version? Thanks Allen make[5]: Entering directory `/usr/src/MonetDB-11.5.7/common/stream' /bin/sh ../../libtool --tag=CC --mode=link gcc -DLIBSTREAM -g -O2 -D_REENTRANT -version-info 2:2:0 -o libstream.la -rpath /usr/local/MonetDBAug2011-SP2/lib libstream_la-stream.lo -lbz2 -L/usr/kerberos/lib64 -lssl -lcrypto -ldl -lz -L/usr/kerberos/lib64 -lcurl -ldl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lssl -lcrypto -lz -pthread libtool: link: gcc -shared -fPIC -DPIC .libs/libstream_la-stream.o -lbz2 -L/usr/kerberos/lib64 -lcurl -ldl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lssl -lcrypto -lz -O2 -pthread -pthread -Wl,-soname -Wl,libstream.so.2 -o .libs/libstream.so.2.0.2 /usr/bin/ld: skipping incompatible /usr/lib/libcom_err.so when searching for -lcom_err /usr/bin/ld: skipping incompatible /usr/lib/libcom_err.a when searching for -lcom_err /usr/bin/ld: cannot find -lcom_err collect2: ld returned 1 exit status

2 2

Re: [MonetDB-users] compile error when build MonetDB 11.5.7 on CentOS 5.5
by Stefan Manegold 04 Nov '11

04 Nov '11

Hi Allen, from your log, I guess your CentS is 64 bit, right? Is the installed libcom_err also 64 bit or 32 bit? The linker says the sitcom_err it finds is "incompatible" ... Stefan ----- Reply message ----- From: "Allen Zhang" <azhang(a)pmci-usa.com> To: <monetdb-users(a)lists.sourceforge.net> Subject: [MonetDB-users] compile error when build MonetDB 11.5.7 on CentOS 5.5 Date: Fri, Nov 4, 2011 01:07 Hi, When compile on CentOS 5.5, following error pop up, can any one tell me which version of libcom_err.so is needed for this MonetDB version? Thanks Allen make[5]: Entering directory `/usr/src/MonetDB-11.5.7/common/stream' /bin/sh ../../libtool --tag=CC --mode=link gcc -DLIBSTREAM -g -O2 -D_REENTRANT -version-info 2:2:0 -o libstream.la -rpath /usr/local/MonetDBAug2011-SP2/lib libstream_la-stream.lo -lbz2 -L/usr/kerberos/lib64 -lssl -lcrypto -ldl -lz -L/usr/kerberos/lib64 -lcurl -ldl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lssl -lcrypto -lz -pthread libtool: link: gcc -shared -fPIC -DPIC .libs/libstream_la-stream.o -lbz2 -L/usr/kerberos/lib64 -lcurl -ldl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lssl -lcrypto -lz -O2 -pthread -pthread -Wl,-soname -Wl,libstream.so.2 -o .libs/libstream.so.2.0.2 /usr/bin/ld: skipping incompatible /usr/lib/libcom_err.so when searching for -lcom_err /usr/bin/ld: skipping incompatible /usr/lib/libcom_err.a when searching for -lcom_err /usr/bin/ld: cannot find -lcom_err collect2: ld returned 1 exit status

1 0

[MonetDB-users] I want to join this group:)
by Tony Bai 02 Nov '11

02 Nov '11

Could you add me as a member of Monetdb please? Thanks, Tony

1 0

[MonetDB-users] Temporal coalescing query error
by Alexander S 29 Oct '11

29 Oct '11

Hello, I'm attempting to use monetdb for some temporal queries. Some queries require the output to be coalesced. For example, with schema emp(empno int, ts date, te date) the tuples (00001, '1/1/2001', '2/1/2001'), (00001, '2/1/2001', '3/1/2001') are output as (00001, '1/1/2001', '3/1/2001'). My coalescing query works in both MS SQL Server and DB2 but MonetDB gives me the error "SELECT: no such column 'm.ts'". 1) A leaner alternative query form using window clauses (ROWS UNBOUNDED PRECEDING) doesn't appear to be supported in MonetDB. So I'm stuck. Any help would be appreciated. Query: WITH Emps(empno, ts, te) AS (SELECT empno, ts, te FROM emp) SELECT DISTINCT F.empno, F.ts, L.te FROM Emps AS F, Emps AS L WHERE F.ts < L.te AND F.empno = L.empno AND NOT EXISTS (SELECT * FROM Emps AS M WHERE M.empno = F.empno AND F.ts < M.ts AND M.ts < L.te AND NOT EXISTS (SELECT * FROM Emps AS T1 WHERE T1.empno = F.empno AND T1.ts < M.ts AND M.ts <= T1.te) ) AND NOT EXISTS (SELECT * FROM Emps AS T2 WHERE T2.empno = F.empno AND ((T2.ts < F.ts AND F.ts <= T2.te) OR (T2.ts <= L.te AND L.te < T2.te)) ); Thanks, Alex -- View this message in context: http://old.nabble.com/Temporal-coalescing-query-error-tp32742108p32742108.h… Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] eEnd of Stream
by nat lu 28 Oct '11

28 Oct '11

I'm using Monet 11.5 on Ubuntu 11.04. Ive created a database and am attempting to run a series of queries against it with a test script. This is in attempt to use Monet with Apache Jena. I had earlier mailed about a problem with temp tables, but have dodged that by using the monetdb account for now. The first few succeed, but then I get the following error: java.sql.SQLException: Read from localhost:50000: End of stream reached (mserver still alive?) Why does this happen, under what circumstances does it arise ? Is there anything I can do to avoid it ? This is the query that it fails on: SELECT R_1.lex AS V_1_lex, R_1.datatype AS V_1_datatype, R_1.lang AS V_1_lang, R_1.type AS V_1_type, R_2.lex AS V_2_lex, R_2.datatype AS V_2_datatype, R_2.lang AS V_2_lang, R_2.type AS V_2_type FROM ( SELECT T_1.s AS X_1 FROM Triples AS T_1 WHERE ( T_1.p = 2004134117598721274 AND T_1.o = 435905340492217258 ) ) AS T_1 LEFT OUTER JOIN Triples AS T_2 ON ( T_2.p = 3816485599920428794 AND T_1.X_1 = T_2.s ) LEFT OUTER JOIN Nodes AS R_1 ON ( T_1.X_1 = R_1.hash ) LEFT OUTER JOIN Nodes AS R_2 ON ( T_2.o = R_2.hash )

3 7

[MonetDB-users] IsNumeric() clause in MonetDB
by Osmin Castillo 26 Oct '11

26 Oct '11

Hi everyone: How can I test if a VARCHAR field has numeric data?, at SQLServer I use IsNumeric() clause, what can i use in MonetDB? thanks in advance Osmin

1 0