Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
MIME-Version: 1.0
In-Reply-To: <CAA0zji79ddsca64uDPOem9EZGO=E3yeLaPAK=DbDhEtw3WXOnw@mail.gmail.com>
References: <CAA0zji79ddsca64uDPOem9EZGO=E3yeLaPAK=DbDhEtw3WXOnw@mail.gmail.com>
From: Edward Capriolo <edlinuxguru@gmail.com>
Date: Mon, 17 Oct 2016 12:03:59 -0400
Message-ID: <CAENxBwxdnQ4Wp6zsk4nq54V7VNG3G6xME4wWPVOkedNexm4urg@mail.gmail.com>
Subject: Re: Inconsistencies in materialized views
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Content-Type: multipart/alternative; boundary=001a11411c6a5cec52053f11b94c
archived-at: Mon, 17 Oct 2016 16:04:52 -0000

--001a11411c6a5cec52053f11b94c
Content-Type: text/plain; charset=UTF-8

https://issues.apache.org/jira/browse/CASSANDRA-11198

Which has problems "maybe" fixed by:

https://issues.apache.org/jira/browse/CASSANDRA-11475

Which has it's own set of problems.

One of these patches was merged into 3.7 which tells you are running a
version 3.6 with known bugs. Also as the feature is "new ish" you should be
aware that "new ish" major features usually take 4-6 versions to solidify.


On Mon, Oct 17, 2016 at 3:19 AM, siddharth verma <
sidd.verma29.list@gmail.com> wrote:

> Hi,
> We have a base table with ~300 million entries.
> And in a recent sanity activity, I saw approx ~33k entires(in one DC)
> which were in the materialized view, but not in the base table. (reads with
> quorum, DCAware)
> (I haven't done it the other way round yet, i.e. entries in base table but
> not in materialized view)
>
> Could someone suggest a possible cause for the same?
> We saw some glitches in cassandra cluster
> 1. node down.
> If this is the case, will repair fix the issue?
> 2. IOPS maxed out in one DC.
> 3. Another DC added with some glitches.
>
> Could someone suggest how could we replicate inconsistency between base
> table and materialized view. Any help would be appreciated.
>
> C* 3.6
> Regards
> SIddharth Verma
> (Visit https://github.com/siddv29/cfs for a high speed cassandra full
> table scan)
>

--001a11411c6a5cec52053f11b94c
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><a href=3D"https://issues.apache.org/jira/browse/CASSANDRA=
-11198">https://issues.apache.org/jira/browse/CASSANDRA-11198</a><br><br>Wh=
ich has problems &quot;maybe&quot; fixed by:<br><br><a href=3D"https://issu=
es.apache.org/jira/browse/CASSANDRA-11475">https://issues.apache.org/jira/b=
rowse/CASSANDRA-11475</a><br><br>Which has it&#39;s own set of problems.=C2=
=A0<br><br>One of these patches was merged into 3.7 which tells you are run=
ning a version 3.6 with known bugs. Also as the feature is &quot;new ish&qu=
ot; you should be aware that &quot;new ish&quot; major features usually tak=
e 4-6 versions to solidify.<br><br><br></div><div class=3D"gmail_extra"><br=
><div class=3D"gmail_quote">On Mon, Oct 17, 2016 at 3:19 AM, siddharth verm=
a <span dir=3D"ltr">&lt;<a href=3D"mailto:sidd.verma29.list@gmail.com" targ=
et=3D"_blank">sidd.verma29.list@gmail.com</a>&gt;</span> wrote:<br><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc s=
olid;padding-left:1ex"><div dir=3D"ltr">Hi,<div>We have a base table with ~=
300 million entries.</div><div>And in a recent sanity activity, I saw appro=
x ~33k entires(in one DC) which were in the materialized view, but not in t=
he base table. (reads with quorum, DCAware)</div><div>(I haven&#39;t done i=
t the other way round yet, i.e. entries in base table but not in materializ=
ed view)</div><div><br></div><div>Could someone suggest a possible cause fo=
r the same?</div><div>We saw some glitches in cassandra cluster</div><div>1=
. node down.=C2=A0</div><div>If this is the case, will repair fix the issue=
?</div><div>2. IOPS maxed out in one DC.</div><div>3. Another DC added with=
 some glitches.</div><div><br></div><div>Could someone suggest how could we=
 replicate inconsistency between base table and materialized view. Any help=
 would be appreciated.</div><div><br></div><div>C* 3.6</div><div>Regards</d=
iv><span class=3D"HOEnZb"><font color=3D"#888888"><div>SIddharth Verma</div=
><div>(Visit <a href=3D"https://github.com/siddv29/cfs" target=3D"_blank">h=
ttps://github.com/siddv29/cfs</a> for a high speed cassandra full table sca=
n)<br></div></font></span></div>
</blockquote></div><br></div>

--001a11411c6a5cec52053f11b94c--