My Oracle Support Banner

MySQL Master is missing 5 mysql system tables on BDA Versions 4.4 - 4.7. (Doc ID 2246229.1)

Last updated on SEPTEMBER 03, 2018

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

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.
...

2. Logging into mysql and checking the mysql system tables shows that the following tables are not present.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.