Using the MYSQL command –line client you have received the error “Lost connection to
MYSQL server query”
Which three are possible causes of the error?
A.
The MYSQL server stopped working during query execution.
B.
The network connection was interrupted during query execution.
C.
The connection that issued the query was killed.
D.
The client connection stayed idle for longer than interactive –timeout seconds and was
closed.
E.
The client sent an erroneous query to the server causing the connection to be closed.
F.
The server interrupted client connection after max-connect-errors was achieved.
B
https://dev.mysql.com/doc/refman/5.6/en/error-lost-connection.html
BD
https://dev.mysql.com/doc/refman/5.6/en/gone-away.html
This section also covers the related Lost connection to server during query error.
D:The most common reason for the MySQL server has gone away error is that the server timed out and closed the connection. | You are using a Windows client and the server had dropped the connection (probably because wait_timeout expired) before the command was issued.
Maybe C:You (or the db administrator) has killed the running thread with a KILL statement or a mysqladmin kill command.
I couldn’t Find anything on E or F.
B D F
https://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_max_connect_errors
https://dev.mysql.com/doc/refman/5.7/en/error-lost-connection.html
BD confirmed, the last one i stand on E
BDE
BCD, i tried C
Lost connection and Has gone away are different errors.
So answer should be BEF.
Usually it indicates network connectivity trouble and you should check the condition of your network if this
error occurs frequently. If the error message includes “during query,” this is probably the case you are
experiencing