Re: LTCS Strategy Resulting in multiple SSTables

2015-09-15 Thread Nate McCall
That's an early 2.1/known buggy version. There have been several issues fixed since which could cause that behavior. Most likely https://issues.apache.org/jira/browse/CASSANDRA-9592 ? Upgrade to 2.1.9 and see if the problem persists. On Tue, Sep 15, 2015 at 8:31 AM, Saladi Naidu

[ANNOUNCE] Apache Gora 0.6.1 Release

2015-09-15 Thread lewis john mcgibbney
Hi All, The Apache Gora team are pleased to announce the immediate availability of Apache Gora 0.6.1. What is Gora? Gora is a framework which provides an in-memory data model and persistence for big data. Gora supports persisting to column stores, key value stores, document stores and RDBMSs,

Re: Possible to restore ENTIRE data from Cassandra-Schema in one go?

2015-09-15 Thread Ajay Garg
Thanks Mam for the reply. I guess there is manual work needed to bring all the SSTables files into one directory, so doesn't really solve the purpose I guess. So, going the "vanilla" way might be simpler :) Thanks anyways for the help !!! Thanks and Regards, Ajay On Tue, Sep 15, 2015 at 11:34

Re: LTCS Strategy Resulting in multiple SSTables

2015-09-15 Thread Marcus Eriksson
if you are on Cassandra 2.2, it is probably this: https://issues.apache.org/jira/browse/CASSANDRA-10270 On Tue, Sep 15, 2015 at 4:37 AM, Saladi Naidu wrote: > We are using Level Tiered Compaction Strategy on a Column Family. Below > are CFSTATS from two nodes in same

Re: Getting intermittent errors while taking snapshot

2015-09-15 Thread Ajay Garg
Hi All. Granting complete-permissions to the keyspace-folder (/var/lib/cassandra/data/instamsg) fixed the issue. Now, multiple, successive snapshot-commands run to completion fine. sudo chmod -R 777 /var/lib/cassandra/data/instamsg

Cassandra adding node issue (no UJ status)

2015-09-15 Thread Rock Zhang
Hi All, Now I got a problem everything when add new node, the data is not balance again, just add it as new node. Originally I saw the UJ status, anybody experienced this kind of issue ? I don't know what changed . ubuntu@ip-172-31-15-242:/etc/cassandra$ nodetool status rawdata Datacenter:

Re: Possible to restore ENTIRE data from Cassandra-Schema in one go?

2015-09-15 Thread Neha Dave
Havent used it.. but u can try SSTaable Bulk Loader: http://docs.datastax.com/en/cassandra/2.0/cassandra/tools/toolsBulkloader_t.html regards Neha On Tue, Sep 15, 2015 at 11:21 AM, Ajay Garg wrote: > Hi All. > > We have a schema on one Cassandra-node, and wish to

Getting intermittent errors while taking snapshot

2015-09-15 Thread Ajay Garg
Hi All. Taking snapshots sometimes works, sometimes don't. Following is the stacktrace whenever the process fails :: ## ajay@ajay-HP-15-Notebook-PC:/var/lib/cassandra/data/instamsg$ nodetool -h localhost

RE: Using DTCS, TTL but old SSTables not being removed

2015-09-15 Thread Jacques-Henri Berthemet
Hi, Any idea when 2.2.2 will be released? I see there are still 3 issues left to fix: https://issues.apache.org/jira/browse/CASSANDRA/fixforversion/1219/?selectedTab=com.atlassian.jira.jira-projects-plugin:version-summary-panel -- Jacques-Henri Berthemet -Original Message- From:

Re: Tag filtering data model

2015-09-15 Thread Carlos Alonso
Really interesting question Artur. Have you gone any further? I think, based on my experience and recalling Cassandra's good practices, that full denormalisation is the Cassandra way to go. Cheers Carlos Alonso | Software Engineer | @calonso On 11 September 2015

Currupt sstables when upgrading from 2.1.8 to 2.1.9

2015-09-15 Thread George Sigletos
Hello, I tried to upgrade two of our clusters from 2.1.8 to 2.1.9. In some, but not all nodes, I got errors about corrupt sstables when restarting. I downgraded back to 2.1.8 for now. Has anybody else faced the same problem? Should sstablescrub fix the problem? I ddin't tried that yet. Kind

Re: Currupt sstables when upgrading from 2.1.8 to 2.1.9

2015-09-15 Thread Nate McCall
You have a/some corrupt SSTables. 2.1.9 is doing strict checking at startup and reacting based on "disk_failure_policy" per the stack trace. For details, see: https://issues.apache.org/jira/browse/CASSANDRA-9686 Either way, you are going to have to run nodetool scrub. I'm not sure if it's better

Re: Concurrency in Cassandra

2015-09-15 Thread Jonathan Haddad
You may want to take an hour and watch a video on Cassandra fundamentals. It'll answer a lot of the questions you're likely to ask next, including this one. https://academy.datastax.com/courses/ds101-introduction-cassandra On Tue, Sep 15, 2015 at 2:04 PM Thouraya TH wrote:

Concurrency in Cassandra

2015-09-15 Thread Thouraya TH
Hi all; Please, is it possible to use insert queries in parallel at the same time in two different nodes ? Or, i will a concurrency problem ? Thanks you so much for answers. Best regards.

Re: LTCS Strategy Resulting in multiple SSTables

2015-09-15 Thread Saladi Naidu
We are on 2.1.2 and planning to upgrade to 2.1.9  Naidu Saladi From: Marcus Eriksson To: user@cassandra.apache.org; Saladi Naidu Sent: Tuesday, September 15, 2015 1:53 AM Subject: Re: LTCS Strategy Resulting in multiple SSTables if you

Re: Cassandra adding node issue (no UJ status)

2015-09-15 Thread Sebastian Estevez
Check https://issues.apache.org/jira/browse/CASSANDRA-8611 All the best, [image: datastax_logo.png] Sebastián Estévez Solutions Architect | 954 905 8615 | sebastian.este...@datastax.com [image: linkedin.png] [image:

Re: Cassandra adding node issue (no UJ status)

2015-09-15 Thread Mark Greene
Hey Rock, I've seen this occur as well. I've come to learn that in some cases, like a network blip, the join can fail. There is usually something in the log to the effect of "Stream failed" When I encounter this issue, I make an attempt to bootstrap the new node again. If that doesn't help, I

Secondary index is causing high CPU load

2015-09-15 Thread Tom van den Berge
Read queries on a secondary index are somehow causing an excessively high CPU load on all nodes in my DC. The table has some 60K records, and the cardinality of the index is very low (~10 distinct values). The returned result set typically contains 10-30K records. The same queries on nodes in