Not the answer you need?
Register and ask your own question!

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

nhadie.monionhadie.monio EntrantCurrent User Role Beginner
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.

Comments

  • nhadie.monionhadie.monio Entrant Current User Role Beginner
    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
  • nhadie.monionhadie.monio Entrant Current User Role Beginner
    never mind.. it seems to be an issue with amazon elb as we have our db behind them :D
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.