MySQL Forums
Forum List  »  Backup

mysqlpump fails on sys views (1356) starting Oct. 23
Posted by: Warren Prince
Date: October 26, 2018 07:49AM

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)"

Options: ReplyQuote


Subject
Views
Written By
Posted
mysqlpump fails on sys views (1356) starting Oct. 23
442
October 26, 2018 07:49AM


Sorry, only registered users may post in this forum.

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.