{question}
Why do I receive the following error when attempting to perform operations such as REBALANCE or RESTORE?
ERROR 1772 ER_DISTRIBUTED_PARTITION_MOVE_FAILED: Forwarding Error (<node-name>:<port>):
Rebalance resource availability check failed. Set the skip_rebalance_resource_check
system variable to run the rebalance without checking the disk and memory availability
on the cluster (error 1267:Illegal mix of collations (utf8_general_ci, IMPLICIT) and
(utf8mb4_unicode_ci, IMPLICIT) for operation 'UNION')
{question}
{answer}
The error is due to a bug that was fixed in the following SingleStoreDB engine versions:
- 7.6.28 (Release notes)
- 7.8.25 (Release notes)
- 7.9.19 (Release notes) (Cloud-only version)
- 8.0.15 (Release notes)
- 8.1.1 (Fix Added to the initial release of 8.1)
The bug fix is noted in the release notes as follows:
"Fixed an error caused by setting the collation_server global variable to a non-default value when performing a REBALANCE PARTITIONS resource availability check."
{answer}