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
