https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42491 --- Comment #1 from David Cook <dcook@prosentient.com.au> --- Created attachment 198326 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=198326&action=edit Bug 42491: Change default daily cleanup to only delete old sessions This change makes the daily cronjob included in Debian packages only delete sessions that are older than 1 day. This prevents sessions from being disrupted if they are in use at the same time the daily cronjob is run. Test plan: 0. Apply the patch 1. Review the debian/koha-common.cron.daily file 2. Run the following SQL to check if you have any old sessions SELECT SUBSTRING_INDEX(SUBSTRING(a_session, LOCATE('_SESSION_ATIME:', a_session) + 15),'\n',1) AS lasttime FROM sessions HAVING lasttime < (UNIX_TIMESTAMP() - 86400); 3. If you do, run the following by hand: sudo koha-foreach --chdir --enabled \ /usr/share/koha/bin/cronjobs/cleanup_database.pl \ --confirm --sessions --sessdays 1 4. Re-run the SQL and note it now returns nothing but if you check "select * from sessions", you wil see that you still have (newer) sessions there. -- You are receiving this mail because: You are watching all bug changes.