Error: 2013 Lost connection to MySQL server during query -- after killing mysqld

MySQL & MariaDB Other MySQL® Questions
1

Would like to seek help to get an idea why this is happening:

  1. there was a stuck query running for half-a-day
  2. i forced kill the query as it does not seem to be doing anything
  3. query is already in killed status but still stuck ( it’s not doing any rollback based on innodb status )
  4. after 2 days i decided to stop mysql but it did not stop due to stuck query
  5. i forced kill mysql daemon and started mysql
  6. then this error kept happening after that. “General error: 2013 Lost connection to MySQL server during query”

May i know if anyone has encountered something similar? Would like to understand what caused the lost connection.

i have tried suggestion like increasing timeout and max_packet but to no avail. Thanks in advance.

2

just an update i set log_warning to 2 , i noticed this: (Got timeout reading communication packets)
but changing max_packet to 1GB it still did not help

3

never mind… it seems to be an issue with amazon elb as we have our db behind them :smiley: