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
Increased also innodb_lock_wait_timeout to 600
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