- Pivotal Greenplum Database (GPDB) 4.3.x
- Operating System- Red Hat Enterprise Linux 6.x
When running gpfdist on the server only, installed with GPDB Loader in a Linux environment, it failed with errors. The error message is shown below:
error while loading shared libraries: libyaml-0.so.1: cannot open shared object file: No such file or directory
As explained in the 4.3.7.x release note shown below, the library file libyaml-0.so.1 was missed in the releases prior to 18.104.22.168.
The Greenplum Database Loaders for Red Hat Enterprise 5 and 6 did not contain the library libyaml-0.so.1.
This issue has been resolved.
The official solution would be to upgrade GPDB to 22.214.171.124+ first, then install the GPDB Loader for matching the release separately.
If an upgrade is not possible at the moment, then try the following workaround.
- If there is a GPDB cluster running in RedHat Linux environment, copy file libyaml-0.so.1 from the master host of GPDB cluster to the server installed with GPDB Loaders.
- If there is no GPDB cluster available, then download the GPDB server installation binary package from network.pivotal.io and upload it to the server installed with GPDB Loaders. Then install the GPDB server package on the GPDB Loaders host and copy file libyaml-0.so.1 from the GPDB server installation directory to the GPDB Loaders installation directory.
- Create related soft links for file libyaml-0.so.1 as illustrated below.
[root@mdw lib]# pwd
/usr/local/greenplum-loaders-126.96.36.199-build-1/lib [root@mdw lib]# cp /usr/local/greenplum-db-188.8.131.52/lib/libyaml-0.so.1.0.0 . [root@mdw lib]# ln -s libyaml-0.so.1.0.0 libyaml-0.so.1 [root@mdw lib]# ln -s libyaml-0.so.1.0.0 libyaml.so [root@mdw lib]# chown gpadmin:gpadmin libyaml*
[root@mdw lib]# ls -l libyaml* lrwxrwxrwx 1 root root 18 Mar 7 20:19 libyaml-0.so.1 -> libyaml-0.so.1.0.0 -rwx------ 1 gpadmin gpadmin 319651 Mar 7 20:18 libyaml-0.so.1.0.0
lrwxrwxrwx 1 root root 18 Mar 7 20:19 libyaml.so -> libyaml-0.so.1.0.0