[jira] [Created] (IGNITE-9048) Local SqlFieldsQuery on client leads to exception

[Anton Vinogradov (Jira)]

Evgenii Zagumennov created IGNITE-9048:
------------------------------------------

             Summary: Local SqlFieldsQuery on client leads to exception
                 Key: IGNITE-9048
                 URL: https://issues.apache.org/jira/browse/IGNITE-9048
             Project: Ignite
          Issue Type: Bug
          Components: cache, clients, sql
            Reporter: Evgenii Zagumennov
         Attachments: LocalSqlFieldsQueryOnClientFailTest.java

SqlFieldsQuery with setLocal(true) on client node throws exception

 
{code:java}
Caused by: java.lang.NullPointerException
    at org.apache.ignite.internal.processors.query.h2.database.H2TreeIndex.segmentsCount(H2TreeIndex.java:187)
    at org.apache.ignite.internal.processors.query.h2.opt.GridH2IndexBase.threadLocalSegment(GridH2IndexBase.java:182)
    at org.apache.ignite.internal.processors.query.h2.database.H2TreeIndex.find(H2TreeIndex.java:195)
    at org.h2.index.BaseIndex.find(BaseIndex.java:128)
    at org.h2.index.IndexCursor.find(IndexCursor.java:169)
    at org.h2.table.TableFilter.next(TableFilter.java:468)
    at org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1452)
    at org.h2.result.LazyResult.hasNext(LazyResult.java:79)
    at org.h2.result.LazyResult.next(LazyResult.java:59)
    at org.h2.command.dml.Select.queryFlat(Select.java:519)
    at org.h2.command.dml.Select.queryWithoutCache(Select.java:625)
    at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
    at org.h2.command.dml.Query.query(Query.java:352)
    at org.h2.command.dml.Query.query(Query.java:333)
    at org.h2.command.CommandContainer.query(CommandContainer.java:113)
    at org.h2.command.Command.executeQuery(Command.java:201)
    ... 18 more{code}
 

Reproducer "LocalSqlFieldsQueryOnClientFailTest.java" is in the attachement



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[prashant]

Hi Guys,

I am also running into same issue where I am doing local query

            SqlFieldsQuery query = new SqlFieldsQuery(sql);
            query.setLocal(true);
            FieldsQueryCursor<List&lt;?>> fq = cache.query(query);


This leads to same exception stack trace.

Is there any workaround where I would like query to be only issued against
the rows that are cached locally on the query node.

Thank you very much
Prashant Patel



--
Sent from: http://apache-ignite-developers.2346864.n4.nabble.com/

[daradurvs]

Hi, which Ignite's version do you use?

*Local* queries are prohibited on client nodes since they do not store data.

The check was added within task [1] and included in Ignite 2.7 release.

[1] https://issues.apache.org/jira/browse/IGNITE-8915

On Tue, Jan 8, 2019 at 10:17 PM prashant <[hidden email]> wrote:

>
> Hi Guys,
>
> I am also running into same issue where I am doing local query
>
>             SqlFieldsQuery query = new SqlFieldsQuery(sql);
>             query.setLocal(true);
>             FieldsQueryCursor<List&lt;?>> fq = cache.query(query);
>
>
> This leads to same exception stack trace.
>
> Is there any workaround where I would like query to be only issued against
> the rows that are cached locally on the query node.
>
> Thank you very much
> Prashant Patel
>
>
>
> --
> Sent from: http://apache-ignite-developers.2346864.n4.nabble.com/

--
Best Regards, Vyacheslav D.