Upgrade Portal/PC fails - Unsupported MySQL Schemas Detected - test
Article ID: 235194
Updated On:
Products
Issue/Introduction
Upgrading from 21.2.7 to 21.2.8 - Console upgrade fails - see message below and advise
Upgrade Existing Installation?
------------------------------
An existing Performance Center 21.2.7.369 installation has been detected at
/opt/CA. Do you want to upgrade this installation?
Click Yes to upgrade the installation.
Click No to exit the Setup program.
Warning: Be sure to perform a database backup before running the installer to
avoid possible data loss during an upgrade. The procedures are documented in
the Installation Guide.
->1- Yes
2- No
ENTER THE NUMBER OF THE DESIRED CHOICE, OR PRESS <ENTER> TO ACCEPT THE
DEFAULT:
===============================================================================
Configure DX Application Performance Management
-----------------------------------------------
Would you like to configure DX Application Performance Management?
This can be configured later by running setEMHost.sh from the wily directory
within the installation root.
->1- No
2- Yes
ENTER THE NUMBER OF THE DESIRED CHOICE, OR PRESS <ENTER> TO ACCEPT THE
DEFAULT:
===============================================================================
Unsupported MySQL Schemas Detected
----------------------------------
The current MySQL installation contains the following schemas which are not
managed by this product.
These unsupported schemas must be dropped or migrated to another MySQL
instance in order to complete this upgrade.
The upgrade will now exit.
Unsupported Schemas:
test
PRESS <ENTER> TO ACCEPT THE FOLLOWING (OK):
Environment
Release : 21.2
Component :
Cause
It was supposed to have 6 rows in the MySQL outputs. The test schema/database was not supposed to exist. It does not belong to PM installation.
$ mysql -uroot -p netqosportal
mysql> select schema_name as database_name from information_schema.schemata order by schema_name;
+--------------------+
| database_name |
+--------------------+
| em |
| information_schema |
| mysql |
| netqosportal |
| performance_schema |
| sys |
| test |
+--------------------+
7 rows in set (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| em |
| mysql |
| netqosportal |
| performance_schema |
| sys |
| test |
+--------------------+
7 rows in set (0.00 sec)
mysql> show schemas;
+--------------------+
| Database |
+--------------------+
| information_schema |
| em |
| mysql |
| netqosportal |
| performance_schema |
| sys |
| test |
+--------------------+
7 rows in set (0.00 sec)
Resolution
In MySQL, the schema is the synonym for the database. Therefore, you can use them interchangeably:
Here is the MySQL syntax to delete the schema/database:
mysql> drop database test;
Then re-run the MySQL queries to confirm it was deleted.
Additional Information
For your reference: https://www.mysqltutorial.org/mysql-drop-database/
Feedback
