Re: multiple snitches in the same cluster

2019-04-16 Thread Paul Chandler
Sravan, When we migrated to google we just continued using the GossipingPropertyFileSnitch, we did not try and use the google version of the snitch. The only downside is the need to manually setup the cassandra-rackdc.properties file, but for us that was controlled by puppet anyway, so it was

Re: multiple snitches in the same cluster

2019-04-16 Thread Shravan R
Thanks Paul. Glad to know that you are speaking on the very subject soon. Even though you are on GCP, you are still tied with GossipingPropertyFileSnitch and not enjoying the GoogleCloudSnitch. If it is not too much to ask, other than hand stitching RACK and DC in cassandra-rackdc.properties are

Re: multiple snitches in the same cluster

2019-04-16 Thread Paul Chandler
Hi Shravan, We did not see any down sides of using the GossipingPropertyFileSnitch, in fact being able to handcraft the DC allowed us to easily create “virtual” cassandra datacenters within the google DC, something we have used for splitting multi tenanted clusters. I am not sure how easy that

Re: multiple snitches in the same cluster

2019-04-16 Thread Shravan R
Thanks Paul On Tue, Apr 16, 2019 at 9:52 AM Paul Chandler wrote: > Hi Shravan, > > We did not see any down sides of using the GossipingPropertyFileSnitch, in > fact being able to handcraft the DC allowed us to easily create “virtual” > cassandra datacenters within the google DC, something we hav

Caused by: com.datastax.driver.core.exceptions.ReadTimeoutException:

2019-04-16 Thread Krishnanand Khambadkone
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.y

Re: Caused by: com.datastax.driver.core.exceptions.ReadTimeoutException:

2019-04-16 Thread Mahesh Daksha
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 solve

Re: Caused by: com.datastax.driver.core.exceptions.ReadTimeoutException:

2019-04-16 Thread Dinesh Joshi
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 wrote: > > Hi, > > how much data you are trying to read in the single query? is it large in size > or normal tex

Re: Caused by: com.datastax.driver.core.exceptions.ReadTimeoutException:

2019-04-16 Thread Tommy Stendahl
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