GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

errors when starting the 2nd node

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

  • errors when starting the 2nd node

    I am evaluating percona cluster to see if we should use it, but I have getting the following errors when starting the 2nd node. Please help.

    mysql.log
    140501 14:13:19 [Note] WSREP: New cluster view: global state: c9d04a44-d0be-11e3-b9da-ff3aecfc8ed9:23, view# 6: Primary, number of nodes: 2, my index: 0, protocol version 2
    140501 14:13:19 [Warning] WSREP: Gap in state sequence. Need state transfer.
    140501 14:13:21 [Note] WSREP: Running: 'wsrep_sst_xtrabackup --role 'joiner' --address 'dbsmyt03' --auth 'sst:secret' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --parent '10144''
    WSREP_SST: [INFO] Streaming with tar (20140501 14:13:21.971)
    WSREP_SST: [INFO] Using socat as streamer (20140501 14:13:21.972)
    WSREP_SST: [INFO] Evaluating socat -u TCP-LISTEN:4444,reuseaddr stdio | tar xfi - --recursive-unlink -h; RC=( ${PIPESTATUS[@]} ) (20140501 14:13:21.979)
    socat: error while loading shared libraries: libreadline.so.5: cannot open shared object file: No such file or directory
    tar: This does not look like a tar archive
    tar: Exiting with failure status due to previous errors
    140501 14:13:32 [Note] WSREP: Prepared SST request: xtrabackup|dbsmyt03:4444/xtrabackup_sst
    140501 14:13:32 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
    140501 14:13:32 [Note] WSREP: Assign initial position for certification: 23, protocol version: 2
    140501 14:13:32 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (c9d04a44-d0be-11e3-b9da-ff3aecfc8ed9): 1 (Operation not permitted)
    at galera/src/replicator_str.cpprepare_for_IST():445. IST will be unavailable.
    140501 14:13:32 [Note] WSREP: Node 0 (dbsmyt03) requested state transfer from '*any*'. Selected 1 (dbsmyt01)(SYNCED) as donor.
    140501 14:13:32 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 23)
    140501 14:13:32 [Note] WSREP: Requesting state transfer: success, donor: 1
    WSREP_SST: [ERROR] Error while getting data from donor node: exit codes: 127 2 (20140501 14:13:32.226)
    WSREP_SST: [ERROR] Cleanup after exit with status:32 (20140501 14:13:32.227)
    WSREP_SST: [INFO] Removing the sst_in_progress file (20140501 14:13:32.228)
    140501 14:13:32 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup --role 'joiner' --address 'dbsmyt03' --auth 'sst:secret' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --parent '10144': 32 (Broken pipe)
    140501 14:13:32 [ERROR] WSREP: Failed to read uuid:seqno from joiner script.
    140501 14:13:32 [ERROR] WSREP: SST failed: 32 (Broken pipe)
    140501 14:13:32 [ERROR] Aborting

    140501 14:13:32 [Warning] WSREP: 1 (dbsmyt01): State transfer to 0 (dbsmyt03) failed: -1 (Operation not permitted)
    140501 14:13:32 [ERROR] WSREP: gcs/src/gcs_group.c:gcs_group_handle_join_msg():719: Will never receive state. Need to abort.
    140501 14:13:32 [Note] WSREP: gcomm: terminating thread
    140501 14:13:32 [Note] WSREP: gcomm: joining thread
    140501 14:13:32 [Note] WSREP: gcomm: closing backend
    140501 14:13:33 [Note] WSREP: view(view_id(NON_PRIM,461454d0-d15c-11e3-9324-37342298a57d,6) memb {
    461454d0-d15c-11e3-9324-37342298a57d,
    } joined {
    } left {
    } partitioned {
    bed5f1c5-d15b-11e3-8e95-0e9dd5f855e1,
    })
    140501 14:13:33 [Note] WSREP: view((empty))
    140501 14:13:33 [Note] WSREP: gcomm: closed
    140501 14:13:33 [Note] WSREP: /usr/sbin/mysqld: Terminated.
    140501 14:13:33 mysqld_safe mysqld from pid file /var/lib/mysql/mysql.pid ended
    Last edited by TomD; 05-01-2014, 05:13 PM. Reason: Hi madaca, I moved this to a fresh thread as it is a new topic. This will give your question a better chance of getting a solution for you from the community.

  • #2
    >> WSREP_SST: [INFO] Evaluating socat -u TCP-LISTEN:4444,reuseaddr stdio | tar xfi - --recursive-unlink -h; RC=( ${PIPESTATUS[@]} ) (20140501 14:13:21.979)
    socat: error while loading shared libraries: libreadline.so.5: cannot open shared object file: No such file or directory
    >> tar: This does not look like a tar archive

    Look likes netcat is not installed which is required for streaming backups. http://www.percona.com/doc/percona-x...kx_stream.html
    $ sudo yum install netcat (RHEL/CentOS)
    $ sudo aptitude install netcat (Ubuntu/Debian)

    After installing netcat, retry starting node2.

    Comment


    • #3
      Hi mifan,
      Is netcat same as nc? I installed that and it didn't help. I also changed the wsrep_sst_method from xtrabackup to rsync, but still having problem starting the 2nd node.
      Thanks,
      Manny

      Comment

      Working...
      X