ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Denis Magda <dma...@gridgain.com>
Subject Re: Exception during querying by jdbc - occurs on average once every 5 times
Date Thu, 26 May 2016 20:00:54 GMT
> https://issues.apache.org/jira/browse/IGNITE-2751 <https://issues.apache.org/jira/browse/IGNITE-2751>
> Does it mean that my SQL quries speed up ?

Yes, it does.

—
Denis

> On May 26, 2016, at 7:16 PM, Tomek W <rrrtomtomrrr@gmail.com> wrote:
> 
> Ok, so firstly upgrade.
> If it don't solve problem, increase timeout (on new version too).
> 
> https://issues.apache.org/jira/browse/IGNITE-2751 <https://issues.apache.org/jira/browse/IGNITE-2751>
> Does it mean that my SQL quries speed up ?
> 
> 2016-05-26 17:53 GMT+02:00 Denis Magda <dmagda@gridgain.com <mailto:dmagda@gridgain.com>>:
>> So what I should to do ?  
>> Increase timeout or try new version ?  
>> When it comes to increase timeout - is it possible to do it using xml config file?
> 
> Try switching to the new version first. And yes it’s possible to set ConnectorConfiguration
in XML.
> 
> —
> Denis
> 
>> On May 26, 2016, at 6:32 PM, Tomek W <rrrtomtomrrr@gmail.com <mailto:rrrtomtomrrr@gmail.com>>
wrote:
>> 
>> | How long does it usually take to execute such query? I’m quite sure that you’re
facing with an I/O timeout that terminates the connection between the client and server because
query execution takes long time on the server side.
>> 
>> Yeah, I have the same guess.  
>> 
>> So what I should to do ?  
>> Increase timeout or try new version ?  
>> When it comes to increase timeout - is it possible to do it using xml config file?
>> 
>> 2016-05-26 15:53 GMT+02:00 Denis Magda <dmagda@gridgain.com <mailto:dmagda@gridgain.com>>:
>> Hi,
>> 
>> How long does it usually take to execute such query? I’m quite sure that you’re
facing with an I/O timeout that terminates the connection between the client and server because
query execution takes long time on the server side.
>> 
>> The first thing to do is to give a try to the latest Ignite release [1] that contains
the fix for the issue [2] you most probably facing with.
>> The second thing to do is to increase ConnectorConfiguration.idleTimeout on the server
side. This can be done in the following way:
>> 
>> IgniteConfiguration cfg = new IgniteConfiguration();
>> 
>> ConnectorConfiguration connectorConfiguration = new ConnectorConfiguration();
>> 
>> connectorConfiguration.setIdleTimeout(30_000);
>> 
>> cfg.setConnectorConfiguration(connectorConfiguration);
>> 
>> [1] apache-ignite-fabric-1.6.0-bin.zip <http://apache-mirror.rbc.ru/pub/apache//ignite/1.6.0/apache-ignite-fabric-1.6.0-bin.zip>
>> [2] https://issues.apache.org/jira/browse/IGNITE-2751 <https://issues.apache.org/jira/browse/IGNITE-2751>
>> 
>> —
>> Denis
>> 
>>> On May 25, 2016, at 3:14 AM, tomk <rrrtomtomrrr@gmail.com <mailto:rrrtomtomrrr@gmail.com>>
wrote:
>>> 
>>> Hello, 
>>> below, I attached some exception that I get during querying by JDBC client. 
>>> It occurs for SELECT * COUNT.
>>> It is very important that this exception occurs about once every three times
>>> - twice getting the correct result. 
>>> My cache has exactly 3000000 entries.
>>> 
>>> 
>>> java.sql.SQLException: Failed to query Ignite.
>>>        at
>>> org.apache.ignite.internal.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:122)
>>>        at Tester.main(Tester.java:41)
>>> Caused by: class
>>> org.apache.ignite.internal.client.impl.connection.GridClientConnectionResetException:
>>> Failed to perform request (connection failed): /127.0.0.1:11212 <http://127.0.0.1:11212/>
>>>        at
>>> org.apache.ignite.internal.client.impl.connection.GridClientConnection.getCloseReasonAsException(GridClientConnection.java:491)
>>>        at
>>> org.apache.ignite.internal.client.impl.connection.GridClientNioTcpConnection.close(GridClientNioTcpConnection.java:336)
>>>        at
>>> org.apache.ignite.internal.client.impl.connection.GridClientNioTcpConnection.close(GridClientNioTcpConnection.java:296)
>>>        at
>>> org.apache.ignite.internal.client.impl.connection.GridClientConnectionManagerAdapter$NioListener.onDisconnected(GridClientConnectionManagerAdapter.java:605)
>>>        at
>>> org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onSessionClosed(GridNioFilterChain.java:249)
>>>        at
>>> org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedSessionClosed(GridNioFilterAdapter.java:93)
>>>        at
>>> org.apache.ignite.internal.util.nio.GridNioCodecFilter.onSessionClosed(GridNioCodecFilter.java:70)
>>>        at
>>> org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedSessionClosed(GridNioFilterAdapter.java:93)
>>>        at
>>> org.apache.ignite.internal.util.nio.GridNioServer$HeadFilter.onSessionClosed(GridNioServer.java:2115)
>>>        at
>>> org.apache.ignite.internal.util.nio.GridNioFilterChain.onSessionClosed(GridNioFilterChain.java:147)
>>>        at
>>> org.apache.ignite.internal.util.nio.GridNioServer$AbstractNioClientWorker.close(GridNioServer.java:1659)
>>>        at
>>> org.apache.ignite.internal.util.nio.GridNioServer$ByteBufferNioClientWorker.processRead(GridNioServer.java:731)
>>>        at
>>> org.apache.ignite.internal.util.nio.GridNioServer$AbstractNioClientWorker.processSelectedKeys(GridNioServer.java:1463)
>>>        at
>>> org.apache.ignite.internal.util.nio.GridNioServer$AbstractNioClientWorker.bodyInternal(GridNioServer.java:1398)
>>>        at
>>> org.apache.ignite.internal.util.nio.GridNioServer$AbstractNioClientWorker.body(GridNioServer.java:1280)
>>>        at
>>> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
>>>        at java.lang.Thread.run(Thread.java:745)
>>> ?
>>> 
>>> 
>>> 
>>> 
>>> --
>>> View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Exception-during-querying-by-jdbc-occurs-on-average-once-every-5-times-tp5156.html
<http://apache-ignite-users.70518.x6.nabble.com/Exception-during-querying-by-jdbc-occurs-on-average-once-every-5-times-tp5156.html>
>>> Sent from the Apache Ignite Users mailing list archive at Nabble.com <http://nabble.com/>.
>> 
>> 
> 
> 


Mime
View raw message