Re: [Koha] Zebra troubles after upgrading from 2.2
On 12 July 2012 20:18, Tom Francart <francart@gmail.com> wrote:
On Thu, Jul 12, 2012 at 10:12 AM, Chris Cormack <chris@bigballofwax.co.nz> wrote:
On 12 July 2012 19:46, Tom Francart <francart@gmail.com> wrote:
On Thu, Jul 12, 2012 at 9:27 AM, Chris Cormack <chris@bigballofwax.co.nz> wrote:
On 12 July 2012 19:16, Tom Francart <francart@gmail.com> wrote:
Dear all,
We've just upgraded from Koha 2.2 to Koha 3.8 and are having troubles searching with zebra.
Hi Chris,
Here's the output with the vv switch.
Here's the salient bit log] Records: 0 i/u/d 0/0/0 No items inserted, updated or deleted. So zebra is being given nothing it can index, it looks to me like your upgrade didn't work well, and the records are not complete. Do you have mysql access, can you do select marc,marcxml from biblioitems where biblionumber = 669 And take a look at it, i suspect it is missing the 999 field, if not a lot more. Chris
On Thu, Jul 12, 2012 at 11:45 AM, Chris Cormack <chris@bigballofwax.co.nz> wrote:
On 12 July 2012 20:18, Tom Francart <francart@gmail.com> wrote:
On Thu, Jul 12, 2012 at 10:12 AM, Chris Cormack <chris@bigballofwax.co.nz> wrote:
On 12 July 2012 19:46, Tom Francart <francart@gmail.com> wrote:
On Thu, Jul 12, 2012 at 9:27 AM, Chris Cormack <chris@bigballofwax.co.nz> wrote:
On 12 July 2012 19:16, Tom Francart <francart@gmail.com> wrote:
Dear all,
We've just upgraded from Koha 2.2 to Koha 3.8 and are having troubles searching with zebra.
Hi Chris,
Here's the output with the vv switch.
Here's the salient bit
log] Records: 0 i/u/d 0/0/0
No items inserted, updated or deleted. So zebra is being given nothing it can index, it looks to me like your upgrade didn't work well, and the records are not complete.
Do you have mysql access, can you do select marc,marcxml from biblioitems where biblionumber = 669
And take a look at it, i suspect it is missing the 999 field, if not a lot more.
Chris
Hi Chris, First of all, thank you very much for taking the time to help us. That query returns no records. In table biblioitems, biblionumber goes only up to 667. Most records have the marcxml field set, but I haven't found any that contain the 999 field. Additionally, records 663-667 have an empty marcxml field. What would be the best way to fix it? I still have the original Koha 2 database. Removing biblioitems 663-667 and re-addng them to the library wouldn't be a problem either. best regards, Tom
Hi Chris,
First of all, thank you very much for taking the time to help us.
That query returns no records. In table biblioitems, biblionumber goes only up to 667.
Most records have the marcxml field set, but I haven't found any that contain the 999 field. Additionally, records 663-667 have an empty marcxml field.
What would be the best way to fix it? I still have the original Koha 2 database. Removing biblioitems 663-667 and re-addng them to the library wouldn't be a problem either.
Hmm it doesn't appear to be indexing anything, not just missing those 4. You could try the rebuild zebra with -k to keep the files, then you could take a look at them. I'd try -k -v -r -b -x Chris
On Thu, Jul 12, 2012 at 12:50 PM, Chris Cormack <chris@bigballofwax.co.nz> wrote:
Hi Chris,
First of all, thank you very much for taking the time to help us.
That query returns no records. In table biblioitems, biblionumber goes only up to 667.
Most records have the marcxml field set, but I haven't found any that contain the 999 field. Additionally, records 663-667 have an empty marcxml field.
What would be the best way to fix it? I still have the original Koha 2 database. Removing biblioitems 663-667 and re-addng them to the library wouldn't be a problem either.
Hmm it doesn't appear to be indexing anything, not just missing those 4.
You could try the rebuild zebra with -k to keep the files, then you could take a look at them.
I'd try -k -v -r -b -x
Chris
Aha, new error message! 13:02:13-12/07 zebraidx(22559) [warn] /usr/local/koha3/etc/zebradb/biblios/etc/dom-config.xml: stylesheet biblio-zebra-indexdefs.xsl not found in path /usr/local/koha3/etc/zebradb/biblios/etc:/usr/local/koha3/etc/zebradb/etc:/usr/local/koha3/etc/zebradb/marc_defs/marc21/biblios:/usr/local/koha3/etc/zebradb/lang_defs/en:/usr/local/koha3/etc/zebradb/xsl biblio-zebra-indexdefs.xsl was indeed missing from my entire koha installation. I downloaded biblio-koha-indexdefs.xml from git, generated biblio-zebra-indexdefs.xsl from it, and now get the following error message: ... 13:15:40-12/07 zebraidx(22788) d056e7b5 [log] dir /tmp/AIIkP2_AHS/biblio 13:15:40-12/07 zebraidx(22788) d056e7b5 [loglevel] returning NO log bit for 'extract' 13:15:40-12/07 zebraidx(22788) d056e7b5 [loglevel] returning NO log bit for 'indexdetails' 13:15:40-12/07 zebraidx(22788) d056e7b5 [log] /usr/local/koha3/etc/zebradb/biblios/etc/dom-config.xml dom filter: loading config file /usr/local/koha3/etc/zebradb/biblios/etc/dom-config.xml 13:15:40-12/07 zebraidx(22788) d056e7b5 [log] skip dom./usr/local/koha3/etc/zebradb/biblios/etc/dom-config.xml /tmp/AIIkP2_AHS/biblio/exported_records 0 13:15:40-12/07 zebraidx(22788) d056e7b5 [log] skip dom./usr/local/koha3/etc/zebradb/biblios/etc/dom-config.xml /tmp/AIIkP2_AHS/biblio/exported_records 4100 .... many times the same ... 13:15:40-12/07 zebraidx(22788) d056e7b5 [log] skip dom./usr/local/koha3/etc/zebradb/biblios/etc/dom-config.xml /tmp/AIIkP2_AHS/biblio/exported_records 4100 13:15:40-12/07 zebraidx(22788) d056e7b5 [log] skip dom./usr/local/koha3/etc/zebradb/biblios/etc/dom-config.xml /tmp/AIIkP2_AHS/biblio/exported_records 8196 13:15:40-12/07 zebraidx(22788) d056e7b5 [log] skip dom./usr/local/koha3/etc/zebradb/biblios/etc/dom-config.xml /tmp/AIIkP2_AHS/biblio/exported_records 8196 13:15:40-12/07 zebraidx(22788) d056e7b5 [log] skip dom./usr/local/koha3/etc/zebradb/biblios/etc/dom-config.xml /tmp/AIIkP2_AHS/biblio/exported_records 8196 13:15:40-12/07 zebraidx(22788) d056e7b5 [log] skip dom./usr/local/koha3/etc/zebradb/biblios/etc/dom-config.xml /tmp/AIIkP2_AHS/biblio/exported_records 8196 Entity: line 133: parser error : XML declaration allowed only at the start of the document <?xml version="1.0" encoding="UTF-8"?> ^ 13:15:40-12/07 zebraidx(22788) d056e7b5 [warn] extract error: generic There are no XML files in my koha installation that have <?xml version="1.0" encoding="UTF-8"?> beyond the first line though. best regards, Tom
Dear Chris, After two days of zebra-fun, I gave up. I finally solved the problem by exporting the Marc records in my old Koha setup, installing the new Koha (no upgrade) and importing all records again. Everything seems to be working fine now. I guess we'll never now what exactly the problem was. Thanks for your help anyway! best regards, Tom On Thu, Jul 12, 2012 at 1:27 PM, Tom Francart <francart@gmail.com> wrote:
On Thu, Jul 12, 2012 at 12:50 PM, Chris Cormack <chris@bigballofwax.co.nz> wrote:
Hi Chris,
First of all, thank you very much for taking the time to help us.
That query returns no records. In table biblioitems, biblionumber goes only up to 667.
Most records have the marcxml field set, but I haven't found any that contain the 999 field. Additionally, records 663-667 have an empty marcxml field.
What would be the best way to fix it? I still have the original Koha 2 database. Removing biblioitems 663-667 and re-addng them to the library wouldn't be a problem either.
Hmm it doesn't appear to be indexing anything, not just missing those 4.
You could try the rebuild zebra with -k to keep the files, then you could take a look at them.
I'd try -k -v -r -b -x
Chris
participants (2)
-
Chris Cormack -
Tom Francart