Comment 8 for bug 1158221

Revision history for this message
Jon Schneider (jon-schneider) wrote :

Using 5.6.20-68.0-56-log Percona XtraDB Cluster

I am receiving a similar node crash when a nightly OPTIMIZE_TABLE was running:

2014-10-09 00:31:53 57717 [Note] WSREP: MDL BF-BF conflict
request: (127191 seqno 47399098 wsrep (2, 1, 0) cmd 3 48 OPTIMIZE TABLE maillog, mtalog, audit_log)
granted: (1 seqno 47399100 wsrep (1, 0, 0) cmd 0 144 (null))
2014-10-09 00:31:53 57717 [Note] WSREP: MDL BF-BF conflict
request: (127191 seqno 47399098 wsrep (2, 1, 0) cmd 3 48 OPTIMIZE TABLE maillog, mtalog, audit_log)
granted: (1 seqno 47399100 wsrep (1, 0, 0) cmd 0 144 (null))
2014-10-09 00:31:53 57717 [Note] WSREP: MDL BF-BF conflict
request: (127191 seqno 47399098 wsrep (2, 1, 0) cmd 3 48 OPTIMIZE TABLE maillog, mtalog, audit_log)
granted: (1 seqno 47399100 wsrep (1, 0, 0) cmd 0 144 (null))
2014-10-09 00:31:53 57717 [Note] WSREP: MDL BF-BF conflict
request: (127191 seqno 47399098 wsrep (2, 1, 0) cmd 3 48 OPTIMIZE TABLE maillog, mtalog, audit_log)
granted: (1 seqno 47399100 wsrep (1, 0, 0) cmd 0 144 (null))
2014-10-09 00:33:45 57717 [Note] WSREP: MDL BF-BF conflict
request: (127191 seqno 47399098 wsrep (2, 1, 0) cmd 3 48 OPTIMIZE TABLE maillog, mtalog, audit_log)
granted: (1 seqno 47399100 wsrep (1, 0, 0) cmd 0 144 (null))
2014-10-09 00:33:45 57717 [ERROR] WSREP: Trx 47399098 tries to abort slave trx 47399100. This could be caused by:
        1) unsupported configuration options combination, please check documentation.
        2) a bug in the code.
        3) a database corruption.
 Node consistency compromized, need to abort. Restart the node to resync with cluster.