View previous topic :: View next topic |
Author |
Message |
uncleringo Tux's lil' helper
![Tux's lil' helper Tux's lil' helper](/images/ranks/rank_rect_1.gif)
![](images/avatars/gallery/Southpark/avatar13.gif)
Joined: 21 Jul 2004 Posts: 146
|
Posted: Mon Feb 20, 2006 5:10 pm Post subject: mysql - Lost connection to mysql server during query (2013) |
|
|
A slightly strange one here...
We've a server with MySQL 5.0.18 running, and a user set up who can connect from any IP (we have to do this right now since we've no fixed IP address). The strange thing is that sometime during the last hour we've lost the ability to connect to this server from one of our machines. Earlier we could connect successfully to it with both our machines here, but now only mine can connect and the other constantly gets the above message:
Error: Lost connection to mysql server during query (2013)
Our client machines are sat behind a single adsl ip, so I was wondering if somehow it was only letting one connection from an IP or something. But I cant see that that's the case since we were both connected a short while ago. Is there a config option for this kind of thing?
Any light shed on this problem would be greatly appreciated (other posts seem to not get any useful responses) |
|
Back to top |
|
![](templates/gentoo/images/spacer.gif) |
JeliJami Veteran
![Veteran Veteran](/images/ranks/rank_rect_5_vet.gif)
![](images/avatars/148526789243d7753a09b11.jpg)
Joined: 17 Jan 2006 Posts: 1086 Location: Belgium
|
|
Back to top |
|
![](templates/gentoo/images/spacer.gif) |
uncleringo Tux's lil' helper
![Tux's lil' helper Tux's lil' helper](/images/ranks/rank_rect_1.gif)
![](images/avatars/gallery/Southpark/avatar13.gif)
Joined: 21 Jul 2004 Posts: 146
|
Posted: Tue Feb 21, 2006 1:14 am Post subject: |
|
|
No, I've checked the error log and nothing abnormal is recorded there. Although having just checked the documentation it seems that the general log would tell me more useful information about connections, so i've just enable it. Won't be able to test until tomorrow, but I'll come back with results asap.
Thanks |
|
Back to top |
|
![](templates/gentoo/images/spacer.gif) |
uncleringo Tux's lil' helper
![Tux's lil' helper Tux's lil' helper](/images/ranks/rank_rect_1.gif)
![](images/avatars/gallery/Southpark/avatar13.gif)
Joined: 21 Jul 2004 Posts: 146
|
Posted: Fri Feb 24, 2006 10:52 am Post subject: |
|
|
I dont know what the problem was, but it seems to have been ok since. Perhaps it's an issue with the client machine acting up. Who knows!
I'll post back if there are further problems |
|
Back to top |
|
![](templates/gentoo/images/spacer.gif) |
apryan Tux's lil' helper
![Tux's lil' helper Tux's lil' helper](/images/ranks/rank_rect_1.gif)
Joined: 31 Jan 2005 Posts: 124
|
Posted: Tue Mar 21, 2006 7:41 am Post subject: |
|
|
If you issue a google search for "Lost connection to MySQL server during query" there seems to be a lot that turns up. Anyone out there find a solution? |
|
Back to top |
|
![](templates/gentoo/images/spacer.gif) |
bedahr n00b
![n00b n00b](/images/ranks/rank_rect_0.gif)
Joined: 19 Oct 2005 Posts: 24
|
Posted: Sat Mar 25, 2006 4:16 pm Post subject: |
|
|
I had got the same error here, and figured out that another connection blocked.
I had a shell open, with mysql running (the client) and I had to exit there first...
Worked.
Hope it'll work for you too...
(Maybe theres a config line to set how many user can connect simultaneously)
cu,
bedahr |
|
Back to top |
|
![](templates/gentoo/images/spacer.gif) |
apryan Tux's lil' helper
![Tux's lil' helper Tux's lil' helper](/images/ranks/rank_rect_1.gif)
Joined: 31 Jan 2005 Posts: 124
|
Posted: Mon Mar 27, 2006 2:23 am Post subject: |
|
|
Thanks. For me it seemed that mysql was binding to only the local address. I removed the bind in my.cnf and it worked. |
|
Back to top |
|
![](templates/gentoo/images/spacer.gif) |
|