Options
Partition reorganize not started
Navin_C
Vertica Customer ✭
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 .
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 .
0