List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:September 11 2002 2:09pm
Subject:Re: Error 1053 stalling replication
View as plain text  
I do:
slave stop
mysqlhotcopy
slave start

Martin Waite wrote:

>Mysql, sql, etc.
>
>
>Hi,
>
>I am using a slave to perform backups using mysqlhotcopy.
>This locks all tables in my database for 10 minutes.
>
>Sometimes the replication is aborted during the period
>that the tables are locked. The error message in the slave's
>log is:
>
>ERROR: 1053  Server shutdown in progress
>020910 21:00:02  Slave:  error running query 'insert into ...'
>020910 21:00:02  Error running query, slave aborted. Fix the problem, and re-start the
> slave thread with "mysqladmin start-slave". We stopped at log 'log-bin.114' position
> 75216512
>
>The slave is then easily restarted using slave start.
>
>Does anyone know why this is happening ?  I imagine it is something to do with
>the tables being locked - but I don't understand why it thinks there is a 
>server shutdown, or why this isn't easily repeatable.
>
>My slave is 3.23.51 (linux 2.4), and the master is 3.23.33 (linux 2.2).
>
>regards,
>Martin
>
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread119289@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


Thread
Error 1053 stalling replicationMartin Waite11 Sep
  • Re: Error 1053 stalling replicationGerald Clark11 Sep