Oleksiy

Same bug described here.

mysql> SHOW TABLE STATUS WHERE Name = ‘cerber_log’;

+------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------------+----------+----------------+---------------------+
| Name       | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation       | Checksum | Create_options | Comment             |
+------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------------+----------+----------------+---------------------+
| cerber_log | InnoDB |      10 | Compact    |    0 |              0 |       16384 |               0 |        49152 |         0 |           NULL | NULL        | NULL        | NULL       | utf8_general_ci |     NULL |                | Cerber activity log |
+------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------------+----------+----------------+---------------------+
1 row in set (0.00 sec)

We’ve just got the same lock with the latest plugin version. Hosted under AWS Aurora (MySQL) and Beanstalk Multi-site version with HyperDB enabled.

|
| 877151 | dbuser | xxx.xxx.xxx.xxx:33466 | dbname | Query | 60542 | Waiting for table level lock | OPTIMIZE TABLE cerber_log |
| 877152 | dbuser | xxx.xxx.xxx.xxx:33468 | dbname | Query | 60542 | Waiting for table metadata lock | OPTIMIZE TABLE cerber_log |
| 877492 | dbuser | xxx.xxx.xxx.xxx:39848 | dbname | Query | 59013 | Waiting for table metadata lock | INSERT INTO cerber_log (ip, ip_long, user_login, user_id, stamp, activity, session_id, country, deta |
| 877494 | dbuser | xxx.xxx.xxx.xxx:36054 | dbname | Query | 58983 | Waiting for table metadata lock | INSERT INTO cerber_log (ip, ip_long, user_login, user_id, stamp, activity, session_id, country, deta |
…

same error…