mysqldump Fails At "SHOW FIELDS FROM VIEW_NAME" After Upgrading From 7.x To 8.0: ERROR 1356 (HY000): View 'DB_NAME.VIEW_NAME' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (Doc ID 2937862.1)

Last updated on SEPTEMBER 06, 2023

Applies to:

MySQL Cluster - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

The "mysqldump" command can fail after upgrading MySQL Cluster installation from 7.x to 8.0. The failure happens at SHOW FIELDS FROM command against a view which refers NDB tables. If no such view exists, the problem cannot happen.

On MySQL Cluster, a backup is usually taken as a native backup via the management node cli: e.g. ndb_mgm -e "START BACKUP". However, mysqldump is still required on SQL nodes to backup non-NDB objects such as views, stored routines, triggers, event scheduler, user accounts.

Cause

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

mysqldump Fails At "SHOW FIELDS FROM VIEW_NAME" After Upgrading From 7.x To 8.0: ERROR 1356 (HY000): View 'DB_NAME.VIEW_NAME' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (Doc ID 2937862.1)

Applies to:

Symptoms

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!