Re: repair never finishing 1.0.7

2012-06-25 Thread Alexandru Sicoe
Hi Andras, I am not using a VPN. The system has been running successfully in this configuration for a couple of weeks until I noticed the repair is not working. What happens is that I configure the IP Tables of the machine on each Cassandra node to forward packets that are sent to any of the IPs

key_cache_size_in_mb

2012-06-25 Thread Gurpreet Singh
Hi, I have a question about cassandra 1.1 Just wanted to confirm if key_cache_size_in_mb is the maximum amount of memory that key cache will use in memory? If not, what is it? My observations: With key cache disabled, I started cassandra. I invoked Full GC through jconsole a couple of times just

Request Timeout with Composite Columns and CQL3

2012-06-25 Thread Henning Kropp
Hi, I am running into timeout issues using composite columns in cassandra 1.1.1 and cql 3. My keyspace and table is defined as the following: create keyspace bn_logs with strategy_options = [{replication_factor:1}] and placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy';

Re: RandomPartitioner is providing a very skewed distribution of keys across a 5-node Solandra cluster

2012-06-25 Thread Safdar Kureishy
Got it. Thanks Jake. Will do. Safdar On Mon, Jun 25, 2012 at 4:16 PM, Jake Luciani wrote: > Hi Sarfar, > > Yes you should make it a multiple. The issue is each shard 'sticks' to a > given node but there is no way to guarantee 5 random keys will equally > distribute across 5 nodes. The idea

Enable CQL3 from Astyanax

2012-06-25 Thread Thierry Templier
Hello, How can I enable CQL3 support in Astyanax? Thanks very much for your help! Thierry

Re: Fat Client Commit Log

2012-06-25 Thread Frank Ng
There are files that are recently created. One fat client node is storing 2.5GB of commit log files. The other 2 nodes are storing around 20MB of files. Question, would the commit log data be related to hinted handoff info in the system CF? In other words, is hinted handoffs being store in the f

Interpreting system.log MeteredFlusher messages

2012-06-25 Thread rohit bhatia
Hi We have 8 cassandra 1.0.5 nodes with 16 cores and 32G ram, Heap size is 12G, memtable_total_space_in_mb is one third = 4G, There are 12 Hot CFs (write-read ratio of 10). memtable_flush_queue_size = 4 and memtable_flush_writers = 2.. I got this log-entry " MeteredFlusher.java (line 74) estimate

Re: wildcards as both ends

2012-06-25 Thread Sam Overton
Hi Sam, On 20 June 2012 15:20, Sam Z J wrote: > > - for each string I have, index all the prefixes in a column family, e.g. > for string 'string', I'd have rows string, strin, stri, str, st, s, with > column values somehow pointing back as row keys. This almost blows up the > storage needed =/ (a

Re: cqlsh commands

2012-06-25 Thread Thierry Templier
Hello Paul, I thought but I can't reproduce the problem anymore... Don't know what really happens. Thanks very much for your message! Thierry What do you mean when you say you can't display the related documentations using the help command? What does cqlsh do instead? I don't know about an

Migrate keyspace from version 1.0.8 to 1.1.1

2012-06-25 Thread Thierry Templier
Hello, What is the correct way to migrate a keyspace version 1.0.8 to 1.1.1? Is there a documentation on this subject? Thanks for your help. Thierry

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

2012-06-25 Thread Oli Schacher
On Mon, 25 Jun 2012 09:31:18 -0400 Jake Luciani wrote: > This means you need to raise the nproc limit for the user you run > cassandra with > Centos 6 apparently introduced a default nproc limit of 1024. I raised this for the cassandra user now and hope the crashes are gone. Thanks a lot for yo

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

2012-06-25 Thread Jake Luciani
This means you need to raise the nproc limit for the user you run cassandra with On Mon, Jun 25, 2012 at 8:48 AM, Oli Schacher wrote: > Hi list > > I have a small cassandra cluster consisting of three nodes. Every few > weeks the whole cluster goes down at the same time. All nodes show: > > java.

Re: RandomPartitioner is providing a very skewed distribution of keys across a 5-node Solandra cluster

2012-06-25 Thread Jake Luciani
Hi Sarfar, Yes you should make it a multiple. The issue is each shard 'sticks' to a given node but there is no way to guarantee 5 random keys will equally distribute across 5 nodes. The idea is eventually they will as you add more and more keys. So increasing shards at once can make that happe

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

2012-06-25 Thread Oli Schacher
Hi list I have a small cassandra cluster consisting of three nodes. Every few weeks the whole cluster goes down at the same time. All nodes show: java.lang.OutOfMemoryError: unable to create new native thread at java.lang.Thread.start0(Native Method) at java.lang.Thread.start(Thre

Re: repair never finishing 1.0.7

2012-06-25 Thread Andras Szerdahelyi
The DCs are communicating over a gateway where I do NAT for ports 7000, 9160 and 7199. Ah, that sounds familiar. You don't mention if you are VPN'd or not. I'll assume you are not. So, your nodes are behind network address translation - is that to say they advertise ( broadcast ) their inter

repair never finishing 1.0.7

2012-06-25 Thread Alexandru Sicoe
Hello everyone, I have a 2 DC (DC1:3 and DC2:6) Cassandra1.0.7 setup. I have about 300GB/node in the DC2. The DCs are communicating over a gateway where I do NAT for ports 7000, 9160 and 7199. I did a "nodetool repair" on a node in DC2 without any external load on the system. It took 5 hrs

Re: Removing a counter columns using Thrift interface

2012-06-25 Thread Sylvain Lebresne
On Mon, Jun 25, 2012 at 9:06 AM, Patrik Modesto wrote: > I'm used to use Mutation for everything, so the first thing I tried > was Deletion on Counter column. Well, nothing happened. No error and > the Counter column was still there. That shouldn't happen. > The second try was the remove_counter

Removing a counter columns using Thrift interface

2012-06-25 Thread Patrik Modesto
Hi, I was playing with Counters in Cassandra 1.0.10 and I see a behaviour that I didn't expect. It's about removing a Counter column. I'm used to use Mutation for everything, so the first thing I tried was Deletion on Counter column. Well, nothing happened. No error and the Counter column was sti