https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41421 Bug ID: 41421 Summary: Bug 35830 DB update must be idempotent Initiative type: --- Sponsorship --- status: Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: critical Priority: P5 - low Component: Database Assignee: koha-bugs@lists.koha-community.org Reporter: lucas@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org To recreate: -Checkout 25.05.x -Add the edit_borrower permission to at least 1 borrower -sudo koha-mysql kohadev -UPDATE systempreferences SET value='25.0505003' WHERE variable='Version'; -updatedatabase, you should see: Upgrade to 25.05.05.004 [13:53:15]: Bug 35830 - Add permission borrowers:merge_borrowers Added new permission 'merge_borrowers' Added 'merge_borrowers' permission to existing users with 'edit_borrowers' -major version upgrade with git checkout 25.11.x -updatedatabase it dies: Upgrade to 25.06.00.028 [13:53:59]: Bug 35830 - Add permission borrowers:merge_borrowers Added new permission 'merge_borrowers' ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry '19-4-merge_borrowers' for key 'PRIMARY' at /kohadevbox/koha/C4/Installer.pm line 82 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.