2 nodes (slave nodes) crash after alter table

This is the list of installed package on the 3 centos 6.5 nodes :
Percona-XtraDB-Cluster-server-56-5.6.20-25.7.888.el6.x86_64
percona-toolkit-2.2.10-1.noarch
percona-xtrabackup-2.2.3-4982.el6.x86_64
Percona-XtraDB-Cluster-galera-3-3.7-1.3254.rhel6.x86_64
Percona-XtraDB-Cluster-galera-3-debuginfo-3.7-1.3254.rhel6.x86_64
percona-release-0.0-1.x86_64
Percona-XtraDB-Cluster-test-56-5.6.20-25.7.888.el6.x86_64
Percona-XtraDB-Cluster-shared-56-5.6.20-25.7.888.el6.x86_64
Percona-XtraDB-Cluster-full-56-5.6.20-25.7.888.el6.x86_64
percona-nagios-plugins-1.1.4-1.noarch
Percona-Server-shared-compat-5.1.68-rel14.6.551.rhel6.x86_64
Percona-XtraDB-Cluster-56-debuginfo-5.6.20-25.7.888.el6.x86_64
Percona-XtraDB-Cluster-client-56-5.6.20-25.7.888.el6.x86_64
Percona-XtraDB-Cluster-garbd-3-3.7-1.3254.rhel6.x86_64

after an alter table for add constraint we have all slave node crash

– Contraintes pour la table DeclensionRelLanguage

ALTER TABLE DeclensionRelLanguage
ADD CONSTRAINT DeclensionRelLanguage_ibfk_4 FOREIGN KEY (languageCode) REFERENCES Language (code) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT DeclensionRelLanguage_ibfk_3 FOREIGN KEY (declensionId) REFERENCES Declension (id) ON DELETE CASCADE;


– Contraintes pour la table GenderRelLanguage

ALTER TABLE GenderRelLanguage
ADD CONSTRAINT GenderRelLanguage_ibfk_4 FOREIGN KEY (languageCode) REFERENCES Language (code) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT GenderRelLanguage_ibfk_3 FOREIGN KEY (genderId) REFERENCES Gender (id) ON DELETE CASCADE;


– Contraintes pour la table SeoTranslation

ALTER TABLE SeoTranslation
ADD CONSTRAINT SeoTranslation_ibfk_4 FOREIGN KEY (translationId) REFERENCES Translation (id) ON DELETE CASCADE;


– Contraintes pour la table SeoTranslationHistory

ALTER TABLE SeoTranslationHistory
ADD CONSTRAINT SeoTranslationHistory_ibfk_1 FOREIGN KEY (actionTypeId) REFERENCES ActionType (id) ON DELETE CASCADE,
ADD CONSTRAINT SeoTranslationHistory_ibfk_2 FOREIGN KEY (userId) REFERENCES User (id) ON DELETE CASCADE,
ADD CONSTRAINT SeoTranslationHistory_ibfk_3 FOREIGN KEY (seoTranslationValueId) REFERENCES SeoTranslationValue (id) ON DELETE CASCADE;


– Contraintes pour la table SeoTranslationValue

ALTER TABLE SeoTranslationValue
ADD CONSTRAINT SeoTranslationValue_ibfk_10 FOREIGN KEY (seoTranslationId) REFERENCES SeoTranslation (id) ON DELETE CASCADE,
ADD CONSTRAINT SeoTranslationValue_ibfk_11 FOREIGN KEY (genderId) REFERENCES Gender (id) ON DELETE CASCADE,
ADD CONSTRAINT SeoTranslationValue_ibfk_12 FOREIGN KEY (declensionId) REFERENCES Declension (id) ON DELETE CASCADE,
ADD CONSTRAINT SeoTranslationValue_ibfk_13 FOREIGN KEY (languageCode) REFERENCES Language (code) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT SeoTranslationValue_ibfk_14 FOREIGN KEY (userId) REFERENCES User (id) ON DELETE CASCADE;


– Contraintes pour la table SeoTranslationValueTransfert

ALTER TABLE SeoTranslationValueTransfert
ADD CONSTRAINT SeoTranslationValueTransfert_ibfk_3 FOREIGN KEY (seoTranslationValueId) REFERENCES SeoTranslationValue (id) ON DELETE CASCADE,
ADD CONSTRAINT SeoTranslationValueTransfert_ibfk_2 FOREIGN KEY (languageCode) REFERENCES Language (code) ON UPDATE CASCADE;

With this error in log :

http://www.percona.com/software/percona-xtradb-cluster/.

Can you say if it’s a bug or an error in the mysql request.

Thanks

Hi, if you can prepare reproducible test case, please file a bug report here: https://bugs.launchpad.net/percona-xtradb-cluster. Provide all necessary information, like initial table schemas, error logs, etc.