Re: 0.7RC1 cassandra-env.sh or cassandra.in.sh?

2010-12-03 Thread Nate McCall
The double JVM option was a side effect of https://issues.apache.org/jira/browse/CASSANDRA-1771 and will be addressed with the next release. The rpm uses the cassandra.in.sh from the debian directory for convenience. The instance of cassandra-env.sh in /usr/share/cassandra/conf is kept as a refere

Re: Set an index on column

2010-12-03 Thread Joshua Partogi
Thanks for the confirmation. Cheers. On Sat, Dec 4, 2010 at 3:34 PM, Jonathan Ellis wrote: > Looks like it was actually after rc1 artifacts were tagged and rolled > (but before it was released). So the fix will be in rc2, or you can > grab the 0.7 branch from svn before then. > > On Fri, Dec 3

Re: Confused about consistency

2010-12-03 Thread Dan Hendry
Doesn't consistency level ALL=QUORUM at RF=2 ? I have not had a chance to test your fix but I don't THINK this is the issue. If it is the issue, how do consistency levels ALL and QUORUM differ at this replication factor? On Sat, Dec 4, 2010 at 12:03 AM, Jonathan Ellis wrote: > I think you are r

Re: Confused about consistency

2010-12-03 Thread Jonathan Ellis
I think you are running into https://issues.apache.org/jira/browse/CASSANDRA-1316, where when an inconsistency on QUORUM/ALL is discovered it always peformed the repair at QUORUM instead of the original CL. Thus, reading at ALL you would see the correct answer on the 2nd read but you weren't guara

Re: Dont bogart that connection my friend

2010-12-03 Thread Jonathan Ellis
That makes sense, but this shouldn't make requests last for the timeout duration -- at quorum, it should be responding to the client as soon as it gets that second-fastest reply. If I'm understanding right that this was making the response to the client block until the overwhelmed node timed out,

Re: Set an index on column

2010-12-03 Thread Jonathan Ellis
Looks like it was actually after rc1 artifacts were tagged and rolled (but before it was released). So the fix will be in rc2, or you can grab the 0.7 branch from svn before then. On Fri, Dec 3, 2010 at 6:44 PM, Tyler Hobbs wrote: > Sounds like 1764: > > https://issues.apache.org/jira/browse/CAS

Confused about consistency

2010-12-03 Thread Dan Hendry
I am seeing fairly strange, behavior in my Cassandra cluster. Setup - 3 nodes (lets call them nodes 1 2 and 3) - RF=2 - A set of servers (producers) which which write data to the cluster at consistency level ONE - A set of servers (consumers/processors) which read data from the cluster at cons

Re: how to see how many rows in each node?

2010-12-03 Thread Edward Capriolo
On Fri, Dec 3, 2010 at 12:53 PM, Robert Coli wrote: > On 12/3/10 6:09 AM, Jonathan Ellis wrote: >> >> Divide space used by average row size from cfstats >> >> On Fri, Dec 3, 2010 at 7:58 AM, Donal Zang  wrote: >>> >>> RT. >>> Is there any command or api? > > In 0.6.x : > > strings /path/to/cassand

Re: Dont bogart that connection my friend

2010-12-03 Thread Daniel Doubleday
Yes. I thought that would make sense, no? I guessed that the quorum read forces the slowest of the 3 nodes to keep the pace of the faster ones. But it cant. No matter how small the performance diff is. So it will just fill up. Also when saying 'practically dead' and 'never recovers' I meant

Re: Set an index on column

2010-12-03 Thread Tyler Hobbs
Sounds like 1764: https://issues.apache.org/jira/browse/CASSANDRA-1764 This was fixed in RC1. - Tyler On Fri, Dec 3, 2010 at 5:43 PM, Joshua Partogi wrote: > Hi Jonathan, > > Thanks for the hint. This is the error that I get: > ERROR [pool-1-thread-1] 2010-12-04 09:38:20,521 Cassandra.java (l

Re: Set an index on column

2010-12-03 Thread Joshua Partogi
Hi Jonathan, Thanks for the hint. This is the error that I get: ERROR [pool-1-thread-1] 2010-12-04 09:38:20,521 Cassandra.java (line 3596) Internal error processing system_update_column_family java.lang.NullPointerException at org.apache.cassandra.config.CFMetaData.apply(CFMetaData.java:665)

Re: Dont bogart that connection my friend

2010-12-03 Thread Jonathan Ellis
Am I understanding correctly that you had all connections going to one cassandra node, which caused one of the *other* nodes to die, and spreading the connections around the cluster fixed it? On Fri, Dec 3, 2010 at 4:00 AM, Daniel Doubleday wrote: > Hi all > > I have found an anti pattern the oth

Re: Get CF with where condition supplied by cassandra-cli

2010-12-03 Thread Jonathan Ellis
http://www.riptano.com/blog/whats-new-cassandra-07-secondary-indexes On Thu, Dec 2, 2010 at 9:34 AM, Yann Perchec, Novapost < yann.perc...@novapost.fr> wrote: > Hello everybody, > > I'm playing since a couple of days with the cassandra-cli supplied with the > Cassandra 0.7 RC. > It seems that new

Cassandra Map-Reduce

2010-12-03 Thread Sanjay Acharya
We are in the process of evaluating Cassandra for our needs and we expect to use parallelism for analytics on collected data. The following BLOG mentions that Cassandra's Map-Reduce support does not support multiple column families http://allthingshadoop.com/2010/04/24/running-hadoop-mapreduce

Cassandra 0.7 - Impact of row size and columns on compaction

2010-12-03 Thread Narendra Sharma
What is the impact (performance and I/O) of row size (in bytes) on compaction? What is the impact (performance and I/O) of number of super columns and columns on compaction? Does anyone has any details and data to share? Thanks, Naren

Re: how to see how many rows in each node?

2010-12-03 Thread Robert Coli
On 12/3/10 6:09 AM, Jonathan Ellis wrote: Divide space used by average row size from cfstats On Fri, Dec 3, 2010 at 7:58 AM, Donal Zang wrote: RT. Is there any command or api? In 0.6.x : strings /path/to/cassandra/data/Keyspace/*-Index.db | wc -l =Rob

Re: Connection refused Error..

2010-12-03 Thread rambabu pakala
Thanks Jonathan.   Ok, will take look.   However wondering why we cannot use the (CASSANDRA_HOME/bin/cassandra) script in the BeforeClass to start and stop-server (with pidfile) to stop it?   --- On Fri, 12/3/10, Jonathan Ellis wrote: From: Jonathan Ellis Subject: Re: Connection refused Err

Re: Re: Cassandra 0.7 beta 3 outOfMemory (OOM)

2010-12-03 Thread Max
Hi, we increased heap space to 3 GB (with JRocket VM under 32-bit Win with 4 GB RAM) but under "heavy" inserts Cassandra is still crashing with OutOfMemory error after a GC storm. It sounds very similar to https://issues.apache.org/jira/browse/CASSANDRA-1177 In our insert-tests the average

Re: Secondary index on SuperColumn Family , Casandra 0.7beta2

2010-12-03 Thread Jonathan Ellis
Created https://issues.apache.org/jira/browse/CASSANDRA-1813 so this doesn't just silently not work. On Thu, Dec 2, 2010 at 5:28 PM, Tyler Hobbs wrote: > Unfortunately, super columns families are not yet supported for secondary > indexes. > > - Tyler > > On Thu, Dec 2, 2010 at 5:22 PM, Nick Santi

Re: how to see how many rows in each node?

2010-12-03 Thread Jonathan Ellis
Divide space used by average row size from cfstats On Fri, Dec 3, 2010 at 7:58 AM, Donal Zang wrote: > RT. > Is there any command or api? > > Thanks! > > > -- Jonathan Ellis Project Chair, Apache Cassandra co-founder of Riptano, the source for professional Cassandra support http://riptano.com

Re: Set an index on column

2010-12-03 Thread Jonathan Ellis
"internal error" means "there's an error in the server log" On Fri, Dec 3, 2010 at 2:47 AM, Joshua Partogi wrote: > Hi Jonathan, > > Thanks for the hint. I've tried it but it throws an error like this: > > [defa...@keyspace1] update column family Standard1 with column_metadata=[{ > column_name:us

Re: Connection refused Error..

2010-12-03 Thread Jonathan Ellis
Look at EmbeddedCassandraService On Fri, Dec 3, 2010 at 2:13 AM, rambabu pakala wrote: > Hi, > > Can someone Please help me? > > Using Cassandra 0.6.6 version on Linux System. > > I can Manually start Cassandra and can run the Junit tests(can see all the > data from cli). However when i try to s

how to see how many rows in each node?

2010-12-03 Thread Donal Zang
RT. Is there any command or api? Thanks!

Re: Best Practice for Data Center Migration

2010-12-03 Thread Daniel Doubleday
Hm - assuming that you have configured your initial tokens in a way that every next start token lives in the other datacenter wouldn't it suffice to decrease rf to 2 switch to simple replication strategy switch off the old dc and start repairs/cleanup? every row should live in either primary

Re: Best Practice for Data Center Migration

2010-12-03 Thread Jake Maizel
Thanks for the followup. I have a few follow on questions: In the case of using decommission, any idea of what happens when we get to the last node in the old data center? Do you think it will decommission properly? I agree that this sounds like the easiest method. We have to see if we can sup

Dont bogart that connection my friend

2010-12-03 Thread Daniel Doubleday
Hi all I have found an anti pattern the other day which I wanted to share, although its pretty special case. Special case because our production cluster is somewhat strange: 3 servers, rf = 3. We do consistent reads/writes with quorum. I did a long running read series (loads of reads as fast a

Re: Set an index on column

2010-12-03 Thread Joshua Partogi
Hi Jonathan, Thanks for the hint. I've tried it but it throws an error like this: [defa...@keyspace1] update column family Standard1 with column_metadata=[{ column_name:user, index_type:0, validation_class:UTF8Type, index_name:Standard1Idx }] and rows_cached=100; Internal error processing system_

Connection refused Error..

2010-12-03 Thread rambabu pakala
Hi,   Can someone Please help me?   Using Cassandra 0.6.6 version on Linux System.   I can Manually start Cassandra and can run the Junit tests(can see all the data from cli). However when i try to start Cassandra from a test (with @Beforeclass)  getting Connection refused error.   Is there a way