[
https://issues.apache.org/jira/browse/CASSANDRA-13813?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16198482#comment-16198482
]
Aleksey Yeschenko commented on CASSANDRA-13813:
-----------------------------------------------
bq. My only bother is that while I haven't actually tried it recently, last
time I did try updating the schema tables manually, it was annoying because the
changes were not automatically picked-up and in fact tended to be overridden,
so I had to force a reload in weird ways (altering some other unrelated table
in the keyspace, which here would actually be an issue). So it would be nice if
we added a JMX call to force reload schema tables from disk to make this easier
(should be easy). If we do, I'm warming up to the idea of considering this is
the only really safe work-around until we find a better way to deal with all
thise.
Yep. You either do an unrelated {{ALTER}} (usually {{WITH comment = ...}}) or
bounce the node. Also wouldn't mind at all adding the new JMX call, as a
companion to {{resetlocalschema}}.
> Don't let user drop (or generally break) tables in system_distributed
> ---------------------------------------------------------------------
>
> Key: CASSANDRA-13813
> URL: https://issues.apache.org/jira/browse/CASSANDRA-13813
> Project: Cassandra
> Issue Type: Bug
> Components: Distributed Metadata
> Reporter: Sylvain Lebresne
> Assignee: Aleksey Yeschenko
> Fix For: 3.0.x, 3.11.x
>
>
> There is not currently no particular restrictions on schema modifications to
> tables of the {{system_distributed}} keyspace. This does mean you can drop
> those tables, or even alter them in wrong ways like dropping or renaming
> columns. All of which is guaranteed to break stuffs (that is, repair if you
> mess up with on of it's table, or MVs if you mess up with
> {{view_build_status}}).
> I'm pretty sure this was never intended and is an oversight of the condition
> on {{ALTERABLE_SYSTEM_KEYSPACES}} in
> [ClientState|https://github.com/apache/cassandra/blob/trunk/src/java/org/apache/cassandra/service/ClientState.java#L397].
> That condition is such that any keyspace not listed in
> {{ALTERABLE_SYSTEM_KEYSPACES}} (which happens to be the case for
> {{system_distributed}}) has no specific restrictions whatsoever, while given
> the naming it's fair to assume the intention that exactly the opposite.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
