Biblio appears twice (absolute duplicate down to timestamp and biblio and control numbers)
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)
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@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)
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@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@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)
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@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@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@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)
participants (1)
-
Elaine Bradtke