Not the answer you need?
Register and ask your own question!

Percona Xtradb cluster db not starting

yajivraghavanyajivraghavan EntrantCurrent User Role Beginner
Hi,
I am trying to start Percona XtraDB Cluster server after following the documentation. The Server is installed on RHEL 5.5

I get this error when I run mysqld :

120810 15:26:46 [Note] WSREP: wsrep_load(): loading provider library '/usr/local/Percona-XtraDB-Cluster-5.5.24/lib/libgalera_smm. so'
120810 15:26:46 [ERROR] WSREP: wsrep_load(): dlopen(): libssl.so.10: cannot open shared object file: No such file or directory
120810 15:26:46 [ERROR] WSREP: wsrep_load(/usr/local/Percona-XtraDB-Cluster-5.5.24/lib/libg alera_smm.so) failed: Invalid argument (22). Reverting to no provider.
120810 15:26:46 [Note] WSREP: wsrep_load(): loading provider library 'none'
120810 15:26:46 [ERROR] Aborting

the my.4000.cnf file I use to start is as given below:

============================
[mysqld]
gdb

datadir=/backup/perconacluster_data
basedir=/usr/local/percona-xtradb-cluster-5.5.20

port = 4000
socket=/tmp/mysql.4000.sock

user=root

binlog_format=ROW

wsrep_provider=/usr/local/Percona-XtraDB-Cluster-5.5.24/lib/ libgalera_smm.so

wsrep_cluster_address=gcomm://

wsrep_provider_options = "gmcast.listen_addr=[URL]tcp://0.0.0.0:4010[/URL]; "
wsrep_sst_receive_address=192.168.0.12:4020

wsrep_slave_threads=2
wsrep_cluster_name=trimethylxanthine
wsrep_sst_method=rsync
wsrep_node_name=node4000

innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2

============================

Have anyone come across this error? Any idea how this can be resolved?

Comments

  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    Hi,

    I guess, the issue is with this line.
    "120810 15:26:46 [ERROR] WSREP: wsrep_load(): dlopen(): libssl.so.10: cannot open shared object file: No such file or directory"

    Can you check with the command "dpkg -L libssl1.0.0" that libssl.so file is there or not? If not than can you install "libssl1.0.0" with apt-get install libssl1.0.0 command and check?
  • lefredlefred Contributor Inactive User Role Beginner
    Hi,

    That file is provided by openssl-1.0.0, on RHEL 5.5 last version is 0.9.8e

    You need to install Percona Cluster for the 5 series (http://repo.percona.com/testing/centos/5/os/x86_64/) and not for CentOS 6 (RHEL 6).

    The version for centos5 is linked to libss.so.6

    Regards,
  • yajivraghavanyajivraghavan Entrant Current User Role Beginner
    Hi ,
    I have tried but its not working.

    Still i got the same error

    "ERROR] WSREP: wsrep_load(): dlopen(): libssl.so.10: cannot open shared object file: No such file or directory"
    My OS Version :RHEL 5.5.

    And let me know is there any library dependency packages required to install percona xtradb cluster.

    I have used binary version and downloaded path is: /downloads/Percona-XtraDB-Cluster/5.5.20-23.4/binary/linux/x 86_64/percona-xtradb-cluster-5.5.20-23.4.3748.Linux.x86_64.r hel5.tar.gz

    And let me know the full structured procedure to install percona xtradb cluster
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.