MySQL Bugs: #38225: monitor still "remembers" deleted servers

Bug #38225	monitor still "remembers" deleted servers
Submitted:	18 Jul 2008 16:48	Modified:	15 Oct 2008 12:05
Reporter:	Ligaya Turmelle
Status:	Closed
Category:	Monitoring: Web	Severity:	S3 (Non-critical)
Version:	1.3.1.9044	OS:	Mac OS X
Assigned to:	Bugs System	Target Version:	2.0 RC
Triage:	D4 (Minor) / R2 (Low) / E2 (Low)

Description:
After deleting a server from the Settings -> Manage Servers tab, at the very bottom of
the page the "Monitoring x instance on x host" values do not reflect the deletion.

In my testing with 2 instances on one machine with extra subscriptions to be used - if I
then navigate away from the Manage Servers page and then go back - the values are
corrected.

How to repeat:
Have monitor watching 2 instances or servers.  Delete 1.  Note "Monitoring x instance on
x host" at bottom of page.

Suggested fix:
Possible work around (show caution):
SELECT * from inv_servers and inv_agents tables to see if the servers are still listed
there.  If so delete the servers from the inv_servers and inv_agents tables in the
monitor database.

If you remove any old entries from the repository database, be sure to restart the Service
Manager afterwards to reflect the changes.

Verified fixed in build 2.0.0.7044.

An entry was added to the 2.0 changelog:

After deleting a server from the Settings, Manage Servers tab, at the very bottom of the
page the Monitoring x instances on x host values did not reflect the deletion.