Cassandra sometimes throws unauthorized error
<p>We have a multi-node Cassandra cluster and  we use Cassandra python driver for our insert queries. Everything was fine till we removed one of our nodes from the cluster using following command:</p>

<pre><code>nodetool removenode force
</code></pre>

<p>Now our driver meets following error not always but once in a while:</p>

<pre><code>(&lt;class 'cassandra.Unauthorized'&gt;, Unauthorized(u'code=2100 [Unauthorized] message="User username has no MODIFY permission on &lt;table keyspace.tablename&gt; or any of its parents"',), &lt;traceback object at 0x7fe2447910e0&gt;)
</code></pre>

<p>We use same user for all our insert queries and it has all required permissions.</p>

<p>What is our cluster's problem?</p>

<p>More info:
Cassandra version 3.0.0
Python driver version 3.0.0</p>

<p>Since you forced a remove node data may now be inconsistent you should start with a repair on the <code>system_auth</code> keyspace.</p>

<p>I would then follow up with a full repair of all the other keyspaces.</p>

python cassandra unauthorized