users-list February 2020

users-list@monetdb.org

8 participants
9 discussions

by ALEX OSSIPOV

I am not able to get R part working in latest SP2 and getting this error: LoaderException:loadLibrary:Loading error failed to open lib rary rapi (from within file '/usr/lib64/monetdb5/lib_rapi.so'): libR.so: cannot open shared object file: No such file or directory I use Centos 7 package MonetDB-R.x86_64_11.35.15-20200217.el7 and wonder if it was build with --enable-R-shlib option. SP1 did not have this problem Thanks Alex

2 years, 5 months

Announcement: New Nov2019-SP2 Bugfix release of MonetDB suite

by Sjoerd Mullender

The MonetDB team at MonetDB BV is pleased to announce the Nov2019-SP2 bugfix release of the MonetDB suite of programs. More information about MonetDB can be found on our website at <https://www.monetdb.org/>. For details on this release, please see the release notes at <https://www.monetdb.org/Downloads/ReleaseNotes>. As usual, the download location is <https://www.monetdb.org/downloads/>. Nov 2019-SP2 bugfix release (11.35.15) Bug Fixes * 6805: Using the cascade operator in a drop table statement ends in an exit from the Monetdb shell. * 6807: Median_avg and quantile_avg ignore NULL values * 6815: query with ifthenelse() crashes mserver5 * 6816: Monetdb Crashes on INSERT statement after ALTER statement in another connection * 6817: running analyze on a schema which contains a stream table stops with an error * 6819: functions do not persist

2 years, 5 months

dropped functions

by ALEX OSSIPOV

I noticed every time Monetdb service is bounced all created functions disappear from database. Is it a bug or a way functions are handled in MonetDB? Thanks Alex.

2 years, 5 months

search links are broken

by ALEX OSSIPOV

All links in Search results point to localhost:8080 instead of site. Can it be fixed? Thanks Alex

2 years, 5 months

Include additional libraries

by Oxana Dolmatova

Hello, Could you tell what would be the easiest way to include additional libraries into the compilation process of MonetDB? More specifically I'm interested in calling MKL operations inside BAT Algebra operations. For example, mkl standalone operation of QR decomposition (in file mkl_qr.c all the additional headers are included) is compiled as follows: gcc -c mkl_qr.c gcc -o mkl_qr mkl_qr.o -L${MKLROOT}/lib/intel64 -Wl,--no-as-needed -lmkl_intel_ilp64 -lmkl_gnu_thread -lmkl_core -lgomp -lpthread -lm -ldl What would be the proper Makefile to edit and extend with additional libraries if I want to use MKL in batcalc.c, for example? Thank you and best regards, Oksana

2 years, 5 months

How can i change plan choice according new constraint

by DEMBELE Simon Pierre

hello, I want to know if it is possible to change how monetdb choose a plan by adding new contraints. -- Simon

2 years, 5 months

A bug occurs when query logging is enabled

by Hanfeng Chen

Hello, The bug can be reproduced on a standard TPC-H database with scale factor 1. A query returns NULL after query logging is enabled. The computer we use has Intel i7-8700K (12 cores) and 32GB RAM. Please see the details below. >> mclient -d tpch1 -t performance Welcome to mclient, the MonetDB/SQL interactive terminal (Nov2019-SP1) Database: MonetDB v11.35.9 (Nov2019-SP1), 'mapi:monetdb://tigger:50000/tpch1' FOLLOW US on https://twitter.com/MonetDB or https://github.com/MonetDB/MonetDB Type \q to quit, \? for a list of available commands auto commit mode: on sql>select sum(l_extendedprice) from lineitem; +------------------------------------------+ | L2 | +==========================================+ | 229577310901.20 | +------------------------------------------+ 1 tuple sql:0.083 opt:1.056 run:5.898 clk:7.763 ms sql>call sys.querylog_enable(); sql>select sum(l_extendedprice) from lineitem; +------------------------------------------+ | L2 | +==========================================+ | null | +------------------------------------------+ 1 tuple sql:0.095 opt:1.312 run:15.920 clk:25.033 ms Hanfeng Chen

2 years, 5 months

Re: pymonetdb issue

by alexo15＠comcast.net

That would be great Thank you Pedro Sent from Xfinity Connect App ------ Original Message ------ From: ferreira To: ALEX OSSIPOV, Communication channel for MonetDB users Sent: February 4, 2020 at 1:42 AM Subject: Re: pymonetdb issue Hello Alex, The pymonetdb developer merged a patch with IPv6 support, which will be available at pymonetdb's next release. As for the R client, it is maintained by a volunteer that has not been active in the MonetDB community lately. I can ask him for it. Beset regards, Pedro On 2/1/20 1:28 AM, ALEX OSSIPOV wrote: Hi Pedro I also found R code has the same problem. I hope it will be addressed in upcoming release as well. Thanks Alex On January 7, 2020 at 9:22 AM ferreira <pedro.ferreira(a)monetdbsolutions.com> wrote: Hello Alex, I just looked at pymonetdb source code and indeed it does not support IPv6 yet. I'm going to create an issue to request for it. The reason is because in the past, the MAPI protocol (which MonetDB uses for socket connections) didn't support IPv6, so the clients (Python, Ruby, JDBC, etc.) never had to implemented them. However they can now add this option. Best regards, Pedro On 12/22/19 5:30 AM, ALEX OSSIPOV wrote: Hi All I installed pymonetdb v 1.2.1 and trying to connect to remote server MonetDB v11.35.3 (Nov2019) listening on IPV6 only. I have got next error in python client: >>> mapi_connection.connect(hostname="<server_name>", port=xxxxx, username="monetdb", password="monetdb", database="demo", language="sql", unix_socket=None, connect_timeout=-1) Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/usr/local/lib/python3.7/site-packages/pymonetdb/mapi.py", line 143, in connect self.socket.connect((hostname, port)) socket.gaierror: [Errno -2] Name or service not known >>> My pc client is also using ipv6 to connect to MonetDB server. I also have jdbc connection that works fine. Question: Does it mean pymonetdb does not support ipv6 only environment? What would be the reason if it has nothing to do with protocol? Thanks Alex _______________________________________________ users-list mailing list users-list(a)monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

2 years, 5 months

pymonetdb issue

by ALEX OSSIPOV

Hi All I installed pymonetdb v 1.2.1 and trying to connect to remote server MonetDB v11.35.3 (Nov2019) listening on IPV6 only. I have got next error in python client: >>> mapi_connection.connect(hostname="<server_name>", port=xxxxx, username="monetdb", password="monetdb", database="demo", language="sql", unix_socket=None, connect_timeout=-1) Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/usr/local/lib/python3.7/site-packages/pymonetdb/mapi.py", line 143, in connect self.socket.connect((hostname, port)) socket.gaierror: [Errno -2] Name or service not known >>> My pc client is also using ipv6 to connect to MonetDB server. I also have jdbc connection that works fine. Question: Does it mean pymonetdb does not support ipv6 only environment? What would be the reason if it has nothing to do with protocol? Thanks Alex

2 years, 5 months

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

users-list February 2020