Re: Question about consistency

2015-09-09 Thread Robert Coli
On Wed, Sep 9, 2015 at 12:07 PM, Eric Plowe wrote: > So I set speculative_retry to NONE and I encountered the situation about > 30 minutes ago. I presume your clocks are synced, and if so that sounds like unexpected behavior. So if you have a means of repro, I would : 1) file an http://issues.

Re: Question about consistency

2015-09-09 Thread Laing, Michael
Wiser heads may have to chime in then :) On Wed, Sep 9, 2015 at 3:07 PM, Eric Plowe wrote: > So I set speculative_retry to NONE and I encountered the situation about > 30 minutes ago. > > > > On Wednesday, September 9, 2015, Laing, Michael > wrote: > >> It appears that: "alter table test.test_r

Re: Question about consistency

2015-09-09 Thread Eric Plowe
So I set speculative_retry to NONE and I encountered the situation about 30 minutes ago. On Wednesday, September 9, 2015, Laing, Michael wrote: > It appears that: "alter table test.test_root with speculative_retry = > 'NONE';" is also valid. > > Seems a bit more definitive :) > > On Wed, Sep 9

Re: Question about consistency

2015-09-09 Thread Laing, Michael
It appears that: "alter table test.test_root with speculative_retry = 'NONE';" is also valid. Seems a bit more definitive :) On Wed, Sep 9, 2015 at 12:11 PM, Eric Plowe wrote: > Yeah, that's what I did. Just wanted to verify it that will indeed turn it > off. > > On Wednesday, September 9, 2015

Re: Question about consistency

2015-09-09 Thread Eric Plowe
Yeah, that's what I did. Just wanted to verify it that will indeed turn it off. On Wednesday, September 9, 2015, Laing, Michael wrote: > "alter table test.test_root WITH speculative_retry = '0.0PERCENTILE';" > > seemed to work for me with C* version 2.1.7 > > On Wed, Sep 9, 2015 at 10:11 AM, Eri

Re: Question about consistency

2015-09-09 Thread Laing, Michael
"alter table test.test_root WITH speculative_retry = '0.0PERCENTILE';" seemed to work for me with C* version 2.1.7 On Wed, Sep 9, 2015 at 10:11 AM, Eric Plowe wrote: > Would this work: > > ALTER TABLE session_state WITH speculative_retry = '0ms'; > ALTER TABLE session_state WITH speculative_ret

Re: Question about consistency

2015-09-09 Thread Eric Plowe
Would this work: ALTER TABLE session_state WITH speculative_retry = '0ms'; ALTER TABLE session_state WITH speculative_retry = '0PERCENTILE'; I can't set it to 0, but was wondering if these would have the same effect? ~Eric On Wed, Sep 9, 2015 at 8:19 AM, Eric Plowe wrote: > Interesting. I'll

Re: Question about consistency

2015-09-09 Thread Eric Plowe
Interesting. I'll give it a try and report back my findings. Thank you, Michael. On Wednesday, September 9, 2015, Laing, Michael wrote: > Perhaps a variation on > https://issues.apache.org/jira/browse/CASSANDRA-9753? > > You could try setting speculative retry to 0 to avoid cross-dc reads. > >

Re: Question about consistency

2015-09-09 Thread Laing, Michael
Perhaps a variation on https://issues.apache.org/jira/browse/CASSANDRA-9753? You could try setting speculative retry to 0 to avoid cross-dc reads. On Wed, Sep 9, 2015 at 7:55 AM, Eric Plowe wrote: > read_repair_chance: 0 > dclocal_read_repair_chance: 0.1 > > > On Wednesday, September 9, 2015, L

Re: Question about consistency

2015-09-09 Thread Eric Plowe
read_repair_chance: 0 dclocal_read_repair_chance: 0.1 On Wednesday, September 9, 2015, Laing, Michael wrote: > What are your read repair settings? > > On Tue, Sep 8, 2015 at 9:28 PM, Eric Plowe > wrote: > >> To further expand. We have two data centers, Miami and Dallas. Dallas is >> our disaste

Re: Question about consistency

2015-09-09 Thread Laing, Michael
What are your read repair settings? On Tue, Sep 8, 2015 at 9:28 PM, Eric Plowe wrote: > To further expand. We have two data centers, Miami and Dallas. Dallas is > our disaster recovery data center. The cluster has 12 nodes, 6 in Miami and > 6 in Dallas. The servers in Miami only read/write to Mi

Re: Question about consistency

2015-09-08 Thread Eric Plowe
To further expand. We have two data centers, Miami and Dallas. Dallas is our disaster recovery data center. The cluster has 12 nodes, 6 in Miami and 6 in Dallas. The servers in Miami only read/write to Miami using data center aware load balancing policy of the driver. We have the problem when writi

Re: Question about consistency

2015-09-08 Thread Eric Plowe
Rob, All writes/reads are happening from DC1. DC2 is a backup. The web app does not handle live requests from DC2. Regards, Eric Plowe On Tuesday, September 8, 2015, Robert Coli wrote: > On Tue, Sep 8, 2015 at 4:40 PM, Eric Plowe > wrote: > >> I'm using Cassandra as a storage mechanism for s

Re: Question about consistency

2015-09-08 Thread Robert Coli
On Tue, Sep 8, 2015 at 4:40 PM, Eric Plowe wrote: > I'm using Cassandra as a storage mechanism for session state persistence > for an ASP.NET web application. I am seeing issues where the session > state is persisted on one page (setting a value: Session["key"] = > "value" and when it redirects t

Question about consistency

2015-09-08 Thread Eric Plowe
I'm using Cassandra as a storage mechanism for session state persistence for an ASP.NET web application. I am seeing issues where the session state is persisted on one page (setting a value: Session["key"] = "value" and when it redirects to another (from a post back event) and check for the existen

Re: Question about consistency in cassandra 2.0.9

2015-06-11 Thread K F
cassandra. Regards,Ken From: graham sanderson To: user@cassandra.apache.org; K F Sent: Thursday, June 11, 2015 8:14 PM Subject: Re: Question about consistency in cassandra 2.0.9 It looks (I’m guessing with entirely not enough info) that you only have two nodes in DC4, and are probably

Re: Question about consistency in cassandra 2.0.9

2015-06-11 Thread graham sanderson
It looks (I’m guessing with entirely not enough info) that you only have two nodes in DC4, and are probably writing at QUORUM reading at LOCAL_ONE. But please specify your configuration > On Jun 11, 2015, at 7:01 PM, K F wrote: > > Hi, > > I am running a cassandra cluster with 4 dcs. Out of 4

Question about consistency in cassandra 2.0.9

2015-06-11 Thread K F
Hi, I am running a cassandra cluster with 4 dcs. Out of 4 dcs, I have 3 DCs returning right data but 1 dc where I had 1 node down, the data didn't return correct records. So, e.g. DC1 - 386 records (single-token based DC)DC2 - 386 records (vnode based DC)DC3 - 386 records (vnode based DC)DC4 - 1

Re: Question about consistency levels

2013-11-10 Thread graham sanderson
erent version of Cassandra, a different > client and likely have different read/write/delete usage. > > Hope that helps. > > -Original Message- > From: graham sanderson [mailto:gra...@vast.com] > Sent: 10 November 2013 06:12 > To: user@cassandra.apache.org >

RE: Question about consistency levels

2013-11-10 Thread Richard Lowe
on [mailto:gra...@vast.com] Sent: 10 November 2013 06:12 To: user@cassandra.apache.org Subject: Question about consistency levels I'm trying to be more succinct this time since no answers on my last attempt. We are currently using 2.0.2 in test (no C* in production yet), and use (LOCAL_)QUOR

Question about consistency levels

2013-11-09 Thread graham sanderson
I’m trying to be more succinct this time since no answers on my last attempt. We are currently using 2.0.2 in test (no C* in production yet), and use (LOCAL_)QUORUM CL on read and writes which guarantees (if successful) that we read latest data. That said, it is highly likely that (LOCAL_)ONE w