Details
-
Bug
-
Resolution: Fixed
-
Medium
-
4.0.5, 4.1.2
-
None
Description
When launching frequent cronjob part, I've got :
Running cronjob part 'frequent' Running cronjobs/notification.php Starting notification event processing Fatal error: A database transaction in eZ Publish failed. The current execution was stopped to prevent further problems. You should contact the System Administrator (dpobel@free.fr) of this site. The current transaction ID is TRANSID-86dc94e5af5b2a31e6c5a6e54e774c43 and has been logged. Please include the transaction ID and the name of the current script when contacting the system administrator.
Looking at mysql query log, I can see the following SQL query :
SELECT DISTINCT user_node.node_id,
user_node.path_string,
user_tree.contentobject_id
FROM ezcontentobject_tree user_node,
ezcontentobject_tree user_tree
WHERE user_node.node_id IN ( ) AND
user_node.path_string like concat( user_tree.path_string,'%' )
Steps to reproduce
1. Edit a node
2. Run "frequent" cronjob part
Attachments
Issue Links
- relates to
-
EZP-14904 Too long query time in eZSubtreeNotificationRule::fetchUserList()
- Closed