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

eZ debug

Timing:	Jan 18 2025 02:05:13
Script start
Timing:	Jan 18 2025 02:05:13
Module start 'layout'
Timing:	Jan 18 2025 02:05:13
Module start 'content'
Timing:	Jan 18 2025 02:05:14
Module end 'content'
Timing:	Jan 18 2025 02:05:14
Script end

Main resources:

Total runtime	0.7545 sec
Peak memory usage	4,096.0000 KB
Database Queries	55

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0095	588.3984	152.6875
Module start 'layout'	0.0095	0.0046	741.0859	39.5547
Module start 'content'	0.0141	0.7385	780.6406	533.3750
Module end 'content'	0.7527	0.0018	1,314.0156	12.0625
Script end	0.7544		1,326.0781

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0036	0.4798	16	0.0002
Check MTime	0.0015	0.1971	16	0.0001
Mysql Total
Database connection	0.0010	0.1376	1	0.0010
Mysqli_queries	0.7012	92.9415	55	0.0127
Looping result	0.0006	0.0769	53	0.0000
Template Total	0.7195	95.4	2	0.3598
Template load	0.0020	0.2624	2	0.0010
Template processing	0.7175	95.1014	2	0.3588
Template load and register function	0.0002	0.0290	1	0.0002
states
state_id_array	0.0009	0.1173	1	0.0009
state_identifier_array	0.0011	0.1455	2	0.0005
Override
Cache load	0.0017	0.2200	18	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0007	0.0958	2	0.0004
Fetch class attribute name	0.0013	0.1700	4	0.0003
XML
Image XML parsing	0.0031	0.4134	2	0.0016
class_abstraction
Instantiating content class attribute	0.0000	0.0009	4	0.0000
General
dbfile	0.0027	0.3571	23	0.0001
String conversion	0.0000	0.0013	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
2	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
3	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	content/datatype/view/ezxmltags/link.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/link.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 11 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs