SingleStore Managed Service

ERROR: Partition’s table metadata are out of sync for table

Issue

The most common cause for this error is an ALTER TABLE query on a sharded table which ran partially but didn’t complete successfully. This may leave table metadata in an inconsistent state where some partitions have the old metadata while some have the new.

Solutions

If the cause of the issue was a failed ALTER TABLE as described above, possible solutions are:

  • Recreate the table. This can be done by insert-selecting the data into a newly created table or reloading the data. For example: sql CREATE TABLE t_copy AS SELECT * FROM t; DROP TABLE t; ALTER TABLE t_copy RENAME AS t;

  • Find the partition(s) with inconsistent table metadata, and manually run ALTER on the leaf partitions to correct them.