Script to delete records containing error record data
Script to delete records containing error record data
- Roman Chernetskyi
Owned by Roman Chernetskyi
Mar 24, 2025
The following script deletes records that are contained in error_records_lb table:
SET SEARCH_PATH = '{tenantId}_mod_source_record_storage';
BEGIN;
DELETE FROM records_lb
WHERE id IN (SELECT id FROM error_records_lb);
DELETE FROM marc_indexers
WHERE marc_id IN (SELECT id FROM error_records_lb);
DELETE FROM marc_records_tracking
WHERE marc_id IN (SELECT id FROM error_records_lb);
DELETE FROM error_records_lb;
COMMIT;
, multiple selections available,
Related content
Script to hard delete OLD records
Script to hard delete OLD records
More like this
Script to update records with invalid 005 field
Script to update records with invalid 005 field
More like this
Bulk delete using CQL query
Bulk delete using CQL query
More like this
Script for removing invalid records from srs before starting marc-bib migration process
Script for removing invalid records from srs before starting marc-bib migration process
More like this
Clean up records with inconsistent matched id values
Clean up records with inconsistent matched id values
More like this
Script to recover MARC_BIB records without ACTUAL or DELETED version
Script to recover MARC_BIB records without ACTUAL or DELETED version
More like this