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.bha...@ipax.at Technischer Leiter IPAX - Aloy Bhatia Hava OG web. http://www.ipax.at Barawitzkagasse 10/2/2/11 email. off...@ipax.at 1190 Wien tel. +43 1 3670030 FN 277995t HG Wien fax. +43 1 3670030 15 ____________________________________________________________________ _______________________________________________ Pacemaker mailing list: Pacemaker@oss.clusterlabs.org http://oss.clusterlabs.org/mailman/listinfo/pacemaker Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs: http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker