Bug 1898707

Summary: [mysql] Connection aborted ... (Got an error reading communication packets)
Product: Red Hat OpenStack Reporter: Robin Cernin <rcernin>
Component: puppet-tripleoAssignee: Michele Baldessari <michele>
Status: CLOSED ERRATA QA Contact: David Rosenfeld <drosenfe>
Severity: high Docs Contact:
Priority: medium    
Version: 16.2 (Train)CC: apevec, astupnik, dciabrin, eharney, jjoyce, jschluet, lhh, lmiccini, mbayer, michele, slinaber, tvignaud
Target Milestone: betaKeywords: Triaged
Target Release: 16.2 (Train on RHEL 8.4)   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: puppet-tripleo-11.6.2-2.20210428172107.5c76ddc.el8ost Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2021-09-15 07:10:23 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Robin Cernin 2020-11-17 22:03:37 UTC 
Description of problem:

DB is dropping connections for multiple users and projects.

2020-11-17 21:08:04 1169 [Warning] Aborted connection 1169 to db: 'cinder' user: 'cinder' host: '...' (Got an error reading communication packets)
2020-11-17 21:08:05 1226 [Warning] Aborted connection 1226 to db: 'cinder' user: 'cinder' host: '...' (Got an error reading communication packets)
2020-11-17 21:08:05 1170 [Warning] Aborted connection 1170 to db: 'cinder' user: 'cinder' host: '...' (Got an error reading communication packets)


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

Red Hat OpenStack Platform release 16.1.2 GA (Train)
MariaDB [(none)]> SHOW VARIABLES LIKE "%version%";
+---------------------------------+------------------------------------------+
| Variable_name                   | Value                                    |
+---------------------------------+------------------------------------------+
| innodb_version                  | 10.3.17                                  |
| protocol_version                | 10                                       |
| slave_type_conversions          |                                          |
| system_versioning_alter_history | ERROR                                    |
| system_versioning_asof          | DEFAULT                                  |
| version                         | 10.3.17-MariaDB                          |
| version_comment                 | MariaDB Server                           |
| version_compile_machine         | x86_64                                   |
| version_compile_os              | Linux                                    |
| version_malloc_library          | system                                   |
| version_source_revision         | 4b5a14d0fe3d6945a0a9516261f563dcfd1f2c9c |
| version_ssl_library             | OpenSSL 1.1.1c FIPS  28 May 2019         |
| wsrep_patch_version             | wsrep_25.24                              |
+---------------------------------+------------------------------------------+
13 rows in set (0.000 sec)

As for the large scale environment, we have added these values under mysqld topic in galera.cnf and restarted the DB

max_allowed_packet = 199999488
max_connections = 8192
connect_timeout = 28800
innodb_lock_wait_timeout = 120
innodb_buffer_pool_size = 5G
innodb_buffer_pool_instances = 2
net_write_timeout = 300
net_read_timeout = 300
Comment 3 Robin Cernin 2020-11-17 22:20:53 UTC 
Increased also innodb_lock_wait_timeout to 600
Comment 45 errata-xmlrpc 2021-09-15 07:10:23 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 (RHOSP) 16.2 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-2021:3483