v.19.3New Features
Added the KILL MUTATION Statement That Allows Removing Mutations That Are for Some Reasons Stuck
Added theKILL MUTATIONstatement that allows removing mutations that are for some reasons stuck. Addedlatest_failed_part,latest_fail_time,latest_fail_reasonfields to thesystem.mutationstable for easier troubleshooting. #4287 (Alex Zatelepin)
Why it matters
This feature addresses the issue of mutations getting stuck and provides administrators with tools to manually terminate these stuck mutations. Additionally, the new fields in thesystem.mutations table help users identify and diagnose mutation failures more effectively by providing detailed failure information.How to use it
To remove a stuck mutation, use theKILL MUTATION statement targeting the specific mutation. For troubleshooting, query the system.mutations table and utilize the new fields (latest_failed_part, latest_fail_time, latest_fail_reason) to gather information about the most recent mutation failures.