Forums / Setup & design / Fatal error: A database transaction in eZ Publish failed

Fatal error: A database transaction in eZ Publish failed

Author Message

Joël LEGER

Thursday 19 June 2008 2:38:15 am

Hi,
the website used to work fine until this :

Fatal error: A database transaction in eZ Publish failed.

The current execution was stopped to prevent further problems.
You should contact the System Administrator of this site with the information on this page.
The current transaction ID is TRANSID-564233c1ef2907f3e97fd7a0d0fb1ff2 and has been logged.
Please include the transaction ID and the current URL when contacting the system administrator.

I can't edit anything, i check the debug and i get this:

Timing:  	Jun 19 2008 11:33:52

Module start 'content'

Error: eZMySQLDB 	Jun 19 2008 11:33:52

Query error: The table 'ezcontentobject_attribute' is full. Query: INSERT INTO ezcontentobject_attribute (id, contentobject_id, version, language_code, language_id, contentclassattribute_id, attribute_original_id, sort_key_int, sort_key_string, data_type_string, data_text, data_int, data_float) VALUES(1, 1, 48, 'fre-FR', 2, 4, 0, 0, 'bienvenue sur le site de la ffhmfac', 'ezstring', 'Bienvenue sur le site de la FFHMFAC', 0, 0.000000)

Error: eZDBInterface::commit TRANSID-564233c1ef2907f3e97fd7a0d0fb1ff2 	Jun 19 2008 11:33:52

Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-564233c1ef2907f3e97fd7a0d0fb1ff2.

So i check if the database space was full or the disk space but nothing appear to me.

eZ debug

Timing: Jan 19 2025 03:43:05
Script start
Timing: Jan 19 2025 03:43:05
Module start 'content'
Timing: Jan 19 2025 03:43:06
Module end 'content'
Timing: Jan 19 2025 03:43:06
Script end

Main resources:

Total runtime1.2030 sec
Peak memory usage4,096.0000 KB
Database Queries183

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0082 589.1953180.8125
Module start 'content' 0.00820.9964 770.0078412.9063
Module end 'content' 1.00460.1983 1,182.9141333.9063
Script end 1.2029  1,516.8203 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00430.3581210.0002
Check MTime0.00150.1269210.0001
Mysql Total
Database connection0.00130.109910.0013
Mysqli_queries1.124193.43901830.0061
Looping result0.00230.19121810.0000
Template Total1.165196.820.5825
Template load0.00210.170420.0010
Template processing1.163096.675320.5815
Template load and register function0.00040.031010.0004
states
state_id_array0.00330.273810.0033
state_identifier_array0.00130.104520.0006
Override
Cache load0.00170.138990.0002
Sytem overhead
Fetch class attribute can translate value0.00140.118120.0007
Fetch class attribute name0.00120.099710.0012
XML
Image XML parsing0.00040.032620.0002
class_abstraction
Instantiating content class attribute0.00000.000410.0000
General
dbfile0.00920.7649210.0004
String conversion0.00000.000630.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
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
1content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
1content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
3content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 9
 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs