Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
mysql - Lost connection to mysql server during query (2013)
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Networking & Security
View previous topic :: View next topic  
Author Message
uncleringo
Tux's lil' helper
Tux's lil' helper


Joined: 21 Jul 2004
Posts: 146

PostPosted: Mon Feb 20, 2006 5:10 pm    Post subject: mysql - Lost connection to mysql server during query (2013) Reply with quote

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
View user's profile Send private message
JeliJami
Veteran
Veteran


Joined: 17 Jan 2006
Posts: 1086
Location: Belgium

PostPosted: Mon Feb 20, 2006 8:30 pm    Post subject: Reply with quote

Are there any messages in the mysql logging?
_________________
Unanswered Post Initiative | Search | FAQ
Former username: davjel
Back to top
View user's profile Send private message
uncleringo
Tux's lil' helper
Tux's lil' helper


Joined: 21 Jul 2004
Posts: 146

PostPosted: Tue Feb 21, 2006 1:14 am    Post subject: Reply with quote

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
View user's profile Send private message
uncleringo
Tux's lil' helper
Tux's lil' helper


Joined: 21 Jul 2004
Posts: 146

PostPosted: Fri Feb 24, 2006 10:52 am    Post subject: Reply with quote

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
View user's profile Send private message
apryan
Tux's lil' helper
Tux's lil' helper


Joined: 31 Jan 2005
Posts: 124

PostPosted: Tue Mar 21, 2006 7:41 am    Post subject: Reply with quote

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
View user's profile Send private message
bedahr
n00b
n00b


Joined: 19 Oct 2005
Posts: 24

PostPosted: Sat Mar 25, 2006 4:16 pm    Post subject: Reply with quote

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
View user's profile Send private message
apryan
Tux's lil' helper
Tux's lil' helper


Joined: 31 Jan 2005
Posts: 124

PostPosted: Mon Mar 27, 2006 2:23 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Networking & Security All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum