Nodetool repair with Load times 5

Hi, I have a phenomena I cannot explain, and I would like to understand. I’m running Cassandra 2.1.8 on a cluster of 5 nodes. I’m using replication factor 3, with most default settings. Last week I done a nodetool status which gave me on each node a load of about 200 GB. Since then there was no

Null pointer exception after delete in a table with statics

Hello, I have an issue with a when I query a table with static fields (without where clause) with Cassandra 2.1.8 / 2 nodes clusters. No more indication in the log : ERROR [SharedPool-Worker-1] 2015-08-18 10:39:02,549 QueryMessage.java:132 - Unexpected error during query java.lang.NullPo

Re: Nodetool repair with Load times 5

Hey Jean, Did you try running a nodetool cleanup on all your nodes, perhaps one at a time? On Tue, Aug 18, 2015 at 3:59 AM, Jean Tremblay < jean.tremb...@zen-innovations.com> wrote: > Hi, > > I have a phenomena I cannot explain, and I would like to understand. > > I’m running Cassandra 2.1.8 on

Re: Nodetool repair with Load times 5

No. I did not try. I would like to understand what is going on before I make my problem, maybe even worse. I really would like to understand: 1) Is this normal? 2) What is the meaning of the column Load? 3) Is there anything to fix? Can I leave it like that? 4) Did I do something wrong? Wh

Re: Null pointer exception after delete in a table with statics

Weird, you issue makes me remember of https://issues.apache.org/jira/browse/CASSANDRA-8502 but it seems that it has been fixed since 2.1.6 and you're using 2.1.8 Can you try to reproduce it using small page with Spark (spark.cassandra.input.fetch.size_in_rows) ? On Tue, Aug 18, 2015 at 11:50 AM,

Question: Coordinator in cassandra

Hi all; Please with the version cassandra 2.0.6, we have by default one coordinator per data center, per client or per query ? Thank you so much for help. Kind Regards.

Re: Nodetool repair with Load times 5

Hi Jean, I might help, but I need to know what you have done recently (change the RF, Add remove node, cleanups, anything else as much as possible...) Also, could you please do the "nodetool status *myks*" for your keyspace(s) ? We will then be able to know the theoretical ownership of each node

Re: How to run any application on Cassandra cluster in high availability mode

Hi John, I have posted the same Q on azkaban google group but there is no response so far :( If i want to do the old school way of monitor, alert and start the process somewhere else..how can I do this? Are there some ready made tools to do this kind of general purpose monitoring and alerting for s

sstablescrub for unreadable sstables?

Two questions really: 1) Is there a way to search the archives https://mail-archives.apache.org/mod_mbox/cassandra-user/ or another better approach to searching for Cassandra answers such as #2? 2) I have the following error in /var/log/cassandra/cassandra.log - cassandra dies after "service cass

Re: How to run any application on Cassandra cluster in high availability mode

Off-topic to the Cassandra list, but corosync/pacemaker comes to mind for automatic service switchover between nodes. For monitoring and alerting, there's almost too many to mention... On Tue, Aug 18, 2015 at 2:45 PM, Vikram Kone wrote: > Hi John, > I have posted the same Q on azkaban googl

Re: sstablescrub for unreadable sstables?

For key cache files (which you have below – note ‘cassandra_saved_caches’ and -KeyCache– ), the safest thing to do is to simply remove them (move them aside or delete them). They’re simple caches, and they’ll be recreated shortly after starting. - Jeff From: David Paulsen Reply-To: "user@cas

RE: Question: Coordinator in cassandra

Hi Thouraya, In all versions of Cassandra, each query will have one coordinator. Any node in the cluster can be the coordinator and this is choice is made by the client/driver. The coordinator may or may not have a replica of the data being requested. Cheers, Alec Collier | Workplace Service