Comment 2 for bug 1260713

Attaching .cnf and error logs for recent case happening 2 nodes with 5.5.34-55-log Percona XtraDB Cluster (GPL), wsrep_25.9.r3928
Arbiter: Percona-XtraDB-Cluster-galera-2.x86_64 2.8-1.157.rhel6

Case happened near 8:41:31

Here are the tables:

CREATE TABLE `person_completed_activity` (
`person_completed_activity_key` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`person_key` bigint(20) unsigned NOT NULL,
`activity_key` bigint(20) unsigned NOT NULL,
`challenge_key` bigint(20) unsigned DEFAULT NULL,
`team_key` bigint(20) unsigned DEFAULT NULL,
`completed_date` datetime NOT NULL,
`source_key` bigint(20) unsigned DEFAULT NULL,
`description` varchar(300) DEFAULT NULL,
`lock_cnt` int(11) unsigned NOT NULL,
PRIMARY KEY (`person_completed_activity_key`),
KEY `person_key` (`person_key`),
KEY `activity_key` (`activity_key`),
KEY `challenge_key` (`challenge_key`),
KEY `team_key` (`team_key`),
KEY `person_completed_activity_source` (`source_key`),
CONSTRAINT `person_completed_activity_ibfk_1` FOREIGN KEY (`person_key`) REFERENCES `person` (`person_key`),
CONSTRAINT `person_completed_activity_ibfk_2` FOREIGN KEY (`activity_key`) REFERENCES `activity` (`activity_key`),
CONSTRAINT `person_completed_activity_ibfk_3` FOREIGN KEY (`challenge_key`) REFERENCES `challenge` (`challenge_key`),
CONSTRAINT `person_completed_activity_ibfk_4` FOREIGN KEY (`team_key`) REFERENCES `team` (`team_key`),
CONSTRAINT `person_completed_activity_source` FOREIGN KEY (`source_key`) REFERENCES `source` (`source_key`)
) ENGINE=InnoDB AUTO_INCREMENT=30160601 DEFAULT CHARSET=latin1

CREATE TABLE `statistic` (
`statistic_key` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`statistic_type_key` bigint(20) unsigned NOT NULL,
`value` int(11) NOT NULL,
`statistic_date` date DEFAULT NULL,
`modify_user` varchar(15) NOT NULL,
`modify_timestamp` datetime NOT NULL,
`lock_cnt` int(11) NOT NULL,
`person_completed_activity_key` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`statistic_key`),
KEY `statistic_idx001` (`statistic_type_key`),
KEY `statistic_fk006` (`person_completed_activity_key`),
CONSTRAINT `statistic_fk001` FOREIGN KEY (`statistic_type_key`) REFERENCES `statistic_type` (`statistic_type_key`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `statistic_fk006` FOREIGN KEY (`person_completed_activity_key`) REFERENCES `person_completed_activity` (`person_completed_activity_key`)
) ENGINE=InnoDB AUTO_INCREMENT=100847135 DEFAULT CHARSET=latin1