> -----Original Message-----
> From: ISP Lists [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, August 24, 2005 10:21 AM
> To: vchkpw@inter7.com
> Subject: Re: [vchkpw] Spotty behavior authenticating: MySQL 
> server has gone away
> 
> > Something peculiar happened to mysql during a reboot and 
> now vpopmail 
> > authdaemond is having trouble completing authentications....
> >
> > /var/log/maillog says:
> >
> > Aug 24 08:36:15 hostname authdaemond: vmysql: sql error[3]: MySQL 
> > server has gone away
> >
> >
> > This problem is spotty though.  I have several successful 
> > authentications before this error occurs.  I then have to restart 
> > mysqld before I can get any other authentications to succeed.  I am 
> > still able to use the mysql client to connect to the server 
> for an interactive session.
> >
> > What seems strange to me is that there are only two mysql 
> daemons running:
> >
> > root     23923  0.0  0.1  5060 1108 pts/0    S    09:13   
> 0:00 /bin/sh
> > /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf 
> > --pid-file=/var/run/mysqld/mysqld.pid
> >
> > mysql    23956  0.0  0.5 38620 5656 pts/0    Sl   09:13   0:00
> > /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/var/lib 
> > --datadir=/var/lib/mysql --user=mysql 
> > --pid-file=/var/run/mysqld/mysqld.pid --skip-locking
> >
> >
> > Every other instance of mysql 3.23.x I've ever run has 
> about 10 child 
> > threads running, so this seems strange to see only one child thread.
> >
> > I have not updated any packages on this box recently.  None 
> at all, I 
> > swear.
> >
> > Suggestions to investigate?  Googling on the "MySQL server 
> has gone away"
> > is a wild goose chase.
> >
> >
> >
> >
> >
> 
> Hrm, rebooting the box seems to have helped.  Still same 
> number of mysql daemons, but they're answering now...  Damned 
> strange.  dmesg on reboot didn't show any ext3 errors being 
> fixed - I was wondering if this was a disk thing.
> 
> Thoughts still welcome and appreciated on this.
> 

In you're /etc/my.cnf, add a variable to increase max_connections

[mysqld]
set-variable = max_connections=500

I had a similar problem with Mysql gone away error, and this solved it
for me.

D

Reply via email to