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

Getting issue where join with any node when enable keyring plugin in xtardb cluster 8.0 ?

lokesh123lokesh123 Current User Role Patron
early-plugin-load=keyring_file.so
keyring_file_data=/var/lib/mysql/keyring



ew ((empty))
2020-08-14T09:32:34.194153Z 0 [Note] [MY-000000] [Galera] gcomm: closed
2020-08-14T09:32:34.194177Z 0 [Note] [MY-000000] [Galera] Member 0.0 (pxc-cluster-node-2) synced with group.
2020-08-14T09:32:34.194192Z 0 [Note] [MY-000000] [Galera] New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
2020-08-14T09:32:34.194224Z 0 [Note] [MY-000000] [Galera] Flow-control interval: [100, 100]
2020-08-14T09:32:34.194234Z 0 [Note] [MY-000000] [Galera] Received NON-PRIMARY.
2020-08-14T09:32:34.194244Z 0 [Note] [MY-000000] [Galera] Shifting JOINER -> OPEN (TO: 8)
2020-08-14T09:32:34.194255Z 0 [Note] [MY-000000] [Galera] New SELF-LEAVE.
2020-08-14T09:32:34.194270Z 0 [Note] [MY-000000] [Galera] Flow-control interval: [0, 0]
2020-08-14T09:32:34.194279Z 0 [Note] [MY-000000] [Galera] Received SELF-LEAVE. Closing connection.
2020-08-14T09:32:34.194289Z 0 [Note] [MY-000000] [Galera] Shifting OPEN -> CLOSED (TO: -1)
2020-08-14T09:32:34.194300Z 0 [Note] [MY-000000] [Galera] RECV thread exiting 0: Success
2020-08-14T09:34:12.014179Z 0 [ERROR] [MY-000000] [WSREP-SST] ******************* FATAL ERROR **********************
2020-08-14T09:34:12.014233Z 0 [ERROR] [MY-000000] [WSREP-SST] Possible timeout in receving first data from donor in gtid/keyring stage
2020-08-14T09:34:12.014250Z 0 [ERROR] [MY-000000] [WSREP-SST] Line 1108
2020-08-14T09:34:12.014266Z 0 [ERROR] [MY-000000] [WSREP-SST] ******************************************************
2020-08-14T09:34:12.014348Z 0 [ERROR] [MY-000000] [WSREP-SST] Cleanup after exit with status:32
2020-08-14T09:34:12.021357Z 0 [ERROR] [MY-000000] [WSREP] Process completed with error: wsrep_sst_xtrabackup-v2 --role 'joiner' --address '192.168.1.129' --datadir '/var/lib/mysql/' --basedir '/usr/' --plugindir '/usr/lib64/mysql/plugin/' --defaults-file '/etc/my.cnf' --defaults-group-suffix '' --parent '18402' --mysqld-version '8.0.19-10'   '' : 32 (Broken pipe)
2020-08-14T09:34:12.021388Z 0 [ERROR] [MY-000000] [WSREP] Failed to read uuid:seqno from joiner script.
2020-08-14T09:34:12.021402Z 0 [ERROR] [MY-000000] [WSREP] SST script aborted with error 32 (Broken pipe)
2020-08-14T09:34:12.021474Z 3 [Note] [MY-000000] [Galera] Processing SST received
2020-08-14T09:34:12.021496Z 3 [Note] [MY-000000] [Galera] SST received: 00000000-0000-0000-0000-000000000000:-1
2020-08-14T09:34:12.021518Z 3 [System] [MY-000000] [WSREP] SST completed
2020-08-14T09:34:12.021549Z 2 [Note] [MY-000000] [Galera]  str_proto_ver_: 3 sst_seqno_: -1 cc_seqno: 8 req->ist_len(): 64
2020-08-14T09:34:12.021576Z 2 [ERROR] [MY-000000] [Galera] Application received wrong state:
        Received: 00000000-0000-0000-0000-000000000000
        Required: 8a0c2dfe-de0b-11ea-9075-7a0902ce80f1
2020-08-14T09:34:12.021593Z 2 [ERROR] [MY-000000] [Galera] Application state transfer failed. This is unrecoverable condition, restart required.
2020-08-14T09:34:12.021610Z 2 [Note] [MY-000000] [Galera] ReplicatorSMM::abort()
2020-08-14T09:34:12.021635Z 2 [Note] [MY-000000] [Galera] Closing send monitor...
2020-08-14T09:34:12.021653Z 2 [Note] [MY-000000] [Galera] Closed send monitor.
2020-08-14T09:34:12.021672Z 2 [Note] [MY-000000] [Galera] recv_thread() joined.
2020-08-14T09:34:12.021693Z 2 [Note] [MY-000000] [Galera] Closing replication queue.
2020-08-14T09:34:12.021709Z 2 [Note] [MY-000000] [Galera] Closing slave action queue.
2020-08-14T09:34:12.021723Z 2 [Note] [MY-000000] [Galera] /usr/sbin/mysqld: Terminated.
2020-08-14T09:34:12.021733Z 2 [Note] [MY-000000] [WSREP] Initiating SST cancellation

Best Answer

Answers

  • jriverajrivera Percona Support Engineer Percona Staff Role
    Can you share full mysql config file? Did you configure SSL parameters or pxc_encrypt_cluster_traffic and initially copied SSL certificates from bootstrapped node to joiner nodes?
  • lokesh123lokesh123 Current User Role Patron
    [client]
    socket=/var/lib/mysql/mysql.sock
    ssl-ca=/home/adminuser/srt/ca.pem
    ssl-key=/home/adminuser/srt/client-key.pem
    ssl-cert=/home/adminuser/srt/client-cert.pem

    [mysqld]
    server-id=1
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    # Binary log expiration period is 604800 seconds, which equals 7 days
    binlog_expire_logs_seconds=604800
    ######## wsrep ###############
    # Path to Galera library
    wsrep_provider=/usr/lib64/galera4/libgalera_smm.so
    # Cluster connection URL contains IPs of nodes
    #If no IP is found, this implies that a new cluster needs to be created,
    #in order to do that you need to bootstrap this node
    wsrep_cluster_address=gcomm://192.168.1.129,192.168.1.157,192.168.1.164
    # In order for Galera to work correctly binlog format should be ROW
    binlog_format=ROW
    # Slave thread to use
    wsrep_slave_threads=8
    wsrep_log_conflicts
    # This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
    innodb_autoinc_lock_mode=2
    # Node IP address
    wsrep_node_address=192.168.1.157
    # Cluster name
    wsrep_cluster_name=pxc-cluster
    #If wsrep_node_name is not specified,  then system hostname will be used
    wsrep_node_name=pxc-cluster-node-2
    #pxc_strict_mode allowed values: DISABLED,PERMISSIVE,ENFORCING,MASTER
    pxc_strict_mode=ENFORCING
    wsrep_sst_method=xtrabackup-v2
    wsrep_provider_options=”socket.ssl_key=/home/adminuser/srt/server-key.pem;socket.ssl_cert=/home/adminuser/srt/server-cert.pem;socket.ssl_ca=/home/adminuser/srt/ca.pem”
    [sst]
    encrypt=4
    ssl-key=/home/adminuser/srt/server-key.pem
    ssl-ca=/home/adminuser/srt/ca.pem
    ssl-cert=/home/adminuser/srt/server-cert.pem
  • lokesh123lokesh123 Current User Role Patron
    It resolved  jrivera Thankyou ,so much the issue was with pxc_encrypt_cluster_traffic configuration.
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.