The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Partition reorganize percent stuck on 99
I ran partition on one of the tables that we have (10TB) with reorganize command in the end.
And when I'm checking the PARTITION_STATUS table I can see that the partition_reorganize_percent stuck on 99% for almost 6 days (other table of 26TB finished after 2 days).
There is nothing in PARTITION_REORGANIZE_ERRORS table.
And on PARTITIONS table I can see that on this table there is one partition on each node on _b0 that the projection_key has NULL.
Chan anynoe help?
This is happening to us now, and is causing operational issues. If there is any way to cancel the reorganization that would be helpful so we can try another approach.