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:
None 
Category:MySQL Utilities Severity:S3 (Non-critical)
Version:8.0.0-dmr, 1.6.4 OS:MacOS
Assigned to: CPU Architecture:Any
Tags: data dictionary

[4 Nov 2016 22:58] Bill Karwin
Description:
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.

Thanks,
Umesh
[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."

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.