[
https://issues.apache.org/jira/browse/CASSANDRA-16320?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17250180#comment-17250180
]
Benjamin Lerer commented on CASSANDRA-16320:
--------------------------------------------
[~yazalulloa] It would be great if you could provide us with a clear scenario:
What was your original schema and what changes you did?
That might allow us to figure out a way of recovering your data and of
preventing this kind of scenario.
You can change the column, table and type names in the schema that you provide
if you want to.
> Cassandra fails to start after schema changed
> ---------------------------------------------
>
> Key: CASSANDRA-16320
> URL: https://issues.apache.org/jira/browse/CASSANDRA-16320
> Project: Cassandra
> Issue Type: Bug
> Reporter: Yazal Ulloa
> Priority: Normal
>
> I'm using Cassandra 3.11.6 on Centos 7 with a 3 node cluster, I ran some
> schema changes, drop tables/materialized views, alter tables, etc, after that
> one of the materialized views was failing with this error:
> org.apache.cassandra.schema.SchemaKeyspace$MissingColumns: No partition key
> columns found in schema table for my_keyspace.my_materialized_view.
>
> I wanted to replace that materialized view with a table, with the same name
> though, that might be why it's failing
>
> I ran nodetool describecluster and found the schema version was different, I
> tried to run a repair, it didn't work, I restarted the nodes, but they didn't
> start.
> This is the error that is showing up in cassandra.log
>
> ERROR [main] 2020-12-09 10:13:15,827 SchemaKeyspace.java:1017 - No partition
> columns found for table my_keyspace.my_materialized_view in
> system_schema.columns. This may be due to corruption or concurrent dropping
> and altering of a table. If this table is supposed to be dropped, run the
> following query to cleanup: "DELETE FROM system_schema.tables WHERE
> keyspace_name = 'my_keyspace' AND table_name = 'my_materialized_view'; DELETE
> FROM system_schema.columns WHERE keyspace_name = 'my_keyspace' AND table_name
> = 'my_materialized_view';" If the table is not supposed to be dropped,
> restore system_schema.columns sstables from backups.
> org.apache.cassandra.schema.SchemaKeyspace$MissingColumns: No partition key
> columns found in schema table for my_keyspace.my_materialized_view
> at
> org.apache.cassandra.schema.SchemaKeyspace.fetchColumns(SchemaKeyspace.java:1106)
> [apache-cassandra-3.11.6.jar:3.11.6]
> at
> org.apache.cassandra.schema.SchemaKeyspace.fetchTable(SchemaKeyspace.java:1046)
> [apache-cassandra-3.11.6.jar:3.11.6]
> at
> org.apache.cassandra.schema.SchemaKeyspace.fetchTables(SchemaKeyspace.java:1000)
> [apache-cassandra-3.11.6.jar:3.11.6]
> at
> org.apache.cassandra.schema.SchemaKeyspace.fetchKeyspace(SchemaKeyspace.java:959)
> [apache-cassandra-3.11.6.jar:3.11.6]
> at
> org.apache.cassandra.schema.SchemaKeyspace.fetchKeyspacesWithout(SchemaKeyspace.java:936)
> [apache-cassandra-3.11.6.jar:3.11.6]
> at
> org.apache.cassandra.schema.SchemaKeyspace.fetchNonSystemKeyspaces(SchemaKeyspace.java:924)
> [apache-cassandra-3.11.6.jar:3.11.6]
> at org.apache.cassandra.config.Schema.loadFromDisk(Schema.java:92)
> [apache-cassandra-3.11.6.jar:3.11.6]
> at org.apache.cassandra.config.Schema.loadFromDisk(Schema.java:82)
> [apache-cassandra-3.11.6.jar:3.11.6]
> at
> org.apache.cassandra.service.CassandraDaemon.setup(CassandraDaemon.java:269)
> [apache-cassandra-3.11.6.jar:3.11.6]
> at
> org.apache.cassandra.service.CassandraDaemon.activate(CassandraDaemon.java:630)
> [apache-cassandra-3.11.6.jar:3.11.6]
> at
> org.apache.cassandra.service.CassandraDaemon.main(CassandraDaemon.java:757)
> [apache-cassandra-3.11.6.jar:3.11.6]
>
> I tried starting Cassandra with
> -Dcassandra.ignore_corrupted_schema_tables=true and it doesn't work.
>
> Is there a way to fix this?
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
