Bug #13235 On Windows if count of cached thread's excesed you get the following errors

• Submitted: 15 Sep 2005 17:28
• Modified: 16 Sep 2005 16:02
• Reporter: August Pavelko
• Status: Can't repeat
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.1.13
• OS: Windows (Windows)
• CPU Architecture: Any

[15 Sep 2005 17:28] August Pavelko

Description:
On Windows if count of cached thread's excesed  and connect from not local host you get the following errors

"Forcing close of thread 1  user: 'someuser'"

These errors are written to the error log only on Windows.

mysql server don't respond for connections and cannot be restarted by servicecontrol manager,
only kill process in task manager and run again help

How to repeat:
simulate many connections from not local host, bigger than thread_cache_size

[16 Sep 2005 16:02] Valeriy Kravchuk

I was unable to repeat on 4.1.14-nt:

C:\Documents and Settings\openxs>mysql -uroot -p
Enter password: ****
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.14-nt

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

mysql> use test;
Database changed
mysql> show variables like 'thread%';
+-------------------+--------+
| Variable_name     | Value  |
+-------------------+--------+
| thread_cache_size | 1      |
| thread_stack      | 196608 |
+-------------------+--------+
2 rows in set (0.00 sec)

mysql> grant all on test to user1 identified by 'user1';
Query OK, 0 rows affected (0.02 sec)

So, thread_cache_size = 1. Then, from the other, Linux host:

[openxs@Fedora 4.1]$ bin/mysql -h 192.168.0.1 -P 3306 -u user1 -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 4.1.14-nt

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

mysql>
[3]+  Stopped                 bin/mysql -h 192.168.0.1 -P 3306 -u user1 -p
[openxs@Fedora 4.1]$ bin/mysql -h 192.168.0.1 -P 3306 -u user1 -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 4.1.14-nt

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

mysql>
[4]+  Stopped                 bin/mysql -h 192.168.0.1 -P 3306 -u user1 -p
[openxs@Fedora 4.1]$ ps -ef | grep user1
openxs    8987  8439  0 18:54 pts/1    00:00:00 bin/mysql -h 192.168.0.1 -P 3306 -u user1 -p
openxs    8988  8439  0 18:54 pts/1    00:00:00 bin/mysql -h 192.168.0.1 -P 3306 -u user1 -p

So, we have 2 remote session from a non-root user. And the only thing in the log is:

050916 18:50:53  InnoDB: Started; log sequence number 0 77390
C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: ready for connections.
Version: '4.1.14-nt'  socket: ''  port: 3306  Official MySQL binary

So, please, try to use newer 4.1.14 version and provide any useful additional information on your configuration if you will see the same behaviour with it.