[CentOS] Problems with mysql multi-master after update.

Wed Feb 11 11:27:47 UTC 2009
Alessandro Ren <alessandro.ren at opservices.com.br>

On 2/11/2009 12:46 AM, Jim Perrin wrote:
> On Mon, Feb 9, 2009 at 7:33 AM, Alessandro Ren
> <alessandro.ren at opservices.com.br>  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 at 192.168.10.207: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 at 192.168.10.207:3306',  replication started in log 'FIRST' at 
position 4


     Any tips? On 5.0.22 I never had this problem.

     Tks.




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.centos.org/pipermail/centos/attachments/20090211/650f7edf/attachment-0005.html>