Re: consistency ONE and null

2011-04-07 Thread Stephen Connolly
as I understand, the read repair is a background task triggered by the read request, but once the consistency requirement has been met you will be given a response. the coordinator at CL.ONE is allowed to return your responce once it has one response (empty or not) from any replica. if the first

Re: consistency ONE and null

2011-04-07 Thread Stephen Connolly
also there is a configuration parameter that controls the probability of any read request triggering a read repair - Stephen --- Sent from my Android phone, so random spelling mistakes, random nonsense words and other nonsense are a direct result of using swype to type on the screen On 7 Apr

problem with large batch mutation set

2011-04-07 Thread Ross Black
Hi, I am using the thrift client batch_mutate method with Cassandra 0.7.0 on Ubuntu 10.10. When the size of the mutations gets too large, the client fails with the following exception: Caused by: org.apache.thrift.transport.TTransportException: java.net.SocketException: Connection reset at

Re: consistency ONE and null

2011-04-07 Thread Jonathan Colby
that makes sense. thanks! On Apr 7, 2011, at 8:36 AM, Stephen Connolly wrote: also there is a configuration parameter that controls the probability of any read request triggering a read repair - Stephen --- Sent from my Android phone, so random spelling mistakes, random nonsense

Re: RE: batch_mutate failed: out of sequence response

2011-04-07 Thread Héctor Izquierdo Seliva
El mié, 06-04-2011 a las 21:04 -0500, Jonathan Ellis escribió: out of sequence response is thrift's way of saying I got a response for request Y when I expected request X. my money is on using a single connection from multiple threads. don't do that. I'm not using thrift directly, and

Re: RE: batch_mutate failed: out of sequence response

2011-04-07 Thread Héctor Izquierdo Seliva
El mié, 06-04-2011 a las 21:04 -0500, Jonathan Ellis escribió: out of sequence response is thrift's way of saying I got a response for request Y when I expected request X. my money is on using a single connection from multiple threads. don't do that. I'm not using thrift directly, and

Re: Error messages after rolling updating cassandra from 0.7.0 to 0.7.2

2011-04-07 Thread Kazuo YAGI
Thank both of you. I'll look it up from another view including non-cassandra processes on the servers. Just guessing Nagios or iptables or others causes it. Kazuo (11/04/05 22:55), Sasha Dolgy wrote: I've been seeing this EOF in my system.log file occasionally as well. Doesn't seem to be

Re: LB scenario

2011-04-07 Thread aaron morton
I would look at your client and see if it can handle multiple pools. So it will try to connect in the first pool, if that fails retry the other nodes in that pool and then move to the next pool. I think hector has grabbed some of the performance detection features from the DynamicSnitch so may

Re: Flush / Snapshot Triggering Full GCs, Leaving Ring

2011-04-07 Thread ruslan usifov
2011/4/7 Jonathan Ellis jbel...@gmail.com Hypothesis: it's probably the flush causing the CMS, not the snapshot linking. Confirmation possibility #1: Add a logger.warn to CLibrary.createHardLinkWithExec -- with JNA enabled it shouldn't be called, but let's rule it out. Confirmation

Reappearing nodes

2011-04-07 Thread Viliam Holub
Hi all, dead nodes which I removed via nodetool's removetoken are reappearing in the ring after few days. Is this normal? Is there a way how to remove them for good? Thanks, Viliam

Re: CL.ONE reads / RR / badness_threshold interaction

2011-04-07 Thread aaron morton
Nice explanation. Wanted to add the importance of been the first node in the ordered node list, even for CL ONE, is that this is the node sent the data request and it has to return before the CL is considered satisfied. e.g. CL One with RR running, read sent to all 5 replicas, if 3 digest

Re: CL.ONE reads / RR / badness_threshold interaction

2011-04-07 Thread Chris Burroughs
Peter, thank you for the extremely detailed reply. To now answer my own question, the critical points that are different from what I said earlier are: that CL.ONE does prefer *one* node (which one depending on snitch) and that RR uses digests (which are not mentioned on the wiki page [1]) instead

Re: Stress tests failed with secondary index

2011-04-07 Thread aaron morton
Can you turn the logging up to DEBUG level and look for a message from CassandraServer that says ... timed out ? Also check the thread pool stats nodetool tpstats to see if the node is keeping up. Aaron On 7 Apr 2011, at 13:43, Sheng Chen wrote: Thank you Aaron. It does not seem to be

Re: Reappearing nodes

2011-04-07 Thread aaron morton
Sounds like this http://comments.gmane.org/gmane.comp.db.cassandra.user/14498 https://issues.apache.org/jira/browse/CASSANDRA-2371 Aaron On 7 Apr 2011, at 22:36, Viliam Holub wrote: Hi all, dead nodes which I removed via nodetool's removetoken are reappearing in the ring after few days.

reoccurring exceptions seen

2011-04-07 Thread Jonathan Colby
These types of exceptions is seen sporadically in our cassandra logs. They occur especially after running a repair with the nodetool. I assume there are a few corrupt rows. Is this cause for panic? Will a repair fix this, or is it best to do a decomission + bootstrap via a move for

Re: Flush / Snapshot Triggering Full GCs, Leaving Ring

2011-04-07 Thread Jonathan Ellis
No, 2252 is not suitable for backporting to 0.7. On Thu, Apr 7, 2011 at 7:33 AM, ruslan usifov ruslan.usi...@gmail.com wrote: 2011/4/7 Jonathan Ellis jbel...@gmail.com Hypothesis: it's probably the flush causing the CMS, not the snapshot linking. Confirmation possibility #1: Add a

codeigniter+phpcassa

2011-04-07 Thread Courtney Robinson
For anyone using Codeigniter and interested. I've written a little library to integrate Codeigniter with PHPcassa and consequently Cassandra. It provides you with access to code igniter's $this-db instance that only has the library's methods and phpcassa's. Follow up tutorial

Secondary Index Updates Break CLI and Client Code Reading

2011-04-07 Thread Fryar, Dexter
Creating an index, validator, and default validator then renaming/dropping the index later results in read errors. Is there an easy way around this problem without having to keep an invalid definition for a column that will get deleted or expired? 1) create a secondary index on a column with

Re: problem with large batch mutation set

2011-04-07 Thread Ryan King
On Wed, Apr 6, 2011 at 11:49 PM, Ross Black ross.w.bl...@gmail.com wrote: Hi, I am using the thrift client batch_mutate method with Cassandra 0.7.0 on Ubuntu 10.10. When the size of the mutations gets too large, the client fails with the following exception: Caused by:

Re: Secondary Index keeping track of column names

2011-04-07 Thread Roland Gude
You could simulate it thoug. Just Add some Meta Column with a boolean Value indicating if the referred Column is in the Row or Not. Then Add an Index in that Meta Column and query for it. I. E. Row a: (c=1234),(has_c=Yes) Quert : List cf where has_c=Yes Am 06.04.2011 um 18:52 schrieb

Re: Flush / Snapshot Triggering Full GCs, Leaving Ring

2011-04-07 Thread Erik Onnen
I'll capture what I we're seeing here for anyone else who may look into this in more detail later. Our standard heap growth is ~300K in between collections with regular ParNew collections happening on average about every 4 seconds. All very healthy. The memtable flush (where we see almost all

Columns values(integer) need frequent updates/ increments

2011-04-07 Thread Ertio Lew
Hi, I am working on a Question/Answers web app using Cassandra(consider very similar to StackOverflow sites). I need to built the reputation system for users on the application. This way the user's reputation increases when s/he answers correctly somebody's question. Thus if I keep the reputation

Re: Flush / Snapshot Triggering Full GCs, Leaving Ring

2011-04-07 Thread Jonathan Ellis
On Thu, Apr 7, 2011 at 2:27 PM, Erik Onnen eon...@gmail.com wrote: 1) Does this seem like a sane amount of garbage (512MB) to generate when flushing a 64MB table to disk? Sort of -- that's just about exactly the amount of space you'd expect 64MB of serialized data to take, in memory. (Not very

Re: RE: batch_mutate failed: out of sequence response

2011-04-07 Thread Dan Washusen
Pelops uses a single connection per operation from a pool that is backed by Apache Commons Pool (assuming you're using Cassandra 0.7). I'm not saying it's perfect but it's NOT sharing a connection over multiple threads. Dan Hendry mentioned that he sees these errors. Is he also using Pelops?

RE: Abnormal memory consumption

2011-04-07 Thread Jeremiah Jordan
Connect with jconsole and watch the memory consumption graph. Click the force GC button watch what the low point is, that is how much memory is being used for persistent stuff, the rest is garbage generated while satisfying queries. Run a query, watch how the graph spikes up when you run your

weird error when connecting to cassandra mbean proxy

2011-04-07 Thread Anurag Gujral
Hi All, I have written a code for connecting to mbean server runnning on cassandra node. I get the following error: Exception in thread main java.lang.reflect.UndeclaredThrowableException at $Proxy1.getReadOperations(Unknown Source) at

Re: weird error when connecting to cassandra mbean proxy

2011-04-07 Thread Narendra Sharma
The correct object name is org.apache.cassandra.db:type=StorageProxy -Naren On Thu, Apr 7, 2011 at 4:36 PM, Anurag Gujral anurag.guj...@gmail.comwrote: Hi All, I have written a code for connecting to mbean server runnning on cassandra node. I get the following error: Exception in thread

Re: Secondary Index Updates Break CLI and Client Code Reading :: DebugLog Attached

2011-04-07 Thread Jonathan Ellis
Addressed on the issue you created, https://issues.apache.org/jira/browse/CASSANDRA-2436. On Thu, Apr 7, 2011 at 12:19 PM, Fryar, Dexter dexter.fr...@hp.com wrote: I have also attached the debug log with each step attached. I've even tried going back and updating the CF with the old index to

CLI does not list data after upgrading to 0.7.4

2011-04-07 Thread Wenjun Che
Hello I just upgraded a 1-node setup from rc2 to 0.7.4 and ran scrub without any error. Now 'list CF' in CLI does not return any data as followings: list User; Using default limit of 100 Input length = 1 I don't see any errors or exceptions in the log. If I run CLi from 0.7.0 against 0.7.4