Backup of the BDA Master MySQL Database with mysqldump Fails with "Got error: 1146: Table 'navigator.NAV_COUNT_STAGING_RAW' doesn't exist when using LOCK TABLES" (Doc ID 2240704.1)

Last updated on JUNE 25, 2023

Applies to:

Big Data Appliance Integrated Software - Version 4.5.0 and later
Linux x86-64

Symptoms

NOTE: In the examples that follow, user details, cluster names, hostnames, directory paths, filenames, etc. represent a fictitious sample (and are used to provide an illustrative example only). Any similarity to actual persons, or entities, living or dead, is purely coincidental and not intended in any manner.

On BDA V4.5 mysqldump fails with "Got error: 1146: Table 'navigator.NAV_COUNT_STAGING_RAW' doesn't exist when using LOCK TABLES".

Output looks like:

Therefore neither NAV_HDFS_ACTIVITY and NAV_HDFS_ACTIVITY_HIST has any concerns.

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

Symptoms

Cause

Solution

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

Backup of the BDA Master MySQL Database with mysqldump Fails with "Got error: 1146: Table 'navigator.NAV_COUNT_STAGING_RAW' doesn't exist when using LOCK TABLES" (Doc ID 2240704.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!