ALTER TABLE reports " ERROR:  tuple already updated by self "
search cancel

ALTER TABLE reports " ERROR:  tuple already updated by self "

book

Article ID: 413937

calendar_today

Updated On:

Products

VMware Tanzu Data Suite VMware Tanzu Greenplum VMware Tanzu Greenplum / Gemfire

Issue/Introduction

When altering a partition table to set it as "DISTRIBUTED RANDOMLY" the following error is reported:

gpadmin=# ALTER TABLE IF EXISTS sch01.part01 SET WITH (REORGANIZE=TRUE) DISTRIBUTED RANDOMLY;
ERROR:  tuple already updated by self (heapam.c:4265)

Cause

Code bug in Greenplum Database 7.x

Resolution

There is no workaround for the issue.

Upgrade to Greenplum 7.6.1 or above to get the fix.

Powered by Wolken Software