uneffective max_connections config/SQL database for RHEL and CentOS in Installation Guide

Bug #1749681 reported by Joao Pagaime
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
openstack-manuals
Fix Released
Low
Ian Y. Choi

Bug Description

This bug tracker is for errors with the documentation, use the following as a template and remove or add fields as you see fit. Convert [ ] into [x] to check boxes:

- [x] I have a fix to the document that I can paste below including example: input and output.

-----------------------------------
Release: on 2018-02-15 07:32
SHA: 497468c48236f6a8d32fdf5ab05717cfe7235514
Source: https://git.openstack.org/cgit/openstack/openstack-manuals/tree/doc/install-guide/source/environment-sql-database-rdo.rst
URL: https://docs.openstack.org/install-guide/environment-sql-database-rdo.html
----------

using cento-OS 7
problem:
- "max_connections = 4096" at /etc/my.cnf.d/openstack.cnf is uneffective unless maximum number of open files is configured at /etc/systemd/system/multi-user.target.wants/mariadb.service
- max TCP conneciontions to mysql maxed out at around 216 leaving openstack useless
fix:
- set LimitNOFILE=xxxx at the "[Service]" section at /etc/systemd/system/multi-user.target.wants/mariadb.service
(more info at https://bugs.launchpad.net/nova/+bug/1734282)

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to openstack-manuals (master)

Fix proposed to branch: master
Review: https://review.openstack.org/545291

Changed in openstack-manuals:
assignee: nobody → Ian Y. Choi (ianychoi)
status: New → In Progress
Revision history for this message
Ian Y. Choi (ianychoi) wrote :

Since such problem might also occur in other distros, so I try to add explanation on environment-sql-database.rst

Ian Y. Choi (ianychoi)
Changed in openstack-manuals:
importance: Undecided → Low
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to openstack-manuals (master)

Reviewed: https://review.openstack.org/545291
Committed: https://git.openstack.org/cgit/openstack/openstack-manuals/commit/?id=36d003613e559bbac119eb4317bc1cefcf4ec506
Submitter: Zuul
Branch: master

commit 36d003613e559bbac119eb4317bc1cefcf4ec506
Author: Ian Y. Choi <email address hidden>
Date: Fri Feb 16 13:12:48 2018 +0000

    [install] Mentions SQL max connection error

    It is worth mentioning about the maximum number of
    connections error messages to give hints how to deal
    with such kind of errors.

    Change-Id: Iee67650c97c40db49a1ee23ea4015d25ec380978
    Closes-Bug: #1749681

Changed in openstack-manuals:
status: In Progress → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.