原 GreenPlum启动报错could not load library /usr/local/greenplum-db-6.27.0/lib/postgresql/pg_cron.so的故障处理
👉 本文共约435个字，系统预计阅读时间或需2分钟。
现在
openEuler 22.03 LTS环境，GreenPlum 6.27.0启动，报错："FATAL","58P01","could not load library ""/usr/local/greenplum-db-6.27.0/lib/postgresql/pg_cron.so"": libpq.so.5: cannot open shared object file: No such file or directory",,,,,,,,"internal_load_library"
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 | 20240411:18:16:53:037721 gpstop:mdw:gpadmin-[INFO]:-Cleaning up leftover gpsmon processes 20240411:18:16:53:037721 gpstop:mdw:gpadmin-[INFO]:-No leftover gpsmon processes on some hosts. not attempting forceful termination on these hosts 20240411:18:16:53:037721 gpstop:mdw:gpadmin-[INFO]:-Cleaning up leftover shared memory 20240411:18:16:54:037721 gpstop:mdw:gpadmin-[INFO]:-Restarting System... 20240411:18:16:54:037721 gpstop:mdw:gpadmin-[CRITICAL]:-Error occurred: non-zero rc: 2 Command was: '$GPHOME/bin/gpstart -a -d /home/data/opt/greenplum/data/master/gpseg-1' rc=2, stdout='20240411:18:16:54:039436 gpstart:mdw:gpadmin-[INFO]:-Starting gpstart with args: -a -d /home/data/opt/greenplum/data/master/gpseg-1 20240411:18:16:54:039436 gpstart:mdw:gpadmin-[INFO]:-Gathering information and validating the environment... 20240411:18:16:54:039436 gpstart:mdw:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 6.27.0 build commit:482d4e839d519dcfde9cddf03807787d9d91d015' 20240411:18:16:54:039436 gpstart:mdw:gpadmin-[INFO]:-Greenplum Catalog Version: '301908232' 20240411:18:16:54:039436 gpstart:mdw:gpadmin-[INFO]:-Starting Master instance in admin mode 20240411:18:16:54:039436 gpstart:mdw:gpadmin-[CRITICAL]:-Failed to start Master instance in admin mode 20240411:18:16:54:039436 gpstart:mdw:gpadmin-[CRITICAL]:-Error occurred: non-zero rc: 1 Command was: 'env GPSESSID=0000000000 GPERA=None $GPHOME/bin/pg_ctl -D /home/data/opt/greenplum/data/master/gpseg-1 -l /home/data/opt/greenplum/data/master/gpseg-1/pg_log/startup.log -w -t 600 -o " -p 5432 -c gp_role=utility " start' rc=1, stdout='waiting for server to start.... stopped waiting ', stderr='pg_ctl: could not start server Examine the log output. ' ', stderr='' [gpadmin@mdw gppkg]$ more /home/data/opt/greenplum/data/master/gpseg-1/pg_log/startup.log 2024-04-11 18:16:54.662459 CST,,,p39446,th-508458816,,,,0,,,seg-1,,,,,"FATAL","58P01","could not load library ""/usr/local/greenplum-db-6.27.0/lib/postgresql/pg_cron.so"": libpq.so.5: cannot open sh ared object file: No such file or directory",,,,,,,,"internal_load_library","dfmgr.c",240,1 0xc02327 postgres errstart (elog.c:557) 2 0xc07800 postgres <symbol not found> (dfmgr.c:237) 3 0xc07e34 postgres load_file (dfmgr.c:156) 4 0xc1b264 postgres process_shared_preload_libraries (miscinit.c:1384) 5 0xa1f4a3 postgres PostmasterMain (postmaster.c:1147) 6 0x6b77c1 postgres main (main.c:205) 7 0x7f66e2470f30 libc.so.6 <symbol not found> + 0xe2470f30 8 0x7f66e2470fdc libc.so.6 __libc_start_main + 0x7c 9 0x6c363c postgres <symbol not found> + 0x6c363 |
排查
报错"/usr/local/greenplum-db-6.27.0/lib/postgresql/pg_cron.so"不存在，但是其实该文件是存在的：
想到，之前在openEuler 22.03 LTS环境上安装gpcc时，为了解决报错“rsync: symbol lookup error: rsync: undefined symbol: ZSTD_compressStream2”，我做了如下的配置：
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！
