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

[Olaf van der Spek]

Package: mariadb-server-10.3
Version: 1:10.3.27-0+deb10u1
Followup-For: Bug #976652

Dear Maintainer,

> syslog.6.gz:Dec  5 18:56:49 dev mysqld[694]: 2020-12-05 18:56:49 0 [Warning] Could not increase number of max_open_files to more than 16384 (request: 32183)

Where does the 32183 come from? I don't see it in any conf file and it's not a value I'd set myself..

I'm not sure this isn't a 'bug'.

Greetings,

Olaf

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

Kernel: Linux 4.19.0-13-amd64 (SMP w/1 CPU core)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /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/mysql/mariadb.conf.d/50-server.cnf changed:
[mysqld]
user      = mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		  = 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
lc-messages-dir	= /usr/share/mysql
skip-external-locking
query_cache_size = 0
key_buffer_size		= 16M
max_allowed_packet	= 16M
thread_cache_size       = 8
myisam_recover_options  = BACKUP
log_error = /var/log/mysql/error.log
expire_logs_days	= 10
max_binlog_size   = 100M
character-set-server  = utf8mb4
collation-server      = utf8mb4_general_ci


-- debconf information:
  mariadb-server-10.3/old_data_directory_saved:
  mariadb-server-10.3/nis_warning:
  mariadb-server-10.3/postrm_remove_databases: false