[Koha] KOHA Unimarc 606 field not connecting to subject authority

[mj]

Hi Marcel, list,

On 08/29/2017 04:59 PM, Marcel de Rooy wrote:
> Probably a Zebra/UNIMARC configuration issue. (The harder ones..)
Yes, we agree on that... :-)

Would hiring someone to convert everything to marc21 make us more 
'mainstream' and 'normal'..? It seems marc21 os more widely used with 
koha, right?

And of we hire someone, we would also like him/her to look at some other 
issues, like below...:

> Did you already try a complete rebuild btw ?
Well, just tried it, and this made us even more worried:

> root at koha:~# koha-rebuild-zebra -f -v instancename
> Zebra configuration information
> ================================
> Zebra biblio directory      = /var/lib/koha/instancename/biblios
> Zebra authorities directory = /var/lib/koha/instancename/authorities
> Koha directory              = /usr/share/koha/intranet/cgi-bin
> Lockfile                    = /var/lock/zebra_instancename/rebuild/rebuild..LCK
> BIBLIONUMBER in :     090$9
> BIBLIOITEMNUMBER in : 090$a
> ================================
> skipping authorities
> ====================
> exporting biblio
> ====================
> 1error retrieving biblio 1 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683, <DATA> line 751.
> .error retrieving biblio 2 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683, <DATA> line 751.
> .error retrieving biblio 3 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683, <DATA> line 751.
> .error retrieving biblio 4 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683, <DATA> line 751.
> .error retrieving biblio 5 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683, <DATA> line 751.
> ..error retrieving biblio 7 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683.
> .error retrieving biblio 8 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683.
> .error retrieving biblio 9 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683.
> .error retrieving biblio 10 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683.
> .error retrieving biblio 11 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683.
> .error retrieving biblio 12 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683.
> .error retrieving biblio 13 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683.
> .error retrieving biblio 14 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683.
> .error retrieving biblio 15 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683.
> .error retrieving biblio 16 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683.
etc
Not looking so good, eh? :-(

> Contact another UNIMARC user and compare zebra settings ? Or compare settings with the situation before the last update?
Thing is, this problem may already have been present for some time, 
before the very last update.

> Check your zebra logs, zebra-error zebra-output. Maybe you must enable some flags in koha-conf to get more verbose output. Follow the queries and look at the fields used in these 'unreadable' @attr 1=xx form etc. Verify that these fields are in the corresponding bib1.att under etc/koha/zebradb ..

Additionally we also suffer from 8 duplicate IDs due to the mysql 
auto_increment bug.

Thanks again, we will try contacting someone at liblibre or catalyst to 
help us with this, as we fear our system is in need of some serious care.

MJ