RE: Question: Coordinator in cassandra

2015-08-18 Thread Alec Collier
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

Re: sstablescrub for unreadable sstables?

2015-08-18 Thread Jeff Jirsa
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: How to run any application on Cassandra cluster in high availability mode

2015-08-18 Thread Ken Hancock
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

sstablescrub for unreadable sstables?

2015-08-18 Thread David Paulsen
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

2015-08-18 Thread Vikram Kone
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

Re: Nodetool repair with Load times 5

2015-08-18 Thread Alain RODRIGUEZ
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

Question: Coordinator in cassandra

2015-08-18 Thread Thouraya TH
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: Null pointer exception after delete in a table with statics

2015-08-18 Thread DuyHai Doan
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,

Re: Nodetool repair with Load times 5

2015-08-18 Thread Jean Tremblay
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: Nodetool repair with Load times 5

2015-08-18 Thread Mark Greene
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

Null pointer exception after delete in a table with statics

2015-08-18 Thread Hervé Rivière
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

Nodetool repair with Load times 5

2015-08-18 Thread Jean Tremblay
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