Error retrieving biblio in rebuild_zebra.pl line 680
Yesterday I upgraded from koha 3.22.08 to 18.11 but can't run koha-rebuild-zebra -f -v -b koha on Ubuntu 16.04 The error I get is exactly the same with bug 18927 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18927 Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/koha_library/biblios Zebra authorities directory = /var/lib/koha/koha_library/authorities Koha directory = /usr/share/koha/intranet/cgi-bin Lockfile = /var/lock/koha/koha_library/rebuild/rebuild..LCK BIBLIONUMBER in : 999$c BIBLIOITEMNUMBER in : 999$d ================================ skipping authorities ==================== exporting biblio ==================== 1error retrieving biblio 2 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 680. .error retrieving biblio 3 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 680. ... Records exported: 0 ==================== REINDEXING zebra ==================== ==================== CLEANING ==================== When I check the file at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 680, the code already has the fix described at https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18927 On further examination, I noticed that the issue is also related to bug 17196 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17196 After the upgrade, it appears the table biblioitems no longer has the marcxml field. Also, the new table biblio_metadata exists but is empty. The other new table deletedbiblio_metadata however has data in it. Indexing with koha-rebuild-zebra -f -v -a koha for authorities works fine with no problems. It appears the update process didn't migrate the data from biblioitems.marcxml to biblio_metadata as should be the case and this is most likely why zebra is not able to index. My problem is now how to solve this issue, thank you. -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
Hi The best thing to do is restore from a backup (you did this upgrade on a test server eh? You've jumped about 3 years worth of upgrades) Then run the upgrade again, paying particular attention to any errors that occur. Because there may well have been other ones too. You will want to catch all of them to make sure you fix them all, before you start using it in production. Chris On 30 January 2019 7:59:12 PM NZDT, otuoma <otuomathegreat@yahoo.com> wrote:
Yesterday I upgraded from koha 3.22.08 to 18.11 but can't run koha-rebuild-zebra -f -v -b koha on Ubuntu 16.04
The error I get is exactly the same with bug 18927 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18927
Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/koha_library/biblios Zebra authorities directory = /var/lib/koha/koha_library/authorities Koha directory = /usr/share/koha/intranet/cgi-bin Lockfile = /var/lock/koha/koha_library/rebuild/rebuild..LCK BIBLIONUMBER in : 999$c BIBLIOITEMNUMBER in : 999$d ================================ skipping authorities ==================== exporting biblio ==================== 1error retrieving biblio 2 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 680. .error retrieving biblio 3 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 680.
...
Records exported: 0 ==================== REINDEXING zebra ==================== ==================== CLEANING ====================
When I check the file at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 680, the code already has the fix described at https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18927
On further examination, I noticed that the issue is also related to bug 17196 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17196
After the upgrade, it appears the table biblioitems no longer has the marcxml field. Also, the new table biblio_metadata exists but is empty. The other new table deletedbiblio_metadata however has data in it.
Indexing with koha-rebuild-zebra -f -v -a koha for authorities works fine with no problems.
It appears the update process didn't migrate the data from biblioitems.marcxml to biblio_metadata as should be the case and this is most likely why zebra is not able to index.
My problem is now how to solve this issue, thank you.
-- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Sent from my Android device with K-9 Mail. Please excuse my brevity.
I think I had a similar problem some time ago, If I am not wrong, please check the koha marc framework, it could be broken <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Libre de virus. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> El mié., 30 ene. 2019 a las 8:11, Chris Cormack (<chrisc@catalyst.net.nz>) escribió:
Hi
The best thing to do is restore from a backup (you did this upgrade on a test server eh? You've jumped about 3 years worth of upgrades)
Then run the upgrade again, paying particular attention to any errors that occur. Because there may well have been other ones too. You will want to catch all of them to make sure you fix them all, before you start using it in production.
Chris
On 30 January 2019 7:59:12 PM NZDT, otuoma <otuomathegreat@yahoo.com> wrote:
Yesterday I upgraded from koha 3.22.08 to 18.11 but can't run koha-rebuild-zebra -f -v -b koha on Ubuntu 16.04
The error I get is exactly the same with bug 18927 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18927
Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/koha_library/biblios Zebra authorities directory = /var/lib/koha/koha_library/authorities Koha directory = /usr/share/koha/intranet/cgi-bin Lockfile = /var/lock/koha/koha_library/rebuild/rebuild..LCK BIBLIONUMBER in : 999$c BIBLIOITEMNUMBER in : 999$d ================================ skipping authorities ==================== exporting biblio ==================== 1error retrieving biblio 2 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 680. .error retrieving biblio 3 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 680.
...
Records exported: 0 ==================== REINDEXING zebra ==================== ==================== CLEANING ====================
When I check the file at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 680, the code already has the fix described at https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18927
On further examination, I noticed that the issue is also related to bug 17196 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17196
After the upgrade, it appears the table biblioitems no longer has the marcxml field. Also, the new table biblio_metadata exists but is empty. The other new table deletedbiblio_metadata however has data in it.
Indexing with koha-rebuild-zebra -f -v -a koha for authorities works fine with no problems.
It appears the update process didn't migrate the data from biblioitems.marcxml to biblio_metadata as should be the case and this is most likely why zebra is not able to index.
My problem is now how to solve this issue, thank you.
-- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Sent from my Android device with K-9 Mail. Please excuse my brevity. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- *Hugo Agud - Orex Digital * *www.orex.es <http://www.orex.es>* <http://www.orex.es/> [image: www.orex.es/koha] <http://www.orex.es/koha> [image: www.orex.es/vufind] <http://www.orex.es/vufind> Director Avda Josep Tarradelles, 134 (Centro de Negocios Infanta) 08029 - Barcelona - Tel: 933 856 138 hagud@orex.es · http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.
The database upgrade was done by the web installer and I didn't see any errors during that time. I am not sure how else I can view these errors? The new biblio_metadata table has only 6 fields. I can easily get data for all the fields from either biblio or biblioitems except for the marcxml field. I could get data for marcxml field from my backups as you have suggested. However, I think that this would require me to be accessing two databases concurrently. This is possible but may be more difficult for me to set up as I would be using PHP (I know almost nothing about perl) However, if I knew how to generate marcxml from the existing data in biblio and biblioitems, then I could almost easily do that. Let me know if you have any ideas, thanks. -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
I wrote a small Codeigniter class that I used to copy the data from the old databases and saved it to biblio_metadata and indexed without a problem thereafter.I have attached the PHP code in a file below.Thank you all. Migrate.php <http://koha.1045719.n5.nabble.com/file/t147596/Migrate.php> -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
The attached file does not seem to be useful, I have instead placed it on github here https://gist.github.com/otuoma/177ab5f407d18cb06c270ee7b34289c5 -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
participants (3)
-
Chris Cormack -
Hugo Agud -
otuoma