Galera Replication from 5.6 node to 5.5 node fails
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL patches by Codership |
In Progress
|
Medium
|
Seppo Jaakola | |||
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC | Status tracked in 5.6 | |||||
5.5 |
Invalid
|
High
|
Unassigned | |||
5.6 |
Fix Committed
|
Undecided
|
Unassigned |
Bug Description
Galera replication stream from a 5.6 host to a 5.5 node fails
5.5 node:
=======
131114 12:28:57 [ERROR] Error in Log_event:
131114 12:28:57 [ERROR] WSREP: applier could not read binlog event, seqno: 213, len: 0
131114 12:28:57 [Warning] WSREP: Failed to apply app buffer: seqno: 213, status: 1
at galera/
Retrying 2th time
131114 12:28:57 [ERROR] Error in Log_event:
131114 12:28:57 [ERROR] WSREP: applier could not read binlog event, seqno: 213, len: 0
131114 12:28:57 [Warning] WSREP: Failed to apply app buffer: seqno: 213, status: 1
at galera/
Retrying 3th time
131114 12:28:57 [ERROR] Error in Log_event:
131114 12:28:57 [ERROR] WSREP: applier could not read binlog event, seqno: 213, len: 0
131114 12:28:57 [Warning] WSREP: Failed to apply app buffer: seqno: 213, status: 1
at galera/
Retrying 4th time
131114 12:28:57 [ERROR] Error in Log_event:
131114 12:28:57 [ERROR] WSREP: applier could not read binlog event, seqno: 213, len: 0
131114 12:28:57 [Warning] WSREP: Failed to apply app buffer: seqno: 213, status: 1
at galera/
Retrying 5th time
131114 12:28:57 [ERROR] Error in Log_event:
131114 12:28:57 [ERROR] WSREP: applier could not read binlog event, seqno: 213, len: 0
131114 12:28:57 [Warning] WSREP: Failed to apply app buffer: seqno: 213, status: 1
at galera/
Retrying 6th time
131114 12:28:57 [ERROR] Error in Log_event:
131114 12:28:57 [ERROR] WSREP: applier could not read binlog event, seqno: 213, len: 0
131114 12:28:57 [Warning] WSREP: Failed to apply app buffer: seqno: 213, status: 1
at galera/
Retrying 7th time
131114 12:28:57 [ERROR] Error in Log_event:
131114 12:28:57 [ERROR] WSREP: applier could not read binlog event, seqno: 213, len: 0
131114 12:28:57 [Warning] WSREP: Failed to apply app buffer: seqno: 213, status: 1
at galera/
Retrying 8th time
131114 12:28:57 [ERROR] Error in Log_event:
131114 12:28:57 [ERROR] WSREP: applier could not read binlog event, seqno: 213, len: 0
131114 12:28:57 [Warning] WSREP: Failed to apply app buffer: seqno: 213, status: 1
at galera/
Retrying 9th time
131114 12:28:57 [ERROR] Error in Log_event:
131114 12:28:57 [ERROR] WSREP: applier could not read binlog event, seqno: 213, len: 0
131114 12:28:57 [Warning] WSREP: Failed to apply app buffer: seqno: 213, status: 1
at galera/
Retrying 10th time
131114 12:28:57 [ERROR] Error in Log_event:
131114 12:28:57 [ERROR] WSREP: applier could not read binlog event, seqno: 213, len: 0
131114 12:28:57 [ERROR] WSREP: Failed to apply trx: source: e87c1c41-
131114 12:28:57 [ERROR] WSREP: Failed to apply trx 213 10 times
131114 12:28:57 [ERROR] WSREP: Node consistency compromized, aborting...
131114 12:28:57 [Note] WSREP: Closing send monitor...
131114 12:28:57 [Note] WSREP: Closed send monitor.
131114 12:28:57 [Note] WSREP: gcomm: terminating thread
131114 12:28:57 [Note] WSREP: gcomm: joining thread
131114 12:28:57 [Note] WSREP: gcomm: closing backend
131114 12:28:58 [Note] WSREP: view(view_
} joined {
} left {
} partitioned {
}
5.6 node:
=======
2013-11-14 12:28:57 7110 [Note] WSREP: New cluster view: global state: 11264cec-
2013-11-14 12:28:57 7110 [Warning] WSREP: Unsupported protocol downgrade: incremental data collection disabled. Expect abort.
2013-11-14 12:28:57 7110 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2013-11-14 12:28:57 7110 [Note] WSREP: REPL Protocols: 5 (3, 1)
2013-11-14 12:28:57 7110 [Note] WSREP: Assign initial position for certification: 213, protocol version: 3
2013-11-14 12:28:57 7110 [Note] WSREP: Service thread queue flushed.
2013-11-14 12:28:57 7110 [Warning] WSREP: trx protocol version: 2 does not match certification protocol version: 3
2013-11-14 12:29:03 7110 [Note] WSREP: cleaning up faef1ff9-
=======
5.5 node has 25.2.8 galera
5.6 node has 25.3.1 galera
Note, that this is even with socket.checksum=1 on 5.6 host.
summary: |
- Galera Replication between 5.6 and 5.5 fails + Galera Replication from 5.6 node to 5.5 node fails |
5.6 node is on:
rpm -qa | grep -i percona XtraDB- Cluster- client- 56-5.6. 14-rel25. 1.1.rhel6. x86_64 XtraDB- Cluster- galera- 56-3.1- 1.169.rhel6. x86_64 XtraDB- Cluster- shared- 56-5.6. 14-rel25. 1.1.rhel6. x86_64 Server- shared- 51-5.1. 72-rel14. 10.597. rhel6.x86_ 64 xtrabackup- 2.1.5-680. rhel6.x86_ 64 XtraDB- Cluster- server- 56-5.6. 14-rel25. 1.1.rhel6. x86_64 testing- 0.0-1.noarch
Percona-
Percona-
Percona-
Percona-
percona-
Percona-
percona-
(Server version: 5.6.14-56 Percona XtraDB Cluster (GPL), Release 25.1, Revision 557, wsrep_25.1.r4019)
5.5 node is on:
rpm -qa | grep -i percona xtrabackup- test-2. 0.2-461. rhel6.x86_ 64 XtraDB- Cluster- client- 5.5.34- 25.9.575. rhel6.x86_ 64 Server- shared- compat- 5.5.34- rel32.0. 591.rhel6. x86_64 toolkit- 2.1.3-2. noarch XtraDB- Cluster- galera- 2.8-1.165. rhel6.x86_ 64 XtraDB- Cluster- shared- 5.5.34- 25.9.575. rhel6.x86_ 64 XtraDB- Cluster- server- 5.5.34- 25.9.575. rhel6.x86_ 64 XtraDB- Cluster- debuginfo- 5.5.34- 25.9.575. rhel6.x86_ 64 XtraDB- Cluster- galera- debuginfo- 2.8-1.162. rhel6.x86_ 64 testing- 0.0-1.noarch xtrabackup- 2.1.5-680. rhel6.x86_ 64 XtraDB- Cluster- test-5. 5.34-25. 9.575.rhel6. x86_64 XtraDB- Cluster- devel-5. 5.34-25. 9.575.rhel6. x86_64
percona-
Percona-
Percona-
percona-
Percona-
Percona-
Percona-
Percona-
Percona-
percona-
percona-
Percona-
Percona-