[Bug 1721546] Re: max open files limit prevents max_connections over 214 on systemd

[Launchpad Bug Tracker]

This bug was fixed in the package mysql-5.7 - 5.7.21-1ubuntu1

---
mysql-5.7 (5.7.21-1ubuntu1) bionic; urgency=medium

  * Merge from Debian.
  * Remaining changes:
- Revert "Build with libmecab-dev" since libmecab-dev is in
  universe.

mysql-5.7 (5.7.21-1) unstable; urgency=high (security fixes)

  * Imported upstream version 5.7.21 to fix security issues:
- 
http://www.oracle.com/technetwork/security-advisory/cpujan2018-3236628.html
- CVE-2018-2562 CVE-2018-2565 CVE-2018-2573 CVE-2018-2576
- CVE-2018-2583 CVE-2018-2586 CVE-2018-2590 CVE-2018-2591
- CVE-2018-2600 CVE-2018-2612 CVE-2018-2622 CVE-2018-2640
- CVE-2018-2645 CVE-2018-2646 CVE-2018-2647 CVE-2018-2665
- CVE-2018-2667 CVE-2018-2668 CVE-2018-2696 CVE-2018-2703
- CVE-2017-3737
(Closes: #887477)

 -- Lars Tangvald   Fri, 02 Feb 2018 11:58:04
+0100

** Changed in: mysql-5.7 (Ubuntu)
   Status: Confirmed => Fix Released

** CVE added: https://cve.mitre.org/cgi-bin/cvename.cgi?name=2017-3737

** CVE added: https://cve.mitre.org/cgi-bin/cvename.cgi?name=2018-2562

** CVE added: https://cve.mitre.org/cgi-bin/cvename.cgi?name=2018-2565

** CVE added: https://cve.mitre.org/cgi-bin/cvename.cgi?name=2018-2573

** CVE added: https://cve.mitre.org/cgi-bin/cvename.cgi?name=2018-2576

** CVE added: https://cve.mitre.org/cgi-bin/cvename.cgi?name=2018-2583

** CVE added: https://cve.mitre.org/cgi-bin/cvename.cgi?name=2018-2586

** CVE added: https://cve.mitre.org/cgi-bin/cvename.cgi?name=2018-2590

** CVE added: https://cve.mitre.org/cgi-bin/cvename.cgi?name=2018-2591

** CVE added: https://cve.mitre.org/cgi-bin/cvename.cgi?name=2018-2600

** CVE added: https://cve.mitre.org/cgi-bin/cvename.cgi?name=2018-2612

** CVE added: https://cve.mitre.org/cgi-bin/cvename.cgi?name=2018-2622

** CVE added: https://cve.mitre.org/cgi-bin/cvename.cgi?name=2018-2640

** CVE added: https://cve.mitre.org/cgi-bin/cvename.cgi?name=2018-2645

** CVE added: https://cve.mitre.org/cgi-bin/cvename.cgi?name=2018-2646

** CVE added: https://cve.mitre.org/cgi-bin/cvename.cgi?name=2018-2647

** CVE added: https://cve.mitre.org/cgi-bin/cvename.cgi?name=2018-2665

** CVE added: https://cve.mitre.org/cgi-bin/cvename.cgi?name=2018-2667

** CVE added: https://cve.mitre.org/cgi-bin/cvename.cgi?name=2018-2668

** CVE added: https://cve.mitre.org/cgi-bin/cvename.cgi?name=2018-2696

** CVE added: https://cve.mitre.org/cgi-bin/cvename.cgi?name=2018-2703

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1721546

Title:
  max open files limit prevents max_connections over 214 on systemd

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1721546/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1721546] Re: max open files limit prevents max_connections over 214 on systemd

[Mario Splivalo]

That is better thatn what it is now, but! What is the rationale behind not 
letting systemd limit the number of open files?
The limit exists in MySQL anyways, and for mysql administrator this is just an 
additional option that needs to be changed. I also imagine most of MySQL admins 
will set LimitNOFILE to Infinity anyways, and control open-files-limit. 

So, +1 on setting LimitNOFile to 5000, but with suggestion to setting it
to INFINITY.

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1721546

Title:
  max open files limit prevents max_connections over 214 on systemd

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1721546/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1721546] Re: max open files limit prevents max_connections over 214 on systemd

[Robie Basak]

Is https://salsa.debian.org/rbasak-guest/mysql/merge_requests/3
acceptable to everyone? This sets LimitNOFile to 5000 based on upstream.

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1721546

Title:
  max open files limit prevents max_connections over 214 on systemd

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1721546/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1721546] Re: max open files limit prevents max_connections over 214 on systemd

[Launchpad Bug Tracker]

Status changed to 'Confirmed' because the bug affects multiple users.

** Changed in: mysql-5.7 (Ubuntu Zesty)
   Status: New => Confirmed

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1721546

Title:
  max open files limit prevents max_connections over 214 on systemd

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1721546/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1721546] Re: max open files limit prevents max_connections over 214 on systemd

[Launchpad Bug Tracker]

Status changed to 'Confirmed' because the bug affects multiple users.

** Changed in: mysql-5.7 (Ubuntu Xenial)
   Status: New => Confirmed

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1721546

Title:
  max open files limit prevents max_connections over 214 on systemd

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1721546/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1721546] Re: max open files limit prevents max_connections over 214 on systemd

[Robie Basak]

This sounds reasonable to go into Debian as well, thanks. If someone can
please propose and test a commit against current Debian VCS, I'll be
happy to push it.

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1721546

Title:
  max open files limit prevents max_connections over 214 on systemd

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1721546/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1721546] Re: max open files limit prevents max_connections over 214 on systemd

[Nish Aravamudan]

Should this be fixed in Debian? Or at least reported there? So that it
does not add to the delta?

And is the underlying proposed fix to add the Service LimitNOFILE change
to the default mysql service file?

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1721546

Title:
  max open files limit prevents max_connections over 214 on systemd

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1721546/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1721546] Re: max open files limit prevents max_connections over 214 on systemd

[Nish Aravamudan]

Should this be fixed in Debian? Or at least reported there? So that it
does not add to the delta?

And is the underlying proposed fix to add the Service LimitNOFILE change
to the default mysql service file?

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-5.7 in Ubuntu.
Matching subscriptions: main
https://bugs.launchpad.net/bugs/1721546

Title:
  max open files limit prevents max_connections over 214 on systemd

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1721546/+subscriptions

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs

[Bug 1721546] Re: max open files limit prevents max_connections over 214 on systemd

[Mario Splivalo]

This can be easily circumvented manually by creating a systemd unit
override file for mysql service.

One should create a file, named
"/etc/systemd/system/mysql.service.d/limits.conf", with this contents
(just two lines):

[Service]
LimitNOFILE=infinity


This fix is now implemented in mysql juju charm: 
https://github.com/marcoceppi/charm-mysql/issues/20




** Bug watch added: github.com/marcoceppi/charm-mysql/issues #20
   https://github.com/marcoceppi/charm-mysql/issues/20

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1721546

Title:
  max open files limit prevents max_connections over 214 on systemd

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1721546/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1721546] Re: max open files limit prevents max_connections over 214 on systemd

[Eric Desrochers]

** Also affects: mysql-5.7 (Ubuntu Artful)
   Importance: Undecided
   Status: Confirmed

** Also affects: mysql-5.7 (Ubuntu Xenial)
   Importance: Undecided
   Status: New

** Also affects: mysql-5.7 (Ubuntu Zesty)
   Importance: Undecided
   Status: New

** Tags added: sts

** Changed in: mysql-5.7 (Ubuntu Artful)
 Assignee: (unassigned) => Mario Splivalo (mariosplivalo)

** Changed in: mysql-5.7 (Ubuntu Zesty)
 Assignee: (unassigned) => Mario Splivalo (mariosplivalo)

** Changed in: mysql-5.7 (Ubuntu Xenial)
 Assignee: (unassigned) => Mario Splivalo (mariosplivalo)

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1721546

Title:
  max open files limit prevents max_connections over 214 on systemd

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1721546/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1721546] Re: max open files limit prevents max_connections over 214 on systemd

[Launchpad Bug Tracker]

Status changed to 'Confirmed' because the bug affects multiple users.

** Changed in: mysql-5.7 (Ubuntu)
   Status: New => Confirmed

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1721546

Title:
  max open files limit prevents max_connections over 214 on systemd

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1721546/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs