[Koha-bugs] [Bug 27313] New: bulkmarcimport.pl -d foreign key constraint fails

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27313

            Bug ID: 27313
           Summary: bulkmarcimport.pl -d foreign key constraint fails
 Change sponsored?: ---
           Product: Koha
           Version: 20.11
          Hardware: All
                OS: Linux
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Command-line Utilities
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: davewood at gmx.at
        QA Contact: testopia at bugs.koha-community.org
                CC: robin at catalyst.net.nz

11:41 < cait1> hm can you file a bug report please?
11:41 < cait1> we have tightened some things in the db, this might be a side
effect
11:41 < cait1> but basically... you have issues
11:41 < cait1> Ausleihen
11:41 < cait1> so it's correct in failing
11:41 < cait1> if you truncate the issues first this is probably going to work
better
11:42 < cait1> the script is not supposed to be used once you have loaded other
transactional data atm
11:42 < cait1> for the same data...


perl /usr/share/koha/bin/migration_tools/bulkmarcimport.pl -d -m=*MARCXML*
-file test.marc.xml
deleting biblios                 
DBD::mysql::db do failed: Cannot delete or update a parent row: a foreign key
constraint fails (`koha_libelle`.`issues`, CONSTRAINT `issues_ibfk_2` FOREIGN
KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON UPDATE CASCADE) [for
Statement "DELETE FROM biblio"] at
/usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 174.
DBD::mysql::db do failed: Cannot delete or update a parent row: a foreign key
constraint fails (`koha_libelle`.`issues`, CONSTRAINT `issues_ibfk_2` FOREIGN
KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON UPDATE CASCADE) [for
Statement "DELETE FROM biblioitems"] at
/usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 176.
DBD::mysql::db do failed: Cannot delete or update a parent row: a foreign key
constraint fails (`koha_libelle`.`issues`, CONSTRAINT `issues_ibfk_2` FOREIGN
KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON UPDATE CASCADE) [for
Statement "DELETE FROM items"] at
/usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 178.
.DBD::mysql::db begin_work failed: Already in a transaction at
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1588, <GEN24> line 2.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.