Re: [MonetDB-users] "ERROR = !Connection terminated" for some SQL queries

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