Mysqlians,
The sql_thread on our slave slave server has been stopping with
error 1053
ERROR: 1053 Server shutdown in progress
031203 16:05:01 Slave: error 'Server shutdown in progress' on query 'INSERT
INTO INTEREST ( ID, PERSON_ID, COMMENT, DATE_CREATED, INTEREST_ID ) VALUES (
'fffc5074-fe83-4f2e-9d4b-3d6a761c3f60',
'49ea2258-3f60-4337-82be-cb15012636be', '', '2003-12-03 16:04:59', '32' )',
error_code=1053
I have seen this half a dozen times and one time was in fact the master
being restarted. However I have seen this several times without the master
being restarted or any error in the master log at all. In addition this
error has occurred on relatively low machine loads ( top/1.0 -2.0) and high
(4.0-6.0). However the master server does between 1000 - 4000
questions/second. Is this a bug or something about the insert statement or
something else.
Thanks,
Trevor