2

I have a AWS RDS MySQL 5.6.27 instance which was working perfectly fine. I did a alter on my table by executing this command.

ALTER TABLE images 
CHANGE `created_timestamp` `created_timestamp` TIMESTAMP DEFAULT CURRENT_TIMESTAMP

After this I am unable to connect to this table at all. A select query on this table gives

Error 2013 Lost connection to mysql.

I was able to query other tables.

How can I make it to work like before?

Thanks in advance.

beerwin
  • 9,813
  • 6
  • 42
  • 57
user3135635
  • 21
  • 2
  • The MySQL Error Log is [accessible from the RDS console](http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.Concepts.MySQL.html). Anything there? – Michael - sqlbot May 21 '17 at 01:30
  • check what is cpu utilization after that query , may be your process did no succeeded yet . Also, check https://stackoverflow.com/questions/7432241/mysql-show-status-active-or-total-connections out – tom May 27 '17 at 17:05
  • Having the same problem here.. Did you ever solve it? – Simba Nov 21 '22 at 23:24

0 Answers0