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
