Upgrade check fails if threre's invalid mutation #39174
Description
There are lot of error on server startup, because some mutation cannot be executed:
2022.07.13 11:29:46.963353 [ 926970 ] {} <Error> MutateFromLogEntryTask: virtual bool DB::ReplicatedMergeMutateTaskBase::executeStep(): Code: 6. DB::Exception: Cannot parse string 'Hello' as UInt64: syntax error at begin of string. Note: there are toUInt64OrZero and toUInt64OrNull functions, which returns zero/NULL instead of throwing exception.: while executing 'FUNCTION _CAST(value :: 2, 'UInt64' :: 3) -> _CAST(value, 'UInt64') UInt64 : 4': (while reading from part /var/lib/clickhouse/store/979/979f9e75-9058-4985-9369-d38296a45f93/20191002_1_1_0_2/): While executing MergeTreeInOrder. (CANNOT_PARSE_TEXT), Stack trace (when copying this message, always include the lines below):
2022.07.13 11:30:23.431180 [ 926991 ] {} <Error> MutateFromLogEntryTask: virtual bool DB::ReplicatedMergeMutateTaskBase::executeStep(): Code: 6. DB::Exception: Cannot parse string 'Hello' as UInt64: syntax error at begin of string. Note: there are toUInt64OrZero and toUInt64OrNull functions, which returns zero/NULL instead of throwing exception.: while executing 'FUNCTION _CAST(value :: 2, 'UInt64' :: 3) -> _CAST(value, 'UInt64') UInt64 : 4': (while reading from part /var/lib/clickhouse/store/979/979f9e75-9058-4985-9369-d38296a45f93/20191002_1_1_0_2/): While executing MergeTreeInOrder. (CANNOT_PARSE_TEXT), Stack trace (when copying this message, always include the lines below):
2022.07.13 11:30:24.107495 [ 926972 ] {} <Error> MutateFromLogEntryTask: virtual bool DB::ReplicatedMergeMutateTaskBase::executeStep(): Code: 6. DB::Exception: Cannot parse string 'Hello' as UInt64: syntax error at begin of string. Note: there are toUInt64OrZero and toUInt64OrNull functions, which returns zero/NULL instead of throwing exception.: while executing 'FUNCTION _CAST(value :: 2, 'UInt64' :: 3) -> _CAST(value, 'UInt64') UInt64 : 4': (while reading from part /var/lib/clickhouse/store/979/979f9e75-9058-4985-9369-d38296a45f93/20191002_1_1_0_2/): While executing MergeTreeInOrder. (CANNOT_PARSE_TEXT), Stack trace (when copying this message, always include the lines below):
Seems like this mutation was started by test 01414_mutations_and_errors_zookeeper:
but
KILL MUTATION was not executed for some reason (and it's totally fine for Stress Tests):Probably similar issue may be caused by other tests as well. It's not clear how to handle it, all (trivial) solutions looks quite bad:
- disable tests like this in BC check
- kill all mutations before restarting server
- add suppressions for each specific error (like Suppression for BC check (
Cannot parse string 'Hello' as UInt64) #39176)
cc: @Avogar