Re: repair never finishing 1.0.7

2012-06-26 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

Secondary index data gone after restart (1.1.1)

2012-06-26 Thread Ivo Meißner
Hi, I am running into some problems with secondary indexes that I am unable to track down. When I restart the cassandra service, the secondary index data won't load and I get the following error during startup: INFO 08:29:42,127 Opening

Re: Secondary index data gone after restart (1.1.1)

2012-06-26 Thread Fei Shan
Hi please refer JDK nio package's ByteBuffer, I don't think that ByteBuffer can be cast from the BigInteger directly, it seems you need make some conversion before put it into a ByteBuffer. Thanks Fei On Tue, Jun 26, 2012 at 12:07 AM, Ivo Meißner i...@overtronic.com wrote: Hi, I am

How to use row caching to enable faster retrieval of rows in Cassandra

2012-06-26 Thread Prakrati Agrawal
Dear all, I am trying to understand whether I can fasten the retrieval process using cache. Please can you help me write the code for setting the cache properties in Cassandra. Please help Thanks and Regards Prakrati This email message may contain

Re: Secondary index data gone after restart (1.1.1)

2012-06-26 Thread Ivo Meißner
Hi, but if the data must be converted, this is something that should be fixed inside cassandra… Is this a bug, should I file a bug report? Or is there some kind of setting I can change to make it work for now? Maybe it is related to this issue, but this should have been fixed in 1.1.0:

Re: Request Timeout with Composite Columns and CQL3

2012-06-26 Thread Sylvain Lebresne
On Mon, Jun 25, 2012 at 11:10 PM, Henning Kropp kr...@nurago.com wrote: 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 =

Re: Removing a counter columns using Thrift interface

2012-06-26 Thread Patrik Modesto
On Mon, Jun 25, 2012 at 9:28 AM, Sylvain Lebresne sylv...@datastax.com wrote: On Mon, Jun 25, 2012 at 9:06 AM, Patrik Modesto patrik.mode...@gmail.com 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

Create column family fail

2012-06-26 Thread Juan Ezquerro
Hi, I create this column family: CREATE COLUMN FAMILY Clients WITH column_type='Super' AND key_validation_class = LongType -- master_id AND comparator = LongType -- client_id AND subcomparator = UTF8Type AND column_metadata = [ {column_name: client_name,

Re: Create column family fail

2012-06-26 Thread Juan Ezquerro
Ok the '--' was the problem ... LOL 2012/6/26 Juan Ezquerro j...@sofistic.net Hi, I create this column family: CREATE COLUMN FAMILY Clients WITH column_type='Super' AND key_validation_class = LongType -- master_id AND comparator = LongType -- client_id AND

AW: Request Timeout with Composite Columns and CQL3

2012-06-26 Thread Henning Kropp
Thanks for the reply. Should have thought about looking into the log files sooner. An AssertionError happens at execution. I haven't figured out yet why. Any input is very much appreciated: ERROR [ReadStage:1] 2012-06-26 15:49:54,481 AbstractCassandraDaemon.java (line 134) Exception in thread

Cassandra and massive TTL expirations cause HEAP issue

2012-06-26 Thread Nils Pommerien
Hello, I am evaluating Cassandra in a log retrieval application. My ring conists of3 m2.xlarge instances (17.1 GB memory, 6.5 ECU (2 virtual cores with 3.25 EC2 Compute Units each), 420 GB of local instance storage, 64-bit platform) and I am writing at roughly 220 writes/sec. Per day I am

Multi datacenter, WAN hiccups and replication

2012-06-26 Thread Karthik N
My Cassandra ring spans two DCs. I use local quorum with replication factor=3. I do a write in DC1 with local quorum. Data gets written to multiple nodes in DC1. For the same write to propagate to DC2 only one copy is sent from the coordinator node in DC1 to a coordinator node in DC2 for

Re: Multi datacenter, WAN hiccups and replication

2012-06-26 Thread Mohit Anchlia
On Tue, Jun 26, 2012 at 7:52 AM, Karthik N karthik@gmail.com wrote: My Cassandra ring spans two DCs. I use local quorum with replication factor=3. I do a write in DC1 with local quorum. Data gets written to multiple nodes in DC1. For the same write to propagate to DC2 only one copy is

Re: Request Timeout with Composite Columns and CQL3

2012-06-26 Thread Sylvain Lebresne
On Tue, Jun 26, 2012 at 4:00 PM, Henning Kropp kr...@nurago.com wrote: Thanks for the reply. Should have thought about looking into the log files sooner. An AssertionError happens at execution. I haven't figured out yet why. Any input is very much appreciated: ERROR [ReadStage:1] 2012-06-26

Re: Multi datacenter, WAN hiccups and replication

2012-06-26 Thread Karthik N
Since Cassandra optimizes and sends only one copy over the WAN, can I opt in only for HH for WAN replication and avoid HH for the local quorum? (since I know I have more copies) On Tuesday, June 26, 2012, Mohit Anchlia wrote: On Tue, Jun 26, 2012 at 7:52 AM, Karthik N

Re: Multi datacenter, WAN hiccups and replication

2012-06-26 Thread Mohit Anchlia
On Tue, Jun 26, 2012 at 8:16 AM, Karthik N karthik@gmail.com wrote: Since Cassandra optimizes and sends only one copy over the WAN, can I opt in only for HH for WAN replication and avoid HH for the local quorum? (since I know I have more copies) I am not sure if I understand your

Re: Consistency Problem with Quorum consistencyLevel configuration

2012-06-26 Thread Jason Tang
Hi After enable Cassandra debug log, I got following log, it shows the delete mutation send to other two nodes rather then local node. And then the read command come to the local nodes. And local one found the mismatch. But I don't know why local node return the local dirty data. It

Re: Multi datacenter, WAN hiccups and replication

2012-06-26 Thread Karthik N
Let me attempt to articulate my question a little better. Say I choose LOCAL_QUORUM with a Replication Factor of 3. Cassandra stores three copies in my local datacenter. Therefore the cost associated with losing one node is not very high locally, and I usually HH, and use read repair/nodetool

Re: Multi datacenter, WAN hiccups and replication

2012-06-26 Thread Karthik N
I re-read my last post and didn't think I had done a good job articulating. Sorry! I'll try again... Say I choose LOCAL_QUORUM with a Replication Factor of 3. Cassandra stores three copies in my local datacenter. Therefore the cost associated with losing one node is not very high locally, and I

Re: cassandra 1.0.9 error - Read an invalid frame size of 0

2012-06-26 Thread Guy Incognito
i have seen this as well, is it a known issue? On 18/06/2012 19:38, Gurpreet Singh wrote: I found a fix for this one, rather a workaround. I changed the rpc_server_type in cassandra.yaml, from hsha to sync, and the error went away. I guess, there is some issue with the thrift nonblocking

Ball is rolling on High Performance Cassandra Cookbook second edition

2012-06-26 Thread Edward Capriolo
Hello all, It has not been very long since the first book was published but several things have been added to Cassandra and a few things have changed. I am putting together a list of changed content, for example features like the old per Column family memtable flush settings versus the new system

Amazingly bad compaction performance

2012-06-26 Thread Dustin Wenz
We occasionally see fairly poor compaction performance on random nodes in our 7-node cluster, and I have no idea why. This is one example from the log: [CompactionExecutor:45] 2012-06-26 13:40:18,721 CompactionTask.java (line 221) Compacted to

bulk load problem

2012-06-26 Thread James Pirz
Dear all, I am trying to use sstableloader in cassandra 1.1.1, to bulk load some data into a single node cluster. I am running the following command: bin/sstableloader -d 192.168.100.1 /data/ssTable/tpch/tpch/ from another node (other than the node on which cassandra is running), while the data

Re: Migrate keyspace from version 1.0.8 to 1.1.1

2012-06-26 Thread aaron morton
There is nothing listed in the News file https://github.com/apache/cassandra/blob/cassandra-1.1/NEWS.txt Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 26/06/2012, at 3:16 AM, Thierry Templier wrote: Hello, What is the correct way to