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>