Bug #42389 Agent does not create inventory table
Submitted: 27 Jan 2009 20:08 Modified: 29 Jan 2009 22:11
Reporter: Diego Medina
Status: Closed
Category:Monitoring: Agent Severity:S1 (Critical)
Version:2.0.4.7140 OS:Any
Assigned to: Kay Roepke Target Version:

[27 Jan 2009 20: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 20: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 12:24] Kay Roepke 
A patch for this problem has been pushed.
[29 Jan 2009 22: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 14: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.