From: [EMAIL PROTECTED]
To:   [EMAIL PROTECTED]
Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2 (10055))


Description:
 I am connecting from Visual Basic 6 to Mysql via
ODBC DSN. When i made 94 sleeped connection after 94 can't connect to a
server. It says : [TCX][MYODBC]Can't Connect to Mysql Server on 192.9.200.2
(10055)
Is it normal. If there a maximum connection limit for process ?
I think it is abnormal cause everyone is talking about
10.000 Web Hit. Is it cause from sleeped process list ?
I increased maximum connection to 200 but it not works.
I think it is not related with maximum connection . It is related with
maximum process number.


How-To-Repeat:
    Run this code on Microsoft Visual Basic 6 ENT Edition.

    For i = 1 To 200
    Set Temp_Bag(i) = New ADODB.Connection
        Temp_Bag(i).Open "DSN=Avukatpro;UID=avukatpro;PWD=avukatpro"
    Next i
It hangs 94 on Winnt. It hangs 60 on Win 95. It hangs 50 on Win98 SE.


Fix:
    Any offer? What means 10055 ? I check-out documents. Can't see any
recomend or definition for this error number.

Additional Information :
Host:       3.23.30-gamma
ClientInfo: 3.23.6-alpha
HostInfo:   192.9.200.2 via TCP/IP
ProtoInfo:  10

I stopped on 93 process and got process list. It is attached.


Synopsis: <synopsis of the problem (one line)>
Submitter-Id: Yusuf Incekara
Originator: Yusuf Incekara
Organization:   Avukatpro Limited Sirketi
MySQL support:  None
Severity: Critical
Priority: High
Category: mysqld, ODBC
Class:  sw-bug,ODBC-bug
Release: mysql-3.23.26-beta

Exectutable:   mysqld-nt and mysqld-opt
Environment:   PIII 700 MHZ Intel,256 MB RAM with WinNT4 ,
        Same Problem on PIII MHZ Intel with 128 MB Ram
System:        WinNT4 with Service Pack 6a, Internet Explorer 5
          Same problem on Windows 95 Osr 2
        Same Problem on Windows 98 SE
Compiler:      ?
Architecture:  i686

+-----+-----------+-----------+-----------+---------+------+-------+------------------+
| Id  | User      | Host      | db        | Command | Time | State | Info             |
+-----+-----------+-----------+-----------+---------+------+-------+------------------+
| 1   | root      | INCEKARA2 | mysql     | Sleep   | 1114 |       |                  |
| 189 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 190 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 191 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 192 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 193 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 194 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 195 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 196 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 197 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 198 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 199 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 200 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 201 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 202 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 203 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 204 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 205 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 206 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 207 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 208 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 209 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 210 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 211 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 212 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 213 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 214 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 215 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 216 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 217 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 218 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 219 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 220 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 221 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 222 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 223 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 224 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 225 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 226 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 227 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 228 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 229 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 230 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 231 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 232 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 233 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 234 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 235 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 236 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 237 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 238 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 239 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 240 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 241 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 242 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 243 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 244 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 245 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 246 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 247 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 248 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 249 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 250 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 251 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 252 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 253 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 254 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 255 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 256 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 257 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 258 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 259 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 260 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 261 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 262 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 263 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 264 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 265 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 266 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 267 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 268 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 269 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 270 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 271 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 272 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 273 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 274 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 275 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 276 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 277 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 278 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 279 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 280 | avukatpro | INCEKARA2 | avukatpro | Sleep   | 16   |       |                  |
| 282 | root      | INCEKARA2 |           | Query   | 0    |       | show processlist |
+-----+-----------+-----------+-----------+---------+------+-------+------------------+

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to