Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Another Memory issue with archive.sh #1777

Closed
anonymous-matomo-user opened this issue Oct 22, 2010 · 1 comment
Closed

Another Memory issue with archive.sh #1777

anonymous-matomo-user opened this issue Oct 22, 2010 · 1 comment
Labels
Bug For errors / faults / flaws / inconsistencies etc. duplicate For issues that already existed in our issue tracker and were reported previously.
Milestone
1.1

Comments

@anonymous-matomo-user
Copy link

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).

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
@robocoder
Copy link
Contributor

Marking as a duplicate of #766.

@anonymous-matomo-user anonymous-matomo-user added this to the Piwik 1.1 milestone Jul 8, 2014
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Bug For errors / faults / flaws / inconsistencies etc. duplicate For issues that already existed in our issue tracker and were reported previously.
Projects
None yet
Milestone
1.1
Development

No branches or pull requests
2 participants
@robocoder @anonymous-matomo-user