Comment 4 for bug 1202241

Revision history for this message
Alex Yurchenko (ayurchen) wrote :

Jay, yes contents of these files are slightly different, but you said that they were "sanitized" and I strongly believe they come from the same original log:

tarragon-7_44-7-57.out:
=================
130613 7:21:40 [Note] WSREP: Running: 'wsrep_sst_xtrabackup --role 'donor' --address 'XXX.XXX.XXX.206:4444/xtrabackup_sst' --auth 'sst_backup:lb5G58PAaeDhk' --socket '/var/lib/mysql/mysql.sock' --datadir '/mnt/ssd/mysql/' --defaults-file '/etc/my.cnf' --gtid '82ff21da-0811-11e2-0800-3771efde9244:8361077172''
...
130613 7:44:16 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3
...
130613 7:44:16 [Note] WSREP: STATE EXCHANGE: got state msg: b92282d0-d437-11e2-0800-644a2bba7edc from 0 (tarragon)
130613 7:44:16 [Note] WSREP: STATE EXCHANGE: got state msg: b92282d0-d437-11e2-0800-644a2bba7edc from 1 (tabasco)
130613 7:44:16 [Note] WSREP: STATE EXCHANGE: got state msg: b92282d0-d437-11e2-0800-644a2bba7edc from 2 (tandoori)

tamarind-7_44-7-57.out:
=================
130613 7:21:40 [Note] WSREP: IST first seqno 8246011901 not found from cache, falling back to SST
130613 7:21:40 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
130613 7:21:40 [Note] WSREP: Running: 'wsrep_sst_xtrabackup --role 'donor' --address 'XXX.XXX.XXX.206:4444/xtrabackup_sst' --auth 'sst_backup:lb5G58PAaeDhk' --socket '/var/lib/mysql/mysql.sock' --datadir '/mnt/ssd/mysql/' --defaults-file '/etc/my.cnf' --gtid '82ff21da-0811-11e2-0800-3771efde9244:8361077172''
...
130613 7:44:16 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3
...
130613 7:44:16 [Note] WSREP: STATE EXCHANGE: got state msg: b92282d0-d437-11e2-0800-644a2bba7edc from 0 (tarragon)
130613 7:44:16 [Note] WSREP: STATE EXCHANGE: got state msg: b92282d0-d437-11e2-0800-644a2bba7edc from 1 (tabasco)
130613 7:44:16 [Note] WSREP: STATE EXCHANGE: got state msg: b92282d0-d437-11e2-0800-644a2bba7edc from 2 (tandoori)
130613 7:44:16 [Note] WSREP: Quorum results:
        version = 2,
        component = PRIMARY,
        conf_id = 284,
        members = 3/3 (joined/total),
        act_id = 8363856198,
        last_appl. = 8363855423,
        protocols = 0/4/2 (gcs/repl/appl),
        group UUID = 82ff21da-0811-11e2-0800-3771efde9244

- notice that "tarragon" speaks like donor (even though you claim that donor was tamarind, and tarragon was a joiner) and says pretty much the same stuff as "tamarind", AND "tamarind" never cares to get a state exchange messages from itself, but instead gets it from tarragon, tabasco and tandoori in a three-node component, leaving no space for "tamarind" there.