May 2006 - developers-list

[Monetdb-developers] Gebruik MonetDB, Python 2.3, WinXP
by drs Slinger Jansen 31 May '06

31 May '06

Hoi hoi, ik probeer al wat uurtjes Monet aan te spreken vanuit Python onder Windows XP, maar het lukt me niet erg. Ik heb de MSI gebruikt, en daarom mis ik de Mapi. Kan ik deze alsnog bouwen/installeren? En is dat uberhaupt wat ik wil? Ik ben ondertussen een pywin32 rijker. Ik wil Monetdb gebruiken vanuit een webservice met hoog volume verkeer (jaja, op een XP server, ik weet het). Kan ik eventueel even langs lopen? Slinger Jansen

2 1

[Monetdb-developers] compiler warnings
by Sjoerd Mullender 29 May '06

29 May '06

With the latest compiler on Fedora Core 5 I get these warnings when compiling mapi.java (see attached file warnings1.txt). And when compiling the jdbc tests I get the warnings in warnings2.txt. Finally, when compiling the jdbc examples I get the warnings in warnings3.txt. Should something be done about these? -- Sjoerd Mullender /usr/bin/ant -f /home/sjoerd/src/devel/MonetDB/src/mapi/clients/java/build.xml -Dbuilddir=/home/sjoerd/src/devel/MonetDB/Linux/src/mapi/clients/java -Djardir=/home/sjoerd/src/devel/MonetDB/Linux/src/mapi/clients/java jar_mapi Buildfile: /home/sjoerd/src/devel/MonetDB/src/mapi/clients/java/build.xml prepare: compile_mapi: [echo] Compiling Java Mapi [javac] Compiling 3 source files to /home/sjoerd/src/devel/MonetDB/Linux/src/mapi/clients/java [javac] ---------- [javac] 1. WARNING in /home/sjoerd/src/devel/MonetDB/src/mapi/clients/java/mapi/Mapi.java [javac] (at line 145) [javac] private int languageId= LANG_MAL; [javac] ^^^^^^^^^^ [javac] The field Mapi.languageId is never read locally [javac] ---------- [javac] ---------- [javac] 2. WARNING in /home/sjoerd/src/devel/MonetDB/src/mapi/clients/java/mapi/Mapi.java [javac] (at line 148) [javac] private boolean everything = false; [javac] ^^^^^^^^^^ [javac] The field Mapi.everything is never read locally [javac] ---------- [javac] ---------- [javac] 3. WARNING in /home/sjoerd/src/devel/MonetDB/src/mapi/clients/java/mapi/Mapi.java [javac] (at line 152) [javac] private boolean eos = false; [javac] ^^^ [javac] The field Mapi.eos is never read locally [javac] ---------- [javac] ---------- [javac] 4. WARNING in /home/sjoerd/src/devel/MonetDB/src/mapi/clients/java/mapi/Mapi.java [javac] (at line 169) [javac] private int minfields= 0; [javac] ^^^^^^^^^ [javac] The field Mapi.minfields is never read locally [javac] ---------- [javac] ---------- [javac] 5. WARNING in /home/sjoerd/src/devel/MonetDB/src/mapi/clients/java/mapi/Mapi.java [javac] (at line 188) [javac] private String hostname( String monetport ){ [javac] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [javac] The method hostname(String) from the type Mapi is never used locally [javac] ---------- [javac] ---------- [javac] 6. WARNING in /home/sjoerd/src/devel/MonetDB/src/mapi/clients/java/mapi/Mapi.java [javac] (at line 194) [javac] private int portnr( String monetport ){ [javac] ^^^^^^^^^^^^^^^^^^^^^^^^^^ [javac] The method portnr(String) from the type Mapi is never used locally [javac] ---------- [javac] ---------- [javac] 7. WARNING in /home/sjoerd/src/devel/MonetDB/src/mapi/clients/java/mapi/Mapi.java [javac] (at line 588) [javac] private void storeBind(){ [javac] ^^^^^^^^^^^ [javac] The method storeBind() from the type Mapi is never used locally [javac] ---------- [javac] ---------- [javac] 8. WARNING in /home/sjoerd/src/devel/MonetDB/src/mapi/clients/java/mapi/Mapi.java [javac] (at line 1007) [javac] String left,right; [javac] ^^^^ [javac] The local variable left is never read [javac] ---------- [javac] ---------- [javac] 9. WARNING in /home/sjoerd/src/devel/MonetDB/src/mapi/clients/java/mapi/Mapi.java [javac] (at line 1007) [javac] String left,right; [javac] ^^^^^ [javac] The local variable right is never read [javac] ---------- [javac] ---------- [javac] 10. WARNING in /home/sjoerd/src/devel/MonetDB/src/mapi/clients/java/mapi/Mapi.java [javac] (at line 1306) [javac] int i, sr=rownr; [javac] ^^ [javac] The local variable sr is never read [javac] ---------- [javac] ---------- [javac] 11. WARNING in /home/sjoerd/src/devel/MonetDB/src/mapi/clients/java/mapi/Mapi.java [javac] (at line 1413) [javac] int n=0; [javac] ^ [javac] The local variable n is never read [javac] ---------- [javac] ---------- [javac] 12. WARNING in /home/sjoerd/src/devel/MonetDB/src/mapi/clients/java/mapi/Mapi.java [javac] (at line 1414) [javac] int len= 0; [javac] ^^^ [javac] The local variable len is never read [javac] ---------- [javac] ---------- [javac] 13. WARNING in /home/sjoerd/src/devel/MonetDB/src/mapi/clients/java/mapi/Mapi.java [javac] (at line 1415) [javac] String s=""; [javac] ^ [javac] The local variable s is never read [javac] ---------- [javac] ---------- [javac] 14. WARNING in /home/sjoerd/src/devel/MonetDB/src/mapi/clients/java/mapi/Mapi.java [javac] (at line 1486) [javac] private void keepProp(String name, String colname){ [javac] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [javac] The method keepProp(String, String) from the type Mapi is never used locally [javac] ---------- [javac] ---------- [javac] 15. WARNING in /home/sjoerd/src/devel/MonetDB/src/mapi/clients/java/mapi/Mapi.java [javac] (at line 1509) [javac] String s= columns[i].columnname= fetchField(i); [javac] ^ [javac] The local variable s is never read [javac] ---------- [javac] ---------- [javac] 16. WARNING in /home/sjoerd/src/devel/MonetDB/src/mapi/clients/java/mapi/Mapi.java [javac] (at line 1591) [javac] private int unquoteInternal(char msg[], int first) [javac] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [javac] The method unquoteInternal(char[], int) from the type Mapi is never used locally [javac] ---------- [javac] ---------- [javac] 17. WARNING in /home/sjoerd/src/devel/MonetDB/src/mapi/clients/java/mapi/Mapi.java [javac] (at line 1690) [javac] int size= msg.length(); [javac] ^^^^ [javac] The local variable size is never read [javac] ---------- [javac] ---------- [javac] 18. WARNING in /home/sjoerd/src/devel/MonetDB/src/mapi/clients/java/mapi/Mapi.java [javac] (at line 1749) [javac] private void dumpLine(int i){ [javac] ^^^^^^^^^^^^^^^ [javac] The method dumpLine(int) from the type Mapi.RowCache is never used locally [javac] ---------- [javac] ---------- [javac] 19. WARNING in /home/sjoerd/src/devel/MonetDB/src/mapi/clients/java/mapi/Mapi.java [javac] (at line 1754) [javac] private void dumpCacheStatus(){ [javac] ^^^^^^^^^^^^^^^^^ [javac] The method dumpCacheStatus() from the type Mapi.RowCache is never used locally [javac] ---------- [javac] ---------- [javac] 20. WARNING in /home/sjoerd/src/devel/MonetDB/src/mapi/clients/java/mapi/MapiException.java [javac] (at line 28) [javac] class MapiException extends Exception { [javac] ^^^^^^^^^^^^^ [javac] The serializable class MapiException does not declare a static final serialVersionUID field of type long [javac] ---------- [javac] 20 problems (20 warnings) jar_mapi: [jar] Building jar: /home/sjoerd/src/devel/MonetDB/Linux/src/mapi/clients/java/mapi.jar BUILD SUCCESSFUL Total time: 7 seconds /usr/bin/ant -f /home/sjoerd/src/devel/sql/src/jdbc/tests/build.xml -Dbuilddir=/home/sjoerd/src/devel/sql/Linux/src/jdbc/tests -Djardir=/home/sjoerd/src/devel/sql/Linux/src/jdbc/tests compile Buildfile: /home/sjoerd/src/devel/sql/src/jdbc/tests/build.xml prepare: compile: [echo] Compiling JDBC tests [javac] Compiling 13 source files to /home/sjoerd/src/devel/sql/Linux/src/jdbc/tests [javac] ---------- [javac] 1. WARNING in /home/sjoerd/src/devel/sql/src/jdbc/tests/Test_Csavepoints.java [javac] (at line 50) [javac] Savepoint sp1 = con.setSavepoint(); [javac] ^^^ [javac] The local variable sp1 is never read [javac] ---------- [javac] ---------- [javac] 2. WARNING in /home/sjoerd/src/devel/sql/src/jdbc/tests/Test_PStypes.java [javac] (at line 27) [javac] ResultSet rs = null; [javac] ^^ [javac] The local variable rs is never read [javac] ---------- [javac] 2 problems (2 warnings) BUILD SUCCESSFUL Total time: 7 seconds /usr/bin/ant -f /home/sjoerd/src/devel/sql/src/jdbc/build.xml -Dbuilddir=/home/sjoerd/src/devel/sql/Linux/src/jdbc -Djardir=/home/sjoerd/src/devel/sql/Linux/src/jdbc jar_jdbcclient Buildfile: /home/sjoerd/src/devel/sql/src/jdbc/build.xml prepare: [mkdir] Created dir: /home/sjoerd/src/devel/sql/Linux/src/jdbc/example [echo] Debug is true, optimise is true driver: compile_jdbc: [echo] Compiling JDBC driver [javac] Compiling 11 source files to /home/sjoerd/src/devel/sql/Linux/src/jdbc [javac] ---------- [javac] 1. WARNING in /home/sjoerd/src/devel/sql/src/jdbc/nl/cwi/monetdb/jdbc/MonetConnection.java [javac] (at line 59) [javac] private final int port; [javac] ^^^^ [javac] The field MonetConnection.port is never read locally [javac] ---------- [javac] ---------- [javac] 2. WARNING in /home/sjoerd/src/devel/sql/src/jdbc/nl/cwi/monetdb/jdbc/MonetConnection.java [javac] (at line 1515) [javac] private final String getValue(char[] chrLine, int start, int stop) { [javac] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [javac] The method getValue(char[], int, int) from the type MonetConnection.ResultSetResponse is never used locally [javac] ---------- [javac] ---------- [javac] 3. WARNING in /home/sjoerd/src/devel/sql/src/jdbc/nl/cwi/monetdb/jdbc/MonetConnection.java [javac] (at line 2090) [javac] int lastState = linetype; [javac] ^^^^^^^^^ [javac] The local variable lastState is never read [javac] ---------- [javac] ---------- [javac] 4. WARNING in /home/sjoerd/src/devel/sql/src/jdbc/nl/cwi/monetdb/jdbc/MonetConnection.java [javac] (at line 2175) [javac] int columncount = parseNumber(soh); [javac] ^^^^^^^^^^^ [javac] The local variable columncount is never read [javac] ---------- [javac] ---------- [javac] 5. WARNING in /home/sjoerd/src/devel/sql/src/jdbc/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java [javac] (at line 1402) [javac] private static String dq(String in) { [javac] ^^^^^^^^^^^^^ [javac] The method dq(String) from the type MonetDatabaseMetaData is never used locally [javac] ---------- [javac] ---------- [javac] 6. WARNING in /home/sjoerd/src/devel/sql/src/jdbc/nl/cwi/monetdb/jdbc/MonetSavepoint.java [javac] (at line 139) [javac] private static synchronized int getHighestId() { [javac] ^^^^^^^^^^^^^^ [javac] The method getHighestId() from the type MonetSavepoint is never used locally [javac] ---------- [javac] ---------- [javac] 7. WARNING in /home/sjoerd/src/devel/sql/src/jdbc/nl/cwi/monetdb/jdbc/MonetSocketBlockMode.java [javac] (at line 24) [javac] import java.util.*; [javac] ^^^^^^^^^ [javac] The import java.util is never used [javac] ---------- [javac] ---------- [javac] 8. WARNING in /home/sjoerd/src/devel/sql/src/jdbc/nl/cwi/monetdb/jdbc/util/MonetRedirectException.java [javac] (at line 23) [javac] public class MonetRedirectException extends Exception { [javac] ^^^^^^^^^^^^^^^^^^^^^^ [javac] The serializable class MonetRedirectException does not declare a static final serialVersionUID field of type long [javac] ---------- [javac] 8 problems (8 warnings) jar_jdbc: [jar] Building jar: /home/sjoerd/src/devel/sql/Linux/src/jdbc/monetdb-1.4-jdbc.jar compile_client: [echo] Compiling Clients [javac] Compiling 7 source files to /home/sjoerd/src/devel/sql/Linux/src/jdbc [javac] ---------- [javac] 1. WARNING in /home/sjoerd/src/devel/sql/src/jdbc/nl/cwi/monetdb/client/util/Exporter.java [javac] (at line 23) [javac] import java.util.*; [javac] ^^^^^^^^^ [javac] The import java.util is never used [javac] ---------- [javac] ---------- [javac] 2. WARNING in /home/sjoerd/src/devel/sql/src/jdbc/nl/cwi/monetdb/client/util/OptionsException.java [javac] (at line 21) [javac] public class OptionsException extends Exception { [javac] ^^^^^^^^^^^^^^^^ [javac] The serializable class OptionsException does not declare a static final serialVersionUID field of type long [javac] ---------- [javac] ---------- [javac] 3. WARNING in /home/sjoerd/src/devel/sql/src/jdbc/nl/cwi/monetdb/client/util/PasswordField.java [javac] (at line 43) [javac] int i; [javac] ^ [javac] The local variable i is never read [javac] ---------- [javac] ---------- [javac] 4. WARNING in /home/sjoerd/src/devel/sql/src/jdbc/nl/cwi/monetdb/jdbc/MonetConnection.java [javac] (at line 59) [javac] private final int port; [javac] ^^^^ [javac] The field MonetConnection.port is never read locally [javac] ---------- [javac] ---------- [javac] 5. WARNING in /home/sjoerd/src/devel/sql/src/jdbc/nl/cwi/monetdb/jdbc/MonetConnection.java [javac] (at line 1515) [javac] private final String getValue(char[] chrLine, int start, int stop) { [javac] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [javac] The method getValue(char[], int, int) from the type MonetConnection.ResultSetResponse is never used locally [javac] ---------- [javac] ---------- [javac] 6. WARNING in /home/sjoerd/src/devel/sql/src/jdbc/nl/cwi/monetdb/jdbc/MonetConnection.java [javac] (at line 2090) [javac] int lastState = linetype; [javac] ^^^^^^^^^ [javac] The local variable lastState is never read [javac] ---------- [javac] ---------- [javac] 7. WARNING in /home/sjoerd/src/devel/sql/src/jdbc/nl/cwi/monetdb/jdbc/MonetConnection.java [javac] (at line 2175) [javac] int columncount = parseNumber(soh); [javac] ^^^^^^^^^^^ [javac] The local variable columncount is never read [javac] ---------- [javac] ---------- [javac] 8. WARNING in /home/sjoerd/src/devel/sql/src/jdbc/nl/cwi/monetdb/jdbc/MonetSocketBlockMode.java [javac] (at line 24) [javac] import java.util.*; [javac] ^^^^^^^^^ [javac] The import java.util is never used [javac] ---------- [javac] ---------- [javac] 9. WARNING in /home/sjoerd/src/devel/sql/src/jdbc/nl/cwi/monetdb/jdbc/util/MonetRedirectException.java [javac] (at line 23) [javac] public class MonetRedirectException extends Exception { [javac] ^^^^^^^^^^^^^^^^^^^^^^ [javac] The serializable class MonetRedirectException does not declare a static final serialVersionUID field of type long [javac] ---------- [javac] ---------- [javac] 10. WARNING in /home/sjoerd/src/devel/sql/src/jdbc/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java [javac] (at line 1402) [javac] private static String dq(String in) { [javac] ^^^^^^^^^^^^^ [javac] The method dq(String) from the type MonetDatabaseMetaData is never used locally [javac] ---------- [javac] ---------- [javac] 11. WARNING in /home/sjoerd/src/devel/sql/src/jdbc/nl/cwi/monetdb/jdbc/MonetSavepoint.java [javac] (at line 139) [javac] private static synchronized int getHighestId() { [javac] ^^^^^^^^^^^^^^ [javac] The method getHighestId() from the type MonetSavepoint is never used locally [javac] ---------- [javac] 11 problems (11 warnings) jar_jdbcclient: [echo] Building JDBC + JdbcClient convenience jar [unjar] Expanding: /home/sjoerd/src/devel/sql/Linux/src/jdbc/monetdb-1.4-jdbc.jar into /home/sjoerd/src/devel/sql/Linux/src/jdbc [jar] Building jar: /home/sjoerd/src/devel/sql/Linux/src/jdbc/jdbcclient-1.4.jar BUILD SUCCESSFUL Total time: 16 seconds

2 1

[Monetdb-developers] a little unicode fix in MapiClient.py
by Max 23 May '06

23 May '06

Steps to reproduce problem: 1. MonetDB-4.10.2, Python 2.3.4, Gentoo Linux 2005.0, LANG=ru_RU.KOI8-R 2. Start monetdb mil server 3. Start MapiClient.py 4. Type following command: vars(); 5. Script fails with the following output: #MapiClient (python) connected to localhost:50000 as max > vars(); Traceback (most recent call last): File "/usr/bin/MapiClient.py", line 77, in ? main(sys.argv) File "/usr/bin/MapiClient.py", line 60, in main res = s.cmd(line) File "/usr/share/MonetDB/python/Mapi.py", line 116, in cmd return self.result() File "/usr/share/MonetDB/python/Mapi.py", line 67, in result while buffer[-len(self.prompt1):] != self.prompt1 and \ UnicodeDecodeError: 'ascii' codec can't decode byte 0x81 in position 0: ordinal not in range(128) Possible patch: --- MonetDB-4.10.2/src/mapi/clients/python/MapiClient.py.in 2006-01-20 23:36:49.000000000 +0700 +++ MonetDB-4.10.2/src/mapi/clients/python/MapiClient.py.in.fixed 2006-05-14 15:15:19.000000000 +0800 @@ -57,7 +57,7 @@ sys.stdout.write(s.prompt) line = fi.readline() while line and line != "quit;\n": - res = s.cmd(line) + res = s.cmd(line).encode('utf-8') print res sys.stdout.write(s.prompt.encode('utf-8')) line = fi.readline()

3 2

[Monetdb-developers] Mserver crash during data import
by Peter Roozemaal 20 May '06

20 May '06

During database import Mserver crashes on my Gentoo (64 bit) Linux Athlon64 machine. After the crash the Monet database is so corrupted that recovery fails. I have appended gdb output of the server session; additional information, input data and scripts are available upon request. Greetings, Peter. ===== gdb `which Mserver` GNU gdb 6.4 Copyright 2005 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type "show copying" to see the conditions. There is absolutely no warranty for GDB. Type "show warranty" for details. This GDB was configured as "x86_64-pc-linux-gnu"...(no debugging symbols found) Using host libthread_db library "/lib/libthread_db.so.1". (gdb) run monetdb-startup.mil Starting program: /usr/bin/Mserver monetdb-startup.mil (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) [Thread debugging using libthread_db enabled] [New Thread 16384 (LWP 21057)] !WARNING: GDKlockHome: created directory /var/lib/MonetDB/dbfarm/default/ !WARNING: GDKlockHome: ignoring empty or invalid .gdk_lock. !WARNING: BBPdir: initializing BBP. [New Thread 32769 (LWP 21060)] [New Thread 16386 (LWP 21061)] # Monet Database Server V4.10.2 # Copyright (c) 1993-2006, CWI. All rights reserved. # Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs; dynamically linked. # Visit http://monetdb.cwi.nl/ for further information. [New Thread 32771 (LWP 21063)] [New Thread 49156 (LWP 21064)] [New Thread 65541 (LWP 21065)] [New Thread 81926 (LWP 21066)] [New Thread 98311 (LWP 21067)] [New Thread 114696 (LWP 21068)] [New Thread 131081 (LWP 21069)] [New Thread 147466 (LWP 21070)] [New Thread 163851 (LWP 21071)] [New Thread 180236 (LWP 21072)] [New Thread 196621 (LWP 21073)] [New Thread 213006 (LWP 21074)] [New Thread 229391 (LWP 21075)] [New Thread 245776 (LWP 21076)] [New Thread 262161 (LWP 21077)] [New Thread 278546 (LWP 21078)] [New Thread 294931 (LWP 21079)] [New Thread 311316 (LWP 21080)] [New Thread 327701 (LWP 21081)] [New Thread 344086 (LWP 21082)] [New Thread 360471 (LWP 21083)] [New Thread 376856 (LWP 21084)] [New Thread 393241 (LWP 21085)] [New Thread 409626 (LWP 21086)] [New Thread 426011 (LWP 21087)] [New Thread 442396 (LWP 21088)] [New Thread 458781 (LWP 21089)] [New Thread 475166 (LWP 21090)] [New Thread 491551 (LWP 21091)] [New Thread 507936 (LWP 21092)] [New Thread 524321 (LWP 21093)] [New Thread 540706 (LWP 21094)] [New Thread 557091 (LWP 21095)] [New Thread 573476 (LWP 21096)] [New Thread 589861 (LWP 21101)] [Thread 147466 (LWP 21070) exited] [New Thread 606218 (LWP 21117)] Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 426011 (LWP 21087)] 0x00002aaaab9aa2c8 in GDKreallocmax () from /usr/lib/libbat.so.0 (gdb) where #0 0x00002aaaab9aa2c8 in GDKreallocmax () from /usr/lib/libbat.so.0 #1 0x00002aaaab9530f3 in HEAPextend () from /usr/lib/libbat.so.0 #2 0x00002aaaab9e6989 in BATextend () from /usr/lib/libbat.so.0 #3 0x00002aaaab91c1b2 in BATappend () from /usr/lib/libbat.so.0 #4 0x00002aaaaafcfdbf in BATappend_wrap () from /usr/lib64/MonetDB/lib_bat.so.0 #5 0x00002aaaaafccf83 in BATappend_wrap_unpack1034987346 () from /usr/lib64/MonetDB/lib_bat.so.0 #6 0x00002aaaaabdc39b in interpret () from /usr/lib/libmonet.so.0 #7 0x00002aaaaabe47ef in interpret_seqblock () from /usr/lib/libmonet.so.0 #8 0x00002aaaaabdbcb1 in interpret () from /usr/lib/libmonet.so.0 #9 0x00002aaaaabdd071 in interpret () from /usr/lib/libmonet.so.0 #10 0x00002aaaaabe47ef in interpret_seqblock () from /usr/lib/libmonet.so.0 #11 0x00002aaaaabdbcb1 in interpret () from /usr/lib/libmonet.so.0 #12 0x00002aaaaabe47ef in interpret_seqblock () from /usr/lib/libmonet.so.0 #13 0x00002aaaaabdbcb1 in interpret () from /usr/lib/libmonet.so.0 #14 0x00002aaaaabdbb69 in interpret () from /usr/lib/libmonet.so.0 #15 0x00002aaaaabe47ef in interpret_seqblock () from /usr/lib/libmonet.so.0 #16 0x00002aaaaabdbcb1 in interpret () from /usr/lib/libmonet.so.0 #17 0x00002aaaaabe7a99 in handleRequest () from /usr/lib/libmonet.so.0 #18 0x00002aaaaabe80c9 in doRequest () from /usr/lib/libmonet.so.0 #19 0x00002aaaaac2593a in monetInterpreter () from /usr/lib/libmonet.so.0 #20 0x00002aaaac013c09 in pthread_start_thread () from /lib/libpthread.so.0 ---Type <return> to continue, or q <return> to quit--- #21 0x00002aaaac013cb3 in pthread_start_thread_event () from /lib/libpthread.so.0 #22 0x00002aaaac5840a3 in clone () from /lib/libc.so.6 #23 0x0000000000000000 in ?? () (gdb) c Continuing. Program terminated with signal SIGKILL, Killed. The program no longer exists. (gdb) q

1 0

[Monetdb-developers] [noreply@sourceforge.net: [Bug 1490591] SSH host key change (new fingerprint)]
by Fabian Groffen 19 May '06

19 May '06

Hi all, FYI: ----- Forwarded message from "SourceForge.net" <noreply(a)sourceforge.net> ----- From: "SourceForge.net" <noreply(a)sourceforge.net> To: noreply(a)sourceforge.net Subject: [Bug 1490591] SSH host key change (new fingerprint) Date: Fri, 19 May 2006 00:47:32 -0700 url: https://sourceforge.net/tracker/?func=detail&atid=200001&aid=1490591&group_… burley changed: What | Value ---------------+--------------------------------- AssignedTo | David Burley (burley) Status | Closed --- Comment from David Burley (burley) 2006-05-19 03:47 --- Greetings, Per the site status page: ( 2006-05-17 12:04:02 - Project CVS Service ) As of 2006-05-17 at 12:00 Pacific we synchronized the SSH keys on all of the CVS hosts. This will cause SSH key mismatch errors for most projects. Please reconfirm the new SSH key against site doc G04 (https://www.sourceforge.net/docs/G04) and then accept the new key, if it matches per normal procedure. We apologize for the inconvenience, but this should be a one-time event and make future CVS infrastructure changes more seamless. Thank you, David Burley Quality of Service Analyst, SourceForge.net ----- End forwarded message -----

1 0

[Monetdb-developers] semantics of aggregation operations
by S.Idreos＠cwi.nl 18 May '06

18 May '06

Hi all, I would like to open a discussion on the semantics of operations. I just noticed for example that the sum operation will return nil if one or more of the BUNs in the BAT is nil. That is probably not the semantics that someone would expect, i.e., I would like to see the actual result by ignoring the nils. Given the current semantics the code that SQL generates has to first remove nils (with a select operation) and then apply the sum operation on a BAT. That costs more time and also results in one more intermediate result. What about updating the sum implementation to ignore nils? How much would affect that the various projects on top of MonetDB? Regards, Stratos

4 3

[Monetdb-developers] multiplex string-add returns empty BAT
by Peter Roozemaal 18 May '06

18 May '06

I am using monetdb 4.10.2 on an AMD64 Gentoo Linux system (the Gentoo ebuild). I suspect there's a bug in the handling of the multiplex string-add: The following mil code: var xxx := "aap noot mies".split(" "); (xxx [+] xxx).print(); prints an empty BAT: #-----------------# # h t # name # void str # type #-----------------# where I expected: [ nil, "aapaap" ] [ nil, "nootnoot" ] [ nil, "miesmies" ] It looks like every invocation of the string [+] gives an empty result. Greetings, Peter Roozemaal.

3 3

[Monetdb-developers] New vs. Existing Update Syntax
by Jens Teubner 18 May '06

18 May '06

Hi MonetDB/XQuery folks, I'm in the midst of implementing the support for the "official" XQuery Update Facility syntax. So far it looks like the current code is pretty good in line with the W3C draft. The update operations in the draft are very similar to the update functions we currently have. A few questions, however, appeared when implementing the new syntax: -- It seems to me like we do not (yet) have a rename() function that only changes the tag name of a given element, attribute, or processing-instruction node. -- It is not clear to me how our current insert-...() functions handle attributes in the new node list. The W3C draft provides separate upd:insertAttributes ($element, $attlist) and upd:insertBefore ($element, $nodelist) functions (and similar). The translation from the surface syntax to the update operations then takes care of invoking the right functions. Unfortunately, this translation (the split-up of attributes and the rest in particular) is non-trivial in XQuery Core. So we could--in line with the current implementation of element construction--push this treatment of attributes into the back-end. Any comments on this? How does the current code deal with attributes in the arguments of insert-...()? So far for now, Jens -- Jens Teubner Technische Universitaet Muenchen, Department of Informatics D-85748 Garching, Germany Tel: +49 89 289-17259 Fax: +49 89 289-17263 XQuery processing at the speed of light: MonetDB/XQuery http://www.monetdb-xquery.org/ http://www.pathfinder-xquery.org/

2 3

[Monetdb-developers] MonetDB website problem
by Fabian Groffen 18 May '06

18 May '06

http://monetdb.cwi.nl/TechDocs/APIs/Mapi/C/index.html Could someone *PLEASE* fix this? kthx.

1 0

[Monetdb-developers] New serialization routine
by Jan Rittinger 16 May '06

16 May '06

In the current version serialization takes 10 seconds for a 10 MB file (http://www-db.in.tum.de/~rittinge/files/mixed.xml) which contains only slightly more nodes (517448) then the auction xml file of the same size (472681). The difference however is the number of attribute nodes which is much higher in mixed.xml (517447 vs. 38266). While the serialization of doc("auction10MB.xml") takes 2.72 seconds, doc("mixed.xml") requires 10.34 seconds!! Removing the attributes in mixed.xml (by deleting all entries from the attr_own bat) speeds up the serialization to complete in 4.6 seconds. Some more calculations reveal that for the auction file we are able to serialize 187 nodes/sec (nodes = elements+textnodes+attributes) while for mixed.xml the serialization function (with and without attributes) was only able to generate about 100 nodes/sec. In all 3 cases the serialization seems way to slow... (at least for me). As in principle the serialization is only a dump of the tables (even in table order) and other approaches are really faster we should be able to come up with an appropriate fast serialization routine. I see at least three possibilities to increase the performance: * serialize.mx uses about 50 function calls until one node without attributes is serialized * serialize.mx does collect the nodes using random access with a lot of indirections * serialize.mx uses stream_printf which is probably slower than a fixed size print routine like stream_write. In the following two weeks (before the feature freeze) I will try to come up with a new prototypical print routine that should handle the serialization more efficiently. This prototype will be a proof of concept and probably will fall back to current routine whenever some conditions are not fulfilled (e.g. wrong serialization type or multiple namespaces). Let's see wether we can get a faster serialization routine for the average query result! I will probably need help for some gdk internals, changes introduced by the update facility (e.g. indirections), and for understanding parts of the current serialize.mx. I hope for your support :-) More information on the new serialization routine will be available at the pathfinder wiki. Cheers, Jan -- Jan Rittinger Database Systems Technische Universität München (Germany) http://www-db.in.tum.de/~rittinge/

2 1