Table reorganize background process is "stuck"

David_1David_1 Registered User
Over 24 hours ago I started a table reorganize process on a very large table by performing a "alter table ... partition by...reorganize" operation. Data has been shuffling over all of my nodes since then. Disk space fills to 100% on each node and immediately falls back to normal levels. Data shuffling has now stopped, querying partition_status shows that the partition_reorganize_percent is still zero. Querying the partitions view shows all partition_key values have been set to null. No errors appear in the reorganize_errors view. How can I ensure that this reorganization operation completes?

Comments

  • David_1David_1 Registered User
    Anyone have any insight here? This morning I'm making another attempt, this time setting the database to k-safe 0 temporarily and dropping one of the buddy partitions on my large table. This obviously makes me very nervous, but I am hoping that this frees up enough space to let the repartition operation succeed.
  • Hi David! We'll look into this for you.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file