April 2016 - developers-list

Monetdb Python Issue
by Patel, Nikunj (CONT) 26 Apr '16

26 Apr '16

Hi, I have created a simple table (create table dept (dept_id integer, dept_nm varchar(25)) and trying to insert records from file using Python and getting errors. All execute statements gives me same error message: connection = monetdb.sql.connect(username="monetdb", password="monetdb", hostname="10.81.102.71", port=2234, database="demo") cursor = connection.cursor() cursor.execute("COPY INTO dept FROM 'C:\AWS\did.csv' USING DELIMITERS;") cursor.execute("COPY INTO dept FROM 'C:\AWS\did.csv' USING DELIMITERS") cursor.execute("COPY INTO dept FROM STDIN;\n44444444,'AL'\n55555555,'JAFFRI'") Traceback (most recent call last): File "<stdin>", line 1, in <module> File "C:\Users\Q1\AppData\Local\Continuum\Anaconda2\lib\site-packages\monetdb\sql\cursors.py", line 175, in execute block = self.connection.execute(query) File "C:\Users\Q1\AppData\Local\Continuum\Anaconda2\lib\site-packages\monetdb\sql\connections.py", line 138, in execute return self.command('s' + query + ';') File "C:\Users\Q1\AppData\Local\Continuum\Anaconda2\lib\site-packages\monetdb\sql\connections.py", line 143, in command return self.mapi.cmd(command) File "C:\Users\Q1\AppData\Local\Continuum\Anaconda2\lib\site-packages\monetdb\mapi.py", line 202, in cmd raise OperationalError(response[1:])monetdb.exceptions.OperationalError: 25005!current transaction is aborted (please ROLLBACK) Thanks, --------------------- Nik Patel ________________________________________________________ The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.

1 0

Announcement: New Jul2015-SP4 Bugfix release of MonetDB suite
by Sjoerd Mullender 11 Apr '16

11 Apr '16

The MonetDB team at CWI/MonetDB BV is pleased to announce the Jul2015-SP4 bugfix release of the MonetDB suite of programs. More information about MonetDB can be found on our website at <http://www.monetdb.org/>. For details on this release, please see the release notes at <http://www.monetdb.org/Downloads/ReleaseNotes>. As usual, the download location is <http://dev.monetdb.org/downloads/>. Jul 2015-SP4 bugfix release MonetDB Common * Fixed a bug that caused various instances where old data returned or where crashes occurred. The problem was that internally data wasn't always marked dirty when it was being changed, causing later processing to not deal with the changed data correctly. Bug Fixes * 3905: MonetDB doesn't handle ANY/SOME/ALL operator correctly * 3929: R aggregate not recognized when using 3 or more parameters * 3965: Not possible to quote/escape single quote character in the name of the file to load. * 3968: Missing double use of column names

1 0

undefined reference to `pcre_config'
by John Krulick 05 Apr '16

05 Apr '16

Hi, I'm trying to build MonetDB from source and running into an error during configure. Running ./configure gives: ... ... checking for SHA256... yes checking for SHA384... yes checking for SHA512... yes checking for pcre... yes checking whether pcre comes with UTF-8 support... no configure: error: PCRE library not found but required for MonetDB5 At the bottom of the email is the error in the config.log. pcretest -C gives me: PCRE version 8.38 2015-11-23 Compiled with:q 8-bit support UTF-8 support Unicode properties support No just-in-time compiler support Newline sequence is LF \R matches all Unicode newlines Internal link size = 2 POSIX malloc threshold = 10 Parentheses nest limit = 250 Default match limit = 10000000 Default recursion depth limit = 10000000 Match recursion uses stack The issue, I think, is I have PCRE version 8.38 built in a non-standard location, /home/john/monetdb_prereq/pcre export pcre_LIBS=-L/home/john/monetdb_prereq/pcre/lib export pcre_CFLAGS=-I/home/john/monetdb_prereq/pcre/include Any idea what I'm missing? Thanks, John configure:20861: checking for SHA512 configure:20861: gcc -o conftest -g -O2 conftest.c -lssl -lcrypto -ldl -lz >&5 configure:20861: $? = 0 configure:20861: result: yes configure:20901: checking for pcre configure:20966: result: yes configure:20971: checking whether pcre comes with UTF-8 support configure:20992: gcc -o conftest -g -O2 -I/home/john/monetdb_prereq/pcre/include conftest.c -L/home/john/monetdb_prereq/pcre/lib >&5 /tmp/ccRjfKcQ.o: In function `main': /home/john/MonetDB-11.21.17/conftest.c:66: undefined reference to `pcre_config' collect2: ld returned 1 exit status configure:20992: $? = 1 configure: program exited with status 1 configure: failed program was: | /* confdefs.h */ | #define PACKAGE_NAME "MonetDB" | #define PACKAGE_TARNAME "MonetDB" | #define PACKAGE_VERSION "11.21.17" | #define PACKAGE_STRING "MonetDB 11.21.17" | #define PACKAGE_BUGREPORT "info(a)monetdb.org" | #define PACKAGE_URL "http://www.monetdb.org/" | #define PACKAGE "MonetDB" | #define VERSION "11.21.17" | #define HOST "x86_64-unknown-linux-gnu" | #define MONETDB_RELEASE "Jul2015-SP3" | #define HAVE_CONSOLE 1 | #define MONETDB5_PASSWDHASH "SHA512" | #define STDC_HEADERS 1 | #define HAVE_SYS_TYPES_H 1 | #define HAVE_SYS_STAT_H 1 | #define HAVE_STDLIB_H 1 | #define HAVE_STRING_H 1 | #define HAVE_MEMORY_H 1 | #define HAVE_STRINGS_H 1 | #define HAVE_INTTYPES_H 1 | #define HAVE_STDINT_H 1 | #define HAVE_UNISTD_H 1 | #define __EXTENSIONS__ 1 | #define _ALL_SOURCE 1 | #define _GNU_SOURCE 1 | #define _POSIX_PTHREAD_SEMANTICS 1 | #define _TANDEM_SOURCE 1 | #define SIZEOF_LONG 8 | #define HAVE_DLFCN_H 1 | #define LT_OBJDIR ".libs/" | #define NDEBUG 1 | #define DIFF "diff" | #define DIR_SEP '/' | #define DIR_SEP_STR "/" | #define PATH_SEP ':' | #define PATH_SEP_STR ":" | #define SO_PREFIX "lib" | #define SO_EXT ".so" | #define HAVE_LIBBZ2 1 | #define HAVE_MALLOPT 1 | #define HAVE_PTHREAD_H 1 | #define HAVE_SEMAPHORE_H 1 | #define HAVE_SCHED_H 1 | #define HAVE_PTHREAD_KILL 1 | #define HAVE_PTHREAD_SIGMASK 1 | #define HAVE_PTHREAD_SETSCHEDPRIO 1 | #define HAVE_LIBPTHREAD 1 | #define HAVE_LIBREADLINE 1 | #define HAVE_ICONV 1 | #define ICONV_CONST | #define HAVE_UUID 1 | #define HAVE_MD5 1 | #define HAVE_RIPEMD160 1 | #define HAVE_SHA1 1 | #define HAVE_SHA224 1 | #define HAVE_SHA256 1 | #define HAVE_SHA384 1 | #define HAVE_SHA512 1 | #define HAVE_OPENSSL 1 | /* end confdefs.h. */ | #include <pcre.h> | int | main () | { | int rc; pcre_config(PCRE_CONFIG_UTF8, &rc); exit(!rc); | ; | return 0; | } configure:20996: result: no configure:21021: error: PCRE library not found but required for MonetDB5

2 2