Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of jlacefield@datastax.com
 designates 209.85.220.176 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CABNrtf0e6_nqJqihdJ1oT7VF53V54vXrguBuNp4WNAUPjiTKOA@mail.gmail.com>
References: 
 <CABNrtf0e6_nqJqihdJ1oT7VF53V54vXrguBuNp4WNAUPjiTKOA@mail.gmail.com>
Date: Wed, 26 Feb 2014 09:18:54 -0500
Message-ID: 
 <CAOP8aV-H4fAppravwTimF396zqmnD=5nikSKbkm72K2jxXq0mA@mail.gmail.com>
Subject: Re: Cassandra nodetool status result after restoring snapshot
From: Jonathan Lacefield <jlacefield@datastax.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=047d7bdc7a4a817e3504f34fe210

--047d7bdc7a4a817e3504f34fe210
Content-Type: text/plain; charset=ISO-8859-1

Hello,

  That's a large variation between the old and new cluster.  Are you sure
you pulled over all the SSTables for your keyspaces?  Also, did you run a
repair after the data move?  Do you have a lot of tombstone data in the old
cluster that was removed during the migration process?  Are you using
Opscenter?

  A quick comparison of cfstats between clusters may help you analyze your
situation and help you pinpoint if you are missing any data for a
particular keyspace, etc as well.

Thanks,

Jonathan

Jonathan Lacefield
Solutions Architect, DataStax
(404) 822 3487
<http://www.linkedin.com/in/jlacefield>


<http://www.datastax.com/what-we-offer/products-services/training/virtual-training>


On Wed, Feb 26, 2014 at 6:07 AM, Ranking Lekarzy <
rankinglekarzy.dev@gmail.com> wrote:

> Hi
>
> I have two separated clusters consist of 4 nodes. One cluster is running
> on 1.2.12 and the other one on 2.0.5. I loaded data from first cluster
> (1.2.12) to the second one (2.0.5) by copying snapshots between
> corresponding nodes. I removed commitlogs, started second cluster and run
> nodetool upgradesstables.
> After this I expect that nodetool status will give me the same results in
> "Load" column on both clusters. Unfortunately it is completely different:
> - old cluster: [728.02 GB, 558.24 GB, 787.08 GB, 555.1 GB]
> - new cluster: [14.63 GB, 35.98 GB, 18 GB, 38.39 GB]
>
> When I briefly check data on new cluster it looks fine. But I'm worry
> about this difference. Do you have any idea what does it mean?
>
> Thanks,
> Michu
>

--047d7bdc7a4a817e3504f34fe210
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hello,<div><br></div><div>=A0 That&#39;s a large variation=
 between the old and new cluster. =A0Are you sure you pulled over all the S=
STables for your keyspaces? =A0Also, did you run a repair after the data mo=
ve? =A0Do you have a lot of tombstone data in the old cluster that was remo=
ved during the migration process? =A0Are you using Opscenter? =A0</div>
<div><br></div><div>=A0 A quick comparison of cfstats between clusters may =
help you analyze your situation and help you pinpoint if you are missing an=
y data for a particular keyspace, etc as well.</div><div><br></div><div>Tha=
nks,</div>
<div><br></div><div>Jonathan</div></div><div class=3D"gmail_extra"><br clea=
r=3D"all"><div><div dir=3D"ltr">Jonathan Lacefield<div>Solutions Architect,=
 DataStax</div><div>(404) 822 3487</div><div><a href=3D"http://www.linkedin=
.com/in/jlacefield" target=3D"_blank"><img src=3D"http://s.c.lnkd.licdn.com=
/scds/common/u/img/logos/logo_linkedin_92x22.png"></a><br>
</div><div><br></div><div><br></div><div><a href=3D"http://www.datastax.com=
/what-we-offer/products-services/training/virtual-training" target=3D"_blan=
k"><img src=3D"http://www.datastax.com/wp-content/themes/datastax-2013/imag=
es/email-sig/email-sig-virtual-training.png"></a><br>
</div></div></div>
<br><br><div class=3D"gmail_quote">On Wed, Feb 26, 2014 at 6:07 AM, Ranking=
 Lekarzy <span dir=3D"ltr">&lt;<a href=3D"mailto:rankinglekarzy.dev@gmail.c=
om" target=3D"_blank">rankinglekarzy.dev@gmail.com</a>&gt;</span> wrote:<br=
><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1=
px #ccc solid;padding-left:1ex">
<div dir=3D"ltr">Hi<div><br></div><div>I have two separated clusters consis=
t of 4 nodes. One cluster is running on 1.2.12 and the other one on 2.0.5. =
I loaded data from first cluster (1.2.12) to the second one (2.0.5) by copy=
ing snapshots between corresponding nodes. I removed commitlogs, started se=
cond cluster and run nodetool upgradesstables.<br>

</div><div>After this I expect that nodetool status will give me the same r=
esults in &quot;Load&quot; column on both clusters. Unfortunately it is com=
pletely different:</div><div>- old cluster: [728.02 GB,=A0558.24 GB,=A0787.=
08 GB,=A0555.1 GB]</div>

<div>- new cluster: [14.63 GB, 35.98 GB, 18 GB, 38.39 GB]</div><div><br></d=
iv><div>When I briefly check data on new cluster it looks fine. But I&#39;m=
 worry about this difference. Do you have any idea what does it mean?</div>

<div><br></div><div>Thanks,</div><div>Michu</div></div>
</blockquote></div><br></div>

--047d7bdc7a4a817e3504f34fe210--