- users-list - monetdb.org

[MonetDB-users] (no subject)
by Richard Wesley 20 Oct '08

20 Oct '08

Hi All - I am trying to evaluate MonetDB on Windows by loading up some large data sets. I'm not having much luck and I'm hoping someone can help me out. The first set of problems revolve around the ODBC driver. It seems to not be able to report errors or even return the results of queries reliably. Most errors come back as a generic error message although we occasionally run into strange messages involving UTF-16 conversions when no string columns are involved (e.g. a count distinct of a numeric column). We are using the July 2008 version from the web site. Are these known issues and is there a more recent build we could try? This is not in production yet, we are simply trying to evaluate the system. I have managed to work around the ODBC problems very slowly and have got to a point where I can load small data sets. But when I then try to do a large insert using the COPY FROM syntax, my client got a "connection terminated" error. When I take the COPY FROM statement and paste it into the client, the MonetDB server crashes. The only log files I can find have a few (mostly unprintable) characters in them. Restarting the server and trying again produces the same problem. The insert query is COPY 6568253 RECORDS INTO "Airlines"."_2005_On_Time_Performance" FROM 'C:\\DOCUME~1\\hawkfish\\LOCALS~1\\Temp\\1\\7A.tmp\\table.tbl' USING DELIMITERS '\t', '\n', '\''; Is there some limit on the COPY INTO syntax? Is there some log file somewhere that could point me in the right direction? TIA, ________________________________________________________ Richard Wesley Senior Software Developer Tableau Software Visit: http://www.trytableau.com/now.html

4 13

[MonetDB-users] MonetDB with Pentaho and Kettle
by Tom Barber 17 Oct '08

17 Oct '08

Hi Guys, As of 3.1 Kettle now has a connector built in for Monet so I thought I'd give it another go after not getting too far earlier in the year. Anyway I have it up and running on a Quad Core Xeon box running Centos x86_64 and it seems pretty happy, but when I try to copy sizable amounts of data into it, kettle stops with an error: 2008/10/17 12:29:22 - Table output.0 - Prepared statement : INSERT INTO voc.d_budgets3 (entity_anl_code, trad_code, Cost, Sales, CostMTD, SalesMTD) VALUES ( ?, ?, ?, ?, ?, ?) 2008/10/17 12:29:27 - Table output.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : Because of an error, this step can't continue: 2008/10/17 12:29:27 - Table output.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : org.pentaho.di.core.exception.KettleException: 2008/10/17 12:29:27 - Table output.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : Error inserting row into table [d_budgets3] with values: [19], [A09], [0], [0], [0], [0] 2008/10/17 12:29:27 - Table output.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : 2008/10/17 12:29:27 - Table output.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : Error inserting/updating row 2008/10/17 12:29:27 - Table output.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : current transaction is aborted (please ROLLBACK) But to my untrained eye the data looks fine(coming from a mysql database) and I don't know where to start debugging this or what settings I could change. The monet table is 2 Strings, 2 Int, 2 Big Num and it always inputs a load of data before stopping. What can I look at to resolve the issues? otherwise, rocking database and keep up the good work. Thanks Tom CONFIDENTIALITY NOTICE This e-mail is confidential and may also be privileged. Please notify us immediately if you are not the intended recipient. You should not copy it, forward it or use it for any purpose or disclose the contents to any person. If you have received this e-mail in error, please notify us as soon as possible and destroy your copy. Unless otherwise expressly stated, this e-mail is not intended to constitute a business letter, order form or other offer or invitation to you, nor does this e-mail form the basis of any contract. Contracts may not be concluded by e-mail and any contract or agreement attached is subject to contract and shall not and is not intended to create a legally binding relationship. This e-mail is sent by or on behalf of Encon Limited or the relevant subsidiary undertaking of Encon Limited with which you are dealing. Encon Limited is registered in England and Wales with company number 3411533 registered office at The Wolseley Center, Harrison Way, Leamington Spa, CV31 3HH, United Kingdom. VAT No 362 0233 93. Encon Ireland is registered in Ireland with company number 262605 registered office at Wolseley Ireland Moydrum Road, Athlone, Co Westmeath. Save a Tree ! - Please think before you print.

3 3

[MonetDB-users] Commercial Support
by Rick Spickelmier 17 Oct '08

17 Oct '08

Hi! Are there companies that are providing commercial support for MonetDB? The home page for MonetDB seems to imply that. If so, can somebody send me a pointer and does anybody have any experience with it? Thanks! Rick Rick Spickelmier | CTO | Success Metrics, Inc. | w (415) 738-2078 | ricks(a)successmetricsinc.com <mailto:ricks@successmetricsinc.com> | www.successmetricsinc.com | www.birst.com

3 2

[MonetDB-users] CREATE INDEX syntax?
by Richard Wesley 14 Oct '08

14 Oct '08

Hi Sjored - I have a lot of questions, so I thought I start a few threads if that is all right. What is the CREATE INDEX syntax? According to the manual it is CREATE [UNIQUE] INDEX <index_name> ON <table_name> ( <column_name>, ...) ; But whey I use this syntax, I get strange errors: sql>CREATE INDEX "_tidx_usernames_2a" ON "Performance"."usernames" ("username"); !CREATE INDEX: no such table 'usernames' sql>select count(*) from "Performance"."usernames"; +--------+ | count_ | +========+ | 5 | +--------+ sql> ________________________________________________________ Richard Wesley Senior Software Developer Tableau Software Visit: http://www.trytableau.com/now.html

1 0

[MonetDB-users] MonetDB on Windows
by bryan rasmussen 07 Oct '08

07 Oct '08

Hi, I haven't looked at monetdb for a while, but now for a new project I have I think it would be a really good solution. I downloaded the current windows installers yesterday (I want to develop this project on Windows for various reasons, specifically related to demos of another component part of the project I need to get up and running quickly that will need to run on Windows) anyway the installers did not install. I don't necessarily want to compile the source etc. since I didn't want to spend a lot of time on getting the database to work in the demo phase, so the question is: what is the last working Windows MSI version so I can download that version and worry about building a new one later? The main problem in the installed servers are a hard coded path to a config file, according to the following error message I get: Could not open file c:\Documents and Settings\sjoerd\My Documents\src\stable\vs32\NT32\etc\monetdb5.conf I guess I could create that path for the purposes of testing but I would rather get a working version. Thanks, Bryan Rasmussen

3 6

[MonetDB-users] Reusing index on another computer
by jz＠uva 07 Oct '08

07 Oct '08

Hi all, I have built an index on a server. I would like to reuse that index on my desktop for testing purposes. However, when I copy the demo directory (consisting of the index), and I restart MServer Mserver --dbinit='module(pathfinder);' --set xquery_backend=milprint_summer then I discover this error: !ERROR: database created with incompatible Mserver So my question is: can I, and if yes, how do I reuse/transfer an index from one computer to another one? Thanks, junte

6 13

[MonetDB-users] allocate timing and deallocate timing of memory
by gashi gashi 07 Oct '08

07 Oct '08

Hi, All I'm working with MonetDB Server v5.6.0, based on kernel 1.24.0 over RedHat Linux Enterprise 5.2. Would you tell me timing which in the memory is allocated and timing in which the memory is deallocated, or is there an instruction that deallocate the memory? Regards, gashi

2 1

[MonetDB-users] merovingian locking up - port issue?
by Ross Bates 07 Oct '08

07 Oct '08

I'm having an issue with merovingian locking up. This is the typical scenario. - Start mero and my db with ./merovingian sobi - Everything works great for anywhere between 50 & 100 queries, then mero stops responding (I'm using python, jdbc & php) - I can still connect to the db from the command line using ./mclient -d sobi -lsql -p 50001 - both merovingian and mserver5 processes continue to run, but mero will end up dying within 1-2 minutes by itself leaving the mserver5 process running - even when mero dies, it appears that all the ports are still in use. This is the result of netstat -a AFTER mero is dead: tcp 0 0 *:50000 *:* LISTEN tcp 0 0 *:50001 *:* LISTEN tcp 0 0 mayfair.local:50000 mayfair.local:48973 ESTABLISHED tcp 0 0 mayfair.local:48973 mayfair.local:50000 ESTABLISHED udp 0 0 *:50000 *:* - when I try to restart mero to reattach it to the database it fails with this error: ./merovingian: binding to stream socket port 50000 failed: Address already in use - stopping the db doesn't work becase mero isn't running. ./monetdb stop sobi warning: MonetDB Database Server is not running stop: cannot perform: MonetDB Database Server (merovingian) is not running - the only thing left to do is kill the mserver5 process and restart both mero and the db. Unfortunately the merovingian.log file doesn't tell me anything. Any other tips for helping troubleshoot this issue? The version is 5.7.0 and was built from the Aug 23rd nightly. Many Thanks, Ross

2 8

[MonetDB-users] Can I copy a local txt file into a remote MonetDB table
by Li Xiaohua 07 Oct '08

07 Oct '08

Hi: I want to copy a txt file into a remote MonetDB table. When I use the copy into command. what should I use after the "into"? using servername.database.schema.tablename? does it work?

1 0

[MonetDB-users] running the monetdb MSI installers on Windows
by bryan rasmussen 06 Oct '08

06 Oct '08

Hi, Is there anyone that has managed to run any particular Monet MSI installer with a resulting successful install of MonetDB (successful implying the database server will start afterwards)? If yes, which version did you use? The problems I have run into so far with the current stable release: Can not find DLLs when starting. Dlls do not seem to have proper entry points (when I try to run them) the server is expecting to find a config file under documents and Settings\Sjoerd\..... I tried uninstalling and installing one release earlier for the sql database, got the first problem again, didn't check if it had all the other problems. Best Regards, Bryan Rasmussen

1 0