Bug 1898707 - [mysql] Connection aborted ... (Got an error reading communication packets)
Summary: [mysql] Connection aborted ... (Got an error reading communication packets)
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: puppet-tripleo
Version: 16.2 (Train)
Hardware: All
OS: Linux
medium
high
Target Milestone: beta
: 16.2 (Train on RHEL 8.4)
Assignee: Michele Baldessari
QA Contact: David Rosenfeld
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2020-11-17 22:03 UTC by Robin Cernin
Modified: 2023-12-15 20:07 UTC (History)
12 users (show)

Fixed In Version: puppet-tripleo-11.6.2-2.20210428172107.5c76ddc.el8ost
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2021-09-15 07:10:23 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
OpenStack gerrit 763356 0 None MERGED Force MySQL / MariaDB log_warnings to 1 2021-05-27 09:27:04 UTC
Red Hat Issue Tracker OSP-4210 0 None None None 2023-03-27 13:18:29 UTC
Red Hat Product Errata RHEA-2021:3483 0 None None None 2021-09-15 07:10:51 UTC

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


Note You need to log in before you can comment on or make changes to this bug.