July 2017 - users-list

[MonetDB-users] Proofreading your professional documents
by Richard Hounslow 24 Feb '24

24 Feb '24

Dear Professor/Lecturer Please excuse us for contacting you directly. We are offering an efficient service to help you ensure your academic and professional work is written in perfect English. We will check the grammar and style of your work and return it to you to meet your requirements and deadlines. Proof-Reading-Service.com can provide you with a professional proofreading service at a very reasonable rate. All our proofreaders are highly qualified native English speakers. Many work as leading academics in their fields and all have extensive experience of proofreading to the highest standards. If you are interested in our service, please take a look at our website: www.proof-reading-service.com All you have to do is send us your document as a word attachment with the deadline and we will guarantee delivery of a perfectly written document to give you complete confidence when you submit your work. The fee is worked out on a flat rate (£6.95 per thousand words or 0.695 pence per word), so you know exactly how much the proofreading will cost in advance. Once we have received your document(s) we will confirm the word count, the price and the deadline. If you have not heard from us within 2 hours during normal business hours after you have sent your work please resend it from a different email account or send the file to proofreadings(a)gmail.com. We look forward to hearing from you! Yours faithfully Proof-Reading-Service.com

2 2

DEC2016-SP2 and BINARY bulk load
by Lynn Carol Johnson 11 Jan '18

11 Jan '18

Hi all – I have always used the COPY BINARY INTO … commands to load my 2.0 Billion row genetic data into a monetdb table. With 135 columns, it has been blindingly fast. Last week I moved from the June2016-SP2 release to dec2016-SP2. My binary loads are taking WAY longer. I killed one after 3 hours (via “call sys.stop(pid)” so it could clean up properly). I then started the load again, thinking perhaps the problem was related to the new columns I was adding. I have since dropped the table and remade it using the same data and scripts that worked in just over 3 minutes in February on the jun2016-SP2 load. It is really chugging along – I’m up to 30 minutes and counting. I don’t have access to the sql log files, but the Merovingian.log shows nothing. I do notice that previously the binary files, once loaded, were removed from the loading directly. This does not happen now. Were these files previously “moved” and now they are copied? Has anyone see this performance issue with Dec2016-SP2 COPY BINARY INTO …. Commands? Thanks - Lynn

5 17

MonetDB Blob Inserts
by Brian Hood 07 Dec '17

07 Dec '17

Hi Guys, I don't seem to be able to INSERT into a blob field is there any information how to achieve this. Regards, Brian Hood

3 6

Setting Up Tools
by Sandy 26 Oct '17

26 Oct '17

Just getting back into trying MonetDB after many years. Got the environment set up pretty well with the test DB `VOC` loaded up and able to do all expected in the command line tools. So I figured I would give a couple of the mentioned GUI tools a shot and see how they work against the server I just set up on a virtual box. I picked up the JDBC drivers and installed on my Window's 10 install of SQuirrel SQL and DBeaver. I got both of the drivers works sort of... On DBeaver I can execute and see queries in the tool but can't do much more than that. Overall looks like an issue with accessing the system table `sys.environment`, not sure if anything related to set up or rights. Using the `voc` user as created with the example db in the getting started. Any help or thought on where to start? Thanks! Sandy -------- Errors * DBeaver 4.0.8 On inspection of some of the logs I see things like - `Error loading object metadata from database` `SQL Error [22000]: SELECT: access denied for voc to table 'sys.environment' java.sql.SQLException: SELECT: access denied for voc to table 'sys.environment'` * SQuirreL SQL Client 3.7.1 java.sql.SQLException: SELECT: access denied for voc to table 'sys.environment' -------- Driver and DB versions I'm using this JAR for the drivers - C:\Users\Squidward\Downloads\monetdb-jdbc-2.25.jar, 2.25 (Liberica 20170330 based on MCL v1.15) MonetDB version - MonetDB v11.25.23 (Dec2016-SP5), 'mapi:monetdb://sandy-VirtualBox-18:50000/voc'

3 6

Error during installation (make)
by Dennis Fassl 31 Jul '17

31 Jul '17

Hi, I want to install MonetDB from the source files. (Version 11.27.1). I am following the guide "HowToStart.rst" in the source directory. But I get an error when executing make. Please find the output below. Do you have a hint for me how to solve this error? Many thanks and kind regards, Dennis make all-recursive make[1]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir' Making all in buildtools make[2]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/buildtools' make all-recursive make[3]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/buildtools' Making all in conf make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/buildtools/conf' make all-am make[5]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/buildtools/conf' make[5]: Nothing to be done for `all-am'. make[5]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/buildtools/conf' make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/buildtools/conf' make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/buildtools' make[4]: Nothing to be done for `all-am'. make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/buildtools' make[3]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/buildtools' make[2]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/buildtools' Making all in common make[2]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/common' make all-recursive make[3]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/common' Making all in stream make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/common/stream' make all-am make[5]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/common/stream' make[5]: Nothing to be done for `all-am'. make[5]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/common/stream' make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/common/stream' Making all in options make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/common/options' make all-am make[5]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/common/options' make[5]: Nothing to be done for `all-am'. make[5]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/common/options' make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/common/options' Making all in utils make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/common/utils' make all-am make[5]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/common/utils' make[5]: Nothing to be done for `all-am'. make[5]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/common/utils' make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/common/utils' make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/common' make[4]: Nothing to be done for `all-am'. make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/common' make[3]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/common' make[2]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/common' Making all in clients make[2]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/clients' make all-recursive make[3]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/clients' Making all in mapilib make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/mapilib' make all-am make[5]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/mapilib' make[5]: Nothing to be done for `all-am'. make[5]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/mapilib' make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/mapilib' Making all in mapiclient make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/mapiclient' make all-am make[5]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/mapiclient' make[5]: Nothing to be done for `all-am'. make[5]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/mapiclient' make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/mapiclient' Making all in examples make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/examples' make all-recursive make[5]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/examples' Making all in C make[6]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/examples/C' make all-am make[7]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/examples/C' make[7]: Nothing to be done for `all-am'. make[7]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/examples/C' make[6]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/examples/C' Making all in php make[6]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/examples/php' make all-am make[7]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/examples/php' make[7]: Nothing to be done for `all-am'. make[7]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/examples/php' make[6]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/examples/php' Making all in perl make[6]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/examples/perl' make all-am make[7]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/examples/perl' make[7]: Nothing to be done for `all-am'. make[7]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/examples/perl' make[6]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/examples/perl' make[6]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/examples' make[6]: Nothing to be done for `all-am'. make[6]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/examples' make[5]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/examples' make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/clients/examples' make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/clients' make[4]: Nothing to be done for `all-am'. make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/clients' make[3]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/clients' make[2]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/clients' Making all in gdk make[2]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/gdk' make all-am make[3]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/gdk' make[3]: Nothing to be done for `all-am'. make[3]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/gdk' make[2]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/gdk' Making all in monetdb5 make[2]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5' make all-recursive make[3]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5' Making all in mal make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/mal' make all-am make[5]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/mal' make[5]: Nothing to be done for `all-am'. make[5]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/mal' make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/mal' Making all in modules make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/modules' make all-recursive make[5]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/modules' Making all in atoms make[6]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/modules/atoms' make all-am make[7]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/modules/atoms' make[7]: Nothing to be done for `all-am'. make[7]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/modules/atoms' make[6]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/modules/atoms' Making all in kernel make[6]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/modules/kernel' make all-am make[7]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/modules/kernel' make[7]: Nothing to be done for `all-am'. make[7]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/modules/kernel' make[6]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/modules/kernel' Making all in mal make[6]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/modules/mal' make all-am make[7]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/modules/mal' make[7]: Nothing to be done for `all-am'. make[7]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/modules/mal' make[6]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/modules/mal' make[6]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/modules' make[6]: Nothing to be done for `all-am'. make[6]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/modules' make[5]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/modules' make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/modules' Making all in optimizer make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/optimizer' make all-am make[5]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/optimizer' make[5]: Nothing to be done for `all-am'. make[5]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/optimizer' make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/optimizer' Making all in scheduler make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/scheduler' make all-am make[5]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/scheduler' make[5]: Nothing to be done for `all-am'. make[5]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/scheduler' make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/scheduler' Making all in tools make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/tools' make all-am make[5]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/tools' make[5]: Nothing to be done for `all-am'. make[5]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/tools' make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/tools' Making all in extras make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/extras' make all-recursive make[5]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/extras' Making all in mal_optimizer_template make[6]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/extras/mal_optimizer_template' make all-am make[7]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/extras/mal_optimizer_template' make[7]: Nothing to be done for `all-am'. make[7]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/extras/mal_optimizer_template' make[6]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/extras/mal_optimizer_template' Making all in rapi make[6]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/extras/rapi' make all-am make[7]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/extras/rapi' make[7]: Nothing to be done for `all-am'. make[7]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/extras/rapi' make[6]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/extras/rapi' make[6]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/extras' make[6]: Nothing to be done for `all-am'. make[6]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/extras' make[5]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/extras' make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5/extras' make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5' make[4]: Nothing to be done for `all-am'. make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5' make[3]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5' make[2]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/monetdb5' Making all in sql make[2]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql' make all-recursive make[3]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql' Making all in include make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/include' make all-am make[5]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/include' make[5]: Nothing to be done for `all-am'. make[5]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/include' make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/include' Making all in common make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/common' make all-am make[5]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/common' make[5]: Nothing to be done for `all-am'. make[5]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/common' make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/common' Making all in storage make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/storage' make all-recursive make[5]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/storage' Making all in bat make[6]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/storage/bat' make all-am make[7]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/storage/bat' make[7]: Nothing to be done for `all-am'. make[7]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/storage/bat' make[6]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/storage/bat' make[6]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/storage' make[6]: Nothing to be done for `all-am'. make[6]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/storage' make[5]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/storage' make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/storage' Making all in server make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/server' make all-am make[5]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/server' make[5]: Nothing to be done for `all-am'. make[5]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/server' make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/server' Making all in backends make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends' make all-recursive make[5]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends' Making all in monet5 make[6]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5' make all-recursive make[7]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5' Making all in vaults make[8]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/vaults' make all-recursive make[9]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/vaults' make[10]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/vaults' make[10]: Nothing to be done for `all-am'. make[10]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/vaults' make[9]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/vaults' make[8]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/vaults' Making all in UDF make[8]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/UDF' make all-recursive make[9]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/UDF' Making all in cudf make[10]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/UDF/cudf' make all-am make[11]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/UDF/cudf' make[11]: Nothing to be done for `all-am'. make[11]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/UDF/cudf' make[10]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/UDF/cudf' make[10]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/UDF' make[10]: Nothing to be done for `all-am'. make[10]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/UDF' make[9]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/UDF' make[8]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/UDF' Making all in LSST make[8]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/LSST' make all-am make[9]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/LSST' make[9]: Nothing to be done for `all-am'. make[9]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/LSST' make[8]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/LSST' Making all in generator make[8]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/generator' make all-am make[9]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/generator' make[9]: Nothing to be done for `all-am'. make[9]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/generator' make[8]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5/generator' make[8]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5' make[8]: Nothing to be done for `all-am'. make[8]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5' make[7]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5' make[6]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends/monet5' make[6]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends' make[6]: Nothing to be done for `all-am'. make[6]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends' make[5]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends' make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/backends' Making all in scripts make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/scripts' make all-am make[5]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/scripts' make[5]: Nothing to be done for `all-am'. make[5]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/scripts' make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql/scripts' make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/sql' make[4]: Nothing to be done for `all-am'. make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql' make[3]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql' make[2]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/sql' Making all in tools make[2]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/tools' make all-recursive make[3]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/tools' Making all in mserver make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/tools/mserver' make all-am make[5]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/tools/mserver' make[5]: Nothing to be done for `all-am'. make[5]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/tools/mserver' make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/tools/mserver' Making all in merovingian make[4]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/tools/merovingian' make all-recursive make[5]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/tools/merovingian' Making all in utils make[6]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/tools/merovingian/utils' make all-am make[7]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/tools/merovingian/utils' make[7]: Nothing to be done for `all-am'. make[7]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/tools/merovingian/utils' make[6]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/tools/merovingian/utils' Making all in client make[6]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/tools/merovingian/client' make all-am make[7]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/tools/merovingian/client' make[7]: Nothing to be done for `all-am'. make[7]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/tools/merovingian/client' make[6]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/tools/merovingian/client' Making all in daemon make[6]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/tools/merovingian/daemon' make all-am make[7]: Entering directory `/home/dennis/MonetDB-11.27.1/buildDir/tools/merovingian/daemon' /bin/bash ../../../libtool --tag=CC --mode=link gcc -g -O2 -export-dynamic -o monetdbd merovingian.o argvcmds.o client.o connections.o controlrunner.o discoveryrunner.o forkmserver.o handlers.o multiplex-funnel.o proxy.o ../utils/libmeroutil.la ../../../common/utils/libmutils.la ../../../monetdb5/tools/libmonetdb5.la -lssl -lcrypto -pthread libtool: link: gcc -g -O2 -o .libs/monetdbd merovingian.o argvcmds.o client.o connections.o controlrunner.o discoveryrunner.o forkmserver.o handlers.o multiplex-funnel.o proxy.o -pthread -Wl,--export-dynamic ../utils/.libs/libmeroutil.a ../../../common/utils/.libs/libmutils.a ../../../monetdb5/tools/.libs/libmonetdb5.so -lssl -lcrypto -pthread /usr/bin/ld: controlrunner.o: undefined reference to symbol 'GDKinit' //home/dennis/MonetDB-11.27.1/buildDir/gdk/.libs/libbat.so.15: error adding symbols: DSO missing from command line collect2: error: ld returned 1 exit status make[7]: *** [monetdbd] Error 1 make[7]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/tools/merovingian/daemon' make[6]: *** [all] Error 2 make[6]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/tools/merovingian/daemon' make[5]: *** [all-recursive] Error 1 make[5]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/tools/merovingian' make[4]: *** [all] Error 2 make[4]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/tools/merovingian' make[3]: *** [all-recursive] Error 1 make[3]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/tools' make[2]: *** [all] Error 2 make[2]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir/tools' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/dennis/MonetDB-11.27.1/buildDir' make: *** [all] Error 2

2 1

C (or Java) API to insert blob via prep statement
by Anton Kravchenko 26 Jul '17

26 Jul '17

Is blob insertion (via prepared statement) supported by C (or Java) MonetDB API as of now?

1 0

COPY INTO doesn't recognise sorted varchar column
by Sridhar Eaturu 25 Jul '17

25 Jul '17

Hi, I imported some csv data using COPY INTO to a table. The data is sorted by the first column "sym", which is of VARCHAR type. Upon importing, the COPY INTO is not recognising the sortedness of the "sym" column. On the other hand, another test I ran with a sorted DATE column gets marked as sorted as expected. I'm using MonetDB v11.25.23 (Dec2016-SP5), and the steps demonstrating this are below. Is this expected? sql>CREATE TABLE tempquote (sym VARCHAR(3),time0 TIME,cond1 VARCHAR(1),bid INTEGER,bidqty INTEGER,ask INTEGER,askqty INTEGER,cond2 VARCHAR(1)); operation successful (2.430ms) sql>COPY INTO tempquote from 'tempquote.csv' USING DELIMITERS ',','\n' NULL AS ''; 5 affected rows (31.972ms) sql>select * from tempquote; +------+----------+-------+------+--------+------+--------+-------+ | sym | time0 | cond1 | bid | bidqty | ask | askqty | cond2 | +======+==========+=======+======+========+======+========+=======+ | ABY | 09:30:03 | F | 1489 | 50 | 1872 | 44 | I | | ACG | 09:30:00 | M | 1419 | 27 | 1542 | 43 | A | | AHK | 09:30:00 | G | 1094 | 74 | 1808 | 56 | F | | AXN | 09:30:01 | I | 1022 | 26 | 1541 | 88 | E | | BEV | 09:30:00 | L | 1377 | 38 | 1353 | 77 | M | +------+----------+-------+------+--------+------+--------+-------+ 5 tuples (1.131ms) sql>select table,column,sorted from storage() where "table"='tempquote'; +-----------+--------+--------+ | table | column | sorted | +===========+========+========+ | tempquote | sym | null | | tempquote | time0 | null | | tempquote | cond1 | null | | tempquote | bid | null | | tempquote | bidqty | null | | tempquote | ask | null | | tempquote | askqty | null | | tempquote | cond2 | null | +-----------+--------+--------+ 8 tuples (5.090ms) sql> Thanks, Sridhar

1 0

Is there any parameter to release memory? I see memory bloats on high concurrency and continuous runs
by Sharma, Sreejith 25 Jul '17

25 Jul '17

Hi, Is there any parameter or any options available for MonetDB to release the memory consumed? As one of the application I tested would run on high concurrency and may run SQL overnight. In such cases I see a memory bloat which may come up to 200gb and will never come down. Please advise? Regards, Sreejith

2 3

Troubles with the MonetDB
by 倪令斌 25 Jul '17

25 Jul '17

Dear Sir/Madam， I have encountered a problem that it has troubled me for several days and I can not continue the next job.I found it online for a long time, but I did not find a solution.Hope you can give me some inspiration: what's the matter with my PC? PS:The OS is Ubuntu16.04. Thanks a lot! Cheers, Lingbin

2 2

Copy into with DEFAULT values
by Ariel Abadi 24 Jul '17

24 Jul '17

Hi Im trying to upload a FILE into one table. The FILE has all the fields of the table, except for the last field which is the *updated *time. For that reason I have created the table with the field: "nrm_now" TIMESTAMP(0) DEFAULT current_timestamp() BUT when im trying to insert the FILE (COY INTO test_20170711 from FILE .... ), there is an error: Failed to import table 'test_20170711', Column value 143 missing Does anybody can help me? Am I doing something wrong? Which should be the best way to implement this? Thnks in advance Ariel

2 2