Failed to start MariaDB 10.3.25 database server

Bug #1927095 reported by Amr Ibrahim on 2021-05-04

This bug report will be marked for expiration in 57 days if no further activity occurs. (find out why)

6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
mariadb-10.3 (Ubuntu)
Undecided
Unassigned

Bug Description

I cannot start the mariadb server.

From terminal:

$ systemctl start mariadb.service
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.

-------------------------------------------------------------------------

From terminal:

$ systemctl status mariadb.service
● mariadb.service - MariaDB 10.3.25 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
     Active: failed (Result: exit-code) since Tue 2021-05-04 14:31:22 CEST; 4min 14s ago
       Docs: man:mysqld(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 91248 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
    Process: 91249 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 91251 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR |>
    Process: 91298 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
   Main PID: 91298 (code=exited, status=1/FAILURE)
     Status: "MariaDB server is down"

May 04 14:31:20 thinkpad systemd[1]: Starting MariaDB 10.3.25 database server...
May 04 14:31:21 thinkpad mysqld[91298]: 2021-05-04 14:31:21 0 [Note] /usr/sbin/mysqld (mysqld 10.3.25-MariaDB-0ubuntu0.20.04.1) starting as process 91298 ...
May 04 14:31:21 thinkpad mysqld[91298]: 2021-05-04 14:31:21 0 [Warning] Could not increase number of max_open_files to more than 16384 (request: 32190)
May 04 14:31:22 thinkpad systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
May 04 14:31:22 thinkpad systemd[1]: mariadb.service: Failed with result 'exit-code'.
May 04 14:31:22 thinkpad systemd[1]: Failed to start MariaDB 10.3.25 database server.

-------------------------------------------------------------------------

From terminal:

$ journalctl -xe
May 04 14:31:16 thinkpad polkitd(authority=local)[595]: Registered Authentication Agent for unix-process:91236:17328190 (system bus name :1.1123 [/usr/bin/pkttyagent --notify-fd 5 --fallback], object path /org/>
May 04 14:31:20 thinkpad polkitd(authority=local)[595]: Operator of unix-session:65 successfully authenticated as unix-user:amr to gain TEMPORARY authorization for action org.freedesktop.systemd1.manage-units f>
May 04 14:31:20 thinkpad systemd[1]: Starting MariaDB 10.3.25 database server...
-- Subject: A start job for unit mariadb.service has begun execution
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- A start job for unit mariadb.service has begun execution.
--
-- The job identifier is 14888.
May 04 14:31:21 thinkpad mysqld[91298]: 2021-05-04 14:31:21 0 [Note] /usr/sbin/mysqld (mysqld 10.3.25-MariaDB-0ubuntu0.20.04.1) starting as process 91298 ...
May 04 14:31:21 thinkpad mysqld[91298]: 2021-05-04 14:31:21 0 [Warning] Could not increase number of max_open_files to more than 16384 (request: 32190)
May 04 14:31:22 thinkpad systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
-- Subject: Unit process exited
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- An ExecStart= process belonging to unit mariadb.service has exited.
--
-- The process' exit code is 'exited' and its exit status is 1.
May 04 14:31:22 thinkpad systemd[1]: mariadb.service: Failed with result 'exit-code'.
-- Subject: Unit failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- The unit mariadb.service has entered the 'failed' state with result 'exit-code'.
May 04 14:31:22 thinkpad systemd[1]: Failed to start MariaDB 10.3.25 database server.
-- Subject: A start job for unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- A start job for unit mariadb.service has finished with a failure.
--
-- The job identifier is 14888 and the job result is failed.
May 04 14:31:22 thinkpad polkitd(authority=local)[595]: Unregistered Authentication Agent for unix-process:91236:17328190 (system bus name :1.1123, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, l>
May 04 14:31:54 thinkpad systemd[1]: Condition check resulted in Run anacron jobs being skipped.
-- Subject: A start job for unit anacron.service has finished successfully
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- A start job for unit anacron.service has finished successfully.
--
-- The job identifier is 14975.
May 04 14:34:11 thinkpad rtkit-daemon[1380]: Supervising 4 threads of 2 processes of 1 users.
May 04 14:34:11 thinkpad rtkit-daemon[1380]: Supervising 4 threads of 2 processes of 1 users.
May 04 14:34:35 thinkpad PackageKit[91048]: daemon quit
May 04 14:34:35 thinkpad systemd[1]: packagekit.service: Succeeded.
-- Subject: Unit succeeded
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- The unit packagekit.service has successfully entered the 'dead' state.

-------------------------------------------------------------------------

ProblemType: Bug
DistroRelease: Ubuntu 20.04
Package: mariadb-server 1:10.3.25-0ubuntu0.20.04.1
ProcVersionSignature: Ubuntu 5.8.0-50.56~20.04.1-generic 5.8.18
Uname: Linux 5.8.0-50-generic x86_64
ApportVersion: 2.20.11-0ubuntu27.16
Architecture: amd64
CasperMD5CheckResult: skip
CurrentDesktop: ubuntu:GNOME
Date: Tue May 4 14:33:55 2021
InstallationDate: Installed on 2020-04-26 (372 days ago)
InstallationMedia: Ubuntu 20.04 LTS "Focal Fossa" - Release amd64 (20200423)
Logs.var.log.daemon.log:

MySQLConf.etc.mysql.conf.d.mysql.cnf: [mysql]
MySQLConf.etc.mysql.conf.d.mysqldump.cnf:
 [mysqldump]
 quick
 quote-names
 max_allowed_packet = 16M
MySQLVarLibDirListing: False
PackageArchitecture: all
SourcePackage: mariadb-10.3
UpgradeStatus: No upgrade log present (probably fresh install)

Amr Ibrahim (amribrahim1987) wrote :
description: updated
Faustin (fauust) wrote :

Hi Amr!
Thanks for your report and for your help in making Ubuntu better.

Can you please try the solution explained here https://mariadb.com/kb/en/systemd/#configuring-the-open-files-limit?

Your instance of mariadb-server seems to be asking a more than the default one (LimitNOFILE=16384).

Regards,
Faustin

Changed in mariadb-10.3 (Ubuntu):
status: New → Incomplete
To post a comment you must log in.