We had been running Piwik v1.12 on a high volume intranet site for several months without problem, ~10k visits per day.
We recently upgraded to v2.0.3 and are now finding that Piwik is crashing 3 or 4 times a day.
Symptoms seem to be that occasionally, one of the CGI / FastCGI processes will lock up (continually 50% cpu) and cause multiple duplicate FastCGI processes to spawn. Within about 20 minutes there will be hundreds of CGI/FastCGI processes listed in task manager, and the IIS Application pool will finally crash giving error 500 – service unavailable.
We have set ’error_reporting=E_ALL’ in php.ini, however the only errors logged seem to be after the hundreds of processes are spawned.
Windows Event log displays numerous Application errors during this time period but don’t indicate what the cause might be:
[size=small]Faulting application name: php-cgi.exe, version: 188.8.131.52, time stamp: 0x5165bd29
Faulting module name: KERNEL32.DLL, version: 6.2.9200.16627, time stamp: 0x51a7dbea
Exception code: 0xc0000005
Fault offset: 0x00025f68
Faulting process id: 0x19ac
Faulting application start time: 0x01cf3204c99a6e26
Faulting application path: C:\Program Files (x86)\PHP\v5.4\php-cgi.exe
Faulting module path: C:\Windows\SYSTEM32\KERNEL32.DLL
Report Id: 07554832-9df8-11e3-9403-00155dbf990e
Faulting package full name:
Faulting package-relative application ID:[/size]
MySQL logs don’t show anything, and all tables pass a quick health check.
Piwik server is:
Windows Server 2012
8GB, Xeon E5-2650@2GHz
Any advise you can give to track down the cause of the problem would br greatly appreciated.