Re: alter column family ?

2013-07-18 Thread Robert Coli
On Wed, Jul 17, 2013 at 7:23 PM, Langston, Jim jim.langs...@compuware.comwrote: As a follow up – I did upgrade the cluster to 1.2.6 and that did take care of the issue. The upgrade went very smoothly, the longest part was being thorough on the configuration files, but I was able to able to

Re: alter column family ?

2013-07-17 Thread Langston, Jim
: alter column family ? Was just looking at a bug with uppercase , could that be the error ? And, yes, definitely saved off the original system keyspaces. I'm tailing the logs when running the cassandra-cli, but I do not see anything in the logs .. Jim From: Robert Coli rc

Re: alter column family ?

2013-07-11 Thread Langston, Jim
@cassandra.apache.orgmailto:user@cassandra.apache.org Subject: Re: alter column family ? On Tue, Jul 9, 2013 at 11:52 AM, Langston, Jim jim.langs...@compuware.commailto:jim.langs...@compuware.com wrote: On the command (4 node cluster): nodetool gossipinfo -h localhost |grep SCHEMA |sort | uniq -c | sort -n

Re: alter column family ?

2013-07-11 Thread Robert Coli
On Thu, Jul 11, 2013 at 9:17 AM, Langston, Jim jim.langs...@compuware.comwrote: Are the schema's held somewhere else ? Going through the process that you sent, when I restart the nodes, the original schema's show up If you do not stop all nodes at once and then remove the system CFs, the

Re: alter column family ?

2013-07-11 Thread Langston, Jim
@cassandra.apache.orgmailto:user@cassandra.apache.org user@cassandra.apache.orgmailto:user@cassandra.apache.org Subject: Re: alter column family ? On Thu, Jul 11, 2013 at 9:17 AM, Langston, Jim jim.langs...@compuware.commailto:jim.langs...@compuware.com wrote: Are the schema's held somewhere else ? Going through

Re: alter column family ?

2013-07-11 Thread Robert Coli
On Thu, Jul 11, 2013 at 10:16 AM, Langston, Jim jim.langs...@compuware.comwrote: It feels like the 2 node that are not coming up with the right schema are not seeing the nodes with the correct ones. At the time that the nodes come up, they should have no schema other than the system

Re: alter column family ?

2013-07-11 Thread Langston, Jim
@cassandra.apache.orgmailto:user@cassandra.apache.org Subject: Re: alter column family ? On Thu, Jul 11, 2013 at 10:16 AM, Langston, Jim jim.langs...@compuware.commailto:jim.langs...@compuware.com wrote: It feels like the 2 node that are not coming up with the right schema are not seeing the nodes with the correct ones

Re: alter column family ?

2013-07-11 Thread Robert Coli
On Thu, Jul 11, 2013 at 11:00 AM, Langston, Jim jim.langs...@compuware.comwrote: I went through the whole sequence again and now have gotten to the point of being able to try and pull in the schema, but now getting this error from the one node I'm executing on. [default@unknown] create

Re: alter column family ?

2013-07-11 Thread Langston, Jim
Reply-To: user@cassandra.apache.orgmailto:user@cassandra.apache.org Date: Thu, 11 Jul 2013 11:07:55 -0700 To: user@cassandra.apache.orgmailto:user@cassandra.apache.org user@cassandra.apache.orgmailto:user@cassandra.apache.org Subject: Re: alter column family ? On Thu, Jul 11, 2013 at 11:00 AM

alter column family ?

2013-07-09 Thread Langston, Jim
Hi all, 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

Re: alter column family ?

2013-07-09 Thread Robert Coli
On Tue, Jul 9, 2013 at 10:08 AM, Langston, Jim jim.langs...@compuware.comwrote: 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

Re: alter column family ?

2013-07-09 Thread Langston, Jim
@cassandra.apache.orgmailto:user@cassandra.apache.org Subject: Re: alter column family ? On Tue, Jul 9, 2013 at 10:08 AM, Langston, Jim jim.langs...@compuware.commailto:jim.langs...@compuware.com wrote: I am trying to alter a column family to change gc_grace_seconds, and now, any of the properties The sequence

Re: alter column family ?

2013-07-09 Thread Robert Coli
On Tue, Jul 9, 2013 at 10:26 AM, Robert Coli rc...@eventbrite.com wrote: nodetool -h localhost netstats |grep SCHEMA |sort | uniq -c | sort -n Sorry, I meant gossipinfo and not netstats. With the right command, do you see that all nodes in the cluster have the same schema version? I'm on

Re: alter column family ?

2013-07-09 Thread Langston, Jim
@cassandra.apache.orgmailto:user@cassandra.apache.org Subject: Re: alter column family ? On Tue, Jul 9, 2013 at 10:26 AM, Robert Coli rc...@eventbrite.commailto:rc...@eventbrite.com wrote: nodetool -h localhost netstats |grep SCHEMA |sort | uniq -c | sort -n Sorry, I meant gossipinfo and not netstats

Re: alter column family ?

2013-07-09 Thread Robert Coli
On Tue, Jul 9, 2013 at 11:52 AM, Langston, Jim jim.langs...@compuware.com wrote: On the command (4 node cluster): nodetool gossipinfo -h localhost |grep SCHEMA |sort | uniq -c | sort -n 4 SCHEMA:60edeaa8-70a4-3825-90a5-d7746ffa8e4d If your schemas actually agree (and given that