Public bug reported: 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) ** Affects: mariadb-10.3 (Ubuntu) Importance: Undecided Status: New ** Tags: amd64 apport-bug focal third-party-packages -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1927095 Title: Failed to start MariaDB 10.3.25 database server To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.3/+bug/1927095/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
