Bug #50986 Please mention the instance name where the error occurs
Submitted: 8 Feb 2010 10:58 Modified: 8 Feb 2010 11:00
Reporter: Simon Mudd (OCA) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Enterprise Monitor: Agent Severity:S4 (Feature request)
Version:2.1.1.1138 OS:Any
Assigned to: CPU Architecture:Any
Tags: windmill

[8 Feb 2010 10:58] Simon Mudd
Description:
We sometimes monitor multiple mysqlds on the same host with a single agent.
In this situation the agent error messages often don't specify which db connection the problem relates to.

So I see:

2010-02-08 11:46:03: (critical) last message repeated 33 times
2010-02-08 11:46:03: (critical) executing 'SHOW /*!50000 ENGINE */ INNODB STATUS' failed: Access denied; you need the PROCESS privilege for this operation (1227)

The problem arose from copying a 5.0 instance and upgrading it to 5.1. The grants that had previously been specified for the agent were correct for 5.0 but not for 5.1.

How to repeat:
Copy a 5.0 instance with correct agent grants
upgrade to 5.1.

Start the agent again and see that the grants are incorrect.
Notice also that the mention of which instance is causing the problem is not shown.

Suggested fix:
Please tell us which monitored db instance this message refers to.

So I'd like something like 

2010-02-08 11:46:03: [displayname_in_dashboard] (critical) executing 'SHOW /*!50000 ENGINE */ INNODB STATUS' failed: Access denied; you need the PROCESS privilege for this operation (1227)
[8 Feb 2010 11:00] Mark Leith
Duplicate of 44748.