percona-discussion team mailing list archive

[Vadim Tkachenko <vadim@xxxxxxxxxxx>]

David,

I think you did not fully clean up slave before setup mirroring.

Please check procedure here
http://www.percona.com/docs/wiki/howto:mirror_binlog

If bug still exists - please create new bug report and I'll take look.

mysqldavid wrote:
> Hello Vadim,
> 
> I got the configure parameter by running mysqlbug.  I am not quite
> sure how the DBA before me selected the parameters for the configure
> script.  So I took your advice and removed those 2 parameters (I read
> the doc, I dont think we need it anyways).   I was able to
> successfully build this for version 5.0.67 hp and 5.0.75 hp.
> However, the replication broke as soon as I shutdown the slave and
> restarted it.  Here is the log:
> 
> 
> 090217 22:50:15 [Note] Slave SQL thread initialized, starting
> replication in log 'mysql-bin.000008' at position 98, relay log
> '/var/lib/mysql/mysql5.000001' position: 4
> 090217 22:50:15 [Note] Slave I/O thread: connected to master
> 'repl@xxxxxxxxxxxxxxxxxxx:3306',  replication started in log
> 'mysql-bin.000008' at position 98
> 090217 22:50:15 [Note] createReplicationMule
> 090217 22:50:15 [Note] Binglog size 98
> 090217 22:50:15 [Note] ReplicationMule: RELAY_MATCH_MULE.
> 090217 22:50:15 [Note]  RELAY_MATCH_MULE event 15
> 090217 22:50:36 [Note] Slave I/O thread killed while reading event
> 090217 22:50:36 [Note] Slave I/O thread exiting, read up to log
> 'mysql-bin.000008', position 98
> 090217 22:50:36 [Note] Error reading relay log event: slave SQL thread
> was killed
> 090217 22:50:38 [Note] Slave SQL thread initialized, starting
> replication in log 'mysql-bin.000008' at position 98, relay log
> '/var/lib/mysql/mysql5.000002' position: 235
> 090217 22:50:38 [Note] Slave I/O thread: connected to master
> 'repl@xxxxxxxxxxxxxxxxxxx:3306',  replication started in log
> 'mysql-bin.000008' at position 98
> 090217 22:50:38 [Note] createReplicationMule
> 090217 22:50:38 [Note] Binglog size 98
> 090217 22:50:38 [Note] ReplicationMule: RELAY_MATCH_MULE.
> 090217 22:50:38 [Note]  RELAY_MATCH_MULE event 15
> 090217 22:54:42 [Note] Slave I/O thread killed while reading event
> 090217 22:54:42 [Note] Slave I/O thread exiting, read up to log
> 'mysql-bin.000013', position 85431178
> 090217 22:54:42 [Note] Error reading relay log event: slave SQL thread
> was killed
> 090217 22:54:46 [Note] Slave SQL thread initialized, starting
> replication in log 'mysql-bin.000013' at position 85431178, relay log
> '/var/lib/mysql/mysql5.000018' position: 85431315
> 090217 22:54:46 [Note] Slave I/O thread: connected to master
> 'repl@xxxxxxxxxxxxxxxxxxx:3306',  replication started in log
> 'mysql-bin.000013' at position 85431178
> 090217 22:54:46 [Note] createReplicationMule
> 090217 22:54:46 [Note] Binglog size 85431178
> 090217 22:54:46 [Note] ReplicationMule: RELAY_MATCH_MULE.
> 090217 22:54:46 [Note]  RELAY_MATCH_MULE event 15
> 090217 23:06:10 [Note] /opt/mysql-5.0.75.5/lib/mysqld: Normal shutdown
> 
> 090217 23:06:10 [Note] Slave I/O thread killed while reading event
> 090217 23:06:10 [Note] Slave I/O thread exiting, read up to log
> 'mysql-bin.000013', position 85431178
> 090217 23:06:10 [Note] Error reading relay log event: slave SQL thread
> was killed
> 090217 23:06:10  InnoDB: Starting shutdown...
> 090217 23:06:12  InnoDB: Shutdown completed; log sequence number 0 2646942385
> 090217 23:06:12 [Note] /opt/mysql-5.0.75.5/lib/mysqld: Shutdown complete
> 
> 090217 23:06:15  InnoDB: Started; log sequence number 0 2646942385
> 090217 23:06:15 [Note] /opt/mysql-5.0.75.5/lib/mysqld: ready for connections.
> Version: '5.0.75-percona-b12-hp-log'  socket:
> '/var/run/mysqld/mysqld.sock'  port: 3306  with_mirror_binlog
> 090217 23:08:12 [Note] Slave SQL thread initialized, starting
> replication in log 'mysql-bin.000013' at position 85431178, relay log
> '/var/lib/mysql/mysql5.000019' position: 235
> 090217 23:08:12 [Note] Slave I/O thread: connected to master
> 'repl@xxxxxxxxxxxxxxxxxxx:3306',  replication started in log
> 'mysql-bin.000013' at position 85431178
> 090217 23:08:12 [Note] createReplicationMule
> 090217 23:08:12 [ERROR] Mule
> binlog(/var/lib/mysql/mysql5/mysql-bin.000014) does not match new
> relay-binlog(mysql-bin.000013)
> 090217 23:08:12 [Note] Slave I/O thread exiting, read up to log
> 'mysql-bin.000013', position 85431178
> 
> 
> -David
> 
> 
> On Fri, Feb 13, 2009 at 10:14 PM, Vadim Tkachenko <vadim@xxxxxxxxxxx> wrote:
>> David,
>>
>> Ok, I am not sure, but it may not work with
>> '--with-embedded-server'
>> '--with-embedded-privilege-control'.
>>
>> where did you take that configure line ?
>>
>>
>> mysqldavid wrote:
>>
>> --
>> Vadim Tkachenko, CTO
>> Percona Inc.
>> ICQ: 369-510-335, Skype: vadimtk153, Phone +1-888-401-3403
>> MySQL Performance Blog - http://www.mysqlperformanceblog.com
>> MySQL Consulting http://www.percona.com/
>>
>>  Attend the 2009 Percona Performance Conference
>>  April 22-23 - http://conferences.percona.com/
>>
>> --
>> Incorrect mirrored binary log
>> https://bugs.launchpad.net/bugs/304296
>> You received this bug notification because you are a direct subscriber
>> of the bug.
>>
>> Status in Patches for MySQL by Percona: Fix Committed
>>
>> Bug description:
>> I have incorrect mirrored binlog when slave between restarts has no new events
>>
> 


-- 
Vadim Tkachenko, CTO
Percona Inc.
ICQ: 369-510-335, Skype: vadimtk153, Phone +1-888-401-3403
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.percona.com/

  Attend the 2009 Percona Performance Conference
  April 22-23 - http://conferences.percona.com/

-- 
Incorrect mirrored binary log
https://bugs.launchpad.net/bugs/304296
You received this bug notification because you are a member of Percona
developers, which is the registrant for Percona patches.

Status in Patches for MySQL by Percona: Fix Committed

Bug description:
I have incorrect mirrored binlog when slave between restarts has no new events