Re: "READ messages were dropped ... for internal timeout" after big amount of writes

Thank you for the recommendation! Most of pending compactions are for another (~100 times larger) keyspace. They are always running in the background. 2018-03-16 13:28 GMT+05:00 Nicolas Guyomar : > Hi, > > You also have 62 pending compactions at the same time, which is odd for > such a small dat

Delete System_Traces Table

Hi All, I accidentally created a test table on the system_traces keyspace. When I tried to drop the table with the Cassandra user, I got the following error: *Unauthorized: Error from server: code=2100 [Unauthorized] message="Cannot DROP "* Is there a way to drop this table permanently? Thanks!

Re: Delete System_Traces Table

No. Why do you want to? If you don't use tracing they will be empty, and if were able to drop them you will no longer be able to use tracing in debugging. Chris > On Mar 19, 2018, at 7:52 AM, shalom sagges wrote: > > Hi All, > > I accidentally created a test table on the system_traces keysp

Re: Delete System_Traces Table

I think he just wants to delete the test table not the whole keyspace. Is that correct? -- Rahul Singh rahul.si...@anant.us Anant Corporation On Mar 19, 2018, 9:08 AM -0500, Chris Lohfink , wrote: > No. > > Why do you want to? If you don't use tracing they will be empty, and if were > able to

Re: Delete System_Traces Table

Yes, that's correct. I'd definitely like to keep the default tables. On Mon, Mar 19, 2018 at 4:10 PM, Rahul Singh wrote: > I think he just wants to delete the test table not the whole keyspace. Is > that correct? > > -- > Rahul Singh > rahul.si...@anant.us > > Anant Corporation > > On Mar 19, 2

Re: Delete System_Traces Table

Oh I misread original, I see. With https://issues.apache.org/jira/browse/CASSANDRA-13813 you wont be able to drop the table, but would be worth a ticket to prevent creation in those keyspaces or allow some sort of override if allowing crea

Re: Delete System_Traces Table

That's weird... I'm using 3.0.12, so I should've still been able to drop it, no? Also, if I intend to upgrade to version 3.11.2, will the existence of the table cause any issues? Thanks! On Mon, Mar 19, 2018 at 4:30 PM, Chris Lohfink wrote: > Oh I misread original, I see. > > With https://issu

Re: Delete System_Traces Table

traces and auth in that version have a whitelist of tables that can be dropped (legacy auth tables). https://github.com/apache/cassandra/blob/cassandra-3.0.12/src/java/org/apache/cassandra/service/ClientState.java#L367

Re: Delete System_Traces Table

Thanks a lot Chris and Rahul! On Mon, Mar 19, 2018 at 5:54 PM, Chris Lohfink wrote: > traces and auth in that version have a whitelist of tables that can be > dropped (legacy auth tables). > > https://github.com/apache/cassandra/blob/cassandra-3.0. > 12/src/java/org/apache/cassandra/service/Clie

Re: Cassandra 2.1 on Xenial

Yep. This was fixed for 2.1.15, 2.2.7, 3.0.6, 3.6 in https://issues.apache.org/jira/browse/CASSANDRA-10853 -- Kind regards, Michael On 03/18/2018 10:55 PM, Cyril Scetbon wrote: > Okay I found that when building the package, the new helper dh_python2 > must be used to fix that issue. > > — > Cyr