MySQL Forums
Forum List  »  MySQL Administrator

ERROR 2013 (HY000): Lost connection to MySQL server at 'sending authentication information', system error: 32
Posted by: Mic Mok
Date: June 07, 2009 02:54PM

Hi,

I am having sporadic connection failures when trying to connect locally to the server.
The failure message returns in 4+ seconds, of which no CPU time is used (sounds like a timeout to me...)
The server is configured with skip-networking, so there is no connectivity issue.
There are enough "free" connections.

Any idea what can that be?

#
# time test
#
$time mysql -u *** -p*** -D *** -e "select count(*) from ***;"
ERROR 2013 (HY000): Lost connection to MySQL server at 'sending authentication information', system error: 32

real 0m4.148s
user 0m0.005s
sys 0m0.002s

#
# Test connections
#
mysql> show processlist;
+-------+-----+-----------+-----+---------+------+-------+------------------+
| Id | User| Host | db | Command | Time | State | Info |
+-------+-----+-----------+-----+---------+------+-------+------------------+
| 47716 | *** | localhost | *** | Query | 0 | NULL | show processlist |
| 47722 | *** | localhost | *** | Sleep | 0 | | NULL |
+-------+-----+-----------+-----+---------+------+-------+------------------+
mysql> show variables like "%connection%";
+--------------------------+-------------------+
| Variable_name | Value |
+--------------------------+-------------------+
| character_set_connection | latin1 |
| collation_connection | latin1_swedish_ci |
| max_connections | 500 |
| max_user_connections | 0 |
+--------------------------+-------------------+

Options: ReplyQuote


Subject
Written By
Posted
ERROR 2013 (HY000): Lost connection to MySQL server at 'sending authentication information', system error: 32
June 07, 2009 02:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.