MySQL Workbench lost connection to MySQL server (after 600 seconds)MySQL Workbench lost connection to MySQL server (after 600 seconds)

Running a query that takes longer than 600 seconds in MySQL Workbench I lose my connection to MySQL server.
I get the following error messages:
Error Code: 2013 Lost connection to MySQL server during query 600.495 sec
Error Code: 2006 MySQL server has gone away

Here is the solution to set a higher timout value :
Go to Edit -> Preferences -> SQL Editor and set to a higher value this parameter: DBMS connection read time out (in seconds). For instance: 86400.
Close and reopen MySQL Workbench. Kill your previously query that probably is running and run the query again.

Running a query that takes longer than 600 seconds in MySQL Workbench I lose my connection to MySQL server.
I get the following error messages:
Error Code: 2013 Lost connection to MySQL server during query 600.495 sec
Error Code: 2006 MySQL server has gone away

Here is the solution to set a higher timout value :
Go to Edit -> Preferences -> SQL Editor and set to a higher value this parameter: DBMS connection read time out (in seconds). For instance: 86400.
Close and reopen MySQL Workbench. Kill your previously query that probably is running and run the query again.

Hinterlasse eine Antwort

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind markiert *

Du kannst folgende HTML-Tags benutzen: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>