Forums / Developer / database transactions

database transactions

« 
Previous topic
|
Developer
|
Next topic
 »
Author Message

Brendan Pike

Tuesday 22 March 2005 10:54:17 pm

In a development site I enabled InnoDB using the ezconvertmysqltabletype.php script. Interestingly it converted many non-eZ publish tables I was using inside the database also. For some reason a few eZ publish tables were not converted and continue to use MyISAM these are, ezcontentobject_tree, ezimagefile, eztrigger and ezurlalias. Is this intentional?

www.dbinformatics.com.au

We are always interested in hearing from experienced eZ PHP programmers and eZ template designers interested in contract work.

Frederik Holljen

Wednesday 23 March 2005 12:28:48 am

Hi,

I've notified the developer who made the script about this message (I unfortunately don't know the answer to your problem). He's left for eastern holidays however, so he won't be able to answer you until next week.

Frederik

Brendan Pike

Wednesday 23 March 2005 5:38:53 am

Thanks for the heads up Frederik

I'll sit tight for now, I also found that trying to move a user to a new user group while editing the user results in a fatal error with a transaction related message. Although moving the user's location from outside the user works fine. Feels like a half implemented thing so I wont submit a bug report yet.

www.dbinformatics.com.au

We are always interested in hearing from experienced eZ PHP programmers and eZ template designers interested in contract work.

Raymond Bosman

Wednesday 30 March 2005 1:45:07 am

Hi Brendan,

Thanks for your notification. It was indeed not the intension to convert the non-eZ publish tables, which is fixed in the trunk.
However it is not intentional to leave the tables: ezcontentobject_tree, ezimagefile, eztrigger, and ezurlalias unconverted. I discovered that MySQL crashes sometimes while converting a large table. Can you check your mysqld error log, to see whether this is the reason why some tables are skipped?

You also found a bug while moving a user to a new user group. Probably the reason why this fatal error pops up is due to an invalid query. Without transactions the error would have been ignored. So can you report this bug, please?

Thanks for your contribution,
Raymond.

eZ debug

Timing: Jan 18 2025 19:17:13
Script start
Timing: Jan 18 2025 19:17:13
Module start 'content'
Timing: Jan 18 2025 19:17:13
Module end 'content'
Timing: Jan 18 2025 19:17:13
Script end

Main resources:

Total runtime0.1517 sec
Peak memory usage4,096.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0066 587.6094180.8438
Module start 'content' 0.00660.0059 768.453193.8359
Module end 'content' 0.01250.1391 862.2891521.8594
Script end 0.1517  1,384.1484 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00412.7201200.0002
Check MTime0.00201.3471200.0001
Mysql Total
Database connection0.00110.728810.0011
Mysqli_queries0.104068.54851410.0007
Looping result0.00120.81811390.0000
Template Total0.138891.410.1388
Template load0.00090.578610.0009
Template processing0.137990.860710.1379
Override
Cache load0.00060.394010.0006
Sytem overhead
Fetch class attribute can translate value0.00090.600310.0009
XML
Image XML parsing0.00030.170010.0003
General
dbfile0.00342.2148200.0002
String conversion0.00000.002730.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.0001 secs