Details
-
Improvement
-
Resolution: Fixed
-
Medium
-
4.2.0, 4.3.0, 4.4.0, 4.5.0alpha
-
None
Description
This probably applies to the DB cluster as well.
From customer issue:
----------------
UPDATE ezdfsfile SET mtime=-ABS(mtime), expired=1
WHERE name like 'var/storage/images/path/path/filename/424242-1-ger-DE/filename.gif/%' s,j3789716 0.7958115183246073 152000
This happens when I delete image from the trash. You shouldn't match by like. Our dfs table has nearly 3 Million items.
----------------
Steps to reproduce
- Perform any "name LIKE" query on a huge DFS database.
Attachments
Issue Links
- relates to
-
EZP-18594 Moving content object within datatype ezimage to trash causing DB Transaction error.
- Closed