Partition reorganize percent stuck on 99

Moderator: NorbertKrupa

Post Reply
chenshaulian
Intermediate
Intermediate
Posts: 51
Joined: Wed Sep 09, 2015 9:34 am

Partition reorganize percent stuck on 99

Post by chenshaulian » Thu Jul 28, 2016 8:06 am

Hi all,

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?

Thanks
Chen

Post Reply

Return to “Vertica Database Administration”