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: | |
| 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
[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.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.061 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.