cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Richard Crowley...@rcrowley.org>
Subject Re: Secondary index partially created
Date Fri, 24 Aug 2012 17:35:44 GMT
On Thu, Aug 23, 2012 at 6:54 PM, Richard Crowley <r@rcrowley.org> wrote:
> I have a three-node cluster running Cassandra 1.0.10.  In this cluster
> is a keyspace with RF=3.  I *updated* a column family via Astyanax to
> add a column definition with an index on that column.  Then I ran a
> backfill to populate the column in every row.  Then I tried to query
> the index from Java and it failed but so did cassandra-cli:
>
>     get my_column_family where my_column = 'my_value';
>
> Two out of the three nodes are unable to query the new index and throw
> this error:
>
>     InvalidRequestException(why:No indexed columns present in index
> clause with operator EQ)
>
> The third is able to query the new index happily but doesn't find any
> results, even when I expect it to.

This morning the one node that's able to query the index is also able
to produce the expected results.  I'm a dummy and didn't use science
so I don't know if the `nodetool compact` I ran across the cluster had
anything to do with it.  Regardless, it did not change the situation
in any other way.

>
> `describe cluster;` in cassandra-cli confirms that all three nodes
> have the same schema and `show schema;` confirms that schema includes
> the new column definition and its index.
>
> The my_column_family.my_index-hd-* files only exist on that one node
> that can query the index.
>
> I ran `nodetool repair` on each node and waited for `nodetool
> compactionstats` to report zero pending tasks.  Ditto for `nodetool
> compact`.  The nodes that failed still fail.  The node that succeeded
> still succeed.
>
> Can anyone shed some light?  How do I convince it to let me query the
> index from any node?  How do I get it to find results?
>
> Thanks,
>
> Richard

Mime
View raw message