Re: nodetool removenode causing the schema out of sync

2017-07-13 Thread Subroto Barua
set streamthroughput higher than 200 on the source side and lower on the target node just curious, have you tried removenode force? On Thursday, July 13, 2017, 8:35:38 AM PDT, Jai Bheemsen Rao Dhanwada wrote: Thank you Sean, you mean setstreamthroughput to a lower value

Re: Repair on system_auth

2017-07-06 Thread Subroto Barua
you can check the status via nodetool netstatsto kill the repair job, restart the instance On Thursday, July 6, 2017, 1:09:42 PM PDT, Mark Furlong wrote: I have started a repair on my system_auth keyspace. The repair has started and the process shows as running with

need help tuning dropped mutation messages

2017-07-06 Thread Subroto Barua
I am seeing these errors: MessagingService.java: 1013 -- MUTATION messages dropped in last 5000 ms: 0 for internal timeout and 4 for cross node timeout write consistency @ LOCAL_QUORUM is failing on a 3-node cluster and 18-node cluster..

Re: need help tuning dropped mutation messages

2017-07-06 Thread Subroto Barua
c* version: 3.0.11 cross_node_timeout: truerange_request_timeout_in_ms: 1write_request_timeout_in_ms: 2000counter_write_request_timeout_in_ms: 5000cas_contention_timeout_in_ms: 1000 On Thursday, July 6, 2017, 11:43:44 AM PDT, Subroto Barua <sbarua...@yahoo.com.INVALID> wrote: I am

Re: Starting Cassandrs after restore of Data - get error

2017-07-08 Thread Subroto Barua
Use "dos2unix" utility when editing/moving from windows to Linux -- could be a formatting issue Subroto > On Jul 7, 2017, at 9:47 AM, Jonathan Baynes > wrote: > > Yes both clusters match I've checked 3 Times and diff'd it as well. Would > file format have any

Re: Reversed read write performance.

2017-07-14 Thread Subroto Barua
Nodetool compactionstats Regarding cassandra-stress, make sure that you initiate load outside of database subnet Subroto > On Jul 14, 2017, at 3:02 PM, Roger Warner wrote: > > 30G java heap. The dataset is the usual Cassandra-test size > > How do I tell if

Re: write time for nulls is not consistent

2017-07-18 Thread Subroto Barua
Works fine either case on 3.0.12 Subroto > On Jul 18, 2017, at 2:41 PM, kurt greaves wrote: > > can you try select a, writetime(b) from test.t > I heard of an issue recently where cqlsh reports null incorrectly if you > query a column twice, wondering if it extends to

Re: MUTATION messages were dropped in last 5000 ms for cross node timeout

2017-07-20 Thread Subroto Barua
In a cloud environment, cross_node_timeout = true can cause issues; we had this issue in our environment and it is set to false now. Dropped messages is an another issue Subroto > On Jul 20, 2017, at 8:27 AM, ZAIDI, ASAD A wrote: > > Hello Folks – > > I’m using

Re: nodetool repair failure

2017-06-29 Thread Subroto Barua
Balaji, Are you repairing a specific keyspace/table? if the failure is tied to a table, try 'verify' and 'scrub' options on .91...see if you get any errors. On Thursday, June 29, 2017, 12:12:14 PM PDT, Balaji Venkatesan wrote: Thanks. I tried with trace option

Re: RE: Cassandra issue “Unable to gossip with any seeds”

2017-07-04 Thread Subroto Barua
check firewall rules to/from .152 to seed nodes (telnet On Tuesday, July 4, 2017, 6:38:16 AM PDT, Jonathan Baynes wrote: #yiv3228115995 #yiv3228115995 -- _filtered #yiv3228115995 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered

Re: RE: Adding a new node with the double of disk space

2017-08-19 Thread Subroto Barua
Jeff, is it ok to have different values of num_tokens per node in a cluster? won't it create cluster imbalance? or it better to initiate it on a separate DC? Subroto On Friday, August 18, 2017, 5:34:11 AM PDT, Durity, Sean R wrote: #yiv5432100827 #yiv5432100827 --

Re: Question: Behavior of inserting a list multiple times with same timestamp

2017-06-19 Thread Subroto Barua
is scores has less than 2 elements) UPDATE plays SET scores = scores - [ 12, 21 ] WHERE id = '123-afde'; // removes all occurrences of 12 and 21 from scores As with maps, TTLs if used only apply to the newly inserted/updated values. On 6/19/17, 1:12 AM, "Subroto Barua"

Re: Question: Behavior of inserting a list multiple times with same timestamp

2017-06-19 Thread Subroto Barua
This is an expected behavior. We learned this issue/feature at the current site (we use Dse 5.08) Subroto > On Jun 18, 2017, at 10:29 PM, Zhongxiang Zheng wrote: > > Hi all, > > I have a question about a behavior when insert a list with specifying > timestamp. > > It

Re: cassandra-stress w/ DC aware

2017-10-18 Thread Subroto Barua
I figured it out ... cassandra-stress user profile=myprofile.yaml cl=local_quorum node= ... On Wednesday, October 18, 2017, 12:07:35 PM PDT, Subroto Barua <sbarua...@yahoo.com.INVALID> wrote: is it possible to run cassandra-stress against a specific DC w/ user yaml

cassandra-stress w/ DC aware

2017-10-18 Thread Subroto Barua
is it possible to run cassandra-stress against a specific DC w/ user yaml file?  there is an option w/o yaml, but I am not sure i can do the same with USER option.. cassandra: 3.0.12 thanks! Subroto

Re: Executing a check before replication / manual replication

2017-11-15 Thread Subroto Barua
turn on audit on tables in question, scan the audit logs (using tools like Splunk) and send alerts based on the activity... On Wednesday, November 15, 2017, 12:33:30 PM PST, Abdelkrim Fitouri wrote: Hi, I know that cassandra handel properly data replication

Re: running C* on AWS EFS storage ...

2017-11-13 Thread Subroto Barua
From our experience, the ebs remount process was quite painful Subroto > On Nov 12, 2017, at 4:18 PM, kurt greaves wrote: > > What's wrong with just detaching the EBS volume and then attaching it to the > new node?​ Assuming you have a separate mount for your C* data

running C* on AWS EFS storage ...

2017-11-12 Thread Subroto Barua
Hi, We have a unique requirement to replace C* (3.0.x on RHEL) nodeswith a new AWS AMI image periodically. The current process (add node/decommissionetc) is a very manual and time consuming process. We currently use EBS andexploring EFS as an option to speed up the process. Does anybody have

Re: running C* on AWS EFS storage ...

2017-11-12 Thread Subroto Barua
Any reason you think EFS would be better than EBS? -- Jeff Jirsa On Nov 12, 2017, at 1:38 PM, Subroto Barua <sbarua...@yahoo.com.INVALID> wrote: Hi, We have a unique requirement to replace C* (3.0.x on RHEL) nodeswith a new AWS AMI image periodically. The current process (add node/dec