MySQL Server has gone away on simple selectFixing “MySQL server has gone away” errorMySQL server has gone away occasionally on simple select querypython mysqldb - mysql server gone away - can't reconnectMySQL error 2006: mysql server has gone awayError 2006: MySQL server has gone awayWordPress - MySQL server has gone away2006: MySQL server has gone awayERROR 2006 (HY000): MySQL Server Has Gone Away… (HaProxy / Galera)MySQL extremely slow on very simple SELECT queriesHow to fix mysql has gone away, high writeiops, switch to postgres?
How can I end combat quickly when the outcome is inevitable?
Return a String containing only alphabets without spaces
Teaching a class likely meant to inflate the GPA of student athletes
Ability To Change Root User Password (Vulnerability?)
Origin of "boor"
Why is long-term living in Almost-Earth causing severe health problems?
Non-aqueous eyes?
How do free-speech protections in the United States apply in public to corporate misrepresentations?
How can I use String in enum for Apex?
Are inverted question and exclamation mark supposed to be symmetrical to the "normal" counter-parts?
Is using 'echo' to display attacker-controlled data on the terminal dangerous?
Can a human be transformed into a Mind Flayer?
How can one's career as a reviewer be ended?
Why did Intel abandon unified CPU cache?
What are some really overused phrases in French that are common nowadays?
I have a problematic assistant manager, but I can't fire him
Separate SPI data
Fermat's statement about the ancients: How serious was he?
How to hide rifle during medieval town entrance inspection?
What is the meaning of the Russian idiom "to taste tuna" ("отведать тунца")?
Should I refuse being named as co-author of a bad quality paper?
Will Roalesk, Apex Hybrid, trigger Sharktocrab twice?
Next date with distinct digits
Is it safe to change the harddrive power feature so that it never turns off?
MySQL Server has gone away on simple select
Fixing “MySQL server has gone away” errorMySQL server has gone away occasionally on simple select querypython mysqldb - mysql server gone away - can't reconnectMySQL error 2006: mysql server has gone awayError 2006: MySQL server has gone awayWordPress - MySQL server has gone away2006: MySQL server has gone awayERROR 2006 (HY000): MySQL Server Has Gone Away… (HaProxy / Galera)MySQL extremely slow on very simple SELECT queriesHow to fix mysql has gone away, high writeiops, switch to postgres?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I get a MySQL server has gone away error on a simple query.
mysql> select version();
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 1
A query such as select id from users limit 1; can also result in this error. Most search results are about inserts or imports so I'm not really sure what to do.
mysql
migrated from stackoverflow.com Nov 26 '11 at 2:26
This question came from our site for professional and enthusiast programmers.
add a comment |
I get a MySQL server has gone away error on a simple query.
mysql> select version();
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 1
A query such as select id from users limit 1; can also result in this error. Most search results are about inserts or imports so I'm not really sure what to do.
mysql
migrated from stackoverflow.com Nov 26 '11 at 2:26
This question came from our site for professional and enthusiast programmers.
What is your MySQL version? may you can find something useful on data directorymachinename.log or error.log.
– Moshe L
Nov 25 '11 at 13:37
+--------------+ | version() | +--------------+ | 5.1.49-1-log | +--------------+ 1 row in set (40.16 sec)
– John Smith
Nov 25 '11 at 13:40
add a comment |
I get a MySQL server has gone away error on a simple query.
mysql> select version();
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 1
A query such as select id from users limit 1; can also result in this error. Most search results are about inserts or imports so I'm not really sure what to do.
mysql
I get a MySQL server has gone away error on a simple query.
mysql> select version();
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 1
A query such as select id from users limit 1; can also result in this error. Most search results are about inserts or imports so I'm not really sure what to do.
mysql
mysql
asked Nov 25 '11 at 13:06
John Smith
migrated from stackoverflow.com Nov 26 '11 at 2:26
This question came from our site for professional and enthusiast programmers.
migrated from stackoverflow.com Nov 26 '11 at 2:26
This question came from our site for professional and enthusiast programmers.
What is your MySQL version? may you can find something useful on data directorymachinename.log or error.log.
– Moshe L
Nov 25 '11 at 13:37
+--------------+ | version() | +--------------+ | 5.1.49-1-log | +--------------+ 1 row in set (40.16 sec)
– John Smith
Nov 25 '11 at 13:40
add a comment |
What is your MySQL version? may you can find something useful on data directorymachinename.log or error.log.
– Moshe L
Nov 25 '11 at 13:37
+--------------+ | version() | +--------------+ | 5.1.49-1-log | +--------------+ 1 row in set (40.16 sec)
– John Smith
Nov 25 '11 at 13:40
What is your MySQL version? may you can find something useful on data directorymachinename.log or error.log.
– Moshe L
Nov 25 '11 at 13:37
What is your MySQL version? may you can find something useful on data directorymachinename.log or error.log.
– Moshe L
Nov 25 '11 at 13:37
+--------------+ | version() | +--------------+ | 5.1.49-1-log | +--------------+ 1 row in set (40.16 sec)
– John Smith
Nov 25 '11 at 13:40
+--------------+ | version() | +--------------+ | 5.1.49-1-log | +--------------+ 1 row in set (40.16 sec)
– John Smith
Nov 25 '11 at 13:40
add a comment |
1 Answer
1
active
oldest
votes
It's not the select, it very likely your interactive timeout setting. MySQL will shutdown idle connections after a period of time. So if you don't type anything for a while, MySQL will drop the connection. What you are seeing is an auto reconnect.
You can change your wait_timeout and interactive_timeout settings if you like. This is unlikely a problem in your code since it is never idle long enough for the connection to drop. Unless you have some long running code.
http://dev.mysql.com/doc/refman/5.1/en/gone-away.html
Well actually, I just opened mysql and that was my first query that I posted here. I'm using SSH and doing this with root access on both the server and mysql.
– John Smith
Nov 25 '11 at 13:53
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f334918%2fmysql-server-has-gone-away-on-simple-select%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
It's not the select, it very likely your interactive timeout setting. MySQL will shutdown idle connections after a period of time. So if you don't type anything for a while, MySQL will drop the connection. What you are seeing is an auto reconnect.
You can change your wait_timeout and interactive_timeout settings if you like. This is unlikely a problem in your code since it is never idle long enough for the connection to drop. Unless you have some long running code.
http://dev.mysql.com/doc/refman/5.1/en/gone-away.html
Well actually, I just opened mysql and that was my first query that I posted here. I'm using SSH and doing this with root access on both the server and mysql.
– John Smith
Nov 25 '11 at 13:53
add a comment |
It's not the select, it very likely your interactive timeout setting. MySQL will shutdown idle connections after a period of time. So if you don't type anything for a while, MySQL will drop the connection. What you are seeing is an auto reconnect.
You can change your wait_timeout and interactive_timeout settings if you like. This is unlikely a problem in your code since it is never idle long enough for the connection to drop. Unless you have some long running code.
http://dev.mysql.com/doc/refman/5.1/en/gone-away.html
Well actually, I just opened mysql and that was my first query that I posted here. I'm using SSH and doing this with root access on both the server and mysql.
– John Smith
Nov 25 '11 at 13:53
add a comment |
It's not the select, it very likely your interactive timeout setting. MySQL will shutdown idle connections after a period of time. So if you don't type anything for a while, MySQL will drop the connection. What you are seeing is an auto reconnect.
You can change your wait_timeout and interactive_timeout settings if you like. This is unlikely a problem in your code since it is never idle long enough for the connection to drop. Unless you have some long running code.
http://dev.mysql.com/doc/refman/5.1/en/gone-away.html
It's not the select, it very likely your interactive timeout setting. MySQL will shutdown idle connections after a period of time. So if you don't type anything for a while, MySQL will drop the connection. What you are seeing is an auto reconnect.
You can change your wait_timeout and interactive_timeout settings if you like. This is unlikely a problem in your code since it is never idle long enough for the connection to drop. Unless you have some long running code.
http://dev.mysql.com/doc/refman/5.1/en/gone-away.html
answered Nov 25 '11 at 13:50
Brent Baisley
Well actually, I just opened mysql and that was my first query that I posted here. I'm using SSH and doing this with root access on both the server and mysql.
– John Smith
Nov 25 '11 at 13:53
add a comment |
Well actually, I just opened mysql and that was my first query that I posted here. I'm using SSH and doing this with root access on both the server and mysql.
– John Smith
Nov 25 '11 at 13:53
Well actually, I just opened mysql and that was my first query that I posted here. I'm using SSH and doing this with root access on both the server and mysql.
– John Smith
Nov 25 '11 at 13:53
Well actually, I just opened mysql and that was my first query that I posted here. I'm using SSH and doing this with root access on both the server and mysql.
– John Smith
Nov 25 '11 at 13:53
add a comment |
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f334918%2fmysql-server-has-gone-away-on-simple-select%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
What is your MySQL version? may you can find something useful on data directorymachinename.log or error.log.
– Moshe L
Nov 25 '11 at 13:37
+--------------+ | version() | +--------------+ | 5.1.49-1-log | +--------------+ 1 row in set (40.16 sec)
– John Smith
Nov 25 '11 at 13:40