[Koha-bugs] [Bug 26024] Purge undone of zebraqueue in cleanup_database.pl

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

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.