That was meant to read 'the slave position has NOT updated since the last upgrade.' Sorry =/
Quoting [EMAIL PROTECTED]: > 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 > > --------------------------------------------------------------------- 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
