This setup is using one master and two slaves.

master- Mysql 4.0.20 - working
slave1 - Mysql-4.0.20 - ?????
slave2 - Mysql 4.0.17 - working

as far as i know the data seems to be ok. but i am a little bit unsure about some of the output of show slave status..


when i run show slave status on slave2 i see the folloing two things,
Slave_IO_Running: Yes
Slave_SQL_Running: Yes


However, When i run show slave status on slave1 i get
Slave_IO_Running: Yes
Slave_SQL_Running: No

Log file and position seem in sync with the master. Whats going on here?


I also tried doing slave stop; slave start; and that didn't help...