The Ultimate Guide to High Availability with MariaDB

Lock wait timeout exceeded issue on ALTER/DROP statements to a InnoDB table

Hi all,

I have an InnoDB table which prevents me to add a column; whatever I have tried - drop inclusive - the error is as follow:

Lock wait timeout exceeded; try restarting transaction

Drop of the related database was also not possible: all tables except the problematic one was dropped and in result the database was stayed.

I don't understand the root problem, because there is no access/transaction to this instance (currently Idle).

How can I solve this issue, thank you for your assistance in advance.

MariaDB version: 10.8.6 OS: Oracle Linux

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.