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