[CentOS] Problems with mysql multi-master after update.
Alessandro Ren
alessandro.ren at opservices.com.br
Wed Feb 11 11:27:47 UTC 2009
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.html>
More information about the CentOS
mailing list