Bug #42389 Agent does not create inventory table
Submitted: 27 Jan 2009 19:08 Modified: 29 Jan 2009 21:11
Reporter: Diego Medina Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Agent Severity:S1 (Critical)
Version:2.0.4.7140 OS:Any
Assigned to: Kay Roepke CPU Architecture:Any

[27 Jan 2009 19:08] Diego Medina
Description:
The agent does not create the mysql.inventory table any more

on the logs you see

 (critical) (share/mysql-proxy/quan.lua:711) [proxy] please add SELECT permissions for this user on mysql.inventory to enable the QUAN feature, got Table 'mysql.inventory' doesn't exist

Even though the user the agent us using is root

How to repeat:
1- Install and start the agent and service manager
2- Check the agent logs

notes: these are all the logs

https://intranet.mysql.com/secure/paste/displaypaste.php?codeid=6715

It may be related to the bug fix for http://bugs.mysql.com/bug.php?id=41603
[27 Jan 2009 19:12] Diego Medina
mysql> show grants for 'root'@'localhost';
+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost                                                                                                              |
+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*6C387FC3893DBA1E3BA155E74754DA6682D04747' WITH GRANT OPTION | 
+----------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.02 sec)

mysql>
[28 Jan 2009 11:24] Kay Roepke
A patch for this problem has been pushed.
[29 Jan 2009 21:11] Diego Medina
Verified fixed on 2.0.4.7141

with and without the log-bin option, the inventory table is created
[9 Feb 2009 13:28] Tony Bedford
An entry was added to the 2.0.4 changelog:

The Service Agent failed to create the mysql.inventory table. The logs displayed the following error message:

(critical) (share/mysql-proxy/quan.lua:711) [proxy] please add SELECT permissions for
this user on mysql.inventory to enable the QUAN feature, got Table 'mysql.inventory'
doesn't exist

This happened even though the Service Agent used the root account.