#6259 - Optimise/fix database tables = 504

By Adam Edington
Added 3rd Aug 2025, 10:22 PM
7 views

Identifier	#6259
Issue type	Minor issue (breaks specific functionality)
Title	Optimise/fix database tables = 504
Status	Open
Handling member	Deleted
Version	10.0.52
Addon	core
Description	Optimise/fix database tables keeps resulting in a 504 error. I am not sure if refreshing the page is allowing the optimisation to continue, or restarting the process from scratch. I assume it is carrying on with the task, but I am not 100% sure.
Steps to reproduce
Funded?	No

The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".

Rating

Unrated

Comments

By Guest posted 3rd Aug 2025, 11:16 PM

This has been an issue particularly with the stats table. 504 is gateway timeout. MySQL takes a long time to optimise stats, and the server gives up waiting.

The task *does* continue, but only for the table which was being optimised at the time of the timeout (later tables don't get optimised).

I recommend using MySQL CLI directly to run these operations instead.

In the future I hope to have actual INNODB support, but that really depends on my availability to implement it.