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/…
[View More]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
[View Less]
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 …
[View More]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
[View Less]
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/…
[View More]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
[View Less]
