My Oracle Support Banner

While Checking for Expired MySQL Passwords Prior to BDA Upgrade the Query Fails with: "ERROR 1054 (42S22) at line 1: Unknown column 'password_expired' in 'field list'" (Doc ID 2351948.1)

Last updated on NOVEMBER 08, 2022

Applies to:

Big Data Appliance Integrated Software - Version 4.6.0 and later
Information in this document applies to any platform.

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. 

Running the pre-requisite checks described in Upgrading Oracle Big Data Appliance(BDA) CDH Cluster to V4.10.0 from V4.6, V4.7, V4.8, V4.9 Releases using Mammoth Software Upgrade Bundle for OL5 or OL6 <Document 2321352.1> results in an inconsistency in the MySQL password checks. 

This problem occurs while running the password_expired checks on the primary and secondary mysql hosts.

For example, on the primary node:

When doing a describe on the "user" table in both nodes, the the password_expired column is present on the primary node, but the secondary node is missing the password_expired column entirely.

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
References


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