Tuesday, November 19, 2019

[google-cloud-sql-discuss] Tablespace **** exists

Hi Google Cloud SQL team,

When running a Google Cloud Mysql instance, second generation with MySQL 5.7, we are stuck with one ghost tablespace that cannot be deleted.
The error that we have if we want to create the table that has been dropped not cleanly is "Tablespace `users`' exists."
This tablespace cannot be dropped and is not visible when using :
SELECT LOGFILE_GROUP_NAME, FILE_NAME, EXTRA
     FROM INFORMATION_SCHEMA.FILES;

It seems that the file './users.ibd' has not be cleaned and cannot be cleaned.

Maybe we are missing something, can you please have a look at that or tell us what we can do?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/a3f1fe81-c30e-41e5-891f-b9e6d2e7191b%40googlegroups.com.

No comments:

Post a Comment