?????? ?????? ?????? t olerate how many nodes down in the cluster

2017-07-27 Thread Peng Xiao
Thanks all for your thorough explanation. -- -- ??: "Anuj Wadehra";; : 2017??7??28??(??) 0:49 ??: "User cassandra.apache.org"; "Peng Xiao"<2535...@qq.com>; : Re: ?? ?? t olerate how many nodes down in the cluster

Re: Stress test

2017-07-27 Thread Jay Zhuang
The user and password should be in -mode section, for example: ./cassandra-stress user profile=table.yaml ops\(insert=1\) -mode native cql3 user=** password=** http://docs.datastax.com/en/cassandra/3.0/cassandra/tools/toolsCStress.html /Jay On 7/27/17 2:46 PM, Greg Lloyd wrote: > I am trying to

Re: nodetool repair failure

2017-07-27 Thread Mitch Gitman
Michael, thanks for the input. I don't think I'm going to need to upgrade to 3.11 for the sake of getting nodetool repair working for me. Instead, I have another plausible explanation and solution for my particular situation. First, I should say that disk usage proved to be a red herring. There wa

Stress test

2017-07-27 Thread Greg Lloyd
I am trying to use the cassandra stress tool with the user profile=table.yaml arguments specified and do authentication at the same time. If I use the user profile I get an error Invalid parameter user=* if I specify a user and password. Is it not possible to specify a yaml and use authenticat

Re: write time for nulls is not consistent

2017-07-27 Thread Nitan Kainth
Thank you Jeff. Please share once, the Patch is available for us to apply. > On Jul 27, 2017, at 2:12 PM, Jeff Jirsa wrote: > > > > On 2017-07-20 08:46 (-0700), "Jeff Jirsa" wrote: >> >> >> On 2017-07-20 08:17 (-0700), Nitan Kainth wrote: >>> Jeff, >>> >>> It is really strange, look at b

Re: write time for nulls is not consistent

2017-07-27 Thread Jeff Jirsa
On 2017-07-20 08:46 (-0700), "Jeff Jirsa" wrote: > > > On 2017-07-20 08:17 (-0700), Nitan Kainth wrote: > > Jeff, > > > > It is really strange, look at below log, I inserted your data and then few > > additional; finally, the issue is reproduced: > This is a bug, cqlsh is displaying the t

Error Exception in Repair Thread

2017-07-27 Thread Meg Mara
Hello Cassandra Experts! I have seen the following errors in the system log when a scheduled nodetool repair operation runs on the cluster. Cassandra Version 3.0.10. Any thoughts or suggestions are welcome! ERROR [Repair#3794:3] 2017-07-27 17:47:22,000 CassandraDaemon.java:207 - Exception in t

Re: Data Loss irreparabley so

2017-07-27 Thread Jon Haddad
We (The Last Pickle) maintain an open source tool to help manage repairs across your clusters called Reaper. It’s a lot easier to set up and manage than trying to manage it through cron. http://thelastpickle.com/reaper.html > On Jul 27, 2017, at 12:38 AM,

Re: nodetool repair failure

2017-07-27 Thread Michael Shuler
On 07/27/2017 12:10 PM, Mitch Gitman wrote: > I'm using Apache Cassandra 3.10. > this is a dev cluster I'm talking about. > Further insights welcome... Upgrade and see if one of the many fixes for 3.11.0 helped? https://github.com/apache/cassandra/blob/cassandra-3.11.0/CHANGES.txt#L1-L129 If y

Re: nodetool repair failure

2017-07-27 Thread Mitch Gitman
I want to add an extra data point to this thread having encountered much the same problem. I'm using Apache Cassandra 3.10. I attempted to run an incremental repair that was optimized to take advantage of some downtime where the cluster is not fielding traffic and only repair each node's primary pa

Re: 回复: 回复: tolerate how many nodes down in the cluster

2017-07-27 Thread Anuj Wadehra
Hi Peng,  Racks can be logical (as defined with RAC attribute in Cassandra configuration files) or physical (racks in server rooms).   In my view, for leveraging racks in your case, its important to understand the implication of following decisions: 1. Number of distinct logical RACs defined in C

How to have nested collections in UDF/UDA

2017-07-27 Thread techpyaasa .
Hi , I have a tables as below: CREATE TABLE test.cs ( > pid bigint, > cid bigint, > stat_object text, > status int, > PRIMARY KEY (pid, cid) > ) WITH CLUSTERING ORDER BY (cid ASC) How can I have a function like below : CREATE or REPLACE FUNCTION test.countstatusobjs (state

Re: Uncaught exception on thread CounterMutationStage

2017-07-27 Thread David Salz
Hi Jeff, thanks for the pointers! We upgraded to C* 3.11.0 now and the situation has improved a little bit, the node does not die completely any more, but the WriteTimeoutExceptions persists and still 'freeze' the node for a couple of minutes. > A single node with 20 cores and 256GB of RAM is p

Re: Data Loss irreparabley so

2017-07-27 Thread Daniel Hölbling-Inzko
In that vein, Cassandra support Auto compaction and incremental repair. Does this mean I have to set up cron jobs on each node to do a nodetool repair or is this taken care of by Cassandra anyways? How often should I run nodetool repair Greetings Daniel Jeff Jirsa schrieb am Do. 27. Juli 2017 um