On Fri, Nov 07, 2003 at 09:16:03AM -0800, Eric Anderson wrote: > > A little explaination:
[snip] > The threads connecting from the 1U (192.168.0.2) all start to block up > as expected, but when the length query on the e450 stops running, the > threads from the 1U stay blocked, and all NEW threads end up in a > "limbo" state: > > | 726136 | unauthenticated user | 192.168.0.2 | NULL | Connect | NULL > | login | NULL | > | 726135 | unauthenticated user | 192.168.0.2 | NULL | Connect | NULL > | login | NULL | > | 726134 | unauthenticated user | 192.168.0.2 | NULL | Connect | NULL > | login | NULL | > | 726138 | unauthenticated user | 192.168.0.2 | NULL | Connect | NULL > | login | NULL | > | 726140 | unauthenticated user | 192.168.0.2 | NULL | Connect | NULL > | login | NULL | > | 726142 | unauthenticated user | 192.168.0.2 | NULL | Connect | NULL > | login | NULL | > | 726143 | unauthenticated user | 192.168.0.2 | NULL | Connect | NULL > | login | NULL | > | 726148 | unauthenticated user | 192.168.0.2 | NULL | Connect | NULL > | login | NULL | > | 726149 | nobody | localhost | bm | Sleep | 11 > | | NULL | > | 726150 | unauthenticated user | 192.168.0.2 | NULL | Connect | NULL > | login | NULL | > | 726153 | unauthenticated user | 192.168.0.2 | NULL | Connect | NULL > | login | NULL | > | 726158 | unauthenticated user | 192.168.0.2 | NULL | Connect | NULL > | login | NULL | > | 726161 | unauthenticated user | 192.168.0.2 | NULL | Connect | NULL > | login | NULL | > | 726164 | unauthenticated user | 192.168.0.2 | NULL | Connect | NULL > | login | NULL | > | 726170 | unauthenticated user | 192.168.0.2 | NULL | Connect | NULL > | login | NULL | > | 726172 | unauthenticated user | 192.168.0.2 | NULL | Connect | NULL > | login | NULL | > | 726173 | nobody | localhost | bm | Sleep | 4 > | | NULL | > | 726181 | unauthenticated user | 192.168.0.2 | NULL | Connect | NULL > | login | NULL | > | 726185 | unauthenticated user | 192.168.0.2 | NULL | Connect | NULL > | login | NULL | > | 726191 | unauthenticated user | 192.168.0.2 | NULL | Connect | NULL > | login | NULL | > | 726201 | unauthenticated user | 192.168.0.2 | NULL | Connect | NULL > | login | NULL | > > No connections from 1U (192.168.0.2) are possible - they just hang, even > the interactive client just hangs. That looks a lot like a DNS problem I've seen on FreeBSD. Do you happen to have skip-name-resovle in the E450's my.cnf? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 55 days, processed 2,062,011,744 queries (433/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]