https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16631 --- Comment #188 from Casey Conlin - mattermost @Casey246 <casey.conlin@gmail.com> --- (In reply to Jonathan Druart from comment #186)
Koha_Main_MariaDB_update is failing, see https://jenkins.koha-community.org/view/main/job/Koha_Main_MariaDB_update/ 2369/consoleFull
-- Table structure for table `reports_branches` --
DROP TABLE IF EXISTS `reports_branches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `reports_branches` ( `report_id` int(11) NOT NULL, `branchcode` varchar(10) NOT NULL, KEY `report_id` (`report_id`), KEY `branchcode` (`branchcode`), CONSTRAINT `reports_branches_ibfk_1` FOREIGN KEY (`report_id`) REFERENCES `saved_sql` (`id`) ON DELETE CASCADE, CONSTRAINT `reports_branches_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */;
-- 5962,5974d5978 < ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; < /*!40101 SET character_set_client = @saved_cs_client */; < < DROP TABLE IF EXISTS `reports_branches`; < /*!40101 SET @saved_cs_client = @@character_set_client */; < /*!40101 SET character_set_client = utf8mb4 */; < CREATE TABLE `reports_branches` ( < `report_id` int(11) NOT NULL, < `branchcode` varchar(10) NOT NULL, < KEY `report_id` (`report_id`), < KEY `branchcode` (`branchcode`), < CONSTRAINT `reports_branches_ibfk_1` FOREIGN KEY (`report_id`) REFERENCES `saved_sql` (`id`) ON DELETE CASCADE, < CONSTRAINT `reports_branches_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ERROR - DB structures are not identical 'diff /tmp/current_db.sql /tmp/upgraded_db.sql && diff -q /tmp/current_db.sql /tmp/upgraded_db.sql || { echo "ERROR - DB structures are not identical" && exit 1; }' exited with value 1 at /kohadevbox/misc4dev/run_tests.pl line 310.
I think it's because the CREATE TABLE reports_branches is not correctly placed in the kohastructure.sql file
That link isn't working for me, but that could be because I took too long getting back to this or I don't have permissions. I can't reproduce the issue locally, but it could be that the reports_branches table was being created before the saved_sql table it references. I moved reports_branches to after saved_sql, so hopefully this resolves the issue. If possible, please point me to some info on how I could test this locally or on Jenkins. Thanks! -- You are receiving this mail because: You are watching all bug changes.