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

Last updated on APRIL 01, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms