** Description changed: I cannot start the mariadb server. From terminal: - $ systemctl status mariadb.service + $ 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" + 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 + [mysqldump] + quick + quote-names + max_allowed_packet = 16M MySQLVarLibDirListing: False PackageArchitecture: all SourcePackage: mariadb-10.3 UpgradeStatus: No upgrade log present (probably fresh install)
-- 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
