PostGIS & gpfdist Errors during migration from Greenplum 6 to 7

Products

• VMware Tanzu Data Suite
• VMware Tanzu Greenplum

Issue/Introduction

The following errors occur when executing a PostGIS query:

ERROR:  Error on receive from seg15 slice1 10.1.1.1:6003 pid=3952021: server closed the connection unexpectedly
        This probably means the server terminated abnormally before or while processing the request.

 

or a gpfdist external table Insert:

ERROR:  Error on receive from seg3 slice1 10.1.1.1:6003 pid=1735062:
server closed the connection unexpectedly.
This probably means the server terminated abnormally before or while processing the request.
SQL state: 58M01

 

Also the following 3rd party error can be found in the logs but can only be linked with the incident through timestamp:

2025-06-10 12:33:07.576052 CEST,,,p11980,th1492269248,,,,0,,,seg15,,,,,"LOG","00000","3rd party error log:
error: Unknown attribute kind (86) (Producer: 'LLVM16.0.6' Reader: 'LLVM 15.0.7')
",,,,,,,,"SysLoggerMain","syslogger.c",719,

Resolution

Greenplum Database uses LLVM for JIT compilation and it is enabled with all RPM distributions of Greenplum Database. If you build Greenplum Database from source, you must include the --with-llvm build option to include JIT compilation support.

In order to use JIT, you must first install the LLVM libraries in your system by running the command:

yum install llvm-libs

https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/7/greenplum-database/admin_guide-query-topics-just-in-time.html

Greenplum Database is currently compatible with LLVM version 15.0.7

Please check the version of the LLVM libraries that have been installed on all the hosts.