Hello everyone,
We have a 5.7 Mysql instance that's been up and running for about a month without any problem. Since Saturday night, during an automated maintenance operation, we can't access it anymore.
All we can see is an "Unknown Error" on Cloud SQL console.
Investigating through the instance logs, exposes the following alert row:
2020-10-03T23:31:21.311568Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
We already tried recovering 3 different backups, even older ones, on the same instance and on new instances, without luck.
Our customer is now stuck, any help would be appreciated.
Thanks in advance,
Gabriele Volpato