Hello, A while back I upgraded our slave mysql database from 3.23 to 4.04, it accepted replication coming from a 3.23 machine fine for several weeks. Last night I upgraded the master from 3.23 to 4.04 and now there is a problem with replication.
Below is the output from show master/slave status. As you can see Slave_IO_Running is a 'No' and the master is writing to a different log file than the slave is reading from (the slave position has updated since the upgrade). It seems like the slave isn't getting the latest index. Please let me know if you have any suggestions. Thanks. mysql> show master status; +-------------+----------+--------------+------------------+ | File | Position | Binlog_do_db | Binlog_ignore_db | +-------------+----------+--------------+------------------+ | ted-bin.005 | 1028620 | | | +-------------+----------+--------------+------------------+ 1 row in set (0.00 sec) mysql> show slave status; +-------------+-------------+-------------+---------------+-----------------+-- -------------------+--------------------+---------------+---------------------- -+------------------+-------------------+-----------------+-------------------- -+------------+------------+--------------+---------------------+-------------- ---+ | Master_Host | Master_User | Master_Port | Connect_retry | Master_Log_File | Read_Master_Log_Pos | Relay_Log_File | Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | Exec_master_log_pos | Relay_log_space | +-------------+-------------+-------------+---------------+-----------------+-- -------------------+--------------------+---------------+---------------------- -+------------------+-------------------+-----------------+-------------------- -+------------+------------+--------------+---------------------+-------------- ---+ | 192.168.1.2 | bill | 3306 | 60 | ted-bin.004 | 79577967 | bill-relay-bin.003 | 4 | ted- bin.004 | No | Yes | | | 0 | | 0 | 79577973 | 4 | +-------------+-------------+-------------+---------------+-----------------+-- -------------------+--------------------+---------------+---------------------- -+------------------+-------------------+-----------------+-------------------- -+------------+------------+--------------+---------------------+-------------- ---+ 1 row in set (0.00 sec) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
