Re: CQL 3.0 composite keys and secondary indexes

2012-05-08 Thread Sylvain Lebresne
On Tue, May 8, 2012 at 12:08 AM, Roland Mechler rmech...@sencha.com wrote: It seems as though secondary indexes are not supported in tables (column families) that have composite keys. Is that true? It is. If so, are there plans to suport that combination in the future? There is:

Re: cassandra1.1 can't start

2012-05-08 Thread cyril auburtin
8G, by default the jvm was taking 2G, and I had this error even with 1G, I had the error, finally 500M made it work (4 Intel Atoms, OS: ubuntu 10.04 ) 2012/5/8 Watanabe Maki watanabe.m...@gmail.com How much memory do you have on the box? It seems you need more memory. maki On 2012/05/08,

Re: strange gossip messages after node reboot with different ip

2012-05-08 Thread Piavlo
On 05/01/2012 04:16 AM, aaron morton wrote: Gossip information about a node can stay in the cluster for up to 3 days. How long has this been going on for ? This has been going for over a week already without any signs of slow down, all nodes that have changed ip popup as UP/DEAD endlessly. Any

RE: cassandra1.1 can't start

2012-05-08 Thread Pierre Chalamet
This looks like CASSANDRA-4201 where map() was failing with oom under 32 bits jvm. Jonathan provided a patch for that. You can apply it on top of 1.1. - Pierre From: cyril auburtin [mailto:cyril.aubur...@gmail.com] Sent: mardi 8 mai 2012 08:56 To: user@cassandra.apache.org Subject: Re:

Re: cassandra1.1 can't start

2012-05-08 Thread cyril auburtin
ah thx yes that's true I forgot to say we are using 32bits Java, we should use 64 now that everything is stable with 64bit thx 2012/5/8 Pierre Chalamet pie...@chalamet.net This looks like CASSANDRA-4201 where map() was failing with oom under 32 bits jvm. Jonathan provided a patch for

[RELEASE] Apache Cassandra 1.0.10 released

2012-05-08 Thread Sylvain Lebresne
The Cassandra team is pleased to announce the release of Apache Cassandra version 1.0.10. Cassandra is a highly scalable second-generation distributed database, bringing together Dynamo's fully distributed design and Bigtable's ColumnFamily-based data model. You can read more here:

Re: [RELEASE] Apache Cassandra 1.0.10 released

2012-05-08 Thread Jonas Borgström
Hi, Can someone give some more details about the CASSANDRA-4116 bug fixed in this release? Could this cause resurrection of deleted data for example? https://issues.apache.org/jira/browse/CASSANDRA-4116 / Jonas On 2012-05-08 11:04 , Sylvain Lebresne wrote: The Cassandra team is pleased to

Re: count after truncate NOT zero

2012-05-08 Thread aaron morton
Some 'feature' for future implementation, maybe? imho truncation working as a meta data operation is the correct approach. It's generally used in testing and development. It deletes the data and removes the SSTables, giving you a clean state. A CF level tombstone would mean that reads had to

enforcing ordering

2012-05-08 Thread Franc Carter
Hi, I'm wondering if there is a common 'pattern' to address a scenario we will have to deal with. We will be storing a set of Column/Value pairs per Key where the Column/Values are read from a set of files that we download regularly. We need the loading to be resilient and we can receive

Re: using the proxy on the cli or configHelper to connect to cassandra server

2012-05-08 Thread aaron morton
There is no support in the cli for using a socks proxy. You would need to add it. Take a look in CliMain.java Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 8/05/2012, at 10:00 AM, Shawna Qian wrote: Hello: In our cassandra

Re: getting status of long running repair

2012-05-08 Thread aaron morton
When you look in the logs please let me know if you see this error… https://issues.apache.org/jira/browse/CASSANDRA-4223 I look at nodetool compactionstats (for the Merkle tree phase), nodetool netstats for the streaming, and this to check for streaming progress: while true; do date; diff

Re: enforcing ordering

2012-05-08 Thread aaron morton
Can you store the corrections in a separate CF? When the client reads the key, reads from the original the corrects CF at the same time. Apply the correction only on the client side. When you have confirmed the ingest has completed, run a background jobs to apply the corrections, store the

Re: enforcing ordering

2012-05-08 Thread Franc Carter
On Tue, May 8, 2012 at 8:09 PM, aaron morton aa...@thelastpickle.comwrote: Can you store the corrections in a separate CF? Yes, I thought of that, but that turns on read in to two ;-( When the client reads the key, reads from the original the corrects CF at the same time. Apply the

Use-case: multi-instance webshop

2012-05-08 Thread R. Verlangen
Hi there, I'm working on a datamodel for a multi-website, multi-customer system. Things we would like to do: - search products (lucene / solr / solandra) - multi-filter (e.g. categories) - reviews - voting I can't really see how to do the filtering of the products by categories and even things

RE: sstableloader 1.1 won't stream

2012-05-08 Thread Pieter Callewaert
I've updated all nodes to 1.1 but I keep getting the same problem... Any other thoughts about this? Kind regards, Pieter -Original Message- From: Benoit Perroud [mailto:ben...@noisette.ch] Sent: maandag 7 mei 2012 22:21 To: user@cassandra.apache.org Subject: Re: sstableloader 1.1 won't

Re: [RELEASE] Apache Cassandra 1.0.10 released

2012-05-08 Thread Sam Tunnicliffe
Hi Jonas, the bug that was fixed in 4116 meant that the max timestamp recorded for an sstable didn't consider any tombstones from row deletions. This meant that from some queries, some sstables were not being read when they should have been. I couldn't say categorically that this would cause the

Re: Timeout Exception in get_slice

2012-05-08 Thread Luís Ferreira
Maybe one of the problems is that I am reading the columns in a row and the rows themselves in batches, using the count attribute in the SliceRange and by changing the start column or the corresponding for rows with the KeyRange. According to your blog post, using start key to read for millions

Re: Failing to delete commitlog at startup/shutdown (Windows)

2012-05-08 Thread Conan Cook
Hi Steve, Thanks for your reply, sorry for the delay in getting back to you. We're actually doing something very similar already, using Hector's EmbeddedServerHelper (it's basically the same, maybe it came from the same code). Unfortunately whilst writing this our internet went down and I

Re: getting status of long running repair

2012-05-08 Thread Bill Au
There are no error message in my log. I ended up restarting all the nodes in my cluster. After that I was able to run repair successfully on one of the node. It took about 40 minutes. Feeling lucky I ran repair on another node and it is stuck again. tpstats show 1 active and 1 pending