Re: Backup solution

2013-03-15 Thread Rene Kochen
Thank you. I have a high bandwidth connection. But that also means that regular repairs on the backup data-center will take a long time. 2013/3/14 Jabbar Azam > Hello, > > If the live data centre disappears restoring the data from the backup is > going to take ages especially if the data is goin

Re: cql query not giving any result.

2013-03-15 Thread Kuldeep Mishra
Hi, Is it possible in Cassandra to make multiple column with same name ?, like in this particular scenario I have two column with same name as "key", first one is rowkey and second on is column name . Thanks and Regards Kuldeep On Fri, Mar 15, 2013 at 4:05 PM, Kuldeep Mishra wrote: > > Hi , >

Re: cql query not giving any result.

2013-03-15 Thread Jason Wee
Here is a list of keywords and whether or not the words are reserved. A reserved keyword cannot be used as an identifier unless you enclose the word in double quotation marks. Non-reserved keywords have a specific meaning in certain context but can be used as an identifier outside this context. ht

Re: cql query not giving any result.

2013-03-15 Thread Sylvain Lebresne
On Fri, Mar 15, 2013 at 11:43 AM, Kuldeep Mishra wrote: > Hi, > Is it possible in Cassandra to make multiple column with same name ?, like > in this particular scenario I have two column with same name as "key", > first one is rowkey and second on is column name . > > No, it shouldn't be possible

Re: cql query not giving any result.

2013-03-15 Thread Kuldeep Mishra
Hi Sylvain, I created it using thrift client, here is column family creation script, Cassandra.Client client; CfDef user_Def = new CfDef(); user_Def.name = "DOCTOR"; user_Def.keyspace = "KunderaExamples"; user_Def.setComparator_type("UTF8Type");

Re: cql query not giving any result.

2013-03-15 Thread Vivek Mishra
Ok. So it's a case when, CQL returns rowkey value as "key" and there is also column present with name as "key". Sounds like a bug? -Vivek On Fri, Mar 15, 2013 at 5:17 PM, Kuldeep Mishra wrote: > Hi Sylvain, > I created it using thrift client, here is column family creation > script, > >

Re: Backup solution

2013-03-15 Thread Aaron Turner
On Fri, Mar 15, 2013 at 3:12 AM, Rene Kochen wrote: > Thank you. I have a high bandwidth connection. But that also means that > regular repairs on the backup data-center will take a long time. Honestly, at this point I don't think anyone can provide you any good feedback based on facts because

Re: Backup solution

2013-03-15 Thread Philip O'Toole
You can consider using a WAN optimization appliance such as a Riverbed Steelhead to significantly speed up your transfers, though that will cost. It is a common approach to speed up inter-datacenter transfers. Steelheads for the AWS EC2 cloud are also available. (Disclaimer: I used to write so

cassandra 1.2.2 build generates slightly different than one on website

2013-03-15 Thread Hiller, Dean
On git, I checkout out tag 1.2.2 and built it and then tar –xvf the bin distro, but it 1. Has extra *.class files in apache-cassandra-1.2.2-SNAPSHOT/bin directory 2. Is missing the cassandra.in.sh so it would not actually start properly? The second one took me a while to figure out. This ma

Re: Backup solution

2013-03-15 Thread Rene Kochen
Hi Aaron, We have many deployments, but typically: - Live cluster of six nodes, replication factor = 3. - A node processes more reads than writes (approximately 100 get_slices per/second, narrow rows). - Data per node is about 50 to 100 GBytes. - We should recover within 4 hours. The idea is to

Re: cassandra 1.2.2 build generates slightly different than one on website

2013-03-15 Thread Sylvain Lebresne
I suspect you are doing something wrong because both the released archive (I just checked) and the tag (as shown here: https://github.com/apache/cassandra/blob/cassandra-1.2.2/bin/cassandra.in.sh) have the cassandra.in.sh file. -- Sylvain On Fri, Mar 15, 2013 at 6:11 PM, Hiller, Dean wrote: >

Re: cassandra 1.2.2 build generates slightly different than one on website

2013-03-15 Thread Hiller, Dean
Very weird. I went back and tried to reproduce it after cleaning all changes from git. I am not sure how that got deleted nor how I ended up with wordcount *.class files since I am not doing any map/reduce or anything…..oh well, must have made a mistake somewhere. Thanks, Dean From: Sylvain

Re: Can't replace dead node

2013-03-15 Thread Andrey Ilinykh
I removed Priam and get the same picture. What I do is- I added to cassandra-env.sh two lines and start cassandra. JVM_OPTS="$JVM_OPTS -Dcassandra.initial_token=aaba" JVM_OPTS="$JVM_OPTS -Dcassandra.replace_token=aaba" Then I can successfu

Re: HintedHandoff IOError?

2013-03-15 Thread Janne Jalkanen
JMX ended up just with lots more IOErrors. Did a rolling restart of the cluster and removed the HH family in the mean time. That seemed to do the trick. Thanks! /Janne On Mar 14, 2013, at 06:58 , aaron morton wrote: >> What is the sanctioned way of removing hints? rm -f HintsColumnFamily*? >

secondary index problem

2013-03-15 Thread Brett Tinling
We have a CF with an indexed column 'type', but we get incomplete results when we query that CF for all rows matching 'type'. We can find the missing rows if we query by key. * we are seeing this on a small, single node, 1.2.2 instance with few rows. * we use thrift execute_cql_query, no CL i

Secondary Indexes

2013-03-15 Thread Andy Stec
We need to provide search capability based on a field that is a bitmap combination of 18 possible values. We want to use secondary indexes to improve performance. One possible solution is to create a named column for each value and have a secondary index for each of the 18 columns. Questions we hav

Re: secondary index problem

2013-03-15 Thread Janne Jalkanen
This could be either of the following bugs (which might be the same thing). I get it too every time I recycle a node on 1.1.10. https://issues.apache.org/jira/browse/CASSANDRA-4973 or https://issues.apache.org/jira/browse/CASSANDRA-4785 /Janne On Mar 15, 2013, at 23:24 , Brett Tinling wrote:

java.lang.OutOfMemoryError: unable to create new native thread

2013-03-15 Thread S C
I have a Cassandra node that is going down frequently with 'java.lang.OutOfMemoryError: unable to create new native thread". Its a 16GB VM out of which 4GB is set as Xmx and there are no other process running on the VM. I have about 300 clients connecting to this node on an average. I have no

Cassandra Compression and Wide Rows

2013-03-15 Thread Drew Kutcharian
Hey Guys, I remember reading somewhere that C* compression is not very effective when most of the CFs are in wide-row format and some folks turn the compression off and use disk level compression as a workaround. Considering that wide rows with composites are "first class citizens" in CQL3, is

Waiting on read repair?

2013-03-15 Thread Jasdeep Hundal
I've got a couple of questions related issues I'm encountering using Cassandra under a heavy write load: 1. With a ConsistencyLevel of quorum, does FBUtilities.waitForFutures() wait for read repair to complete before returning? 2. When read repair applies a mutation, it needs to obtain a lock for

Re: Backup solution

2013-03-15 Thread Aaron Turner
On Fri, Mar 15, 2013 at 10:35 AM, Rene Kochen wrote: > Hi Aaron, > > We have many deployments, but typically: > > - Live cluster of six nodes, replication factor = 3. > - A node processes more reads than writes (approximately 100 get_slices > per/second, narrow rows). > - Data per node is about 50

RE: java.lang.OutOfMemoryError: unable to create new native thread

2013-03-15 Thread S C
I think I figured out where the issue is. I will keep you posted soon. From: as...@outlook.com To: user@cassandra.apache.org Subject: java.lang.OutOfMemoryError: unable to create new native thread Date: Fri, 15 Mar 2013 17:54:25 -0500 I have a Cassandra node that is going down frequently with

Re: Can't replace dead node

2013-03-15 Thread Andrey Ilinykh
More info. I see this problem only if rest of cluster runs 1.1.5 and I try to replace dead node by version 1.1.7 or higher. If I upgrade rest of cluster to the same version (I tried 1.1.10) everything is ok. I guess there is some incompatibility between 1.1.5 and 1.1.7 and higher. Thank you, And

Lots of Deleted Rows Came back after upgrade 1.1.6 to 1.1.10

2013-03-15 Thread Arya Goudarzi
Hi, I have upgraded our test cluster from 1.1.6 to 1.1.10. Followed by running repairs. It appears that the repair task that I executed after upgrade, brought back lots of deleted rows into life. Here are some logistics: - The upgraded cluster started from 1.1.1 -> 1.1.2 -> 1.1.5 -> 1.1.6 - Old c

Cassandra 1.2.1 adding new node

2013-03-15 Thread Daning Wang
I tried to add new node to ring, it is supposed to be fast in 1.2(256 tokens on each node), but it is 8+ hours now. after showing bootstraping, now cpu usage is very low, I turned on debug, it shows applying mutation. is that normal? INFO [main] 2013-03-15 08:36:44,530 StorageService.java (line

Re: Incompatible Gossip 1.1.6 to 1.2.1 Upgrade?

2013-03-15 Thread Arya Goudarzi
Thank you very much Aaron. I recall from the logs of this upgraded node to 1.2.2 reported seeing others as dead. Brandon suggested in https://issues.apache.org/jira/browse/CASSANDRA-5332 that I should at least upgrade from 1.1.7. So, I decided to try upgrading to 1.1.10 first before upgrading to 1.

Re: cql query not giving any result.

2013-03-15 Thread Vivek Mishra
Any suggestions? -Vivek On Fri, Mar 15, 2013 at 5:20 PM, Vivek Mishra wrote: > Ok. So it's a case when, CQL returns rowkey value as "key" and there is > also column present with name as "key". > > Sounds like a bug? > > -Vivek > > > On Fri, Mar 15, 2013 at 5:17 PM, Kuldeep Mishra > wrote: > >>

Re: hinted handoff disabling trade-offs

2013-03-15 Thread Matt Kap
Thanks Aaron. I am using CL=ONE. read_repair_chance=0. The part which I'm wondering about is what happens to the internal Cassandra writes if Hinted Handoffs are disabled. I think I understand what it means for application-level data, but the part I'm not entirely sure about is what it could mean