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 | node3.eclipse.org:54647 | 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?
Thanks.
Subject
Views
Written By
Posted
Master stops processing queries
3816
April 25, 2006 07:43AM
1737
April 25, 2006 02:12PM
1910
May 02, 2006 09:01AM
1869
May 05, 2006 08:41AM
1837
May 10, 2006 11:49AM
1928
May 15, 2006 08:56AM
1882
May 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.