You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@ignite.apache.org by "Aditya (Jira)" <ji...@apache.org> on 2020/01/27 11:20:00 UTC

[jira] [Created] (IGNITE-12584) Query execution is too long issue!

Aditya created IGNITE-12584:
-------------------------------

             Summary: Query execution is too long issue!
                 Key: IGNITE-12584
                 URL: https://issues.apache.org/jira/browse/IGNITE-12584
             Project: Ignite
          Issue Type: Bug
            Reporter: Aditya
         Attachments: uploadthis.txt

When querying via some java application and if the topology is in such a way that two clients connect to one server node, then some times we are getting an exception saying query execution is too long.

 

This is the SQL schema for table

 

stmt.executeUpdate("CREATE TABLE DOCIDS (" +
 " id LONG PRIMARY KEY, url VARCHAR, score LONG, appname VARCHAR) " +
 " WITH \"template=replicated\"");

 

stmt.executeUpdate("CREATE INDEX idx_doc_name_url ON DOCIDS (appname, url)");

 

Query -> 

SqlFieldsQuery query = new SqlFieldsQuery("SELECT count(id) FROM DOCIDS");

FieldsQueryCursor<List<?>> cursor = cache.query(query);

For warning prints, please check the attachment.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)