Re: cqlsh problem

CASSANDRA-10959 made the control connection timeout be the same as the connect timeout. This patch is available since 2.2.5, 3.0.3, 3.3. On Fri, Oct 14, 2016 at 11:45 AM, joseph gao wrote: > I've found the problem,

Re: are there any free Cassandra -> ElasticSearch connector / plugin ?

Yep - exactly right Kurt. I strongly doubt there can be over 100K LOC changed across 1K files and not touch anything else as a side effect. git diff --stat cassandra-3.0.9..HEAD 1093 files changed, 98490 insertions(+), 16870 deletions(-) On Thu, Oct 13, 2016 at 9:27 PM kurt Greaves

Re: Repair in Multi Datacenter - Should you use -dc Datacenter repair or repair with -pr

Don't do pr repairs when using incremental repair, you'll just end up with loads of anti-compactions. On 12 October 2016 at 19:11, Harikrishnan Pillai wrote: > In my experience dc local repair node by node with > Pr and par options is best .full repair increased

Re: are there any free Cassandra -> ElasticSearch connector / plugin ?

New features don't necessarily restrict bugs only to those features. (only in our dreams). Often features may touch on parts of the code that could cause issues for other parts of the system. To clarify, just because you don't use new features, doesn't mean you are free from the risk of their

Re: what does this Note mean?

Nodetool status / nodetool ring will show an estimated ownership. They estimate this by looking at the replication settings of one of the non-system keyspaces (presumably those that contain actual data). If they all have the same replication settings (say, RF=3 in each DC using

Re: cqlsh problem

I've found the problem, in cqlsh file, find all Cluster 's construct method like ' conn = Cluster(xxx,xxx). At the end, add parameter control_connection_timeout=float(_SOME_MS_VALUE_). As below: conn = Cluster(contact_points=(self.hostname,), port=self.port, cql_version=self.conn.cql_version,

Re: what does this Note mean?

It means for accurate load statistics add the keyspace name after nodetool status. nodetool status All the best, On Thu, Oct 13, 2016 at 10:08 PM, Kant Kodali wrote: > > Note: Non-system keyspaces don't have the same replication settings, > effective ownership

what does this Note mean?

Note: Non-system keyspaces don't have the same replication settings, effective ownership information is meaningless

Re: Can not delete record with counter column in a batch.

On 10/13/2016 08:11 PM, Alexei Levashov wrote: > Previously I did it in a logged batch without any issues but upgrading > from Cassandra 1.2.x to 2.1 brings the following Exception message: > "Error executing batch. Message: Cannot include a counter statement in a > logged batch" > > Question: >

Can not delete record with counter column in a batch.

Configuration : Cassandra 2.1 (if it matters Datastax Java driver 3.0.0 - driver users list couldn't help) Platform Unix. I have two tables: CREATE TABLE unmapped_doc_type ( application_id uuid, doc_type_id text, metadata text, PRIMARY KEY (application_id, doc_type_id) ) CREATE TABLE

Re: are there any free Cassandra -> ElasticSearch connector / plugin ?

If you're not using the features why use a release that nobody else (read: experienced users) is? What do you need in 3.x that's not available in 3.0? On Thu, Oct 13, 2016 at 5:23 PM Eric Ho wrote: > But if I'm not doing anything fancy w/ C* (i.e. don't use new features

Re: are there any free Cassandra -> ElasticSearch connector / plugin ?

But if I'm not doing anything fancy w/ C* (i.e. don't use new features in 3.{2,4,6}) then I'll be fine, right ? -eric ho On Thu, Oct 13, 2016 at 5:09 PM, Jonathan Haddad wrote: > I listed my reasons, please check my previous email. > > On Thu, Oct 13, 2016 at 4:55 PM Eric

Re: are there any free Cassandra -> ElasticSearch connector / plugin ?

I listed my reasons, please check my previous email. On Thu, Oct 13, 2016 at 4:55 PM Eric Ho wrote: > Why 3.0.x ? Why not use 3.2.x or 3.4.x ? or 3.6.x ? > Shouldn't 3.6.x be more stable than say 3.2.x ? > > > -eric ho > > > On Thu, Oct 13, 2016 at 3:48 PM, Jonathan

Re: are there any free Cassandra -> ElasticSearch connector / plugin ?

Why 3.0.x ? Why not use 3.2.x or 3.4.x ? or 3.6.x ? Shouldn't 3.6.x be more stable than say 3.2.x ? -eric ho On Thu, Oct 13, 2016 at 3:48 PM, Jonathan Haddad wrote: > Here's your basic options: > > 1. Triggers (avoid like the plague) > 2. CDC (really new, tricky to avoid

Re: are there any free Cassandra -> ElasticSearch connector / plugin ?

Here's your basic options: 1. Triggers (avoid like the plague) 2. CDC (really new, tricky to avoid RF operations as is, probably avoid) 3. Do it in your app 4. Put Kafka in front of your data, write as many consumers as you want to write the data in as many ways as you want Also, how long have

Re: are there any free Cassandra -> ElasticSearch connector / plugin ?

Some suggested Elassandra. But that is based on Cassandra 2.2. I would like to use Cassandra 3.7 and up... -eric ho On Thu, Oct 13, 2016 at 3:04 PM, vincent gromakowski < vincent.gromakow...@gmail.com> wrote: > Elassandra > https://github.com/vroyer/elassandra > > Le 14 oct. 2016 12:02 AM,

Re: are there any free Cassandra -> ElasticSearch connector / plugin ?

I haven't used it yet, but https://github.com/vroyer/elassandra -- Brian O'Neill Principal Architect @ Monetate m: 215.588.6024 bone...@monetate.com > On Oct 13, 2016, at 6:02 PM, Eric Ho wrote: >

Re: are there any free Cassandra -> ElasticSearch connector / plugin ?

Elassandra https://github.com/vroyer/elassandra Le 14 oct. 2016 12:02 AM, "Eric Ho" a écrit : > I don't want to change my code to write into C* and then to ES. > So, I'm looking for some sort of a sync tool that will sync my C* table > into ES and it should be smart enough

are there any free Cassandra -> ElasticSearch connector / plugin ?

I don't want to change my code to write into C* and then to ES. So, I'm looking for some sort of a sync tool that will sync my C* table into ES and it should be smart enough to avoid duplicates or gaps. Is there such a tool / plugin ? I'm using stock apache Cassandra 3.7. I know that some premium

Re: Does increment/decrement by 0 generate any commits ?

According to https://issues.apache.org/jira/browse/CASSANDRA-7304 unset values in a prepared statement for a counter does not change the value of the counter. This applies for versions of Cassandra 2.2 and above. I would also look to verify the claimed behaviour myself. On Tue, 11 Oct 2016 at

New node overstreaming data ?

Hello, We run 2.1.13 and seeing an odd issue. A node went down, and stayed down for a while so it went out of gossip. When we try to bootstrap it again (as a new node), it overstreams from other nodes, eventually disk becomes full and crashes. This repeated 3 times. Does anyone have any

Re: Gossip status: hibernate

In the normal case, absolutely. That should happen quickly. I think it is likely the case that you've hit another race condition where this phantom node is not correctly marked as dead. In this case, even if it is removed from some nodes in the cluster, it will get re-added by the node that

Re: Gossip status: hibernate

Thanks for the details. I don't know what happened on that node. It's a long time ago I think. I wasn't aware of it earlier. Will a node in hibernating state that failed joining and subsequently was discarded get removed from gossip at some point? On Wed, Oct 12, 2016 at 5:23 PM, Joel Knighton