Another Memory issue with archive.sh


(gabel) #1

When starting the archive.sh script i’ll get the following error.
I know that there are some memory issues with piwik,
but it should be able to handle one low-medium
traffic page (~30.000 Actions per day).

Trac Ticket #1777

Any recommendations?

System:

Piwik Version 1.0
Ubuntu 10.04 LTS
PHP memory_limit 256M
Apache 2.x
PHP 5.3

Database Stats (the important rows):

Table Row count Data size Index size Total size
piwik_log_link_visit_action 379.8 K 9.3 Mb 8.3 Mb 17.6 Mb
piwik_archive_blob_2010_10 375,3 K 162,8 Mb 18,5 Mb 181,3 Mb
Total 879590 189,3 Mb 33,1 Mb 222,4 Mb

Enabled Plugins:

Actions, Dashboard, DBStats, ExampleAPI, ExampleFeedburner, ExamplePlugin, ExampleRssWidget, Feedback, Goals, LanguagesManager, Login, MultiSites, PDFReports, Provider, Referers, SEO, UserCountry, UserCountryMap, UserSettings, VisitFrequency, VisitorInterest, VisitsSummary, VisitTime, Widgetize

URL called:

index.php?module=API&method=VisitsSummary.getVisits&idSite=2&period=month&date=last52&format=xml&token_auth=***

PHP-Error:

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 8208 bytes) in 
/***/htdocs/php-bin/piwik/core/DataTable.php on line 935 Call Stack: 0,0005 676696 1. {main}() 
/***/htdocs/php-bin/piwik/index.php:0 0,0903 9846632 2. Piwik_FrontController->dispatch() 
/***/htdocs/php-bin/piwik/index.php:60 0,0928 10287632 3. call_user_func_array() 
/***/htdocs/php-bin/piwik/core/FrontController.php:126 0,0928 10288016 4. Piwik_API_Controller->index() 
/***/htdocs/php-bin/piwik/core/FrontController.php:0 0,0932 10340904 5. Piwik_API_Request->process() 
/***/htdocs/php-bin/piwik/plugins/API/Controller.php:27 0,0961 10575952 6. Piwik_API_Proxy->call() 
/***/htdocs/php-bin/piwik/core/API/Request.php:117 0,0969 10668120 7. call_user_func_array() 
/***/htdocs/php-bin/piwik/core/API/Proxy.php:151 0,0969 10669032 8. Piwik_VisitsSummary_API->getVisits() 
/***/htdocs/php-bin/piwik/core/API/Proxy.php:0 0,0969 10669176 9. Piwik_VisitsSummary_API->getNumeric() 
/***/htdocs/php-bin/piwik/plugins/VisitsSummary/API.php:106 0,0969 10669176 10. Piwik_Archive::build() 
/***/htdocs/php-bin/piwik/plugins/VisitsSummary/API.php:99 0,0992 10808264 11. Piwik_Archive_Array_IndexedByDate->__construct() 
/***/htdocs/php-bin/piwik/core/Archive.php:145 0,3379 18409040 12. Piwik_Archive::build() 
/***/htdocs/php-bin/piwik/core/Archive/Array/IndexedByDate.php:32 0,3380 18413608 13. Piwik_Archive_Single->prepareArchive() 
/***/htdocs/php-bin/piwik/core/Archive.php:170 0,3446 18477304 14. Piwik_ArchiveProcessing->launchArchiving() 
/***/htdocs/php-bin/piwik/core/Archive/Single.php:185 0,4027 18893640 15. Piwik_ArchiveProcessing_Period->compute() 
/***/htdocs/php-bin/piwik/core/ArchiveProcessing.php:410 0,9079 18950008 16. Piwik_PostEvent() 
/***/htdocs/php-bin/piwik/core/ArchiveProcessing/Period.php:286 0,9080 18951584 17. Event_Dispatcher->postNotification() 
/***/htdocs/php-bin/piwik/core/PluginsManager.php:532 0,9082 18955848 18. call_user_func_array() '
/***/htdocs/php-bin/piwik/libs/Event/Dispatcher.php:284 0,9082 18955904 19. Piwik_Actions->archivePeriod() 
/***/htdocs/php-bin/piwik/libs/Event/Dispatcher.php:0 0,9083 18957368 20. Piwik_ArchiveProcessing_Period->archiveDataTable() 
/***/htdocs/php-bin/piwik/plugins/Actions/Actions.php:186 5,3828 115301024 21. Piwik_ArchiveProcessing_Period->getRecordDataTableSum() 
/***/htdocs/php-bin/piwik/core/ArchiveProcessing/Period.php:183 15,7768 258260224 22. Piwik_Archive_Single->loadSubDataTables() 
/***/htdocs/php-bin/piwik/core/ArchiveProcessing/Period.php:213 16,2562 268152784 23. Piwik_Archive_Single->loadSubDataTables() 
/***/htdocs/php-bin/piwik/core/Archive/Single.php:305 16,2565 268186840 24. Piwik_Archive_Single->loadSubDataTables() 
/***/htdocs/php-bin/piwik/core/Archive/Single.php:305 16,2566 268193376 25. Piwik_Archive_Single->getDataTable() 
/***/htdocs/php-bin/piwik/core/Archive/Single.php:303 16,2566 268195576 26. Piwik_DataTable->addRowsFromSerializedArray() 
/***/htdocs/php-bin/piwik/core/Archive/Single.php:449 16,2566 268195656 27. unserialize() /***/htdocs/php-bin/piwik/core/DataTable.php:935