We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Partition reorganize not started — Vertica Forum

Partition reorganize not started

Navin_CNavin_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 .


Leave a Comment

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