[Koha-bugs] [Bug 31629] Cleanup database needs a flag for removing elastic index entries from background_jobs table

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31629

--- Comment #10 from Frédéric Demians <frederic at tamil.fr> ---
Created attachment 142502
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=142502&action=edit
Bug 31629: Add jobsqueue options to cleanup_database

This patch adds an jobsqueue option to cleanup_database.pl to allow
for purging background jobs queue

There is also a fix for --elasticqueue default value

To test:

1. On a DB with a populated background_jobs table, identify in this
   table
   entries older than X days.
2. perl misc/cronjobs/cleanup_database.pl
   Note elasticqueue entry shows in help
3. perl misc/cronjobs/cleanup_database.pl --elasticqueue -v
   Note this message:
   Elastic queue (background jobs) purge triggered for 30 days
4. perl misc/cronjobs/cleanup_database.pl --jobsqueue -v
   Note this message:
   Background jobs queue purge triggered for 30 days.
5. perl misc/cronjobs/cleanup_database.pl --jobsqueue 1 -v
   Background jobs queue purge triggered for 1 day.
6. perl misc/cronjobs/cleanup_database.pl --jobsqueue 1 -v --confirm
   Note that number of entries deleted is reporte
7. In Koha > Admin > Background jobs, see the purge queue.

-- 
You are receiving this mail because:
You are watching all bug changes.