loop while updating content

Next topic

Author	Message
Harry van Irsel	Thursday 17 August 2006 6:55:17 am I've upgraded my site from 3.8.0. to 3.8.3 but now I'm getting problems after updating or adding some content through the admin interface. After 3 or 4 updates or additions eZpublish gets into an infinite loop. After a while my account gets suspended by my webhost so my site is unavailable. Didn't have the problem with 3.8.0. Anyone else got the same problem and more important what can I do to solve it ? One solution is a fallback to 3.8.0 but that is not really something I want to do........
Harry van Irsel	Thursday 17 August 2006 9:56:49 pm Some additional information. My webhost company monitored the site for a day, and it looks like the mysql database gets into a loop which causes the server to overload.
Harry van Irsel	Saturday 19 August 2006 7:17:08 am I mentioned before that I upgrade from 3.8.0 but it was 3.8.1. Been forced to restore 3.8.1 and all works fine now.... For the time being I will not upgrade to 3.8.3 because the problem was not found.....
Harry van Irsel	Friday 25 August 2006 1:57:17 am Look like like I'm getting closer to the cause of the problem. After I did a fallback to 3.8.1 and restored the databases to a date of which I was sure everything was stable the site runned OK for a week now. Yesterday I looked through my guest accounts and noticed two blank accounts. I remembered getting the registrationmails of these two blank accounts, but didn't payed much attention to it at the time. Yesterday I've deleted these 2 blank accounts and suddenly the problems came back. After a short time updating my content through the admin interface it again seemes to go in a loop. My webhost company says that everything points to problems with severe load on my mysql database. My guess now is that the deletion of the blank accounts causes the database to go in a corrupt status or something like that. I remember also that I did the same thing when I upgraded to 3.8.3 and the same problems occurred. For the time being I could restore the database with the blank accounts in them an leave them as is. Problem is that my webhost suspends my account when it happens and I cann't do anything about it...

eZ debug

Timing:	Jan 18 2025 21:07:43
Script start
Timing:	Jan 18 2025 21:07:43
Module start 'layout'
Timing:	Jan 18 2025 21:07:43
Module start 'content'
Timing:	Jan 18 2025 21:07:44
Module end 'content'
Timing:	Jan 18 2025 21:07:44
Script end

Main resources:

Total runtime	1.2088 sec
Peak memory usage	4,096.0000 KB
Database Queries	58

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0058	589.4609	152.6406
Module start 'layout'	0.0058	0.0040	742.1016	39.4766
Module start 'content'	0.0098	1.1974	781.5781	487.2969
Module end 'content'	1.2073	0.0015	1,268.8750	12.1484
Script end	1.2088		1,281.0234

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0035	0.2855	16	0.0002
Check MTime	0.0014	0.1166	16	0.0001
Mysql Total
Database connection	0.0007	0.0606	1	0.0007
Mysqli_queries	1.1413	94.4170	58	0.0197
Looping result	0.0006	0.0463	56	0.0000
Template Total	1.1676	96.6	2	0.5838
Template load	0.0024	0.1961	2	0.0012
Template processing	1.1652	96.3963	2	0.5826
Template load and register function	0.0001	0.0080	1	0.0001
states
state_id_array	0.0018	0.1487	1	0.0018
state_identifier_array	0.0016	0.1332	2	0.0008
Override
Cache load	0.0019	0.1570	31	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0478	1	0.0006
Fetch class attribute name	0.0013	0.1081	5	0.0003
XML
Image XML parsing	0.0015	0.1221	1	0.0015
class_abstraction
Instantiating content class attribute	0.0000	0.0020	8	0.0000
General
dbfile	0.0026	0.2136	16	0.0002
String conversion	0.0000	0.0007	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
4	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
4	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
4	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
6	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 20 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs