A database transaction error after send for publishing

Next topic

Author	Message
Softriva .com	Monday 06 July 2009 9:03:21 am Hello I am getting this error after I send for publish. This error only occurs on the live server but not locally. I am running 4.1.3. Thank you 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-269d8fb76eaee6e478acb99e4662c761 and has been logged. Please include the transaction ID and the current URL when contacting the system administrator.
Łukasz Serwatka	Monday 06 July 2009 10:45:10 am Hi, More details about which SQL query failed you can find in the eZ Publish error.log. See var/log/error.log and search for the TRANSID. Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog
Softriva .com	Monday 06 July 2009 10:52:47 am Fixed it. I enabled the DELETE rights for the db user. For info, the error is shown below: DELETE command denied to user 'dbuser'@'localhost' for table 'ezcontentobject_link'. Query: DELETE FROM ezcontentobject_link
Łukasz Serwatka	Monday 06 July 2009 10:54:15 am Good. DELETE is required for eZ Publish DB user. Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog

eZ debug

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0061	588.1563	152.6563
Module start 'layout'	0.0061	0.0033	740.8125	39.5078
Module start 'content'	0.0094	0.9895	780.3203	543.4141
Module end 'content'	0.9989	0.0016	1,323.7344	12.1094
Script end	1.0005		1,335.8438

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0032	0.3159	16	0.0002
Check MTime	0.0013	0.1339	16	0.0001
Mysql Total
Database connection	0.0010	0.1013	1	0.0010
Mysqli_queries	0.9496	94.9121	60	0.0158
Looping result	0.0006	0.0583	58	0.0000
Template Total	0.9658	96.5	2	0.4829
Template load	0.0022	0.2171	2	0.0011
Template processing	0.9636	96.3090	2	0.4818
Template load and register function	0.0002	0.0195	1	0.0002
states
state_id_array	0.0016	0.1571	1	0.0016
state_identifier_array	0.0015	0.1547	2	0.0008
Override
Cache load	0.0017	0.1743	18	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0009	0.0928	2	0.0005
Fetch class attribute name	0.0012	0.1167	5	0.0002
XML
Image XML parsing	0.0007	0.0748	2	0.0004
class_abstraction
Instantiating content class attribute	0.0000	0.0013	6	0.0000
General
dbfile	0.0019	0.1946	18	0.0001
String conversion	0.0000	0.0009	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

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/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
4	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
2	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 14 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs