GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

loading provider library 'none'

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • loading provider library 'none'

    I am trying to install an XtraDB Cluster server on my Mysql server. On this server I already have 3 MySQL (5.5) instances running with the mysql-multi script.
    The server is a RedHat 6 Linux and I am using the dowloaded binaries from Percona. When I start the XtraDB Cluster instance, I get this message in the mysqld error log :
    "...
    130816 16:27:30 [Note] WSREP: Read nil XID from storage engines, skipping position init
    130816 16:27:30 [Note] WSREP: wsrep_load(): loading provider library 'none'
    130816 16:27:30 [Note] /ccv/app/pxc55/bin/mysqld: ready for connections.
    Version: '5.5.31-23.7.5-log' socket: '/ccv/data/mysql/300/data/mysqld.sock' port: 3336 Percona XtraDB Cluster (GPL) 5.5.31-23.7.5, Revision 438, wsrep_23.7.5.r3880
    ..."
    This is what I added in my.cnf
    ...
    ################################################## #########################
    # server 300 : Percona XtraDB Cluster TEST
    ################################################## #########################
    # client = DINF/DSI/DSOL
    # application-1 = Typo3 VD.CH Production
    # application-2 =
    # application-3 =
    # application-4 =
    # web =
    ################################################## #########################
    [mysqld300]
    user = mysql
    basedir = /ccv/app/pxc55
    mysqld = /ccv/app/pxc55/bin/mysqld_safe
    mysqladmin = /ccv/app/pxc55/bin/mysqladmin
    datadir = /ccv/data/mysql/300/data
    pid-file = /ccv/data/mysql/300/data/mysqld.pid
    log-error = /ccv/data/mysql/300/log/mysqld.err

    port = 3336
    socket = /ccv/data/mysql/300/data/mysqld.sock
    skip-external-locking
    key_buffer_size = 256M
    max_allowed_packet = 36M
    table_open_cache = 256
    sort_buffer_size = 1M
    read_buffer_size = 1M
    read_rnd_buffer_size = 4M
    myisam_sort_buffer_size = 64M
    thread_cache_size = 8
    # Query Cache is not supported with wsrep
    # query_cache_size = 24M
    query_cache_type = 0
    query_cache_size = 0
    # Try number of CPU's*2 for thread_concurrency
    thread_concurrency = 4

    # Replication Master Server (default)
    # binary logging is required for replication
    log-bin = /ccv/data/mysql/300/log/bin-log
    #
    # required unique id between 1 and 2^32 - 1
    # defaults to 1 if master-host is not set
    # but will not function as a master if omitted
    server-id = 1
    #
    # binary logging format - mixed recommended
    # ROW format recommended for Percona XtraDB Cluster
    # binlog-format = mixed
    binlog-format = ROW
    # Point the following paths to different dedicated disks
    tmpdir = /ccv/data/mysql/300/tmp
    #log-update = /path-to-dedicated-directory/hostname

    # Uncomment the following if you are using InnoDB tables
    innodb_data_home_dir = /ccv/data/mysql/300/data
    innodb_data_file_path = ibdata1:10M:autoextend
    innodb_log_group_home_dir = /ccv/data/mysql/300/log
    # You can set .._buffer_pool_size up to 50 - 80 %
    # of RAM but beware of setting memory usage too high
    # Voir plus loin: Config PXC
    # innodb_buffer_pool_size = 256M
    innodb_additional_mem_pool_size = 20M
    # Set .._log_file_size to 25 % of buffer pool size
    # innodb_log_file_size = 64M
    innodb_log_buffer_size = 8M
    innodb_flush_log_at_trx_commit = 1
    innodb_lock_wait_timeout = 50
    #
    default-storage-engine = INNODB
    innodb_file_per_table
    #
    #Parametre Tuning
    ################################################## ##########
    character-set-server = utf8
    collation-server = utf8_general_ci
    max_allowed_packet = 32M
    interactive_timeout = 288000
    wait_timeout = 288000
    # transaction-isolation = READ-COMMITTED
    ################################################## ##########
    #

    ################################################## ##########
    # Galera/Percona PXC Config Params
    ################################################## ##########
    wsrep_cluster_address=gcomm://
    wsrep_provider=/ccv/app/pxc55/lib/libgalera_smm.so
    wsrep_slave_threads=4
    wsrep_cluster_name=pxctest
    wsrep_sst_method=xtrabackup
    wsrep_node_name=slv0116v-pxc
    wsrep_sst_auth="sstuser:S5tU53R"
    #
    log_slave_updates
    #
    innodb_locks_unsafe_for_binlog=1
    innodb_autoinc_lock_mode=2
    innodb_buffer_pool_size=400M
    innodb_log_file_size=64M
    ################################################## ##########
    ...

    Of course, I already checked that the "wsrep_provider=/ccv/app/pxc55/lib/libgalera_smm.so" exists and is readable.
    Can you tell me what I did wrong and need to correct ?

    Thanks in advance.





  • #2
    It should work, can't see any obvious mistake here. Looks like the wsrep_provider option is not passed to mysqld at all. Even if you put wrong file name, there should be this name in log entry, like this:
    Code:
    130801 4:24:09 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/libgalera_smm.so1'
    130801 4:24:09 [ERROR] WSREP: wsrep_load(): dlopen(): /usr/lib64/libgalera_smm.so1: cannot open shared object file: No such file or directory
    130801 4:24:09 [ERROR] WSREP: wsrep_load(/usr/lib64/libgalera_smm.so1) failed: Invalid argument (22). Reverting to no provider.
    130801 4:24:09 [Note] WSREP: Read nil XID from storage engines, skipping position init
    130801 4:24:09 [Note] WSREP: wsrep_load(): loading provider library 'none'
    130801 4:24:09 [ERROR] Aborting
    So either the variable is not passed, or you don't show all relevant error log entries, and there is some information earlier.

    Btw. can you verify there is no SELinux problem? Check the
    /var/log/audit/audit.log for anything useful.
    Also there is quite nice post about using mysql_multi with Galera based cluster:
    http://www.sebastien-han.fr/blog/201...s-with-galera/

    Comment


    • #3
      Thank you for your suggestions,

      SELinux is "disabled" and could not cause any problem.
      I am still trying to find what is wrong.

      Comment


      • #4
        I made some progress: "mysql_safe" did not transmit the wsrep parameters to "mysql", so I changed in "my.cnf" :
        ...
        mysqld = /ccv/app/pxc55/bin/mysqld_safe
        to
        mysqld = /ccv/app/pxc55/bin/mysqld

        Now I can start the first node on my cluster. But any joiner node will crash with this message :
        ...
        130822 15:20:27 [Note] WSREP: Running: 'wsrep_sst_xtrabackup --role 'joiner' --address '10.120.148.45' --auth 'sstuser:S5tU53R' --datadir '/ccv/data/mysql/300/data/' --defaults-file '/etc/mysql/my.cnf' --parent '3930''
        130822 15:20:27 [ERROR] WSREP: Failed to read 'ready <addr>' from: wsrep_sst_xtrabackup --role 'joiner' --address '10.120.148.45' --auth 'sstuser:S5tU53R' --datadir '/ccv/data/mysql/300/data/' --defaults-file '/etc/mysql/my.cnf' --parent '3930'
        Read: 'Can't find nc in the path'
        130822 15:20:27 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup --role 'joiner' --address '10.120.148.45' --auth 'sstuser:S5tU53R' --datadir '/ccv/data/mysql/300/data/' --defaults-file '/etc/mysql/my.cnf' --parent '3930': 22 (Invalid argument)
        130822 15:20:27 [ERROR] WSREP: Failed to prepare for 'xtrabackup' SST. Unrecoverable.
        130822 15:20:27 [ERROR] Aborting

        Seems like I am not the only one to have this problem. But I am still looking for a solution.

        Comment


        • #5
          Can you please check if nc installed?

          Please check it:
          yum list installed | grep -i nc

          If not then please install it:
          sudo yum install nc

          and try again

          Comment

          Working...
          X