Hi there, Version :- Cassandra 3.0.7
I attempted to create a Materialized View on a certain table and it failed with never-ending WARN message "Mutation of <x> bytes is too large for the maximum size of <y>". "nodetool stop VIEW_BUILD" also did not help. That seems to be a result of https://issues.apache.org/jira/browse/CASSANDRA-11670 which is fixed in newer versions. So I tried dropping the view and that generated error messages like following :- ERROR [CompactionExecutor:632] [Timestamp] Keyspace.java:475 - Attempting to mutate non-existant table 7c2e1c40-b82b-11e6-9d20-4b0190661423 (keyspace_name.view_name) I performed an incremental repair of the table on which view was created and a rolling restart to stop these errors. Now I see huge size of system.batches table on one of the nodes. It seems related to issues mentioned above since last modification timestamps of the sstable files inside system/batches is same as when I tried to drop the MV. Some insight and suggestions regarding it will be very helpful. I will like to know if i can safely truncate the table, rm the files or any other approach to clean it up? Thanks.
