gpmigrate utility included in GPDB 7.4.0 release gets Error when executing

Products

• VMware Tanzu Data Suite

Issue/Introduction

A customer attempted to test the gpmigrate utility, which was newly introduced in Greenplum Database version 7.4.0. They executed the utility, specifying the Greenplum 6.26.3 home directory as the source and the Greenplum 7.4.0 home directory as the target. However, the operation encountered an error and failed to complete successfully.

 

cd /tmp/greenplum-db-7.4.0/bin

./gpmigrate --source-gphome /usr/local/greenplum-db --target-gphome /tmp/greenplum-db --source-port 5434

 

Utility errors with:

gpmigrate timestamp: 20250222020900
Connecting to database template1
Performing Migration Validation on Source Cluster
-----------------------------
Checking cluster versions                                   ok
Checking for incompatible partition tables with keyword exclusive and/or inclusive
ok
Checking for incompatible SUBPARTITION TEMPLATE 'RANK'      ok
Checking for multi-column LIST partition keys               ok
Checking for functions dependent on plpython2               ok
Checking for views with removed functions                   SQL command failed
CREATE OR REPLACE FUNCTION view_has_removed_functions(OID) RETURNS BOOL AS '$libdir/pg_upgrade_support' LANGUAGE C STRICT;
ERROR:  could not find function "view_has_removed_functions" in file "/usr/local/greenplum-db-6.26.3/lib/postgresql/pg_upgrade_support.so"
Failure, exiting
Error: exit status 1

Environment

Testing/Staging 

Source Cluster: GPDB 6.26.3

Target Cluster: GPDB 7.4.0 

Utility: gpmigrate 

 

Cause

The/usr/local/greenplum-db-6.26.3/lib/postgresql/pg_upgrade_support.so file is actually included with GPDB 6.26.3, but it is just a placeholder. The gpmigrate utility was not completed at the time 6.26.3 was released. 

Resolution

After upgrading from 6.26.3 TO 7.4.0, customer confirmed the gpmigrate utility ran and completed successfully. The minimum GPDB version needed on the source cluster is 6.28.2.