[MonetDB-users] "ERROR = !Connection terminated" for some SQL queries
Hi, the following query results in a "Connection terminated error": SELECT count(*) FROM ( SELECT DISTINCT node1.id AS id1, node2.id AS id2, node1.toplevel_corpus FROM node AS node1, rank AS rank1, component AS component1, node AS node2, rank AS rank2, component AS component2 WHERE component1.id = component2.id AND component1.name IS NULL AND component1.type = 'd' AND component2.name IS NULL AND component2.type = 'd' AND rank1.component_ref = component1.id AND rank1.node_ref = node1.id AND rank1.pre = rank2.parent AND rank2.component_ref = component2.id AND rank2.node_ref = node2.id ) AS solutions; The full error message is: MAPI = annis@moos.local:50000 ACTION= read_line QUERY = SELECT count(*) FROM ( SELECT DISTINCT node1.id AS id1, node2.id AS id2, node1.toplevel_corpus FROM node AS node1, rank AS rank1, component AS component1, node AS node2, rank AS rank2, component AS component2 WHERE component1.id = component2.id AND component1.name IS NULL AND component1.type = 'd' AND component2.name IS NULL AND component2.type = 'd' AND rank1.component_ref = component1.id AND rank1.node_ref = node1.id AND rank1.pre = rank2.parent AND rank2.component_ref = component2.id AND rank2.node_ref = node2.id ) AS solutions; ERROR = !Connection terminated I can get it to run if I remove the following line: component1.id = component2.id AND or if I remove the following 4 lines: component1.name IS NULL AND component1.type = 'd' AND component2.name IS NULL AND component2.type = 'd' AND However, if I include all constraints on component, the error appears. Let me know, if you need more information. Cheers, Viktor
Viktor, a server crash is always a bug; hence, please file a bug report. If possible, include any of the following information: Does the server also crash when you run the query in empty tables, then please include your relevant create table statements. Can you run mserver5 (preferably not configured with --disable-debug --enable-optimize) in a debugger? If so, please attach a back-trace of the crash, including prints of all variables/arguments related to the statement where the crash occurs. Could you re-configure and re-build your MonetDB with --enable-assert and check whether you get an assertion (if so, which?)? Thanks! Stefan On Fri, Feb 24, 2012 at 11:32:35AM +0100, Viktor Rosenfeld wrote:
Hi,
the following query results in a "Connection terminated error":
SELECT count(*) FROM ( SELECT DISTINCT node1.id AS id1, node2.id AS id2, node1.toplevel_corpus FROM node AS node1, rank AS rank1, component AS component1, node AS node2, rank AS rank2, component AS component2 WHERE component1.id = component2.id AND component1.name IS NULL AND component1.type = 'd' AND component2.name IS NULL AND component2.type = 'd' AND rank1.component_ref = component1.id AND rank1.node_ref = node1.id AND rank1.pre = rank2.parent AND rank2.component_ref = component2.id AND rank2.node_ref = node2.id ) AS solutions;
The full error message is:
MAPI = annis@moos.local:50000 ACTION= read_line QUERY = SELECT count(*) FROM ( SELECT DISTINCT node1.id AS id1, node2.id AS id2, node1.toplevel_corpus FROM node AS node1, rank AS rank1, component AS component1, node AS node2, rank AS rank2, component AS component2 WHERE component1.id = component2.id AND component1.name IS NULL AND component1.type = 'd' AND component2.name IS NULL AND component2.type = 'd' AND rank1.component_ref = component1.id AND rank1.node_ref = node1.id AND rank1.pre = rank2.parent AND rank2.component_ref = component2.id AND rank2.node_ref = node2.id ) AS solutions; ERROR = !Connection terminated
I can get it to run if I remove the following line:
component1.id = component2.id AND
or if I remove the following 4 lines:
component1.name IS NULL AND component1.type = 'd' AND component2.name IS NULL AND component2.type = 'd' AND
However, if I include all constraints on component, the error appears.
Let me know, if you need more information.
Cheers, Viktor
------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
Hi Stefan, I've filed a bug report: http://bugs.monetdb.org/show_bug.cgi?id=3046. Sorry for not getting back earlier. The server also crashes on empty tables. I've included the SQL to create the tables and also a backtrace of the crash. I don't know how to create prints of variables or arguments, although the values of some arguments are visible in the backtrace. There appears to be no assertion or any output in merovingian.log. I've used --enable-debug --disable-optimize --enable-assert as options to configure. Cheers, Viktor Stefan Manegold wrote:
Viktor,
a server crash is always a bug; hence, please file a bug report.
If possible, include any of the following information:
Does the server also crash when you run the query in empty tables, then please include your relevant create table statements.
Can you run mserver5 (preferably not configured with --disable-debug --enable-optimize) in a debugger? If so, please attach a back-trace of the crash, including prints of all variables/arguments related to the statement where the crash occurs.
Could you re-configure and re-build your MonetDB with --enable-assert and check whether you get an assertion (if so, which?)?
Thanks! Stefan
On Fri, Feb 24, 2012 at 11:32:35AM +0100, Viktor Rosenfeld wrote:
Hi,
the following query results in a "Connection terminated error":
SELECT count(*) FROM ( SELECT DISTINCT node1.id AS id1, node2.id AS id2, node1.toplevel_corpus FROM node AS node1, rank AS rank1, component AS component1, node AS node2, rank AS rank2, component AS component2 WHERE component1.id = component2.id AND component1.name IS NULL AND component1.type = 'd' AND component2.name IS NULL AND component2.type = 'd' AND rank1.component_ref = component1.id AND rank1.node_ref = node1.id AND rank1.pre = rank2.parent AND rank2.component_ref = component2.id AND rank2.node_ref = node2.id ) AS solutions;
The full error message is:
MAPI = annis@moos.local:50000 ACTION= read_line QUERY = SELECT count(*) FROM ( SELECT DISTINCT node1.id AS id1, node2.id AS id2, node1.toplevel_corpus FROM node AS node1, rank AS rank1, component AS component1, node AS node2, rank AS rank2, component AS component2 WHERE component1.id = component2.id AND component1.name IS NULL AND component1.type = 'd' AND component2.name IS NULL AND component2.type = 'd' AND rank1.component_ref = component1.id AND rank1.node_ref = node1.id AND rank1.pre = rank2.parent AND rank2.component_ref = component2.id AND rank2.node_ref = node2.id ) AS solutions; ERROR = !Connection terminated
I can get it to run if I remove the following line:
component1.id = component2.id AND
or if I remove the following 4 lines:
component1.name IS NULL AND component1.type = 'd' AND component2.name IS NULL AND component2.type = 'd' AND
However, if I include all constraints on component, the error appears.
Let me know, if you need more information.
Cheers, Viktor
------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Hi Viktor, great. thanks. We'll look at it as soon as possible. Stefan On Thu, Mar 01, 2012 at 02:50:29PM +0100, Viktor Rosenfeld wrote:
Hi Stefan,
I've filed a bug report: http://bugs.monetdb.org/show_bug.cgi?id=3046.
Sorry for not getting back earlier. The server also crashes on empty tables. I've included the SQL to create the tables and also a backtrace of the crash. I don't know how to create prints of variables or arguments, although the values of some arguments are visible in the backtrace.
There appears to be no assertion or any output in merovingian.log. I've used --enable-debug --disable-optimize --enable-assert as options to configure.
Cheers, Viktor
Stefan Manegold wrote:
Viktor,
a server crash is always a bug; hence, please file a bug report.
If possible, include any of the following information:
Does the server also crash when you run the query in empty tables, then please include your relevant create table statements.
Can you run mserver5 (preferably not configured with --disable-debug --enable-optimize) in a debugger? If so, please attach a back-trace of the crash, including prints of all variables/arguments related to the statement where the crash occurs.
Could you re-configure and re-build your MonetDB with --enable-assert and check whether you get an assertion (if so, which?)?
Thanks! Stefan
On Fri, Feb 24, 2012 at 11:32:35AM +0100, Viktor Rosenfeld wrote:
Hi,
the following query results in a "Connection terminated error":
SELECT count(*) FROM ( SELECT DISTINCT node1.id AS id1, node2.id AS id2, node1.toplevel_corpus FROM node AS node1, rank AS rank1, component AS component1, node AS node2, rank AS rank2, component AS component2 WHERE component1.id = component2.id AND component1.name IS NULL AND component1.type = 'd' AND component2.name IS NULL AND component2.type = 'd' AND rank1.component_ref = component1.id AND rank1.node_ref = node1.id AND rank1.pre = rank2.parent AND rank2.component_ref = component2.id AND rank2.node_ref = node2.id ) AS solutions;
The full error message is:
MAPI = annis@moos.local:50000 ACTION= read_line QUERY = SELECT count(*) FROM ( SELECT DISTINCT node1.id AS id1, node2.id AS id2, node1.toplevel_corpus FROM node AS node1, rank AS rank1, component AS component1, node AS node2, rank AS rank2, component AS component2 WHERE component1.id = component2.id AND component1.name IS NULL AND component1.type = 'd' AND component2.name IS NULL AND component2.type = 'd' AND rank1.component_ref = component1.id AND rank1.node_ref = node1.id AND rank1.pre = rank2.parent AND rank2.component_ref = component2.id AND rank2.node_ref = node2.id ) AS solutions; ERROR = !Connection terminated
I can get it to run if I remove the following line:
component1.id = component2.id AND
or if I remove the following 4 lines:
component1.name IS NULL AND component1.type = 'd' AND component2.name IS NULL AND component2.type = 'd' AND
However, if I include all constraints on component, the error appears.
Let me know, if you need more information.
Cheers, Viktor
------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
participants (2)
-
Stefan Manegold -
Viktor Rosenfeld