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)