Re: Restarting slave after interruption

["Moon's Father" <yueliangdao0608@xxxxxxxxx>]

This is a classic error.
You just reconfigurate the parameter master_log_file and master_log_pos
.Good luck.

On Fri, May 23, 2008 at 5:13 AM, Mike <lunarblu@xxxxxxxxx> wrote:

> On Thu, May 22, 2008 at 10:41 AM, François Beausoleil <
> fbeausoleil@xxxxxxxx>
> wrote:
>
> > Hi all!
> > I must be stupid or something.  I can't find what my problem is.
> >
> > I searched this list, and did find a couple of hits, but nothing that
> > seemed fully relevant.  This one in particular was interesting:
> > http://lists.mysql.com/mysql/212863
> >
> > I have a single master (server-id=1) and a single slave (server-id=2).
> > Replication was correctly setup, and I was doing backups from the slave.
>  To
> > test recovery, I terminated the slave server (I'm on EC2), and I now wish
> to
> > start a new one.
> >
>
> If your taking a dump of the master open two windows.  Don't close either
> In the first lock all tables with FLUSH ALL TABLES WITH READ LOCK; & master
> status;
> Then in the second window procedure with mysqldump.
>
>
> >
> > First, I dump my master using this:
> >
> > mysqldump --master-data --flush-logs --extended-insert
> --single-transaction
> > -u root -papassword mydb >thedump.sql
> >
> > Then, I copy the dump to the slave and load the dump using:
> >
> > mysql -u root -papassword mydb <thedump.sql
> >
> > Next, I login to the slave server using the mysql command line client and
> > issue the following commands:
> >
> > CHANGE MASTER TO MASTER_HOST='10.252.155.80',
> >
> >  MASTER_USER='root',
> >
> >  MASTER_PASSWORD='apassword',
> >
> >  MASTER_LOG_FILE='mysql-bin.000054',
> >
> >  MASTER_LOG_POS=98;
> >
> > I read the log file and position from the dump (--master-data),
> > specifically, this line:
> >
> > CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000054', MASTER_LOG_POS=98;
> >
> > Then, I issue a START SLAVE on the slave, and SHOW SLAVE STATUS\G
> >
> > Here's the output:
> >
> > *************************** 1. row ***************************
> >             Slave_IO_State: Waiting for master to send event
> >                Master_Host: 10.252.155.80
> >                Master_User: root
> >                Master_Port: 3306
> >              Connect_Retry: 60
> >            Master_Log_File: mysql-bin.000054
> >        Read_Master_Log_Pos: 39727978
> >             Relay_Log_File: mysqld-relay-bin.000002
> >              Relay_Log_Pos: 1381
> >      Relay_Master_Log_File: mysql-bin.000054
> >           Slave_IO_Running: Yes
> >          Slave_SQL_Running: No
> >            Replicate_Do_DB:
> >        Replicate_Ignore_DB:
> >         Replicate_Do_Table:
> >     Replicate_Ignore_Table:
> >    Replicate_Wild_Do_Table:
> > Replicate_Wild_Ignore_Table:
> >                 Last_Errno: 1062
> >                 Last_Error: Error 'Duplicate entry '479084' for key
>
>
> This is a Duplicate primary key.  Usually means the position error.
>
> >
> > 1' on query. Default database: 'mydb'. Query: 'INSERT INTO assets
> > (`content_type`, `email_id`, `size`, `thumbnail`, `updated_at`,
> > `account_id`, `archive_id`, `title`, `type`, `folder_id`,
> > `description`, `filename`, `height`, `owner_id`, `parent_id`,
> > `created_at`, `width`) VALUES('image/jpeg', NULL, 6571, 'small',
> > '2008-05-21 23:24:10', 125, NULL, NULL, NULL, NULL, NULL,
> > '0101100102000104022008052003d78e21fe087d9623000b5c-21_small.jpg',
> > 180, NULL, 479082, '2008-05-21 23:24:10', 240)'
> >               Skip_Counter: 0
> >        Exec_Master_Log_Pos: 1244
> >            Relay_Log_Space: 39728115
> >            Until_Condition: None
> >             Until_Log_File:
> >              Until_Log_Pos: 0
> >         Master_SSL_Allowed: No
> >         Master_SSL_CA_File:
> >         Master_SSL_CA_Path:
> >            Master_SSL_Cert:
> >          Master_SSL_Cipher:
> >             Master_SSL_Key:
> >      Seconds_Behind_Master: NULL
> >
> > Anybody can tell me what I'm doing wrong ?  Am I dumping my master DB
> using
> > the right combination of options ?
> >
> > Thanks !
> > François Beausoleil
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:    http://lists.mysql.com/mysql?unsub=lunarblu@xxxxxxxxx
> >
> >
>



-- 
I'm a mysql DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn