Ken, Alain is right about the system tables. What you're describing only works on non-local tables. Changing the CL doesn't help with keyspaces that use LocalStrategy. Here's the definition of the system keyspace:
CREATE KEYSPACE system WITH replication = {'class': 'LocalStrategy'} AND durable_writes = true; Jon On Thu, Apr 4, 2019 at 9:03 AM Kenneth Brotman <kenbrot...@yahoo.com.invalid> wrote: > > The trick below I got from the book Mastering Cassandra. You have to set the > consistency to ALL for it to work. I thought you guys knew that one. > > > > From: Alain RODRIGUEZ [mailto:arodr...@gmail.com] > Sent: Thursday, April 04, 2019 8:46 AM > To: user cassandra.apache.org > Subject: Re: Assassinate fails > > > > Hi Alex, > > > > About previous advices: > > > > You might have inconsistent data in your system tables. Try setting the > consistency level to ALL, then do read query of system tables to force repair. > > > > System tables use the 'LocalStrategy', thus I don't think any repair would > happen for the system.* tables. Regardless the consistency you use. It should > not harm, but I really think it won't help. > > --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org For additional commands, e-mail: user-h...@cassandra.apache.org