Bug #2814 multiple connections, database locking up.
Submitted: 15 Feb 2004 15:53 Modified: 25 Feb 2005 19:05
Reporter: Web Master Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S1 (Critical)
Version:MySQL 4.1 -- Alpha release OS:Linux (redhat linux.)
Assigned to: CPU Architecture:Any

[15 Feb 2004 15:53] Web Master 
Description:
it seems like the server is being attacked but its not,
with heavy traffic the requests seem to multiple more then what there really is bringing the sql to a halt.

here is some output from the proccess list.

 Id  User  Host  db  Command  Time  State  Info  
Kill  428 unauthenticated user 66.154.35.193:33203 NULL Connect NULL Reading from net NULL 
Kill  432 unauthenticated user 66.154.35.193:33207 NULL Connect NULL login NULL 
Kill  433 unauthenticated user 66.154.35.193:33208 NULL Connect NULL login NULL 
Kill  434 unauthenticated user 66.154.35.193:33209 NULL Connect NULL login NULL 
Kill  435 unauthenticated user 66.154.35.193:33210 NULL Connect NULL login NULL 
Kill  436 unauthenticated user 66.154.35.193:33196 NULL Connect NULL login NULL 
Kill  437 unauthenticated user 66.154.35.193:33212 NULL Connect NULL login NULL 
Kill  438 unauthenticated user 66.154.35.193:33213 NULL Connect NULL login NULL 
Kill  439 unauthenticated user 66.154.35.193:33214 NULL Connect NULL login NULL 
Kill  440 unauthenticated user 66.154.35.193:33215 NULL Connect NULL login NULL 
Kill  441 unauthenticated user 66.154.35.193:33216 NULL Connect NULL login NULL 
Kill  442 unauthenticated user 66.154.35.193:33217 NULL Connect NULL login NULL 
Kill  443 unauthenticated user 66.154.35.193:33211 NULL Connect NULL login NULL 
Kill  444 unauthenticated user 66.154.35.193:33218 NULL Connect NULL login NULL 
Kill  445 unauthenticated user 66.154.35.193:33219 NULL Connect NULL login NULL 
Kill  446 unauthenticated user 66.154.35.193:33220 NULL Connect NULL login NULL 
Kill  447 unauthenticated user 66.154.35.193:33221 NULL Connect NULL login NULL 
Kill  448 unauthenticated user 66.154.35.193:33222 NULL Connect NULL login NULL 
Kill  449 unauthenticated user 66.154.35.193:33223 NULL Connect NULL login NULL 
Kill  450 unauthenticated user 66.154.35.193:33224 NULL Connect NULL login NULL 
Kill  451 unauthenticated user 66.154.35.193:33225 NULL Connect NULL login NULL 
Kill  452 unauthenticated user 66.154.35.193:33226 NULL Connect NULL login NULL 
Kill  453 unauthenticated user 66.154.35.193:33227 NULL Connect NULL login NULL 
Kill  454 unauthenticated user 66.154.35.193:33229 NULL Connect NULL login NULL 
Kill  455 unauthenticated user 66.154.35.193:33232 NULL Connect NULL login NULL 
Kill  456 unauthenticated user 66.154.35.193:33233 NULL Connect NULL login NULL 
Kill  457 unauthenticated user 66.154.35.193:33234 NULL Connect NULL login NULL 
Kill  458 unauthenticated user 66.154.35.193:33235 NULL Connect NULL login NULL 
Kill  459 unauthenticated user 66.154.35.193:33236 NULL Connect NULL login NULL 
Kill  460 unauthenticated user 66.154.35.193:33237 NULL Connect NULL login NULL 
Kill  461 unauthenticated user 66.154.35.193:33238 NULL Connect NULL login NULL 
Kill  462 unauthenticated user 66.154.35.193:33240 NULL Connect NULL login NULL 
Kill  463 unauthenticated user 66.154.35.193:33241 NULL Connect NULL login NULL 
Kill  464 unauthenticated user 66.154.35.193:33242 NULL Connect NULL login NULL 
Kill  465 unauthenticated user 66.154.35.193:33243 NULL Connect NULL login NULL 
Kill  466 unauthenticated user 66.154.35.193:33245 NULL Connect NULL login NULL 
Kill  467 unauthenticated user 66.154.35.193:33248 NULL Connect NULL login NULL 
Kill  468 unauthenticated user 66.154.35.193:33249 NULL Connect NULL login NULL 
Kill  469 unauthenticated user 66.154.35.193:33250 NULL Connect NULL login NULL 
Kill  470 unauthenticated user 66.154.35.193:33251 NULL Connect NULL login NULL 
Kill  471 unauthenticated user 66.154.35.193:33252 NULL Connect NULL login NULL 
Kill  472 unauthenticated user 66.154.35.193:33239 NULL Connect NULL login NULL 
Kill  473 unauthenticated user 66.154.35.193:33253 NULL Connect NULL login NULL 
Kill  474 unauthenticated user 66.154.35.193:33254 NULL Connect NULL login NULL 
Kill  475 unauthenticated user 66.154.35.193:33255 NULL Connect NULL login NULL 
Kill  476 unauthenticated user 66.154.35.193:33256 NULL Connect NULL login NULL 
Kill  477 unauthenticated user 66.154.35.193:33257 NULL Connect NULL login NULL 
Kill  478 unauthenticated user 66.90.69.3:56507 NULL Connect NULL login NULL 
Kill  479 unauthenticated user 66.154.35.193:33260 NULL Connect NULL login NULL 
Kill  480 unauthenticated user 66.154.35.193:33261 NULL Connect NULL login NULL 
Kill  481 unauthenticated user 66.154.35.193:33262 NULL Connect NULL login NULL 
Kill  482 unauthenticated user 66.154.35.193:33258 NULL Connect NULL login NULL 
Kill  483 unauthenticated user 66.154.35.193:33263 NULL Connect NULL login NULL 
Kill  484 unauthenticated user 66.154.35.193:33264 NULL Connect NULL login NULL 
Kill  485 unauthenticated user 66.154.35.193:33265 NULL Connect NULL login NULL 
Kill  486 unauthenticated user 66.154.35.193:33266 NULL Connect NULL login NULL 
Kill  487 unauthenticated user 66.154.35.193:33267 NULL Connect NULL login NULL 
Kill  488 unauthenticated user 66.154.35.193:33268 NULL Connect NULL login NULL 
Kill  489 unauthenticated user 66.154.35.193:33270 NULL Connect NULL login NULL 
Kill  490 unauthenticated user 66.154.35.193:33271 NULL Connect NULL login NULL 
Kill  491 unauthenticated user 66.154.35.193:33272 NULL Connect NULL login NULL 
Kill  492 unauthenticated user 66.154.35.193:33273 NULL Connect NULL login NULL 
Kill  493 unauthenticated user 66.154.35.193:33274 NULL Connect NULL login NULL 
Kill  494 unauthenticated user 66.154.35.193:33275 NULL Connect NULL login NULL 
Kill  495 unauthenticated user 66.154.35.193:33276 NULL Connect NULL login NULL 
Kill  496 unauthenticated user 66.154.35.193:33277 NULL Connect NULL login NULL 
Kill  497 unauthenticated user 66.154.35.193:33278 NULL Connect NULL login NULL 
Kill  498 unauthenticated user 66.154.35.193:33279 NULL Connect NULL login NULL 
Kill  499 unauthenticated user 66.154.35.193:33280 NULL Connect NULL login NULL 
Kill  500 unauthenticated user 66.154.35.193:33282 NULL Connect NULL login NULL 
Kill  501 unauthenticated user 66.154.35.193:33283 NULL Connect NULL login NULL 
Kill  502 unauthenticated user 66.154.35.193:33269 NULL Connect NULL login NULL 
Kill  503 unauthenticated user 66.154.35.193:33284 NULL Connect NULL login NULL 
Kill  504 unauthenticated user 66.154.35.193:33285 NULL Connect NULL login NULL 
Kill  505 unauthenticated user 66.154.35.193:33286 NULL Connect NULL login NULL 
Kill  506 unauthenticated user 66.154.35.193:33287 NULL Connect NULL login NULL 
Kill  507 unauthenticated user 66.154.35.193:33288 NULL Connect NULL login NULL 
Kill  508 unauthenticated user 66.154.35.193:33289 NULL Connect NULL login NULL 
Kill  509 unauthenticated user 66.154.35.193:33290 NULL Connect NULL login NULL 
Kill  510 unauthenticated user 66.154.35.193:33291 NULL Connect NULL login NULL 
Kill  511 unauthenticated user 66.154.35.193:33292 NULL Connect NULL login NULL 
Kill  512 unauthenticated user 66.154.35.193:33293 NULL Connect NULL login NULL 
Kill  513 unauthenticated user 66.154.35.193:33281 NULL Connect NULL login NULL 
Kill  514 unauthenticated user 66.154.35.193:33295 NULL Connect NULL login NULL 
Kill  515 unauthenticated user 66.154.35.193:33294 NULL Connect NULL login NULL 
Kill  516 unauthenticated user 66.154.35.193:33297 NULL Connect NULL login NULL 
Kill  517 unauthenticated user 66.154.35.193:33299 NULL Connect NULL login NULL 
Kill  518 unauthenticated user 66.154.35.193:33300 NULL Connect NULL login NULL 
Kill  519 unauthenticated user 66.154.35.193:33301 NULL Connect NULL login NULL 
Kill  520 unauthenticated user 66.154.35.193:33303 NULL Connect NULL login NULL 
Kill  521 unauthenticated user 66.154.35.193:33304 NULL Connect NULL login NULL 
Kill  522 unauthenticated user 66.154.35.193:33305 NULL Connect NULL login NULL 
Kill  523 unauthenticated user 66.154.35.193:33306 NULL Connect NULL login NULL 
Kill  524 unauthenticated user 66.154.35.193:33307 NULL Connect NULL login NULL 
Kill  525 unauthenticated user 66.154.35.193:33308 NULL Connect NULL login NULL 
Kill  526 unauthenticated user 66.154.35.193:33309 NULL Connect NULL login NULL 
Kill  527 unauthenticated user 66.154.35.193:33310 NULL Connect NULL login NULL 
Kill  528 unauthenticated user 66.154.35.193:33311 NULL Connect NULL login NULL 
Kill  529 unauthenticated user 66.154.35.193:33312 NULL Connect NULL login NULL 
Kill  530 unauthenticated user 66.154.35.193:33313 NULL Connect NULL login NULL 
  Id  User  Host  db  Command  Time  State  Info  
Kill  531 unauthenticated user 66.154.35.193:33302 NULL Connect NULL login NULL 
Kill  532 unauthenticated user 66.154.35.193:33315 NULL Connect NULL login NULL 
Kill  533 unauthenticated user 66.154.35.193:33316 NULL Connect NULL login NULL 
Kill  534 unauthenticated user 66.154.35.193:33317 NULL Connect NULL login NULL 
Kill  535 unauthenticated user 66.154.35.193:33318 NULL Connect NULL login NULL 
Kill  536 unauthenticated user 66.154.35.193:33320 NULL Connect NULL login NULL 
Kill  537 unauthenticated user 66.154.35.193:33321 NULL Connect NULL login NULL 
Kill  538 unauthenticated user 66.154.35.193:33322 NULL Connect NULL login NULL 
Kill  539 unauthenticated user 66.154.35.193:33323 NULL Connect NULL login NULL 
Kill  540 unauthenticated user 66.154.35.193:33324 NULL Connect NULL login NULL 
Kill  541 unauthenticated user 66.154.35.193:33325 NULL Connect NULL login NULL 
Kill  542 unauthenticated user 66.154.35.193:33326 NULL Connect NULL login NULL 
Kill  543 unauthenticated user 66.154.35.193:33327 NULL Connect NULL login NULL 
Kill  544 unauthenticated user 66.154.35.193:33328 NULL Connect NULL login NULL 
Kill  545 unauthenticated user 66.154.35.193:33329 NULL Connect NULL login NULL 
Kill  546 unauthenticated user 66.154.35.193:33319 NULL Connect NULL login NULL 
Kill  547 unauthenticated user 66.154.35.193:33330 NULL Connect NULL login NULL 
Kill  548 unauthenticated user 66.154.35.193:33331 NULL Connect NULL login NULL 
Kill  549 unauthenticated user 66.154.35.193:33333 NULL Connect NULL login NULL 
Kill  550 unauthenticated user 66.154.35.193:33336 NULL Connect NULL login NULL 
Kill  551 unauthenticated user 66.154.35.193:33337 NULL Connect NULL login NULL 
Kill  552 unauthenticated user 66.154.35.193:33338 NULL Connect NULL login NULL 
Kill  553 unauthenticated user 66.154.35.193:33339 NULL Connect NULL login NULL 
Kill  554 unauthenticated user 66.154.35.193:33340 NULL Connect NULL login NULL 
Kill  555 unauthenticated user 66.154.35.193:33341 NULL Connect NULL login NULL 
Kill  556 unauthenticated user 66.154.35.193:33342 NULL Connect NULL login NULL 
Kill  557 unauthenticated user 66.154.35.193:33335 NULL Connect NULL login NULL 
Kill  558 unauthenticated user 66.154.35.193:33343 NULL Connect NULL login NULL 
Kill  559 unauthenticated user 66.154.35.193:33344 NULL Connect NULL login NULL 
Kill  560 unauthenticated user 66.154.35.193:33345 NULL Connect NULL login NULL 
Kill  561 unauthenticated user 66.154.35.193:33346 NULL Connect NULL login NULL 
Kill  562 unauthenticated user 66.154.35.193:33347 NULL Connect NULL login NULL 
Kill  563 unauthenticated user 66.154.35.193:33348 NULL Connect NULL login NULL 
Kill  564 unauthenticated user 66.154.35.193:33349 NULL Connect NULL login NULL 
Kill  565 unauthenticated user 66.154.35.193:33350 NULL Connect NULL login NULL 
Kill  566 unauthenticated user 66.154.35.193:33352 NULL Connect NULL login NULL 
Kill  567 unauthenticated user 66.154.35.193:33353 NULL Connect NULL login NULL 
Kill  568 unauthenticated user 66.154.35.193:33354 NULL Connect NULL login NULL 
Kill  569 unauthenticated user 66.154.35.193:33355 NULL Connect NULL login NULL 
Kill  570 unauthenticated user 66.154.35.193:33356 NULL Connect NULL login NULL 
Kill  571 unauthenticated user 66.154.35.193:33357 NULL Connect NULL login NULL 
Kill  572 unauthenticated user 66.154.35.193:33358 NULL Connect NULL login NULL 
Kill  573 unauthenticated user 66.154.35.193:33359 NULL Connect NULL login NULL 
Kill  574 unauthenticated user 66.154.35.193:33362 NULL Connect NULL login NULL 
Kill  575 unauthenticated user 66.154.35.193:33351 NULL Connect NULL login NULL 
Kill  576 unauthenticated user 66.154.35.193:33365 NULL Connect NULL login NULL 
Kill  577 unauthenticated user 66.154.35.193:33368 NULL Connect NULL login NULL 
Kill  578 unauthenticated user 66.154.35.193:33371 NULL Connect NULL login NULL 
Kill  579 unauthenticated user 66.154.35.193:33372 NULL Connect NULL login NULL 
Kill  580 unauthenticated user 66.154.35.193:33373 NULL Connect NULL login NULL 
Kill  581 unauthenticated user 66.90.69.3:56524 NULL Connect NULL login NULL 
Kill  582 unauthenticated user 66.154.35.193:33374 NULL Connect NULL login NULL 
Kill  583 unauthenticated user 66.154.35.193:33375 NULL Connect NULL login NULL 
Kill  584 unauthenticated user 66.154.35.193:33376 NULL Connect NULL login NULL 
Kill  585 unauthenticated user 66.154.35.193:33377 NULL Connect NULL login NULL 
Kill  586 unauthenticated user 66.154.35.193:33378 NULL Connect NULL login NULL 
Kill  587 unauthenticated user 66.154.35.193:33379 NULL Connect NULL login NULL 
Kill  588 unauthenticated user 66.154.35.193:33380 NULL Connect NULL login NULL 
Kill  589 unauthenticated user 66.154.35.193:33381 NULL Connect NULL login NULL 
Kill  590 unauthenticated user 66.154.35.193:33382 NULL Connect NULL login NULL 
Kill  591 unauthenticated user 66.154.35.193:33384 NULL Connect NULL login NULL 
Kill  592 unauthenticated user 66.154.35.193:33385 NULL Connect NULL login NULL 
Kill  593 unauthenticated user 66.154.35.193:33386 NULL Connect NULL login NULL 
Kill  594 unauthenticated user 66.154.35.193:33387 NULL Connect NULL login NULL 
Kill  595 unauthenticated user 66.154.35.193:33388 NULL Connect NULL login NULL 
Kill  596 unauthenticated user 66.154.35.193:33389 NULL Connect NULL login NULL 
Kill  597 unauthenticated user 66.154.35.193:33391 NULL Connect NULL login NULL 
Kill  598 unauthenticated user 66.154.35.193:33392 NULL Connect NULL login NULL 
Kill  599 unauthenticated user 66.154.35.193:33393 NULL Connect NULL login NULL 
Kill  600 unauthenticated user 66.154.35.193:33394 NULL Connect NULL login NULL 
Kill  601 unauthenticated user 66.154.35.193:33396 NULL Connect NULL login NULL 
Kill  602 unauthenticated user 66.154.35.193:33397 NULL Connect NULL login NULL 
Kill  603 unauthenticated user 66.154.35.193:33398 NULL Connect NULL login NULL 
Kill  604 unauthenticated user 66.154.35.193:33399 NULL Connect NULL login NULL 
Kill  605 unauthenticated user 66.154.35.193:33400 NULL Connect NULL login NULL 
Kill  606 unauthenticated user 66.154.35.193:33401 NULL Connect NULL login NULL 
Kill  607 unauthenticated user 66.154.35.193:33403 NULL Connect NULL login NULL 
Kill  608 unauthenticated user 66.154.35.193:33404 NULL Connect NULL login NULL 
Kill  609 unauthenticated user 66.154.35.193:33405 NULL Connect NULL login NULL 
Kill  610 unauthenticated user 66.154.35.193:33406 NULL Connect NULL login NULL 
Kill  611 unauthenticated user 66.154.35.193:33408 NULL Connect NULL login NULL 
Kill  612 unauthenticated user 66.154.35.193:33409 NULL Connect NULL login NULL 
Kill  613 unauthenticated user 66.154.35.193:33412 NULL Connect NULL login NULL 
Kill  614 unauthenticated user 66.154.35.193:33413 NULL Connect NULL login NULL 
Kill  615 unauthenticated user 66.154.35.193:33414 NULL Connect NULL login NULL 
Kill  616 unauthenticated user 66.154.35.193:33402 NULL Connect NULL login NULL 
Kill  617 unauthenticated user 66.154.35.193:33415 NULL Connect NULL login NULL 
Kill  618 unauthenticated user 66.154.35.193:33416 NULL Connect NULL login NULL 
Kill  619 unauthenticated user 66.154.35.193:33407 NULL Connect NULL login NULL 
Kill  620 unauthenticated user 66.154.35.193:33417 NULL Connect NULL login NULL 
Kill  621 unauthenticated user 66.154.35.193:33418 NULL Connect NULL login NULL 
Kill  622 unauthenticated user 66.154.35.193:33411 NULL Connect NULL login NULL 
Kill  623 unauthenticated user 66.154.35.193:33410 NULL Connect NULL login NULL 
Kill  624 unauthenticated user 66.154.35.193:33421 NULL Connect NULL login NULL 
Kill  625 unauthenticated user 66.154.35.193:33422 NULL Connect NULL login NULL 
Kill  626 unauthenticated user 66.154.35.193:33425 NULL Connect NULL login NULL 
Kill  627 unauthenticated user 66.154.35.193:33427 NULL Connect NULL login NULL 
Kill  628 unauthenticated user 66.154.35.193:33431 NULL Connect NULL login NULL 
Kill  629 unauthenticated user 66.154.35.193:33420 NULL Connect NULL login NULL 
Kill  630 unauthenticated user 66.154.35.193:33432 NULL Connect NULL login NULL 
  Id  User  Host  db  Command  Time  State  Info  
Kill  631 unauthenticated user 66.154.35.193:33419 NULL Connect NULL login NULL 
Kill  632 unauthenticated user 66.154.35.193:33433 NULL Connect NULL login NULL 
Kill  633 unauthenticated user 66.154.35.193:33434 NULL Connect NULL login NULL 
Kill  634 unauthenticated user 66.154.35.193:33435 NULL Connect NULL login NULL 
Kill  635 unauthenticated user 66.154.35.193:33436 NULL Connect NULL login NULL 
Kill  636 unauthenticated user 66.154.35.193:33438 NULL Connect NULL login NULL 
Kill  637 unauthenticated user 66.154.35.193:33439 NULL Connect NULL login NULL 
Kill  638 unauthenticated user 66.154.35.193:33440 NULL Connect NULL login NULL 
Kill  639 unauthenticated user 66.154.35.193:33441 NULL Connect NULL login NULL 
Kill  640 unauthenticated user 66.154.35.193:33442 NULL Connect NULL login NULL 
Kill  641 unauthenticated user 66.154.35.193:33444 NULL Connect NULL login NULL 
Kill  642 unauthenticated user 66.154.35.193:33446 NULL Connect NULL login NULL 
Kill  643 unauthenticated user 66.154.35.193:33447 NULL Connect NULL login NULL 
Kill  644 unauthenticated user 66.154.35.193:33448 NULL Connect NULL login NULL 
Kill  645 unauthenticated user 66.154.35.193:33449 NULL Connect NULL login NULL 
Kill  646 unauthenticated user 66.154.35.193:33437 NULL Connect NULL login NULL 
Kill  647 unauthenticated user 66.154.35.193:33450 NULL Connect NULL login NULL 
Kill  648 unauthenticated user 66.154.35.193:33451 NULL Connect NULL login NULL 
Kill  649 unauthenticated user 66.154.35.193:33452 NULL Connect NULL login NULL 
Kill  650 unauthenticated user 66.154.35.193:33453 NULL Connect NULL login NULL 
Kill  651 unauthenticated user 66.154.35.193:33454 NULL Connect NULL login NULL 
Kill  652 unauthenticated user 66.154.35.193:33455 NULL Connect NULL login NULL 
Kill  653 unauthenticated user 66.154.35.193:33456 NULL Connect NULL login NULL 
Kill  654 unauthenticated user 66.154.35.193:33457 NULL Connect NULL login NULL 
Kill  655 unauthenticated user 66.154.35.193:33458 NULL Connect NULL login NULL 
Kill  656 unauthenticated user 66.154.35.193:33459 NULL Connect NULL login NULL 
Kill  657 unauthenticated user 66.154.35.193:33443 NULL Connect NULL login NULL 
Kill  658 unauthenticated user 66.154.35.193:33460 NULL Connect NULL login NULL 
Kill  659 unauthenticated user 66.154.35.193:33462 NULL Connect NULL login NULL 
Kill  660 unauthenticated user 66.154.35.193:33463 NULL Connect NULL login NULL 
Kill  661 unauthenticated user 66.154.35.193:33464 NULL Connect NULL login NULL 
Kill  662 unauthenticated user 66.154.35.193:33466 NULL Connect NULL login NULL 
Kill  663 unauthenticated user 66.154.35.193:33467 NULL Connect NULL login NULL 
Kill  664 unauthenticated user 66.154.35.193:33471 NULL Connect NULL login NULL 
Kill  665 unauthenticated user 66.154.35.193:33473 NULL Connect NULL login NULL 
Kill  666 unauthenticated user 66.154.35.193:33474 NULL Connect NULL login NULL 
Kill  667 unauthenticated user 66.154.35.193:33475 NULL Connect NULL login NULL 
Kill  668 unauthenticated user 66.154.35.193:33476 NULL Connect NULL login NULL 
Kill  669 unauthenticated user 66.154.35.193:33477 NULL Connect NULL login NULL 
Kill  670 unauthenticated user 66.154.35.193:33478 NULL Connect NULL login NULL 
Kill  671 unauthenticated user 66.154.35.193:33479 NULL Connect NULL login NULL 
Kill  672 unauthenticated user 66.154.35.193:33480 NULL Connect NULL login NULL 
Kill  673 unauthenticated user 66.154.35.193:33481 NULL Connect NULL login NULL 
Kill  674 unauthenticated user 66.154.35.193:33482 NULL Connect NULL login NULL 
Kill  675 unauthenticated user 66.154.35.193:33468 NULL Connect NULL login NULL 
Kill  676 unauthenticated user 66.154.35.193:33483 NULL Connect NULL login NULL 
Kill  677 unauthenticated user 66.154.35.193:33484 NULL Connect NULL login NULL 
Kill  678 unauthenticated user 66.154.35.193:33485 NULL Connect NULL login NULL 
Kill  679 unauthenticated user 66.154.35.193:33472 NULL Connect NULL login NULL 
Kill  680 unauthenticated user 66.154.35.193:33490 NULL Connect NULL login NULL 
Kill  681 unauthenticated user 66.154.35.193:33492 NULL Connect NULL login NULL 
Kill  682 unauthenticated user 66.154.35.193:33494 NULL Connect NULL login NULL 
Kill  683 unauthenticated user 66.154.35.193:33495 NULL Connect NULL login NULL 
Kill  684 unauthenticated user 66.154.35.193:33496 NULL Connect NULL login NULL 
Kill  685 unauthenticated user 66.154.35.193:33497 NULL Connect NULL login NULL 
Kill  686 unauthenticated user 66.154.35.193:33498 NULL Connect NULL login NULL 
Kill  687 unauthenticated user 66.154.35.193:33499 NULL Connect NULL login NULL 
Kill  688 unauthenticated user 66.154.35.193:33491 NULL Connect NULL login NULL 
Kill  689 unauthenticated user 66.154.35.193:33500 NULL Connect NULL login NULL 
Kill  690 unauthenticated user 66.154.35.193:33501 NULL Connect NULL login NULL 
Kill  691 unauthenticated user 66.154.35.193:33502 NULL Connect NULL login NULL 
Kill  692 unauthenticated user 66.154.35.193:33493 NULL Connect NULL login NULL 
Kill  693 unauthenticated user 66.154.35.193:33503 NULL Connect NULL login NULL 
Kill  694 unauthenticated user 66.154.35.193:33505 NULL Connect NULL login NULL 
Kill  695 unauthenticated user 66.154.35.193:33506 NULL Connect NULL login NULL 
Kill  696 unauthenticated user 66.154.35.193:33507 NULL Connect NULL login NULL 
Kill  697 unauthenticated user 66.154.35.193:33508 NULL Connect NULL login NULL 
Kill  698 unauthenticated user 66.154.35.193:33509 NULL Connect NULL login NULL 
Kill  699 unauthenticated user 66.154.35.193:33510 NULL Connect NULL login NULL 
Kill  700 unauthenticated user 66.154.35.193:33511 NULL Connect NULL login NULL 
Kill  701 unauthenticated user 66.154.35.193:33512 NULL Connect NULL login NULL 
Kill  702 unauthenticated user 66.154.35.193:33513 NULL Connect NULL login NULL 
Kill  703 unauthenticated user 66.154.35.193:33514 NULL Connect NULL login NULL 
Kill  704 unauthenticated user 66.154.35.193:33515 NULL Connect NULL login NULL 
Kill  705 unauthenticated user 66.154.35.193:33516 NULL Connect NULL login NULL 
Kill  706 unauthenticated user 66.154.35.193:33517 NULL Connect NULL login NULL 
Kill  707 unauthenticated user 66.154.35.193:33518 NULL Connect NULL login NULL 
Kill  708 unauthenticated user 66.154.35.193:33519 NULL Connect NULL login NULL 
Kill  709 unauthenticated user 66.154.35.193:33520 NULL Connect NULL login NULL 
Kill  710 unauthenticated user 66.154.35.193:33504 NULL Connect NULL login NULL 
Kill  711 unauthenticated user 66.154.35.193:33521 NULL Connect NULL login NULL 
Kill  712 unauthenticated user 66.154.35.193:33522 NULL Connect NULL login NULL 
Kill  713 unauthenticated user 66.154.35.193:33523 NULL Connect NULL login NULL 
Kill  714 unauthenticated user 66.154.35.193:33526 NULL Connect NULL login NULL 
Kill  715 unauthenticated user 66.154.35.193:33528 NULL Connect NULL login NULL 
Kill  716 unauthenticated user 66.154.35.193:33529 NULL Connect NULL login NULL 
Kill  717 unauthenticated user 66.154.35.193:33533 NULL Connect NULL login NULL 
Kill  718 unauthenticated user 66.154.35.193:33534 NULL Connect NULL login NULL 
Kill  719 unauthenticated user 66.154.35.193:33535 NULL Connect NULL login NULL 
Kill  720 unauthenticated user 66.154.35.193:33536 NULL Connect NULL login NULL 
Kill  721 unauthenticated user 66.154.35.193:33538 NULL Connect NULL login NULL 
Kill  722 unauthenticated user 66.154.35.193:33539 NULL Connect NULL login NULL 
Kill  723 unauthenticated user 66.154.35.193:33540 NULL Connect NULL login NULL 
Kill  724 unauthenticated user 66.154.35.193:33541 NULL Connect NULL login NULL 
Kill  725 unauthenticated user 66.154.35.193:33542 NULL Connect NULL login NULL 
Kill  726 unauthenticated user 66.154.35.193:33543 NULL Connect NULL login NULL 
Kill  727 unauthenticated user 66.154.35.193:33544 NULL Connect NULL login NULL 
Kill  728 unauthenticated user 66.154.35.193:33546 NULL Connect NULL login NULL 
Kill  729 unauthenticated user 66.154.35.193:33547 NULL Connect NULL login NULL 
Kill  730 unauthenticated user 66.154.35.193:33548 NULL Connect NULL login NULL 
  Id  User  Host  db  Command  Time  State  Info  
Kill  731 unauthenticated user 66.154.35.193:33549 NULL Connect NULL login NULL 
Kill  732 unauthenticated user 66.154.35.193:33550 NULL Connect NULL login NULL 
Kill  733 unauthenticated user 66.154.35.193:33551 NULL Connect NULL login NULL 
Kill  734 unauthenticated user 66.154.35.193:33552 NULL Connect NULL login NULL 
Kill  735 unauthenticated user 66.154.35.193:33553 NULL Connect NULL login NULL 
Kill  736 unauthenticated user 66.154.35.193:33554 NULL Connect NULL login NULL 
Kill  737 unauthenticated user 66.154.35.193:33555 NULL Connect NULL login NULL 
Kill  738 unauthenticated user 66.154.35.193:33556 NULL Connect NULL login NULL 
Kill  739 unauthenticated user 66.154.35.193:33557 NULL Connect NULL login NULL 
Kill  740 unauthenticated user 66.154.35.193:33558 NULL Connect NULL login NULL 
Kill  741 unauthenticated user 66.154.35.193:33563 NULL Connect NULL login NULL 
Kill  742 unauthenticated user 66.154.35.193:33566 NULL Connect NULL login NULL 
Kill  743 unauthenticated user 66.154.35.193:33567 NULL Connect NULL login NULL 
Kill  744 unauthenticated user 66.154.35.193:33569 NULL Connect NULL login NULL 
Kill  745 unauthenticated user 66.154.35.193:33576 NULL Connect NULL login NULL 
Kill  746 unauthenticated user 66.154.35.193:33577 NULL Connect NULL login NULL 
Kill  747 unauthenticated user 66.154.35.193:33578 NULL Connect NULL login NULL 
Kill  748 unauthenticated user 66.154.35.193:33579 NULL Connect NULL login NULL 
Kill  749 unauthenticated user 66.154.35.193:33580 NULL Connect NULL login NULL 
Kill  750 unauthenticated user 66.154.35.193:33581 NULL Connect NULL login NULL 
Kill  751 unauthenticated user 66.154.35.193:33582 NULL Connect NULL login NULL 
Kill  752 unauthenticated user 66.154.35.193:33584 NULL Connect NULL login NULL 
Kill  753 unauthenticated user 66.154.35.193:33585 NULL Connect NULL login NULL 
Kill  754 unauthenticated user 66.154.35.193:33586 NULL Connect NULL login NULL 
Kill  755 unauthenticated user 66.154.35.193:33587 NULL Connect NULL login NULL 
Kill  756 root localhost mysql Query 0 NULL SHOW PROCESSLIST 

at first it will accept connections then after a few minutes it turns into this.

How to repeat:
well i didnt get this with small amounts of traffic but once increased to a certain level this is what happens (mostly select querys (%name%) with SQL_CAL), however it does not appear to happen with the previous stable version 4.0.12

Suggested fix:
unknown, but for now im going back to stable release :-)

hope this info helps.
[16 Feb 2004 0:53] Alexander Keremidarski 
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Additional info:

Please provide repeatable test case. There is nothing in your report which can help us repeat the problem so we have no way to investigate it.
[24 Nov 2004 10:16] Beat Vontobel 
Unfortunetaly I experience the exact same bug since about half a year with all of the 4.1.x builds 
so far (running 4.1.7-classic-log right now) on a SuSE Linux with kernel 2.6.5: All the connections 
just stay in state 'unauthenticated' until the maximum number of connections is reached and the 
server is blocked.

However, I was never able to reproduce the bug on purpose. The server sometimes runs for 
weeks without any problems and then the error just pops up again. The problem persists for 
some minutes or hours and then just disappears again. The only possibility to take the MySQL 
server down with the connections in state 'unauthenticated' seems to be a "killall -9". But a 
restart of the server process or even a reboot of the client and the server machine (configuration 
with a db server and a webserver connected by a _direct_ ethernet link) usually doesn't help: It's 
still impossible to connect via ethernet to the MySQL server process.

I know this sounds strange and I too blamed the network first, of course: But after half a year of 
testing on the network side, this doesn't seem to be the source of the problems. I replaced 
network cards (different vendors and chipsets, gigabit/100Mbit, checks for full/half duplex 
problems...) on both sides and the cable between the two machines multiple times. I did flood 
pings and ftp, ssh and http transfers at the same time, _while_ the MySQL bug was occurring - 
without losing any single packet on the other protocols. However I wasn't able to connect to the 
MySQL server at the same time, nor through the php library (which all the applications on the 
webserver use) nor through the mysql command line tool. It just got stuck after I entered the 
password.

This makes me believe, that the original poster in fact might really have hit a bug, although I 
have no idea so far as to what might trigger it. But I'd _really_ like to help with this if you have 
any idea for me on what to investigate when the bug pops up again, as this gets very annoying 
on a production server.

I'm running different installations of MySQL without similar problems, so it might be connected 
somehow to the specific setup/hardware, although I run all of my MySQL servers on clean installs 
of SuSE Linux professional (minimal installation) without any other software running on the 
machine. But this is in fact the only machine running SuSE Professional 9.1 (others running 8.x or 
9.0/9.2).
[24 Jan 2005 8:29] Azli Ehwan 
Hi there,

  I also have the same problem like you. But i really can't find the solutions. I really need help from anybody who know how to solve it or from developer him/herself. I can even answer my user because it always appear suddenly with heavy traffic. I really and urgently need help. Thanks in advance.

-Azli-
[12 Feb 2005 20:18] Dimitris Georgakoulos 
I am having the same problem  with 4.1.5
[21 Feb 2005 8:44] Louis Savage 
I am using mysql src rpm and both the prebuilt rpm's and have come accross this same issue.

Using mysql version 4.1.9 and 4.1.10 ... Here is a error log from the crash.

mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=524288
read_buffer_size=258048
max_used_connections=1249
max_connections=1500
threads_connected=481
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 762500 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

You seem to be running 32-bit Linux and have 481 concurrent connections.
If you have not changed STACK_SIZE in LinuxThreads and built the binary
yourself, LinuxThreads is quite likely to steal a part of the global heap for
the thread stack. Please read http://www.mysql.com/doc/en/Linux.html

thd=0x976ca7a8
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0xbe7ff608, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x80be41a
0x82f8518
0x82e8a80
0x80b7074
0x80d0824
0x82f3e11
0x8320b9a
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at (nil)  is invalid pointer
thd->thread_id=4974
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.

note I have 4gigs of ram on this machine.
[23 Feb 2005 22:18] Louis Savage 
Was able to replicate issue.  Only when there was no reverse dns setup or no entry in /etc/hosts about the remote computers. As soon as this was added the issue stopped.
[25 Feb 2005 19:05] Sergei Golubchik 
Do you mean that without reverse dns (or missing line in hosts) mysqld was crashing ?
[12 May 2005 16:27] Beat Vontobel 
Louis Savage is right: The problem is definitively DNS related. This afternoon I experienced the bug for the first time since my last entry above (Nov 2004). As we have a very simple setup (the Database runs on a separate machine directly connected to the Webserver via a crossed cable), there was no DNS set up for these to private IP adresses (10.1.1.1 and .100):

Internet <---> [public IP] Webserver [10.1.1.100] <---> [10.1.1.1] Database

What happened again today was exactly what I and everybody else described above: The MySQL server suddenly didn't accept any new logins. All new connections got stock during the login process (the process list on mysql shows "unauthenticated user", "login", "connect").

At our site the mysql server didn't crash (we're always running the latest stable build, now 4.1.11-classic-log). It's just that with all the new connections stuck during login the number of allowed connections (300 at our site) got used up quickly (and anyway nobody was able to login).

After adding an entry for the webserver (10.1.1.100) to /etc/hosts on the database server (and I also added one for 10.1.1.1 on the webserver) the problem disappeared in an instant. New logins were accepted again by mysqld. (Thanks Louis for this valuable information, I always thought this to be a network related problem, exchanged all the network cards, drivers, cables multiple times but didn't blame it on DNS... stupid me!)

The big question now: What makes the bug pop up? Our systems ran stable now since last November... We didn't change anything in DNS nor anywhere else in this configuration since then. But still I think now that the main reason could be external to mysqld (somewhere in DNS, resolver libraries?). We run SuSE Professional (Linux version 2.6.5-7.104-smp (geeko@buildhost) (gcc version 3.3.3 (SuSE Linux)) #1 SMP Wed Jul 28 16:42:13 UTC 2004).

MySQL tries to find out the DNS name for every IP of an incoming connection and something seems to make it sometimes wait forever (or at least for a long timeout, I think with DNS this is often something around two minutes).

So as a workaround _always_ start mysql with --skip-name-resolve if you don't really need DNS on your installation or add an entry to /etc/hosts for every machine possibly connecting to your server.

This said, the guys at MySQL probably want to close this bug because it could be outside their scope (somewhere in the DNS). But I'm not 100% sure about this: During the occurrence of the bug today I was able to get very quick answers on DNS queries from command line tool dig (albeit negative ones, because these private IP addresses of course had no DNS entries) - and mysqld still was not accepting any queries.

Anyway, if this really turns out to be no MySQL bug, I'd make it an important feature request, because it would probably make sense to check the login/authentication code in MySQL and to make it a little more stable regarding DNS problems: You don't want your database server rendered completely useless only because of a DNS problem if you authenticate e.g. 90% percent of logins via wildcards (user@%) or IPs (user@xx.xx.xx.xx). If a user could be authenticated without knowing it's DNS name this probably should be done right away.
[6 Jul 2005 20:38] Rich Brome 
I've been having this problem as well, using MySQL 4.1.12 on RedHat. Like others, I'm using a private connection and IPs to connect the web and database servers.

It was driving me mad. When it happened, (more often during peak hours, but sometimes off-peak as well,) it was freezing Apache completely on both of my web servers for up to five minutes, taking my site down completely. It always corrected itself within 5 minutes, but 5-minute outages a dozen times a day was pretty frustrating.

Lowering the connect timeout tamed the Apache lockups, but the MySQL lockups still happened, so I then was getting streams of "Lost connection" and "Can't connect" errors from my site.

It took me forever to finally catch an event while I was logged in to MySQL, but then I finally did, and saw what others here described - hundreds of processes, all stuck at "Connect".

Simply adding "skip-name-resolve" to my.cnf seems to have solved all my problems.

I think it's a pretty serious bug that the default config will do this, apparently whenever there are private IP addresses and high loads, which can't be that uncommon.
[16 Jul 2005 15:36] Paul Vernon 
The problem is related to the listed name servers in your resolv.conf file.

If for whatever reason those servers cannot be contacted by your server, then reverse dns cannot be performed.  You can do either of the following to correct this issue:

1. Add additional secondary nameservers to your resolv.conf file
2. Add common hosts that will connect to this server to your /etc/hosts file
3. Add skip-name-resolve to your my.cnf file or startup scripts.

You should also add the hostname of the DB server you are running to each of your Web Servers /etc/hosts file, since they are probably using the same lame dns servers as well.

Paul Vernon
[11 Nov 2005 20:59] akif ozturk 
i have same problem. i am tryed everything but not fix it :(

how can i fix this problem
[11 Nov 2005 20:59] akif ozturk 
i have same problem. i am tryed everything but not fix it :(

how can i fix this problem
[23 Jul 2007 17:11] Naor Pinto 
We have come up with a way we can reproduce this bug. One way is to have network monitor to open connections to MySQL (in our case BigIP-F5.)

If the address of the F5 is not part of DNS or etc\hosts of the MySQL machine, MySQL will start having hanging threads in the process list for "unauthenticated user" and on State=Login.

This will happen if the F5 passes to MySQL the IP address instead of a qualified name that can be resolved by the DNS.
[16 Nov 2010 10:59] Eugene Khablov 
Reproduced on MacOSX Server 10.6.5 using MySQL 5.1.49. In case of slow 192.168.0.2 resolution connections from php scripts to 192.168.0.2 IP address on the same server massively stalled in "login" state with "unauthorized" user.