- users-list - monetdb.org

stethoscope tool
by Suresh Devarakonda 12 Mar '20

12 Mar '20

Thank you Sjoerd Mullender. I am able to install it. ====== Doing sudo yum install /usr/bin/stethoscope should do it. That will install the package MonetDB-client-tools. On 09/03/2020 16.11, Suresh Devarakonda wrote: > Hi, > > > > I would like to use the stethoscope tool to monitor the performance of > queries. But, I do not find the tool in the MonetDB software that I > installed on my server. Can you help me to get the stethoscope tool. > > > > [root at xxxxxx<https://www.monetdb.org/mailman/listinfo/users-list> ~]# yum list installed |grep -i monet > > MonetDB.x86_64 11.35.9-20191218.el7 @monetdb > > MonetDB-SQL-server5.x86_64 11.35.9-20191218.el7 @monetdb > > MonetDB-client.x86_64 11.35.9-20191218.el7 @monetdb > > MonetDB-client-odbc.x86_64 11.35.9-20191218.el7 @monetdb > > MonetDB-release-epel.noarch 1.3-1.monetdb installed > > MonetDB-stream.x86_64 11.35.9-20191218.el7 @monetdb > > MonetDB5-server.x86_64 11.35.9-20191218.el7 @monetdb > > > > > > > > *Suresh Devarakonda* > > *84.51* <http://www.8451.com/>*° * > > *TDO - Database Support Team* > > *D:*513.632.3692 > > *M*: 859.512.1839 > > *A: *100 W. 5^th Street, Cincinnati, Ohio 45202 > > > > Cincinnati *|* Chicago *|* New York *|* Portland > > Facebook > <https://www.facebook.com/8451group/?ref=aymt_homepage_panel> LinkedIn > <https://www.linkedin.com/company/84-51/?trk=biz-companies-cym> Instagram > <https://www.instagram.com/84.51/> Twitter > <https://twitter.com/8451group> > > Please consider the environment before printing this email. > > > > > > > _______________________________________________ > users-list mailing list > users-list at monetdb.org<https://www.monetdb.org/mailman/listinfo/users-list> > https://www.monetdb.org/mailman/listinfo/users-list > ________________________________ * Previous message (by thread): stethoscope tool<https://www.monetdb.org/pipermail/users-list/2020-March/010593.html> * Messages sorted by: [ date ]<https://www.monetdb.org/pipermail/users-list/2020-March/date.html#10594> [ thread ]<https://www.monetdb.org/pipermail/users-list/2020-March/thread.html#10594> [ subject ]<https://www.monetdb.org/pipermail/users-list/2020-March/subject.html#10594> [ author ]<https://www.monetdb.org/pipermail/users-list/2020-March/author.html#10594>

1 0

stethoscope tool
by Suresh Devarakonda 09 Mar '20

09 Mar '20

Hi, I would like to use the stethoscope tool to monitor the performance of queries. But, I do not find the tool in the MonetDB software that I installed on my server. Can you help me to get the stethoscope tool. [root@xxxxxx ~]# yum list installed |grep -i monet MonetDB.x86_64 11.35.9-20191218.el7 @monetdb MonetDB-SQL-server5.x86_64 11.35.9-20191218.el7 @monetdb MonetDB-client.x86_64 11.35.9-20191218.el7 @monetdb MonetDB-client-odbc.x86_64 11.35.9-20191218.el7 @monetdb MonetDB-release-epel.noarch 1.3-1.monetdb installed MonetDB-stream.x86_64 11.35.9-20191218.el7 @monetdb MonetDB5-server.x86_64 11.35.9-20191218.el7 @monetdb [cid:image001.jpg@01D5F602.57C58E70] Suresh Devarakonda 84.51<http://www.8451.com/>° TDO - Database Support Team D: 513.632.3692 M: 859.512.1839 A: 100 W. 5th Street, Cincinnati, Ohio 45202 Cincinnati | Chicago | New York | Portland Facebook<https://www.facebook.com/8451group/?ref=aymt_homepage_panel> LinkedIn<https://www.linkedin.com/company/84-51/?trk=biz-companies-cym> Instagram<https://www.instagram.com/84.51/> Twitter<https://twitter.com/8451group> Please consider the environment before printing this email.

2 1

SP2 R integration
by ALEX OSSIPOV 22 Feb '20

22 Feb '20

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 2

Announcement: New Nov2019-SP2 Bugfix release of MonetDB suite
by Sjoerd Mullender 21 Feb '20

21 Feb '20

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

1 0

dropped functions
by ALEX OSSIPOV 18 Feb '20

18 Feb '20

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 1

search links are broken
by ALEX OSSIPOV 17 Feb '20

17 Feb '20

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

2 1

Include additional libraries
by Oxana Dolmatova 13 Feb '20

13 Feb '20

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

1 0

How can i change plan choice according new constraint
by DEMBELE Simon Pierre 10 Feb '20

10 Feb '20

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

2 2

A bug occurs when query logging is enabled
by Hanfeng Chen 09 Feb '20

09 Feb '20

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 1

Re: pymonetdb issue
by alexo15＠comcast.net 04 Feb '20

04 Feb '20

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

1 0