Nils,
I agree with you, you do have to have all the log files, which is why I
reset the master.
According to the manual:
4.10.7.5 RESET MASTER (master)
Deletes all binary logs listed in the index file, resetting the binlog index
file to be empty. Previously named FLUSH MASTER .
By doing this you eliminate all old master file and start over at
FILENAME-bin-001 position 79.
Thanks for the input though.
Calvin
On 6/2/03 21:32, "Nils Valentin" <[EMAIL PROTECTED]> wrote:
> Hi Calvin,
>
> I am not sure which table format you use, but somehow I assume you use innodb.
>
> If I remember correctly than Innodb will need all log files. If only one is
> missing than thats it, you get the error described.
>
> - anybody please correct me if I talk rubbish here
>
> Best regards
>
> Nils Valentin
> Tokyo/Japan
>
>
> 2003年 6月 3日 火曜日 12:12、Calvin Hill
> さんは書きました:
>> Hello,
>>
>> I'm running MySQL Ver 12.18 Distrib 4.0.12 I had replication set up and
>> working perfectly between two machines in a round robin fashion. (Serv 1
>> updates Serv 2 and Serv 2 updates Serv 1.)
>>
>> Recently serv 2 locked up, upon restarting, it automatically began to
>> update with the files from serv 1. YEAH so far. Then I noticed that Serv 1
>> was not updating from serv 2. I checked all the settings and evertyhing
>> seems to be the same, but I'm getting the following in the error log;
>>
>> 030602 21:03:09 Slave I/O thread: connected to master
>> '[EMAIL PROTECTED]:3306', replication started in log ' serv2-bin.001' at
>> position 376
>>
>> 030602 21:03:09 Error reading packet from server: Could not find first log
>> file name in binary log index file (server_errno=1236)
>>
>> 030602 21:03:09 Got fatal error 1236: 'Could not find first log file name
>> in binary log index file' from master when reading data from binary log
>>
>> 030602 21:03:09 Slave I/O thread exiting, read up to log ' serv2-bin.001',
>> position 376
>>
>>
>> And the slave thread quits. I've quit and restarted the mysqld process on
>> both servers. I've even reset the master and slave files and re-set the
>> servers. Still I get the same error whenever I do a slave start on serv1.
>> serv2 is still happily grabbing the changes made to serv1 though.
>>
>> Any ideas?
>>
>> Thanks
>> Calvin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
