Cassandra nodes failing with OOM

2012-11-16 Thread Ивaн Cобoлeв
Dear Community, advice from you needed. We have a cluster, 1/6 nodes of which died for various reasons(3 had OOM message). Nodes died in groups of 3, 1, 2. No adjacent died, though we use SimpleSnitch. Version: 1.1.6 Hardware: 12Gb RAM / 8 cores(virtual) Data: 40Gb/node

Re: unable to read saved rowcache from disk

2012-11-16 Thread Manu Zhang
> > Did that take into account the token, the row key, and the row payload, > and the java memory overhead ? how could I watch the heap usage then since jconsole is not able to connect Cassandra at that time? Trying delete the saved cache and restarting. there is no problem for me to do so. But

huge commitlog

2012-11-16 Thread Chuan-Heng Hsiao
hi Cassandra Developers, I am experiencing huge commitlog size (200+G) after inserting huge amount of data. It is a 4-node cluster with RF= 3, and currently each has 200+G commit log (so there are around 1T commit log in total) The setting of commitlog_total_space_in_mb is default. I am using 1.

Re: Offsets and Range Queries

2012-11-16 Thread aaron morton
> I assume it's because of iterators in read-time, which go over results do > merging/reducing/collating results one-by-one that is not so well suited for > jumping to arbitrary offsets, given the practically huge number of columns > involved, right? No really, you can have a slice that starts i

Re: Datatype Conversion in CQL-Client?

2012-11-16 Thread aaron morton
> Does the official/built-in Cassandra CQL client (in 1.2) What language ? Check the Java http://code.google.com/a/apache-extras.org/p/cassandra-jdbc/ and python http://code.google.com/a/apache-extras.org/p/cassandra-dbapi2/ drivers. Cheers - Aaron Morton Freelance Cassandra

Re: unable to read saved rowcache from disk

2012-11-16 Thread aaron morton
> Just curious why do you think row key will take 300 byte? That's what I thought it said earlier in the email thread. > If the row key is Long type, doesn't it take 8 bytes? Yes, 8 bytes on disk. > In his case, the rowCache was 500M with 1.6M rows, so the row data is 300B. > Did I miss som

Re: Admin for cassandra?

2012-11-16 Thread Bryan Talbot
The https://github.com/sebgiroux/Cassandra-Cluster-Admin app does some of what you're asking. It allows basic browsing and some admin functionality. If you want to run actual CQL queries though, you currently need to use another app for that (like cqlsh). -Bryan On Thu, Nov 15, 2012 at 11:30 P

Re: unsubscribe

2012-11-16 Thread Eric Evans
http://i1.kym-cdn.com/photos/images/newsfeed/000/263/866/403.gif On Thu, Nov 15, 2012 at 2:02 PM, Kartik Padmanabhan wrote: > -- Eric Evans Acunu | http://www.acunu.com | @acunu

Re: SchemaDisagreementException

2012-11-16 Thread Everton Lima
I do that because I need to create a dynamic column families. I create 2 keyspaces in the start of application, using embedded cassandra instance too, but it's never throw exception. And than, insert dynamic column families in this 2 keyspaces. I put a "Thread.sleep(3000);" in the middle of the c

Re: unsubscribe

2012-11-16 Thread Alain RODRIGUEZ
http://wiki.apache.org/cassandra/FAQ#unsubscribe 2012/11/16 yaw >

Re: Compact and Repair

2012-11-16 Thread Henrik Schröder
It was the long time since last repair that did it. We've scheduled regular repairs now, and this time the repairs didn't increase the load very much. So that was it! :-) /Henrik On Thu, Nov 8, 2012 at 7:20 PM, Andrey Ilinykh wrote: > Nothing unusual. When you run repair cassandra streams inc