GPSS package removal is failing with "Multiple packages match remove request"

Products

• VMware Tanzu Greenplum

Issue/Introduction

After upgrading the GPSS it may be possible that the old package file is left on the cluster.
This can cause issues when trying to remove the package.

[gpadmin@mdw local]$ gppkg --query --all
20220329:05:17:11:072062 gppkg:mdw:gpadmin-[INFO]:-Starting gppkg with args: --query --all
madlib-1.18.0+2
pivotal_greenplum_backup_restore-1.23.0
gpss-gpdb6                     <<<< gpss-gpdb6 is listed twice
MetricsCollector-6.6.0_gp_6.18.2
gpss-gpdb6                     <<<< gpss-gpdb6 is listed twice

[gpadmin@mdw local]$ gppkg -r gpss-gpdb6
20220329:05:17:29:072095 gppkg:mdw:gpadmin-[INFO]:-Starting gppkg with args: -r gpss-gpdb6
20220329:05:17:29:072095 gppkg:mdw:gpadmin-[ERROR]:-gppkg error: Remove request 'gpss-gpdb6' too broad. Multiple packages match remove request: ( gpss-gpdb6-1.6.0-rhel7-x86_64.gppkg, gpss-gpdb6-1.7.0-rhel7-x86_64.gppkg )

Environment

Product Version: 6.18

Resolution

Manually delete the package file for the older version and then run "gppkg -r <packageName>".

On the master host change directroy to ${GHOME}/share/packages/archive

cd ${GHOME}/share/packages/archive

List the package files:

ls -l

Delete the older version of the GPSS package (Note: change the file name below to the correct filename):

rm gpss-gpdb6-1.6.0-rhel7-x86_64.gppkg

Run the package remove command (Note: the package name may be different and depends on the installed package):

gppkg -r gpss-gpdb6