Have you guys ever tested remote tables for the latest MonetDB v11.23.7 (Jun2016-SP1)?

On MacOS I have tested 'count' on remote table (as shown in my previous email) - it worked for MonetDB v11.21.17 (Jul2015-SP3) and did not for MonetDB v11.23.7 (Jun2016-SP1).


On Wed, Aug 24, 2016 at 10:28 AM, Anton Kravchenko <kravchenko.anton86@gmail.com> wrote:
Hi there,

when I run 'count' on remote table I get a segfault on worker server: 'could not find L1.L1 NOT NULL as L1 L1.L1
Segmentation fault'

Here is master(server/client) and worker (server/client), all are living on localhost (as it was shown in example https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/DistributedQueryProcessing). 

master client
[akravchenko@hnode1 ~]$ mclient -d mst
Welcome to mclient, the MonetDB/SQL interactive terminal (Jun2016-SP1)
Database: MonetDB v11.23.7 (Jun2016-SP1), 'mst'
Type \q to quit, \? for a list of available commands
auto commit mode: on
sql>CREATE REMOTE TABLE t1 (i int) on 'mapi:monetdb://localhost:50001/rt1';
operation successful (1.357ms)
sql>\d
REMOTE TABLE  sys.t1
sql>select * from t1;
+------+
| i    |
+======+
|   11 |
|   13 |
+------+
2 tuples (16.205ms)
sql>select count(*) from t1;
an error occurred on connection: Connection lost
sql>


worker client
[akravchenko@hnode1 ~]$ mclient -d rt1 -p 50001
Welcome to mclient, the MonetDB/SQL interactive terminal (Jun2016-SP1)
Database: MonetDB v11.23.7 (Jun2016-SP1), 'rt1'
Type \q to quit, \? for a list of available commands
auto commit mode: on
sql>\d
TABLE  sys.t1
sql>select count(*) from t1;
+------+
| L1   |
+======+
|    2 |
+------+
1 tuple (0.594ms)

worker server
[akravchenko@hnode1 ~]$ mserver5 --dbpath=rt1 --set mapi_port=50001
# MonetDB 5 server v11.23.7 "Jun2016-SP1"
# Serving database 'rt1', using 4 threads
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs and 128bit integers dynamically linked
# Found 31.357 GiB available main-memory.
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2016 MonetDB B.V., all rights reserved
# Visit http://www.monetdb.org/ for further information
# Listening for connection requests on mapi:monetdb://127.0.0.1:50001/
# MonetDB/SQL module loaded
>could not find L1.L1 NOT NULL as L1
L1.L1
Segmentation fault

master server
[akravchenko@hnode1 ~]$ mserver5 --dbpath=mst
# MonetDB 5 server v11.23.7 "Jun2016-SP1"
# Serving database 'mst', using 4 threads
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs and 128bit integers dynamically linked
# Found 31.357 GiB available main-memory.
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2016 MonetDB B.V., all rights reserved
# Visit http://www.monetdb.org/ for further information
# Listening for connection requests on mapi:monetdb://127.0.0.1:50000/
# MonetDB/SQL module loaded

Thank you,
Anton