Announcement

Announcement Module
Collapse
No announcement yet.

Percona 5.5.23

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

  • Percona 5.5.23

    Hi,

    I've upgraded My Percona on 5.5.23.
    The first node start without problem, but the others nodes failed due to errors :

    120516 14:57:44 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (18df8ebb-848f-11e1-0800-34439383ee44): 1 (Operation not permitted)
    at galera/src/replicator_str.cpprepare_for_IST():439. IST will be unavailable.
    120516 14:57:44 [Note] WSREP: Node 0 (percona-node2) requested state transfer from '*any*'. Selected 1 (percona-node1)(SYNCED) as donor.
    120516 14:57:44 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 1403)
    120516 14:57:44 [Note] WSREP: Requesting state transfer: success, donor: 1
    120516 14:57:54 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup 'joiner' '192.168.2.150' '***:*****' '/var/lib/mysql/' '/etc/mysql/my.cnf' '1756' 2>sst.err: 32 (Broken pipe)
    120516 14:57:54 [ERROR] WSREP: Failed to read uuid:seqno from joiner script.
    120516 14:57:54 [ERROR] WSREP: SST failed: 32 (Broken pipe)
    120516 14:57:54 [ERROR] Aborting

    120516 14:57:54 [Warning] WSREP: 1 (percona-node1): State transfer to 0 (percona-node2) failed: -1 (Operation not permitted)
    120516 14:57:54 [ERROR] WSREP: gcs/src/gcs_group.c:gcs_group_handle_join_msg():712: Will never receive state. Need to abort.

    In the sst.err file:
    tar: This does not look like a tar archive
    tar: Exiting with failure status due to previous errors
    Error while getting st data from donor node

    In innobackup.backup.log file :
    xtrabackup: Error: Please set parameter 'datadir'
    innobackupex: fatal error: no 'mysqld' group in MySQL options
    innobackupex: fatal error: OR no 'datadir' option in group 'mysqld' in MySQL options

    Why this pb and how to resolve it

    Thx a lot

  • #2
    azigui wrote on Wed, 16 May 2012 16:26
    xtrabackup: Error: Please set parameter 'datadir'
    innobackupex: fatal error: no 'mysqld' group in MySQL options
    innobackupex: fatal error: OR no 'datadir' option in group 'mysqld' in MySQL options
    Have you looked at your /etc/mysql/my.cnf?

    Comment


    • #3
      I resolve it, you must put in my.cnf file in [MYSQLD] section :
      datadir=/var/lib/mysql
      tmpdir=/tmp
      user=mysql

      Be carrefull, you can probably obtain a start/stop failed, so you must update password for mysql user debian-syst-main.
      This password is written in debian.cnf file

      Comment


      • #4
        Hello guys

        Today was my first introduction to percona (5.5.24)

        and I have same problem
        I have used this guide http://www.mysqlperformanceblog.com/2012/06/20/percona-xtrad b-cluster-reference-architecture-with-haproxy/
        I have installed first node (percona) on the VM, then clone this VM to new "percona2" and made proper configurations in my.cnf for node 2 (from guide)

        So I have two almost identically nodes - first node starts without error, but second always fails with same error.

        please help me resolve this problem

        Comment


        • #5
          I figured this out
          I just needed to enable some ports ( http://www.percona.com/doc/percona-xtradb-cluster/3nodesec2. html)

          Comment

          Working...
          X