[MonetDB-users] eEnd of Stream

nat lu natlu2809 at gmail.com
Fri Oct 28 10:30:10 CEST 2011


And heres JDBC debug log from that time if its any help

    RD 1319745225847: read final block: 33 bytes
    RX 1319745225847: void:merovingian:8:md5,plain:LIT:
    RD 1319745225847: inserting prompt
    TD 1319745225847: write final block: 50 bytes
    TX 1319745225847: BIG:merovingian:{plain}merovingianvoid:sql:TEST2H:
    RD 1319745225847: read final block: 42 bytes
    RX 1319745225848: ^mapi:merovingian://proxy?database=TEST2H

    RD 1319745225848: inserting prompt
    RD 1319745225848: read final block: 57 bytes
    RX 1319745225848:
    hzk40Q5Zr:mserver:9:RIPEMD160,SHA256,SHA1,MD5:LIT:SHA512:
    RD 1319745225848: inserting prompt
    TD 1319745225848: write final block: 96 bytes
    TX 1319745225848:
    BIG:monetdb:{SHA256}c7885da1d35daa15452371326b54a9a0d0e1d6bb6dd41e1ce886f070a9e62043:sql:TEST2H:
    RD 1319745225849: read final block: 0 bytes
    RX 1319745225849:
    RD 1319745225849: inserting prompt
    TD 1319745225849: write final block: 48 bytes
    TX 1319745225849: sSET TIME ZONE INTERVAL '+01:00' HOUR TO MINUTE;
    RD 1319745225850: read final block: 0 bytes
    RX 1319745225850:
    RD 1319745225850: inserting prompt
    TD 1319745225850: write final block: 15 bytes
    TX 1319745225850: Xreply_size 250
    RD 1319745225851: read final block: 0 bytes
    RX 1319745225851:
    RD 1319745225851: inserting prompt
    TD 1319745225851: write final block: 22 bytes
    TX 1319745225851: sDELETE FROM Prefixes;
    RD 1319745225860: read final block: 8 bytes
    RX 1319745225860: &2 1 -1

    RD 1319745225860: inserting prompt
    TD 1319745225860: write final block: 19 bytes
    TX 1319745225860: sDELETE FROM Nodes;
    RD 1319745225869: read final block: 9 bytes
    RX 1319745225869: &2 15 -1

    RD 1319745225869: inserting prompt
    TD 1319745225869: write final block: 21 bytes
    TX 1319745225869: sDELETE FROM Triples;
    RD 1319745225877: read final block: 9 bytes
    RX 1319745225877: &2 13 -1

    RD 1319745225877: inserting prompt
    TD 1319745225877: write final block: 19 bytes
    TX 1319745225877: sDELETE FROM Quads;
    RD 1319745225885: read final block: 8 bytes
    RX 1319745225885: &2 0 -1

    RD 1319745225885: inserting prompt
    TD 1319745225886: write final block: 14 bytes
    TX 1319745225886: Xauto_commit 0
    RD 1319745225886: read final block: 0 bytes
    RX 1319745225886:
    RD 1319745225886: inserting prompt
    TD 1319745225886: write final block: 34 bytes
    TX 1319745225886: sSELECT prefix, uri FROM Prefixes;
    RD 1319745225888: read final block: 116 bytes
    RX 1319745225888: &1 0 0 2 0
    % sys.prefixes,    sys.prefixes # table_name
    % prefix,    uri # name
    % varchar,    varchar # type
    % 0,    0 # length

    RD 1319745225888: inserting prompt
    TD 1319745225892: write final block: 47 bytes
    TX 1319745225892: sSELECT uri FROM Prefixes
        WHERE prefix = '';
    RD 1319745225893: read final block: 82 bytes
    RX 1319745225894: &1 1 0 1 0
    % sys.prefixes # table_name
    % uri # name
    % varchar # type
    % 0 # length

    RD 1319745225894: inserting prompt
    TD 1319745225894: write final block: 57 bytes
    TX 1319745225894: sINSERT INTO Prefixes
        VALUES (':', 'http://example/');
    RD 1319745225895: read final block: 8 bytes
    RX 1319745225896: &2 1 -1

    RD 1319745225896: inserting prompt
    TD 1319745227160: write final block: 130 bytes
    TX 1319745227160: sCREATE LOCAL TEMPORARY TABLE NNodeTriples
    (n0 BIGINT ,
    n1 VARCHAR (32672) ,
    n2 VARCHAR(1024) ,
    n3 VARCHAR(1024) ,
    n4 INT
    ) ;
    RD 1319745227161: read final block: 3 bytes
    RX 1319745227161: &3

    RD 1319745227161: inserting prompt
    TD 1319745228330: write final block: 80 bytes
    TX 1319745228330: sCREATE LOCAL TEMPORARY TABLE NTriples
    (t0 BIGINT ,
    t1 BIGINT ,
    t2 BIGINT
    ) ;
    RD 1319745228331: read final block: 3 bytes
    RX 1319745228331: &3

    RD 1319745228331: inserting prompt
    TD 1319745228333: write final block: 62 bytes
    TX 1319745228333: sPREPARE INSERT INTO NNodeTriples VALUES (? , ? ,
    ? , ? , ? );
    RD 1319745228334: read final block: 238 bytes
    RX 1319745228334: &5 10 5 3 5
    % .prepare,    .prepare,    .prepare # table_name
    % type,    digits,    scale # name
    % varchar,    int,    int # type
    % 0,    0,    0 # length
    [ "bigint",    64,    0    ]
    [ "varchar",    32672,    0    ]
    [ "varchar",    1024,    0    ]
    [ "varchar",    1024,    0    ]
    [ "int",    32,    0    ]

    RD 1319745228334: inserting prompt
    TD 1319745228336: write final block: 50 bytes
    TX 1319745228336: sPREPARE INSERT INTO NTriples VALUES (? , ? , ? );
    RD 1319745228337: read final block: 191 bytes
    RX 1319745228337: &5 11 3 3 3
    % .prepare,    .prepare,    .prepare # table_name
    % type,    digits,    scale # name
    % varchar,    int,    int # type
    % 0,    0,    0 # length
    [ "bigint",    64,    0    ]
    [ "bigint",    64,    0    ]
    [ "bigint",    64,    0    ]

    RD 1319745228338: inserting prompt
    TD 1319745228339: write final block: 62 bytes
    TX 1319745228339: sPREPARE DELETE FROM Triples
    WHERE
    s = ? AND
    p = ? AND
    o = ?;
    RD 1319745228341: read final block: 191 bytes
    RX 1319745228341: &5 12 3 3 3
    % .prepare,    .prepare,    .prepare # table_name
    % type,    digits,    scale # name
    % varchar,    int,    int # type
    % 0,    0,    0 # length
    [ "bigint",    64,    0    ]
    [ "bigint",    64,    0    ]
    [ "bigint",    64,    0    ]

    RD 1319745228341: inserting prompt
    TD 1319745228342: write final block: 29 bytes
    TX 1319745228342: sPREPARE DELETE FROM Triples;
    RD 1319745228343: read final block: 131 bytes
    RX 1319745228343: &5 13 0 3 0
    % .prepare,    .prepare,    .prepare # table_name
    % type,    digits,    scale # name
    % varchar,    int,    int # type
    % 0,    0,    0 # length

    RD 1319745228343: inserting prompt
    TD 1319745228344: write final block: 34 bytes
    TX 1319745228344: sPREPARE DELETE FROM NNodeTriples;
    RD 1319745228344: read final block: 131 bytes
    RX 1319745228345: &5 14 0 3 0
    % .prepare,    .prepare,    .prepare # table_name
    % type,    digits,    scale # name
    % varchar,    int,    int # type
    % 0,    0,    0 # length

    RD 1319745228345: inserting prompt
    TD 1319745228346: write final block: 30 bytes
    TX 1319745228346: sPREPARE DELETE FROM NTriples;
    RD 1319745228346: read final block: 131 bytes
    RX 1319745228346: &5 15 0 3 0
    % .prepare,    .prepare,    .prepare # table_name
    % type,    digits,    scale # name
    % varchar,    int,    int # type
    % 0,    0,    0 # length

    RD 1319745228346: inserting prompt
    TD 1319745228353: write final block: 863 bytes
    TX 1319745228353: sexec 10(-8395209716130787220, 'http://example/x',
    '', '', 2);
    exec 10(2004134117598721274, 'http://example/p', '', '', 2);
    exec 10(435905340492217258, '1', '',
    'http://www.w3.org/2001/XMLSchema#integer', 5);
    exec 10(745852752491398227, '2', '',
    'http://www.w3.org/2001/XMLSchema#integer', 5);
    exec 10(-5334307821581591471, '3', '',
    'http://www.w3.org/2001/XMLSchema#integer', 5);
    exec 10(4788264553748351656, 'http://example/a', '', '', 2);
    exec 10(8936870869765386580, 'http://example/b', '', '', 2);
    exec 10(3816485599920428794, 'http://example/q1', '', '', 2);
    exec 10(-5216419694041718175, 'http://example/z1', '', '', 2);
    exec 10(-8287201118401564753, 'http://example/q2', '', '', 2);
    exec 10(7121703792433320712, 'http://example/z2', '', '', 2);
    exec 10(-4064636373028764940, 'http://example/z', '', '', 2);
    exec 10(-3401798235167296541, 'abc', '', '', 3);
    RD 1319745228354: read final block: 104 bytes
    RX 1319745228354: &2 1 -1
    &2 1 -1
    &2 1 -1
    &2 1 -1
    &2 1 -1
    &2 1 -1
    &2 1 -1
    &2 1 -1
    &2 1 -1
    &2 1 -1
    &2 1 -1
    &2 1 -1
    &2 1 -1

    RD 1319745228354: inserting prompt
    TD 1319745228354: write final block: 657 bytes
    TX 1319745228354: sexec 11(-8395209716130787220,
    2004134117598721274, 435905340492217258);
    exec 11(-8395209716130787220, 2004134117598721274, 745852752491398227);
    exec 11(-8395209716130787220, 2004134117598721274,
    -5334307821581591471);
    exec 11(-8395209716130787220, 2004134117598721274, 4788264553748351656);
    exec 11(-8395209716130787220, 2004134117598721274, 8936870869765386580);
    exec 11(4788264553748351656, 3816485599920428794, -5216419694041718175);
    exec 11(4788264553748351656, -8287201118401564753, 7121703792433320712);
    exec 11(8936870869765386580, 3816485599920428794, -5216419694041718175);
    exec 11(-4064636373028764940, 2004134117598721274,
    -3401798235167296541);
    RD 1319745228355: read final block: 72 bytes
    RX 1319745228355: &2 1 -1
    &2 1 -1
    &2 1 -1
    &2 1 -1
    &2 1 -1
    &2 1 -1
    &2 1 -1
    &2 1 -1
    &2 1 -1

    RD 1319745228355: inserting prompt
    TD 1319745228355: write final block: 241 bytes
    TX 1319745228355: sINSERT INTO Nodes (hash, lex, lang, datatype, type)
    SELECT NNodeTriples.n0 , NNodeTriples.n1 , NNodeTriples.n2 ,
    NNodeTriples.n3 , NNodeTriples.n4
    FROM NNodeTriples LEFT JOIN Nodes ON (NNodeTriples.n0=Nodes.hash)
    WHERE Nodes.hash IS NULL;
    RD 1319745228360: read final block: 9 bytes
    RX 1319745228360: &2 13 -1

    RD 1319745228360: inserting prompt
    TD 1319745228360: write final block: 230 bytes
    TX 1319745228360: sINSERT INTO Triples
    SELECT DISTINCT NTriples.t0 , NTriples.t1 , NTriples.t2
    FROM NTriples LEFT JOIN Triples ON
      (t0=Triples.s AND t1=Triples.p AND t2=Triples.o)
    WHERE
    Triples.s IS NULL OR
    Triples.p IS NULL OR
    Triples.o IS NULL;
    RD 1319745228369: read final block: 8 bytes
    RX 1319745228369: &2 9 -1

    RD 1319745228369: inserting prompt
    TD 1319745228369: write final block: 11 bytes
    TX 1319745228369: sexec 14();
    RD 1319745228369: read final block: 9 bytes
    RX 1319745228369: &2 13 -1

    RD 1319745228369: inserting prompt
    TD 1319745228369: write final block: 11 bytes
    TX 1319745228369: sexec 15();
    RD 1319745228369: read final block: 8 bytes
    RX 1319745228369: &2 9 -1

    RD 1319745228369: inserting prompt
    TD 1319745228369: write final block: 8 bytes
    TX 1319745228369: sCOMMIT;
    RD 1319745228390: read final block: 5 bytes
    RX 1319745228390: &4 f

    RD 1319745228390: inserting prompt
    TD 1319745228390: write final block: 14 bytes
    TX 1319745228390: Xauto_commit 1
    RD 1319745228390: read final block: 0 bytes
    RX 1319745228390:
    RD 1319745228390: inserting prompt
    TD 1319745228404: write final block: 574 bytes
    TX 1319745228404: sSELECT 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 )
    ;


On 28/10/11 09:13, nat lu wrote:
> 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 at 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 at 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 at 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 at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/monetdb-users
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20111028/39200aae/attachment.html>


More information about the users-list mailing list