I'm new to Koha and am having issues with web timeouts when using "Batch record deletion", either when uploading a list, or when carrying out the actual deletion of records in a loaded list. When I realized 10K records might be too many, I decreased to less than 5K. In one test, about 1/3 of my records were deleted by the time the timeout occurred. I'm not positive if the delete job is still running in the background, despite the web timeout. I'd like to ask, couldn't the batch deletion be performed by FTP'ing my list to the server, and then running batch_delete_records.pl with parameters in order to circumvent the web interface entirely? Maybe at some point, I'll have time to figure this out on my own. Until then, if anyone has figured this out, please let me know. Certainly, I could perform this operation with SQL, but I'm not yet fluent or familiar enough with Koha to know how to make sure I do this correctly for items, bibs, holds. Thanks for your time, Tasha R. Bales
Hello Tasha, The entire request will be processed on the server anyway, but you won't get summary screen. I would recommend you to raise the timeout value of the webserver. If you don't want to, or cannot, you can still write a script that does what the tools script does, but that's not trivial. Regards, Jonathan Le ven. 12 févr. 2021 à 16:34, Bales (US), Tasha R <tasha.r.bales@boeing.com> a écrit :
I'm new to Koha and am having issues with web timeouts when using "Batch record deletion", either when uploading a list, or when carrying out the actual deletion of records in a loaded list. When I realized 10K records might be too many, I decreased to less than 5K. In one test, about 1/3 of my records were deleted by the time the timeout occurred. I'm not positive if the delete job is still running in the background, despite the web timeout.
I'd like to ask, couldn't the batch deletion be performed by FTP'ing my list to the server, and then running batch_delete_records.pl with parameters in order to circumvent the web interface entirely? Maybe at some point, I'll have time to figure this out on my own. Until then, if anyone has figured this out, please let me know.
Certainly, I could perform this operation with SQL, but I'm not yet fluent or familiar enough with Koha to know how to make sure I do this correctly for items, bibs, holds.
Thanks for your time,
Tasha R. Bales
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
I should have added that the following bug report will put the deletion in a background task and will allow large deletion: Bug 26080 - Use the task queue for the batch delete records tool https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26080 Le lun. 15 févr. 2021 à 16:32, Jonathan Druart <jonathan.druart@bugs.koha-community.org> a écrit :
Hello Tasha,
The entire request will be processed on the server anyway, but you won't get summary screen.
I would recommend you to raise the timeout value of the webserver.
If you don't want to, or cannot, you can still write a script that does what the tools script does, but that's not trivial.
Regards, Jonathan
Le ven. 12 févr. 2021 à 16:34, Bales (US), Tasha R <tasha.r.bales@boeing.com> a écrit :
I'm new to Koha and am having issues with web timeouts when using "Batch record deletion", either when uploading a list, or when carrying out the actual deletion of records in a loaded list. When I realized 10K records might be too many, I decreased to less than 5K. In one test, about 1/3 of my records were deleted by the time the timeout occurred. I'm not positive if the delete job is still running in the background, despite the web timeout.
I'd like to ask, couldn't the batch deletion be performed by FTP'ing my list to the server, and then running batch_delete_records.pl with parameters in order to circumvent the web interface entirely? Maybe at some point, I'll have time to figure this out on my own. Until then, if anyone has figured this out, please let me know.
Certainly, I could perform this operation with SQL, but I'm not yet fluent or familiar enough with Koha to know how to make sure I do this correctly for items, bibs, holds.
Thanks for your time,
Tasha R. Bales
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Bales (US), Tasha R -
Jonathan Druart