Pivotal Knowledge Base

Follow

GPText upgrade from 1.2.2.2 to 1.3.0.3 fails with errors saying no gptext schema in database

Problem

When upgrading GPText using "/usr/local/greenplum-text-1.3.0.3/bin/upgrade2T3.sh"

The upgrade fails with the following log messages

{code}

CREATE FUNCTION
###########################################################################################
#/usr/local/greenplum-text-1.3.0.3/bin/upgrade2T3.sh step 5: start up new gptext instance.
###########################################################################################

20160831:11:31:25:116173 gptext-start:uat-gpm-01:gpadmin-[INFO]:-Retrieving configuration from database...
20160831:11:31:26:116173 gptext-start:uat-gpm-01:gpadmin-[CRITICAL]:-Error starting GPText cluster: error 'ERROR: could not access file "gptext-1.2.2.2": No such file or directory (seg0 slice2 sdw1.gphd.local:1025 pid=186912)
CONTEXT: SQL function "status" statement 1
' in 'SELECT * FROM gptext.status()'
20160831:11:31:26:116173 gptext-start:uat-gpm-01:gpadmin-[ERROR]:-Some of the GPText instances failed to start.

GPText start failed!

{code}

 

Resolution

Perform the upgrade steps as follows manually;

1) Stop <gptext_old> instance
2) Upgrade GPDB
3) Install <gptext_old> binaries to new GPDB version using: gptext-migrator -s
4) Install GPText 1.3.0.3 into a separate location
5) gpssh -f ~/hostfile-all -e "rm -rf /usr/local/greenplum-db/lib/postgresql/<gptext_old>.so;
ln -s /usr/local/greenplum-text-1.3.0.3/lib/gptext-gpdb43-1.3.0.3.so /usr/local/greenplum-db/lib/postgresql/<gptext_old>.so"
6) psql -c "CREATE or REPLACE FUNCTION gptext.version() returns text as \$\$ begin return 'Greenplum Text Analytics 1.2.2.2 (build 1)'; end; \$\$ language plpgsql;"
7) Run gptext-start to start up new gptext instance
8) /usr/local/greenplum-text-1.3.0.3/bin/gptext-migrator -f /usr/local/greenplum-text-1.3.0.3/share/upgrade.yaml
9) source /usr/local/greenplum-text-1.3.0.3/greenplum-text_path.sh

Comments

Powered by Zendesk