Not the answer you need?
Register and ask your own question!

2 nodes (slave nodes) crash after alter table

stuxboulotstuxboulot EntrantInactive User Role Beginner
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

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.