Sample Header Ad - 728x90

AWS MYSQL RDS db instance freezes

1 vote
0 answers
64 views
Ok I'm facing a real crazy issue, I usually connect through AWS VPN Client Endpoint normally and I can access my database. Today I tried and TablePlus just froze, checked if I'm connected through mysql in the terminal and I'm connected, but when I use for example
backend;
it freezes on
table information for completion of table and column names You can turn off this feature to get a quicker startup with -A
I try with -A and it works fine till I for example tried
* from table_1 limit 10
worked fine, but made the limit 20, it froze again. Retried again and asked for the count, worked fine, tried a specific row after 20 it returned fine, tried
table_1
and nothing is corrupted, checked for stuck transactions/processes and nothing was there. Rebooted the rds and still. I even increased from t3.micro to large (I know it's still tiny but I have only 10,000 rows total max) and nothing changed it still freezes and I can't access the database. Spent the whole day debugging with AI but still reached a dead end. I checked CloudWatch logs, all I found was there was an update to mysql done on April 7th, I tried upgrading to 8.4.4 maybe it would fix it but still freeze issue. Another thing from my logs was
-04-28T20:55:07.997349Z 22 [Warning] [MY-010055] [Server] IP address 'xxx.xx.xx.xxx' could not be resolved: Name or service not known
and everyday it's a different ip (I run a cron job everyday), I checked the subnet with that ip in it's range and it's configured correctly. I also created another instance but in the same VPC and it had the same freeze issue. Any help would be appreciated!
Asked by Mohammed Elbaz
Apr 28, 2025, 11:23 PM
Last activity: Apr 29, 2025, 01:31 AM