THD000,ERROR,""GPDB Expression type: Query Parameter not supported in DXL"" about geospatial HOT 5 OPEN

gpdb version:
[gpadmin@gpdb1 ~]$ gpstate
20201228:04:05:17:005746 gpstate:gpdb1:gpadmin-[INFO]:-Starting gpstate with args:
20201228:04:05:17:005746 gpstate:gpdb1:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.13.0 build commit:4f1adf8e247a9685c19ea02bcaddfdc200937ecd Open Source'
20201228:04:05:17:005746 gpstate:gpdb1:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.24 (Greenplum Database 6.13.0 build commit:4f1adf8e247a9685c19ea02bcaddfdc200937ecd Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Dec 18 2020 22:31:16

os version:
[gpadmin@gpdb1 ~]$ cat /etc/redhat-release
CentOS Linux release 7.9.2009 (Core)
[gpadmin@gpdb1 ~]$

gdal version: 1.11.
geos version: 3.8.0
proj4 version: 5.8.0
geospatial version: geospatial-master-2.5.4-patch3

from geospatial.

Thanks for reporting the issue @yangjiurong

Few questions

1. How did you build and install postgis ? Did you run anything else before running the CREATE EXTENSION command ?
2. Is this an upgrade scenario or a fresh install ?

from geospatial.

@yangjiurong ^^^

from geospatial.

1.Compile and install some dependence libs

• 1.1 gdal-1.11.1

• 1.2 geos-master3.8.0

• 1.3 proj-5.2.0
  then compile and install geospatial

• 1.4 unzip geospatial-master-2.5.4-patch3.zip

• 1.5 cd geospatial-rel-v2.5.4-pivotal.3/postgis/build/postgis-2.5.4/

• 1.6 ./autogen.sh

• 1.7 ./configure --with-pgconfig=/usr/local/greenplum-db/bin/pg_config
  --with-gdalconfig=/usr/local/gdal/bin/gdal-config
  --with-geosconfig=/usr/local/geos/bin/geos-config
  --with-projdir=/usr/local/proj4
  --with-raster --without-topology

• 1.8 make USE_PGXS=1 clean all install

• 1.9 chown -R gpadmin:gpadmin /usr/local/greenplum*

• 1.10 chgrp -R gpadmin /usr/local/greenplum*

2. fresh install

from geospatial.

@yangjiurong Thanks for the response. We tried the exact same setup, but weren't able to repro the error mentioned.
gdal-1.11.1
geos-3.8.0
proj-5.2.0
and were successfully able to create the PostGIS extension.

select postgis_full_version();
                                                                                postgis_full_version
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
POSTGIS="2.5.4" [EXTENSION] PGSQL="94" GEOS="3.8.0-CAPI-1.13.1 " PROJ="Rel. 5.2.0, September 15th, 2018" GDAL="GDAL 1.11.1, released 2014/09/24" LIBXML="2.9.1" LIBJSON="0.11" RASTER
(1 row)

Also, since you are using specific locations for GDAL, GEOS and PROJ4, did you run ldconfig as mentioned https://github.com/greenplum-db/geospatial#workaround-for-missing-so-files ?

Another thing to try is a yum install of geos and proj4 as mentioned here https://github.com/greenplum-db/geospatial/blob/master/postgis/README.libs
and re-run configure without passing in --with-geosconfig and --with-projdir flags

from geospatial.