Open GoogleCodeExporter opened 8 years ago
Could you please paste the following command resultset on the slave
192.168.100.55:3306?
select * from mysql.slave_relay_log_info;
Original comment by Yoshinor...@gmail.com
on 6 Jun 2014 at 5:08
oh ,thanks for your answers
192.168.100.55:3306 is the master while 192.168.100.55:3307 is the slave ,so
there should be nothing in table slave_relay_log_info on 192.168.100.55:3306 .
look this(192.168.100.55:3307):
(user:root time: 11:44 port: 3307)[db: (none)]select * from
mysql.slave_relay_log_info;
+-----------------+--------------------------+---------------+------------------
+----------------+-----------+-------------------+----+
| Number_of_lines | Relay_log_name | Relay_log_pos | Master_log_name
| Master_log_pos | Sql_delay | Number_of_workers | Id |
+-----------------+--------------------------+---------------+------------------
+----------------+-----------+-------------------+----+
| 7 | ./mysql-relay-bin.000002 | 24298857 | mysql-bin.000008
| 52881234 | 0 | 0 | 1 |
+-----------------+--------------------------+---------------+------------------
+----------------+-----------+-------------------+----+
Original comment by freedom3...@gmail.com
on 8 Jun 2014 at 3:55
I have the same problem.
I think it's maybe a bug in Server.pm in line 237:
master's mysql.slave_relay_log_info is empty, so get_relay_dir_file_from_table
returns nothing.
if ( $self->{relay_log_info_type} eq "TABLE" ) {
my ( $relay_dir, $current_relay_log ) =
MHA::SlaveUtil::get_relay_dir_file_from_table($dbh);
$self->{relay_dir} = $relay_dir;
$self->{current_relay_log} = $current_relay_log;
if ( !$relay_dir || !$current_relay_log ) {
$log->error(
sprintf(
" Getting relay log directory or current relay logfile from replication table
failed on %s!",
$self->get_hostinfo() )
);
croak;
}
}
Original comment by hdk...@gmail.com
on 18 Jun 2014 at 8:25
Upgrading to 0.56 should resolve this issue.
Original comment by ben.mild...@percona.com
on 20 Jun 2014 at 4:41
Original issue reported on code.google.com by
freedom3...@gmail.com
on 6 Jun 2014 at 9:05