Bug #83701 MySQL Utilities references mysql.proc, which does not exist in MySQL 8.0
Submitted: 4 Nov 2016 22:58 Modified: 17 Jan 2020 13:53
Reporter: Bill Karwin (Candidate Quality Contributor) (OCA) Email Updates:
Status: Verified Impact on me:
Category:MySQL Utilities Severity:S3 (Non-critical)
Version:8.0.0-dmr, 1.6.4 OS:Mac OS X
Assigned to: CPU Architecture:Any
Tags: data dictionary

[4 Nov 2016 22:58] Bill Karwin
Several queries run by the MySLQ Utilities package mysql.utilities.common.database make reference to the table `mysql`.`proc`.

The `proc` table has been removed from the `mysql` database recently in MySQL 8.0.0, as part of the refactoring to use the InnoDB Data Dictionary.

I assume this affects most or all of the Python scripts in MySQL Utilities. I haven't tested more than one script, but the code is in a common package.

How to repeat:
$ mysqldbcompare --server1=root:passwd@localhost --difftype=sql test:test2

# WARNING: Using a password on the command line interface can be insecure.
# server1 on localhost: ... connected.
# Checking databases test and test2 on server1
ERROR: Query failed. 1146 (42S02): Table 'mysql.proc' doesn't exist```

Suggested fix:
Update MySQL Utilities code to search for stored routine metadata in an appropriate way, to support changes in MySQL 8.0.
[5 Nov 2016 5:31] MySQL Verification Team
Hello Bill,

Thank you for the report and feedback.

[25 Apr 2018 23:39] MySQL Verification Team
https://bugs.mysql.com/bug.php?id=90636 marked as duplicate of this one.
[17 Jan 2020 8:46] Reio Remma
No change after 3 years. Looking for ways to gradually update from 5.7 to 8 but running into an obstacle after obstacle.

Any workaround for this?
[17 Jan 2020 13:53] Bill Karwin
I don't expect this will ever be fixed. 

MySQL Utilities hasn't had any commits or releases since its 1.6.5 release in January 2017, according to https://github.com/mysql/mysql-utilities/releases

The download for MySQL Utilities has been moved to an archive page: https://downloads.mysql.com/archives/utilities/ and there's a notice that its current status is "Oracle Sustaining Support."

It also states: "Some features of Utilities are on the roadmap for Shell, users are encouraged to migrate to MySQL Shell."