Authority searching fails after too many authorities are deleted

Bug #1993542 reported by Steve Callender
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Evergreen
New
Undecided
Unassigned

Bug Description

Evergreen 3.8+

When an authority is deleted/removed it looks like it leaves behind it's entries in the authority.full_rec table. Too many of these, will cause searching to fail since it still grabs the data from that table but has no matching authority.record_entry to go with it, causing search to load a bunch of entry entries that won't show on the screen. This means that a regular author search may only retrieve a handful of results due to the extra cruft loading behind the scenes.

The authority.full_rec table should have the record field designated as a foreign key to the authority.record_entry(id) table.

tags: added: cat-authority
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.