Fatal error: A database transaction in eZ Publish failed

Next topic

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.

Author

Message

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 31 2025 00:41:20
Script start
Timing:	Jan 31 2025 00:41:20
Module start 'layout'
Timing:	Jan 31 2025 00:41:20
Module start 'content'
Timing:	Jan 31 2025 00:41:21
Module end 'content'
Timing:	Jan 31 2025 00:41:21
Script end

Main resources:

Total runtime	1.1652 sec
Peak memory usage	8,192.0000 KB
Database Queries	46

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0047	588.3750	151.2422
Module start 'layout'	0.0047	0.0032	739.6172	220.7500
Module start 'content'	0.0079	1.1564	960.3672	4,146.5156
Module end 'content'	1.1643	0.0009	5,106.8828	7.9375
Script end	1.1651		5,114.8203

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.2944	16	0.0002
Check MTime	0.0013	0.1145	16	0.0001
Mysql Total
Database connection	0.0008	0.0685	1	0.0008
Mysqli_queries	1.0973	94.1735	46	0.0239
Looping result	0.0005	0.0430	44	0.0000
Template Total	1.1075	95.0	2	0.5537
Template load	0.0022	0.1886	2	0.0011
Template processing	1.1053	94.8577	2	0.5526
Template load and register function	0.0013	0.1100	1	0.0013
states
state_id_array	0.0022	0.1922	1	0.0022
state_identifier_array	0.0028	0.2373	2	0.0014
Override
Cache load	0.0018	0.1518	9	0.0002
Sytem overhead
Fetch class attribute can translate value	0.0019	0.1614	1	0.0019
Fetch class attribute name	0.0016	0.1365	1	0.0016
XML
Image XML parsing	0.0001	0.0098	1	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0005	1	0.0000
General
dbfile	0.0012	0.0997	10	0.0001
String conversion	0.0000	0.0006	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
1	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
3	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
2	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 9 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs