From: P.V.Anthony
Date: November 6 2004 5:00pm
Subject: Re: AW: connection problem with 4.1.7
List-Archive: http://lists.mysql.com/mysql/175383
Message-Id: <418D0322.6060101@singnet.com.sg>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

> 
> Hi,
> 
> I am having an intermitten connection problem with MySQL 4.1.7 .
> 
> Here is the setup.
> 
> Intel P4 with HT
> Fedora Core 1 kernel 2.4.27 smp
> MySQL version 4.1.7 (RPM install from mysql.org)
> Qmail with vpopmail using mysql (www.qmailtoaster.com)
> 
> Sometimes I cannot login to qmail to check mail. Using thunderbird or 
> even webmail.
> 
> Only way to solve the problem is to restart MySQL. Then everything is 
> ok. After maybe 2 hours the same problem again.
> 
> I am concluding that this is a MySQL problem because other apps that use 
>   MySQL also shows problems.
> 
> qmail vpopmail is using socket and my cms (WebGUI) is using tcp to connect.
> 
> I have tried to check the logs at /var/lib/mysql. But do not see 
> anything any error. I do see a warning like this,
> 041106  9:50:59 [Warning] Asked for 196608 thread stack, but got 126976
> 
> The strange thing is that I can still connect to MySQL using webmin.
> 
> Is there any other thing I can do to find out what is causing the 
> problem? Maybe I have made some silly mistake.
> 
> Please advice and help.
> 
> P.V.Anthony

Kostas Pyliouras wrote:
 > Hi,
 >
 > When you have this problem, do the MySQL client applications work? 
Have you tried logging in with the mysql client?
 >
 > Kostas
 >

Thank you very very very much for replying.

Yes, I can login with mysql client. I can even login using webmmin.

Here is another strange thing. Once I have logged in using mysql client 
then everything works again. I do not have to restart MySQL. This is 
very very strange. What could be the problem?

There is no error in the error log file.

Is there any other place I have to look at?

Please do continue to help.

P.V.Anthony