Reorganize failed with error " Execution canceled by operator"
Hi all,
I tried to run ALTER table PARTITION BY date_trunc('week', schema.table.date) REORGANIZE; on relatively big table (322GB).
It started running the process on background with the following message:
NOTICE 4954: The new partitioning scheme will produce 62 partitions
WARNING 6100: Using PARTITION expression that returns a Timestamp value
HINT: This PARTITION expression may cause too many data partitions. Use of an expression that returns a more accurate value, such as a regular VARCHAR or INT, is encouraged
NOTICE 4785: Started background repartition table task
ALTER TABLE
When I checked V_MONITOR.PARTITION_STATUS table after several minutes it stated that 0% was processed and V_MONITOR.PARTITION_REORGANIZE_ERRORS table showed message='Execution canceled by operator'. tuple_mover_operations also stated that Partitioning was Aborted.
Tried later to run REORGANIZE only, but it failed the same way.
Anyone can help on further actions/checks?
Thanks,