You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:7.0.1) Gecko/20100101 Firefox/7.0.1
Build Identifier:
Trying to create adapter in Apache Jena for MonetDB. Jena unit test "Optional - 1" is failing while connected to newly created database with a particular query.
Merovingian log shows :
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
JDBC debug log shows
RD 1319891391488: inserting prompt
TD 1319891391488: write final block: 14 bytes
TX 1319891391488: Xauto_commit 1
RD 1319891391488: read final block: 0 bytes
RX 1319891391488:
RD 1319891391488: inserting prompt
TD 1319891391502: write final block: 574 bytes
TX 1319891391502: 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 )
;
TD 1319891419345: write final block: 11 bytes
TX 1319891419345: Xrelease 11
Reproducible: Always
Steps to Reproduce:
Create Jena Schema and contents using following Dump:
START TRANSACTION;
SET SCHEMA "sys";
CREATE TABLE "sys"."prefixes" (
"prefix" VARCHAR(50) NOT NULL,
"uri" VARCHAR(500) NOT NULL,
CONSTRAINT "prefixes_prefix_pkey" PRIMARY KEY ("prefix")
);
COPY 1 RECORDS INTO "sys"."prefixes" FROM stdin USING DELIMITERS '\t','\n','"';
":" "http://example/"
CREATE TABLE "sys"."nodes" (
"hash" BIGINT NOT NULL,
"lex" CHARACTER LARGE OBJECT NOT NULL,
"lang" VARCHAR(10) NOT NULL,
"datatype" VARCHAR(200),
"type" INTEGER NOT NULL,
CONSTRAINT "nodes_hash_pkey" PRIMARY KEY ("hash")
);
COPY 13 RECORDS INTO "sys"."nodes" FROM stdin USING DELIMITERS '\t','\n','"';
-8395209716130787220 "http://example/x" "" "" 2
2004134117598721274 "http://example/p" "" "" 2
435905340492217258 "1" "" "http://www.w3.org/2001/XMLSchemainteger" 5
745852752491398227 "2" "" "http://www.w3.org/2001/XMLSchemainteger" 5
-5334307821581591471 "3" "" "http://www.w3.org/2001/XMLSchemainteger" 5
4788264553748351656 "http://example/a" "" "" 2
8936870869765386580 "http://example/b" "" "" 2
3816485599920428794 "http://example/q1" "" "" 2
-5216419694041718175 "http://example/z1" "" "" 2
-8287201118401564753 "http://example/q2" "" "" 2
7121703792433320712 "http://example/z2" "" "" 2
-4064636373028764940 "http://example/z" "" "" 2
-3401798235167296541 "abc" "" "" 3
CREATE TABLE "sys"."triples" (
"s" BIGINT NOT NULL,
"p" BIGINT NOT NULL,
"o" BIGINT NOT NULL,
CONSTRAINT "triples_s_p_o_pkey" PRIMARY KEY ("s", "p", "o")
);
CREATE INDEX "objsubj" ON "sys"."triples" ("o", "s");
CREATE INDEX "predobj" ON "sys"."triples" ("p", "o");
COPY 9 RECORDS INTO "sys"."triples" FROM stdin USING DELIMITERS '\t','\n','"';
-8395209716130787220 2004134117598721274 435905340492217258
-8395209716130787220 2004134117598721274 745852752491398227
-8395209716130787220 2004134117598721274 -5334307821581591471
-8395209716130787220 2004134117598721274 4788264553748351656
-8395209716130787220 2004134117598721274 8936870869765386580
4788264553748351656 3816485599920428794 -5216419694041718175
4788264553748351656 -8287201118401564753 7121703792433320712
8936870869765386580 3816485599920428794 -5216419694041718175
-4064636373028764940 2004134117598721274 -3401798235167296541
CREATE TABLE "sys"."quads" (
"g" BIGINT NOT NULL,
"s" BIGINT NOT NULL,
"p" BIGINT NOT NULL,
"o" BIGINT NOT NULL,
CONSTRAINT "quads_g_s_p_o_pkey" PRIMARY KEY ("g", "s", "p", "o")
);
CREATE INDEX "graobjsubj" ON "sys"."quads" ("g", "o", "s");
CREATE INDEX "grapredobj" ON "sys"."quads" ("g", "p", "o");
CREATE INDEX "objsubjpred" ON "sys"."quads" ("o", "s", "p");
CREATE INDEX "predobjsubj" ON "sys"."quads" ("p", "o", "s");
CREATE INDEX "subjpredobj" ON "sys"."quads" ("s", "p", "o");
COMMIT;
Connect with mclient or jdbc connection and issue following query
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 )
Actual Results:
Connection crash, possibly server ?
JDBC shows SQLException : java.sql.SQLException: Read from localhost:50000: End of stream reached (mserver still alive?)
Date: 2011-10-29 14:47:22 +0200
From: ultan <>
To: SQL devs <>
Version: 11.7.5 (Dec2011) [obsolete]
CC: @njnes
Last updated: 2012-03-16 14:56:56 +0100
Comment 16493
Date: 2011-10-29 14:47:22 +0200
From: ultan <>
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:7.0.1) Gecko/20100101 Firefox/7.0.1
Build Identifier:
Trying to create adapter in Apache Jena for MonetDB. Jena unit test "Optional - 1" is failing while connected to newly created database with a particular query.
Merovingian log shows :
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
JDBC debug log shows
RD 1319891391488: inserting prompt
TD 1319891391488: write final block: 14 bytes
TX 1319891391488: Xauto_commit 1
RD 1319891391488: read final block: 0 bytes
RX 1319891391488:
RD 1319891391488: inserting prompt
TD 1319891391502: write final block: 574 bytes
TX 1319891391502: 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 )
;
TD 1319891419345: write final block: 11 bytes
TX 1319891419345: Xrelease 11
Reproducible: Always
Steps to Reproduce:
START TRANSACTION;
SET SCHEMA "sys";
CREATE TABLE "sys"."prefixes" (
"prefix" VARCHAR(50) NOT NULL,
"uri" VARCHAR(500) NOT NULL,
CONSTRAINT "prefixes_prefix_pkey" PRIMARY KEY ("prefix")
);
COPY 1 RECORDS INTO "sys"."prefixes" FROM stdin USING DELIMITERS '\t','\n','"';
":" "http://example/"
CREATE TABLE "sys"."nodes" (
"hash" BIGINT NOT NULL,
"lex" CHARACTER LARGE OBJECT NOT NULL,
"lang" VARCHAR(10) NOT NULL,
"datatype" VARCHAR(200),
"type" INTEGER NOT NULL,
CONSTRAINT "nodes_hash_pkey" PRIMARY KEY ("hash")
);
COPY 13 RECORDS INTO "sys"."nodes" FROM stdin USING DELIMITERS '\t','\n','"';
-8395209716130787220 "http://example/x" "" "" 2
2004134117598721274 "http://example/p" "" "" 2
435905340492217258 "1" "" "http://www.w3.org/2001/XMLSchemainteger" 5
745852752491398227 "2" "" "http://www.w3.org/2001/XMLSchemainteger" 5
-5334307821581591471 "3" "" "http://www.w3.org/2001/XMLSchemainteger" 5
4788264553748351656 "http://example/a" "" "" 2
8936870869765386580 "http://example/b" "" "" 2
3816485599920428794 "http://example/q1" "" "" 2
-5216419694041718175 "http://example/z1" "" "" 2
-8287201118401564753 "http://example/q2" "" "" 2
7121703792433320712 "http://example/z2" "" "" 2
-4064636373028764940 "http://example/z" "" "" 2
-3401798235167296541 "abc" "" "" 3
CREATE TABLE "sys"."triples" (
"s" BIGINT NOT NULL,
"p" BIGINT NOT NULL,
"o" BIGINT NOT NULL,
CONSTRAINT "triples_s_p_o_pkey" PRIMARY KEY ("s", "p", "o")
);
CREATE INDEX "objsubj" ON "sys"."triples" ("o", "s");
CREATE INDEX "predobj" ON "sys"."triples" ("p", "o");
COPY 9 RECORDS INTO "sys"."triples" FROM stdin USING DELIMITERS '\t','\n','"';
-8395209716130787220 2004134117598721274 435905340492217258
-8395209716130787220 2004134117598721274 745852752491398227
-8395209716130787220 2004134117598721274 -5334307821581591471
-8395209716130787220 2004134117598721274 4788264553748351656
-8395209716130787220 2004134117598721274 8936870869765386580
4788264553748351656 3816485599920428794 -5216419694041718175
4788264553748351656 -8287201118401564753 7121703792433320712
8936870869765386580 3816485599920428794 -5216419694041718175
-4064636373028764940 2004134117598721274 -3401798235167296541
CREATE TABLE "sys"."quads" (
"g" BIGINT NOT NULL,
"s" BIGINT NOT NULL,
"p" BIGINT NOT NULL,
"o" BIGINT NOT NULL,
CONSTRAINT "quads_g_s_p_o_pkey" PRIMARY KEY ("g", "s", "p", "o")
);
CREATE INDEX "graobjsubj" ON "sys"."quads" ("g", "o", "s");
CREATE INDEX "grapredobj" ON "sys"."quads" ("g", "p", "o");
CREATE INDEX "objsubjpred" ON "sys"."quads" ("o", "s", "p");
CREATE INDEX "predobjsubj" ON "sys"."quads" ("p", "o", "s");
CREATE INDEX "subjpredobj" ON "sys"."quads" ("s", "p", "o");
COMMIT;
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 )
Actual Results:
Connection crash, possibly server ?
JDBC shows SQLException : java.sql.SQLException: Read from localhost:50000: End of stream reached (mserver still alive?)
Expected Results:
Statment execution, result set returned.
Comment 16646
Date: 2011-12-09 09:40:21 +0100
From: @sjoerdmullender
Changeset 6b880a8a3952 made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=6b880a8a3952
Changeset description:
Comment 16699
Date: 2011-12-27 15:28:34 +0100
From: @njnes
Changeset 57700c6efacb made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=57700c6efacb
Changeset description:
Comment 17012
Date: 2012-02-27 19:36:00 +0100
From: @njnes
test runs without problems
Comment 17103
Date: 2012-03-16 14:56:56 +0100
From: @grobian
Released in Dec2011-SP2
The text was updated successfully, but these errors were encountered: