Bug #39906 Log full of "...job_collect_mysql.c:860: <SELECT CONCAT..."
Submitted: 7 Oct 2008 11:45 Modified: 7 Oct 2008 15:43
Reporter: Bogdan Kecman Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Enterprise Monitor: Agent Severity:S3 (Non-critical)
Version:2.0.0.7014 OS:Any
Assigned to: CPU Architecture:Any

[7 Oct 2008 11:45] Bogdan Kecman 
Description:
The Agent log file is full of:

(critical) job_collect_mysql.c:860: <SELECT CONCAT('\'',user,'\'@\'',host,'\'') as user FROM mysql.user WHERE user !='root' AND (Drop_priv='Y' OR Alter_priv = 'Y' OR Delete_priv='Y' OR Update_priv='Y' OR Insert_priv='Y' OR Lock_tables_priv='Y')> is returning more than one row on 'mysql', we ignore the rest

(critical) job_collect_mysql.c:860: <SELECT CONCAT('\'',user,'\'@\'',host,'\'') AS user_spec FROM mysql.user WHERE user != 'root' AND Grant_priv = 'Y'> is returning more than one row on 'mysql', we ignore the rest

How to repeat:
Start Agent, 
wait, 
look at the log

Suggested fix:
.
[7 Oct 2008 15:43] Andy Bang 
This is a duplicate of http://bugs.mysql.com/bug.php?id=38612.