[Bug 26025] New: Data loss issue during Schema database upgrade from 16.11 to 20.05
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26025 Bug ID: 26025 Summary: Data loss issue during Schema database upgrade from 16.11 to 20.05 Change sponsored?: --- Product: Koha Version: 20.05 Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Installation and upgrade (command-line installer) Assignee: koha-bugs@lists.koha-community.org Reporter: mishravk79@gmail.com QA Contact: testopia@bugs.koha-community.org Hi While trying to run database upgrade command from Koha 16.11 to 20.05 it gives following error: Upgrade to 16.12.00.003 done (Bug 17486 - Remove 'Mozilla Persona' as an authentication method) DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`deletedbiblio_metadata`, CONSTRAINT `deletedbiblio_metadata_fk_1` FOREIGN KEY (`biblionumber`) REFERENCES `deletedbiblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE) [for Statement " INSERT INTO deletedbiblio_metadata ( biblionumber, format, marcflavour, metadata ) SELECT biblionumber, 'marcxml', 'CHANGEME', marcxml FROM deletedbiblioitems; "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 13816. Above seems to be data loss under deletedbiblioitem etc. as per discussion over Koha mailing list? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26025 Amit Gupta <amitddng135@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |amit.gupta@informaticsgloba | |l.com, | |amitddng135@gmail.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26025 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@bugs.koha-c | |ommunity.org --- Comment #1 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Hi Vinod, This is a quite old update DB version, and I am not sure it makes sense to fix it as nobody else reported the problem before. To handle this you could: 1. Restore a previous version of the DB 2. Fix the id collision in deletedbiblioitems This wiki page will help you to catch the problematic entries: https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix#Is_your_data_co... Basically you need find the duplicate ID in deletedbiblio[items] tables, like: select count(*) as c, biblionumber from deletedbiblio group by biblionumber having c > 1; The easier is to remove the duplicated ID, but you may delete important data. If you want to keep the data you should modify the ID (this can be tricky, depending on the other data you have in biblio[items]) 3. Execute the updatedatabase script -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26025 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|20.05 |master Summary|Data loss issue during |Data loss issue during |Schema database upgrade |Schema database upgrade |from 16.11 to 20.05 |from 16.11 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26025 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |WONTFIX Status|NEW |RESOLVED --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- (In reply to Jonathan Druart from comment #1)
Hi Vinod,
This is a quite old update DB version, and I am not sure it makes sense to fix it as nobody else reported the problem before.
It's another 3 years later. I am closing WONTFIX. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org