Fehlermeldung bei Löschversuch

Samstag, 20. Mai 2006 07:21:02

Hallo!

Ich kann keine Datei löschen. Es kommt folgende Fehlermeldung:

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-(....) and has been logged.
Please include the transaction ID and the current URL when contacting the system administrator.

Woran liegt das?

Samstag, 20. Mai 2006 17:11:14

Also da ich nichts löschen kann, hat sich mein anderes Posting erst mal so lange erledigt, bis das mit dem Löschen geklärt ist

Ich habe die Debugfunktion eingeschaltet und das Ergebnis ist leider ellenlang:

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-14d2ae4553e8cdc7d44d43fff6cc3912 and has been logged.
Please include the transaction ID and the current URL when contacting the system administrator.



Notice: Only variable references should be returned by reference in /.../.../.../.../lib/eztemplate/classes/eztemplate.php on line 600
eZ debug
Clear cache:
Gesamter Cache Inhalt Template Template & Inhalt Ini Einstellungen Statisch

Quick settings:

Debug output Debug redirection Template debug Inline template debug List of used templates SQL debug output

Timing: May 20 2006 16:53:40
Script start

Notice: eZMySQLDB::query(0.000 ms) query number per page:0 May 20 2006 16:53:40
SET NAMES 'utf8'

Notice: eZMySQLDB::query(1 rows, 0.459 ms) query number per page:1 May 20 2006 16:53:40
SELECT data, user_id, expiration_time FROM ezsession WHERE session_key='7607049301e6775a9f7859e3114cd762'

Notice: eZMySQLDB::query(0 rows, 0.467 ms) query number per page:2 May 20 2006 16:53:40
SELECT contentobject_id, login, email, password_hash, password_hash_type
FROM ezuser
WHERE contentobject_id='0'

Notice: eZMySQLDB::query(0 rows, 0.397 ms) query number per page:3 May 20 2006 16:53:40
SELECT contentobject_id, login, email, password_hash, password_hash_type
FROM ezuser
WHERE contentobject_id='0'

Notice: eZMySQLDB::query(0 rows, 0.568 ms) query number per page:4 May 20 2006 16:53:40
SELECT destination_url, forward_to_id
FROM ezurlalias
WHERE source_md5 = '1c34fd3458a71d2991757bd3f2394cdd' AND
is_wildcard = 0
ORDER BY forward_to_id ASC, is_internal ASC
LIMIT 0, 1

Timing: May 20 2006 16:53:40
Module start 'content'

Notice: eZMySQLDB::query(0 rows, 0.169 ms) query number per page:5 May 20 2006 16:53:40
BEGIN WORK

Notice: eZMySQLDB::query(2 rows, 0.491 ms) query number per page:6 May 20 2006 16:53:40
SELECT id, name, locale, disabled
FROM ezcontent_language
ORDER BY name ASC

Notice: eZMySQLDB::query(1 rows, 0.824 ms) query number per page:6 May 20 2006 16:53:40
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.name as class_name,
ezcontentclass.identifier as class_identifier
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id IN ( 65 ) AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0

and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
)

Notice: eZMySQLDB::query(1 rows, 0.427 ms) query number per page:7 May 20 2006 16:53:40
SELECT id, version, name, identifier, contentobject_name, creator_id, modifier_id,
created, remote_id, modified, is_container, always_available
FROM ezcontentclass
WHERE id='11' AND version='0'
ORDER BY version ASC
LIMIT 0, 2

Notice: eZMySQLDB::query(1 rows, 0.669 ms) query number per page:8 May 20 2006 16:53:40
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.name as class_name
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
WHERE ezcontentobject_tree.contentobject_id=65 AND
ezcontentobject_tree.main_node_id = ezcontentobject_tree.node_id AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id

Notice: eZMySQLDB::query(1 rows, 0.798 ms) query number per page:9 May 20 2006 16:53:40
SELECT
count(*) AS count
FROM
ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name

WHERE
path_string like '/1/2/65/%' and




ezcontentclass.version=0 AND
node_id != 65 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
)


AND
ezcontentobject.language_mask & 7 > 0

Notice: eZMySQLDB::query(1 rows, 0.743 ms) query number per page:10 May 20 2006 16:53:40
SELECT
count(*) AS count
FROM
ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name

WHERE
path_string like '/1/2/65/%' and




ezcontentclass.version=0 AND
node_id != 65 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
)


AND
ezcontentobject.language_mask & 7 > 0

Notice: eZMySQLDB::query(1 rows, 0.779 ms) query number per page:11 May 20 2006 16:53:40
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.name as class_name
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
WHERE contentobject_id=65 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
ORDER BY path_string

Notice: eZMySQLDB::query(-1 rows, 0.186 ms) query number per page:12 May 20 2006 16:53:40
CREATE TEMPORARY TABLE eznode_count_ ( count int )

Error: eZMySQLDB May 20 2006 16:53:40
Query error: Access denied for user '...'@'...' to database '...'. Query: CREATE TEMPORARY TABLE eznode_count_ ( count int )

Notice: eZMySQLDB::query(0 rows, 0.084 ms) query number per page:13 May 20 2006 16:53:40
UNLOCK TABLES

Error: eZDBInterface::commit TRANSID-14d2ae4553e8cdc7d44d43fff6cc3912 May 20 2006 16:53:40
Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-14d2ae4553e8cdc7d44d43fff6cc3912.

Notice: eZMySQLDB::query(0 rows, 0.123 ms) query number per page:14 May 20 2006 16:53:40
ROLLBACK


Timing points:
Checkpoint Elapsed Rel. Elapsed Memory Rel. Memory
Script start 0.0000 sec 0.1644 sec 1,533.5469KB 5,284.2109KB
Module start 'content' 0.1644 sec 6,817.7578KB 0.0049KB
Total runtime: 0.3007 sec

Time accumulators:
Accumulator Elapsed Percent Count Average
ini_load
Load cache 0.0192 sec 6.2057% 11 0.0017 sec
FindInputFiles 0.0096 sec 3.0957% 11 0.0009 sec
Mysql Total
Mysql_queries 0.0184 sec 5.9472% 15 0.0012 sec
Looping result 0.0006 sec 0.2039% 8 0.0001 sec
TS translator
TS init 0.0103 sec 3.3218% 2 0.0051 sec
TS cache load 0.0038 sec 1.2251% 2 0.0019 sec
TS context load 0.0017 sec 0.5536% 2 0.0009 sec
Template Total 0.0539 sec 17.4% 1 0.0539 sec
Template load 0.0119 sec 3.8515% 1 0.0119 sec
Template processing 0.0416 sec 13.4711% 1 0.0416 sec
override
Cache load 0.0095 sec 3.0714% 1 0.0095 sec
General
dbfile 0.0003 sec 0.0857% 2 0.0001 sec
Total script time: 0.3090 sec

______________________________________________________________________

Mir sagt das alles leider gar nichts

Samstag, 20. Mai 2006 19:02:47

Vielen Dank! Dieser Fehler hat sich erledigt.

Aber es gibt noch Probleme wegen der Aktivierung der Pakete - siehe anderes Posting...

Samstag, 20. Mai 2006 20:07:34

Hallo!

Danke für die schnelle Antwort

Ich nutze Version 3.8.

Die Fehlermeldung kommt jedesmal, wenn man im Adminbereich als Admin etwas löschen möchte - z.B. einen Artikel usw. Dadurch lässt sich momentan nichts löschen.

Wie ich gerade feststelle, erscheint die Fehlermeldung wirklich immer - z.B. auch dann, wenn man ein Paket deinstallieren will...
Also bei jeglichem Lösch- und Deinstallationsversuch.

Dienstag, 27. Juni 2006 09:02:22

... und NICHT das Problem!
Ich rate dringend davon ab den Kernel zu ändern!
Die Tabelle ist Temporär und sollte auch als solche erzeugt werden.
Bitte löst das Problem, indem ihr die Benutzerrechte des MySQL Benutzers anpasst.