Would you please offer me something please ? > 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 fault of myodbc or mysql server? > 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