Re: Seed nodes and bootstrap (was: Re: Initializing a multiple node cluster (multiple datacenters))

2018-02-26 Thread Oleksandr Shulgin
On Mon, Feb 26, 2018 at 7:05 PM, Jeff Jirsa wrote: > > I'll happily click the re-open button (you could have, too), but I'm not > sure what the 'right' fix is. Feel free to move discussion to 5836. > Thanks, Jeff. Somehow, I don't see any control elements to change issue

Re: Data Deleted After a few days of being off

2018-02-26 Thread Oleksandr Shulgin
On Tue, Feb 27, 2018 at 7:37 AM, A wrote: > > I started going through the logs and haven't noticed anything yet... Very > unexpected behavior. > Maybe I'm asking the obvious, but were your inserts *without* a TTL? -- Alex

Re: Data Deleted After a few days of being off

2018-02-26 Thread @Nandan@
Please check your error.log file once. As you checked it means Your data is not coming into Data file. I will suggest you to check your error.log file once. On Tue, Feb 27, 2018 at 2:37 PM, A wrote: > Hey there. Thanks for your response. > > Yes. I absolutely inserted

Re: Data Deleted After a few days of being off

2018-02-26 Thread Justin Cameron
Cassandra data files are located at /var/lib/cassandra/data ( http://cassandra.apache.org/doc/latest/configuration/cassandra_config_file.html#data-file-directories ) Can you double check that the Cassandra process has write access to this directory? There should be a number of SSTable files in

Re: Data Deleted After a few days of being off

2018-02-26 Thread A
blockquote, div.yahoo_quoted { margin-left: 0 !important; border-left:1px #715FFA solid !important; padding-left:1ex !important; background-color:white !important; } Hey there. Thanks for your response. Yes.  I absolutely inserted the data correctly and queried it many times through cqlsh> as

Re: Cassandra Summit 2019 / Cassandra Summit 2018

2018-02-26 Thread Jeff Jirsa
Instaclustr sponsored the 2017 NGCC (Next Gen Cassandra Conference), which was developer/development focused (vs user focused). For 2018, we're looking at options for both a developer conference and a user conference. There's a lot of logistics involved, and I think it's fairly obvious that most

Re: Data Deleted After a few days of being off

2018-02-26 Thread @Nandan@
Hi A, As I am able to understand your question :- 1) You inserted some data into your table and that was inserted successfully. 2) Then you stop the cassandra servie. 3) After few days you started your service and you checked your Table and there were no data. Did you cross verified once you

Data Deleted After a few days of being off

2018-02-26 Thread A
I'm new to Cassandra.  Trying it out to see if it will work for my upcoming project.  I created a test keyspace and table on my dev laptop.  Loaded it with some data on a Friday and closed her down.  Returned on Monday and looked up the data and it was gone.  The keyspace and table was there,

Re: Cassandra Summit 2019 / Cassandra Summit 2018

2018-02-26 Thread Rahul Singh
I think some of the Instaclustr folks had done one last year which I really wanted to go to.. Distributed / Async both would be easier to get people to write papers, make slides, do youtube videos with.. and then we could do a virtual web conf of the best submissions. On Feb 26, 2018, 1:04 PM

RE: Filling in the blank To Do sections on the Apache Cassandra web site

2018-02-26 Thread Kenneth Brotman
Here are the related JIRA’s. Please add content even if It’s not well formed compositionally. Myself or someone else will take it from there. https://issues.apache.org/jira/browse/CASSANDRA-14274 The troubleshooting section of the web site is empty

RE: Filling in the blank To Do sections on the Apache Cassandra web site

2018-02-26 Thread Kenneth Brotman
Nice! Thanks for the help Oliver! Kenneth Brotman From: Oliver Ruebenacker [mailto:cur...@gmail.com] Sent: Sunday, February 25, 2018 7:12 AM To: user@cassandra.apache.org Cc: d...@cassandra.apache.org Subject: Re: Filling in the blank To Do sections on the Apache Cassandra web site

Add explaination of vNodes to online documentation

2018-02-26 Thread Kenneth Brotman
JIRA 14265 Add explanation of vNodes to online documentation: https://issues.apache.org/jira/browse/CASSANDRA-14265 A lot of inquiries on the mailing list about how vNodes work and how to set configuration properly. We should add and explanation to the documentation. Kenneth Brotman

RE: Gathering / Curating / Organizing Cassandra Best Practices & Patterns

2018-02-26 Thread Kenneth Brotman
Eric, My tone changed as I studied in more detail the thread. He begin with a well-intended but ill-advised inquiry, very public inquiry at that which itself was problematic. It’s not a board member’s place to push their weight around like that. That’s board member training 101. Not his

Re: Gathering / Curating / Organizing Cassandra Best Practices & Patterns

2018-02-26 Thread Eric Plowe
*Kenneth, * How did you get "caught in the middle" of this "stuff"? You are the one bringing it up? Also, your tone switched between calling Chris a "well intended ASF" board member, to calling him an "idiot". He asked a perfectly reasonable question, and then other questions followed as a

The home page of Cassandra is mobile friendly but the link to the third parties is not

2018-02-26 Thread Kenneth Brotman
The home page of Cassandra is mobile friendly but the link to the third parties from that web page is not. Any suggestions? I made a JIRA for it: https://issues.apache.org/jira/browse/CASSANDRA-14263 Should posts about JIRA's be on this list or the dev list? Kenneth Brotman

Cassandra Summit 2019 / Cassandra Summit 2018

2018-02-26 Thread Kenneth Brotman
Is there any planning yet for a Cassandra Summit 2019 or Cassandra Summit 2018 (probably too late)? Is there a planning committee? Who wants there to be a Cassandra Summit 2019 and who thinks there is a better way? We could try a Cassandra Distributed Summit 2019 where we meet

Re: Seed nodes and bootstrap (was: Re: Initializing a multiple node cluster (multiple datacenters))

2018-02-26 Thread Jeff Jirsa
That ticket was before I was really active contributing, but I tend to agree with your assessment: clearly there's pain point there, and we can do better than the status quo. The problem (as Jonathan notes) is that its a complicated subsystem, and the "obvious" fix probably isn't as obvious as it

Re: How to Parse raw CQL text?

2018-02-26 Thread Jon Haddad
Yes ideally. I’ve been spending a bit of time in the parser the last week. There’s a lot of internals which are still using old terminology and are pretty damn confusing. I’m doing a little investigation into exposing some of the information while also modernizing it. > On Feb 26, 2018,

Re: How to Parse raw CQL text?

2018-02-26 Thread Hannu Kröger
If this is needed functionality, shouldn’t that be available as a public method or something? Maybe write a patch etc. ? > Ariel Weisberg kirjoitti 26.2.2018 kello 18.47: > > Hi, > > I took a similar approach and it worked fine. I was able to build a tool that > parsed

Re: How to Parse raw CQL text?

2018-02-26 Thread Kant Kodali
wouldn't it make sense to expose the parser at some point? On Mon, Feb 26, 2018 at 9:47 AM, Ariel Weisberg wrote: > Hi, > > I took a similar approach and it worked fine. I was able to build a tool > that parsed production query logs. > > I used a helper method that would just

Re: How to Parse raw CQL text?

2018-02-26 Thread Ariel Weisberg
Hi, I took a similar approach and it worked fine. I was able to build a tool that parsed production query logs. I used a helper method that would just grab a private field out of an object by name using reflection. Ariel On Sun, Feb 25, 2018, at 11:58 PM, Jonathan Haddad wrote: > I had to do

RE: Gathering / Curating / Organizing Cassandra Best Practices & Patterns

2018-02-26 Thread Kenneth Brotman
I got caught in the middle of this stuff. I feel for everyone. I said my two cents. I had to vent. I’m back to concentrating on helping the group. Kenneth Brotman From: Eric Evans [mailto:john.eric.ev...@gmail.com] Sent: Monday, February 26, 2018 9:16 AM To:

Re: Gathering / Curating / Organizing Cassandra Best Practices & Patterns

2018-02-26 Thread Eric Evans
On Sun, Feb 25, 2018 at 8:45 AM, Kenneth Brotman < kenbrot...@yahoo.com.invalid> wrote: > Chris Mattmann acted without authority and completely improperly as an > Apache Software Foundation board member as a board member on their own has > no authority. Their authority is to participate and vote

Re: vnodes status verification

2018-02-26 Thread Hannu Kröger
Hello, you can always run “nodetool ring” to see all tokens. Hannu > On 26 Feb 2018, at 12:32, Ivan Iliev wrote: > > Hello C* Gurus, > > I am quite new to cassandra so I am struggling over the concent of vnodes and > how to verify if those are properly enabled on my

vnodes status verification

2018-02-26 Thread Ivan Iliev
Hello C* Gurus, I am quite new to cassandra so I am struggling over the concent of vnodes and how to verify if those are properly enabled on my cluster. I have the num_tokens in yaml set to 256 across all nodes and initial_token is commented out of the config. Apart from that I cannot find any

Re: Cassandra Hints monitoring

2018-02-26 Thread Jai Bheemsen Rao Dhanwada
This works when the count value is changing/increasing. In my case if the Hints total value is 10 for 2 hours, the difference(sum("TotalHints_Count")) is going to be 10 for that 10 seconds time period and then it will be 0 later on. where as the value should be constantly 10 until there is a

Re: Cassandra Hints monitoring

2018-02-26 Thread Nicolas Guyomar
I find DIFFERENCE to be working for dropped mutation, which IMHO works the same way as Hint metrics *select difference(sum("Dropped_Count")) FROM "cassandraDroppedMessage" groupby host* is valid when I check with nodetool over a period of time Not sure what is not working on your side On 26

Re: Cassandra Hints monitoring

2018-02-26 Thread Jai Bheemsen Rao Dhanwada
DIFFERENCE may not work here, if the Hints count is 10 for few hours, the difference is always is zero. which is not the correct value. On Mon, Feb 26, 2018 at 1:18 AM, Jai Bheemsen Rao Dhanwada < jaibheem...@gmail.com> wrote: > Thanks Alex, > > Let me try it. > > > On Monday, February 26, 2018,

Re: hardware sizing for insert only scenarios

2018-02-26 Thread Nicolas Guyomar
Hi, Before looking for a sizing, have you try looking for application side compression before inserting you data (this paper is really interresting https://aaltodoc.aalto.fi/bitstream/handle/123456789/29099/master_Burman_ Michael_2017.pdf?sequence=1 ) ? For timeseries use case this is a major

Re: Cassandra Hints monitoring

2018-02-26 Thread Jai Bheemsen Rao Dhanwada
Thanks Alex, Let me try it. On Monday, February 26, 2018, Oleksandr Shulgin < oleksandr.shul...@zalando.de> wrote: > On Mon, Feb 26, 2018 at 10:02 AM, Jai Bheemsen Rao Dhanwada < > jaibheem...@gmail.com> wrote: > >> Thank you Alex, >> >> I tried "TotalHintsInProgress" already, and I don't see

Re: Cassandra Hints monitoring

2018-02-26 Thread Oleksandr Shulgin
On Mon, Feb 26, 2018 at 10:02 AM, Jai Bheemsen Rao Dhanwada < jaibheem...@gmail.com> wrote: > Thank you Alex, > > I tried "TotalHintsInProgress" already, and I don't see it sending the > correct metrics. I used mean("TotalHintsInProgress") and I see 0 always > on grafana. > Do you know what is

Re: Cassandra Hints monitoring

2018-02-26 Thread Jai Bheemsen Rao Dhanwada
Thank you Alex, I tried "TotalHintsInProgress" already, and I don't see it sending the correct metrics. I used mean("TotalHintsInProgress") and I see 0 always on grafana. Do you know what is the correct way to do rate or diff for hints using "TotalHints"? I am currently using the below query

hardware sizing for insert only scenarios

2018-02-26 Thread onmstester onmstester
Another Question on node density, in this scenario: 1. we should keep time series data of some years for a heavy write system in Cassandra ( 10K Ops in seconds) 2. the system is insert only and inserted data would never be updated 3. in partition key, we used number of months since 1970, so

Seed nodes and bootstrap (was: Re: Initializing a multiple node cluster (multiple datacenters))

2018-02-26 Thread Oleksandr Shulgin
On Fri, Feb 23, 2018 at 7:35 PM, Jeff Jirsa wrote: > It comes up from time to time. Rob Coli spent years arguing that this > behavior was confusing ( https://issues.apache.org/ > jira/browse/CASSANDRA-5836 ) , especially in the "I'm replacing a failed > seed" sense. It also

Re: Cassandra Hints monitoring

2018-02-26 Thread Oleksandr Shulgin
On Mon, Feb 26, 2018 at 8:21 AM, Jai Bheemsen Rao Dhanwada < jaibheem...@gmail.com> wrote: > > I am trying to evaluate the JMX hints metrics for cassandra(TotalHints). > However, when I am testing the metrics, the total hints accumulated count > shows perfectly fine, but when the hints are