Delete old logs Crashes php-fpm


(Melvin Suter) #1

Hi there

I’m trying to activate the option “delete old visitor-logs”, but every time I activate and save the option, php-fpm crashes. I have to restart the service, reload the website, restart the service again, deactivate the option, save and restart the service again to get the site up running.

Anyone experienced this problem?
Could it be, because our database is ~100-150G in size?

Thanks & Regards,
Melvin


(Lukas Winkler) #2

Hi,

No PHP software should be able to crash PHP itself, so there should be something wrong.

Can you check the error logs to see why it crashes?


(Melvin Suter) #4

Hi Lukas,

So I finally got to set the option and read the error logs. (I anonymized the IP and Domainname)
Here’s an error I get when I open the settings page:

[Tue Oct 30 18:10:08.249642 2018] [proxy_fcgi:error] [pid 13677:tid 140674506667776] [client 123.456.789.101:54496] AH01071: Got error 'PHP message: Error in Matomo: curl_exec: Could not resolve host: plugins.matomo.org; Der Name oder der Dienst ist nicht bekannt. Hostname requested was: plugins.matomo.org\n', referer: http://PIWIK.DOMAIN.NAME/index.php?module=CoreAdminHome&action=home&idSite=3&period=range&date=previous7
[Tue Oct 30 18:10:08.297813 2018] [proxy_fcgi:error] [pid 13677:tid 140674627462912] [client 123.456.789.101:54494] AH01071: Got error 'PHP message: Error in Matomo: curl_exec: Could not resolve host: plugins.matomo.org; Der Name oder der Dienst ist nicht bekannt. Hostname requested was: plugins.matomo.org\n', referer: http://PIWIK.DOMAIN.NAME/index.php?module=CoreAdminHome&action=home&idSite=3&period=range&date=previous7
[Tue Oct 30 18:10:17.212729 2018] [proxy_fcgi:error] [pid 13679:tid 140674456311552] [client 123.456.789.101:54526] AH01071: Got error 'PHP message: Error in Matomo: curl_exec: Could not resolve host: plugins.matomo.org; Der Name oder der Dienst ist nicht bekannt. Hostname requested was: plugins.matomo.org\n', referer: https://PIWIK.DOMAIN.NAME/index.php?module=CoreAdminHome&action=home&idSite=3&period=range&date=previous7
[Tue Oct 30 18:10:17.273250 2018] [proxy_fcgi:error] [pid 27234:tid 140674661033728] [client 123.456.789.101:54527] AH01071: Got error 'PHP message: Error in Matomo: curl_exec: Could not resolve host: plugins.matomo.org; Der Name oder der Dienst ist nicht bekannt. Hostname requested was: plugins.matomo.org\n', referer: https://PIWIK.DOMAIN.NAME/index.php?module=CoreAdminHome&action=home&idSite=3&period=range&date=previous7

And here’s what I get when i try to load the site after enabling the delete old logs option:

[Tue Oct 30 18:11:19.384227 2018] [proxy_fcgi:error] [pid 13679:tid 140674405955328] (70007)The timeout specified has expired: [client 123.456.789.101:54525] AH01075: Error dispatching request to :, referer: https://PIWIK.DOMAIN.NAME/index.php?module=PrivacyManager&action=privacySettings&idSite=3&period=range&date=previous7
[Tue Oct 30 18:11:22.595625 2018] [proxy_fcgi:error] [pid 13679:tid 140674540238592] (70007)The timeout specified has expired: [client 123.456.789.101:54517] AH01075: Error dispatching request to :, referer: https://PIWIK.DOMAIN.NAME/index.php?module=PrivacyManager&action=privacySettings&idSite=3&period=range&date=previous7
[Tue Oct 30 18:11:26.933239 2018] [proxy_fcgi:error] [pid 13778:tid 140674661033728] (70007)The timeout specified has expired: [client 123.456.789.101:54538] AH01075: Error dispatching request to :, referer: https://PIWIK.DOMAIN.NAME/index.php?module=CoreAdminHome&action=home&idSite=3&period=range&date=previous7

My browser displays “service temporarily unavailable”.

Thanks, Melvin