Re: Restart node = hinted handoff flood

2013-07-05 Thread Michał Michalski
My blind guess is: https://issues.apache.org/jira/browse/CASSANDRA-5179 In our case the only sensible solution was to pause hints delivery and disable storing them (both done with a nodetool: pausehandoff and disablehandoff). Once they TTL'd (3 hours by default I believe?) I turned HH on

Re: CorruptBlockException - recover?

2013-07-05 Thread Jan Kesten
Hi, i tried to scrub the keyspace - but with no success either, the process threw an exception when hitting the corrupt block and stopped then. I will rebootstrap the node :-) Thanks anyways, Jan On 03.07.2013 19:10, Glenn Thompson wrote: For what its worth. I did this when I had this

Re: CorruptBlockException - recover?

2013-07-05 Thread Michał Michalski
I think I'd try removing broken SSTables (when node is down) and running repair then. M. W dniu 05.07.2013 09:10, Jan Kesten pisze: Hi, i tried to scrub the keyspace - but with no success either, the process threw an exception when hitting the corrupt block and stopped then. I will

Call for papers is open for OSS4B 2013

2013-07-05 Thread Gabriele Bartolini
Hello, I am happy to inform you that the call for papers of the first edition of the Open Source Software for Business conference is now open. OSS4B 2013 will take place in Prato, Tuscany, Italy on 19 and 20 September. We are looking for talks on open source technologies used in business and

Re: How to build indexes?

2013-07-05 Thread Sylvain Lebresne
Creating a secondary index will trigger the build of that index automatically. However, that built is done asynchronously and can take some time if you have lots of existing data to index. To know when that building is done, you can check the nodes log for an entry looking like Index build of

Re: Installing specific version

2013-07-05 Thread Kais Ahmed
Hi ben, You can get it from http://archive.apache.org/dist/cassandra/ 2013/7/5 Ben Gambley ben.gamb...@intoscience.com Hi all Can anyone point me in the right direction for installing a specific version from datastax repo, we need 1.2.4 to keep consistent with our qa environment. It's

Re: How to build indexes?

2013-07-05 Thread Tony Anecito
Thanks, Apparently for 1.2.5 it did not build automatically. Diescribe shows index[] which indicates it was not built.   I will try the nodetool command. I dd not see it in the hep list though.   Best Regards, -Tony From: Sylvain Lebresne sylv...@datastax.com To: user@cassandra.apache.org

Use case of libcql

2013-07-05 Thread Shubham Mittal
Hi, Does anyone know about any working use case of libcql (c++ client for cassandra) because there is not much info on its github repohttps://github.com/mstump/libcql regarding how to use it. Thanks

Re: How to build indexes?

2013-07-05 Thread Tony Anecito
Thanks Sylvain, I am getting errors in nodetool. Strange it wants -ks (which I assume is keyspace) then when I try I get following error. C:\servers\apache-cassandra-1.2.5\binnodetool rebuild_index -host localhost -ks video -cf videos Starting NodeTool Unrecognized option: -ks usage: java

CassandraDaemon - recent unsafe memory access operation in compiled Java code

2013-07-05 Thread Glyn Davies
Hi, Just starting to experiment with Cassandra, and have hit an early snag. I'm using 1.2.6 on Ubuntu AWS m1.xlarge instances with the Datastax Community package and have tried using Java versions jdk1.7.0_25 jre1.6.0_45 Also testing with and without libjna-java However, something has

Re: CorruptBlockException - recover?

2013-07-05 Thread Robert Coli
On Fri, Jul 5, 2013 at 12:10 AM, Jan Kesten j.kes...@enercast.de wrote: i tried to scrub the keyspace - but with no success either, the process threw an exception when hitting the corrupt block and stopped then. I will rebootstrap the node :-)

Re: Cassandra with vnode and ByteOrderedPartition

2013-07-05 Thread Sávio Teles
Ok! Thanks! 2013/7/3 Richard Low rich...@wentnet.com On 3 July 2013 22:18, Sávio Teles savio.te...@lupa.inf.ufg.br wrote: We were able to implement ByteOrderedPartition on Cassandra 1.1 and insert an object in a specific machine. However, with Cassandra 1.2 and VNodes we can't implement

select count(1) and OOM

2013-07-05 Thread Pavel Kirienko
Hi everyone, I was playing with a single-node Cassandra installation when discovered that a request like [SELECT COUNT(*) FROM CF] seems to load the entire dataset of CF into RAM. I am not sure is it expected to behave this way or not. I'd expect it to iterate through the entire set of rows

Re: select count(1) and OOM

2013-07-05 Thread Sylvain Lebresne
I was playing with a single-node Cassandra installation when discovered that a request like [SELECT COUNT(*) FROM CF] seems to load the entire dataset of CF into RAM. This is the case (the whole CF will be loaded in memory). And it's currently a know limitation of Cassandra 1.2. This will be

Re: going down from RF=3 to RF=2, repair constantly falls over with JVM OOM

2013-07-05 Thread Eric Stevens
The following setting is probably not a good idea: bloom_filter_fp_chance = 1.0 It would disable the bloom filters all together, and this setting doesn't have appreciably greater benefits over a setting of 0.1 (which has the advantage of saving you from disk I/O 90% of the time for keys which

Re: Dynamic Snitch and EC2MultiRegionSnitch

2013-07-05 Thread Robert Coli
On Mon, Jul 1, 2013 at 2:35 PM, Daning Wang dan...@netseer.com wrote: How does dynamic snitch work with EC2MultiRegionSnitch? Can dynamic routing only happen in one data center? We don't wan to have the requests routed to another center even nodes are idle in other side since the network

Re: Migrating data from 2 node cluster to a 3 node cluster

2013-07-05 Thread Robert Coli
On Thu, Jul 4, 2013 at 10:03 AM, srmore comom...@gmail.com wrote: We are planning to move data from a 2 node cluster to a 3 node cluster. We are planning to copy the data from the two nodes (snapshot) to the new 2 nodes and hoping that Cassandra will sync it to the third node. Will this work

Re: Migrating data from 2 node cluster to a 3 node cluster

2013-07-05 Thread srmore
On Fri, Jul 5, 2013 at 6:08 PM, Robert Coli rc...@eventbrite.com wrote: On Thu, Jul 4, 2013 at 10:03 AM, srmore comom...@gmail.com wrote: We are planning to move data from a 2 node cluster to a 3 node cluster. We are planning to copy the data from the two nodes (snapshot) to the new 2 nodes