[Pacemaker] mysql m/s failover: 'Could not find first log file name in binary log index file'

[Raoul Bhatia [IPAX]]

On 04/19/2011 10:01 AM, Raoul Bhatia [IPAX] wrote:
> the failover worked and wdb02 is up and running.
> upon rejoin, wdb01 wanted to start syncing from mysql-bin.000015,
> position 24386 (as saved in the cib).
> 
> this fails with error "Last_IO_Errno: 1236" and the message:
>> Last_IO_Error: Got fatal error 1236 from master when reading data
>> from binary log: 'Could not find first log file name in binary log
>> index file'

one additional note:

the ra does not detect this as a failure either. pacemaker reports
that both instances are up and running.

there is a "WARNING: MySQL Slave IO threads currently not running."
in the logs, but the ra checks for "Last_Errno:" only.

thus, it does not catch *any* other error, e.g.
> # mysql -h wdb01c -e "show slave status\G"|grep -i err
>                    Last_Errno: 0
>                    Last_Error: 
>                 Last_IO_Errno: 1236
>                 Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'
>                Last_SQL_Errno: 0
>                Last_SQL_Error: 

thanks,
raoul
-- 
____________________________________________________________________
DI (FH) Raoul Bhatia M.Sc.          email.          r.bhatia at ipax.at
Technischer Leiter

IPAX - Aloy Bhatia Hava OG          web.          http://www.ipax.at
Barawitzkagasse 10/2/2/11           email.            office at ipax.at
1190 Wien                           tel.               +43 1 3670030
FN 277995t HG Wien                  fax.            +43 1 3670030 15
____________________________________________________________________