Error 3024: Query execution was interrupted, maximum statement execution time exceeded

Error Code	SQLSTATE	Error	Description
3024		ER_QUERY_TIMEOUT	Query execution was interrupted, maximum statement execution time exceeded

Possible Causes and Solutions

The cause is that the executing statement took more than max_statement_time (primary) or slave_max_statement_time (replica) to execute.

To fix this, you have to either increase the value of max_statement_time or find out why the query is slow. Start by doing an EXPLAIN or ANALYZE on the query to find out how the query is executed.

See Also

• Aborting Statements that Exceed a Certain Time to Execute

_{This page is licensed: CC BY-SA / Gnu FDL}