Added extra column as composite key while creation counter column family

2013-04-14 Thread Kuldeep Mishra
Hi, While I creating counter column family a extra column is being added what I do ? Table creation script CREATE TABLE counters ( key text, value counter, PRIMARY KEY (key) ) WITH COMPACT STORAGE after describing column family I am getting following CREATE TABLE counters ( key text,

AUTO : Samuel CARRIERE is out of the office (retour 22/04/2013)

2013-04-14 Thread Samuel CARRIERE
Je suis absent(e) du bureau jusqu'au 22/04/2013 Remarque : ceci est une réponse automatique à votre message "re-execution of failed queries with rpc_timeout" envoyé le 15/04/2013 3:12:45. C'est la seule notification que vous recevrez pendant l'absence de cette personne.

Re: Rename failed while cassandra is starting up

2013-04-14 Thread Boris Yen
Hi Aaron, "startup is single threaded and the scrub runs before the tables are opened ". This is what I was thinking too. However, after using the debugger to trace the code, I realized that MeteredFlusher (see the "countFlushBytes" method) might open the sstables before the scrub is completed. I

Re: re-execution of failed queries with rpc_timeout

2013-04-14 Thread Moty Kosharovsky
Sorry, not LOCAL QUORUM, I meant "ANY" quorum. On Mon, Apr 15, 2013 at 4:12 AM, Moty Kosharovsky wrote: > Hello, > > I'm running a 12 node cluser with cassandra 1.1.5 and oracle jdk 1.6.0_35. > Our application constantly writes large updates with cql. Once in a while, > an rpc_time will occur. >

re-execution of failed queries with rpc_timeout

2013-04-14 Thread Moty Kosharovsky
Hello, I'm running a 12 node cluser with cassandra 1.1.5 and oracle jdk 1.6.0_35. Our application constantly writes large updates with cql. Once in a while, an rpc_time will occur. Since a lot of the information is counters, its impossible for me to understand if the updates complete partially on

1.1.9 to 1.2.3 upgrade issue

2013-04-14 Thread John Watson
Started doing a rolling upgrade of nodes from 1.1.9 to 1.2.3 and nodes on 1.1.9 started flooding this error: Exception in thread Thread[RequestResponseStage:19496,5,main] java.io.IOError: java.io.EOFException at org.apache.cassandra.service.AbstractRowResolver.preprocess(Abstra

Re: Rename failed while cassandra is starting up

2013-04-14 Thread aaron morton
> From the log messages, it looked like the table/keyspace was > opened before the scrubDataDirectories was executed. This created a race > condition between two threads. Seems odd. AFAIK that startup is single threaded and the scrub runs before the tables are opened. See AbstractCassandraDaemon.

Re: Problems with shuffle

2013-04-14 Thread Rustam Aliyev
How does Cassandra with vnodes exactly decide how many vnodes to move? The num_tokens setting in the yaml file. What did you set this to? 256, same as on all other nodes. Cheers - Aaron Morton Freelance Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.c

Re: Problems with shuffle

2013-04-14 Thread aaron morton
> How does Cassandra with vnodes exactly decide how many vnodes to move? The num_tokens setting in the yaml file. What did you set this to? Cheers - Aaron Morton Freelance Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 14/04/2013, at 11:56 AM, Rust

Re: Any experience of 20 node mini-itx cassandra cluster

2013-04-14 Thread Jabbar Azam
Thanks Aaron. Thanks Jabbar Azam On 14 April 2013 19:39, aaron morton wrote: > That's better. > > The SSD size is a bit small, and be warned that you will want to leave > 50Gb to 100GB free to allow room for compaction (using the default size > tiered). > > On the ram side you will want to ru

Re: Extracting data from SSTable files with MapReduce

2013-04-14 Thread aaron morton
> The SSTable files are in the -f- format from 0.8.10. If you can upgrade to the latest version it will make things easier. Start a node and use nodetool upgradesstables. The org.apache.cassandra.tools.SSTableExport class provides a blue print for reading rows from disk. hope that helps. ---

Re: Any experience of 20 node mini-itx cassandra cluster

2013-04-14 Thread aaron morton
That's better. The SSD size is a bit small, and be warned that you will want to leave 50Gb to 100GB free to allow room for compaction (using the default size tiered). On the ram side you will want to run about 4GB (assuming cass 1.2) for the JVM the rest can be off heap Cassandra structures.

Re: CQL3 And ReversedTypes Question

2013-04-14 Thread aaron morton
> Bad Request: Type error: > org.apache.cassandra.cql3.statements.Selection$SimpleSelector@1e7318 cannot > be passed as argument 0 of function dateof of type timeuuid > > Is there something I am missing here or should I open a new ticket? Yes please. Cheers - Aaron Morton Free

Re: unexplained hinted handoff

2013-04-14 Thread aaron morton
>> Do slow reads trigger hint storage? No. But dropped read messages is often an indicator that the node is overwhelmed. >> If hints are being stored, doesn't that imply DOWN nodes, and why don't I >> see that in the logs? Hints are stored for two reasons. First if the node is down when the wri

Re: Repair hanges on 1.1.4

2013-04-14 Thread aaron morton
The errors from Hints are not concerned with repair. Increasing the rpc_timeout may help with those. If it's logging about 0 hints you may be seeing this https://issues.apache.org/jira/browse/CASSANDRA-5068 How did repair hang ? Check for progress with nodetool compactionstats and nodetool nets

Re: running cassandra on 8 GB servers

2013-04-14 Thread aaron morton
> Hmmm, what is the recommendation for a 10G network if 1G was 300G to > 500GŠI am guessing I can't do 10 times that, correct? But maybe I could > squeak out 600G to 1T? Best thing to do would be run a test on how long it takes to repair or bootstrap a node. The 300GB to 500Gb was just a guidelin

Re: running cassandra on 8 GB servers

2013-04-14 Thread aaron morton
> ERROR [Thrift:641] 2013-04-11 11:25:19,563 CassandraDaemon.java (line 164) > Exception in thread Thread[Thrift:641,5,main] > java.lang.OutOfMemoryError: Java heap space It's easier for people to help if you provide the error stack. Does this happen at startup or after it has been running for a

Re: Exception for version 1.1.0

2013-04-14 Thread aaron morton
Always read the news.txt guide https://github.com/apache/cassandra/blob/cassandra-1.2/NEWS.txt Cheers - Aaron Morton Freelance Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 12/04/2013, at 8:54 PM, Winsdom Chen wrote: > Hi Aaron, > Thanks fo

Re: multiple Datacenter values in PropertyFileSnitch

2013-04-14 Thread aaron morton
> So that 2 apps with same and very high load pattern are not clashing. I'm not sure what the advantage is of putting two apps in the same cluster, but using the replication strategy properties so they are on different nodes. The reason to put the apps in the same cluster is to share the resource

Re: is the select result grouped by the value of the partition key?

2013-04-14 Thread aaron morton
> >>> Is it guaranteed that the rows are grouped by the value of the >>> partition key? That is, is it guaranteed that I'll get yes. - Aaron Morton Freelance Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 12/04/2013, at 7:24 PM, Sorin Manolache w