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