[debian-mysql] Bug#976652: mariadb-server-10.3: Could not increase number of max_open_files to more than 16384 (request: 32191)

[Richard van den Berg]

Package: mariadb-server-10.3
Version: 1:10.3.27-0+deb10u1
Severity: normal

When starting the mariadb service it warns:

Dec  6 07:01:05 myhost mysqld[24031]: 2020-12-06  7:01:05 0 [Warning] Could not increase number of max_open_files to more than 16384 (request: 32191)

This warning is because /lib/systemd/system/mariadb.service contains:

LimitNOFILE=16384

Please increase this limit to 32191 as suggested by mariadb.

-- System Information:
Debian Release: 10.7
  APT prefers stable
  APT policy: (990, 'stable'), (500, 'stable-updates'), (500, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 4.19.0-9-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) (ignored: LC_ALL set to C.UTF-8), LANGUAGE=en_US:en (charmap=UTF-8) (ignored: LC_ALL set to C.UTF-8)
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages mariadb-server-10.3 depends on:
ii  adduser                   3.118
ii  debconf [debconf-2.0]     1.5.71
ii  galera-3                  25.3.25-2
ii  gawk                      1:4.2.1+dfsg-1
ii  iproute2                  4.20.0-2
ii  libc6                     2.28-10
ii  libdbi-perl               1.642-1+deb10u1
ii  libgnutls30               3.6.7-4+deb10u5
ii  libpam0g                  1.3.1-5
ii  libstdc++6                8.3.0-6
ii  lsb-base                  10.2019051400
ii  lsof                      4.91+dfsg-1
ii  mariadb-client-10.3       1:10.3.27-0+deb10u1
ii  mariadb-common            1:10.3.27-0+deb10u1
ii  mariadb-server-core-10.3  1:10.3.27-0+deb10u1
ii  passwd                    1:4.5-1.1
ii  perl                      5.28.1-6+deb10u1
ii  psmisc                    23.2-1
ii  rsync                     3.1.3-6
ii  socat                     1.7.3.2-2
ii  zlib1g                    1:1.2.11.dfsg-1

Versions of packages mariadb-server-10.3 recommends:
ii  libhtml-template-perl  2.97-1

Versions of packages mariadb-server-10.3 suggests:
ii  bsd-mailx [mailx]  8.1.2-0.20180807cvs-1
pn  mariadb-test       <none>
pn  netcat-openbsd     <none>
pn  tinyca             <none>

-- Configuration Files:
/etc/logcheck/ignore.d.paranoid/mariadb-server-10_3 [Errno 13] Permission denied: '/etc/logcheck/ignore.d.paranoid/mariadb-server-10_3'
/etc/logcheck/ignore.d.server/mariadb-server-10_3 [Errno 13] Permission denied: '/etc/logcheck/ignore.d.server/mariadb-server-10_3'
/etc/logcheck/ignore.d.workstation/mariadb-server-10_3 [Errno 13] Permission denied: '/etc/logcheck/ignore.d.workstation/mariadb-server-10_3'
/etc/logrotate.d/mysql-server changed [not included]

-- debconf information excluded