Default values for dclocal_read_repair_chance = 0.1 and read_repair_chance = 0 Should I set both to 0?

2019-10-26 Thread Sergio
I have a COLUMN Family in a Keyspace with Replication Factor = 3. The client reads it with LOCAL_QUORUM. Does this mean that all the reads should kick a read_repair or not? Are these parameters meaningful only with LOCAL_ONE or ONE Consistency then? I have also an application that translates some

Re: Decommissioned Node UNREACHABLE in describecluster but LEFT in gossipinfo

2019-10-26 Thread Sergio Bilello
It disappeared from describecluster after 1 day. It is only in gossipinfo now and this looks to be ok :) On 2019/10/25 04:01:03, Sergio wrote: > Hi guys, > > Cassandra 3.11.4 > > nodetool gossipinfo > /10.1.20.49 > generation:1571694191 > heartbeat:279800 >

Re: TWCS and gc_grace_seconds

2019-10-26 Thread Jon Haddad
My coworker Radovan wrote up a post on the relationship between gc grace and hinted handoff: https://thelastpickle.com/blog/2018/03/21/hinted-handoff-gc-grace-demystified.html Jon On Sat, Oct 26, 2019 at 6:45 AM Hossein Ghiyasi Mehr wrote: > It needs to change gc_grace_seconds carefully

Re: Repair Issues

2019-10-26 Thread Ben Mills
Thanks Ghiyasi. On Sat, Oct 26, 2019 at 9:17 AM Hossein Ghiyasi Mehr wrote: > If the problem exist still, and all nodes are up, reboot them one by one. > Then try to repair one node. After that repair other nodes one by one. > > On Fri, Oct 25, 2019 at 12:56 AM Ben Mills wrote: > >> >> Thanks

Re: Select statement in batch

2019-10-26 Thread Hossein Ghiyasi Mehr
Hello, Batch isn't for selet only query, it's for transactional queries. If you want to read data, you should use select query (prepared or simple or etc.) On Fri, Oct 11, 2019 at 5:50 PM Inquistive allen wrote: > Hello Team, > > Wanted to understand the impacted of using a select statement

Re: TWCS and gc_grace_seconds

2019-10-26 Thread Hossein Ghiyasi Mehr
It needs to change gc_grace_seconds carefully because it has side effect on hinted handoff. On Fri, Oct 18, 2019 at 5:04 PM Paul Chandler wrote: > Hi Adarsh, > > You will have problems if you manually delete data when using TWCS. > > To fully understand why, I recommend reading this The Last

Re: Repair Issues

2019-10-26 Thread Hossein Ghiyasi Mehr
If the problem exist still, and all nodes are up, reboot them one by one. Then try to repair one node. After that repair other nodes one by one. On Fri, Oct 25, 2019 at 12:56 AM Ben Mills wrote: > > Thanks Jon! > > This is very helpful - allow me to follow-up and ask a question. > > (1) Yes,