[Koha-bugs] [Bug 26024] Purge undone of zebraqueue in cleanup_database.pl
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Mon Jul 20 12:00:44 CEST 2020
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26024
--- Comment #1 from Fridolin SOMERS <fridolin.somers at biblibre.com> ---
Created attachment 107083
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=107083&action=edit
Bug 26024: Purge undone of zebraqueue in cleanup_database.pl
Purge script misc/cronjobs/cleanup_database.pl with --zebraqueue DAYS will
delete entries from zebraqueue table with done=1
We now start to use Elasticsearch only so entries of zebraqueue with done=0
stay in database.
I propose we purge all entries in cleanup_database.pl.
Even with zebra, if indexing does not occur after several days (30 by default),
there is a problem and one need a full rebuild.
Test plan:
1) Use an database with entries in zebraqueue older than 7 days
2) Stop zebra indexing
3) Count entries older than 7 days :
mysql > select count(*),done from zebraqueue where time < date_sub(curdate(),
INTERVAL 7 DAY) group by done;
4) Simulate done=0 :
mysql > update zebraqueue set done=0;
5) Run misc/cronjobs/cleanup_database.pl --zebraqueue 7 -v
6) Re run 3) you have no results
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list