- developers-list - monetdb.org

Re: [Monetdb-developers] [Monetdb-checkins] buildtools/conf MonetDB.m4, MonetDB_1-20, 1.37.2.18, 1.37.2.19
by Ying Zhang 21 Jan '08

21 Jan '08

helaas, als ik de stable brach compileer, krijg ik steeds de selfde error, misschien is de string "+yes-*-darwin[89]*-powerpc*-* | yes-*- darwin[89]*-i386*-* | yes-*-darwin[89]*-x86_64*-*)" waar het script naar kijkt niet correct, mijn gcc zegt namelijk zo iets: $ gcc i686-apple-darwin9-gcc-4.0.1: no input files ik kan dit zelf wel uitzoeken, denk ik, maar niet nu:) Als ik "--enable-bits" helemaal niet gebruikt, compileert het als een speer:) Ik kan alleen de tijah module net laden in mserver, maar dat is een ander verhaal. Jennie On Jan 18, 2008, at 10:34 , Fabian wrote: > Update of /cvsroot/monetdb/buildtools/conf > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv25825 > > Modified Files: > Tag: MonetDB_1-20 > MonetDB.m4 > Log Message: > Add support for 64-bits with GCC 4 on Solaris and on Darwin 9 and > Darwin on Intel > > Index: MonetDB.m4 > =================================================================== > RCS file: /cvsroot/monetdb/buildtools/conf/MonetDB.m4,v > retrieving revision 1.37.2.18 > retrieving revision 1.37.2.19 > diff -u -d -r1.37.2.18 -r1.37.2.19 > --- MonetDB.m4 22 Nov 2007 15:44:17 -0000 1.37.2.18 > +++ MonetDB.m4 18 Jan 2008 09:34:48 -0000 1.37.2.19 > @@ -490,8 +490,8 @@ > ;; > yes-*-solaris*-*-*) > case `$bits-$CC -v 2>&1` in > - 32-*|*-*'gcc version 3.'*) ;; > - *) AC_MSG_ERROR([need GCC version 3.X for 64 bits]);; > + 32-*|*-*'gcc version '[34]'.'*) ;; > + *) AC_MSG_ERROR([need GCC version >=3.X for 64 bits]);; > esac > CC="$CC -m$bits" > ;; > @@ -520,7 +520,8 @@ > -*pgcc*-linux*-x86_64*-*) > CC="$CC -tp=k8-$bits" > ;; > -yes-*-darwin8*-powerpc*-*) > +yes-*-darwin[89]*-powerpc*-* | yes-*-darwin[89]*-i386*-* | yes-*- > darwin[89]*-x86_64*-*) > + # Darwin/OSX cases > CC="$CC -m$bits" > ;; > *) > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins

2 8

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/modules/mal/Tests remote04.mal, , NONE, 1.1 remote05.mal, , NONE, 1.1
by Romulo Goncalves 20 Jan '08

20 Jan '08

Martin Kersten wrote: > Update of /cvsroot/monetdb/MonetDB5/src/modules/mal/Tests > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv31308 > > Added Files: > remote04.mal remote05.mal > Log Message: > Examples of poor-mans bat transport. > > > --- NEW FILE: remote04.mal --- > #this example tests recieving tuple values as part of the > #MAL interface. > > b:bat[:oid,:int]:=mserver.receive(); > [ 0@0, 1] > [ 0@1, 2] > > c:bat[:oid,:str]:=mserver.receive(); > [ 0@0, "hello"] > [ 0@1, "world"] > > io.print(b); > io.print(c); > > --- NEW FILE: remote05.mal --- > #this example tests recieving tuple values as part of the > #MAL interface. > # now in a remote setting > > include remote; > # for testweb, we need to ask the server itself how it is available, use > # sabaoth for that > include sabaoth; > > h := sabaoth.getLocalConnectionHost(); > p := sabaoth.getLocalConnectionPort(); > > # create a connecton to ourself > remote.create("test", h, p, nil:str, "monetdb", "monetdb"); > > b:= bat.new(:oid,:str); > bat.insert( 0@0, "hello"); > bat.insert( 0@1, "world"); Shouldn't here be: bat.insert( b, 0@0, 1); bat.insert( b, 0@1, 2); Because your remote site is expecting to receive b:bat[:oid,:int]:=mserver.receive(); Romulo > > # store the values > remote.send("test",b); > c:= remote.query("test","io.print(b);") > io.print(c); > # shutdown > remote.destroy("test"); > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins

1 0

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/runtime/xrpc/export xrpc.html, xquery-decomposition, 1.3, 1.3.2.1
by Sjoerd Mullender 17 Jan '08

17 Jan '08

Should this also be fixed on the main branch? Ying Zhang wrote: > Update of /cvsroot/monetdb/pathfinder/runtime/xrpc/export > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv26528 > > Modified Files: > Tag: xquery-decomposition > xrpc.html > Log Message: > fixed wrong link > > > > Index: xrpc.html > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/runtime/xrpc/export/xrpc.html,v > retrieving revision 1.3 > retrieving revision 1.3.2.1 > diff -u -d -r1.3 -r1.3.2.1 > --- xrpc.html 18 Dec 2007 21:02:22 -0000 1.3 > +++ xrpc.html 17 Jan 2008 12:11:33 -0000 1.3.2.1 > @@ -40,7 +40,7 @@ > For more information on XRPC, check the following sources: > <ul> > <li> the XRPC <a href="http://monetdb.cwi.nl/XQuery/QuickTour/XRPC">tutorial</a> > - <li> the XRPC <a href="http://monetdb.cwi.nl/XQuery/Documentation/XRPC/">reference manual</a> > + <li> the XRPC <a href="http://monetdb.cwi.nl/XQuery/Documentation/XRPC-Extension.html">reference manual</a> > <li> the XRPC <a href="http://www.cwi.nl/htbin/ins1/publications?request=intabstract&key=ZhBo:VLDB…">VLDB Paper</a> > </ul> > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Monetdb-pf-checkins mailing list > Monetdb-pf-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins -- Sjoerd Mullender

2 2

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/src/sqlhelpers/xmlshred encoding.c, , 1.15, 1.16 hash.c, , 1.7, 1.8
by Sjoerd Mullender 10 Jan '08

10 Jan '08

Why did you move the include of pf_config.h? Generally, the *config.h files need to be *first*. Torsten Grust wrote: > Update of /cvsroot/monetdb/pathfinder/src/sqlhelpers/xmlshred > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv10014 > > Modified Files: > encoding.c hash.c > Log Message: > -- pfshred now requires SAX2 (namespace URI processing) > > -- Local name and URI hash tables operate with xmlChar* values > > > > Index: encoding.c > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/src/sqlhelpers/xmlshred/encoding.c,v > retrieving revision 1.15 > retrieving revision 1.16 > diff -u -d -r1.15 -r1.16 > --- encoding.c 9 Jan 2008 09:16:05 -0000 1.15 > +++ encoding.c 10 Jan 2008 09:02:16 -0000 1.16 > @@ -25,13 +25,14 @@ > * $Id$ > */ > > -#include "pf_config.h" > #include <stdio.h> > #include <string.h> > > /* libxml SAX2 parser internals */ > #include "libxml/parserInternals.h" > > +#include "pf_config.h" > + > #include "encoding.h" > #include "guides.h" > #include "oops.h" > @@ -40,6 +41,9 @@ > > #include <assert.h> > > +#ifndef HAVE_SAX2 > + #error "libxml2 SAX2 interface required to compile the XML shredder `pfshred'" > +#endif > > FILE *out; > FILE *out_attr; > @@ -256,15 +260,14 @@ > > if (!localname) > return -1; > + > + localname_id = hashtable_find (localname_hash, localname); > > - localname_id = hashtable_find (localname_hash, (char *) localname); > - > - /* key not found */ > if (NOKEY (localname_id)) { > - /* create a new name id */ > + /* key not found, create a new name id */ > localname_id = global_localname_id++; > - /* add the pair into the hashtable */ > - hashtable_insert (localname_hash, (char *) localname, localname_id); > + /* add the (localname, localname_id) pair into the hash table */ > + hashtable_insert (localname_hash, localname, localname_id); > /* print the name binding if necessary */ > if (shredstate.names_separate) > fprintf (out_names, "%i, \"%s\"\n", localname_id, (char*) localname); > @@ -282,14 +285,13 @@ > if (!URI) > return -1; > > - uri_id = hashtable_find (uris_hash, (char *) URI); > + uri_id = hashtable_find (uris_hash, URI); > > - /* key not found */ > if (NOKEY (uri_id)) { > - /* create a new URI id */ > + /* key not found, create a new URI id */ > uri_id = global_uri_id++; > - /* add the pair into the hashtable */ > - hashtable_insert (uris_hash, (char *) URI, uri_id); > + /* add the (URI, uri_id) pair to the hash table */ > + hashtable_insert (uris_hash, URI, uri_id); > /* print the URI binding if necessary */ > if (shredstate.names_separate) > fprintf (out_uris, "%i, \"%s\"\n", uri_id, (char*) URI); > @@ -313,7 +315,8 @@ > > /* check if tagname is larger than TAG_SIZE characters */ > if (localname && xmlStrlen (localname) > TAG_SIZE) > - BAILOUT ("attribute local name `%s' exceeds %u characters", localname, TAG_SIZE); > + BAILOUT ("attribute local name `%s' exceeds %u characters", > + localname, TAG_SIZE); > > if (URI && xmlStrlen (URI) > TAG_SIZE) > BAILOUT ("namespace URI `%s' exceeds length of %u characters", > @@ -686,7 +689,7 @@ > report (void) > { > if (text_stripped > 0) { > - fprintf (err, "%u values were stripped to %u " > + fprintf (err, "%u text node/attribute values were stripped to %u " > "character(s).\n", text_stripped, text_size); > } > } > > Index: hash.c > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/src/sqlhelpers/xmlshred/hash.c,v > retrieving revision 1.7 > retrieving revision 1.8 > diff -u -d -r1.7 -r1.8 > --- hash.c 8 Jan 2008 10:00:07 -0000 1.7 > +++ hash.c 10 Jan 2008 09:02:16 -0000 1.8 > @@ -25,39 +25,39 @@ > * $Id$ > */ > > -#include "pf_config.h" > -#include "hash.h" > -#include "shred_helper.h" > #include <string.h> > #include <unistd.h> > #include <assert.h> > > +#include "pf_config.h" > +#include "hash.h" > +#include "shred_helper.h" > + > /* We use a seperate chaining strategy to > - * mantain our hash_table, > - * So each bucket is a chained list itself, > - * to handle possible collisions. > + * mantain our hash table, so each bucket is a chained list itself > + * to handle collisions. > */ > struct bucket_t { > - char *key; /**< key as string */ > - int id; /**< name_id */ > - bucket_t* next; /**< next bucket in our list */ > + xmlChar *key; /**< key (elem/attr name or namespace URI) */ > + int id; /**< name_id */ > + bucket_t *next; /**< next bucket in overflow chain */ > }; > > -/* size of the hashtable */ > +/* hashtable size */ > #define PRIME 113 > > /** > - * Lookup an id in a given bucket using it associated key. > + * Lookup an id in a given bucket using its associated key. > */ > static int > -find_id (bucket_t *bucket, char *key) > +find_id (bucket_t *bucket, const xmlChar *key) > { > bucket_t *cur_bucket = bucket; > > assert (key); > > while (cur_bucket) > - if (strcmp (cur_bucket->key, key) == 0) > + if (xmlStrcmp (cur_bucket->key, key) == 0) > return cur_bucket->id; > else > cur_bucket = cur_bucket->next; > @@ -69,16 +69,16 @@ > * Attach an (id, key) pair to a given bucket list. > */ > static bucket_t * > -bucket_insert (bucket_t *bucket, char *key, int id) > +bucket_insert (bucket_t *bucket, const xmlChar *key, int id) > { > int ident = find_id (bucket, key); > > - /* no key found */ > if (NOKEY (ident)) { > + /* no key found */ > bucket_t *newbucket = (bucket_t*) malloc (sizeof (bucket_t)); > > newbucket->id = id; > - newbucket->key = strndup (key, strlen(key)); > + newbucket->key = xmlStrdup (key); > > /* add new bucket to the front of list */ > newbucket->next = bucket; > @@ -95,13 +95,12 @@ > * Create the hash value for a given key. > */ > static int > -find_hash_bucket (char *key) > +find_hash_bucket (const xmlChar *key) > { > assert (key); > > - size_t len = strlen (key); > - /* keys have at least length 1 */ > - /* assert (len > 0); */ > + size_t len = xmlStrlen (key); > + > /* build a hash out of the first and the last character > and the length of the key */ > return (key[0] * key[MAX(0,len-1)] * len) % PRIME; > @@ -113,7 +112,9 @@ > hashtable_t > new_hashtable (void) > { > - hashtable_t ht = malloc (PRIME * sizeof (bucket_t)); > + hashtable_t ht; > + > + ht = (hashtable_t) malloc (PRIME * sizeof (bucket_t)); > > /* initialize the hash table */ > for (unsigned int i = 0; i < PRIME; i++) > @@ -126,24 +127,25 @@ > * Insert key and id into hashtable. > */ > void > -hashtable_insert (hashtable_t hash_table, char *key, int id) > +hashtable_insert (hashtable_t hash_table, const xmlChar *key, int id) > { > int hashkey; > > - assert (hash_table && key); > - > + assert (hash_table); > + assert (key); > + > hashkey = find_hash_bucket (key); > hash_table[hashkey] = bucket_insert (hash_table[hashkey], key, id); > - return; > } > > /** > * Find element in hashtable. > */ > int > -hashtable_find (hashtable_t hash_table, char *key) > +hashtable_find (hashtable_t hash_table, const xmlChar *key) > { > - assert (key); > + assert (key); > + > return find_id (hash_table[find_hash_bucket (key)], key); > } > > @@ -156,7 +158,6 @@ > bucket_t *bucket, *free_bucket; > > assert (hash_table); > - if (!hash_table) return; > > for (int i = 0; i < PRIME; i++) { > bucket = hash_table[i]; > @@ -165,9 +166,11 @@ > free_bucket = bucket; > bucket = bucket->next; > /* free the copied hash key */ > - if (free_bucket->key) free (free_bucket->key); > + if (free_bucket->key) > + xmlFree (free_bucket->key); > free (free_bucket); > } > } > + > free(hash_table); > } > > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace > _______________________________________________ > Monetdb-pf-checkins mailing list > Monetdb-pf-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins -- Sjoerd Mullender

1 0

[Monetdb-developers] Run Mtest on windows...
by Romulo Goncalves 08 Jan '08

08 Jan '08

I am running Mtest on windows 64 to fix a test that I submitted yesterday and I am getting the following error when I start my Mtest: E:\MonetDB\Current\sql\NT>RunMtest.bat -rq Mtest.py: ERROR: ' mserver5 "--config=E:\MonetDB\Current\MonetDB5\NT\etc\monetdb5.conf" --debug=10 --set "monet_mod_pat h=E:\MonetDB\Current\\sql\NT\src\backends\monet5\.libs;E:\MonetDB\Current\\sql\NT\src\backends\monet5;E:\MonetDB\Current\ MonetDB5\NT\lib\MonetDB5" --set "gdk_dbfarm=E:\MonetDB\Current\\sql\NT\dbfarm" --set "sql_logdir=E:\MonetDB\Current\\sql\ NT\sql_logs" --set "xquery_logdir=E:\MonetDB\Current\\sql\NT\xquery_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=38998 --set xrpc_port=43861 --set monet_prompt= --trace --dbname=mTests` failed: !WARNING: GDKlockHome: ignoring empty or invalid .gdk_lock. !WARNING: BBPdir: initializing BBP. # MonetDB server v5.3.0, based on kernel v1.21.0 # Serving database 'mTests' # Compiled for i686-pc-win32/64bit with 32bit OIDs dynamically linked # Copyright (c) 1993-2007 CWI, all rights reserved # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see E:\MonetDB\Current\MonetDB5\NT\etc\monetdb5.conf) !FATAL: MALException:addUser:user 'monetdb' already exists ! Exit 1 Exception in thread Thread-12 (most likely raised during interpreter shutdown): Traceback (most recent call last): File "C:\Python25\lib\threading.py", line 460, in __bootstrap File "C:\Python25\lib\threading.py", line 623, in run File "C:\Python25\lib\threading.py", line 364, in wait File "C:\Python25\lib\threading.py", line 238, in wait <type 'exceptions.ValueError'>: list.remove(x): x not in list E:\MonetDB\Current\sql\NT> I already cleaned my dbfarm was you can see... Any idea? Regards, Romulo

2 2

[Monetdb-developers] find temp tables....
by Romulo Goncalves 05 Jan '08

05 Jan '08

In sql we have some problems in locate temp tables. If I create the following table: create global temporary t1(id int); If I do: select * from t1; or select * from tmp.t1; I can see the table. However, When I do alter table, copy into, create trigger, create index statements I cannot detect the table even if I use tmp.t1 Should I open a bug? Or there is a special reason for this? Regards, Romulo

2 1

[Monetdb-developers] commit options for create table statement....
by Romulo Goncalves 05 Jan '08

05 Jan '08

Reading the MonetDB code seems that commit option ON COMMIT DROP ON COMMIT PRESERVE ROWS ON COMMIT DELETE ROWS should not be used for normal tables (the ones which are not temporary). If that is the rule, the commit option should be allowed in the create table statement. If it is not the rule, the commit option is not being used at all for the normal tables. Look to the following example (auto-commit mode is on): >CREATE TABLE test1(id int) ON COMMIT DELETE ROWS; &3 >insert into test1 values(1); &2 1 -1 >select * from test1; &1 3 1 1 1 % sys.test1 # table_name % id # name % int # type % 1 # length [ 1 ] > So what is the rule for MonetDB? Regards, Romulo

2 1

[Monetdb-developers] Geom II
by Stefan de Konink 04 Jan '08

04 Jan '08

And I probably should take the other part of the documentation out there more seriously. I guess this is 'suppose' to happen if you do *not* include geom in your (jfu) database. gdb --args /opt/monetdb/bin/mserver5 --dbinit="include sql;" --dbname=osm --dbfarm=/mnt/media/MonetDB5/dbfarm GNU gdb 6.7.1 Copyright (C) 2007 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html> This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "x86_64-pc-linux-gnu"... Using host libthread_db library "/lib/libthread_db.so.1". (gdb) run Starting program: /opt/monetdb/bin/mserver5 --dbinit=include\ sql\; --dbname=osm --dbfarm=/mnt/media/MonetDB5/dbfarm warning: no loadable sections found in added symbol-file system-supplied DSO at 0x7fff30ffd000 [Thread debugging using libthread_db enabled] [New Thread 0x2b887c85d860 (LWP 2919)] [New Thread 0x40800950 (LWP 2922)] # MonetDB server v5.3.0, based on kernel v1.21.0 # Serving database 'osm' # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked # Copyright (c) 1993-2007 CWI, all rights reserved # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /opt/monetdb/etc/monetdb5.conf) [New Thread 0x41001950 (LWP 2923)] # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ # MonetDB/SQL module v2.21.0 loaded >!ERROR: BATnew:tt error Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 0x41001950 (LWP 2923)] 0x00002aaab26c8d3c in temp_create (b=0x0) at bat_utils.mx:130 130 temp_dup(b->batCacheid); (gdb) bt #0 0x00002aaab26c8d3c in temp_create (b=0x0) at bat_utils.mx:130 #1 0x00002aaab26c4d76 in e_bat (type=-31) at bat_storage.mx:84 #2 0x00002aaab26c62ee in load_bat (sname=0xba3028 "sys", tname=0x10607d8 "nodes_geom", bname=0x107d118 "geometry", type=-31, sz=1024, cnt=0x1060700) at bat_storage.mx:454 #3 0x00002aaab26c6660 in create_col (tr=0xba2ee8, c=0x107d088) at bat_storage.mx:518 #4 0x00002aaab26b639b in load_column (tr=0xba2ee8, t=0x10606c8, rid=193) at store.mx:516 #5 0x00002aaab26b691c in load_table (tr=0xba2ee8, s=0xba2f58, rid=193) at store.mx:583 #6 0x00002aaab26b7dd3 in load_schema (tr=0xba2ee8, id=1128, rid=38) at store.mx:850 #7 0x00002aaab26b819e in load_trans (tr=0xba2ee8, id=1128) at store.mx:902 #8 0x00002aaab26ba16d in store_init (debug=0, store=store_bat, logdir=0x63cfc0 "/opt/monetdb/var/MonetDB5/sql_logs", dbname=0x63ce90 "osm", stk=0) at store.mx:1328 #9 0x00002aaab269707d in mvc_init (debug=0, store=store_bat, stk=0) at sql_mvc.mx:247 #10 0x00002aaab26367bb in SQLinit (c=0x6046c8) at sql_scenario.mx:227 #11 0x00002b8879e003af in initScenario (c=0x6046c8, s=0x2b887a01b070) at mal_scenario.mx:263 #12 0x00002b8879e0159c in setScenario (c=0x6046c8, nme=0xad8123 "sql") at mal_scenario.mx:471 #13 0x00002b8879dc9951 in MSscheduleClient (command=0xad80e8 "LIT", challenge=0x41000fc0 "Roh8IvYDJa", fin=0xacdf40, fout=0xacdea0) at mal_session.mx:342 #14 0x00002aaab0f8527b in doChallenge (cmd=0x0, in=0xacdd60, out=0xacdcc0) at mserver.mx:481 #15 0x00002aaab0f85533 in SERVERlistenThread (Sock=0x9f0938) at mserver.mx:563 #16 0x00002b887b8d5067 in start_thread () from /lib/libpthread.so.0 #17 0x00002b887c5d9bed in clone () from /lib/libc.so.6 People may wonder why I tried anyway... The simple query "select * from nodes LIMIT 1;" also took far more time (22s) to complete than expected. Stefan

1 0

[Monetdb-developers] Geom and its examples.
by Stefan de Konink 04 Jan '08

04 Jan '08

Hi, So I decided to try out Geom, and after copying in a small set of data. I decided to test if it was any faster than my own made up SQL fantasy, which greatly seems to depend on the state MonetDB is in, I had some nice results before my Geom test, but I guess I just have overloaded the database again. select * from nodes, node_tags where latitude >= 52.375 AND latitude <= 52.379 AND longitude >= 4.89 AND longitude <= 4.90 AND nodes.id = node_tags.node AND name='amenity' and value='atm'; Took before 8 seconds... now it is ending nowhere. (In the over 10 minutes range.) Next to this now is 27.8GB in virtual memory (my entire dbfarm directory, while the data that is required for this query BY FAR not that amount of data.) So I suspect a problem in the Geom code :) read on :) I'm using the very latest CVS HEAD. sql>SELECT id, geometry FROM nodes_geom LIMIT 1; +----+---------------------------------------------------------------------+ | id |geometry | +====+=====================================================================+ | 2 |POINT (50.1360073999999969 8.3023717000000001) | +----+---------------------------------------------------------------------+ Looks shining. Lets do a basic operation: sql>SELECT id, X(geometry) FROM nodes_geom LIMIT 1; !types point(0,0) (wkb) and geometry(0,0) (wkb) are not equal Hum. Was it my poor choose of column name? So I decided to try out the example: http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/SQL_002fGIS.html sql>SELECT forests.name,buildings.name more>FROM forests,buildings more>WHERE forests.name = 'Green Forest' and more> Overlaps(forests.shape, buildings.outline) = true; !types multipolygon(0,0) (wkb) and geometry(0,0) (wkb) are not equal So what went so terribly wrong? Or better: what can be done to fix it. Yours Sincerely, Stefan de Konink

1 0

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB/NT monetdb_winconfig.h, , 1.6, 1.7 winrules.msc, , 1.16, 1.17
by Romulo Goncalves 03 Jan '08

03 Jan '08

Stefan Manegold wrote: > Update of /cvsroot/monetdb/MonetDB/NT > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv15904/NT > > Modified Files: > monetdb_winconfig.h winrules.msc > Log Message: > > made OID size (command-line-) configurable (also) on 64-bit Windows: > As opposed to Unix, where the default OID size is identical to the > native machine word size (in particular 64-bit OIDs on 64-bit systems), > the default OID size on 64-bit Windows has been and remains 32-bit > (see NT/monetdb_winconfig.h for details). > This default can be overruled by compiling with `nmake MONET_OID64=1`. > (In case the default in NT/monetdb_winconfig.h is changed to 64-bit > OIDs on 64-bit Windows, 32-bit OIDs on 64-bit Windows can be enabled > by compiling with `nmake MONET_OID32=1`.) Following these rules I decided to compile MonetDB on windows like this: E:\MonetDB\Current\MonetDB\NT>nmake MONET_OID64=1 Microsoft (R) Program Maintenance Utility Version 8.00.50727.42 Copyright (C) Microsoft Corporation. All rights reserved. "E:\Microsoft Visual Studio 8\VC\BIN\amd64\nmake.exe" /nologo /f ".\..\Makefile.msc" "prefix=E:\MonetDB\Current\M onetDB\NT" "bits=32" all if not exist "src" mkdir "src" copy ".\..\src\Makefile.msc" "src\Makefile" 1 file(s) copied. cd "src" && "E:\Microsoft Visual Studio 8\VC\BIN\amd64\nmake.exe" /nologo "prefix=E:\MonetDB\Current\MonetDB\NT" "bits=32" all if not exist "common" mkdir "common" copy ".\..\..\src\common\Makefile.msc" "common\Makefile" 1 file(s) copied. cd "common" && "E:\Microsoft Visual Studio 8\VC\BIN\amd64\nmake.exe" /nologo "prefix=E:\MonetDB\Current\MonetDB\N T" "bits=32" all cl -GF -W3 -wd4273 -wd4102 -MD -nologo -Ox -I. -I.\..\.. "-IC:\Pthreads\include" -I.\..\..\..\src\common -DHAVE_L IBZ "-IC:\zlib-1.2.3.win32\include" -DHAVE_ICONV "-IC:\iconv-1.9.2.win32\include" -DLIBSTREAM -DCOMPILE_DL_STREAM - Fo"stream.obj" -c "stream.c" stream.c As you can see the compilation is done for 32 bits and I would like to do it for 64 bits. Could someone give a help here please. Thanks in advance, Romulo

2 1