Multiget_slice or composite column keys?

2011-05-15 Thread Charles Blaxland
Hi All, New to Cassandra, so apologies if I don't fully grok stuff just yet. I have data keyed by a key as well as a date. I want to run a query to get multiple keys across multiple contiguous date ranges simultaneously. I'm currently storing the date along with the row key like this: key1|2011-

Re: Native heap leaks?

2011-05-15 Thread Peter Schuller
> Ok, so I think I found one major cause contributing to the increasing Nice job tracking this down! That is useful to know, even outside of Cassandra use cases. Frankly it's disappointing to learn what nio is doing. -- / Peter Schuller

Re: Inconsistent data issues when running nodetool move.

2011-05-15 Thread Peter Schuller
> That makes sense with my symptoms...  I was doing a CL=ONE for write and a > CL=ALL for read, expecting that to be sufficient. > > I will try both set to ALL and see if I get better consistency. Just keep in mind that with ALL queries will fail with just a single node down. (This is why QUORUM

Re: Native heap leaks?

2011-05-15 Thread Jonathan Ellis
Great debugging work! That workaround sounds like the best alternative to me too. On Sat, May 14, 2011 at 9:46 PM, Hannes Schmidt wrote: > Ok, so I think I found one major cause contributing to the increasing > resident size of the Cassandra process. Looking at the OpenJDK sources > was of great

Re: Native heap leaks?

2011-05-15 Thread Hannes Schmidt
As promised: https://issues.apache.org/jira/browse/CASSANDRA-2654 On Sun, May 15, 2011 at 7:09 AM, Jonathan Ellis wrote: > Great debugging work! > > That workaround sounds like the best alternative to me too. > > On Sat, May 14, 2011 at 9:46 PM, Hannes Schmidt wrote: >> Ok, so I think I found on

Inconsistent results using secondary indexes between two DC

2011-05-15 Thread Wojciech Pietrzok
Hello, I've noticed strange behaviour of Cassandra when using secondary indexes. There are 2 Data Centers, each with 2 nodes, RF=4, on all nodes Cassandra 0.7.5 is installed. When I connect to one of the nodes in DC1 and perform query using secondary indexes ("get ColumnFamily where column = 'foo'

Re: Import/Export of Schema Migrations

2011-05-15 Thread aaron morton
Not sure what sort of changes you are making, but this is my approach. I've always managed database (my sql, sql server whatever) schema as source code (SQL DDL statements, CLI script etc). It makes it a lot easier to cold start the system, test changes and see who changed what. Once you ha

Re: [howto measure disk usage]

2011-05-15 Thread aaron morton
Sub columns for a super column do serialise their time stamp, they are just the same as regular column. The super column does not have a timestamp of it's own. It does have it's own tombstone marker though. Super Column does not take a huge amount more disk space, just the name a shot int, two

Re: Converting separate clusters in mutliple dc to one cluster across multiple dcs

2011-05-15 Thread aaron morton
Rename a cluster http://wiki.apache.org/cassandra/FAQ#clustername_mismatch see also https://issues.apache.org/jira/browse/CASSANDRA-2632 The best approach will depend on - how much data you have - if this is a running system - are the schemas identical - are the individual clusters using the N

Re: assertion error in cassandra when doing nodetool move

2011-05-15 Thread aaron morton
I've had a bit more of a look and am a bit confused between what I see in the stack below and what's in the source. What version are you seeing ? Thank - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 14 May 2011, at 03:23, Anurag Gujral

Re: problems using property snitch file

2011-05-15 Thread aaron morton
Whats does your cassandra-topology.properties file look like ? Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 14 May 2011, at 11:48, Anurag Gujral wrote: > Hi All, > I have built a cassandra cluster which is using prope

Re: JMX access sample by jython (Was: How to invoke getNaturalEndpoints with jconsole?)

2011-05-15 Thread aaron morton
Nice, Thanks - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 15 May 2011, at 01:12, Maki Watanabe wrote: > Just FYI for beginners like me: I've also write it with jython. > Getting attributes are more easier than invoke Operations. I fee

Re: assertion error in cassandra when doing nodetool move

2011-05-15 Thread Anurag Gujral
I am using version 0.7.3 Thanks Anurag On Fri, May 13, 2011 at 11:15 AM, Anurag Gujral wrote: > I am using network Topology strategy for one of my keyspaces. > Thanks > Anurag > > > On Thu, May 12, 2011 at 6:45 PM, Anurag Gujral wrote: > >> Hi All, >> I run following command on one o

Re: problems using property snitch file

2011-05-15 Thread Anurag Gujral
IPAddress1=DC1:RAC1 IPAddress1=DC2:RAC1 IPAddress1=DC2:RAC1 IPAddress1=DC2:RAC1 Thanks Anurag On Sun, May 15, 2011 at 4:52 PM, aaron morton wrote: > Whats does your cassandra-topology.properties file look like ? > > Cheers > > - > Aaron Morton > Freelance Cassandra Developer > @a

Re: Converting separate clusters in mutliple dc to one cluster across multiple dcs

2011-05-15 Thread Anurag Gujral
Hi Aaron, Thanks for your mail. I am leaning towards making a new cluster since I am using cassandra version 0.7.3 and the fix you have put in is in cassandra 0.7.5, and I am less adventurous primarily because it is live system and service disruption is not what is desirable. I have