Re: Problems with mysql multi-master after update.

[Alessandro Ren <alessandro.ren@xxxxxxxxxxxxxxxxx>]

On 2/11/2009 12:46 AM, Jim Perrin wrote:

On Mon, Feb 9, 2009 at 7:33 AM, Alessandro Ren
<alessandro.ren@xxxxxxxxxxxxxxxxx> wrote:
e incremental.000001 on
  

the master and this causes the problem.
    In 5.0.22 this would not happen, this does not happen as I have
servers running this version and after the reboot, it starts syncing on
the right incremental.
    Any idea?
    

While I haven't seen this going from 0.22 to 0.45, did you run
mysql_upgrade following your upgrade?
Last I had this issue my table structure wasn't quite what the server
was expecting, and running mysql_upgrade was the solution.

  

    I tried it , but it did't help.
    I just rebooted one of the nodes and I am getting this error in the logs.
090211  9:07:41 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000012' (relay_log_pos 358860475)
090211  9:07:41 [ERROR] Could not find target log during relay log initialization
090211  9:07:41 [ERROR] Failed to initialize the master info structure
090211  9:07:41 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution


    Afeter deleting master.info and relay-log.ingo I get the incremental error:

090211  9:23:23 [ERROR] Error reading packet from server: File './incremental.000003' not found (Errcode: 2) ( server_errno=29)
090211  9:23:23 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'FIRST' position 4
090211  9:23:23 [Note] Slave: connected to master 'root@xxxxxxxxxxxxxx:3306',replication resumed in log 'FIRST' at position 4
090211  9:23:23 [ERROR] Error reading packet from server: File './incremental.000003' not found (Errcode: 2) ( server_errno=29)


    After fixing de inc-index on the master en restarting, abd restarting the slave, it workis fine:

Version: '5.0.45-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
090211  9:26:14 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/var/run/mysqld/mysqld-relay-bin.000005' position: 98
090211  9:26:14 [Note] Slave I/O thread: connected to master 'root@xxxxxxxxxxxxxx:3306',  replication started in log 'FIRST' at position 4


    Any tips? On 5.0.22 I never had this problem.

    Tks.

_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos