The original title is: Fixing "Can't get distribution attribute of table" in GBase 8a

Short summary

GBase 8a clusters can lose entries in gbase.table_distribution after an unclean shutdown, leaving tables in a contradictory state where they can't be dropped or recreated. The fix is to manually insert the missing metadata row with correct distribution parameters and restart the gcluster service. A diagnostic query against information_schema can identify all affected tables, and standby clusters can serve as a source for recovery files.

• •Unclean shutdowns can corrupt gbase.table_distribution metadata, making tables unqueryable
• •Manually insert missing distribution rows and restart gcluster to recover without data loss
• •Use information_schema query to detect all tables missing distribution records

Generated with AI, which can make mistakes.