- users-list - monetdb.org

[MonetDB-users] 64bit MonetDB, JDBC Insert via RJDBC, >300 million rows
by Yue Sheng 17 Mar '09

17 Mar '09

I'm been trying to insert from file for over 322 files, totally 12GB with over 600 million rows. The RJDBC connection hangs after 350 million row. I noticed the VSIZE in Activity Monitor is 30.85GB, closer to 32GB system memory. Is this the reason that I cannot connect to the database? What should I do? Error message I get from MonetDB server: # MonetDB server v5.8.4, based on kernel v1.26.4 # Serving database 'bigdata', using 8 threads # Compiled for i386-apple-darwin9.6.0/64bit with 64bit OIDs dynamically linked # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008- MonetDB B.V., all rights reserved # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /Users/someuser/MonetDB64/etc/monetdb5.conf) # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ # MonetDB/SQL module v2.26.4 loaded >!ERROR: GDKsave: failed name=24/2460, ext=tail, mode 0 !ERROR: GDKsave: failed name=23/2317, ext=tail, mode 0 !ERROR: GDKsave: failed name=25/2503, ext=tail, mode 0 !ERROR: GDKsave: failed name=26/2657, ext=tail, mode 0 !ERROR: GDKsave: failed name=22/2274, ext=tail, mode 0 !ERROR: GDKsave: failed name=22/2224, ext=tail, mode 0 !ERROR: GDKsave: failed name=01/112, ext=head, mode 0 !ERROR: logger_exit: could not open /Users/someuser/MonetDB64/var/MonetDB5/sql_logs/bigdata/sql/log System:MacPro Dual Quad Xenon Leopard OS X 32GB RAM R 2.8.1 32Bit MonetDB v5.8.4 complied for i386-apple-darmin9.6.0/64bit Many thanks. Yuesheng

4 28

[MonetDB-users] Apples and oranges
by Nils Grimsmo 17 Mar '09

17 Mar '09

Hi! I have some questions as to how MonetDB/XQuery should be compared fairly to other systems. If I re-run a query multiple times in a single call to `mclient`, is any calculation re-used? How about if I run multiple similar queries in a single call? Example: $ cat www.xq count(doc("dblp")//www) $ cat www_s10.xq (count(doc("dblp")//www), count(doc("dblp")//www), count(doc("dblp")//www), count(doc("dblp")//www), count(doc("dblp")//www), count(doc("dblp")//www), count(doc("dblp")//www), count(doc("dblp")//www), count(doc("dblp")//www), count(doc("dblp")//www)) $ cat www_s100.xq (count(doc("dblp")//www), ... count(doc("dblp")//www)) $ mclient --language=xquery --time < www.xq 11760 Timer 22.552 msec (Assert we are running hot.) $ mclient --language=xquery --time < www.xq 11760 Timer 21.661 msec $ mclient --language=xquery --time < www_s10.xq 11760, [snip] 11760 Timer 33.063 msec $ mclient --language=xquery --time < www_s100.xq 11760, [snip] 11760 Timer 252.414 msec So the average execution times are 22, 3.3 and 2.5 milliseconds. Is the extra cost for the first query just starting up the client program, or is some calculation re-used? If we now look at more expensive queries: $ cat dblp_authors.xq count(doc("dblp")/dblp//author[text()="Grzegorz Rozenberg"]) Just repeating the same: $ cat dblp_authors_s10.xq (count(doc("dblp")/dblp//author[text()="Grzegorz Rozenberg"]), count(doc("dblp")/dblp//author[text()="Grzegorz Rozenberg"]), count(doc("dblp")/dblp//author[text()="Grzegorz Rozenberg"]), count(doc("dblp")/dblp//author[text()="Grzegorz Rozenberg"]), count(doc("dblp")/dblp//author[text()="Grzegorz Rozenberg"]), count(doc("dblp")/dblp//author[text()="Grzegorz Rozenberg"]), count(doc("dblp")/dblp//author[text()="Grzegorz Rozenberg"]), count(doc("dblp")/dblp//author[text()="Grzegorz Rozenberg"]), count(doc("dblp")/dblp//author[text()="Grzegorz Rozenberg"]), count(doc("dblp")/dblp//author[text()="Grzegorz Rozenberg"]), count(doc("dblp")/dblp//author[text()="Grzegorz Rozenberg"])) Different but related queries: $ cat dblp_authors_x10.xq (count(doc("dblp")/dblp//author[text()="Grzegorz Rozenberg"]), count(doc("dblp")/dblp//author[text()="Wen Gao"]), count(doc("dblp")/dblp//author[text()="Irith Pomeranz"]), count(doc("dblp")/dblp//author[text()="Hector Garcia-Molina"]), count(doc("dblp")/dblp//author[text()="Moshe Y. Vardi"]), count(doc("dblp")/dblp//author[text()="Joseph Y. Halpern"]), count(doc("dblp")/dblp//author[text()="Noga Alon"]), count(doc("dblp")/dblp//author[text()="Wei Li"]), count(doc("dblp")/dblp//author[text()="Ming Li"]), count(doc("dblp")/dblp//author[text()="Donald F. Towsley"]) ) $ mclient --language=xquery --time < dblp_authors.xq 351 Timer 1238.436 msec $ mclient --language=xquery --time < dblp_authors.xq 351 Timer 1253.927 msec $ mclient --language=xquery --time < dblp_authors_s10.xq 351, ... 351 Timer 1284.191 msec $ mclient --language=xquery --time < dblp_authors_x10.xq 351, 347, 346, 341, 334, 334, 330, 320, 320, 317 Timer 2610.589 msec Here the average times are 1238, 128 and 261 milliseconds. Here the difference is clearly not just startup of the client. If this was not a client-server architecture, I would guess the difference came from opening files, getting stuff into cache, etc.. Are there similar reasons here? What parts of the calculations are actually done inside the client, if any? If the answer is none, why is this behavior seen? In conclusion: When running multiple queries, what would be the most fair way to compare MonetDB/XQuery to other client/server architectures in your view? Concatenating the queries in a single call to `mclient`, or multiple calls? When timing a single query, can it be repeated multiple times in a single call, and the average taken, without being unfair? If I use for example MS SQL Server 2008, there is no gain from a single invocation of the client, whether I have multiple SQL statements SELECT x.query('$q) FROM t; ..., SELECT x.query('$q) FROM t; Or a single SQL statement with a list of XPath queries SELECT x.query('($q, ..., $q)') FROM t; Klem fra Nils -- http://www.idi.ntnu.no/~nilsgri/ Why is this thus? What is the reason of this thusness? - Artemus Ward

4 4

[MonetDB-users] owner of files in dbfarm changed
by Ross Bates 16 Mar '09

16 Mar '09

Hi All - I've been running an Feb2009 nightly install for a few weeks now with no issues. Tried to start the database this morning and was getting tons of errors about the BACKUP directory, SQL Catalog, etc... It turns out that somehow various files dbfarm directory were changed to root ownership. Checked the system logs, bash history, etc.... and root hasn't been used to start any monetdb services or anything else related to monetdb. I know it sounds far fetched but is there something internal to the db which could have done this? Anyone seen mysterious ownership changes like this before? As for a solution, should I be ok just doing a chown on everything below my monetdb home back to the installation user? Thanks, Ross

2 1

[MonetDB-users] [Fwd: making the server accessible from other machines]
by Martin Kersten 16 Mar '09

16 Mar '09

-------- Original Message -------- Subject: making the server accessible from other machines Date: Mon, 16 Mar 2009 11:59:29 +0100 From: francois guérin <replonk(a)gmail.com> To: monet(a)cwi.nl Hi, (i'm francois, this is not the first time i come to ask you some questions about monetdb...) i've tried to make the server accessible from another machine, but it dont work... when i launch the server, and enter the statement " xprc_trusted.delete(); ", everything's fine and i can access to my server with another machine. but, when i edit the MonetBD.conf file, as it's preconized in http://monetdb.cwi.nl/projects/monetdb/XQuery/Documentation/Security.html nothing change a quick look at my monetDB.conf file: # if not set port to address the HTTP server for pathfinder = mapi_port+1 xrpc_port="" # xrpc daemon is open for outside connections by default xrpc_open=yes # Additional options to be passed to the XRPC server, currently only # "timing". xrpc_options="" # IP addresses or hostname separated by ';' who can execute scripts in # <datadir>/MonetDB/xrpc/admin/ xrpc_admin="" # IP addresses or hostname separated by ';' who can retrieve XML # documents stored in the database using a URL of the form: # http://<host>[:port]/xrpc/<name>.xml xrpc_user="" # url prefixes of trusted modules separated by ';' xrpc_trusted="" As you can see, all slots are either open, either empty (that should mean any url/modules/user are allowed)

1 0

Re: [MonetDB-users] import error in python script
by Ranadeeran 16 Mar '09

16 Mar '09

Yes i did that but didn't work.. > You should set PYTHONPATH to something like > /prefix/lib/python2.5/site-packages > > Can you confirm? > > Thanx, > Lazaros. > > On Thu, Mar 12, 2009 at 08:36:08PM +0530, Ranadeeran wrote: >> hi all >> i use MonetDB Database Server Toolkit v0.4 and ubuntu 8.10. >> im unable to issue any of the monetdb commands without prefixing them >> with >> a ./ >> that is instead of mserver5,it works only when i give ./mserver5 >> >> And im able to issue these commands only when im in the bin directory >> though i ve permanantly set the PATH variable in .bash_profile >> >> when i try to connect to monetdb using the sample python script that is >> given in the docs,i get an import error telling unable to import >> MonetDbSQL,though i ve set the PYTHONPATH variable to >> /prefix/lib/python2.5/site-packages/MonetDb directory >> >> the script is >> import MonetSQLdb >> # Let the cursor return dictionaries instead of tuples: >> # x = MonetSQLdb.connect(cursorclass = MonetSQLdb.cursors.DictCursor) >> x = MonetSQLdb.connect(host = 'localhost', user = 'monetdb',password = >> 'monet\db', lang = 'sql') >> #x = MonetSQLdb.connect(lang='sql') >> c = x.cursor() >> c.execute('select * from test') >> #print c.fetchone() >> print c.fetchall() >> x.close() >> >> But the script works fine on Debian Etch. >> >> i need to overcome these two issues... >> >> Thanks in advance, >> Mahesh >> ----------------------------------------- This email was sent using TCEMail Service. Thiagarajar College of Engineering Madurai - 625015 (India)

1 0

[MonetDB-users] import error in python script
by Ranadeeran 13 Mar '09

13 Mar '09

hi all i use MonetDB Database Server Toolkit v0.4 and ubuntu 8.10. im unable to issue any of the monetdb commands without prefixing them with a ./ that is instead of mserver5,it works only when i give ./mserver5 And im able to issue these commands only when im in the bin directory though i ve permanantly set the PATH variable in .bash_profile when i try to connect to monetdb using the sample python script that is given in the docs,i get an import error telling unable to import MonetDbSQL,though i ve set the PYTHONPATH variable to /prefix/lib/python2.5/site-packages/MonetDb directory the script is import MonetSQLdb # Let the cursor return dictionaries instead of tuples: # x = MonetSQLdb.connect(cursorclass = MonetSQLdb.cursors.DictCursor) x = MonetSQLdb.connect(host = 'localhost', user = 'monetdb',password = 'monet\db', lang = 'sql') #x = MonetSQLdb.connect(lang='sql') c = x.cursor() c.execute('select * from test') #print c.fetchone() print c.fetchall() x.close() But the script works fine on Debian Etch. i need to overcome these two issues... Thanks in advance, Mahesh ----------------------------------------- This email was sent using TCEMail Service. Thiagarajar College of Engineering Madurai - 625015 (India)

4 3

[MonetDB-users] Random errors and segfaults executing concurrent queries
by Dominique Prunier 12 Mar '09

12 Mar '09

Hi, I'm experiencing a lot of instabilities using MonetDB-Feb2009 on a moderately big database (70GB) with 3 concurrent (read only) connections. In my test setup, i have 3 identical tables which i query in parallel (from 3 jdbc connections). Almost every time, i get some weird errors: TypeException:user.s213_7[16]:'io.s13_4' undefined in: _26:any := io.s13_4() TypeException:user.s244_2[18]:'io.s14_6' undefined in: _31:any := io.s14_6() TypeException:user.s236_8[31]:'io.s18_3' undefined in: _47:any := io.s18_3() .... Finally, at some point, the server often segfault. Is there anything i can do to improve this ? Thanks,

1 0

[MonetDB-users] Strange performance behavior on bulk import with / without sequences
by Cimballi 11 Mar '09

11 Mar '09

Hi, I have a strange behavior with MonetDB and the JDBC driver, maybe you have an explanation. Here is what I do : I import about 100 000 rows in MonetDB using the JDBC driver and simple SQL statements (not prepared) with Spring JDBC API. I made the test a first time using sequences, so before inserting the data I query for the next sequence number and then I insert the data. The second time, I generate the sequence number on the application side, using a simple increment, so I directly insert the data. And the strange result : In the first test, it took 7:30 minutes for the whole insert. In the second test, it took only 30 seconds for the whole insert. So, it seems there is a problem with the select performance, and in fact I saw this problem for another select operation. Do you have any idea about where it can come from ? Is there any configuration option or the way I use the JDBC API ? Thanks, Cimballi

2 3

[MonetDB-users] writing out all fields
by dariuszs 11 Mar '09

11 Mar '09

Hi, Selecting 50 fields out of 300 takes almost no time to write out to csv file, but selecting everything takes forever - is there any setting that can improve the speed to write out all fields from a table? Thanks. Dariusz.

2 1

[MonetDB-users] MonetDB-MAL usage questions
by Maria 10 Mar '09

10 Mar '09

Hi, I am having some problems using mal. firstly, I want to find bats of a table 'st' I loaded. I created a table 'st' using sql. > ./mclient -lsql -ddemo > \<simpletable.sql ==> it creates table 'st' with two columns 'id' and 'name' > \q then, I try to use mal. > ./mclient -lmal -ddemo > bbp.open(); > bbp.prelude(); > a := bbp.bind("st", "id"); then, I got following error msg > ERROR = !MALException:bbp.find:BAT not found I thought when a table is created using sql, it stored as number of bats and I can find it through bat buffer pool. but it seems that there is nothing in the bbp ( I tried bbp.getObjects(), and printed returns which contains no bats). Where can I get bats of table 'st'? What can be the logical name of each bat? (same as column name?? or tablename_columnname??) Second question) Although I've read all documents in MonetDB site, I'm still quite confused the way to use mal. For example, if I want to create table using mal, how could it be done? sql statement: "create table st ("id" integer not null, "name" varchar(30));" To understand mal, I think I need number of examples. Is there any documents I can study about mal? Is there any way to see system generated mal when I run sql statement? If I can, it can be good example code for me. I really hope that any one could help me. Thanks.

3 2

Re: [MonetDB-users] too deep recursion
by Nils Grimsmo 09 Mar '09

09 Mar '09

Hi, I just upgraded from the Augst to the Noveber super-ball, and the performance has worsened badly. Example queries on dblp.xml (441 MB): Q0: count(/dblp//author[text()="Michael Stonebraker"]) Q1: count(/dblp/*/author[text()="Michael Stonebraker"]) Query time in milliseconds: August November Q0 1100 4867 Q1 3993 17999 I have compiled with --enable-optimise both times. I query with: mclient --language=xquery --algebra --time < $QUERYFILE Is this performance degradation expected? If so, why? BTW: Is there any way of finding how much disk space a collection uses? Thank you for contributing free software! Klem fra Nils -- http://www.idi.ntnu.no/~nilsgri/ Why is this thus? What is the reason of this thusness? - Artemus Ward

3 4

[MonetDB-users] Kettle and MonetDB
by denvro 09 Mar '09

09 Mar '09

Hello, I have just installed Kettle 3.1 on my Archlinux machine. I wanted to use it with MonetDB but when i try to create a JDBC connection i get the following message: Error connecting to database [MonetDB] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class nl.cwi.monetdb.jdbc.MonetDriver) Server challenge string unusable! Challenge contains too few tokens: !an internal error has occurred, please try again later I have merovingian running in the back and created a database "pentaho". See status below: bash-3.2# monetdb status -l pentaho pentaho: location: /usr/local/MonetDB/var/MonetDB5/dbfarm/pentaho database name: pentaho state: running locked: no scenarios: mal sql msql connections: mapi:monetdb://myhost:50001/ start count: 3 stop count: 2 crash count: 0 current uptime: 51m 10s average uptime: 13m 12s maximum uptime: 14m 42s minimum uptime: 11m 41s last crash: (unknown) last start: 2009-02-21 13:03:00 average of crashes in the last start attempt: 0 average of crashes in the last 10 start attempts: 0.00 average of crashes in the last 30 start attempts: 0.00 Can anybody help me with this. I already use the lates .jar (monetdb-1.9-jdbc). Kind Regards, Dennis -- View this message in context: http://www.nabble.com/Kettle-and-MonetDB-tp22141036p22141036.html Sent from the monetdb-users mailing list archive at Nabble.com.

2 3

[MonetDB-users] Not working xquery
by Hans van Rijswijk (DT) 06 Mar '09

06 Mar '09

Hi all, Why does this xquery work: let $result := doc("document.xml")//*[properties] let $astypes := distinct-values(for $n in $result/ancestor-or-self::*[properties] return name($n)) return $astypes <> Whereas these xqueries don't: let $result := doc("document.xml")//properties/.. let $astypes := distinct-values(for $n in $result/ancestor-or-self::*[properties] return name($n)) return $astypes <> let $result := doc("document.xml")//properties/parent::* let $astypes := distinct-values(for $n in $result/ancestor-or-self::*[properties] return name($n)) return $astypes <> The latter two xqueries return an error: MAPI = monetdb@host:50000 QUERY = let $result := doc("document.xml")//properties/parent::* ERROR = !ERROR: ancestor-or-self: illegal data in size column or context list. !ERROR: PFll_ancestor_or_self: operation failed. Which MonetDB expert can explain? Regards, Hans v R

2 1

[MonetDB-users] vertically fragment a table manually
by Brightwin 05 Mar '09

05 Mar '09

hi all, Is it possible to vertically fragment a table manually in MonetDB,instead of the Binary Association Table which is automatically created by it. thanks in advance Brightwin. ----------------------------------------- This email was sent using TCEMail Service. Thiagarajar College of Engineering Madurai - 625015 (India)

3 2

[MonetDB-users] implementing high performance time series schemas in monetDB
by Tom H 05 Mar '09

05 Mar '09

Hi, I have recently been using the TSdbi/MySQL library in R, which allows mapping between time series matrices and data stored in a mysql backend - its actually pretty good, I've made loads of progress in a few days... However I now now looking at scaling it up to many parallel sources of time series data, and my limited understanding of implementing this type of schema suggests that column orientated databases like monetDB should perform better than MySQL for this type of data. (?) The schema suggested as the default for storing irregular time series is as follows; create table T ( id VARCHAR(40), date DATETIME, v double DEFAULT ); with an index on the ident and the DATETIME field; CREATE INDEX Tindex_id ON T (id); CREATE INDEX Tindex_date ON T (date); So I am looking to support 500+ writes per second, while entertaining a whole bunch of queries of time periods like; SELECT date, v FROM T WHERE id = 'series1' order by date select date, v from T WHERE date > NOW() - INTERVAL 1 WEEK AND date < NOW(); I was hoping for some advice on whether monetDB is suitable for this type of data, and performance suggestions to get it blisteringly fast!! Thanks, Tom

1 0

[MonetDB-users] too deep recursion
by Lazaros Koromilas 02 Mar '09

02 Mar '09

Hi all, We are trying to annotate some XML data with MonetDB/XQuery. For this I run some big queries, that contain unions of many Xpath expressions (say 100). I get the following error: ERROR = !fatal error: aborted too deep recursion Tried to use the option declare option pf:recursion-depth "<number>"; I see no difference in bahaviour. I also call mclient with -G, though I don't know if it's needed. MonetDB Server is v4.26.2 and default back-end is 'algebra'. Any help with this? Thank you, Lazaros. -- http://www.ics.forth.gr/~koromil

3 4

[MonetDB-users] SUM of NULLs is 0?
by kelas 01 Mar '09

01 Mar '09

Dear MonetDB-users, a complete newbie to MonetDB, I can't really tell whether it is a bug, feature or I'm just getting it all wrong. A script below illustrates some weird NULL handling behaviour found in Nov2008-SP2: -- years under audit CREATE TABLE BUDGET_PERIOD (BP smallint NOT NULL); INSERT INTO BUDGET_PERIOD VALUES (1998); INSERT INTO BUDGET_PERIOD VALUES (1999); INSERT INTO BUDGET_PERIOD VALUES (2000); INSERT INTO BUDGET_PERIOD VALUES (2001); INSERT INTO BUDGET_PERIOD VALUES (2002); INSERT INTO BUDGET_PERIOD VALUES (2003); INSERT INTO BUDGET_PERIOD VALUES (2004); INSERT INTO BUDGET_PERIOD VALUES (2005); -- annual expenditure data CREATE TABLE EXPENDITURE (BP smallint NOT NULL, AMOUNT DECIMAL(15,2)); INSERT INTO EXPENDITURE VALUES (1999, 0.00); INSERT INTO EXPENDITURE VALUES (2000, 1.00); INSERT INTO EXPENDITURE VALUES (2001, 2.00); INSERT INTO EXPENDITURE VALUES (2002, 3.00); INSERT INTO EXPENDITURE VALUES (2003, 4.00); INSERT INTO EXPENDITURE VALUES (2004, NULL); -- calculate past years expenditure as of year: expected to be NULL for 1998, returns 0 SELECT A.BP, SUM( B.AMOUNT ) AS TOTAL_EXPD_ASOF FROM BUDGET_PERIOD A LEFT JOIN EXPENDITURE B ON (A.BP >= B.BP) GROUP BY A.BP ORDER BY A.BP -- same as above using CASE: returns all nulls (?!) SELECT A.BP, SUM( CASE WHEN A.BP >= B.BP THEN B.AMOUNT ELSE NULL END ) FROM BUDGET_PERIOD A, EXPENDITURE B GROUP BY A.BP go Regards, Vladimir

2 1

[MonetDB-users] [Fwd: Re: monetdb, xquery and perl]
by Martin Kersten 01 Mar '09

01 Mar '09

-------- Original Message -------- Subject: Re: monetdb, xquery and perl Date: Fri, 27 Feb 2009 10:35:15 +0100 From: francois guérin <replonk(a)gmail.com> To: Martin.Kersten(a)cwi.nl References: <31b3364e0902230836l140c9d0cs932937c392e8e9d(a)mail.gmail.com> <49A2EBEC.4050306(a)cwi.nl> ok! I'll then try the xrpc requests... is there a way to delete a collection in the database? (deleting documents one by one in a given collection is quite fastidious) and a way to delete a database created by the command Mserver --dbname=<...> ? (the only way i found was to physically delete directories with that same name) Thanks, francois. 2009/2/23 Martin Kersten <Martin.Kersten(a)cwi.nl>: > francois guérin wrote: >> >> Hi, >> I am about to develop an app using monetdb and its xquery part. >> My app will essentially be made of perl code. >> But it seems that perl is only used in monetdb's sql part, isn't? like >> using sql statements to access arrays and rows, but there's no way to >> access xml collections. >> >> Am i right or haven't i read enough of monetdb's documentation? > > You are right. The PHP, Perl, JDBC application interfacing to > the XML/XQuery part is less developed. > > regards, Martin >> >> Thanks a lot, >> >> francois. > >

2 1

[MonetDB-users] [Fwd: Re: Monet DB for RDF databases, BLOB]
by Martin Kersten 26 Feb '09

26 Feb '09

1 0

[MonetDB-users] Set the user of MonetDB in Windows
by Xiaofang Tao 23 Feb '09

23 Feb '09

Hello, I intend to know how can I specify the user of one database on the Monet. Hoping for your reply. Thank you very much. TaoXiaofang

2 1

[MonetDB-users] external functions
by dariuszs 21 Feb '09

21 Feb '09

Hi, Does anybody have an example of how to call external functions written in C? Thank you. Dariusz.

2 1

[MonetDB-users] Corrupt DB - missing bat files
by David Svenson 19 Feb '09

19 Feb '09

Hi, When importing date with 'COPY INTO' I reached a database corruption state. When I open the server, it comes up fine, but immediately when I start a client the server crashes with this message: # Listening for connection requests on mapi:abacusdb://127.0.0.1:50000/ # AbacusDB/SQL module v2.27.0 loaded >!ERROR: GDKload: cannot open: name=01\106, ext=head !OS: The system cannot find the path specified. !ERROR: GDKload: failed name=01\106, ext=head The bat files for 01\106 that are mentioned in the error message are missing from the dbfarm. Does the fact that they are supposed to be in folder 01 mean that these are system tables? Can I recover from this state, or has my current database become unrecoverably corrupt? -- View this message in context: http://www.nabble.com/Corrupt-DB---missing-bat-files-tp22096097p22096097.ht… Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] Please, HELP me!
by Xiaofang Tao 18 Feb '09

18 Feb '09

Hello, my friends： I have just installed the latest version of MonetDB5 (SQL) on windows, 32bit system. When I start the client (start-programs-MonetDB5-MonetDB SQL Client), after I start the server (start-programs-MonetDB5-MonetDB SQL Server), the client window prompted start with sql, and I can not use the command like -d. -f, -H, -u and so on, moreover, I can not specify the user or the schema. If I want to use these commands and to specify the user and the schema, what I should do. Hoping for your reply! Best regards. Tao Xiaofang

1 0

[MonetDB-users] Please, HELP me!
by taoxiaofang 18 Feb '09

18 Feb '09

Hello, my friends： I have just installed the latest version of MonetDB5 (SQL) on windows, 32bit system. When I start the client (start-programs-MonetDB5-MonetDB SQL Client), after I start the server (start-programs-MonetDB5-MonetDB SQL Server), the client window prompted start with sql, and I can not use the command like -d. -f, -H, -u and so on, moreover, I can not specify the user or the schema. If I want to use these commands and to specify the user and the schema, what I should do. Hoping for your reply! Best regards. 2009-02-18 taoxiaofang

1 0

[MonetDB-users] Java 1.6 and MonetDB JDBC driver
by Fabian Groffen 17 Feb '09

17 Feb '09

http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6795561 The MonetDB JDBC driver is affected by above bug, which manifests itself as an IndexOutOfBoundsException thrown somewhere deep from the heart of the driver in the mcl StartOfHeaderParser. The only workaround is to use JDK 1.4 or 1.5 if you hit this problem.

2 1