mysqlpump fails on sys views (1356) starting Oct. 23
Mysqlpump has worked fine for me for months. There was an apt upgrade to 8.0.13 on October 22, and mysqlpump started failing. The error messages are:
mysqlpump: [ERROR] (1356) View 'sys.schema_auto_increment_columns' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Dump process encountered error and will not continue.
mysqlpump: [ERROR] (1356) View 'sys.schema_object_overview' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Dump process encountered error and will not continue.
mysqlpump: [ERROR] (1356) View 'sys.schema_redundant_indexes' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Dump process encountered error and will not continue.
mysqlpump: [ERROR] (1356) View 'sys.schema_unused_indexes' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Dump process encountered error and will not continue.
mysqlpump: [ERROR] (1356) View 'sys.x$schema_flattened_keys' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Dump process encountered error and will not continue.
The account mysql.sys@localhost exists. It has Trigger privileges on sys schema. I don't know what else to check. I did run mysql_upgrade which succeeds and has the message (inter alia) "The sys schema is already up to date (version 2.0.0)"
Subject
Views
Written By
Posted
mysqlpump fails on sys views (1356) starting Oct. 23
2738
October 26, 2018 07:49AM
798
March 25, 2019 12:50PM
Sorry, you can't reply to this topic. It has been closed.
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.