Comment 4 for bug 1282707

Revision history for this message
i.Tuzhilkin (ivan-tuzhilkin) wrote : Re: Percona XtraDB Cluster 5.6 crash on ALTER TABLE

It happens again, on fresh release. Same error.

After this:
"ALTER TABLE common_referal_payment CHANGE parent_payment_id parent_payment_id INTEGER(11) NOT NULL;"

Table structure:

CREATE TABLE IF NOT EXISTS `common_referal_payment` (
  `id` int(11) NOT NULL,
  `child_id` int(11) NOT NULL,
  `parent_payment_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `child_id` (`child_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `common_referal_payment`
  ADD CONSTRAINT `common_referal_payment_ibfk_1` FOREIGN KEY (`id`) REFERENCES `abstract_payment` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `common_referal_payment_ibfk_2` FOREIGN KEY (`child_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;