sync level violation with wsrep checkpointing

Bug #1248908 reported by Teemu Ollakka
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Status tracked in 5.6
5.5
Fix Released
High
Teemu Ollakka
5.6
Fix Released
High
Teemu Ollakka
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
Status tracked in 5.6
5.5
Fix Released
Undecided
Unassigned
5.6
Fix Released
Undecided
Unassigned

Bug Description

After turning UNIV_SYNC_DEBUG on, node that was started from clean state crashed immediately at startup with:

InnoDB: sync levels should be > 290 but a level is 290
-------------
RW-LATCH INFO
RW-LATCH: 0x7fdbcbd411b0
Locked: thread 140582617687872 file /home/teemu/codership/galera/bzr/codership-mysql/5.6/storage/innobase/include/trx0sys.ic line 103 X-LOCK
Locked: thread 140582617687872 file /home/teemu/codership/galera/bzr/codership-mysql/5.6/storage/innobase/include/trx0sys.ic line 103 X-LOCK
InnoDB: sync_thread_levels_g(array, 290) does not hold!
2013-11-07 12:38:51 7fdbf0fd2740 InnoDB: Assertion failure in thread 140582617687872 in file sync0sync.cc line 1171

The reason is calling trx_sysf_get() twice in succession, first from trx_sys_read_wsrep_checkpoint(), then from trx_sys_update_wsrep_checkpoint().

Similar crash happens when binlog is enabled and trx_sys_update_wsrep_checkpoint() and trx_sys_update_mysql_binlog() are called twice in succession.

Revision history for this message
Teemu Ollakka (teemu-ollakka) wrote :
Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

trx_sys_update_mysql_binlog_offset was missed in commit for https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1228341

Hence, merging these commits as well.

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-1511

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.