Bug 1851445 - [OSP13->OSP16.1] FFU fails with Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Summary: [OSP13->OSP16.1] FFU fails with Can't connect to local MySQL server through s...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: openstack-tripleo-heat-templates
Version: 16.1 (Train)
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: z2
: 16.1 (Train on RHEL 8.2)
Assignee: Jesse Pretorius
QA Contact: Ronnie Rasouli
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2020-06-26 14:22 UTC by Jose Luis Franco
Modified: 2020-10-28 15:38 UTC (History)
3 users (show)

Fixed In Version: openstack-tripleo-heat-templates-11.3.2-0.20200728213431.6c7ccc9.el8ost
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2020-10-28 15:38:11 UTC
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
OpenStack gerrit 739518 0 None MERGED [TRAIN ONLY] Wait until DB is ready for neutron DB rename 2020-11-17 00:29:54 UTC
Red Hat Product Errata RHEA-2020:4284 0 None None None 2020-10-28 15:38:31 UTC

Description Jose Luis Franco 2020-06-26 14:22:19 UTC 
Description of problem:

When performing the FFU upgrade from OSP13 to OSP16.1, during the Undercloud upgrade step the upgrade fails in the mysql_neutron_db_rename container with the following error:

2020-06-26T09:15:28.976248074-04:00 stderr F ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

This looks like it's caused by a race condition between mysql and this container, as the DB isn't up and running yet when the container gets executed. It tends to occur in system with slow HDD or virtualized environments.

To workaround the issue it is possible to restart the container and just re-run the whole undercloud upgrade command:

* sudo podman restart mysql_neutron_db_rename
* openstack undercloud upgrade -y

Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:
Comment 7 errata-xmlrpc 2020-10-28 15:38:11 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory (Red Hat OpenStack Platform 16.1 bug fix and enhancement advisory), and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHEA-2020:4284
Note You need to log in before you can comment on or make changes to this bug.