[solved] HowToFindError - 38473 records too much?

Previous topic

General

Next topic

Author	Message
Daniel Brüßler	Tuesday 09 June 2009 3:52:54 am Hello, we have upgraded to eZ Publish 4.1.2 and get a white page, when we try to edit a record in the ezadmin-siteaccess. Our custom ContentClass has 38473 records, 13 attributes, one of the attributes is of type "object relationS". We don't have override.ini.append.php entries for the ezadmin-siteaccess or in the override folder. We get a WHITE PAGE, when we have 128MB and a message like "memorry exausted" when it's 300MB, and "Maximum execution time of 300 seconds exceeded" when we set the memory limit to 1GB. Datasets of OTHER contentclasses are editable! They have just 5000 records or less. => problem with 4.1.2? => can it be a recursion? => why can we edit the record in the ger-siteaccess (this has an override for the edit-templates) Please tell your ideas about it - any answer is welcome Daniel Brüßler .............. lemonjuice digital creations GmbH & Co. KG www.lemonjuice.de ..............
Carlos Revillo	Tuesday 09 June 2009 4:42:57 am Is your object relations field and indexable one? Could it be maybe that you're getting relations like A -> B, B->C, C->A? Maybe you can try to make your object relations field non indexable...
Daniel Brüßler	Tuesday 09 June 2009 6:09:35 am Thanks, Carlos, the error was in an other content class which has the type "object relational browse". There I had the wrong select-type for the list of relations "List" instead of "default browse".... Before our import this worked well, just a little number of options in the select box, but after the import it had too much entries. Cheers! Daniel .............. lemonjuice digital creations GmbH & Co. KG www.lemonjuice.de ..............

Author

Message

Daniel Brüßler

Tuesday 09 June 2009 3:52:54 am

Hello,

we have upgraded to eZ Publish 4.1.2 and get a white page, when we try to edit a record in the ezadmin-siteaccess.

Our custom ContentClass has 38473 records, 13 attributes, one of the attributes is of type "object relationS". We don't have override.ini.append.php entries for the ezadmin-siteaccess or in the override folder.

We get a WHITE PAGE, when we have 128MB and a message like "memorry exausted" when it's 300MB, and "Maximum execution time of 300 seconds exceeded" when we set the memory limit to 1GB.

Datasets of OTHER contentclasses are editable! They have just 5000 records or less.

=> problem with 4.1.2?
=> can it be a recursion?
=> why can we edit the record in the ger-siteaccess (this has an override for the edit-templates)

Please tell your ideas about it - any answer is welcome
Daniel Brüßler

..............

lemonjuice digital creations GmbH & Co. KG
www.lemonjuice.de

..............

Carlos Revillo

Tuesday 09 June 2009 4:42:57 am

Is your object relations field and indexable one?
Could it be maybe that you're getting relations like A -> B, B->C, C->A?

Maybe you can try to make your object relations field non indexable...

Daniel Brüßler

Tuesday 09 June 2009 6:09:35 am

Thanks, Carlos,

the error was in an other content class which has the type "object relational browse". There I had the wrong select-type for the list of relations "List" instead of "default browse".... Before our import this worked well, just a little number of options in the select box, but after the import it had too much entries.

Cheers!
Daniel

..............

lemonjuice digital creations GmbH & Co. KG
www.lemonjuice.de

..............

eZ debug

Timing:	Jan 18 2025 19:35:38
Script start
Timing:	Jan 18 2025 19:35:38
Module start 'layout'
Timing:	Jan 18 2025 19:35:38
Module start 'content'
Timing:	Jan 18 2025 19:35:39
Module end 'content'
Timing:	Jan 18 2025 19:35:39
Script end

Main resources:

Total runtime	0.5947 sec
Peak memory usage	4,096.0000 KB
Database Queries	57

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0045	588.0391	152.6406
Module start 'layout'	0.0045	0.0041	740.6797	39.4766
Module start 'content'	0.0086	0.5847	780.1563	534.9922
Module end 'content'	0.5933	0.0014	1,315.1484	12.4375
Script end	0.5947		1,327.5859

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.5640	16	0.0002
Check MTime	0.0012	0.2083	16	0.0001
Mysql Total
Database connection	0.0005	0.0858	1	0.0005
Mysqli_queries	0.5462	91.8351	57	0.0096
Looping result	0.0005	0.0915	55	0.0000
Template Total	0.5683	95.6	2	0.2842
Template load	0.0016	0.2741	2	0.0008
Template processing	0.5667	95.2872	2	0.2833
Template load and register function	0.0001	0.0188	1	0.0001
states
state_id_array	0.0013	0.2240	1	0.0013
state_identifier_array	0.0009	0.1497	2	0.0004
Override
Cache load	0.0014	0.2278	24	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0006	0.1013	2	0.0003
Fetch class attribute name	0.0009	0.1582	4	0.0002
XML
Image XML parsing	0.0025	0.4187	2	0.0012
class_abstraction
Instantiating content class attribute	0.0000	0.0011	5	0.0000
General
dbfile	0.0026	0.4389	16	0.0002
String conversion	0.0000	0.0017	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
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
6	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
4	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 17 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs