Bug 34061

Summary: Koha Catalog Freezes while being imported
Product: Koha Reporter: National Library of Jamaica <kohasupport>
Component: ToolsAssignee: Bugs List <koha-bugs>
Status: CLOSED WONTFIX QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low    
Version: 21.05   
Hardware: PC   
OS: Linux   
GIT URL: Initiative type: ---
Sponsorship status: --- Comma delimited list of Sponsors:
Crowdfunding goal: 0 Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

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.