TimeoutException and keyspace exceptions

Hi, I'm running a heavy load with about 3200 clients accessing cassandra to execute read and update queries via YCSB. At certain moment, YCSB starts throwing exceptions indefinitely like the following: * [30/07/2013 00:04:50] Read Exception (Thread: 5007; Host: 10.191.54.26): TimedOutExce

Re: deleting columns with CAS (2.0.0-beta2)

Yep, for example, I created a simple users table and then issued a delete with an IF statement. i.e CREATE TABLE users ( user_name varchar, password varchar, state varchar, PRIMARY KEY (user_name) ); INSERT INTO users (user_name, password, state)

Re: make cassandra-cli use 7197 for JMX instead?

Ugh, how did I miss that one, it was in the cassandra-cli --helpŠ.never mind. Dean On 7/29/13 11:24 AM, "Hiller, Dean" wrote: >I start nodetool with > >Cassandra-cli ­p 9158 but it gives warnings about not displaying all >information because my JMX port is on 7197 instead of 7199 which is in >u

Re: Custom commands in cassandra

hi > Have you identified issues where throughput or latency is an issue ? no, I am on design stage of my app and I want to do it the fastest way possible from the beginning > Most performance gains are going to be made by getting the data model right. hope to get it right, and with embedding will

make cassandra-cli use 7197 for JMX instead?

I start nodetool with Cassandra-cli –p 9158 but it gives warnings about not displaying all information because my JMX port is on 7197 instead of 7199 which is in use by another process. How do I make cassandra-cli connect to 7197 for the JMX stuff (right now it connets into another process whi

Re: nodetool cfstats write count ?

On 29 July 2013 14:43, Langston, Jim wrote: Running nodetool and looking at the cfstats output, for the > counters such as write count and read count, do those numbers > reflect any replication ? > > For instance, if write count shows 3000 and the replication factor > is 3, is that really 1000

nodetool cfstats write count ?

Hi all, Running nodetool and looking at the cfstats output, for the counters such as write count and read count, do those numbers reflect any replication ? For instance, if write count shows 3000 and the replication factor is 3, is that really 1000 writes ? Thanks, Jim

Re: key cache hit rate and BF false positive

Re-sending hoping to get some assistance. Thanks! From: Keith Wright mailto:kwri...@nanigans.com>> Reply-To: "user@cassandra.apache.org" mailto:user@cassandra.apache.org>> Date: Friday, July 26, 2013 11:25 PM To: "user@cassandra.apache.org

Re: sstable size change

Version 1.2.4. Original alter that does nothing: alter table shard_user_lookup with compaction_strategy_options = {'sstable_size_in_mb':256}; Correct alter: alter table cookie_user_lookup with compaction={'sstable_size_in_mb': '256', 'class': 'LeveledCompactionStrategy'}; Thanks From: aaron

RE: AssertionError during ALTER TYPE in 1.2.5

Maybe it's because of the "COMPACT STORAGE". Without that, the cells of a CQL3 table definition will be mapped to a composite taking the clustering part of the key and the column name. So, i.e. in your case the "value" column should be mapped to a cell with name column1:value if your def not inc

Re: [RELEASE] Apache Cassandra 1.2.8

The CHANGES and NEWS links pointed to the 1.2.8-tentative. The 1.2.8 links are: CHANGES.txt: https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=CHANGES.txt;hb=refs/tags/1.2.8 NEWS.txt: https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=NEWS.txt;hb=refs/tags

Re: Installing Debian package from ASF repo

On 29 July 2013 12:00, Pavel Kirienko wrote: > Hi, > > I failed to install the Debian package of Cassandra 1.2.7 from ASF > repository because of 404 error. > APT said: > > http://www.apache.org/dist/cassandra/debian/pool/main/c/cassandra/cassandra_1.2.7_all.deb > 404 Not Found [IP: 192.87.106.

Installing Debian package from ASF repo

Hi, I failed to install the Debian package of Cassandra 1.2.7 from ASF repository because of 404 error. APT said: http://www.apache.org/dist/cassandra/debian/pool/main/c/cassandra/cassandra_1.2.7_all.deb 404 Not Found [IP: 192.87.106.229 80] http://www.apache.org/dist/cassandra/debian/pool/main/c

Re: Custom commands in cassandra

> My reasons to merge the app > into cassandra's code is to gain speed so I will be running only one > java vm process along multiple cores inside a node. Have you identified issues where throughput or latency is an issue ? Most performance gains are going to be made by getting the data model rig

Re: maximum storage per node

> Does anyone have opinions on the maximum amount of data reasonable to store > on one Cassandra node? spinning disk and 1Gbe networking, rule of thumb was 300Gb to 500GB. SSD or very fast local disk, 10Gbe networking, optionally JBOD, cassandra 1.2 and vnodes people are talking about multiple

Re: AssertionError during ALTER TYPE in 1.2.5

The error is because the underlying CF is not defined using a composite type for the comparator. > CREATE TABLE "RRD" ( > key text, > column1 blob, > value blob, > PRIMARY KEY (key, column1) > ) WITH COMPACT STORAGE AND Looks like this PRIMARY KEY (key, column1) is incorrect. That says "Th

Re: cassandra 1.2.5- virtual nodes (num_token) pros/cons?

I would *strongly* recommend against upgrading from 0.8 directly to 1.2. Skipping a major version is generally not recommended, skipped 3 would seem like carelessness. > I second Romain, do the upgrade and make sure the health is good first. +1 but I would also recommend deciding if you actuall

Re: hadoop/cassandra integration using CL_ONE...

> Is it possible to use CL_ONE with hadoop/cassandra when doing an M/R job? That's the default. https://github.com/apache/cassandra/blob/cassandra-1.2/src/java/org/apache/cassandra/hadoop/ConfigHelper.java#L383 > And more importantly is there a way to configure that such that if my RF=3, > that

Re: sstable size change

> I still would have expected my original alter command to at least have thrown > an error. I assume I should open a bug for this? Sounds like a good idea. Please describe the version and query you first used. Thanks for taking the time to update the thread. Cheers - Aaron

Re: Cassandra 2.0: Paxos Prepare response always false

Thanks for looking into this. If you have a way to reproduce this the best thing to do is create a ticket at https://issues.apache.org/jira/browse/CASSANDRA as 2.0 is still under development. Cheers - Aaron Morton Cassandra Consultant New Zealand @aaronmorton http://www.the

Re: deleting columns with CAS (2.0.0-beta2)

> I presume it can be done because conditional deletes work through CQL3. Out of interest where do you have an example or a reference for this? Cheers - Aaron Morton Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 26/07/2013, at 8:07 AM, Kalpana Su