Error with high traffic site and 2.0

Support & Bugs
21

ok yes this is hard to diagnose, others had issues using 5.2.x php and by going to 5.3.3 fixed things i know yours is close but trying 5.3.3 could that be a quick painless fix here?

22

Never heard of PHP 5.2.x issues with Piwik – so this will my next step.

I think we will update to PHP 5.5.7.

23

Our Apache log shows two exception faults for each archive.php attempt.

What errors exactly are you getting?

24

Good news, we’ve fixed this bug: https://github.com/piwik/piwik/commit/23a1c9d680a2409c182977cc02ebf1c00d414cd0

can you try apply the patch and confirm whether all issues are fixed during archiving and this error does not show anymore?

25

i have added this patch and i can confirm, all works. Website, that showed error is now archived properly and data is shown.

Thanks

26

Thanks for the patch!

Archiving works again, but still exits with the 2 errors I mentioned.

Piwik’s archive.log:

[size=x-small]INFO [2014-01-09 13:31:05] [972cd] SUMMARY OF ERRORS
INFO [2014-01-09 13:31:05] [972cd] Error: Got invalid response from API request: mysite.de. Response was 'curl_exec: Empty reply from server’
INFO [2014-01-09 13:31:05] [972cd] Error: Got invalid response from API request: mysite.de. Response was 'curl_exec: Empty reply from server’
INFO [2014-01-09 13:31:05] [972cd] 2 total errors during this script execution, please investigate and try and fix these errors
INFO [2014-01-09 13:31:05] [972cd] ERROR: 2 total errors during this script execution, please investigate and try and fix these errors. First error was: Got invalid response from API request: mysite.de. Response was ‘curl_exec: Empty reply from server’[/size]

Apache Log:
[size=x-small]
[Thu Jan 09 13:30:41 2014] [notice] child pid 4373 exit signal Segmentation fault (11)
[Thu Jan 09 13:30:56 2014] [notice] child pid 4384 exit signal Segmentation fault (11)
[/size]

27

Me too, getting errors:

$ sudo -u www-data /usr/bin/php5 /mydir/piwik/misc/cron/archive.php --url=http://it.mysite.org/piwik/ --force-all-websites --force-all-periods
[sudo] password for user:
INFO [2014-01-09 12:56:18] [7e9a5] ---------------------------
INFO [2014-01-09 12:56:18] [7e9a5] INIT
INFO [2014-01-09 12:56:18] [7e9a5] Querying Piwik API at: http://it.mysite.org/piwik/index.php
INFO [2014-01-09 12:56:18] [7e9a5] Running Piwik 2.0.2 as Super User: user
INFO [2014-01-09 12:56:18] [7e9a5] ---------------------------
INFO [2014-01-09 12:56:18] [7e9a5] NOTES
INFO [2014-01-09 12:56:18] [7e9a5] - Reports for today will be processed at most every 82800 seconds. You can change this value in Piwik UI > Settings > General Settings.
INFO [2014-01-09 12:56:18] [7e9a5] - Reports for the current week/month/year will be refreshed at most every 3600 seconds.
INFO [2014-01-09 12:56:18] [7e9a5] - Archiving was last executed without error 19 giorni 10 ore ago
INFO [2014-01-09 12:56:18] [7e9a5] - Will process all 14 websites
INFO [2014-01-09 12:56:18] [7e9a5] ---------------------------
INFO [2014-01-09 12:56:18] [7e9a5] START
INFO [2014-01-09 14:21:00] [7e9a5] ERROR: Got invalid response from API request: http://it.mysite.org/piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=day&date=last520&format=php&token_auth=6862472f689dfbae97a714f8bf274219&trigger=archivephp. Response was '

<td bgc INFO [2014-01-09 14:21:00] [7e9a5] WARNING: Empty or invalid response '' for website id 1, Time elapsed: 5081.622s, skipping

(I didn’t create the tests/PHPUnit/Core/DataTableTest.php file which I hadn’t, I only created/updated the first 3 files in the given commit)

( ! ) Fatal error: Allowed memory size of 4294967296 bytes exhausted (tried to allocate 72 bytes) in /var/wwwc/piwik/core/DataTable.php on line 1317
Call Stack
#TimeMemoryFunctionLocation
10.0000226272{main}( )../index.php:0
20.04712795216Piwik\FrontController->dispatch( )../index.php:71
30.05153032656call_user_func_array ( )../FrontController.php:117
40.05153032824Piwik\Plugins\API\Controller->index( )../FrontController.php:117
50.05223036408Piwik\API\Request->process( )../Controller.php:34
60.05363061776Piwik\API\Proxy->call( )../Request.php:220
70.07383137696call_user_func_array ( )../Proxy.php:212
80.07383138312Piwik\Plugins\VisitsSummary\API->getVisits( )../Proxy.php:212
90.07383138424Piwik\Plugins\VisitsSummary\API->getNumeric( )../API.php:118
100.10973940008
28

Excuse me, spurius characters had been inserted: the call stack was:


Response was '<br />
<font size='1'><table class='xdebug-error xe-fatal-error' dir='ltr' border='1' cellspacing='0' cellpadding='1'>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> Fatal error: Allowed memory size of 4294967296 bytes exhausted (tried to allocate 72 bytes) in /var/wwwc/piwik/core/DataTable.php on line <i>1317</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Memory</th><th align='left' bgcolor='#eeeeec'>Function</th><th align='left' bgcolor='#eeeeec'>Location</th></tr>
<tr><td bgcolor='#eeeeec' align='center'>1</td><td bgcolor='#eeeeec' align='center'>0.0000</td><td bgcolor='#eeeeec' align='right'>226272</td><td bgcolor='#eeeeec'>{main}(  )</td><td title='/var/wwwc/piwik/index.php' bgcolor='#eeeeec'>../index.php<b>:</b>0</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>2</td><td bgcolor='#eeeeec' align='center'>0.0471</td><td bgcolor='#eeeeec' align='right'>2795216</td><td bgcolor='#eeeeec'>Piwik\FrontController->dispatch(  )</td><td title='/var/wwwc/piwik/index.php' bgcolor='#eeeeec'>../index.php<b>:</b>71</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>3</td><td bgcolor='#eeeeec' align='center'>0.0515</td><td bgcolor='#eeeeec' align='right'>3032656</td><td bgcolor='#eeeeec'><a href='http://www.php.net/call_user_func_array' target='_new'>call_user_func_array</a>
(  )</td><td title='/var/wwwc/piwik/core/FrontController.php' bgcolor='#eeeeec'>../FrontController.php<b>:</b>117</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>4</td><td bgcolor='#eeeeec' align='center'>0.0515</td><td bgcolor='#eeeeec' align='right'>3032824</td><td bgcolor='#eeeeec'>Piwik\Plugins\API\Controller->index(  )</td><td title='/var/wwwc/piwik/core/FrontController.php' bgcolor='#eeeeec'>../FrontController.php<b>:</b>117</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>5</td><td bgcolor='#eeeeec' align='center'>0.0522</td><td bgcolor='#eeeeec' align='right'>3036408</td><td bgcolor='#eeeeec'>Piwik\API\Request->process(  )</td><td title='/var/wwwc/piwik/plugins/API/Controller.php' bgcolor='#eeeeec'>../Controller.php<b>:</b>34</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>6</td><td bgcolor='#eeeeec' align='center'>0.0536</td><td bgcolor='#eeeeec' align='right'>3061776</td><td bgcolor='#eeeeec'>Piwik\API\Proxy->call(  )</td><td title='/var/wwwc/piwik/core/API/Request.php' bgcolor='#eeeeec'>../Request.php<b>:</b>220</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>7</td><td bgcolor='#eeeeec' align='center'>0.0738</td><td bgcolor='#eeeeec' align='right'>3137696</td><td bgcolor='#eeeeec'><a href='http://www.php.net/call_user_func_array' target='_new'>call_user_func_array</a>
(  )</td><td title='/var/wwwc/piwik/core/API/Proxy.php' bgcolor='#eeeeec'>../Proxy.php<b>:</b>212</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>8</td><td bgcolor='#eeeeec' align='center'>0.0738</td><td bgcolor='#eeeeec' align='right'>3138312</td><td bgcolor='#eeeeec'>Piwik\Plugins\VisitsSummary\API->getVisits(  )</td><td title='/var/wwwc/piwik/core/API/Proxy.php' bgcolor='#eeeeec'>../Proxy.php<b>:</b>212</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>9</td><td bgcolor='#eeeeec' align='center'>0.0738</td><td bgcolor='#eeeeec' align='right'>3138424</td><td bgcolor='#eeeeec'>Piwik\Plugins\VisitsSummary\API->getNumeric(  )</td><td title='/var/wwwc/piwik/plugins/VisitsSummary/API.php' bgcolor='#eeeeec'>../API.php<b>:</b>118</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>10</td><td bgcolor='#eeeeec' align='center'>0.1097</td><td bgcolor='#eeeeec' align='right'>3940008</td><td>
29

The error with another site with more visits than the previous one. It seems like errors are recursive


( ! ) Fatal error: Allowed memory size of 4294967296 bytes exhausted (tried to allocate 72 bytes) in /var/wwwc/piwik/core/DataTable.php on line 1317
Call Stack
#	Time	Memory	Function	Location
1	0.0000	226272	{main}( )	../index.php:0
2	0.0471	2795216	Piwik\FrontController->dispatch( )	../index.php:71
3	0.0515	3032656	call_user_func_array ( )	../FrontController.php:117
4	0.0515	3032824	Piwik\Plugins\API\Controller->index( )	../FrontController.php:117
5	0.0522	3036408	Piwik\API\Request->process( )	../Controller.php:34
6	0.0536	3061776	Piwik\API\Proxy->call( )	../Request.php:220
7	0.0738	3137696	call_user_func_array ( )	../Proxy.php:212
8	0.0738	3138312	Piwik\Plugins\VisitsSummary\API->getVisits( )	../Proxy.php:212
9	0.0738	3138424	Piwik\Plugins\VisitsSummary\API->getNumeric( )	../API.php:118
10	0.1097	3940008	
( ! ) Fatal error: Allowed memory size of 4294967296 bytes exhausted (tried to allocate 72 bytes) in /var/wwwc/piwik/core/DataTable/Row.php on line 80
Call Stack
#	Time	Memory	Function	Location
1	0.0000	226272	{main}( )	../index.php:0
2	0.0766	2793968	Piwik\FrontController->dispatch( )	../index.php:71
3	0.0798	2901056	call_user_func_array ( )	../FrontController.php:117
4	0.0798	2901224	Piwik\Plugins\API\Controller->index( )	../FrontController.php:117
5	0.0805	2904808	Piwik\API\Request->process( )	../Controller.php:34
6	0.0817	2930184	Piwik\API\Proxy->call( )	../Request.php:220
7	0.0831	2958128	call_user_func_array ( )	../Proxy.php:212
8	0.0831	2958744	Piwik\Plugins\VisitsSummary\API->getVisits( )	../Proxy.php:212
9	0.0831	2958856	Piwik\Plugins\VisitsSummary\API->getNumeric( )	../API.php:118
10	0.1130	3355816	
( ! ) Fatal error: Allowed memory size of 4294967296 bytes exhausted (tried to allocate 72 bytes) in /var/wwwc/piwik/core/DataTable.php on line 1317
Call Stack
#	Time	Memory	Function	Location
1	0.0000	226272	{main}( )	../index.php:0
2	0.0471	2795216	Piwik\FrontController->dispatch( )	../index.php:71
3	0.0515	3032656	call_user_func_array ( )	../FrontController.php:117
4	0.0515	3032824	Piwik\Plugins\API\Controller->index( )	../FrontController.php:117
5	0.0522	3036408	Piwik\API\Request->process( )	../Controller.php:34
6	0.0536	3061776	Piwik\API\Proxy->call( )	../Request.php:220
7	0.0738	3137696	call_user_func_array ( )	../Proxy.php:212
8	0.0738	3138312	Piwik\Plugins\VisitsSummary\API->getVisits( )	../Proxy.php:212
9	0.0738	3138424	Piwik\Plugins\VisitsSummary\API->getNumeric( )	../API.php:118

Here is the html, see it in a browser:


<font size='1'><table class='xdebug-error xe-fatal-error' dir='ltr' border='1' cellspacing='0' cellpadding='1'>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> Fatal error: Allowed memory size of 4294967296 bytes exhausted (tried to allocate 72 bytes) in /var/wwwc/piwik/core/DataTable.php on line <i>1317</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Memory</th><th align='left' bgcolor='#eeeeec'>Function</th><th align='left' bgcolor='#eeeeec'>Location</th></tr>
<tr><td bgcolor='#eeeeec' align='center'>1</td><td bgcolor='#eeeeec' align='center'>0.0000</td><td bgcolor='#eeeeec' align='right'>226272</td><td bgcolor='#eeeeec'>{main}(  )</td><td title='/var/wwwc/piwik/index.php' bgcolor='#eeeeec'>../index.php<b>:</b>0</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>2</td><td bgcolor='#eeeeec' align='center'>0.0471</td><td bgcolor='#eeeeec' align='right'>2795216</td><td bgcolor='#eeeeec'>Piwik\FrontController->dispatch(  )</td><td title='/var/wwwc/piwik/index.php' bgcolor='#eeeeec'>../index.php<b>:</b>71</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>3</td><td bgcolor='#eeeeec' align='center'>0.0515</td><td bgcolor='#eeeeec' align='right'>3032656</td><td bgcolor='#eeeeec'><a href='http://www.php.net/call_user_func_array' target='_new'>call_user_func_array</a>
(  )</td><td title='/var/wwwc/piwik/core/FrontController.php' bgcolor='#eeeeec'>../FrontController.php<b>:</b>117</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>4</td><td bgcolor='#eeeeec' align='center'>0.0515</td><td bgcolor='#eeeeec' align='right'>3032824</td><td bgcolor='#eeeeec'>Piwik\Plugins\API\Controller->index(  )</td><td title='/var/wwwc/piwik/core/FrontController.php' bgcolor='#eeeeec'>../FrontController.php<b>:</b>117</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>5</td><td bgcolor='#eeeeec' align='center'>0.0522</td><td bgcolor='#eeeeec' align='right'>3036408</td><td bgcolor='#eeeeec'>Piwik\API\Request->process(  )</td><td title='/var/wwwc/piwik/plugins/API/Controller.php' bgcolor='#eeeeec'>../Controller.php<b>:</b>34</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>6</td><td bgcolor='#eeeeec' align='center'>0.0536</td><td bgcolor='#eeeeec' align='right'>3061776</td><td bgcolor='#eeeeec'>Piwik\API\Proxy->call(  )</td><td title='/var/wwwc/piwik/core/API/Request.php' bgcolor='#eeeeec'>../Request.php<b>:</b>220</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>7</td><td bgcolor='#eeeeec' align='center'>0.0738</td><td bgcolor='#eeeeec' align='right'>3137696</td><td bgcolor='#eeeeec'><a href='http://www.php.net/call_user_func_array' target='_new'>call_user_func_array</a>
(  )</td><td title='/var/wwwc/piwik/core/API/Proxy.php' bgcolor='#eeeeec'>../Proxy.php<b>:</b>212</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>8</td><td bgcolor='#eeeeec' align='center'>0.0738</td><td bgcolor='#eeeeec' align='right'>3138312</td><td bgcolor='#eeeeec'>Piwik\Plugins\VisitsSummary\API->getVisits(  )</td><td title='/var/wwwc/piwik/core/API/Proxy.php' bgcolor='#eeeeec'>../Proxy.php<b>:</b>212</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>9</td><td bgcolor='#eeeeec' align='center'>0.0738</td><td bgcolor='#eeeeec' align='right'>3138424</td><td bgcolor='#eeeeec'>Piwik\Plugins\VisitsSummary\API->getNumeric(  )</td><td title='/var/wwwc/piwik/plugins/VisitsSummary/API.php' bgcolor='#eeeeec'>../API.php<b>:</b>118</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>10</td><td bgcolor='#eeeeec' align='center'>0.1097</td><td bgcolor='#eeeeec' align='right'>3940008</td><td bgc
Error: Got invalid response from API request: http://it.cathopedia.org/piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=11&period=day&date=last520&format=php&token_auth=6862472f689dfbae97a714f8bf274219&trigger=archivephp. Response was '<br />
<font size='1'><table class='xdebug-error xe-fatal-error' dir='ltr' border='1' cellspacing='0' cellpadding='1'>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> Fatal error: Allowed memory size of 4294967296 bytes exhausted (tried to allocate 72 bytes) in /var/wwwc/piwik/core/DataTable/Row.php on line <i>80</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Memory</th><th align='left' bgcolor='#eeeeec'>Function</th><th align='left' bgcolor='#eeeeec'>Location</th></tr>
<tr><td bgcolor='#eeeeec' align='center'>1</td><td bgcolor='#eeeeec' align='center'>0.0000</td><td bgcolor='#eeeeec' align='right'>226272</td><td bgcolor='#eeeeec'>{main}(  )</td><td title='/var/wwwc/piwik/index.php' bgcolor='#eeeeec'>../index.php<b>:</b>0</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>2</td><td bgcolor='#eeeeec' align='center'>0.0766</td><td bgcolor='#eeeeec' align='right'>2793968</td><td bgcolor='#eeeeec'>Piwik\FrontController->dispatch(  )</td><td title='/var/wwwc/piwik/index.php' bgcolor='#eeeeec'>../index.php<b>:</b>71</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>3</td><td bgcolor='#eeeeec' align='center'>0.0798</td><td bgcolor='#eeeeec' align='right'>2901056</td><td bgcolor='#eeeeec'><a href='http://www.php.net/call_user_func_array' target='_new'>call_user_func_array</a>
(  )</td><td title='/var/wwwc/piwik/core/FrontController.php' bgcolor='#eeeeec'>../FrontController.php<b>:</b>117</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>4</td><td bgcolor='#eeeeec' align='center'>0.0798</td><td bgcolor='#eeeeec' align='right'>2901224</td><td bgcolor='#eeeeec'>Piwik\Plugins\API\Controller->index(  )</td><td title='/var/wwwc/piwik/core/FrontController.php' bgcolor='#eeeeec'>../FrontController.php<b>:</b>117</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>5</td><td bgcolor='#eeeeec' align='center'>0.0805</td><td bgcolor='#eeeeec' align='right'>2904808</td><td bgcolor='#eeeeec'>Piwik\API\Request->process(  )</td><td title='/var/wwwc/piwik/plugins/API/Controller.php' bgcolor='#eeeeec'>../Controller.php<b>:</b>34</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>6</td><td bgcolor='#eeeeec' align='center'>0.0817</td><td bgcolor='#eeeeec' align='right'>2930184</td><td bgcolor='#eeeeec'>Piwik\API\Proxy->call(  )</td><td title='/var/wwwc/piwik/core/API/Request.php' bgcolor='#eeeeec'>../Request.php<b>:</b>220</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>7</td><td bgcolor='#eeeeec' align='center'>0.0831</td><td bgcolor='#eeeeec' align='right'>2958128</td><td bgcolor='#eeeeec'><a href='http://www.php.net/call_user_func_array' target='_new'>call_user_func_array</a>
(  )</td><td title='/var/wwwc/piwik/core/API/Proxy.php' bgcolor='#eeeeec'>../Proxy.php<b>:</b>212</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>8</td><td bgcolor='#eeeeec' align='center'>0.0831</td><td bgcolor='#eeeeec' align='right'>2958744</td><td bgcolor='#eeeeec'>Piwik\Plugins\VisitsSummary\API->getVisits(  )</td><td title='/var/wwwc/piwik/core/API/Proxy.php' bgcolor='#eeeeec'>../Proxy.php<b>:</b>212</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>9</td><td bgcolor='#eeeeec' align='center'>0.0831</td><td bgcolor='#eeeeec' align='right'>2958856</td><td bgcolor='#eeeeec'>Piwik\Plugins\VisitsSummary\API->getNumeric(  )</td><td title='/var/wwwc/piwik/plugins/VisitsSummary/API.php' bgcolor='#eeeeec'>../API.php<b>:</b>118</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>10</td><td bgcolor='#eeeeec' align='center'>0.1130</td><td bgcolor='#eeeeec' align='right'>3355816</td><td 
2 total errors during this script execution, please investigate and try and fix these errors
ERROR: 2 total errors during this script execution, please investigate and try and fix these errors. First error was: Got invalid response from API request: http://it.cathopedia.org/piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=day&date=last520&format=php&token_auth=6862472f689dfbae97a714f8bf274219&trigger=archivephp. Response was '<br />
<font size='1'><table class='xdebug-error xe-fatal-error' dir='ltr' border='1' cellspacing='0' cellpadding='1'>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> Fatal error: Allowed memory size of 4294967296 bytes exhausted (tried to allocate 72 bytes) in /var/wwwc/piwik/core/DataTable.php on line <i>1317</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Memory</th><th align='left' bgcolor='#eeeeec'>Function</th><th align='left' bgcolor='#eeeeec'>Location</th></tr>
<tr><td bgcolor='#eeeeec' align='center'>1</td><td bgcolor='#eeeeec' align='center'>0.0000</td><td bgcolor='#eeeeec' align='right'>226272</td><td bgcolor='#eeeeec'>{main}(  )</td><td title='/var/wwwc/piwik/index.php' bgcolor='#eeeeec'>../index.php<b>:</b>0</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>2</td><td bgcolor='#eeeeec' align='center'>0.0471</td><td bgcolor='#eeeeec' align='right'>2795216</td><td bgcolor='#eeeeec'>Piwik\FrontController->dispatch(  )</td><td title='/var/wwwc/piwik/index.php' bgcolor='#eeeeec'>../index.php<b>:</b>71</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>3</td><td bgcolor='#eeeeec' align='center'>0.0515</td><td bgcolor='#eeeeec' align='right'>3032656</td><td bgcolor='#eeeeec'><a href='http://www.php.net/call_user_func_array' target='_new'>call_user_func_array</a>
(  )</td><td title='/var/wwwc/piwik/core/FrontController.php' bgcolor='#eeeeec'>../FrontController.php<b>:</b>117</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>4</td><td bgcolor='#eeeeec' align='center'>0.0515</td><td bgcolor='#eeeeec' align='right'>3032824</td><td bgcolor='#eeeeec'>Piwik\Plugins\API\Controller->index(  )</td><td title='/var/wwwc/piwik/core/FrontController.php' bgcolor='#eeeeec'>../FrontController.php<b>:</b>117</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>5</td><td bgcolor='#eeeeec' align='center'>0.0522</td><td bgcolor='#eeeeec' align='right'>3036408</td><td bgcolor='#eeeeec'>Piwik\API\Request->process(  )</td><td title='/var/wwwc/piwik/plugins/API/Controller.php' bgcolor='#eeeeec'>../Controller.php<b>:</b>34</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>6</td><td bgcolor='#eeeeec' align='center'>0.0536</td><td bgcolor='#eeeeec' align='right'>3061776</td><td bgcolor='#eeeeec'>Piwik\API\Proxy->call(  )</td><td title='/var/wwwc/piwik/core/API/Request.php' bgcolor='#eeeeec'>../Request.php<b>:</b>220</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>7</td><td bgcolor='#eeeeec' align='center'>0.0738</td><td bgcolor='#eeeeec' align='right'>3137696</td><td bgcolor='#eeeeec'><a href='http://www.php.net/call_user_func_array' target='_new'>call_user_func_array</a>
(  )</td><td title='/var/wwwc/piwik/core/API/Proxy.php' bgcolor='#eeeeec'>../Proxy.php<b>:</b>212</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>8</td><td bgcolor='#eeeeec' align='center'>0.0738</td><td bgcolor='#eeeeec' align='right'>3138312</td><td bgcolor='#eeeeec'>Piwik\Plugins\VisitsSummary\API->getVisits(  )</td><td title='/var/wwwc/piwik/core/API/Proxy.php' bgcolor='#eeeeec'>../Proxy.php<b>:</b>212</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>9</td><td bgcolor='#eeeeec' align='center'>0.0738</td><td bgcolor='#eeeeec' align='right'>3138424</td><td bgcolor='#eeeeec'>Piwik\Plugins\VisitsSummary\API->getNumeric(  )</td><td title='/var/wwwc/piwik/plugins/VisitsSummary/API.php' bgcolor='#eeeeec'>../API.php<b>:</b>118</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>
30

Please read the error messages, they are different from the one reported in this topic:

child pid 4373 exit signal Segmentation fault (11)
child pid 4384 exit signal Segmentation fault (11)

See: http://piwik.org/faq/troubleshooting/faq_131/

( ! ) Fatal error: Allowed memory size of 4294967296 bytes exhausted (tried to allocate 72 bytes) in /var/wwwc/piwik/core/DataTable.php on line 1317

See http://piwik.org/faq/troubleshooting/#faq_95

31

Ok, raising memory_limity I got rid of the error, but now I have all the dayly statistics, but I don’t see the data for some weeks, months, and years

32

You’re right, Matt – sorry about that. I checked my log files and the Segmentation faults were happening for a long time…
So you fixed our main problem with the patch posted in this thread and archiving works again.

I took a look at the FAQ you mentioned and while there is PDO_MYSQL configured in Piwik’s global.ini.php our installation had an old entry “adapter = MYSQLI” in the config.ini.php. I deleted this entry to switch back to PDO_MYSQL and the Segmentation faults are gone. Archiving now works completely without errors.

Thanks for your help.

Thorsten

33

Aaargh! upgrading to 2.0.3 after patching like above gave me:

( ! ) Fatal error: Call to undefined method Piwik\Config::getFromDefaultConfig() in /var/wwwc/piwik/core/Plugin/Manager.php on line 484
Call Stack

Time Memory Function Location

1 0.0001 223208 {main}( ) …/index.php:0
2 0.0060 363080 Piwik\FrontController->init( ) …/index.php:61
3 0.0161 1213144 Piwik\Plugin\Manager->loadPlugins( ) …/FrontController.php:340
4 0.0161 1217920 Piwik\Plugin\Manager->reloadPlugins( ) …/Manager.php:526
5 0.0162 1222896 Piwik\Plugin\Manager->isPluginThirdPartyAndBogus( ) …/Manager.php:642
6 0.0162 1223000 Piwik\Plugin\Manager->isPluginBundledWithCore( ) …/Manager.php:495

( ! ) Fatal error: Call to undefined method Piwik\Config::getFromDefaultConfig() in /var/wwwc/piwik/core/Plugin/Manager.php on line 484
Call Stack

Time Memory Function Location

1 0.0001 223208 {main}( ) …/index.php:0
2 0.0060 363080 Piwik\FrontController->init( ) …/index.php:61
3 0.0161 1213144 Piwik\Plugin\Manager->loadPlugins( ) …/FrontController.php:340
4 0.0161 1217920 Piwik\Plugin\Manager->reloadPlugins( ) …/Manager.php:526
5 0.0162 1222896 Piwik\Plugin\Manager->isPluginThirdPartyAndBogus( ) …/Manager.php:642
6 0.0162 1223000 Piwik\Plugin\Manager->isPluginBundledWithCore( ) …/Manager.php:495
7 0.0167 1223320 Piwik\FrontController::triggerSafeModeWhenError( ) …/FrontController.php:0
8 0.0167 1224800 Piwik\FrontController->dispatch( ) …/FrontController.php:258
9 0.0190 1418968 call_user_func_array ( ) …/FrontController.php:117
10 0.0190 1419304 Piwik\Plugins\CorePluginsAdmin\Controller->safemode( ) …/FrontController.php:117
11 0.0227 1630928 Piwik\Plugin\Manager->returnLoadedPluginsInfo( ) …/Controller.php:365
12 0.0245 1646464 Piwik\Plugin\Manager->isPluginThirdPartyAndBogus( ) …/Manager.php:440
13 0.0245 1646464 Piwik\Plugin\Manager->isPluginBundledWithCore( ) …/Manager.php:495

Archiving too is unuseful:

/usr/bin/php5 /var/wwwc/piwik/misc/cron/archive.php --url=http://it.cathopedia.org/piwik/ > /var/log/piwik/piwik-archive.log

PHP Fatal error: Call to undefined method Piwik\Config::getFromDefaultConfig() in /var/wwwc/piwik/core/Plugin/Manager.php on line 484
PHP Stack trace:
PHP 1. {main}() /var/wwwc/piwik/misc/cron/archive.php:0
PHP 2. Piwik\CronArchive->init() /var/wwwc/piwik/misc/cron/archive.php:44
PHP 3. Piwik\CronArchive->initCore() /var/wwwc/piwik/core/CronArchive.php:140
PHP 4. Piwik\FrontController->init() /var/wwwc/piwik/core/CronArchive.php:736
PHP 5. Piwik\Plugin\Manager->loadPlugins() /var/wwwc/piwik/core/FrontController.php:340
PHP 6. Piwik\Plugin\Manager->reloadPlugins() /var/wwwc/piwik/core/Plugin/Manager.php:526
PHP 7. Piwik\Plugin\Manager->isPluginThirdPartyAndBogus() /var/wwwc/piwik/core/Plugin/Manager.php:642
PHP 8. Piwik\Plugin\Manager->isPluginBundledWithCore() /var/wwwc/piwik/core/Plugin/Manager.php:495
PHP Fatal error: Call to undefined method Piwik\Config::getFromDefaultConfig() in /var/wwwc/piwik/core/Plugin/Manager.php on line 484
PHP Stack trace:
PHP 1. {main}() /var/wwwc/piwik/misc/cron/archive.php:0
PHP 2. Piwik\CronArchive->init() /var/wwwc/piwik/misc/cron/archive.php:44
PHP 3. Piwik\CronArchive->initCore() /var/wwwc/piwik/core/CronArchive.php:140
PHP 4. Piwik\FrontController->init() /var/wwwc/piwik/core/CronArchive.php:736
PHP 5. Piwik\Plugin\Manager->loadPlugins() /var/wwwc/piwik/core/FrontController.php:340
PHP 6. Piwik\Plugin\Manager->reloadPlugins() /var/wwwc/piwik/core/Plugin/Manager.php:526
PHP 7. Piwik\Plugin\Manager->isPluginThirdPartyAndBogus() /var/wwwc/piwik/core/Plugin/Manager.php:642
PHP 8. Piwik\Plugin\Manager->isPluginBundledWithCore() /var/wwwc/piwik/core/Plugin/Manager.php:495
PHP 9. Piwik\FrontController::triggerSafeModeWhenError() /var/wwwc/piwik/core/FrontController.php:0
PHP 10. Piwik\FrontController->dispatch() /var/wwwc/piwik/core/FrontController.php:258
PHP 11. call_user_func_array() /var/wwwc/piwik/core/FrontController.php:117
PHP 12. Piwik\Plugins\CorePluginsAdmin\Controller->safemode() /var/wwwc/piwik/core/FrontController.php:117
PHP 13. Piwik\Plugin\Manager->returnLoadedPluginsInfo() /var/wwwc/piwik/plugins/CorePluginsAdmin/Controller.php:365
PHP 14. Piwik\Plugin\Manager->isPluginThirdPartyAndBogus() /var/wwwc/piwik/core/Plugin/Manager.php:440
PHP 15. Piwik\Plugin\Manager->isPluginBundledWithCore() /var/wwwc/piwik/core/Plugin/Manager.php:495

34

Still got this error in Piwik 2.0.3
PHP 5.4.24-1
timeout value 3600

INFO [2014-01-14 20:08:50] [91fe0] ERROR: Got invalid response from API request: http://xxx.yyy.com/index.php?module=API&method=VisitsSummary.getVisits&idSite=24&period=year&date=last3&format=php&token_auth=c8b5f7df73cd9cd49f9b0cca
2e0728b8&trigger=archivephp. Response was 'a:2:{s:6:“result”;s:5:“error”;s:7:“message”;s:192:"This report has been reprocessed since your last click. To see this error less often, please increase the timeout value in seconds in Settings

General Settings. (error: id 265 not found).";}’

35

Matt, any hint about the error I got after upgrading to 2.0.3? 301 Moved Permanently

36

reupload all files, looks like some files are not using 2.0…3

37

I reuploaded all the file, but when I archive I got error, with the recomendation to report on the forum:


First error was: Got invalid response from API request: http://mysite/piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=day&date=last52&format=php&token_auth=6862472f689dfbae97a714f8bf274219&trigger=archivephp. Response was '<div style='word-wrap: break-word; border: 3px solid red; padding:4px; width:70%; background-color:#FFFF96;'>
        <strong>There is an error. Please report the message (Piwik 2.0.3)
        and full backtrace in the <a href='?module=Proxy&action=redirect&url=http://forum.piwik.org' target='_blank'>Piwik forums</a> (please do a Search first as it might have been reported already!).<br /><br/>
        Notice:</strong> <em>Undefined index: enable_load_data_infile</em> in <strong>/var/piwik/core/Db/BatchInsert.php</strong> on line <strong>67</strong>
<br /><br />Backtrace --><div style="font-family:Courier;font-size:10pt"><br />
#0  Piwik\Error::errorHandler(...) called at [/var/piwik/core/Db/BatchInsert.php:67]<br />
#1  Piwik\Db\BatchInsert::tableInsertBatch(...) called at [/var/piwik/core/DataAccess/ArchiveWriter.php:280]<br />
#2  Piwik\DataAccess\ArchiveWriter->insertBulkRecords(...) called at [/var/piwik/core/DataAccess/ArchiveWriter.php:97]<br />
#3  Piwik\DataAccess\ArchiveWriter->insertBlobRecord(...) called at [/var/piwik/core/ArchiveProcessor.php:313]<br />
#4  Piwik\ArchiveProcessor->insertBlobRecord(...) called at [/var/piwik/plugins/Actions/Archiver.php:464]<br />
#5  Piwik\Plugins\Actions\Archiver->insertTable(...) called at [/var/piwik/plugins/Actions/Archiver.php:440]<br />
#6  Piwik\Plugins\Actions\Archiver->insertPageUrlsReports(...) called at [/var/piwik/plugins/Actions/Archiver.php:430]<br />
#7  Piwik\Plugins\Actions\Archiver->insertDayReports(...) called at [/var/piwik/plugins/Actions/Archiver.php:101]<br />
#8  Piwik\Plugins\Actions\Archiver->aggregateDayReport(...) called at [/var/piwik/core/ArchiveProcessor/PluginsArchiver.php:95]<br />
#9  Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins(...) called at [/var/piwik/core/ArchiveProcessor/Loader.php:120]<br />
#10  Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive(...) called at [/var/piwik/core/ArchiveProcessor/Loader.php:74]<br />
#11  Piwik\ArchiveProcessor\Loader->prepareArchive(...) called at [/var/piwik/core/Archive.php:793]<br />
#12  Piwik\Archive->prepareArchive(...) called at [/var/piwik/core/Archive.php:612]<br />
#13  Piwik\Archive->cacheArchiveIdsAfterLaunching(...) called at [/var/piwik/core/Archive.php:554]<br />
#14  Piwik\Archive->getArchiveIds(...) called at [/var/piwik/core/Archive.php:494]<br />
#15  Piwik\Archive->get(...) called at [/var/piwik/core/Archive.php:343]<br />
#16  Piwik\Archive->getDataTableFromNumeric(...) called at [/var/piwik/plugins/VisitsSummary/API.php:112]<br />
#17  Piwik\Plugins\VisitsSummary\API->getNumeric(...) called at [/var/piwik/plugins/VisitsSummary/API.php:118]<br />
#18  Piwik\Plugins\VisitsSummary\API->getVisits(...) called at [:]<br />
#19  call_user_func_array(...) called at [/var/piwik/core/API/Proxy.php:213]<br />
#20  Piwik\API\Proxy->call(...) called at [/var/piwik/core/API/Request.php:220]<br />
#21  Piwik\API\Request->process(...) called at [/var/piwik/plugins/API/Controller.php:34]<br />
#22  Piwik\Plugins\API\Controller->index(...) called at [:]<br />
#23  call_user_func_array(...) called at [/var/piwik/core/FrontController.php:117]<br />
#24  Piwik\FrontController->dispatch(...) called at [/var/piwik/index.php:62]<br />

I re-deleted all the archive tables in the db, I keep getting the same error.

38

A weird thing I saw in archive program: archiving begun creating 2013_11 table, then 2013_12, then 2014_01, and it stopped there with the error.

The logical thing would be beginning with 2014_01 and keep backward.

I get the error with all the sites, even with those which have less visits.

39

Check your file config/global.ini.php is uploaded correctly from 2.0.3