You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by "sj.climber" <sj...@gmail.com> on 2012/07/17 23:54:35 UTC

Inability to drop column families

Looking for ideas on how to diagnose this issue.  I have installed v1.1.2 on
a two-node cluster (the data files loaded, incidentally, were from an
earlier v1.1.1 2-node setup).  While initially I recall being able to
create/drop column families, I am no longer able to.  

Let's say I have column family MyFamily in MyKeyspace.  Using cassandra-cli,
I issue:
[default@unknown] use MyKeyspace;
Authenticated to keyspace: MyKeyspace
[default@galaxy_lookups] drop column family MyFamily;
27f5c6bc-8cf3-3671-94e6-9f905be28c35
Waiting for schema agreement...
... schemas agree across the cluster

However, the column family is still there, either way using "describe" from
within cassandra-cli, or through nodetool cfstats.  Moreover, there are no
errors in the Cassandra logs.

Ideas on what to try next? Thanks!



--
View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Inability-to-drop-column-families-tp7581297.html
Sent from the cassandra-user@incubator.apache.org mailing list archive at Nabble.com.

Re: Inability to drop column families

Posted by Code Box <co...@gmail.com>.
Go and look in the data directory on the disk and check if the files still
exist there?


On Thu, Jul 19, 2012 at 2:56 PM, Kirk <ki...@mustardgrain.com> wrote:

> What does "show schema" show? Is the CF showing up?
>
> Are the data files for the CF on disk?
>
> If you poke around with the system CFs, is there any data still present?
>
>
> On 07/17/2012 02:54 PM, sj.climber wrote:
>
>> Looking for ideas on how to diagnose this issue.  I have installed v1.1.2
>> on
>> a two-node cluster (the data files loaded, incidentally, were from an
>> earlier v1.1.1 2-node setup).  While initially I recall being able to
>> create/drop column families, I am no longer able to.
>>
>> Let's say I have column family MyFamily in MyKeyspace.  Using
>> cassandra-cli,
>> I issue:
>> [default@unknown] use MyKeyspace;
>> Authenticated to keyspace: MyKeyspace
>> [default@galaxy_lookups] drop column family MyFamily;
>> 27f5c6bc-8cf3-3671-94e6-**9f905be28c35
>> Waiting for schema agreement...
>> ... schemas agree across the cluster
>>
>> However, the column family is still there, either way using "describe"
>> from
>> within cassandra-cli, or through nodetool cfstats.  Moreover, there are no
>> errors in the Cassandra logs.
>>
>> Ideas on what to try next? Thanks!
>>
>>
>>
>> --
>> View this message in context: http://cassandra-user-**
>> incubator-apache-org.3065146.**n2.nabble.com/Inability-to-**
>> drop-column-families-**tp7581297.html<http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Inability-to-drop-column-families-tp7581297.html>
>> Sent from the cassandra-user@incubator.**apache.org<ca...@incubator.apache.org>mailing list archive at Nabble.com.
>>
>
>

Re: Inability to drop column families

Posted by Kirk <ki...@mustardgrain.com>.
What does "show schema" show? Is the CF showing up?

Are the data files for the CF on disk?

If you poke around with the system CFs, is there any data still present?

On 07/17/2012 02:54 PM, sj.climber wrote:
> Looking for ideas on how to diagnose this issue.  I have installed v1.1.2 on
> a two-node cluster (the data files loaded, incidentally, were from an
> earlier v1.1.1 2-node setup).  While initially I recall being able to
> create/drop column families, I am no longer able to.
>
> Let's say I have column family MyFamily in MyKeyspace.  Using cassandra-cli,
> I issue:
> [default@unknown] use MyKeyspace;
> Authenticated to keyspace: MyKeyspace
> [default@galaxy_lookups] drop column family MyFamily;
> 27f5c6bc-8cf3-3671-94e6-9f905be28c35
> Waiting for schema agreement...
> ... schemas agree across the cluster
>
> However, the column family is still there, either way using "describe" from
> within cassandra-cli, or through nodetool cfstats.  Moreover, there are no
> errors in the Cassandra logs.
>
> Ideas on what to try next? Thanks!
>
>
>
> --
> View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Inability-to-drop-column-families-tp7581297.html
> Sent from the cassandra-user@incubator.apache.org mailing list archive at Nabble.com.