CloudSql databases lost suddenly

Google Cloud Database
1

Hi,

I’m running cloud sql(mysql :smiling_face_with_sunglasses: and suddenly it lost the databases I was using.
Again and again it happened. I restored the database.

please anyone know the reason for this.

regards.

1 Like
2

Hi @Haritha_Kawshan ,

Welcome to Google Cloud Community!

I’m sorry to hear that you are experiencing issues with your Google Cloud SQL databases. There are several potential causes for a database to become lost or unavailable. Some possible causes could include:

  • Hardware or infrastructure issues
  • Network connectivity problems
  • Configuration errors
  • Incorrect usage of the database or database management tools
  • Data corruption or other database errors
    Without more information about your specific situation, it is difficult to determine the exact cause of the issue.

To troubleshoot and resolve the issue, it might be helpful to try the following:

  • Check the Cloud SQL logs for error messages or other clues about the cause of the problem
  • Verify that the database instance is running and healthy
  • Check for any recent changes that might have caused the issue (e.g., configuration changes, new code deployments, etc.)
  • Check for any known issues or maintenance events that could be affecting your database instance
    If you are unable to resolve the issue on your own, you may want to consider reaching out to Google Cloud Support for further assistance. They may be able to provide more specific guidance based on your specific situation.

Thank you

2 Likes
3

Hi!

I had the same problem and couldn’t find any solution, the databases I created automatically disappeared after about a day.

I just recreated a database named “laptopshop” at 11:00 AM December 29, 2023 and when I checked again at 19:00 PM the same day, the database had been deleted.
Below is the log file link that I downloaded during the above mentioned period.
https://drive.google.com/file/d/18KKsZZzZQVVbytTGW1ttt_li8RuaJrGV/view?fbclid=IwAR3ZYnOdpOve-i8y6nnL4Ze1Pjy_okeSq0rxVsPcGOFoaQDLEdXf2LBcF9A

Please help me!

1 Like
4

I am facing the exact same issue. were you able to find a solution?

1 Like
5

I am also facing same issue with Postgres. Found any solution?

1 Like