search

MariaDB / mariadb-docker

Docker Official Image packaging for MariaDB
https://mariadb.org
GNU General Public License v2.0
767 stars 438 forks source link

There is a strange error when trying to recreate a table after deleting it. #569

Closed Soo-yeong closed 6 months ago

Soo-yeong commented 7 months ago

If you accidentally create a table with the same name first and then do a drop table, even if the drop table succeeds, it will appear as a table that already exists when you create a table later. The problem is that this problem is solved only by restarting the server without eating Flush Tables. Please solve it! Or I hope you can tell me how I can solve this problem.

grooverdan commented 7 months ago

If you accidentally create a table with the same name first and then do a drop table, even if the drop table succeeds, it will appear as a table that already exists when you create a table later.

How?

The problem is that this problem is solved only by restarting the server without eating Flush Tables.

Please solve it! Or I hope you can tell me how I can solve this problem.

Provide a detailed reproducer - exact SQL commands and there reponses. Include the MariaDB version. "strange error" isn't that specific.