My RDS MySQL instance behaves weirdly and and in about a month, it wipes off all my tables.

{"code":"ER_NO_SUCH_TABLE","errno":1146,"sqlMessage":"Table 'nfs.registration_requests' doesn't exist","sqlState":"42S02","index":0,"sql":"SELECT* FROM registration_requests"}

enter image description here

All I could find in the logs were such errors:

2020-06-25T05:09:00.804365Z 15776 [Warning] Host name 'zg-0624a-49.stretchoid.com' could not be resolved: Name or service not known`----------------------- END OF LOG ----------------------`

The instance seems to be in good health:

enter image description here

How can I diagnose this problem?

  • you should conatct the support and see if they had backups, and in future make backups – nbk Jun 26 at 8:54
  • I had the snapshots luckily and restored them, their support costs 30$ per month, outrageous. – Mammadbayli Jun 26 at 9:16
  • Perhaps a permissions problem? – Rick James 2 days ago
  • i.stack.imgur.com/BfVtG.png please have a look at this image, doesnt seem to be a permission issue, I cannot even list tables. – Mammadbayli yesterday

I'd suggest that something else is going on. Database corruption doesn't result in neatness. You get lots of errors. This looks like something or someone is issuing DROP TABLE statements. Turn on the audit log to see what's happening on the system.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.