Problem on Staged MARC management
Hi. I've set up a new VM with Koha (16.11.08.000) and imported my old UNIMARC Frameworks. I tried to import a MARC Record (marcxml). I can upload the file, then Stage for import, but then when I *Import this batch into the catalog* on *Manage staged MARC records*, the Job progress bar will keep *0%* forever. If I refresh page it shows that the record was staged ok. The problem is related with the *Item* because when I choose *NO* on *Check for embedded item record data?* it works, the Job progress bar will go to *100%* On */var/log/koha/koha/intranet-error.log* /[cgi:error] [pid 1580] [client xx.xx.xx.xx:35538] AH01215: [Tue May 30 14:34:16 2017] stage-marc-import.pl: Use of uninitialized value in concatenation (.) or string at /usr/share/perl5/MARC/File/XML.pm line 397, <__ANONIO__> chunk 2.: /usr/share/koha/intranet/cgi-bin/tools/stage-marc-import.pl, referer: http://yy.yy.yy.yy::8080/cgi-bin/koha/tools/stage-marc-import.pl/ Maybe a bug? Thank you ----- Koha version: 16.05.05 - - José Anjos -- View this message in context: http://koha.1045719.n5.nabble.com/Problem-on-Staged-MARC-management-tp593520... Sent from the Koha-general mailing list archive at Nabble.com.
Hello José, Can you share the marcxml of the item in which this is happening? Have you tried importing other biblios+items? Also, what happens if you import using the bulkmarcimport.pl <https://perldoc.koha-community.org/misc/migration_tools/bulkmarcimport.html> script instead of UI import? 2017-05-30 14:54 GMT+00:00 anjoze <joseanjos@gmail.com>:
Hi. I've set up a new VM with Koha (16.11.08.000) and imported my old UNIMARC Frameworks. I tried to import a MARC Record (marcxml). I can upload the file, then Stage for import, but then when I *Import this batch into the catalog* on *Manage staged MARC records*, the Job progress bar will keep *0%* forever. If I refresh page it shows that the record was staged ok.
The problem is related with the *Item* because when I choose *NO* on *Check for embedded item record data?* it works, the Job progress bar will go to *100%*
On */var/log/koha/koha/intranet-error.log* /[cgi:error] [pid 1580] [client xx.xx.xx.xx:35538] AH01215: [Tue May 30 14:34:16 2017] stage-marc-import.pl: Use of uninitialized value in concatenation (.) or string at /usr/share/perl5/MARC/File/XML.pm line 397, <__ANONIO__> chunk 2.: /usr/share/koha/intranet/cgi-bin/tools/stage-marc-import.pl, referer: http://yy.yy.yy.yy::8080/cgi-bin/koha/tools/stage-marc-import.pl/
Maybe a bug? Thank you
----- Koha version: 16.05.05 - - José Anjos -- View this message in context: http://koha.1045719.n5.nabble. com/Problem-on-Staged-MARC-management-tp5935206.html Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Olá Pedro, Yes I've tried other files. Trying with bulkmarcimport.pl I have this message: / bib-64150.marcxml <http://koha.1045719.n5.nabble.com/file/n5935220/bib-64150.marcxml> deleting biblios DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign key constraint (`koha_koha`.`aqorders`, CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `koha_koha`.`biblio` (`biblionumber`)) [for Statement "truncate biblio"] at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 150. DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign key constraint (`koha_koha`.`items`, CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `koha_koha`.`biblioitems` (`biblioitemnumber`)) [for Statement "truncate biblioitems"] at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 151. DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign key constraint (`koha_koha`.`accountlines`, CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `koha_koha`.`items` (`itemnumber`)) [for Statement "truncate items"] at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 152. Characteristic MARC flavour: UNIMARC . 1 MARC records done in 0.147950887680054 seconds/ Maybe its a problem with Mysql 5.7? There was a lot of problems with mysql 5.7... ----- Koha version: 16.05.05 - - José Anjos -- View this message in context: http://koha.1045719.n5.nabble.com/Problem-on-Staged-MARC-management-tp593520... Sent from the Koha-general mailing list archive at Nabble.com.
Hey, Maybe. The following link reads *All version of Koha (3.x, 16.05, 16.11) are not compatible with default config of MySQL 5.7* and provides a solution: https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04_... We are currently using *mysql 5.6.26* and we have *sql_mode=NO_ENGINE_SUBSTITUTION* in *my.cnf*. I'm not sure if it's related but wouldn't hurt to try using mysql < 5.7, given the documentation. Pedro Amorim 2017-05-30 15:44 GMT+00:00 anjoze <joseanjos@gmail.com>:
Olá Pedro,
Yes I've tried other files. Trying with bulkmarcimport.pl I have this message:
/ bib-64150.marcxml <http://koha.1045719.n5.nabble.com/file/n5935220/bib-64150.marcxml> deleting biblios DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign key constraint (`koha_koha`.`aqorders`, CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `koha_koha`.`biblio` (`biblionumber`)) [for Statement "truncate biblio"] at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 150. DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign key constraint (`koha_koha`.`items`, CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `koha_koha`.`biblioitems` (`biblioitemnumber`)) [for Statement "truncate biblioitems"] at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 151. DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign key constraint (`koha_koha`.`accountlines`, CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `koha_koha`.`items` (`itemnumber`)) [for Statement "truncate items"] at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 152. Characteristic MARC flavour: UNIMARC . 1 MARC records done in 0.147950887680054 seconds/
Maybe its a problem with Mysql 5.7? There was a lot of problems with mysql 5.7...
----- Koha version: 16.05.05 - - José Anjos -- View this message in context: http://koha.1045719.n5.nabble. com/Problem-on-Staged-MARC-management-tp5935206p5935220.html Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Tried with a new VM (16.11.08.000) with mariaDB same problem. Can someone check if this is a bug? Thanks ----- Koha version: 16.05.05 - - José Anjos -- View this message in context: http://koha.1045719.n5.nabble.com/Problem-on-Staged-MARC-management-tp593520... Sent from the Koha-general mailing list archive at Nabble.com.
you should try not using the truncate switch. El mar., 30 de may. de 2017 12:44 PM, anjoze <joseanjos@gmail.com> escribió:
Olá Pedro,
Yes I've tried other files. Trying with bulkmarcimport.pl I have this message:
/ bib-64150.marcxml <http://koha.1045719.n5.nabble.com/file/n5935220/bib-64150.marcxml> deleting biblios DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign key constraint (`koha_koha`.`aqorders`, CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `koha_koha`.`biblio` (`biblionumber`)) [for Statement "truncate biblio"] at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 150. DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign key constraint (`koha_koha`.`items`, CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `koha_koha`.`biblioitems` (`biblioitemnumber`)) [for Statement "truncate biblioitems"] at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 151. DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign key constraint (`koha_koha`.`accountlines`, CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `koha_koha`.`items` (`itemnumber`)) [for Statement "truncate items"] at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 152. Characteristic MARC flavour: UNIMARC . 1 MARC records done in 0.147950887680054 seconds/
Maybe its a problem with Mysql 5.7? There was a lot of problems with mysql 5.7...
----- Koha version: 16.05.05 - - José Anjos -- View this message in context: http://koha.1045719.n5.nabble.com/Problem-on-Staged-MARC-management-tp593520... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Tomás Cohen Arazi Theke Solutions (https://theke.io <http://theke.io/>) ✆ +54 9351 3513384 GPG: B2F3C15F
My config is like this: https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04_... / sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION/ Tomas, what do you mean with: try not using the truncate switch? Thank you ----- Koha version: 16.05.05 - - José Anjos -- View this message in context: http://koha.1045719.n5.nabble.com/Problem-on-Staged-MARC-management-tp593520... Sent from the Koha-general mailing list archive at Nabble.com.
El mié., 31 may. 2017 a las 5:30, anjoze (<joseanjos@gmail.com>) escribió:
Tomas, what do you mean with: try not using the truncate switch?
By default, bulkmarcimport.pl doesn't delete data. You are getting the truncate errors because you are using the '-d' flag, for sure. The progress indicator problem is certaintly a bug, and it is interesting to know that (not)including the items on import changes the behaviour. You should mention that on your bug report. Regards -- Tomás Cohen Arazi Theke Solutions (https://theke.io <http://theke.io/>) ✆ +54 9351 3513384 GPG: B2F3C15F
Done: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18719 Thank you ----- Koha version: 16.05.05 - - José Anjos -- View this message in context: http://koha.1045719.n5.nabble.com/Problem-on-Staged-MARC-management-tp593520... Sent from the Koha-general mailing list archive at Nabble.com.
participants (3)
-
anjoze -
Pedro Amorim -
Tomas Cohen Arazi