MySQL Forums :: Replication :: Master stops processing queries

Advanced Search

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

Subject Views Written By Posted
Master stops processing queries 3303 Denis Roy 04/25/2006 07:43AM
Re: Master stops processing queries 1605 James Day 04/25/2006 02:12PM
Re: Master stops processing queries 1702 Denis Roy 05/02/2006 09:01AM
Re: Master stops processing queries 1668 Denis Roy 05/05/2006 08:41AM
Re: Master stops processing queries 1658 James Day 05/10/2006 11:49AM
Re: Master stops processing queries 1709 Denis Roy 05/15/2006 08:56AM
Re: Master stops processing queries 1623 Denis Roy 05/02/2006 01:14PM

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.