February 2010 - users-list

[MonetDB-users] Monetdb + unixODBC
by Alexander Barkov 18 Feb '10

18 Feb '10

Hello, I am a new in MonetDB. I'm testing MonetDB + unixODBC with an application which inserts long BLOB values, and I'm having some problems. Can you please help me? 1. When I use rc= SQLBindParameter(hstmt, position, SQL_PARAM_INPUT, SQL_C_DEFAULT, SQL_LONGVARBINARY, 0, 0, (char*) data, data_size, &BindBuf[position].size); I get error "Optional feature is not implemented". If I change SQL_LONGVARBINARY to SQL_VARCHAR, it works, however it wants the data in HEX notation, instead of raw binary buffer. That means I need 2*data_size extra memory to encode my binary data in hex, and then send the result send to SQLBindParameter. Is there a way to bind raw binary data, to avoid hex encoding? 2. When I insert blob data using rc= SQLExecDirect(hstms, "INSERT INTO t1 (blob_column)" "VALUES " "('<long hex-string>')", SQL_NTS); It works fine for short data, but it returns this error when hex-string is long enough: [SQLSTATE:S1000][unixODBC][MonetDB][ODBC Driver 1.0]current transaction is aborted (please ROLLBACK) I guess I hit some maximum possible query length limit, or maybe maximum possible transaction size. Is there a way to configure MonetDB to allow longer values? 3. Does the native MonetDB API have the same limitations with the bind types and maximum query(or transaction) size? Thank you very much!

2 9

[MonetDB-users] MAL BAT Types
by Gerrard_56 14 Feb '10

14 Feb '10

hi, I’m writing a theoretical paper about MonetDB and I have a question about the MAL. Does the MAL also use inverted lists and are the updated in the same way described for the MIL in the thesis of P. A. Boncz “Monet: A Next-Generation DBMS Kernel For Query-Intensive Applications” on page 137f. Thanks for any information gerrard -- View this message in context: http://old.nabble.com/MAL-BAT-Types-tp27583769p27583769.html Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] Admin GUI is blank page
by jasonpriem 12 Feb '10

12 Feb '10

Hi, I've just installed MonetDB on my 32-bit Vista system. The server and client both start up fine; however, http://127.0.0.1:50001/admin gives me a blank page. I can't really think of much to try, save deactivating the firewall (which made no difference). Any suggestions? Thanks. -- View this message in context: http://old.nabble.com/Admin-GUI-is-blank-page-tp27559054p27559054.html Sent from the monetdb-users mailing list archive at Nabble.com.

2 2

[MonetDB-users] Missing element names when bulkloading XML files into MonetDB
by Alexander Koglin 12 Feb '10

12 Feb '10

I have buldloaded a collection of 10.000 XML files into MonetDB like this: for $d in doc("/monetdbfiles.xml")//doc return pf:add-doc(fn:concat($d/@path,$d/@name), fn:string($d/@name), "abap10k", 0) <> Now the XML files have missing element names and look like this in MonetDB: <AST> < type="compound" line="1" id="1"> < type="stmt" line="1" id="2"/> < type="stmt" line="5" id="3"> < type="clause" line="5" id="4"> < type="idf" line="5" id="5"/> </> What could be wrong? Thanks for your help.

2 1

[MonetDB-users] Pager in mclient?
by Mark Bucciarelli 11 Feb '10

11 Feb '10

>From man page, it looks like I should be able to pipe the output of a command through less. But I can't figure out the syntax. For example: sql>\|less \d mytable sql> Can I do this? If so, is there a way to set it up so this always happens? This is candidate release from November 2009. Thanks, Mark

2 1

[MonetDB-users] where is the data?
by Zoltan Tomory 09 Feb '10

09 Feb '10

Curiosity has gotten the best of me. Where is the datafile/s kept and what is it called? Thanks in advance, Zoltan Tomory

2 1

[MonetDB-users] Monetdb and Hardy Heron
by Radek Maciaszek 09 Feb '10

09 Feb '10

Hi, I noticed the release for Karmic Koala but none for Hardy Heron. Is it possible to install monetdb with hardy? Is there perhaps any wiki page in monetdb documentation which expplains steps? Looking forward to trying monetdb! Radek

3 3

[MonetDB-users] dump and restore---use merovingian database files?
by Mark Bucciarelli 09 Feb '10

09 Feb '10

I just had to restore a database dump, and I got nervous watching top. The box, which doesn't have much RAM, started to swap on the restore. At times, the monetdb process was using over 90% of available RAM. While I only have 500M RAM, the database only has 10m records. The gzipped dump is 142MB. Other than the backup/restore issue, Monet seems quite happy running with this much data and so little RAM. It looks like it could support much more data---but I'm not so sure the restore will. If I run $ monetdb stop -a can I safely tar the database files and use that as a backup? Or do I need to stop merovingian too? Or is this approach not safe? Thanks, Mark

3 3

[MonetDB-users] Ubuntu distribution is broken with latest release.
by Mike Mansell 08 Feb '10

08 Feb '10

Attempting to install latest release using Ubuntu packages but the package definition appears to still be referencing the older 1.34.2-20091210 versions while the actual libraries have been updated to the newer 1.34.4-20100112 version. Installation gets errors: W: Failed to fetch http://monetdb.cwi.nl/downloads/Ubuntu/pool/monetdb/m/monetdb/libmonetdb1_1… 404 Not Found W: Failed to fetch http://monetdb.cwi.nl/downloads/Ubuntu/pool/monetdb/m/monetdb-client/libmon… 404 Not Found W: Failed to fetch http://monetdb.cwi.nl/downloads/Ubuntu/pool/monetdb/m/monetdb5-server/libmo… 404 Not Found W: Failed to fetch http://monetdb.cwi.nl/downloads/Ubuntu/pool/monetdb/m/monetdb-sql/libmonetd… 404 Not Found W: Failed to fetch http://monetdb.cwi.nl/downloads/Ubuntu/pool/monetdb/m/monetdb5-server/monet… 404 Not Found W: Failed to fetch http://monetdb.cwi.nl/downloads/Ubuntu/pool/monetdb/m/monetdb-sql/monetdb5-… 404 Not Found

7 14

[MonetDB-users] MonetDB XQuery Bulk Load / Bulkload
by Alexander Koglin 07 Feb '10

07 Feb '10

I have currently installed a version of MonetDB XQuery for Linux and want to bulkload data like this: http://monetdb.cwi.nl/XQuery/Documentation/Bulk-Loading-a-Collection.html#B… For that purpose, I used the following command inside the Client: for $d in doc("/monetdbfiles.xml")//doc return pf:add-doc(fn:concat($d/@path,$d/@name), fn:string($d/@name), "abap10k", 0) <> It references the following, definitely existing XML file: <dir> <doc path="/home/epic/tarari_svn/benchmarks/abap/ABAP/" name="ACL_AUNIT_RESULT==============CCDEF"> <doc path="/home/epic/tarari_svn/benchmarks/abap/ABAP/" name="ACL_AUNIT_RESULT==============CCIMP"> <doc path="/home/epic/tarari_svn/benchmarks/abap/ABAP/" name="ACL_AUNIT_RESULT==============CCMAC"> <doc path="/home/epic/tarari_svn/benchmarks/abap/ABAP/" name="ACL_AUNIT_RESULT==============CI"> <doc path="/home/epic/tarari_svn/benchmarks/abap/ABAP/" name="ACL_AUNIT_RESULT==============CM001"> <doc path="/home/epic/tarari_svn/benchmarks/abap/ABAP/" name="ACL_AUNIT_RESULT==============CM002"> <doc path="/home/epic/tarari_svn/benchmarks/abap/ABAP/" name="ACL_AUNIT_RESULT==============CM003"> <doc path="/home/epic/tarari_svn/benchmarks/abap/ABAP/" name="ACL_AUNIT_RESULT==============CM004"> <doc path="/home/epic/tarari_svn/benchmarks/abap/ABAP/" name="ACL_AUNIT_RESULT==============CM005"> </dir> But unfortunately an error is thrown (I also tried it unter Windows and it was the same): MAPI = root@localhost:50000 QUERY = for $d in doc("/monetdbfiles.xml")//doc ERROR = !ERROR: err:FODC0002, Error retrieving resource (no such document "/monetdbfiles.xml"). What could be the reason for that?

1 1