Ошибка юнита mariadb service - Ремонт и установка крупной бытовой техники

I’m using Fedora 29.
I’m try to run mariadb.service with command:
systemctl start mariadb,
and give error:
Failed to start mariadb.service: Unit mariadb.service not found.

Also, I tried next commands:
systemctl status mariadb
Unit mariadb.service could not be found.

systemctl start mariadb.service
Failed to start mariadb.service: Unit mariadb.service not found.

systemctl start mysql
Failed to start mysql.service: Unit mysql.service not found.

systemctl enable mariadb
Failed to enable unit: Unit file mariadb.service does not exist.

systemctl daemon-reload
<nothing to output>

I trying this with sudo and without. The result is same.

mariadb-server is installed:
dnf install mariadb-server Package mysql-community-server-8.0.15-1.fc29.x86_64 already installed.

Just starting to use Linux, I can not understand what’s the trouble.

Ruslan

6,0501 gold badge20 silver badges36 bronze badges

asked Feb 3, 2019 at 8:57

You have MySQL 8 installed which is why your installation of MariaDB failed: the two conflict and you must pick which one you want.

If you want to install MariaDB, you first have to uninstall MySQL 8 first:

dnf remove mysql-community-server
dnf install mariadb-server

Historically, both MySQL and MariaDB used to use mysql as the service name. The MySQL 8 package uses only the mysql service name whereas MariaDB has both mariadb and mysql services, the latter being an alias to the mariadb one.

MariaDB added its own service name quite early on in the 10 series of releases and has added aliases for other commands as well. For example, the mariadb command is the same program as the mysql command in MariaDB 10.5.

answered Nov 13, 2021 at 20:29

markusjmmarkusjm

2,3031 gold badge11 silver badges23 bronze badges

It was quite confusing to me too. I followed several instructions found online but it seems that even talking about the same version 5.5 there are quite a few different ways to start the service after installation. I finally accidentally tried mysql and it worked.

when seeing this after a successful installation:

Installed: MariaDB-server.x86_64 0:5.5.67-1.el7.centos

Dependency Installed: MariaDB-client.x86_64 0:5.5.67-1.el7.centos

Complete!

and I tried:

$ sudo systemctl start mariadb

Failed to start mariadb.service: Unit not found.

and I tried:

$ sudo systemctl start mysql

there was a silence.
and I tried:

$ sudo systemctl status mysql

It said it’s active(running).

answered May 6, 2020 at 19:00

you can use rpm -ql mysql-community-server-8.0.15-1 in order to find where the package is installed. then you can find executables from this path and try to run it

answered Feb 3, 2019 at 16:12

Источник

2

1

mariadb ставил из офф репозитория.Всё работало до перезагрузки.Перезагрузился служба не стартует,удалил всё,установил заново,после перезагрузки такая же проблема.Конфиги не правил,все по дэфолту.Подскажите где искать проблему?С mysql особо не дружу.


palamar@home:~$ sudo /etc/init.d/mysql start
[....] Starting mysql (via systemctl): mysql.serviceJob for mariadb.service failed because a timeout was exceeded. See "systemctl status mariadb.service" and "journalctl -xe" for details.
 failed!

palamar@home:~$ journalctl -xe
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [Note] InnoDB: Waiting for purge to start
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [Note] InnoDB: 5.7.21 started; log sequence number 44849714
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140299082897152 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [Note] Plugin 'FEEDBACK' is disabled.
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [Note] Server socket created on IP: '127.0.0.1'.
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [ERROR] mysql.user has no `Event_priv` column at position 29
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at posit
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Di
Мар 17 15:03:36 home audit[6373]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [Note] Reading of all Master_info entries succeded
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [Note] Added new Master_info '' to hash table
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [Note] /usr/sbin/mysqld: ready for connections.
Мар 17 15:03:36 home mysqld[6373]: Version: '10.2.13-MariaDB-10.2.13+maria~xenial-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary
Мар 17 15:03:36 home kernel: audit: type=1400 audit(1521291816.893:43): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" e
Мар 17 15:03:37 home mysqld[6373]: 2018-03-17 15:03:37 140299082897152 [Note] InnoDB: Buffer pool(s) load completed at 180317 15:03:37
Мар 17 15:03:58 home sshd[6414]: Bad protocol version identification '03' from 10.10.10.10 port 54943
Мар 17 15:05:06 home systemd[1]: mariadb.service: Start operation timed out. Terminating.
Мар 17 15:05:06 home mysqld[6373]: 2018-03-17 15:05:06 140299674679040 [Note] /usr/sbin/mysqld (unknown): Normal shutdown
Мар 17 15:05:06 home audit[6373]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
Мар 17 15:05:06 home mysqld[6373]: 2018-03-17 15:05:06 140299124860672 [Note] InnoDB: FTS optimize thread exiting.
Мар 17 15:05:06 home kernel: audit: type=1400 audit(1521291906.672:44): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" e
Мар 17 15:05:06 home mysqld[6373]: 2018-03-17 15:05:06 140299674679040 [Note] InnoDB: Starting shutdown...
Мар 17 15:05:06 home mysqld[6373]: 2018-03-17 15:05:06 140299082897152 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
Мар 17 15:05:06 home mysqld[6373]: 2018-03-17 15:05:06 140299082897152 [Note] InnoDB: Buffer pool(s) dump completed at 180317 15:05:06
Мар 17 15:05:07 home mysqld[6373]: 2018-03-17 15:05:07 140299674679040 [Note] InnoDB: Shutdown completed; log sequence number 44849742
Мар 17 15:05:07 home mysqld[6373]: 2018-03-17 15:05:07 140299674679040 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Мар 17 15:05:07 home mysqld[6373]: 2018-03-17 15:05:07 140299674679040 [Note] /usr/sbin/mysqld: Shutdown complete
Мар 17 15:05:07 home audit[6373]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
Мар 17 15:05:07 home audit[6373]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
Мар 17 15:05:07 home kernel: audit: type=1400 audit(1521291907.515:45): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" e
Мар 17 15:05:07 home kernel: audit: type=1400 audit(1521291907.515:46): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" e
Мар 17 15:05:07 home systemd[1]: Failed to start MariaDB 10.2.13 database server.
-- Subject: Ошибка юнита mariadb.service
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Произошел сбой юнита mariadb.service.
-- 
-- Результат: failed.
Мар 17 15:05:07 home systemd[1]: mariadb.service: Unit entered failed state.
Мар 17 15:05:07 home systemd[1]: mariadb.service: Failed with result 'timeout'.
Мар 17 15:05:07 home sudo[6194]: pam_unix(sudo:session): session closed for user root

Источник

I am somewhat new to Linux, testing various LAMP setups in Virtualbox on Windows. Currently I have a Centos 7 VM that I am trying to install MariaDB on. I am following instructions here: http://www.tecmint.com/install-lamp-in-centos-7

I ran

# yum install mariadb-server mariadb

Installation was successful according to terminal output, but when I run:

 # systemctl start mariadb

I get

Failed to start mariadb.service: Unit not found.

I spent past couple of hours googling this, but nothing seems to solve my issue, inlcuding this (No mysqld or mysql.server after mariadb-server install) and many other posts.

Any help is greatly appreciated.

UPDATE 01

I uninstalled mariadb:

[root@centos7 admin]# yum remove mysql
Loaded plugins: fastestmirror
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-client.x86_64 0:10.0.30-1.el7.centos will be erased
--> Processing Dependency: MariaDB-client for package: MariaDB-server-10.0.30-1.el7.centos.x86_64
--> Running transaction check
---> Package MariaDB-server.x86_64 0:10.0.30-1.el7.centos will be erased
--> Finished Dependency Resolution

Dependencies Resolved

===================================================================================
 Package              Arch         Version                    Repository      Size
===================================================================================
Removing:
 MariaDB-client       x86_64       10.0.30-1.el7.centos       @mariadb        49 M
Removing for dependencies:
 MariaDB-server       x86_64       10.0.30-1.el7.centos       @mariadb       237 M

Transaction Summary
===================================================================================
Remove  1 Package (+1 Dependent package)

Installed size: 286 M
Is this ok [y/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Erasing    : MariaDB-server-10.0.30-1.el7.centos.x86_64                      1/2
  Erasing    : MariaDB-client-10.0.30-1.el7.centos.x86_64                      2/2
  Verifying  : MariaDB-client-10.0.30-1.el7.centos.x86_64                      1/2
  Verifying  : MariaDB-server-10.0.30-1.el7.centos.x86_64                      2/2

Removed:
  MariaDB-client.x86_64 0:10.0.30-1.el7.centos

Dependency Removed:
  MariaDB-server.x86_64 0:10.0.30-1.el7.centos

Complete!

ran yum clean all and yum update

reinstalled mariadb:

# yum install mariadb-server mariadb
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * Webmin: download.webmin.com
 * base: anorien.csc.warwick.ac.uk
 * extras: centos.mirrors.nublue.co.uk
 * updates: centos.serverspace.co.uk
Package mariadb-server is obsoleted by MariaDB-server, trying to install MariaDB-server-10.0.30-1.el7.centos.x86_64 instead
Package mariadb is obsoleted by MariaDB-client, trying to install MariaDB-client-10.0.30-1.el7.centos.x86_64 instead
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-client.x86_64 0:10.0.30-1.el7.centos will be installed
---> Package MariaDB-server.x86_64 0:10.0.30-1.el7.centos will be installed
--> Finished Dependency Resolution

Dependencies Resolved

===================================================================================
 Package              Arch         Version                     Repository     Size
===================================================================================
Installing:
 MariaDB-client       x86_64       10.0.30-1.el7.centos        mariadb        10 M
 MariaDB-server       x86_64       10.0.30-1.el7.centos        mariadb        55 M

Transaction Summary
===================================================================================
Install  2 Packages

Total download size: 65 M
Installed size: 65 M
Is this ok [y/d/N]: y
Downloading packages:
(1/2): MariaDB-10.0.30-centos7-x86_64-client.rpm            |  10 MB  00:00:22
(2/2): MariaDB-10.0.30-centos7-x86_64-server.rpm            |  55 MB  00:01:15
-----------------------------------------------------------------------------------
Total                                                 876 kB/s |  65 MB  01:15
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : MariaDB-client-10.0.30-1.el7.centos.x86_64                      1/2
  Installing : MariaDB-server-10.0.30-1.el7.centos.x86_64                      2/2
libsemanage.map_file: Unable to open /usr/share/mysql/SELinux/mariadb.pp
 (No such file or directory).
libsemanage.semanage_direct_install_file: Unable to read file /usr/share/mysql/SELinux/mariadb.pp
 (No such file or directory).
/usr/sbin/semodule:  Failed on /usr/share/mysql/SELinux/mariadb.pp!
  Verifying  : MariaDB-client-10.0.30-1.el7.centos.x86_64                      1/2
  Verifying  : MariaDB-server-10.0.30-1.el7.centos.x86_64                      2/2

Installed:
  MariaDB-client.x86_64 0:10.0.30-1.el7.centos
  MariaDB-server.x86_64 0:10.0.30-1.el7.centos

Complete!

Still no go, what gives?

# systemctl start mariadb.service
Failed to start mariadb.service: Unit not found.

UPDATE 02

There could be something with package versions and capitalization, I used mariaDB repos instead of centos for installation, so it picked up version 10.0.30:

]# yum info mariadb-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * Webmin: download.webmin.com
 * base: anorien.csc.warwick.ac.uk
 * extras: centos.mirrors.nublue.co.uk
 * updates: centos.serverspace.co.uk
Installed Packages
Name        : MariaDB-server
Arch        : x86_64
Version     : 10.0.30
Release     : 1.el7.centos
Size        : 237 M
Repo        : installed
From repo   : mariadb
Summary     : MariaDB: a very fast and robust SQL database server
URL         : http://mariadb.org
License     : GPLv2
Description : MariaDB: a very fast and robust SQL database server
            :
            : It is GPL v2 licensed, which means you can use the it free of charge
            : under the conditions of the GNU General Public License Version 2
            : (http://www.gnu.org/licenses/).
            :
            : MariaDB documentation can be found at https://mariadb.com/kb
            : MariaDB bug reports should be submitted through
            : https://jira.mariadb.org

Available Packages
Name        : mariadb-server
Arch        : x86_64
Epoch       : 1
Version     : 5.5.52
Release     : 1.el7
Size        : 11 M
Repo        : base/7/x86_64
Summary     : The MariaDB server and related files
URL         : http://mariadb.org
License     : GPLv2 with exceptions and LGPLv2 and BSD
Description : MariaDB is a multi-user, multi-threaded SQL database server. It is a
            : client/server implementation consisting of a server daemon (mysqld)
            : and many different client programs and libraries. This package
            : contains the MariaDB server and some accompanying files and
            : directories. MariaDB is a community developed branch of MySQL.

Источник

I’m using Fedora 29.
I’m try to run mariadb.service with command:
systemctl start mariadb,
and give error:
Failed to start mariadb.service: Unit mariadb.service not found.

Also, I tried next commands:
systemctl status mariadb
Unit mariadb.service could not be found.

systemctl start mariadb.service
Failed to start mariadb.service: Unit mariadb.service not found.

systemctl start mysql
Failed to start mysql.service: Unit mysql.service not found.

systemctl enable mariadb
Failed to enable unit: Unit file mariadb.service does not exist.

systemctl daemon-reload
<nothing to output>

I trying this with sudo and without. The result is same.

mariadb-server is installed:
dnf install mariadb-server Package mysql-community-server-8.0.15-1.fc29.x86_64 already installed.

Just starting to use Linux, I can not understand what’s the trouble.

Ruslan

5,9901 gold badge20 silver badges36 bronze badges

asked Feb 3, 2019 at 8:57

You have MySQL 8 installed which is why your installation of MariaDB failed: the two conflict and you must pick which one you want.

If you want to install MariaDB, you first have to uninstall MySQL 8 first:

dnf remove mysql-community-server
dnf install mariadb-server

answered Nov 13, 2021 at 20:29

markusjmmarkusjm

2,1941 gold badge10 silver badges22 bronze badges

when seeing this after a successful installation:

Installed: MariaDB-server.x86_64 0:5.5.67-1.el7.centos

Dependency Installed: MariaDB-client.x86_64 0:5.5.67-1.el7.centos

Complete!

and I tried:

$ sudo systemctl start mariadb

Failed to start mariadb.service: Unit not found.

and I tried:

$ sudo systemctl start mysql

there was a silence.
and I tried:

$ sudo systemctl status mysql

It said it’s active(running).

answered May 6, 2020 at 19:00

you can use rpm -ql mysql-community-server-8.0.15-1 in order to find where the package is installed. then you can find executables from this path and try to run it

answered Feb 3, 2019 at 16:12

I ran

# yum install mariadb-server mariadb

Installation was successful according to terminal output, but when I run:

 # systemctl start mariadb

I get

Failed to start mariadb.service: Unit not found.

I spent past couple of hours googling this, but nothing seems to solve my issue, inlcuding this (No mysqld or mysql.server after mariadb-server install) and many other posts.

Any help is greatly appreciated.

UPDATE 01

I uninstalled mariadb:

[root@centos7 admin]# yum remove mysql
Loaded plugins: fastestmirror
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-client.x86_64 0:10.0.30-1.el7.centos will be erased
--> Processing Dependency: MariaDB-client for package: MariaDB-server-10.0.30-1.el7.centos.x86_64
--> Running transaction check
---> Package MariaDB-server.x86_64 0:10.0.30-1.el7.centos will be erased
--> Finished Dependency Resolution

Dependencies Resolved

===================================================================================
 Package              Arch         Version                    Repository      Size
===================================================================================
Removing:
 MariaDB-client       x86_64       10.0.30-1.el7.centos       @mariadb        49 M
Removing for dependencies:
 MariaDB-server       x86_64       10.0.30-1.el7.centos       @mariadb       237 M

Transaction Summary
===================================================================================
Remove  1 Package (+1 Dependent package)

Installed size: 286 M
Is this ok [y/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Erasing    : MariaDB-server-10.0.30-1.el7.centos.x86_64                      1/2
  Erasing    : MariaDB-client-10.0.30-1.el7.centos.x86_64                      2/2
  Verifying  : MariaDB-client-10.0.30-1.el7.centos.x86_64                      1/2
  Verifying  : MariaDB-server-10.0.30-1.el7.centos.x86_64                      2/2

Removed:
  MariaDB-client.x86_64 0:10.0.30-1.el7.centos

Dependency Removed:
  MariaDB-server.x86_64 0:10.0.30-1.el7.centos

Complete!

ran yum clean all and yum update

reinstalled mariadb:

# yum install mariadb-server mariadb
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * Webmin: download.webmin.com
 * base: anorien.csc.warwick.ac.uk
 * extras: centos.mirrors.nublue.co.uk
 * updates: centos.serverspace.co.uk
Package mariadb-server is obsoleted by MariaDB-server, trying to install MariaDB-server-10.0.30-1.el7.centos.x86_64 instead
Package mariadb is obsoleted by MariaDB-client, trying to install MariaDB-client-10.0.30-1.el7.centos.x86_64 instead
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-client.x86_64 0:10.0.30-1.el7.centos will be installed
---> Package MariaDB-server.x86_64 0:10.0.30-1.el7.centos will be installed
--> Finished Dependency Resolution

Dependencies Resolved

===================================================================================
 Package              Arch         Version                     Repository     Size
===================================================================================
Installing:
 MariaDB-client       x86_64       10.0.30-1.el7.centos        mariadb        10 M
 MariaDB-server       x86_64       10.0.30-1.el7.centos        mariadb        55 M

Transaction Summary
===================================================================================
Install  2 Packages

Total download size: 65 M
Installed size: 65 M
Is this ok [y/d/N]: y
Downloading packages:
(1/2): MariaDB-10.0.30-centos7-x86_64-client.rpm            |  10 MB  00:00:22
(2/2): MariaDB-10.0.30-centos7-x86_64-server.rpm            |  55 MB  00:01:15
-----------------------------------------------------------------------------------
Total                                                 876 kB/s |  65 MB  01:15
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : MariaDB-client-10.0.30-1.el7.centos.x86_64                      1/2
  Installing : MariaDB-server-10.0.30-1.el7.centos.x86_64                      2/2
libsemanage.map_file: Unable to open /usr/share/mysql/SELinux/mariadb.pp
 (No such file or directory).
libsemanage.semanage_direct_install_file: Unable to read file /usr/share/mysql/SELinux/mariadb.pp
 (No such file or directory).
/usr/sbin/semodule:  Failed on /usr/share/mysql/SELinux/mariadb.pp!
  Verifying  : MariaDB-client-10.0.30-1.el7.centos.x86_64                      1/2
  Verifying  : MariaDB-server-10.0.30-1.el7.centos.x86_64                      2/2

Installed:
  MariaDB-client.x86_64 0:10.0.30-1.el7.centos
  MariaDB-server.x86_64 0:10.0.30-1.el7.centos

Complete!

Still no go, what gives?

# systemctl start mariadb.service
Failed to start mariadb.service: Unit not found.

UPDATE 02

There could be something with package versions and capitalization, I used mariaDB repos instead of centos for installation, so it picked up version 10.0.30:

]# yum info mariadb-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * Webmin: download.webmin.com
 * base: anorien.csc.warwick.ac.uk
 * extras: centos.mirrors.nublue.co.uk
 * updates: centos.serverspace.co.uk
Installed Packages
Name        : MariaDB-server
Arch        : x86_64
Version     : 10.0.30
Release     : 1.el7.centos
Size        : 237 M
Repo        : installed
From repo   : mariadb
Summary     : MariaDB: a very fast and robust SQL database server
URL         : http://mariadb.org
License     : GPLv2
Description : MariaDB: a very fast and robust SQL database server
            :
            : It is GPL v2 licensed, which means you can use the it free of charge
            : under the conditions of the GNU General Public License Version 2
            : (http://www.gnu.org/licenses/).
            :
            : MariaDB documentation can be found at https://mariadb.com/kb
            : MariaDB bug reports should be submitted through
            : https://jira.mariadb.org

Available Packages
Name        : mariadb-server
Arch        : x86_64
Epoch       : 1
Version     : 5.5.52
Release     : 1.el7
Size        : 11 M
Repo        : base/7/x86_64
Summary     : The MariaDB server and related files
URL         : http://mariadb.org
License     : GPLv2 with exceptions and LGPLv2 and BSD
Description : MariaDB is a multi-user, multi-threaded SQL database server. It is a
            : client/server implementation consisting of a server daemon (mysqld)
            : and many different client programs and libraries. This package
            : contains the MariaDB server and some accompanying files and
            : directories. MariaDB is a community developed branch of MySQL.

05.07.2022

Здравствуйте.
Из репо Астралинукс установил mariadb, однако сервер запускаться отказывается. Ругается на то, что юнит службы не сконфигурирован.

root@sw-management:/etc/apt# systemctl start mariadb
Job for mariadb.service failed because the service did not take the steps required by its unit configuration.
See «systemctl status mariadb.service» and «journalctl -xe» for details.
root@sw-management:/etc/apt# journalctl -xe

— Subject: Начинается запуск юнита mariadb.service
— Defined-By: systemd
— Support: https://www.rusbitech.ru/support
—
— Начат процесс запуска юнита mariadb.service.
июл 05 15:46:16 sw-management systemd[1]: mariadb.service: Failed with result ‘protocol’.
— Subject: Unit failed
— Defined-By: systemd
— Support: https://www.rusbitech.ru/support
—
— The unit mariadb.service has entered the ‘failed’ state with result ‘protocol’.
июл 05 15:46:16 sw-management systemd[1]: Failed to start MariaDB 10.3.27 database server.
— Subject: Ошибка юнита mariadb.service
— Defined-By: systemd
— Support: https://www.rusbitech.ru/support
—
— Произошел сбой юнита mariadb.service.
—
— Результат: failed.
июл 05 15:46:16 sw-management audit[1]: SERVICE_START pid=1 uid=0 auid=4294967295 ses=4294967295 subj=0:0:0:0 msg=’unit=mariadb comm=»systemd» exe=»/usr/lib/systemd/systemd» hostname=? addr=? terminal=? res=failed’

июл 05 15:47:03 sw-management systemd[1]: Starting MariaDB 10.3.27 database server…
— Subject: Начинается запуск юнита mariadb.service
— Defined-By: systemd
— Support: https://www.rusbitech.ru/support
—
— Начат процесс запуска юнита mariadb.service.
июл 05 15:47:03 sw-management systemd[1]: mariadb.service: Failed with result ‘protocol’.
— Subject: Unit failed
— Defined-By: systemd
— Support: https://www.rusbitech.ru/support
—
— The unit mariadb.service has entered the ‘failed’ state with result ‘protocol’.
июл 05 15:47:03 sw-management systemd[1]: Failed to start MariaDB 10.3.27 database server.
— Subject: Ошибка юнита mariadb.service
— Defined-By: systemd
— Support: https://www.rusbitech.ru/support
—
— Произошел сбой юнита mariadb.service.
—
— Результат: failed.
июл 05 15:47:03 sw-management audit[1]: SERVICE_START pid=1 uid=0 auid=4294967295 ses=4294967295 subj=0:0:0:0 msg=’unit=mariadb comm=»systemd» exe=»/usr/lib/systemd/systemd» hostname=? addr=? terminal=? res=failed’

Подскажите, пожалуйста, какие действия требуется произвести? Почему «из коробки» дефолтная конфигурация не работает?

06.07.2022

скорее всего потому, что в рбт…..
но смотрите сами

07.07.2022

Спасибо за ответ. А насчёт СУБД, к сожалению, два дням ушло на выяснение, что версия 3.27 , которая в репозитории астры мэйн, не работоспособная. 10.3.31 встала сразу и заработала.

08.07.2022

Ciao, I am really happy to have found such a great web blog, it’s toally the thing my friends from work and I are searching for. all of secrets on the forum is completely magical and is going to benefit my friends and I twice a week or more. It looks like the site has a significant amount of details concerning this and other pages and information definitely shows. I’m not usually on the net during the week so when we get an opportunity i’m more often than not are perusing for similarly types of information or things similarly sharing simliar helpful tricks. I have one of my friends that assumed an interest in this because of what I have found out about it and they’re for sure to visit the website because it is such an excellent discovery. I am also facsinated in politics and coping with the new changes in world politics I have another forum I just created Thursday about seo … [color=#000_url]Professsional SEO Arkansas[/color] give me a jingle.

Hi I have installed MariaDB server and mariaDB client, php7.0-mysql on my fresh Ubuntu 16.04 VPS, but after installation I cant login using PhpMyAdmin, when I am trying to login using PHPMyAdmin its always give Access denied for user ‘root’@’localhost’ error.

here is some info.
If try to get status

root@ubuntu-2gb-ams2-01:/var/lib# service mariadb status
● mariadb.service
   Loaded: not-found (Reason: No such file or directory)
   Active: inactive (dead)

When I tried to start get this

# service mariadb start
Failed to start mariadb.service: Unit mariadb.service not found.

I can login and create new database with SSH

root@ubuntu-2gb-ams2-01:/var/lib# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or g.
Your MariaDB connection id is 61
Server version: 10.0.27-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

MariaDB [(none)]> create database protest;
Query OK, 1 row affected (0.00 sec)

If I want to see database then I can see all database

root@ubuntu-2gb-ams2-01:/var/lib# mysql -u root -p -e 'show databases'
Enter password:
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| protest            |
+--------------------+

So its look like Mariadb is installed but cant understand why status showing dead, start/restart not working, front end login not working (using phpmyadmin, can anyone give a clue?

UPDATE: I just created another DB and user, I can login that user and access db using phpmyadmin.

So I tried to start mariadb.service and following the steps from the wiki https://wiki.archlinux.org/title/MariaDB and got this.

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

After searching I found this forum post https://bbs.archlinux.org/viewtopic.php?id=240842 that I hoped it would fix my problem. It didn’t

Here is what happened when I tried the solution in the post.

$ sudo rm /etc/systemd/system/mariadb.service.d/mariadb.conf
rm: cannot remove '/etc/systemd/system/mariadb.service.d/mariadb.conf': No such file or directory

I have also tried removing and reinstalling mariadb after cleaning /var/lib/mysql with no results

Thus I am asking for help in this post.

Here are the relevant outputs.

$ sudo systemctl cat mariadb.service
# /usr/lib/systemd/system/mariadb.service
# It's not recommended to modify this file in-place, because it will be
# overwritten during package upgrades.  If you want to customize, the
# best way is to create a file "/etc/systemd/system/mariadb.service",
# containing
#	.include /usr/lib/systemd/system/mariadb.service
#	...make your changes here...
# or create a file "/etc/systemd/system/mariadb.service.d/foo.conf",
# which doesn't need to include ".include" call and which will be parsed
# after the file mariadb.service itself is parsed.
#
# For more info about custom unit files, see systemd.unit(5) or
# https://mariadb.com/kb/en/mariadb/systemd/
#
# Copyright notice:
#
# This file is free software; you can redistribute it and/or modify it
# under the terms of the GNU Lesser General Public License as published by
# the Free Software Foundation; either version 2.1 of the License, or
# (at your option) any later version.

[Unit]
Description=MariaDB 10.5.11 database server
Documentation=man:mariadbd(8)
Documentation=https://mariadb.com/kb/en/library/systemd/
After=network.target

[Install]
WantedBy=multi-user.target


[Service]

##############################################################################
## Core requirements
##

Type=notify

# Setting this to true can break replication and the Type=notify settings
# See also bind-address mariadbd option.
PrivateNetwork=false

##############################################################################
## Package maintainers
##

User=mysql
Group=mysql

# CAP_IPC_LOCK To allow memlock to be used as non-root user
# CAP_DAC_OVERRIDE To allow auth_pam_tool (which is SUID root) to read /etc/shadow when it's chmod 0
#   does nothing for non-root, not needed if /etc/shadow is u+r
# CAP_AUDIT_WRITE auth_pam_tool needs it on Debian for whatever reason
CapabilityBoundingSet=CAP_IPC_LOCK CAP_DAC_OVERRIDE CAP_AUDIT_WRITE

# PrivateDevices=true implies NoNewPrivileges=true and
# SUID auth_pam_tool suddenly doesn't do setuid anymore
PrivateDevices=false

# Prevent writes to /usr, /boot, and /etc
ProtectSystem=full

# Doesn't yet work properly with SELinux enabled
# NoNewPrivileges=true

# Prevent accessing /home, /root and /run/user
ProtectHome=true

# Execute pre and post scripts as root, otherwise it does it as User=
PermissionsStartOnly=true



# Perform automatic wsrep recovery. When server is started without wsrep,
# galera_recovery simply returns an empty string. In any case, however,
# the script is not expected to return with a non-zero status.
# It is always safe to unset _WSREP_START_POSITION environment variable.
# Do not panic if galera_recovery script is not available. (MDEV-10538)
ExecStartPre=/bin/sh -c "systemctl unset-environment _WSREP_START_POSITION"
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 || exit 1"

# Needed to create system tables etc.
# ExecStartPre=/usr/bin/mysql_install_db -u mysql

# Start main service
# MYSQLD_OPTS here is for users to set in /etc/systemd/system/mariadb.service.d/MY_SPECIAL.conf
# Use the [Service] section and Environment="MYSQLD_OPTS=...".
# This isn't a replacement for my.cnf.
# _WSREP_NEW_CLUSTER is for the exclusive use of the script galera_new_cluster
ExecStart=/usr/bin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION

# Unset _WSREP_START_POSITION environment variable.
ExecStartPost=/bin/sh -c "systemctl unset-environment _WSREP_START_POSITION"



KillSignal=SIGTERM

# Don't want to see an automated SIGKILL ever
SendSIGKILL=no

# Restart crashed server only, on-failure would also restart, for example, when
# my.cnf contains unknown option
Restart=on-abort
RestartSec=5s

UMask=007

##############################################################################
## USERs can override
##
##
## by creating a file in /etc/systemd/system/mariadb.service.d/MY_SPECIAL.conf
## and adding/setting the following under [Service] will override this file's
## settings.

# Useful options not previously available in [mysqld_safe]

# Kernels like killing mariadbd when out of memory because its big.
# Lets temper that preference a little.
# OOMScoreAdjust=-600

# Explicitly start with high IO priority
# BlockIOWeight=1000

# If you don't use the /tmp directory for SELECT ... OUTFILE and
# LOAD DATA INFILE you can enable PrivateTmp=true for a little more security.
PrivateTmp=true

# Set an explicit Start and Stop timeout of 900 seconds (15 minutes!)
# this is the same value as used in SysV init scripts in the past
# Galera might need a longer timeout, check the KB if you want to change this:
# https://mariadb.com/kb/en/library/systemd/#configuring-the-systemd-service-timeout
TimeoutStartSec=900
TimeoutStopSec=900

##
## Options previously available to be set via [mysqld_safe]
## that now needs to be set by systemd config files as mysqld_safe
## isn't executed.
##

# Number of files limit. previously [mysqld_safe] open-files-limit
LimitNOFILE=32768

# Maximium core size. previously [mysqld_safe] core-file-size
# LimitCore=

# Nice priority. previously [mysqld_safe] nice
# Nice=-5

# Timezone. previously [mysqld_safe] timezone
# Environment="TZ=UTC"

# Library substitutions. previously [mysqld_safe] malloc-lib with explicit paths
# (in LD_LIBRARY_PATH) and library name (in LD_PRELOAD).
# Environment="LD_LIBRARY_PATH=/path1 /path2" "LD_PRELOAD=
Environment="LD_PRELOAD=/usr/lib/libjemalloc.so"

# Flush caches. previously [mysqld_safe] flush-caches=1
# ExecStartPre=sync
# ExecStartPre=sysctl -q -w vm.drop_caches=3

# numa-interleave=1 equalivant
# Change ExecStart=numactl --interleave=all /usr/bin/mariadbd......

# crash-script equalivent
# FailureAction=

$ sudo systemctl status mariadb.service
x mariadb.service - MariaDB 10.5.11 database server
     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
     Active: failed (Result: exit-code) since Thu 2021-07-01 02:39:47 EEST; 23s ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 327118 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 327120 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 || exit 1 (code=exited, status=0/SUCCESS)
    Process: 327129 ExecStart=/usr/bin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
   Main PID: 327129 (code=exited, status=1/FAILURE)
     Status: "MariaDB server is down"
        CPU: 84ms

Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01  2:39:47 0 [Note] InnoDB: 10.5.11 started; log sequence number 45130; transaction id 20
Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01  2:39:47 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01  2:39:47 0 [Note] InnoDB: Buffer pool(s) load completed at 210701  2:39:47
Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01  2:39:47 0 [Note] Server socket created on IP: '::'.
Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01  2:39:47 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01  2:39:47 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01  2:39:47 0 [ERROR] Aborting
Jul 01 02:39:47 myPC systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jul 01 02:39:47 myPC systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jul 01 02:39:47 myPC systemd[1]: Failed to start MariaDB 10.5.11 database server.

$ sudo journalctl -xeu mariadb.service -- Journal begins at Sat 2021-04-24 22:44:50 EEST, ends at Thu 2021-07-01 02:40:42 EEST. -- Jun 28 21:55:00 myPC systemd[1]: Starting MariaDB 10.5.10 database server... -- Subject: A start job for unit mariadb.service has begun execution -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- A start job for unit mariadb.service has begun execution. -- -- The job identifier is 1634. Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] /usr/bin/mariadbd (mysqld 10.5.10-MariaDB) starting as process 182330 ... Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created! Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] InnoDB: Uses event mutexes Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] InnoDB: Number of pools: 1 Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts) Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] InnoDB: Using Linux native AIO Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] InnoDB: Completed initialization of buffer pool Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] InnoDB: Setting file './ibdata1' size to 12 MB. Physically writing the file full; Please wait ... Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] InnoDB: File './ibdata1' size is now 12 MB. Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 100663296 bytes Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] InnoDB: New log file created, LSN=10317 Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] InnoDB: Doublewrite buffer not found: creating new Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] InnoDB: Doublewrite buffer created Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] InnoDB: 128 rollback segments are active. Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] InnoDB: Creating foreign key constraint system tables. Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] InnoDB: Creating tablespace and datafile system tables. Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] InnoDB: Creating sys_virtual system tables. Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] InnoDB: 10.5.10 started; log sequence number 0; transaction id 7 Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [Note] Server socket created on IP: '::'. Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? Jun 28 21:55:00 myPC mariadbd[182330]: 2021-06-28 21:55:00 0 [ERROR] Aborting Jun 28 21:55:00 myPC systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE -- Subject: Unit process exited -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- An ExecStart= process belonging to unit mariadb.service has exited. -- -- The process' exit code is 'exited' and its exit status is 1. Jun 28 21:55:00 myPC systemd[1]: mariadb.service: Failed with result 'exit-code'. -- Subject: Unit failed -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- The unit mariadb.service has entered the 'failed' state with result 'exit-code'. Jun 28 21:55:00 myPC systemd[1]: Failed to start MariaDB 10.5.10 database server. -- Subject: A start job for unit mariadb.service has failed -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- A start job for unit mariadb.service has finished with a failure. -- -- The job identifier is 1634 and the job result is failed. Jun 28 21:57:01 myPC systemd[1]: Starting MariaDB 10.5.10 database server... -- Subject: A start job for unit mariadb.service has begun execution -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- A start job for unit mariadb.service has begun execution. -- -- The job identifier is 1736. Jun 28 21:57:02 myPC mariadbd[182833]: 2021-06-28 21:57:02 0 [Note] /usr/bin/mariadbd (mysqld 10.5.10-MariaDB) starting as process 182833 ... Jun 28 21:57:02 myPC mariadbd[182833]: 2021-06-28 21:57:02 0 [Note] InnoDB: Uses event mutexes Jun 28 21:57:02 myPC mariadbd[182833]: 2021-06-28 21:57:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 Jun 28 21:57:02 myPC mariadbd[182833]: 2021-06-28 21:57:02 0 [Note] InnoDB: Number of pools: 1 Jun 28 21:57:02 myPC mariadbd[182833]: 2021-06-28 21:57:02 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions Jun 28 21:57:02 myPC mariadbd[182833]: 2021-06-28 21:57:02 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts) Jun 28 21:57:02 myPC mariadbd[182833]: 2021-06-28 21:57:02 0 [Note] InnoDB: Using Linux native AIO Jun 28 21:57:02 myPC mariadbd[182833]: 2021-06-28 21:57:02 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 Jun 28 21:57:02 myPC mariadbd[182833]: 2021-06-28 21:57:02 0 [Note] InnoDB: Completed initialization of buffer pool Jun 28 21:57:02 myPC mariadbd[182833]: 2021-06-28 21:57:02 0 [Note] InnoDB: 128 rollback segments are active. Jun 28 21:57:02 myPC mariadbd[182833]: 2021-06-28 21:57:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables Jun 28 21:57:02 myPC mariadbd[182833]: 2021-06-28 21:57:02 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Jun 28 21:57:02 myPC mariadbd[182833]: 2021-06-28 21:57:02 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Jun 28 21:57:02 myPC mariadbd[182833]: 2021-06-28 21:57:02 0 [Note] InnoDB: 10.5.10 started; log sequence number 35040; transaction id 8 Jun 28 21:57:02 myPC mariadbd[182833]: 2021-06-28 21:57:02 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Jun 28 21:57:02 myPC mariadbd[182833]: 2021-06-28 21:57:02 0 [Note] InnoDB: Buffer pool(s) load completed at 210628 21:57:02 Jun 28 21:57:02 myPC mariadbd[182833]: 2021-06-28 21:57:02 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded Jun 28 21:57:02 myPC mariadbd[182833]: 2021-06-28 21:57:02 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist Jun 28 21:57:02 myPC mariadbd[182833]: 2021-06-28 21:57:02 0 [Note] Server socket created on IP: '::'. Jun 28 21:57:02 myPC mariadbd[182833]: 2021-06-28 21:57:02 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use Jun 28 21:57:02 myPC mariadbd[182833]: 2021-06-28 21:57:02 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? Jun 28 21:57:02 myPC mariadbd[182833]: 2021-06-28 21:57:02 0 [ERROR] Aborting Jun 28 21:57:02 myPC systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE -- Subject: Unit process exited -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- An ExecStart= process belonging to unit mariadb.service has exited. -- -- The process' exit code is 'exited' and its exit status is 1. Jun 28 21:57:02 myPC systemd[1]: mariadb.service: Failed with result 'exit-code'. -- Subject: Unit failed -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- The unit mariadb.service has entered the 'failed' state with result 'exit-code'. Jun 28 21:57:02 myPC systemd[1]: Failed to start MariaDB 10.5.10 database server. -- Subject: A start job for unit mariadb.service has failed -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- A start job for unit mariadb.service has finished with a failure. -- -- The job identifier is 1736 and the job result is failed. Jun 28 21:57:08 myPC systemd[1]: Starting MariaDB 10.5.10 database server... -- Subject: A start job for unit mariadb.service has begun execution -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- A start job for unit mariadb.service has begun execution. -- -- The job identifier is 1838. Jun 28 21:57:08 myPC mariadbd[182885]: 2021-06-28 21:57:08 0 [Note] /usr/bin/mariadbd (mysqld 10.5.10-MariaDB) starting as process 182885 ... Jun 28 21:57:08 myPC mariadbd[182885]: 2021-06-28 21:57:08 0 [Note] InnoDB: Uses event mutexes Jun 28 21:57:08 myPC mariadbd[182885]: 2021-06-28 21:57:08 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 Jun 28 21:57:08 myPC mariadbd[182885]: 2021-06-28 21:57:08 0 [Note] InnoDB: Number of pools: 1 Jun 28 21:57:08 myPC mariadbd[182885]: 2021-06-28 21:57:08 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions Jun 28 21:57:08 myPC mariadbd[182885]: 2021-06-28 21:57:08 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts) Jun 28 21:57:08 myPC mariadbd[182885]: 2021-06-28 21:57:08 0 [Note] InnoDB: Using Linux native AIO Jun 28 21:57:08 myPC mariadbd[182885]: 2021-06-28 21:57:08 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 Jun 28 21:57:08 myPC mariadbd[182885]: 2021-06-28 21:57:08 0 [Note] InnoDB: Completed initialization of buffer pool Jun 28 21:57:08 myPC mariadbd[182885]: 2021-06-28 21:57:08 0 [Note] InnoDB: 128 rollback segments are active. Jun 28 21:57:08 myPC mariadbd[182885]: 2021-06-28 21:57:08 0 [Note] InnoDB: Creating shared tablespace for temporary tables Jun 28 21:57:08 myPC mariadbd[182885]: 2021-06-28 21:57:08 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Jun 28 21:57:08 myPC mariadbd[182885]: 2021-06-28 21:57:08 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Jun 28 21:57:08 myPC mariadbd[182885]: 2021-06-28 21:57:08 0 [Note] InnoDB: 10.5.10 started; log sequence number 35052; transaction id 8 Jun 28 21:57:08 myPC mariadbd[182885]: 2021-06-28 21:57:08 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Jun 28 21:57:08 myPC mariadbd[182885]: 2021-06-28 21:57:08 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded Jun 28 21:57:08 myPC mariadbd[182885]: 2021-06-28 21:57:08 0 [Note] InnoDB: Buffer pool(s) load completed at 210628 21:57:08 Jun 28 21:57:08 myPC mariadbd[182885]: 2021-06-28 21:57:08 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist Jun 28 21:57:08 myPC mariadbd[182885]: 2021-06-28 21:57:08 0 [Note] Server socket created on IP: '::'. Jun 28 21:57:08 myPC mariadbd[182885]: 2021-06-28 21:57:08 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use Jun 28 21:57:08 myPC mariadbd[182885]: 2021-06-28 21:57:08 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? Jun 28 21:57:08 myPC mariadbd[182885]: 2021-06-28 21:57:08 0 [ERROR] Aborting Jun 28 21:57:08 myPC systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE -- Subject: Unit process exited -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- An ExecStart= process belonging to unit mariadb.service has exited. -- -- The process' exit code is 'exited' and its exit status is 1. Jun 28 21:57:08 myPC systemd[1]: mariadb.service: Failed with result 'exit-code'. -- Subject: Unit failed -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- The unit mariadb.service has entered the 'failed' state with result 'exit-code'. Jun 28 21:57:08 myPC systemd[1]: Failed to start MariaDB 10.5.10 database server. -- Subject: A start job for unit mariadb.service has failed -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- A start job for unit mariadb.service has finished with a failure. -- -- The job identifier is 1838 and the job result is failed. -- Boot 716777e028a04dad8ca427d35f5f9fbd -- Jul 01 02:15:58 myPC systemd[1]: Starting MariaDB 10.5.11 database server... -- Subject: A start job for unit mariadb.service has begun execution -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- A start job for unit mariadb.service has begun execution. -- -- The job identifier is 1726. Jul 01 02:15:58 myPC mariadbd[317484]: 2021-07-01 2:15:58 0 [Note] /usr/bin/mariadbd (mysqld 10.5.11-MariaDB) starting as process 317484 ... Jul 01 02:15:58 myPC mariadbd[317484]: 2021-07-01 2:15:58 0 [Note] InnoDB: Uses event mutexes Jul 01 02:15:58 myPC mariadbd[317484]: 2021-07-01 2:15:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 Jul 01 02:15:58 myPC mariadbd[317484]: 2021-07-01 2:15:58 0 [Note] InnoDB: Number of pools: 1 Jul 01 02:15:58 myPC mariadbd[317484]: 2021-07-01 2:15:58 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions Jul 01 02:15:58 myPC mariadbd[317484]: 2021-07-01 2:15:58 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts) Jul 01 02:15:58 myPC mariadbd[317484]: 2021-07-01 2:15:58 0 [Note] InnoDB: Using Linux native AIO Jul 01 02:15:58 myPC mariadbd[317484]: 2021-07-01 2:15:58 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 Jul 01 02:15:58 myPC mariadbd[317484]: 2021-07-01 2:15:58 0 [Note] InnoDB: Completed initialization of buffer pool Jul 01 02:15:58 myPC mariadbd[317484]: 2021-07-01 2:15:58 0 [Note] InnoDB: 128 rollback segments are active. Jul 01 02:15:58 myPC mariadbd[317484]: 2021-07-01 2:15:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables Jul 01 02:15:58 myPC mariadbd[317484]: 2021-07-01 2:15:58 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Jul 01 02:15:58 myPC mariadbd[317484]: 2021-07-01 2:15:58 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Jul 01 02:15:58 myPC mariadbd[317484]: 2021-07-01 2:15:58 0 [Note] InnoDB: 10.5.11 started; log sequence number 44900; transaction id 21 Jul 01 02:15:58 myPC mariadbd[317484]: 2021-07-01 2:15:58 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Jul 01 02:15:58 myPC mariadbd[317484]: 2021-07-01 2:15:58 0 [Note] InnoDB: Buffer pool(s) load completed at 210701 2:15:58 Jul 01 02:15:58 myPC mariadbd[317484]: 2021-07-01 2:15:58 0 [Note] Server socket created on IP: '::'. Jul 01 02:15:58 myPC mariadbd[317484]: 2021-07-01 2:15:58 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use Jul 01 02:15:58 myPC mariadbd[317484]: 2021-07-01 2:15:58 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? Jul 01 02:15:58 myPC mariadbd[317484]: 2021-07-01 2:15:58 0 [ERROR] Aborting Jul 01 02:15:58 myPC systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE -- Subject: Unit process exited -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- An ExecStart= process belonging to unit mariadb.service has exited. -- -- The process' exit code is 'exited' and its exit status is 1. Jul 01 02:15:58 myPC systemd[1]: mariadb.service: Failed with result 'exit-code'. -- Subject: Unit failed -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- The unit mariadb.service has entered the 'failed' state with result 'exit-code'. Jul 01 02:15:58 myPC systemd[1]: Failed to start MariaDB 10.5.11 database server. -- Subject: A start job for unit mariadb.service has failed -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- A start job for unit mariadb.service has finished with a failure. -- -- The job identifier is 1726 and the job result is failed. Jul 01 02:22:10 myPC systemd[1]: Starting MariaDB 10.5.11 database server... -- Subject: A start job for unit mariadb.service has begun execution -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- A start job for unit mariadb.service has begun execution. -- -- The job identifier is 1828. Jul 01 02:22:10 myPC mariadbd[320008]: 2021-07-01 2:22:10 0 [Note] /usr/bin/mariadbd (mysqld 10.5.11-MariaDB) starting as process 320008 ... Jul 01 02:22:10 myPC mariadbd[320008]: 2021-07-01 2:22:10 0 [Note] InnoDB: Uses event mutexes Jul 01 02:22:10 myPC mariadbd[320008]: 2021-07-01 2:22:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 Jul 01 02:22:10 myPC mariadbd[320008]: 2021-07-01 2:22:10 0 [Note] InnoDB: Number of pools: 1 Jul 01 02:22:10 myPC mariadbd[320008]: 2021-07-01 2:22:10 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions Jul 01 02:22:10 myPC mariadbd[320008]: 2021-07-01 2:22:10 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts) Jul 01 02:22:10 myPC mariadbd[320008]: 2021-07-01 2:22:10 0 [Note] InnoDB: Using Linux native AIO Jul 01 02:22:10 myPC mariadbd[320008]: 2021-07-01 2:22:10 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 Jul 01 02:22:10 myPC mariadbd[320008]: 2021-07-01 2:22:10 0 [Note] InnoDB: Completed initialization of buffer pool Jul 01 02:22:10 myPC mariadbd[320008]: 2021-07-01 2:22:10 0 [Note] InnoDB: 128 rollback segments are active. Jul 01 02:22:10 myPC mariadbd[320008]: 2021-07-01 2:22:10 0 [Note] InnoDB: Creating shared tablespace for temporary tables Jul 01 02:22:10 myPC mariadbd[320008]: 2021-07-01 2:22:10 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Jul 01 02:22:10 myPC mariadbd[320008]: 2021-07-01 2:22:10 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Jul 01 02:22:10 myPC mariadbd[320008]: 2021-07-01 2:22:10 0 [Note] InnoDB: 10.5.11 started; log sequence number 45118; transaction id 20 Jul 01 02:22:10 myPC mariadbd[320008]: 2021-07-01 2:22:10 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Jul 01 02:22:10 myPC mariadbd[320008]: 2021-07-01 2:22:10 0 [Note] InnoDB: Buffer pool(s) load completed at 210701 2:22:10 Jul 01 02:22:10 myPC mariadbd[320008]: 2021-07-01 2:22:10 0 [Note] Server socket created on IP: '::'. Jul 01 02:22:10 myPC mariadbd[320008]: 2021-07-01 2:22:10 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use Jul 01 02:22:10 myPC mariadbd[320008]: 2021-07-01 2:22:10 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? Jul 01 02:22:10 myPC mariadbd[320008]: 2021-07-01 2:22:10 0 [ERROR] Aborting Jul 01 02:22:10 myPC systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE -- Subject: Unit process exited -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- An ExecStart= process belonging to unit mariadb.service has exited. -- -- The process' exit code is 'exited' and its exit status is 1. Jul 01 02:22:10 myPC systemd[1]: mariadb.service: Failed with result 'exit-code'. -- Subject: Unit failed -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- The unit mariadb.service has entered the 'failed' state with result 'exit-code'. Jul 01 02:22:10 myPC systemd[1]: Failed to start MariaDB 10.5.11 database server. -- Subject: A start job for unit mariadb.service has failed -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- A start job for unit mariadb.service has finished with a failure. -- -- The job identifier is 1828 and the job result is failed. Jul 01 02:23:21 myPC systemd[1]: Starting MariaDB 10.5.11 database server... -- Subject: A start job for unit mariadb.service has begun execution -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- A start job for unit mariadb.service has begun execution. -- -- The job identifier is 1930. Jul 01 02:23:21 myPC mariadbd[320635]: 2021-07-01 2:23:21 0 [Note] /usr/bin/mariadbd (mysqld 10.5.11-MariaDB) starting as process 320635 ... Jul 01 02:23:21 myPC mariadbd[320635]: 2021-07-01 2:23:21 0 [Note] InnoDB: Uses event mutexes Jul 01 02:23:21 myPC mariadbd[320635]: 2021-07-01 2:23:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 Jul 01 02:23:21 myPC mariadbd[320635]: 2021-07-01 2:23:21 0 [Note] InnoDB: Number of pools: 1 Jul 01 02:23:21 myPC mariadbd[320635]: 2021-07-01 2:23:21 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions Jul 01 02:23:21 myPC mariadbd[320635]: 2021-07-01 2:23:21 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts) Jul 01 02:23:21 myPC mariadbd[320635]: 2021-07-01 2:23:21 0 [Note] InnoDB: Using Linux native AIO Jul 01 02:23:21 myPC mariadbd[320635]: 2021-07-01 2:23:21 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 Jul 01 02:23:21 myPC mariadbd[320635]: 2021-07-01 2:23:21 0 [Note] InnoDB: Completed initialization of buffer pool Jul 01 02:23:21 myPC mariadbd[320635]: 2021-07-01 2:23:21 0 [Note] InnoDB: 128 rollback segments are active. Jul 01 02:23:21 myPC mariadbd[320635]: 2021-07-01 2:23:21 0 [Note] InnoDB: Creating shared tablespace for temporary tables Jul 01 02:23:21 myPC mariadbd[320635]: 2021-07-01 2:23:21 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Jul 01 02:23:21 myPC mariadbd[320635]: 2021-07-01 2:23:21 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Jul 01 02:23:21 myPC mariadbd[320635]: 2021-07-01 2:23:21 0 [Note] InnoDB: 10.5.11 started; log sequence number 45118; transaction id 20 Jul 01 02:23:21 myPC mariadbd[320635]: 2021-07-01 2:23:21 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Jul 01 02:23:21 myPC mariadbd[320635]: 2021-07-01 2:23:21 0 [Note] InnoDB: Buffer pool(s) load completed at 210701 2:23:21 Jul 01 02:23:21 myPC mariadbd[320635]: 2021-07-01 2:23:21 0 [Note] Server socket created on IP: '::'. Jul 01 02:23:21 myPC mariadbd[320635]: 2021-07-01 2:23:21 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use Jul 01 02:23:21 myPC mariadbd[320635]: 2021-07-01 2:23:21 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? Jul 01 02:23:21 myPC mariadbd[320635]: 2021-07-01 2:23:21 0 [ERROR] Aborting Jul 01 02:23:22 myPC systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE -- Subject: Unit process exited -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- An ExecStart= process belonging to unit mariadb.service has exited. -- -- The process' exit code is 'exited' and its exit status is 1. Jul 01 02:23:22 myPC systemd[1]: mariadb.service: Failed with result 'exit-code'. -- Subject: Unit failed -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- The unit mariadb.service has entered the 'failed' state with result 'exit-code'. Jul 01 02:23:22 myPC systemd[1]: Failed to start MariaDB 10.5.11 database server. -- Subject: A start job for unit mariadb.service has failed -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- A start job for unit mariadb.service has finished with a failure. -- -- The job identifier is 1930 and the job result is failed. Jul 01 02:24:38 myPC systemd[1]: Starting MariaDB 10.5.11 database server... -- Subject: A start job for unit mariadb.service has begun execution -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- A start job for unit mariadb.service has begun execution. -- -- The job identifier is 2032. Jul 01 02:24:38 myPC mariadbd[321187]: 2021-07-01 2:24:38 0 [Note] /usr/bin/mariadbd (mysqld 10.5.11-MariaDB) starting as process 321187 ... Jul 01 02:24:38 myPC mariadbd[321187]: 2021-07-01 2:24:38 0 [Note] InnoDB: Uses event mutexes Jul 01 02:24:38 myPC mariadbd[321187]: 2021-07-01 2:24:38 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 Jul 01 02:24:38 myPC mariadbd[321187]: 2021-07-01 2:24:38 0 [Note] InnoDB: Number of pools: 1 Jul 01 02:24:38 myPC mariadbd[321187]: 2021-07-01 2:24:38 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions Jul 01 02:24:38 myPC mariadbd[321187]: 2021-07-01 2:24:38 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts) Jul 01 02:24:38 myPC mariadbd[321187]: 2021-07-01 2:24:38 0 [Note] InnoDB: Using Linux native AIO Jul 01 02:24:38 myPC mariadbd[321187]: 2021-07-01 2:24:38 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 Jul 01 02:24:38 myPC mariadbd[321187]: 2021-07-01 2:24:38 0 [Note] InnoDB: Completed initialization of buffer pool Jul 01 02:24:38 myPC mariadbd[321187]: 2021-07-01 2:24:38 0 [Note] InnoDB: 128 rollback segments are active. Jul 01 02:24:38 myPC mariadbd[321187]: 2021-07-01 2:24:38 0 [Note] InnoDB: Creating shared tablespace for temporary tables Jul 01 02:24:38 myPC mariadbd[321187]: 2021-07-01 2:24:38 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Jul 01 02:24:38 myPC mariadbd[321187]: 2021-07-01 2:24:38 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Jul 01 02:24:38 myPC mariadbd[321187]: 2021-07-01 2:24:38 0 [Note] InnoDB: 10.5.11 started; log sequence number 45106; transaction id 20 Jul 01 02:24:38 myPC mariadbd[321187]: 2021-07-01 2:24:38 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Jul 01 02:24:38 myPC mariadbd[321187]: 2021-07-01 2:24:38 0 [Note] InnoDB: Buffer pool(s) load completed at 210701 2:24:38 Jul 01 02:24:38 myPC mariadbd[321187]: 2021-07-01 2:24:38 0 [Note] Server socket created on IP: '::'. Jul 01 02:24:38 myPC mariadbd[321187]: 2021-07-01 2:24:38 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use Jul 01 02:24:38 myPC mariadbd[321187]: 2021-07-01 2:24:38 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? Jul 01 02:24:38 myPC mariadbd[321187]: 2021-07-01 2:24:38 0 [ERROR] Aborting Jul 01 02:24:38 myPC systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE -- Subject: Unit process exited -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- An ExecStart= process belonging to unit mariadb.service has exited. -- -- The process' exit code is 'exited' and its exit status is 1. Jul 01 02:24:38 myPC systemd[1]: mariadb.service: Failed with result 'exit-code'. -- Subject: Unit failed -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- The unit mariadb.service has entered the 'failed' state with result 'exit-code'. Jul 01 02:24:38 myPC systemd[1]: Failed to start MariaDB 10.5.11 database server. -- Subject: A start job for unit mariadb.service has failed -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- A start job for unit mariadb.service has finished with a failure. -- -- The job identifier is 2032 and the job result is failed. Jul 01 02:34:32 myPC systemd[1]: Starting MariaDB 10.5.11 database server... -- Subject: A start job for unit mariadb.service has begun execution -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- A start job for unit mariadb.service has begun execution. -- -- The job identifier is 2134. Jul 01 02:34:32 myPC mariadbd[325022]: 2021-07-01 2:34:32 0 [Note] /usr/bin/mariadbd (mysqld 10.5.11-MariaDB) starting as process 325022 ... Jul 01 02:34:32 myPC mariadbd[325022]: 2021-07-01 2:34:32 0 [Note] InnoDB: Uses event mutexes Jul 01 02:34:32 myPC mariadbd[325022]: 2021-07-01 2:34:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 Jul 01 02:34:32 myPC mariadbd[325022]: 2021-07-01 2:34:32 0 [Note] InnoDB: Number of pools: 1 Jul 01 02:34:32 myPC mariadbd[325022]: 2021-07-01 2:34:32 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions Jul 01 02:34:32 myPC mariadbd[325022]: 2021-07-01 2:34:32 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts) Jul 01 02:34:32 myPC mariadbd[325022]: 2021-07-01 2:34:32 0 [Note] InnoDB: Using Linux native AIO Jul 01 02:34:32 myPC mariadbd[325022]: 2021-07-01 2:34:32 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 Jul 01 02:34:32 myPC mariadbd[325022]: 2021-07-01 2:34:32 0 [Note] InnoDB: Completed initialization of buffer pool Jul 01 02:34:32 myPC mariadbd[325022]: 2021-07-01 2:34:32 0 [Note] InnoDB: 128 rollback segments are active. Jul 01 02:34:32 myPC mariadbd[325022]: 2021-07-01 2:34:32 0 [Note] InnoDB: Creating shared tablespace for temporary tables Jul 01 02:34:32 myPC mariadbd[325022]: 2021-07-01 2:34:32 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Jul 01 02:34:32 myPC mariadbd[325022]: 2021-07-01 2:34:32 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Jul 01 02:34:32 myPC mariadbd[325022]: 2021-07-01 2:34:32 0 [Note] InnoDB: 10.5.11 started; log sequence number 45118; transaction id 20 Jul 01 02:34:32 myPC mariadbd[325022]: 2021-07-01 2:34:32 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Jul 01 02:34:32 myPC mariadbd[325022]: 2021-07-01 2:34:32 0 [Note] InnoDB: Buffer pool(s) load completed at 210701 2:34:32 Jul 01 02:34:32 myPC mariadbd[325022]: 2021-07-01 2:34:32 0 [Note] Server socket created on IP: '::'. Jul 01 02:34:32 myPC mariadbd[325022]: 2021-07-01 2:34:32 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use Jul 01 02:34:32 myPC mariadbd[325022]: 2021-07-01 2:34:32 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? Jul 01 02:34:32 myPC mariadbd[325022]: 2021-07-01 2:34:32 0 [ERROR] Aborting Jul 01 02:34:32 myPC systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE -- Subject: Unit process exited -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- An ExecStart= process belonging to unit mariadb.service has exited. -- -- The process' exit code is 'exited' and its exit status is 1. Jul 01 02:34:32 myPC systemd[1]: mariadb.service: Failed with result 'exit-code'. -- Subject: Unit failed -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- The unit mariadb.service has entered the 'failed' state with result 'exit-code'. Jul 01 02:34:32 myPC systemd[1]: Failed to start MariaDB 10.5.11 database server. -- Subject: A start job for unit mariadb.service has failed -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- A start job for unit mariadb.service has finished with a failure. -- -- The job identifier is 2134 and the job result is failed. Jul 01 02:39:47 myPC systemd[1]: Starting MariaDB 10.5.11 database server... -- Subject: A start job for unit mariadb.service has begun execution -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- A start job for unit mariadb.service has begun execution. -- -- The job identifier is 2236. Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01 2:39:47 0 [Note] /usr/bin/mariadbd (mysqld 10.5.11-MariaDB) starting as process 327129 ... Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01 2:39:47 0 [Note] InnoDB: Uses event mutexes Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01 2:39:47 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01 2:39:47 0 [Note] InnoDB: Number of pools: 1 Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01 2:39:47 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01 2:39:47 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts) Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01 2:39:47 0 [Note] InnoDB: Using Linux native AIO Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01 2:39:47 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01 2:39:47 0 [Note] InnoDB: Completed initialization of buffer pool Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01 2:39:47 0 [Note] InnoDB: 128 rollback segments are active. Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01 2:39:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01 2:39:47 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01 2:39:47 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01 2:39:47 0 [Note] InnoDB: 10.5.11 started; log sequence number 45130; transaction id 20 Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01 2:39:47 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01 2:39:47 0 [Note] InnoDB: Buffer pool(s) load completed at 210701 2:39:47 Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01 2:39:47 0 [Note] Server socket created on IP: '::'. Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01 2:39:47 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01 2:39:47 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? Jul 01 02:39:47 myPC mariadbd[327129]: 2021-07-01 2:39:47 0 [ERROR] Aborting Jul 01 02:39:47 myPC systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE -- Subject: Unit process exited -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- An ExecStart= process belonging to unit mariadb.service has exited. -- -- The process' exit code is 'exited' and its exit status is 1. Jul 01 02:39:47 myPC systemd[1]: mariadb.service: Failed with result 'exit-code'. -- Subject: Unit failed -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- The unit mariadb.service has entered the 'failed' state with result 'exit-code'. Jul 01 02:39:47 myPC systemd[1]: Failed to start MariaDB 10.5.11 database server. -- Subject: A start job for unit mariadb.service has failed -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- A start job for unit mariadb.service has finished with a failure. -- -- The job identifier is 2236 and the job result is failed.

Thanks in advance for your time

Last edited by katarok (2021-07-01 23:44:20)

When I tried to start mariadb, I got:

[root]# systemctl start mariadb
Failed to start mariadb.service: Unit not found.

And I also got this message:

Package 1:mariadb-5.5.56-2.el7.x86_64 is obsoleted by mysql-community-client-5.6.39-2.el7.x86_64 which is already installed

What should I do next?

Romeo Ninov

15.2k5 gold badges31 silver badges41 bronze badges

asked Apr 17, 2018 at 1:25

The mariadb service is called mysqld.

Try systemctl start mysqld

Edit: and even if you have mysql installed instead this solution will still work

answered Apr 18, 2018 at 2:12

Источник

Геннадий

@sferg1985

Рассказывать долго. Сами спросите о чём нужно.

Здравствуйте, господа. На Debian Jessie настроена связка Nginx + PHP7-FPM + MariaDB. Решил попробовать перенести БД с обычного HDD на SSD:

1. Останавливаю MariaDB:
systemctl stop mysql

2. Копирую БД на SSD:
rsync -av /var/lib/mysql /home/ssd

3. Меняю в файле /etc/mysql/my.cnf значение параметра datadir с /var/lib/mysql на /home/ssd/mysql

4. Пытаюсь запустить MariaDB:
systemctl start mysql

и получаю ошибку:

Job for mariadb.service failed. See ‘systemctl status mariadb.service’ and ‘journalctl -xn’ for details.

5. Вывод команды journalctl -xn:

— Logs begin at Ср 2016-12-07 13:44:53 MSK, end at Сб 2016-12-10 14:33:43 MSK. —
дек 10 14:33:40 hostname systemd[1]: Starting MariaDB database server…
— Subject: Начинается запуск юнита mariadb.service
— Defined-By: systemd
— Support: lists.freedesktop.org/mailman/listinfo/systemd-devel
—
— Начат процесс запуска юнита mariadb.service.
дек 10 14:33:41 hostname mysqld[28833]: 2016-12-10 14:33:41 140252996253632 [Note] /usr/sbin/mysqld (mysqld 10.1.19-MariaDB-1~jessie) starting as process 28833 …
дек 10 14:33:41 hostname mysqld[28833]: 2016-12-10 14:33:41 140252996253632 [Warning] Can’t create test file /home/ssd/mysql/hostname.lower-test
дек 10 14:33:41 hostname mysqld[28833]: [91B blob data]
дек 10 14:33:41 hostname mysqld[28833]: 2016-12-10 14:33:41 140252996253632 [ERROR] Aborting
дек 10 14:33:41 hostname systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
дек 10 14:33:41 hostname systemd[1]: Failed to start MariaDB database server.
— Subject: Ошибка юнита mariadb.service
— Defined-By: systemd
— Support: lists.freedesktop.org/mailman/listinfo/systemd-devel
—
— Произошел сбой юнита mariadb.service.
—
— Результат: failed.
дек 10 14:33:41 hostname systemd[1]: Unit mariadb.service entered failed state.

На /var/lib/mysql всё стартует нормально, а на /home/ssd/mysql — не хочет. В чём может быть дело? Куда копать?

Вопрос задан

более трёх лет назад
2958 просмотров

Пригласить эксперта

Примонтируй ssd в другую директорию НЕ /home, у mysql сервиса стоит защита на запуск в /home.
Либо можно прибиндить директорию и не трогать конфиги:
mount —bind /home/ssd/mysql /var/lib/mysql

У меня была такая же проблема, яндекс выдал тему в stack overflow которая мне помогла

Была така же проблема но с MYSQL,
1. Проверьте чтобы верные права и пользователь был в новой папке

2. Если не поможет — тогда конфиг оставляйте как был, а папку делайте симлинком на ssd

Не смущает эта строка?

дек 10 14:33:41 hostname mysqld[28833]: 2016-12-10 14:33:41 140252996253632 [Warning] Can’t create test file /home/ssd/mysql/hostname.lower-test

Проверьте есть ли права на записьчтение в /home/ssd/mysql/ у учетной записи, под которой стартует процесс.

Показать ещё
Загружается…

25 июн. 2023, в 11:42

600 руб./за проект

25 июн. 2023, в 10:30

6000 руб./за проект

25 июн. 2023, в 10:26

15000 руб./за проект

Минуточку внимания

Источник