Bug #3869 MYSQL database server shuts down after using system for few hours.
Submitted: 24 May 2004 5:12 Modified: 24 Jun 2004 7:24
Reporter: Mohammad Siddiqui Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.0.18 OS:Microsoft Windows (Windows Server 2003)
Assigned to: CPU Architecture:Any

[24 May 2004 5:12] Mohammad Siddiqui
Description:
MYSQL database server shuts down after using system for few hours. 

How to repeat:
We are using MYSQL 4.0.18 for application deployed on JBOSS. When we 
manage catalog for few hours doing basic update/Delete/Add. MYSQL Server shuts down.
[24 May 2004 5:34] Miguel Solorzano
You need to provide more information for us to try to repeat
your bug report. Like a repeatable test case.

Thanks.
[24 May 2004 5:58] Mohammad Siddiqui
It seems when number of application connections increases database server Could not create connection. Issue is sporadic. When client uses application 5 to 6 hours it shurs down server. It is OK if server slows down with increase number of connections but shutting down is frustating my clients.

Here is error message when accessing jboss appication.

HTTP ERROR: 500 SQLException: Could not create connection; - nested
throwable: (java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?); - nested throwable:
(org.jboss.resource.ResourceException: Could not create connection; - nested
throwable: (java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?)) RequestURI=/jrt/index.jsp
[24 May 2004 6:20] Miguel Solorzano
I assume that you have configured adequately the below
server configuration key for your system needs:

C:\mysql\bin>mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.0.18-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show variables like "%max_connection%";
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 100   |
+-----------------+-------+
1 row in set (0.00 sec)

the above is the default value.

also please read the below MS's support articles and search for
another related ones:

ttp://support.microsoft.com/default.aspx?scid=kb;en-us;196271
[24 May 2004 7:08] Mohammad Siddiqui
Default is set to 100. I think default 100 is too low for application we are using.I want to change server variable "max_connections" to 500.

I have used this command Set global max_connections =500. It sets server variable to 500 but when I restarts MYSQL Server it resets back to 100. 
is there way I can permanently change server variable?
[24 May 2004 7:24] Miguel Solorzano
You only need to add the below to the [mysqld] section in
your my.ini or my.cnf configuration file:

[mysqld]
max-connections=500
....

C:\mysql\bin>mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.18-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show variables like "%max_connection%";
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 500   |
+-----------------+-------+
1 row in set (0.00 sec)
[14 Feb 2005 22:54] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".