Hi Folks,
We are trying to put a monitoring solution in place at a client and have
come up against something during testing. If the replication user
disappears off the master and the slave cannot log in, the
Slave_IO_Thread still shows running and no error in the last error
number field. Does anybody know if this is intentional? I can't find any
references to this in the doco.
This is MySQL 4.0.20 and RH Advanced Server 2.1
After deleting the user on the master, the following message appears in
the log but the slave status shows a healthy relationship.
40902 10:54:13 Slave I/O thread: error connecting to master
'[EMAIL PROTECTED]:3307': Error: 'Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES)' errno: 1045
mysql> show slave status \G
*************************** 1. row **********
Master_Host: hpim202-98.aus.hp.com
Master_User: repl
Master_Port: 3307
Connect_retry: 60
Master_Log_File: hpim202-98-bin.001
Read_Master_Log_Pos: 913879
Relay_Log_File: MAU023W-relay-bin.010
Relay_Log_Pos: 305
Relay_Master_Log_File: hpim202-98-bin.001
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_do_db:
Replicate_ignore_db:
Last_errno: 0
Last_error:
Skip_counter: 0
Exec_master_log_pos: 913879
Relay_log_space: 301
1 row in set (0.00 sec)
Regards
David Logan
Database Administrator
HP Managed Services
139 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
