Re: Cannot achieve consistency level LOCAL_ONE

2017-07-09 Thread Justin Cameron
It's best-practice to disable the default user ("cassandra" user) after enabling password authentication on your cluster. The default user reads with a CL.QUORUM when authenticating, while other users use CL.LOCAL_ONE. This means it's more likely you could experience authentication issues, even if

Re: Cannot achieve consistency level LOCAL_ONE

2017-07-07 Thread Oleksandr Shulgin
On Thu, Jul 6, 2017 at 6:58 PM, Charulata Sharma (charshar) < chars...@cisco.com> wrote: > Hi, > > I am facing similar issues with SYSTEM_AUTH keyspace and wanted to know > the implication of disabling the "*cassandra*" superuser. > Unless you have scheduled any tasks that require the user with

Re: Cannot achieve consistency level LOCAL_ONE

2017-07-06 Thread Charulata Sharma (charshar)
t; Date: Wednesday, June 14, 2017 at 2:16 AM To: Oleksandr Shulgin <oleksandr.shul...@zalando.de<mailto:oleksandr.shul...@zalando.de>> Cc: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" <user@cassandra.apache.org<mailto:user@cassandra.apac

Re: Cannot achieve consistency level LOCAL_ONE

2017-06-14 Thread wxn...@zjqunshuo.com
Thanks for the detail explanation. You did solve my problem. Cheers, -Simon From: Oleksandr Shulgin Date: 2017-06-14 17:09 To: wxn...@zjqunshuo.com CC: user Subject: Re: Cannot achieve consistency level LOCAL_ONE On Wed, Jun 14, 2017 at 10:46 AM, wxn...@zjqunshuo.com <wxn...@zjqunshuo.

Re: Cannot achieve consistency level LOCAL_ONE

2017-06-14 Thread Oleksandr Shulgin
On Wed, Jun 14, 2017 at 10:46 AM, wxn...@zjqunshuo.com wrote: > Thanks for the reply. > My system_auth settings is as below and what should I do with it? And I'm > interested why the newly added node is responsible for the user > authentication? > > CREATE KEYSPACE

Re: Cannot achieve consistency level LOCAL_ONE

2017-06-14 Thread wxn...@zjqunshuo.com
'} AND durable_writes = true; -Simon From: Oleksandr Shulgin Date: 2017-06-14 16:36 To: wxn...@zjqunshuo.com CC: user Subject: Re: Cannot achieve consistency level LOCAL_ONE On Wed, Jun 14, 2017 at 9:11 AM, wxn...@zjqunshuo.com <wxn...@zjqunshuo.com> wrote: Hi, Cluster set up: 1 DC with 5 nodes (each node

Re: Cannot achieve consistency level LOCAL_ONE

2017-06-14 Thread Oleksandr Shulgin
On Wed, Jun 14, 2017 at 9:11 AM, wxn...@zjqunshuo.com wrote: > Hi, > Cluster set up: > 1 DC with 5 nodes (each node having 700GB data) > 1 kespace with RF of 2 > write CL is LOCAL_ONE > read CL is LOCAL_QUORUM > > One node was down for about 1 hour because of OOM issue.