Forums / Install & configuration / loop while updating content

loop while updating content

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 18:22:01
Script start
Timing: Jan 18 2025 18:22:01
Module start 'content'
Timing: Jan 18 2025 18:22:01
Module end 'content'
Timing: Jan 18 2025 18:22:01
Script end

Main resources:

Total runtime0.1799 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0057 587.8281180.8281
Module start 'content' 0.00570.0060 768.656397.9141
Module end 'content' 0.01170.1681 866.5703526.3047
Script end 0.1798  1,392.8750 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00382.1122200.0002
Check MTime0.00140.7604200.0001
Mysql Total
Database connection0.00080.469210.0008
Mysqli_queries0.129672.05901410.0009
Looping result0.00170.94341390.0000
Template Total0.167493.110.1674
Template load0.00100.568110.0010
Template processing0.166492.502810.1664
Override
Cache load0.00070.390910.0007
Sytem overhead
Fetch class attribute can translate value0.00070.363610.0007
XML
Image XML parsing0.00020.125010.0002
General
dbfile0.00291.6361200.0001
String conversion0.00000.002830.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0002 secs