Hello All,
I had used alter table statement ending with REORGANIZE keyword to change the partition on a few tables.
After checking the partition_Status table I found all the projection are 100% done but only one of them is at 0 (this one is a buddy projection with _b1).
Waited for almost more then an hour, but still it does not advance ahead of 0.
When checked the Log files.
LowDiskSpaceCheck:0x7f0864018190-a000000074ae9f [Txn] <INFO> Begin Txn: a000000074ae9f 'LowDiskSpaceCheck
LowDiskSpaceCheck:0x7f0864018190-a000000074ae9f [Txn] <INFO> Rollback Txn: a000000074ae9f 'LowDiskSpaceCheck'
LowDiskSpaceCheck:0x7f0864018190 [Util] <INFO> Task 'LowDiskSpaceCheck' enabled
Now I am not able to see the partition keys for that table.
Is there something I am missing here.
Anyway we can kill the Reorganize process .
Partition reorganize not started
Moderator: NorbertKrupa
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Partition reorganize not started
First, check PARTITION_REORGANIZE_ERRORS for errors and/or actionable hints. Then, I would try to CLEAR_PROJECTION_REFRESHES() and then run a REFRESH() on the table.
Checkout vertica.tips for more Vertica resources.