Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "how to solve the error report when the table is stuck on the MySQL end". In the operation of the actual case, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

[problem description]

Mysql delete table is stuck. Report: waiting for table metadata lock | DROP TABLE 'app'.' App' table deletion failed to get stuck, other tables can operate normally.

Please refer to the attachment for details.

[solution]

View the orchestration node and data node logs and flip through the ERROR logs from back to front. From the attachment log and the detailed log file provided by the customer, it is located that the data file is corrupted due to the abnormal operation, which leads to the above problem. Recommendations:

1. The corrupted file is on the standby node

a. Stop node, execute bin/sdbstop-p stop node

b. Go to the node data directory (database/data/)

c. Delete standby node data files (* .data, * .idx) and synchronization log files (replicalog/*)

d. Start the node and wait for data synchronization to be completed.

two。 If the corrupted file is on the primary node

a. Stop the primary node and wait for the node to re-select the master

b. Delete the data file and synchronization log file, and start the node, as in step 1

[description]

Deleting a file is a dangerous operation and is not recommended unless there is a special exception. Please check with the maintenance / development engineer and use it with caution.

"MySQL end delete table stuck how to solve the error report" content is introduced here, thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.