libgalera_smm.so SSL_COMP_free_compression_methods not defined

[Satoshi MITANI]

wsrep_load() failed with latest PXC5.7 like below. I installed on CentOS7.2.

2017-10-31T04:09:58.240068Z 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera3/libgalera_smm.so'
2017-10-31T04:09:58.241781Z 0 [ERROR] WSREP: wsrep_load(): dlopen(): /usr/lib64/galera3/libgalera_smm.so: symbol SSL_COMP_free_compression_methods, version libssl.so.10 not defined in file libssl.so.10 with link time reference

$ rpm -qa | grep Percona
Percona-XtraDB-Cluster-shared-57-5.7.19-29.22.3.el7.x86_64
Percona-XtraDB-Cluster-client-57-5.7.19-29.22.3.el7.x86_64
Percona-XtraDB-Cluster-shared-compat-57-5.7.19-29.22.3.el7.x86_64
Percona-XtraDB-Cluster-57-5.7.19-29.22.3.el7.x86_64
Percona-XtraDB-Cluster-server-57-5.7.19-29.22.3.el7.x86_64

$ rpm -qa | grep openssl
openssl-libs-1.0.1e-51.el7_2.7.x86_64
openssl-1.0.1e-51.el7_2.7.x86_64

[Hrvoje Matijakovic (hrvojem)]

Please try to upgrade the openssl package (yum upgrade openssl*) this should resolve the issue.

[Satoshi MITANI (samitani)]

Thank you for reply.

I updated openssl, but same situation was occurred.

this is 5.7.19-29.22.3 symbols.

$ rpm -qa | egrep 'Percona|openssl' | sort
openssl-1.0.1e-60.el7_3.1.x86_64
openssl-libs-1.0.1e-60.el7_3.1.x86_64
Percona-XtraDB-Cluster-57-5.7.19-29.22.3.el7.x86_64
Percona-XtraDB-Cluster-client-57-5.7.19-29.22.3.el7.x86_64
Percona-XtraDB-Cluster-server-57-5.7.19-29.22.3.el7.x86_64
Percona-XtraDB-Cluster-shared-57-5.7.19-29.22.3.el7.x86_64
Percona-XtraDB-Cluster-shared-compat-57-5.7.19-29.22.3.el7.x86_64

$ nm -D /usr/lib64/galera3/libgalera_smm.so | grep SSL_COMP_free_compression_methods
                 U SSL_COMP_free_compression_methods

$ nm -D /lib64/libssl.so.1.0.1e | grep SSL_COMP_free_compression_methods

this is 5.7.19-29.22.1 symbols. libgalera_smm.so does not needs SSL_COMP_free_compression_methods.
I guess that your build environment has been changed.

$ rpm -qa | egrep 'Percona|openssl' | sort
openssl-1.0.1e-60.el7_3.1.x86_64
openssl-libs-1.0.1e-60.el7_3.1.x86_64
Percona-XtraDB-Cluster-57-5.7.19-29.22.1.el7.x86_64
Percona-XtraDB-Cluster-client-57-5.7.19-29.22.1.el7.x86_64
Percona-XtraDB-Cluster-server-57-5.7.19-29.22.1.el7.x86_64
Percona-XtraDB-Cluster-shared-57-5.7.19-29.22.1.el7.x86_64
Percona-XtraDB-Cluster-shared-compat-57-5.7.19-29.22.1.el7.x86_64

$ nm -D /usr/lib64/galera3/libgalera_smm.so | grep SSL_COMP_free_compression_methods
$ nm -D /lib64/libssl.so.1.0.1e | grep SSL_COMP_free_compression_methods

[Hrvoje Matijakovic (hrvojem)]

I still see that openssl packages are older version. I'm getting:

[root@centos7 ~]# yum upgrade openssl*
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: distro.ibiblio.org
 * epel: mirror.cogentco.com
 * extras: mirror.teklinks.com
 * updates: www.gtlib.gatech.edu
Resolving Dependencies
--> Running transaction check
---> Package openssl.x86_64 1:1.0.1e-42.el7.9 will be updated
---> Package openssl.x86_64 1:1.0.2k-8.el7 will be an update
---> Package openssl-libs.x86_64 1:1.0.1e-42.el7.9 will be updated
---> Package openssl-libs.x86_64 1:1.0.2k-8.el7 will be an update
--> Finished Dependency Resolution

[Satoshi MITANI (samitani)]

After upgrade openssl to openssl-1.0.2k, I confirmed error fixed. Thank you.

Actually, my envronment allows to update to latest CentOS7.2 packages.
http://vault.centos.org/7.2.1511/os/x86_64/Packages/

So, I imported only openssl-1.0.2k from CentOS7.4 repository.

[Krunal Bauskar (krunal-bauskar)]

* Standard packages that are build in percona repo are with latest open-ssl version.

* As confirmed above user can upgrade the old open-ssl packages to latest one and things should work.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-2014