Re: constant CMS GC using CPU time

2012-10-21 Thread Radim Kolar
Dne 18.10.2012 20:06, Bryan Talbot napsal(a): In a 4 node cluster running Cassandra 1.1.5 with sun jvm 1.6.0_29-b11 (64-bit), the nodes are often getting stuck in state where CMS collections of the old space are constantly running. you need more java heap memory

Re: What does ReadRepair exactly do?

2012-10-21 Thread aaron morton
There are two processes in cassandra that trigger Read Repair like behaviour. During a DigestMismatchException is raised if the responses from the replicas do not match. In this case another read is run that involves reading all the data. This is the CL level agreement kicking in. The other

Re: Hinted Handoff runs every ten minutes

2012-10-21 Thread aaron morton
I *think* this may be ghost rows which have not being compacted. How many SSTables are on disk for the HintedHandoff CF ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 19/10/2012, at 7:16 AM, David Daeschler david.daesch...@gmail.com

Re: Compound primary key: Insert after delete

2012-10-21 Thread aaron morton
Yes AFAIK. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/10/2012, at 12:15 AM, Vivek Mishra mishra.v...@gmail.com wrote: Hi, Is it possible to reuse same compound primary key after delete? I guess it works fine for non composite

Re: DELETE query failing in CQL 3.0

2012-10-21 Thread aaron morton
Can you paste the table definition ? Thanks - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/10/2012, at 5:53 AM, Ryabin, Thomas thomas.rya...@mckesson.com wrote: I have a column family called “books”, and am trying to delete all rows where

find smallest counter

2012-10-21 Thread Paul Loy
I have a set of categories. In these categories I want to add groups of users. If a user does not specify the group they want to join in a category, I want to add them to the least subscribed group. So the groups are a super column with CategoryId as key, GroupId as superColumnName and then

Re: DELETE query failing in CQL 3.0

2012-10-21 Thread wang liang
It is better to provide table definition. I guess the reason is below statement. a table must define at least one column that is not part of the PRIMARY KEY as a row exists in Cassandra only if it contains at least one value for one such column Please check this document