David, I haven't ever attempted to delete the slave user on the master, and since I only run replication on 4.1 boxes and not 4.0 boxes, I won't be able to help much. But I would probably submit it to http://bugs.mysql.com and they can verify that it is a bug. But they will probably not recommend deleting the slave user again. :)
Donny > -----Original Message----- > From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 01, 2004 8:53 PM > To: MySQL List > Subject: Replication bug? > > 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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]