MySQL Master is missing 5 mysql system tables on BDA Versions 4.4 - 4.7.
(Doc ID 2246229.1)
Last updated on NOVEMBER 20, 2023
Applies to:
Big Data Appliance Integrated Software - Version 4.4.0 to 4.7.0 [Release 4.4 to 4.7]Linux x86-64
Symptoms
NOTE: In the examples that follow, user details, cluster names, hostnames, directory paths, filenames, etc. represent a fictitious sample (and are used to provide an illustrative example only). Any similarity to actual persons, or entities, living or dead, is purely coincidental and not intended in any manner.
The symptoms are as below:
1. /var/log/mysqld.log on the MySQL master contains Error messages about 5 missing mysql system tables.
The Error messages look like:
<timestamp> <#> InnoDB: Error: Fetch of persistent statistics requested for table "activity_monitor"."ids_to_delete_<#>" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
<timestamp> <#> InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
<timestamp> <#> InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
<timestamp> <#> InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
<timestamp> <#> InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
<timestamp> <#> InnoDB: Error: Fetch of persistent statistics requested for table "activity_monitor"."ids_to_delete_<#>" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
<timestamp> <#> InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
<timestamp> <#> InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
<timestamp> <#> InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
<timestamp> <#> InnoDB: Recalculation of persistent statistics requested for table "navigator"."HDFS_AUDIT_EVENTS_<date>" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
<timestamp> <#> InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
<timestamp> <#> InnoDB: Recalculation of persistent statistics requested for table "hive"."DBS" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
<timestamp> <#> InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
<timestamp> <#> InnoDB: Recalculation of persistent statistics requested for table "hive"."PARTITION_KEYS" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
<timestamp> <#> InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
<timestamp> <#> InnoDB: Recalculation of persistent statistics requested for table "hive"."SERDES" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
...
<timestamp> <#> InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
<timestamp> <#> InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
<timestamp> <#> InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
<timestamp> <#> InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
<timestamp> <#> InnoDB: Error: Fetch of persistent statistics requested for table "activity_monitor"."ids_to_delete_<#>" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
<timestamp> <#> InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
<timestamp> <#> InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
<timestamp> <#> InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
<timestamp> <#> InnoDB: Recalculation of persistent statistics requested for table "navigator"."HDFS_AUDIT_EVENTS_<date>" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
<timestamp> <#> InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
<timestamp> <#> InnoDB: Recalculation of persistent statistics requested for table "hive"."DBS" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
<timestamp> <#> InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
<timestamp> <#> InnoDB: Recalculation of persistent statistics requested for table "hive"."PARTITION_KEYS" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
<timestamp> <#> InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
<timestamp> <#> InnoDB: Recalculation of persistent statistics requested for table "hive"."SERDES" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
...
2. Logging into mysql and checking the mysql system tables shows that the following tables are not present.
- innodb_index_stats
- innodb_table_stats
- slave_master_info
- slave_relay_log_info
- slave_worker_info
Login to mysql as 'root' user on the Master:
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Description of the Tables |
| Impact of the Missing Tables on the BDA |
| Impact when Restarting MySQL Slave Replication |
| The 'host' mysql System Table |
| Solution |
| Known Issues |
| Detailed Steps |
| References |