cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sebastian Estevez <>
Subject Re: UnknownColumnFamily exception / schema inconsistencies
Date Fri, 13 Nov 2015 17:56:59 GMT
I think you're just missing the steps in *Bold*:


4)Identify from schema_column_families which cf ID is the "new" one
(currently in use).

cqlsh -e "select * from system.schema_column_families"|grep <table name>

*5) Move the data from the "old" one to the "new" one and remove the
old directory. *

*6) If there are multiple "old" ones repeat 5 for every "old" directory.*

*7) run nodetool refresh*

All the best,

[image: datastax_logo.png] <>

Sebastián Estévez

Solutions Architect | 954 905 8615 |

[image: linkedin.png] <> [image:
facebook.png] <> [image: twitter.png]
<> [image: g+.png]


DataStax is the fastest, most scalable distributed database technology,
delivering Apache Cassandra to the world’s most innovative enterprises.
Datastax is built to be agile, always-on, and predictably scalable to any
size. With more than 500 customers in 45 countries, DataStax is the
database technology and transactional backbone of choice for the worlds
most innovative companies such as Netflix, Adobe, Intuit, and eBay.

On Fri, Nov 13, 2015 at 12:37 PM, Maciek Sakrejda <> wrote:

> Any advice on how to proceed here? Sebastian seems to have guessed
> correctly at the underlying issue, but I'm still not sure how to resolve
> this given what I see in the data directory and the catalogs.
> On Wed, Nov 11, 2015 at 12:15 PM, Maciek Sakrejda <>
> wrote:
>> On Wed, Nov 11, 2015 at 9:55 AM, Sebastian Estevez <
>>> wrote:
>>> Stupid question, but how do I find the problem table? The error message
>>>> complains about a keyspace (by uuid); I haven't seen errors relating to a
>>>> specific table. I've poked around in the data directory, but I'm not sure
>>>> what I'm looking for.
>>> Is the message complaining about a *keyspace* or abou*t a table (cfid)*?
>>> You'r original was complaining about a table:
>>> UnknownColumnFamilyException reading from
>>>> socket; closing org.apache.cassandra.db.UnknownColumnFamilyException:
>>>> Couldn't find *cfId=3ecce750-84d3-11e5-bdd9-**dd7717dcdbd5*
>> Sorry, you're absolutely right--it's the table from this error message. I
>> confused myself. But now I was able to find it:
>> cursors-3ecce75084d311e5bdd9dd7717dcdbd5
>> cursors-3ed23e8084d311e583b30fc0205655f5
>> The second uuid is the one that shows up via the schema_columnfamilies
>> query, but on two of the nodes, the directory with the *other* uuid exists.
>> Can I just rename the directory on these two nodes? Or how should I proceed?

View raw message