June 2009 - users-list

[MonetDB-users] connection terminated
by Christoph Beekmans 25 Jun '09

25 Jun '09

Hi everybody, I posted my issue a few weeks ago, but i got no answer, so i try i again. I installed MonetDB on Windows with the geom module and afterwards i tried to execute a query with some geometric data types. But after a few changes to the query and execution i got an error. After that i had to restart MonetDB but i got an error message that the system tables couldn`t be loaded. If i start the server without geom support it starts fine but the sql client can`t connect: "Connection terminated Press any key to continue . . . " If i start the server with geom support it loads the sql and geom modules but shuts down after that without error message. Even a reinstall didn't fix it so the error must be somewhere else. Has anyone an idea about that? Please help, Thanks.

1 0

[MonetDB-users] Deployment of MonetDB
by Martin Kersten 24 Jun '09

24 Jun '09

Dear users, In our ongoing effort to improve the MonetDB software suite we would like to hear from you. It appears that MonetDB is used for teaching, and customers use it for/within their products. Also, the divergence in primary platform is crucial for us to keep focus. We would greately appreciate if you could replay with a short message how you deploy the software and your top priorities for a next release. Thank you for you cooperation, Martin Kersten

3 6

[MonetDB-users] May2009 - can't connect on Windows64
by Alex Bo. 24 Jun '09

24 Jun '09

Hi, I installed the new May2009 release. On Windows32 I have no problem connecting through Mapi. On Windows64, however, I can't connect. I get a 'Setup connection failed' error from Mapi. (I had no problem connecting on Windows64 with the Feb09 release) Please help, Thanks. -- View this message in context: http://www.nabble.com/May2009---can%27t-connect-on-Windows64-tp24056525p240… Sent from the monetdb-users mailing list archive at Nabble.com.

3 2

Re: [MonetDB-users] [Monetdb-checkins] load data from a file to a table
by Stefan Manegold 24 Jun '09

24 Jun '09

Hi Pedro, A) Thanks for using MonetDB. B) The users mailing list is "monetdb-users(a)lists.sourceforge.net", not "monetdb-checkins(a)lists.sourceforge.net". C) I'm afraid your report contains too little information (basically none) for us to provide any help. The least we'd (obviously) need to know is which version of MonetDB you're using on wich operating system and, in particular, what the exact problem is, i.e., the a detailed description of the symptoms and/or the error messages that you encounter. Stefan On Tue, Jun 16, 2009 at 02:54:01PM +0000, Pedro Bramao wrote: > > I'm trying to load data into a table from a file, named criminoso.sql, to a table named criminos stored in MonetDB. > I'm doing the following coomand : > > copy 2 records into criminoso from '/home/pedro/Escola/tabd/criminoso1.sql' using delimiters tuple_separator ',' record_separator ';'; > > But it's not working... i nedd some help!!!! > > thanks > > _________________________________________________________________ > Conheça os novos produtos Windows Live! Clique aqui. > http://www.windowslive.com.br > ------------------------------------------------------------------------------ > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |

1 0

Re: [MonetDB-users] disk usage
by Jens Oehlschlägel 23 Jun '09

23 Jun '09

> > http://www.fusionio.com/Products.aspx If this SSD sits on the bus, it is not compatible with i-core7, is it?

2 1

[MonetDB-users] Schema Changes Through JDBC
by Scott Stephens 22 Jun '09

22 Jun '09

I've been seeing some weird behavior when using Eclipse SQL Explorer to execute statements that modify the schema with the MonetDB May2009 release and the monetdb-1.10-jdbc.jar file. For instance, the statement CREATE TABLE Archive.Test ( var1 int, var2 varchar(100) ); yields a pop-up error message titled "Error Executing SQL" with the text "Schema statements are directly executed and therefor cannot be debugged, explained, profiled, traced, or used in a prepare statement". I'm not a Java user and haven't tried this in Java code as opposed to through SQL Explorer, so I can't conclusively link it to the JDBC driver as opposed to the SQL Explorer code, but I seem to recall this working in previous versions of MonetDB with SQL Explorer. Thoughts anyone? Is this supposed to work? Scott

2 1

Re: [MonetDB-users] CRT and GKLoad errors
by Florian Joßbächer 16 Jun '09

16 Jun '09

Hey, this issue is still unsolved. Are there any ideas or hints? Best regards, Florian.

1 0

[MonetDB-users] Is MonetDB for me?
by Bohák András 12 Jun '09

12 Jun '09

Dear Community, I plan to bulid a database of stock market data. The database structure is very simple, there will be a main table with columns like timestamp, stockID, price, volume. The size of the database is about 4 TB. I would like to use the database to search certain patterns, like "5% stock price change in 5 minutes", so all my queries will likely touch all the data in the database. Is MonetDB for me? Is it considerably faster than an OLTP database (Mysql, Oracle)? Another question: would you use cheap SATA hard drives for this, or is it worth to invest in 15k SAS drives? Is HDD an important performance factor? Thanks in advance for all your answers, Andras Bohak

2 1

[MonetDB-users] Crash after recurring column updates
by Alex Bo. 11 Jun '09

11 Jun '09

Hi, I am working on MonetDB Feb2009SP2 compiled and run on windows64 from CVS. After Creating a 40 Million row table, I did a series of ADD COLUMN and UPDATE operations on all 40M rows. After a few update queries the server crashed. I noticed that for each query a lot of memory was allocated, but not all of it freed after the query returned, so that after each update query the total amount of memory used by MonetDB has gone up, until eventually the server crashed. (The machine is 64 bit with 8GB of RAM) I then tried to reproduce it on a smaller database with 20 Million rows. I ran this query over and over: UPDATE testtable set testtable."MonthColumn" = "month"("DateColumn"); This too eventually crashed. I attached an image of the memory consumption from task manager that was taken right after the crash. http://www.nabble.com/file/p23984181/MonetMemory.jpg Any ideas on why this happens and how I can work around it? Is it at all a memory issue like I suspected? Thanks. -- View this message in context: http://www.nabble.com/Crash-after-recurring-column-updates-tp23984181p23984… Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] Slow import of large XML documents
by John van Schie (DT) 11 Jun '09

11 Jun '09

Hi, Today I tried to shred a XML document of 1.6 giga bytes using mclient and it took more than 3 hours (~150 kb/s) on a quite fast machine. I was a bit suprised. because for smaller documents shredding is quite fast. Are these numbers expected? I know that it can be hard to say something about this case without the document itself. So I'm currently working to anonymize the document, but what is the prefered way to get the document to the CWI? System information: - Fedora Core 10, x86_64, 32 GB RAM (24G cached/free), 5.5 GB disk free (after import) - MonetDB4 / XQuery v4.28.4, 64bit OIDs (RPM version) Commands: $ time mclient -p 50000 -l xq -s"pf:add-doc('/tmp/structure.xml', 'structure3.xml')" real 198m49.543s user 0m0.002s sys 0m0.003s [user@host tmp]$ ls -lah /tmp/structure.xml -rw-r--r-- 1 user user 1.6G 2009-06-08 16:26 /tmp/structure.xml Regards, John van Schie

3 3