Reingest bib needs to deal with missing metabib.record_attr entries
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Fix Released
|
Medium
|
Unassigned |
Bug Description
Evergreen master
This is for TPAC searches conducted in both public catalog and staff client.
It seems possible that bib records cannot be found even after updating them with more appropriate information or undeleting them. Running the following SQL identified several unfindable bibs in our system:
SELECT bre.id
FROM biblio.record_entry bre
LEFT JOIN metabib.record_attr mra ON (bre.id = mra.id)
WHERE NOT deleted AND active AND attrs is null;
It turns out we needed to add an entry back to metabib.record_attr with the ID number of the biblio.record_entry that was broken and then reingest the bibs to repopulate the values.
Suggestion from IRC (http://
Changed in evergreen: | |
status: | New → Confirmed |
importance: | Undecided → Medium |
tags: | added: reingest |
Changed in evergreen: | |
assignee: | Rogan Hamby (rogan-hamby) → Jeff Godin (jgodin) |
Changed in evergreen: | |
assignee: | nobody → Jeff Godin (jgodin) |
Changed in evergreen: | |
status: | Fix Committed → Fix Released |
assignee: | Jeff Godin (jgodin) → nobody |
Observed first occurrence of this issue after upgrade from 2.2.2 to 2.7.2. To fix an undeleted bib the following steps should work after upgrading beyond 2.6:
• prior to upgraded from 2.2.2 table needing blank entry was metabib.record_attr
• after 2.6?? metabib.record_attr is a view and table needing a blank/dummy entry is metabib. record_ attr_vector_ list
For bib with id of 19928246 here is a sample of SQL to make an item searchable again:
begin;
insert into metabib. record_ attr_vector_ list (source, vlist) values (19928246, '{631}'); --any value will do for the vlist entry as long as it is a valid format!
UPDATE config. internal_ flag SET enabled = TRUE WHERE name = 'ingest. reingest. force_on_ same_marc' ; --force reingest
UPDATE biblio.record_entry SET id = id WHERE id = 19928246; --force reingest
select * from metabib. record_ attr_vector_ list where source = 19928246; -- verify output from the transaction before committing!
UPDATE config. internal_ flag SET enabled = FALSE WHERE name = 'ingest. reingest. force_on_ same_marc' ; --turn off forced reingest
commit; --commit or rollback!!!