Support Forums : DataStax

how to re create OpsCenter column families tables?

(4 posts) (2 voices)

Tags:

No tags yet.

mikek753
Member

hi,

I got some issue in OpsCenter keyspace, it doesn't work anymore as cluster returns

2012-10-31 12:55:23-0700 [] Unhandled Error
Traceback (most recent call last):
Failure: telephus.cassandra.ttypes.SchemaDisagreementException: SchemaDisagreementException()

how I can re create this schema?

No, Node repair for OpsCenter doesn't work as it doesn't show any column families at all.
How I can remove OpsCenter Keyspace from my cluster that OpsCenter app can re create it?

thanks.

Posted 6 months ago #
thobbs
Administrator

You can drop the keyspace and then restart opscenterd.

To drop the keyspace with cassandra-cli:

drop keyspace OpsCenter;

Posted 6 months ago #
thobbs
Administrator

Oops, actually, you won't be able to do that while you have a schema disagreement. To resolve that, please follow the steps here: http://www.datastax.com/docs/1.0/troubleshooting/index#schema-disagreement-exception-occurs

Posted 6 months ago #
mikek753
Member

thank you.
it took me a while.
I have to repeat 2-3 times to remove nodes from incorrect schema, otherwise it appeared again with diff schema, even I removed data completely and use existing good for bootstrap.

I'm not sure why it went like that ...

Posted 6 months ago #

You must log in to post.