CTAS fails with "ERROR: AssignTransactionId() called by Segment Reader process (xact.c:585)"

Products

• VMware Tanzu Greenplum

Issue/Introduction

A CTAS into a RANDOMLY distributed table fails with the error:

ERROR: AssignTransactionId() called by Segment Reader process (xact.c:585) (seg42 slice1 10.10.4.102:6018 pid=305636) (xact.c:585) 

The same CTAS into a table distributed on another field works fine. 

Unsetting the GUC temp_tablespaces also works.

gpadmin=# set temp_tablespaces='';

Environment

Product Version: 6.0

Resolution

This has been identified as a product defect in Greenplum Database (GPDB) v6.x when query wants to use temp tablespace for spill.

A fix for this issue is included in GPDB 6.1.0+.