On Wed, Aug 24, 2016 at 09:44:53PM -0700, Anton Kravchenko wrote:
> 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).

Anton

Thank you for reporting this problem. Your test case was now added to
the nightly testing we have. Also I fixed the problem in the Jun2016
branch. So the next Service pack should include this fix.

Niels

>
>
> 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
>
>

> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list


--
Niels Nes, Manager ITF, Centrum Wiskunde & Informatica (CWI)
Science Park 123, 1098 XG Amsterdam, The Netherlands
room L3.14,  phone ++31 20 592-4098     sip:4098@sip.cwi.nl
url: https://www.cwi.nl/people/niels    e-mail: Niels.Nes@cwi.nl
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list