Bug 34061 - Koha Catalog Freezes while being imported
Summary: Koha Catalog Freezes while being imported
Status: RESOLVED WONTFIX
Alias: None
Product: Koha
Classification: Unclassified
Component: Tools (show other bugs)
Version: 21.05
Hardware: PC Linux
: P5 - low normal (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-06-19 18:13 UTC by National Library of Jamaica
Modified: 2023-06-26 06:05 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description National Library of Jamaica 2023-06-19 18:13:38 UTC
After staging a .mrc file and attempting to import into the catalog, the process freezes. When data is examined, there is no problem. I cleaned and deleted the batch file. I did this multiple times not knowing that data was somehow stored in the Database after the clean and deletion of the batch file.

Now I am attempting to upload the DB by breaking it up. Prior to uploading anymore records, the 'cataloguing' search shows that data is in the database but none in the reservoir. Most of it is duplicated. (I suppose from previous trial uploads). I tried the 'cleanup_database. pl' cron job to flush the DB and that did not work. 

Please advise. Thank you.
Comment 1 Katrin Fischer 2023-06-26 06:03:44 UTC
You probably missed to undo the import before you cleaned the batch. These are separate steps, suggesting the import worked in part, but maybe didn't finish. You could try a batch delete records if you wanted to clean up, maybe using the datecreated or similar to identify the records.
Comment 2 Katrin Fischer 2023-06-26 06:05:18 UTC
21.05 is quite old and no longer maintained.

A big import might take a while and the progress bar will jump from 0 to 100 (known bug). Maybe it didn't freeze, but just wasn't finished yet.