Active IQ Unified Manager のアップグレードが「 Failed to Upgrade platform_base 」というエラーで失敗する。

環境

• Active IQ Unified Manager （ AIQUM ） 9.6P1
• VMware OVA

問題

• Active IQ Unified Manager のアップグレードがで失敗する Failed to Upgrade platform_base

• で、次の手順を実行 upgrade.log:

 Jun 10 19:10:33 ocum systemd[1]: [0;1;39mmysql.service: Unit entered failed state.[0m Jun 10 19:10:33 ocum systemd[1]: [0;1;39mmysql.service: Failed with result 'signal'.[0m dpkg: error processing package mysql-community-server (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mysql-server: mysql-server depends on mysql-community-server (= 8.0.21-1debian10); however: Package mysql-community-server is not configured yet. dpkg: error processing package mysql-server (--configure): dependency problems - leaving unconfigured Processing triggers for libc-bin (2.28-10) ... Errors were encountered while processing: mysql-community-server mysql-server W: --force-yes is deprecated, use one of the options starting with --allow instead. W: --force-yes is deprecated, use one of the options starting with --allow instead. E: Sub-process /usr/bin/dpkg returned an error code (1) Jun 10 19:10:33: Failed to upgrade platform_base Jun 10 19:10:33: Upgrade of Active IQ Unified Manager failed. Jun 10 19:10:33: Contact technical support with appropriate AutoSupport information. Jun 10 19:10:33: For more information about AutoSupport, Jun 10 19:10:33: refer to the product documentation in the Support Site. 

• MySQL error.logの場合：

 2021-06-03T00:27:30.133311Z 29 [ERROR] InnoDB: Failed to find tablespace for table `ocum`.`annotationofcluster` in the cache. Attempting to load the tablespace with space id 68583 2021-06-03T00:27:30.133483Z 29 [ERROR] InnoDB: In file './ocum/annotationofcluster.ibd', tablespace id and flags are 68618 and 0, but in the InnoDB data dictionary they are 68583 and 0. Have you moved InnoDB .ibd files around without using the commands DISCARD TABLESPACE and IMPORT TABLESPACE? Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue. 2021-06-03T00:27:30.133497Z 29 [ERROR] InnoDB: Operating system error number 2 in a file operation. 2021-06-03T00:27:30.133505Z 29 [ERROR] InnoDB: The error means the system cannot find the path specified. 2021-06-03T00:27:30.133514Z 29 [ERROR] InnoDB: Could not find a valid tablespace file for `ocum/annotationofcluster`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue. 2021-06-03T00:27:30.133562Z 29 [Warning] InnoDB: Cannot calculate statistics for table `ocum`.`annotationofcluster` because the .ibd file is missing. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.

• Select * from ocum.annotationofcluster 次の場合に失敗します 
  Tablespace is missing error for table ocum.annotationofcluster