Thanks Martin -

This is what I have in the log, not very informative I think. Last few lines would be when I shut the machine down I presume, everything else appears consistent.

2011-10-27 20:53:36 MSG TEST2H[8527]: arguments: /usr/bin/mserver5 --set gdk_dbfarm=/home/ultan/my-farm --dbname=TEST2H --set merovingian_uri=mapi:monetdb://boxer:50000/TEST2H --set mapi_open=false --set mapi_port=0 --set mapi_usock=/home/ultan/my-farm/TEST2H/.mapi.sock --set monet_vault_key=/home/ultan/my-farm/TEST2H/.vaultkey --set monet_daemon=yes
2011-10-27 20:53:36 MSG TEST2H[8527]: # MonetDB 5 server v11.5.3 "Aug2011-SP1"
2011-10-27 20:53:36 MSG TEST2H[8527]: # Serving database 'TEST2H', using 8 threads
2011-10-27 20:53:36 MSG TEST2H[8527]: # Compiled for i686-pc-linux-gnu/32bit with 32bit OIDs dynamically linked
2011-10-27 20:53:36 MSG TEST2H[8527]: # Found 3.875 GiB available main-memory.
2011-10-27 20:53:36 MSG TEST2H[8527]: # Copyright (c) 1993-July 2008 CWI.
2011-10-27 20:53:36 MSG TEST2H[8527]: # Copyright (c) August 2008-2011 MonetDB B.V., all rights reserved
2011-10-27 20:53:36 MSG TEST2H[8527]: # Visit http://www.monetdb.org/ for further information
2011-10-27 20:53:36 MSG TEST2H[8527]: # Listening for UNIX domain connection requests on mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock
2011-10-27 20:53:36 MSG TEST2H[8527]: # MonetDB/SQL module loaded
2011-10-27 20:53:41 MSG merovingian[7189]: proxying client localhost.localdomain:55739 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:41 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:41 MSG merovingian[7189]: proxying client localhost.localdomain:55740 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:41 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:41 MSG merovingian[7189]: proxying client localhost.localdomain:55741 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:41 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:41 MSG merovingian[7189]: proxying client localhost.localdomain:55742 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:41 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:41 MSG merovingian[7189]: proxying client localhost.localdomain:55743 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:41 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:41 MSG merovingian[7189]: proxying client localhost.localdomain:55744 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:41 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:41 MSG merovingian[7189]: proxying client localhost.localdomain:55745 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:41 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:41 MSG merovingian[7189]: proxying client localhost.localdomain:55746 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:41 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:41 MSG merovingian[7189]: proxying client localhost.localdomain:55747 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:41 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:41 MSG merovingian[7189]: proxying client localhost.localdomain:55748 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:41 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:41 MSG merovingian[7189]: proxying client localhost.localdomain:55749 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:41 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:41 MSG merovingian[7189]: proxying client localhost.localdomain:55750 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:41 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:41 MSG merovingian[7189]: proxying client localhost.localdomain:55751 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:41 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:41 MSG merovingian[7189]: proxying client localhost.localdomain:55752 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:41 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:41 MSG merovingian[7189]: proxying client localhost.localdomain:55753 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:41 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:41 MSG merovingian[7189]: proxying client localhost.localdomain:55754 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:41 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:41 MSG merovingian[7189]: proxying client localhost.localdomain:55755 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:41 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:43 MSG merovingian[7189]: proxying client localhost.localdomain:55756 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:43 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:43 MSG merovingian[7189]: proxying client localhost.localdomain:55757 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:43 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:43 MSG merovingian[7189]: proxying client localhost.localdomain:55758 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:43 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:43 MSG merovingian[7189]: proxying client localhost.localdomain:55759 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:43 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:43 MSG merovingian[7189]: proxying client localhost.localdomain:55760 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:43 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:45 MSG merovingian[7189]: proxying client localhost.localdomain:55761 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:45 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:45 MSG merovingian[7189]: proxying client localhost.localdomain:55762 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:45 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:45 MSG merovingian[7189]: proxying client localhost.localdomain:55763 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:45 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:45 MSG merovingian[7189]: proxying client localhost.localdomain:55764 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:45 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:45 MSG merovingian[7189]: proxying client localhost.localdomain:55765 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:45 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:45 MSG merovingian[7189]: proxying client localhost.localdomain:55766 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:45 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:45 MSG merovingian[7189]: proxying client localhost.localdomain:55767 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:45 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:45 MSG merovingian[7189]: proxying client localhost.localdomain:55768 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:45 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:45 MSG merovingian[7189]: proxying client localhost.localdomain:55769 for database 'TEST2H' to mapi:monetdb:///home/ultan/my-farm/TEST2H/.mapi.sock?database=TEST2H
2011-10-27 20:53:45 MSG merovingian[7189]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2011-10-27 20:53:48 MSG merovingian[7189]: database 'TEST2H' (8527) was killed by signal SIGSEGV
2011-10-27 21:00:59 MSG merovingian[7189]: caught SIGTERM, starting shutdown sequence
2011-10-27 21:00:59 MSG control[7189]: control channel closed
2011-10-27 21:00:59 ERR discovery[7189]: error while sending broadcast message: Network is unreachable
2011-10-27 21:00:59 MSG merovingian[7189]: Merovingian 1.5 stopped


On 27/10/11 21:04, Martin Kersten wrote: 
On 10/27/11 9:59 PM, nat lu wrote:

I'm using Monet 11.5 on Ubuntu 11.04.

Ive created a database and am attempting to run a series of queries against it with a test script. This is in attempt to use Monet with Apache Jena. I had earlier mailed about a problem with temp tables, but have dodged that by using the monetdb account
for now.

The first few succeed, but then I get the following error:

    java.sql.SQLException: Read from localhost:50000: End of stream reached (mserver still alive?)

Can you check the tail of the merovingian.log file in the dbfarm?
It may report on issues encountered during the request. (Please note the time stamp)



Why does this happen, under what circumstances does it arise ? Is there anything I can do to avoid it ?


This is the query that it fails on:

    SELECT R_1.lex AS V_1_lex, R_1.datatype AS V_1_datatype, R_1.lang AS V_1_lang, R_1.type AS V_1_type,
    R_2.lex AS V_2_lex, R_2.datatype AS V_2_datatype, R_2.lang AS V_2_lang, R_2.type AS V_2_type
    FROM
    ( SELECT T_1.s AS X_1
    FROM Triples AS T_1
    WHERE ( T_1.p = 2004134117598721274
    AND T_1.o = 435905340492217258 )
    ) AS T_1
    LEFT OUTER JOIN
    Triples AS T_2
    ON ( T_2.p = 3816485599920428794
    AND T_1.X_1 = T_2.s )
    LEFT OUTER JOIN
    Nodes AS R_1
    ON ( T_1.X_1 = R_1.hash )
    LEFT OUTER JOIN
    Nodes AS R_2
    ON ( T_2.o = R_2.hash )





------------------------------------------------------------------------------
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning@Cisco Self-Assessment and learn
about Cisco certifications, training, and career opportunities.
http://p.sf.net/sfu/cisco-dev2dev



_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users


------------------------------------------------------------------------------
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning@Cisco Self-Assessment and learn 
about Cisco certifications, training, and career opportunities. 
http://p.sf.net/sfu/cisco-dev2dev
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users