June 2009 - users-list

[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

[MonetDB-users] Insert tuples with special characters especially umlauts
by Sebastian Bräuer 09 Jun '09

09 Jun '09

Hallo everybody, I would like to know whether there exist any possibilities to add tuples with umlauts as characters (ä,ö,ü) or other special characters like ß to tables. I tried to use the regular INSERT-statement as well as the COPY INTO-statement with a csv input file but without success (unexpected end of input error or missing ' to close the string). Example: CREATE TABLE Umlautnamelist(CUST_ID numeric(9,0) not null, CUST_NAME varchar(100) not null, constraint Umlautnamelist_PK primary key (CUST_ID)); INSERT INTO Umlautnamelist (123456789,'Bräuer'); Are there any chances to get it working? Thank you in advance. Sebastian

4 3

[MonetDB-users] possible bug in monetdb-install.sh
by Ying Zhang 09 Jun '09

09 Jun '09

Hi, I was using moentdb-install.sh to install the May 2009 release with the following command, which ends in an error: ================================ $ monetdb-install.sh --prefix=[pathto]/mdb_may2009 --enable-optimize --enable-xquery --22:11:36-- http://www.ins.cwi.nl/~monet/tars/latest/release/MonetDB.tar.bz2 => `/private/var/tmp/MonetDB-1244491895/MonetDB/ MonetDB.tar.bz2' Resolving www.ins.cwi.nl... 192.16.196.21 Connecting to www.ins.cwi.nl|192.16.196.21|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 882,241 (862K) [application/x-bzip2] 0K ........ ..... 100% 780.55 KB/s 22:11:37 (780.55 KB/s) - `/private/var/tmp/MonetDB-1244491895/MonetDB/ MonetDB.tar.bz2' saved [882241/882241] fetching http://www.ins.cwi.nl/~monet/tars/latest/release/MonetDB.tar {,bz2:bzip2,gz:gzip} failed! Please refer to the full log at /private/var/tmp/MonetDB-1244491895/log If you believe this is an error in the script or the software, file a bug and attach the logfile. Terminated ================================ The following code in the 'fetch()' function seems incorrect to me: for c in $LZMA $BZIP2 $GZIP ; do wget --progress=dot:mega -t 5 --passive-ftp $1.${c%:*} -P "$BUILDROOT"/$f > $QUIET ... done [[ ! -f "$BUILDROOT"/$f/$f.tar ]] && \ die "fetching $1 {$LZMA,$BZIP2,$GZIP} failed!" First, in the for-loop, e.g., MonetDB.tar.bz2 is fetched. Then, the code following the for-loop checks if ".../MonetDB.tar" exists, if not, it complains that fetching ".../MonetDB.tar.bz2" has failed, returning the error I got. Kind regards, Jennie

2 3