Hi Dipan,
Did you try following the advice in the referenced DataStax article called Mutation of <https://support.datastax.com/hc/en-us/articles/207267063-Mutation-of-x-byte s-is-too-large-for-the-maxiumum-size-of-y-> <x> bytes is too large for the maximum size of <y> as suggested in the stackoverflow.com post you cited? Kenneth Brotman From: Dipan Shah [mailto:dipan....@hotmail.com] Sent: Thursday, February 28, 2019 2:23 AM To: Dipan Shah; user@cassandra.apache.org Subject: Re: MV's stuck in build state Forgot to add version info. This is on 3.7. [cqlsh 5.0.1 | Cassandra 3.7 | CQL spec 3.4.2 | Native protocol v4] Thanks, Dipan Shah _____ From: Dipan Shah <dipan....@hotmail.com> Sent: Thursday, February 28, 2019 3:38 PM To: user@cassandra.apache.org Subject: MV's stuck in build state Hello All, I have a few MV's that are stuck in build state because of a bad schema design and thus getting a lot of messages like this "Mutation xxx is too large for maximum size of 16.000MiB". I have dropped those MV's and I can no longer see their schema in the keyspace. But they are visible under "system.views_build_in_progress" and "nodetool viewbuildstatus". I have tried "nodetool stop VIEW_BUILD" as suggested here: https://stackoverflow.com/questions/40553499/stop-cassandra-materialized-vie w-build and have also reboot a few nodes in the cluster. This has also not helped. Is there anything else that can be done over here? <https://stackoverflow.com/questions/40553499/stop-cassandra-materialized-vi ew-build> <https://stackoverflowcom/questions/40553499/stop-cassandra-materialized-vie w-build> Stop Cassandra Materialized View Build - Stack Overflow Its not documented, but nodetool stop actually takes any compaction type, not just the ones listed (which the view build is one of). So you can simply: nodetool stop VIEW_BUILD Or you can hit JMX directly with the org.apache.cassandra.db:type=CompactionManager mbean's stopCompaction operation.. All thats really gonna do is set a flag for the view builder to stop on its next loop. stackoverflow.com Thanks, Dipan Shah
