Details
-
Bug
-
Resolution: Fixed
-
None
-
Critical
-
Empty show more show less
Description
problem
By default the garbage collector runs every 15 minutes triggered by each request to translate5. (This can be changed to a cron job based trigger by calling https://$
{URL}/editor/cron/periodical via wget in cron).
In the request based way the last GC call is saved with a timetamp to the Zf_memcache table.
Here comes the problem: On memcache creation the MySQL now() function was used (with the MySQL configured timezone) and for deletion of memcache entries the PHP now() function was used with the PHP timezone.
Since the MySQL timezone was set to GMT and the PHP ones to MEZ, the memcache entry was directly deleted after creation since it was two hours old.
Solution
- Use at both code places the same technique
- Set the timezones of mysql accordingly to the PHP ones (for example https://www.sitepoint.com/synchronize-php-mysql-timezone-configuration/)
- Ensure that both timezones are synchronised by a fix in the install-and-update script