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 rcoli@eventbrite.com designates
 209.85.128.44 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <CE01BB9A.37A26%jim.langston@compuware.com>
References: <CE01BB9A.37A26%jim.langston@compuware.com>
Date: Tue, 9 Jul 2013 10:26:45 -0700
Message-ID: 
 <CAEDUwd3nYGbfoAgRpQ5fHGX_3w1Zhv08GkWXpnwUoY3=H5_HBw@mail.gmail.com>
Subject: Re: alter column family ?
From: Robert Coli <rcoli@eventbrite.com>
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Content-Type: multipart/alternative; boundary=047d7b6d8c0616f61804e11777c8

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

On Tue, Jul 9, 2013 at 10:08 AM, Langston, Jim
<Jim.Langston@compuware.com>wrote:

>  I am trying to alter a column family to change gc_grace_seconds, and
> now,
> any of the properties
>
>  The sequence:
>
>  use ks ;
> alter table CF with gc_grace_seconds=864000 ;
>
>  When listing the CF, gc_grace_seconds is set to 0, after
> running the CLI, gc_grace_seconds is still set to 0.
>
>  I tried change the comment property, but this did not
> change either.
>
>  Using the same keyspace, I created another table
> and executed both the gc_grace_seconds change and
> the comments change. Both of these successfully changed.
>

I'm surprised to hear that other columnfamilies work in the same keyspace.
In general when people end up in this case, no schema migrations work.

If you do :

nodetool -h localhost netstats |grep SCHEMA |sort | uniq -c | sort -n

Do you see that all nodes in the cluster have the same schema version?

What version of Cassandra?

=Rob

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

<div dir=3D"ltr">On Tue, Jul 9, 2013 at 10:08 AM, Langston, Jim <span dir=
=3D"ltr">&lt;<a href=3D"mailto:Jim.Langston@compuware.com" target=3D"_blank=
">Jim.Langston@compuware.com</a>&gt;</span> wrote:<br><div class=3D"gmail_e=
xtra"><div class=3D"gmail_quote">
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">


<div style=3D"font-size:14px;font-family:Calibri,sans-serif;word-wrap:break=
-word">
<div>I am trying to alter a column family to change gc_grace_seconds, and n=
ow,=A0<br></div>
<div>any of the properties =A0</div>
<div><br>
</div>
<div>The sequence:</div>
<div><br>
</div>
<div>use ks ;</div>
<div>alter table CF with gc_grace_seconds=3D864000 ;</div>
<div><br>
</div>
<div>When listing the CF, gc_grace_seconds is set to 0, after</div>
<div>running the CLI, gc_grace_seconds is still set to 0.</div>
<div><br>
</div>
<div>I tried change the comment property, but this did not</div>
<div>change either.</div>
<div><br>
</div>
<div>Using the same keyspace, I created another table</div>
<div>and executed both the gc_grace_seconds change and</div>
<div>the comments change. Both of these successfully changed.</div></div></=
blockquote><div><br></div><div style>I&#39;m surprised to hear that other c=
olumnfamilies work in the same keyspace. In general when people end up in t=
his case, no schema migrations work.</div>
<div style><br></div><div style>If you do :</div><div style><br></div><div =
style>nodetool -h localhost netstats |grep SCHEMA |sort | uniq -c | sort -n=
</div><div style><br></div><div style>Do you see that all nodes in the clus=
ter have the same schema version?</div>
<div style><br></div><div style>What version of Cassandra?</div><div style>=
<br></div><div style>=3DRob=A0</div></div></div></div>

--047d7b6d8c0616f61804e11777c8--