<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
On 2/11/2009 12:46 AM, Jim Perrin wrote:
<blockquote
cite="mid:302ce8b50902101846j27dac7fcw8c8402ad58825586@mail.gmail.com"
type="cite">
<pre wrap="">On Mon, Feb 9, 2009 at 7:33 AM, Alessandro Ren
<a class="moz-txt-link-rfc2396E" href="mailto:alessandro.ren@opservices.com.br"><alessandro.ren@opservices.com.br></a> wrote:
e incremental.000001 on
</pre>
<blockquote type="cite">
<pre wrap="">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?
</pre>
</blockquote>
<pre wrap=""><!---->
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.
</pre>
</blockquote>
I tried it , but it did't help.<br>
I just rebooted one of the nodes and I am getting this error in the
logs.<br>
090211 9:07:41 [ERROR] Failed to open the relay log
'/var/run/mysqld/mysqld-relay-bin.000012' (relay_log_pos 358860475)<br>
090211 9:07:41 [ERROR] Could not find target log during relay log
initialization<br>
090211 9:07:41 [ERROR] Failed to initialize the master info structure<br>
090211 9:07:41 [Note] /usr/libexec/mysqld: ready for connections.<br>
Version: '5.0.45-log' socket: '/var/lib/mysql/mysql.sock' port: 3306
Source distribution<br>
<br>
<br>
Afeter deleting master.info and relay-log.ingo I get the
incremental error:<br>
<br>
090211 9:23:23 [ERROR] Error reading packet from server: File
'./incremental.000003' not found (Errcode: 2) ( server_errno=29)<br>
090211 9:23:23 [Note] Slave I/O thread: Failed reading log event,
reconnecting to retry, log 'FIRST' position 4<br>
090211 9:23:23 [Note] Slave: connected to master
'<a class="moz-txt-link-abbreviated" href="mailto:root@192.168.10.207:3306">root@192.168.10.207:3306</a>',replication resumed in log 'FIRST' at
position 4<br>
090211 9:23:23 [ERROR] Error reading packet from server: File
'./incremental.000003' not found (Errcode: 2) ( server_errno=29)<br>
<br>
<br>
After fixing de inc-index on the master en restarting, abd
restarting the slave, it workis fine:<br>
<br>
Version: '5.0.45-log' socket: '/var/lib/mysql/mysql.sock' port: 3306
Source distribution<br>
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<br>
090211 9:26:14 [Note] Slave I/O thread: connected to master
'<a class="moz-txt-link-abbreviated" href="mailto:root@192.168.10.207:3306">root@192.168.10.207:3306</a>', replication started in log 'FIRST' at
position 4<br>
<br>
<br>
Any tips? On 5.0.22 I never had this problem.<br>
<br>
Tks.<br>
<br>
<br>
<br>
<br>
</body>
</html>