Forums / General / ezpersistentobject memory error updating class attribute with +150000 objects stored
Hugo Sandoval
Wednesday 04 August 2010 1:45:30 pm
Hello.
When i try to delete, modify or add an attribute to a class with more than 150K object published, the ezpublish fatal error appears. The var/log/error.log output is:
PHP Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 16777216 bytes) in /srv/www/htdocs/kernel/classes/ezpersistentobject.php on line 906, referer: http://localhost/index.php/ezwebin_site_admin/class/edit/45/(language)/esl-ES
I'd make some queries taken from debug output, directly in mysql and it's return the 150K records in 1 single select sentence.
******
ezpublish: 4.3
mysql: 5.1.46-log SUSE
.·. .·. .·. .·. .·. .·. .·. http://www.softwarelibre.com.ve/
André R.
Thursday 05 August 2010 1:28:12 am
This is not supported from the web ui currently.
You'll need to use a script to accomplish changing class schema on so many objects.In 4.3 and up you can use an extension called ezscriptmonitor: http://projects.ez.no/ezscriptmonitor
(you can use it with older 4.x ezp versions as well, but then you need to use version 0.3 of it)
eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription @: http://twitter.com/andrerom