With interleaving being deprecated in Cockroach v21, I have some tables that I'm trying to alter. These exist in a hierarchy with the primary of each being interleaved into its parent. No secondary indexes appear to be interleaved.
I followed the recommended process for de-interleaving these (running an alter primary key with the original components and omitting the interleave) but when the migration was applied, I got an error stating that the job couldn't be completed and that manual cleanup might be required. I wound up having to restore from backup.
Are there any gotchas around de-interleaving tables? Is there something I'm missing?