MySQL Forums
Forum List  »  Replication

Master stops processing queries
Posted by: Denis Roy
Date: April 25, 2006 07:43AM

MySQL 4.0.18 on SLES 9 quad PPC 16GB RAM

I'm asking under replication as it seems to only happen when the slave is running.

We have a master and a slave. Recently, the master server died, so we "promoted" the slave as the master. The failed master was entered back in service as the slave days later.

Since then, the (new) master occasionally seems to stop processing queries for no apparent reason, until the connection limit is hit. Issuing rcmysql restart fixes the problem, but only for a day or 3.

SHOW FULL PROCESSLIST displays a lengthy list of queries; the topmost always being:

| 54 | DELAYED | | eclipse | Delayed_insert | 14196
| 55 | xxxxxxxx | hostname:38242 | | Binlog Dump | 72422 | Has sent all binlog to slave; waiting for binlog to be updated | |
| 335588 | xxxxxxxx | | eclipse | Query | 14190 | end

It's strange that the DELAYED has no state (normally it's Waiting for INSERT, or upgrading Lock depending on load).

As mentioned previously, this happens every 24-72 hours when the slave is running. There's nothing in the log_error that would indicate why it's doing this, the server's not running out of open file handles, the disk arrays are not swamped.

Any clues?


Options: ReplyQuote

Written By
Master stops processing queries
April 25, 2006 07:43AM
April 25, 2006 02:12PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.