Re: Failed to fetch SQL query result

2018-12-07 Thread Ilya Kasnacheev
Hello! After more investigation we have opened a new ticket: https://issues.apache.org/jira/browse/IGNITE-10580 And the workaround is different: you need to make query non-local, for example by turning cache partitioned instead of replicated. If you execute two identical local queries (ones that

Re: Failed to fetch SQL query result

2018-12-06 Thread yangjiajun
Hello! Please fell free to deal with the code. I try to add where clause to my query,but it does not save me.The test code still throws the exception after a while.My ignite's version is 2.6.Does the workaround work in latest version?Or does this workaround only reduce the probability of the

Re: Failed to fetch SQL query result

2018-12-06 Thread Ilya Kasnacheev
Hello! I have confirmed this problem and we are working on it in https://issues.apache.org/jira/browse/IGNITE-9171 I have converted your reproducer to Ignite test, hope you don't mind. There is a workaround in that you could add a parameter to your query, such as WHERE id > ?, and pass something

Re: Failed to fetch SQL query result

2018-12-05 Thread yangjiajun
Hello. I test setQueryTimeout method to see whether it works or not because I try to prevent long time queries from blocking other operations.According to my test,this method has no effect.You can also see that I have already removed it in my latest test code.The code is simple and reproduce my

Re: Failed to fetch SQL query result

2018-12-05 Thread Ilya Kasnacheev
c > > here, though. > > > > Regards, > > -- > > Ilya Kasnacheev > > > > > > пн, 3 дек. 2018 г. в 06:21, yangjiajun < > > > 1371549332@ > > >>: > > > >> Hello. > >> > >> The error does no

Re: Failed to fetch SQL query result

2018-12-04 Thread yangjiajun
If so, which is the # of row on which it >> will >> > happen? >> > >> > Regards, >> > -- >> > Ilya Kasnacheev >> > >> > >> > вт, 27 нояб. 2018 г. в 10:09, yangjiajun < >> >> > 137154

Re: Failed to fetch SQL query result

2018-12-02 Thread Ilya Kasnacheev
t; -- > > Ilya Kasnacheev > > > > > > вт, 27 нояб. 2018 г. в 10:09, yangjiajun < > > > 1371549332@ > > >>: > > > >> Hello. > >> > >> I did a scan query on a table which has 8w records and tried to go > >> through > &

Re: Failed to fetch SQL query result

2018-12-02 Thread yangjiajun
ecords and tried to go >> through >> all records in the result set but got following exception: >> >> [13:53:31,523][SEVERE][client-connector-#77][JdbcRequestHandler] Failed >> to >> fetch SQL query result [reqId=0, req=JdbcQueryFetchRequest >> [queryId=3810

Re: Failed to fetch SQL query result

2018-11-30 Thread Ilya Kasnacheev
h > all records in the result set but got following exception: > > [13:53:31,523][SEVERE][client-connector-#77][JdbcRequestHandler] Failed to > fetch SQL query result [reqId=0, req=JdbcQueryFetchRequest > [queryId=38106237, pageSize=1024]] > class org.apache.ignite.internal.processors.query

Failed to fetch SQL query result

2018-11-26 Thread yangjiajun
Hello. I did a scan query on a table which has 8w records and tried to go through all records in the result set but got following exception: [13:53:31,523][SEVERE][client-connector-#77][JdbcRequestHandler] Failed to fetch SQL query result [reqId=0, req=JdbcQueryFetchRequest [queryId=38106237