kill session in cassandra cluster

2021-01-06 Thread David Ni
Hello,Experts! I want to know if there is a way to kill the session in cassandra cluster,for example,I get session_id from system_traces.sessions:4c9049a0-4fed-11eb-a60d-7f98ffdaf6cd,the session is running with very bad cql which causing bad performance,I need to kill it ASAP,could

Re:Re:Re: Re: Re: unconfigured table logtabl

2020-04-05 Thread David Ni
Hi Erick Thank you very much for your friendly note. ERROR [AntiEntropyStage:1] 2020-04-04 13:57:09,614 RepairMessageVerbHandler.java:177 - Table with id 21a3fa90-74c7-11ea-978a-b556b0c3a5ea was dropped during prepare phase of repair cassandra@cqlsh:system_schema> select

Re:Re: Re: Re: unconfigured table logtabl

2020-04-04 Thread David Ni
Thank you very much for your friendly note. ERROR [AntiEntropyStage:1] 2020-04-04 13:57:09,614 RepairMessageVerbHandler.java:177 - Table with id 21a3fa90-74c7-11ea-978a-b556b0c3a5ea was dropped during prepare phase of repair cassandra@cqlsh:system_schema> select keyspace_name,table_name,id

Re:Re: Re: unconfigured table logtabl

2020-04-04 Thread David Ni
Hi Erick here is the log from system.log but when I desc keyspace the table is still there At 2020-04-04 11:56:15, "Erick Ramirez" wrote: And from your review of the logs, what was the cause of the repair failures? Because that's likely to yield clues on the root cause.

unconfigured table logtabl

2020-04-03 Thread David Ni
Hello experts: I am using cassandra 3.11.2 and having below problem: cassandra@cqlsh> select * from oapi_dev.logtabl; InvalidRequest: Error from server: code=2200 [Invalid query] message="unconfigured table logtabl" but when I descrbibe keyspace,it shows in the result:

Re:RE: Re:RE: data not beening syncd in different nodes

2018-09-02 Thread David Ni
quickly so that results may differ even for 2 consecutive queries. How about this theory? CL in your driver – depends on which CL is default for your particular driver. Regards, Kyrill From: David Ni Sent: Friday, August 31, 2018 12:53 PM To:user@cassandra.apache.org Subject: Re:RE: data n

Re:RE: data not beening syncd in different nodes

2018-08-31 Thread David Ni
As you use TimeWindowCompactionStrategy, do you insert data with TTL? These buckets seem to be too small for me: 'compaction_window_size': '2', 'compaction_window_unit': 'MINUTES'. Do you have such a huge amount of writes so that such bucket size makes sense? Regards, Kyrill From: David Ni Sent: Friday, August 3

data not beening syncd in different nodes

2018-08-31 Thread David Ni
Hi Experts, I am using 3.9 cassandra in production environment,we have 6 nodes,the RF of keyspace is 3, I have a table which below definition: CREATE TABLE nev_prod_tsp.heartbeat ( vin text PRIMARY KEY, create_time timestamp, pkg_sn text, prot_ver text, trace_time