The web site allows users to upload files and currently stores +400,000 files. These files can be large PDF files. We have moved to a new server and the user is receiving a “Gateway Timeout” error after 90s when uploading a file. The file uploads successfully, however I also see this error in the log, usually in groups of 2 or 3 users within seconds of each other:
SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
The SQL statement causing this error is:
UPDATE TreeNodes SET dateModified = ? WHERE treeNodeID = ?’ with params [“2024-09-04 13:39:41”, “7”]:
Tree Node record ID=7 refers to the root folder of the file repository. A second attempt to upload the file typically succeeds. This is an intermittent error, not repeatable. Any advice on why this query would be receiving a timeout?
Concrete CMS version: 9.2.4