ERROR: Cannot append paths with incompatible distribution

Products

• VMware Tanzu Greenplum

Issue/Introduction

An error similar to the following is encountered when running a function:

"ERROR","0AM00","Cannot append paths with incompatible distribution",,,,,"SQL statement "<offending query>"

PL/pgSQL function ""rules_execution"" line 43 at EXECUTE statement","<the functon>"",0,,"pathnode.c",1616,

Run the offending query independently of the function and check if it is failing due to VMEM usage:

ERROR: Canceling query because of high VMEM usage. Used: 6366MB, available 814MB, red zone: 7372MB (runaway_cleaner.c:202)

Environment

Product Version: 5.28

Resolution

Ensure gp_vmem_protect_limit settings are at the advised values, according to our calculator tool below or environments that use resource queues:
 

• https://greenplum.org/calc/

For systems with resource groups, follow the respective documentation.