DB fails to start : could not access file "metrics_collector": No such file or directory

Products

• VMware Tanzu Greenplum

Issue/Introduction

"gpstart" fails to start the database. The startup.log file reports an error similar to:

2023-10-12 13:44:58.409729 UTC,,,p56375,th1910461056,,,,0,,,seg-1,,,,,"FATAL","58P01","could not access file ""metrics_collector"": No such file or directory",,,,,,,,"internal_load_library","dfmgr.c",202,1

Environment

Product Version: 6.25

Resolution

The database searches the directories defined in the GUC "dynamic_library_path". See dynamic_library_path for details on the GUC.
By default this is set to "$libdir". This may be removed when an optional package is installed.

If "$libdir" is missing from the list of paths in the GUC, prepend the string to the GUC.
NOTE: The settings below are just examples and will need to be changed to appropriate values for the specific environment

1. Check the "postgresql.conf" file for the master/coordinartor.

vi $MASTER_DATA_DIRECTORY/postgresql.conf

dynamic_library_path='/usr/local/greenplum-db/madlib/Versions/1.21.0/../../Current/ports/greenplum/6/lib'

Prepend "$libdir" to the list of paths:

dynamic_library_path='$libdir:/usr/local/greenplum-db/madlib/Versions/1.21.0/../../Current/ports/greenplum/6/lib'

2. Start the database in master-only mode:

gpstart -ma

3. Change the GUC on all segments:

gpconfig -c dynamic_library_path='$libdir:/usr/local/greenplum-db/madlib/Versions/1.21.0/../../Current/ports/greenplum/6/lib'

4. Stop and start the database

gpstop -af
​​​​​​​gpstart -a