ezpersistentobject memory error updating class attribute with +150000 objects stored

Previous topic

General

Next topic

Author	Message
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

Author

Message

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