No Host AvailableException during querying Cassandra.

Hello All, We are using DSE 4.6.6 & Cassandra 2.0.14.425. I am facing this exception right now. We got this exception couple of times & repair jobs helped us temporarily. As the data is growing significantly we are experiencing this exception more than couple of times. Does any one have any

Re: [Multi DC] Old Data Not syncing from Existing cluster to new Cluster

What Dikang said, in your original email you are passing -dc to rebuild. This is incorrect. Simply run nodetool rebuild from each of the nodes in the new dc. On 28 Jan 2017 07:50, "Dikang Gu" wrote: > Have you run 'nodetool rebuild dc_india' on the new nodes? > > On Tue,

Re: [Multi DC] Old Data Not syncing from Existing cluster to new Cluster

Have you run 'nodetool rebuild dc_india' on the new nodes? On Tue, Jan 24, 2017 at 7:51 AM, Benjamin Roth wrote: > Have you also altered RF of system_distributed as stated in the tutorial? > > 2017-01-24 16:45 GMT+01:00 Abhishek Kumar Maheshwari

Re: Re : Decommissioned nodes show as DOWN in Cassandra versions 2.1.12 - 2.1.16

FYI : This issue is related to CASSANDRA-10205 (Gossiper class) patch introduced in 2.1.11. When we roll back the changes from CASSANDRA-10205 (Gossiper class) in 2.1.12 and 2.1.15,

Re: Re : Decommissioned nodes show as DOWN in Cassandra versions 2.1.12 - 2.1.16

Please remove the ips from the system.peer table of all nodes or you can use unsafeassasinate from JMX. From: Agrawal, Pratik Sent: Friday, January 27, 2017 9:05:43 AM To: user@cassandra.apache.org; k...@instaclustr.com;

Re: Re : Decommissioned nodes show as DOWN in Cassandra versions 2.1.12 - 2.1.16

We are seeing the same issue with Cassandra 2.0.8. The nodetool gossipinfo reports a node being down even after we decommission the node from the cluster. Thanks, Pratik From: kurt greaves > Reply-To:

Re: Re : Decommissioned nodes show as DOWN in Cassandra versions 2.1.12 - 2.1.16

we've seen this issue on a few clusters, including on 2.1.7 and 2.1.8. pretty sure it is an issue in gossip that's known about. in later versions it seems to be fixed. On 24 Jan 2017 06:09, "sai krishnam raju potturi" wrote: > In the Cassandra versions 2.1.11 - 2.1.16,

secondary index on static column

Hi, I'm quite new to cassandra and allthough there is much info on the net, sometimes I cannot find the solution to a problem. In this case, I have a second index on a static column and I don't understand the answer I get from my select. A cut down version of the table is: create table demo

Re: [External] Re: Cassandra ad hoc search options

Hi We used lucene stratio plugin with C*3.0.3 Helped to solve a lot of some read patterns. Served well for prefix. But created problems as repairs failed repeatedly. We might have used it sub optimally, not sure. Later, we had to do away with it, and tried to serve most of the read patterns with