show master status returns nothing..?
Posted by:
Dan Casey
Date: November 11, 2005 10:56AM
Using MySQL 4.0.20 on both client and server
on the master, I did a show master status\G and it returned "Empty set (0.00 sec)"
please keep in mind that this was working previously.
what could have caused this to happen... more importantly, how can i get it to start again...
on the slave i ran "start slave" "show slave status\G"
Slave_IO_Running: No
Slave_SQL_Running: Yes
Last_errno: 0
Last_error:
--snip-- from slave.err
051013 12:24:52 Slave SQL thread initialized, starting replication in log 'master-bin.525' at position 805533, relay log './slave-relay-bin.306' position: 805533
051013 12:24:52 Slave I/O thread: connected to master 'repl@master:3306', replication started in log 'master-bin.525' at position 805533
051019 8:39:34 Slave I/O thread: Failed reading log event, reconnecting to retry, log 'master-bin.1127' position 427249
051019 8:39:34 Slave I/O thread: error reconnecting to master 'repl@master:3306': Error: 'Lost connection to MySQL server during query' errno: 2013 retry-time: 60 retries: 86400
on the master:
grep slave master.err -- nothing
grep repl master.err -- nothing...
any ideas?
Subject
Views
Written By
Posted
show master status returns nothing..?
7886
November 11, 2005 10:56AM
2838
November 11, 2005 10:33PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.