You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Krishnanand Khambadkone <kk...@yahoo.com.INVALID> on 2019/04/17 06:12:11 UTC
Caused by:
com.datastax.driver.core.exceptions.ReadTimeoutException:
Hi, I have a single instance cassandra server. I am trying to execute a query with ALLOW FILTERING option. When I run this same query from cqlsh it runs fine but when I try to execute the query through the java driver it throws this exception. I have increased all the timeouts in cassandra.yaml file and also included the read timeout option in the SimpleStetement query I am running. Any idea how I can fix this issue.
Caused by: com.datastax.driver.core.exceptions.ReadTimeoutException: Cassandra timeout during read query at consistency LOCAL_ONE (1 responses were required but only 0 replica responded)
Re: Caused by:
com.datastax.driver.core.exceptions.ReadTimeoutException:
Posted by Tommy Stendahl <to...@ericsson.com>.
Hi,
Have you tried to change the page size? I think cqlsh use a page size of 100 and the java driver use 5000 as default, sometimes this can make a difference.
/Tommy
On tis, 2019-04-16 at 23:38 -0700, Dinesh Joshi wrote:
More info with detailed explanation: https://protect2.fireeye.com/url?k=20fb8817-7c71a48f-20fbc88c-0cc47ad93eae-422600ad004bede1&u=https://www.instaclustr.com/apache-cassandra-scalability-allow-filtering-partition-keys/
Dinesh
On Apr 16, 2019, at 11:24 PM, Mahesh Daksha <da...@gmail.com>> wrote:
Hi,
how much data you are trying to read in the single query? is it large in size or normal text data.
Looking at the exception it seems the node is unable to deliver data within stipulated time. I have faced similar issue with the response data in huge in size (some binary data). But it was solved as we spread the data across multiple rows.
Thanks,
Mahesh Daksha
On Wed, Apr 17, 2019 at 11:42 AM Krishnanand Khambadkone <kk...@yahoo.com.invalid>> wrote:
Hi, I have a single instance cassandra server. I am trying to execute a query with ALLOW FILTERING option. When I run this same query from cqlsh it runs fine but when I try to execute the query through the java driver it throws this exception. I have increased all the timeouts in cassandra.yaml file and also included the read timeout option in the SimpleStetement query I am running. Any idea how I can fix this issue.
Caused by: com.datastax.driver.core.exceptions.ReadTimeoutException: Cassandra timeout during read query at consistency LOCAL_ONE (1 responses were required but only 0 replica responded)
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org<ma...@cassandra.apache.org>
For additional commands, e-mail: user-help@cassandra.apache.org<ma...@cassandra.apache.org>
Re: [EXTERNAL] Re: Caused by:
com.datastax.driver.core.exceptions.ReadTimeoutException:
Posted by Krishnanand Khambadkone <kk...@yahoo.com.INVALID>.
Thank you gentlemen for all your responses. Reading through them I was able to resolve the issue by doing the following,
a. Creating an index on one of the query fieldsb. Setting page size to 200
Now the query runs instantaneously.
On Wednesday, April 17, 2019, 7:12:21 AM PDT, Shaurya Gupta <sh...@gmail.com> wrote:
As already mentioned in this thread, ALLOW FILTERING should be avoided in any scenario.
It seems to work in test scenarios, but as soon as the data increases to certain size(a few MBs), it starts failing miserably and fails almost always.
ThanksShaurya
On Wed, Apr 17, 2019, 6:44 PM Durity, Sean R <SE...@homedepot.com> wrote:
If you are just trying to get a sense of the data, you could try adding a limit clause to limit the amount of results and hopefully beat the timeout.
However, ALLOW FILTERING really means "ALLOW ME TO DESTROY MY APPLICATION AND CLUSTER." It means the data model does not support the query and will not scale -- in this case, not even on one node. Design a new table to support the query with a proper partition key (and any clustering keys).
Sean Durity
-----Original Message-----
From: Dinesh Joshi <dj...@icloud.com.INVALID>
Sent: Wednesday, April 17, 2019 2:39 AM
To: user@cassandra.apache.org
Subject: [EXTERNAL] Re: Caused by: com.datastax.driver.core.exceptions.ReadTimeoutException:
More info with detailed explanation: https://urldefense.proofpoint.com/v2/url?u=https-3A__www.instaclustr.com_apache-2Dcassandra-2Dscalability-2Dallow-2Dfiltering-2Dpartition-2Dkeys_&d=DwIFAg&c=MtgQEAMQGqekjTjiAhkudQ&r=aC_gxC6z_4f9GLlbWiKzHm1vucZTtVYWDDvyLkh8IaQ&m=HXMAEKpR-N5O0-U5rclUrsVk5QPmSUQYels4VTOVZWI&s=LHl3QGlLsAdszkJ6XK3O2w7_EcSyRyaSFjBgEcK9nfo&e=
Dinesh
> On Apr 16, 2019, at 11:24 PM, Mahesh Daksha <da...@gmail.com> wrote:
>
> Hi,
>
> how much data you are trying to read in the single query? is it large in size or normal text data.
> Looking at the exception it seems the node is unable to deliver data within stipulated time. I have faced similar issue with the response data in huge in size (some binary data). But it was solved as we spread the data across multiple rows.
>
> Thanks,
> Mahesh Daksha
>
> On Wed, Apr 17, 2019 at 11:42 AM Krishnanand Khambadkone <kk...@yahoo.com.invalid> wrote:
> Hi, I have a single instance cassandra server. I am trying to execute a query with ALLOW FILTERING option. When I run this same query from cqlsh it runs fine but when I try to execute the query through the java driver it throws this exception. I have increased all the timeouts in cassandra.yaml file and also included the read timeout option in the SimpleStetement query I am running. Any idea how I can fix this issue.
> Caused by: com.datastax.driver.core.exceptions.ReadTimeoutException: Cassandra timeout during read query at consistency LOCAL_ONE (1 responses were required but only 0 replica responded)
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
For additional commands, e-mail: user-help@cassandra.apache.org
________________________________
The information in this Internet Email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this Email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this Email are subject to the terms and conditions expressed in any applicable governing The Home Depot terms of business or client engagement letter. The Home Depot disclaims all responsibility and liability for the accuracy and content of this attachment and for any damages or losses arising from any inaccuracies, errors, viruses, e.g., worms, trojan horses, etc., or other items of a destructive nature, which may be contained in this attachment and shall not be liable for direct, indirect, consequential or special damages in connection with this e-mail message or its attachment.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
For additional commands, e-mail: user-help@cassandra.apache.org
Re: [EXTERNAL] Re: Caused by: com.datastax.driver.core.exceptions.ReadTimeoutException:
Posted by Shaurya Gupta <sh...@gmail.com>.
As already mentioned in this thread, ALLOW FILTERING should be avoided in
any scenario.
It seems to work in test scenarios, but as soon as the data increases to
certain size(a few MBs), it starts failing miserably and fails almost
always.
Thanks
Shaurya
On Wed, Apr 17, 2019, 6:44 PM Durity, Sean R <SE...@homedepot.com>
wrote:
> If you are just trying to get a sense of the data, you could try adding a
> limit clause to limit the amount of results and hopefully beat the timeout.
>
> However, ALLOW FILTERING really means "ALLOW ME TO DESTROY MY APPLICATION
> AND CLUSTER." It means the data model does not support the query and will
> not scale -- in this case, not even on one node. Design a new table to
> support the query with a proper partition key (and any clustering keys).
>
>
> Sean Durity
>
>
> -----Original Message-----
> From: Dinesh Joshi <dj...@icloud.com.INVALID>
> Sent: Wednesday, April 17, 2019 2:39 AM
> To: user@cassandra.apache.org
> Subject: [EXTERNAL] Re: Caused by:
> com.datastax.driver.core.exceptions.ReadTimeoutException:
>
> More info with detailed explanation:
> https://urldefense.proofpoint.com/v2/url?u=https-3A__www.instaclustr.com_apache-2Dcassandra-2Dscalability-2Dallow-2Dfiltering-2Dpartition-2Dkeys_&d=DwIFAg&c=MtgQEAMQGqekjTjiAhkudQ&r=aC_gxC6z_4f9GLlbWiKzHm1vucZTtVYWDDvyLkh8IaQ&m=HXMAEKpR-N5O0-U5rclUrsVk5QPmSUQYels4VTOVZWI&s=LHl3QGlLsAdszkJ6XK3O2w7_EcSyRyaSFjBgEcK9nfo&e=
>
> Dinesh
>
> > On Apr 16, 2019, at 11:24 PM, Mahesh Daksha <da...@gmail.com> wrote:
> >
> > Hi,
> >
> > how much data you are trying to read in the single query? is it large in
> size or normal text data.
> > Looking at the exception it seems the node is unable to deliver data
> within stipulated time. I have faced similar issue with the response data
> in huge in size (some binary data). But it was solved as we spread the data
> across multiple rows.
> >
> > Thanks,
> > Mahesh Daksha
> >
> > On Wed, Apr 17, 2019 at 11:42 AM Krishnanand Khambadkone <
> kkhambadkone@yahoo.com.invalid> wrote:
> > Hi, I have a single instance cassandra server. I am trying to execute
> a query with ALLOW FILTERING option. When I run this same query from cqlsh
> it runs fine but when I try to execute the query through the java driver it
> throws this exception. I have increased all the timeouts in cassandra.yaml
> file and also included the read timeout option in the SimpleStetement query
> I am running. Any idea how I can fix this issue.
> > Caused by: com.datastax.driver.core.exceptions.ReadTimeoutException:
> Cassandra timeout during read query at consistency LOCAL_ONE (1 responses
> were required but only 0 replica responded)
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
> For additional commands, e-mail: user-help@cassandra.apache.org
>
>
> ________________________________
>
> The information in this Internet Email is confidential and may be legally
> privileged. It is intended solely for the addressee. Access to this Email
> by anyone else is unauthorized. If you are not the intended recipient, any
> disclosure, copying, distribution or any action taken or omitted to be
> taken in reliance on it, is prohibited and may be unlawful. When addressed
> to our clients any opinions or advice contained in this Email are subject
> to the terms and conditions expressed in any applicable governing The Home
> Depot terms of business or client engagement letter. The Home Depot
> disclaims all responsibility and liability for the accuracy and content of
> this attachment and for any damages or losses arising from any
> inaccuracies, errors, viruses, e.g., worms, trojan horses, etc., or other
> items of a destructive nature, which may be contained in this attachment
> and shall not be liable for direct, indirect, consequential or special
> damages in connection with this e-mail message or its attachment.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
> For additional commands, e-mail: user-help@cassandra.apache.org
>
>
RE: [EXTERNAL] Re: Caused by:
com.datastax.driver.core.exceptions.ReadTimeoutException:
Posted by "Durity, Sean R" <SE...@homedepot.com>.
If you are just trying to get a sense of the data, you could try adding a limit clause to limit the amount of results and hopefully beat the timeout.
However, ALLOW FILTERING really means "ALLOW ME TO DESTROY MY APPLICATION AND CLUSTER." It means the data model does not support the query and will not scale -- in this case, not even on one node. Design a new table to support the query with a proper partition key (and any clustering keys).
Sean Durity
-----Original Message-----
From: Dinesh Joshi <dj...@icloud.com.INVALID>
Sent: Wednesday, April 17, 2019 2:39 AM
To: user@cassandra.apache.org
Subject: [EXTERNAL] Re: Caused by: com.datastax.driver.core.exceptions.ReadTimeoutException:
More info with detailed explanation: https://urldefense.proofpoint.com/v2/url?u=https-3A__www.instaclustr.com_apache-2Dcassandra-2Dscalability-2Dallow-2Dfiltering-2Dpartition-2Dkeys_&d=DwIFAg&c=MtgQEAMQGqekjTjiAhkudQ&r=aC_gxC6z_4f9GLlbWiKzHm1vucZTtVYWDDvyLkh8IaQ&m=HXMAEKpR-N5O0-U5rclUrsVk5QPmSUQYels4VTOVZWI&s=LHl3QGlLsAdszkJ6XK3O2w7_EcSyRyaSFjBgEcK9nfo&e=
Dinesh
> On Apr 16, 2019, at 11:24 PM, Mahesh Daksha <da...@gmail.com> wrote:
>
> Hi,
>
> how much data you are trying to read in the single query? is it large in size or normal text data.
> Looking at the exception it seems the node is unable to deliver data within stipulated time. I have faced similar issue with the response data in huge in size (some binary data). But it was solved as we spread the data across multiple rows.
>
> Thanks,
> Mahesh Daksha
>
> On Wed, Apr 17, 2019 at 11:42 AM Krishnanand Khambadkone <kk...@yahoo.com.invalid> wrote:
> Hi, I have a single instance cassandra server. I am trying to execute a query with ALLOW FILTERING option. When I run this same query from cqlsh it runs fine but when I try to execute the query through the java driver it throws this exception. I have increased all the timeouts in cassandra.yaml file and also included the read timeout option in the SimpleStetement query I am running. Any idea how I can fix this issue.
> Caused by: com.datastax.driver.core.exceptions.ReadTimeoutException: Cassandra timeout during read query at consistency LOCAL_ONE (1 responses were required but only 0 replica responded)
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
For additional commands, e-mail: user-help@cassandra.apache.org
________________________________
The information in this Internet Email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this Email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this Email are subject to the terms and conditions expressed in any applicable governing The Home Depot terms of business or client engagement letter. The Home Depot disclaims all responsibility and liability for the accuracy and content of this attachment and for any damages or losses arising from any inaccuracies, errors, viruses, e.g., worms, trojan horses, etc., or other items of a destructive nature, which may be contained in this attachment and shall not be liable for direct, indirect, consequential or special damages in connection with this e-mail message or its attachment.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
For additional commands, e-mail: user-help@cassandra.apache.org
Re: Caused by:
com.datastax.driver.core.exceptions.ReadTimeoutException:
Posted by Dinesh Joshi <dj...@icloud.com.INVALID>.
More info with detailed explanation: https://www.instaclustr.com/apache-cassandra-scalability-allow-filtering-partition-keys/
Dinesh
> On Apr 16, 2019, at 11:24 PM, Mahesh Daksha <da...@gmail.com> wrote:
>
> Hi,
>
> how much data you are trying to read in the single query? is it large in size or normal text data.
> Looking at the exception it seems the node is unable to deliver data within stipulated time. I have faced similar issue with the response data in huge in size (some binary data). But it was solved as we spread the data across multiple rows.
>
> Thanks,
> Mahesh Daksha
>
> On Wed, Apr 17, 2019 at 11:42 AM Krishnanand Khambadkone <kk...@yahoo.com.invalid> wrote:
> Hi, I have a single instance cassandra server. I am trying to execute a query with ALLOW FILTERING option. When I run this same query from cqlsh it runs fine but when I try to execute the query through the java driver it throws this exception. I have increased all the timeouts in cassandra.yaml file and also included the read timeout option in the SimpleStetement query I am running. Any idea how I can fix this issue.
> Caused by: com.datastax.driver.core.exceptions.ReadTimeoutException: Cassandra timeout during read query at consistency LOCAL_ONE (1 responses were required but only 0 replica responded)
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
For additional commands, e-mail: user-help@cassandra.apache.org
Re: Caused by: com.datastax.driver.core.exceptions.ReadTimeoutException:
Posted by Mahesh Daksha <da...@gmail.com>.
Hi,
how much data you are trying to read in the single query? is it large in
size or normal text data.
Looking at the exception it seems the node is unable to deliver data within
stipulated time. I have faced similar issue with the response data in huge
in size (some binary data). But it was solved as we spread the data across
multiple rows.
Thanks,
Mahesh Daksha
On Wed, Apr 17, 2019 at 11:42 AM Krishnanand Khambadkone
<kk...@yahoo.com.invalid> wrote:
> Hi, I have a single instance cassandra server. I am trying to execute a
> query with ALLOW FILTERING option. When I run this same query from cqlsh
> it runs fine but when I try to execute the query through the java driver it
> throws this exception. I have increased all the timeouts in cassandra.yaml
> file and also included the read timeout option in the SimpleStetement query
> I am running. Any idea how I can fix this issue.
>
> Caused by: com.datastax.driver.core.exceptions.ReadTimeoutException:
> Cassandra timeout during read query at consistency LOCAL_ONE (1 responses
> were required but only 0 replica responded)
>
>