[Koha] Biblio appears twice (absolute duplicate down to timestamp and biblio and control numbers)

[Elaine Bradtke]

Just an update on how we fixed this.
We followed Paul's advice and flushed the Varnish cache, but this did not
solve the problem.
I downloaded the good record. Deleted it from Koha, uploaded it again -
thereby generating a new biblio number for it.  We still could not get to
the bad record in Koha, it showed up in a search result, but if you clicked
on it,  an error message would appear saying it was not found. We copied
the whole catalogue over to our test site and tried searching there, no
sign of the bad record. Digging around in the SQL proved that this was
correct, the bad record did not exist. Diagnosis - this is an indexing
problem.
We then did an aggressive re-indexing of the zebra and this cleared out the
bad data. No more ghost record.
We had reindexed when the bad record was first discovered, but that time it
didn't work. I'm not sure if it was the fact that the good record's biblio
number was changed or we used different re-indexing commands or both that
finally cleared it up.



On Mon, Jul 14, 2014 at 9:59 PM, Elaine Bradtke <eb at efdss.org> wrote:

> I've downloaded and deleted the good record.  The bad one still appears in
> the search results, but when I click on the link I get Error 500 Internal
> Server Error
>
> Internal Server Error
>
> Guru Meditation:
>
> XID: 1250605665
>
> Varnish cache server
>
>
> On Mon, Jul 14, 2014 at 9:22 PM, Elaine Bradtke <eb at efdss.org> wrote:
>
>> On further investigation, this seems to be a problem with the link
>> parsing. I'm not sure how I can get to the bad record, because Koha keeps
>> bringing up the good record. There appears to be some very small
>> differences, as if the record was saved in mid edit, and saved again, with
>> the same timestamp and numbers.  There is a space and 7c after the biblio
>> number in the bad record.
>>
>>
>> On Mon, Jul 14, 2014 at 8:32 PM, Elaine Bradtke <eb at efdss.org> wrote:
>>
>>> Koha 3.14.06
>>>
>>> Quite a while back we had a problem with duplicate biblios appearing for
>>> newly added catalogue records.
>>> But this time it's only one.  It is an exact duplicate of a record that
>>> had an item added to it (not a new catalogue record).  A search on the
>>> biblio number returns both records, one says no items, the other has four
>>> items attached.  However if you click on the record with no items, it shows
>>> the four items attached, if you click on the "next" button, it shows the
>>> same record.
>>> Looking at the MARC in two separate windows, they are absolutely
>>> identical - time stamp, biblionumber, control number.  This shouldn't be
>>> possible.
>>> I don't know how to fix this, because I can't tell which is the ghost
>>> and which is the original.   I'm tempted to export the record. Delete both
>>> copies, and then re import the record.
>>> We run Koha on a virtual machine, and I hear that there was a reboot
>>> over the weekend and our test site froze. Production only seems to have
>>> suffered this one glitch as far as we can tell. Re-indexing didn't seem to
>>> help. Is there is a particular command we need to use to resolve duplicate
>>> biblios?
>>>
>>> Any ideas?
>>> --
>>> Elaine Bradtke
>>> Data Wrangler
>>> VWML
>>> English Folk Dance and Song Society | http://www.efdss.org
>>> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
>>> Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance
>>> and Song Society in London, England. If you wish to phone me personally,
>>> send an e-mail first. I work off site)
>>>
>>> --------------------------------------------------------------------------
>>> Registered Company No. 297142
>>> Charity Registered in England and Wales No. 305999
>>>
>>> ---------------------------------------------------------------------------
>>> "Writing about music is like dancing about architecture"
>>> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
>>>
>>
>>
>>
>> --
>> Elaine Bradtke
>> Data Wrangler
>> VWML
>> English Folk Dance and Song Society | http://www.efdss.org
>> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
>> Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance
>> and Song Society in London, England. If you wish to phone me personally,
>> send an e-mail first. I work off site)
>> --------------------------------------------------------------------------
>> Registered Company No. 297142
>> Charity Registered in England and Wales No. 305999
>>
>> ---------------------------------------------------------------------------
>> "Writing about music is like dancing about architecture"
>> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
>>
>
>
>
> --
> Elaine Bradtke
> Data Wrangler
> VWML
> English Folk Dance and Song Society | http://www.efdss.org
> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance
> and Song Society in London, England. If you wish to phone me personally,
> send an e-mail first. I work off site)
> --------------------------------------------------------------------------
> Registered Company No. 297142
> Charity Registered in England and Wales No. 305999
> ---------------------------------------------------------------------------
> "Writing about music is like dancing about architecture"
> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
>



-- 
Elaine Bradtke
Data Wrangler
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--------------------------------------------------------------------------
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
---------------------------------------------------------------------------
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)