Is anything being logged in the error log? -----Original Message----- From: Eric Anderson [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 11:16 AM To: [EMAIL PROTECTED] Subject: Very strange problem
A little explaination: We've got two servers, e450 (3.23.47) and 1U (4.0.14). These two machines have a private connection between them (192.168.0.1 and 192.168.0.2). The e450 is the master server, and the 1U has a copy (no replication) of some basic data, so it can run server-intensive pages. However, it needs to connect back to the e450 to insert some data. Everything runs fine until the e450 does something that "blocks" other threads (including the threads that are connecting from the 1U) on the table 'vip_t'. Let's say for example that I run a lengthy query on table 'vip_t' which causes all the other threads to be blocked while that query runs. 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. In order to clear things, I have to shutdown both httpd and mysql on both machines and restart them. And on the e450, mysql will not shut down completely. 'mysqladmin shutdown' just hangs (ostensibly waiting for the above threads to clear). I end up flushing everything and killing both mysql and the starting script. I'm sure the solution is to upgrade the e450's version of mysql first because that seems to be where the problem is, but I hate to do it at gunpoint. I'm wondering if anyone else has heard/seen any of these problems? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]