The MySQL server is running with the LOCK_WRITE_GROWTH option so it cannot execute this statement

The error message "The MySQL server is running with the LOCK_WRITE_GROWTH option so it cannot execute this statement" indicates that the MySQL server is currently configured with the LOCK_WRITE_GROWTH option enabled, which prevents certain types of statements from being executed.

This option is used to control the growth of the InnoDB tablespace, and when it is enabled, some DDL statements such as ALTER TABLE and CREATE INDEX may be blocked.

To resolve this issue, you can try disabling the LOCK_WRITE_GROWTH option by running the following command:

SET GLOBAL innodb_locks_unsafe_for_binlog=1;

Note that disabling this option may have an impact on the performance of your MySQL server, so you should carefully consider the consequences before making any changes. It is also recommended to consult the MySQL documentation or seek assistance from a qualified database administrator before making any changes to your MySQL configuration.