Zurück
-
Titel
SQL PI Statements not collecting in MySQL Aurora and MariaDB -
Beschreibung
SQL PI statements do not collect in Aurora based instances of MySQL and MariaDB -
Ursache
CAUSE 1
Missing configuration settings
CAUSE 2
The MySQL PI agent could not connect to the MariaDB database using the MySQL driver.
CAUSE 3
Product defect
CAUSE 4
Missing "Create Temporary Tables" permission on the foglight user in MySQL or MariaDB.
-
Lösung
RESOLUTION 1
Review KB 4309267
RESOLUTION 2
In the agent status properties for the MySQL PI agent, enable the checkbox to use the Alternate MariaDB driver.
RESOLUTION 3
This issue was logged as defect FOG-3814 and has been fixed in the 6.1.0.11 and higher releases of the MySQL PI cartridge.
RESOLUTION 4
Grant "Create Temporary Tables" permission to Foglight user in MySQL or MariaDB -
Fehler-ID
FOG-3814