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 :
[URL=“Percona XtraDB Cluster – The MySQL Clustering Solution”]http://www.percona.com/software/percona-xtradb-cluster/.[/URL]
Can you say if it’s a bug or an error in the mysql request.
Thanks