Resolved systemctl start mariadb (10.6 error)

[yigitvp]

i got this error when i updated mariadb with new plesk update
● mariadb.service - MariaDB 10.6.5 database server
Loaded: loaded (/usr/lib/systemd/system/./mariadb.service; disabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Tue 2022-01-18 18:01:01 +03; 931ms ago
Docs: man:mariadbd(8)
systemd
Process: 21397 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 21378 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_S>
Process: 21376 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 21397 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"

Jan 18 18:01:01 ss.page mariadbd[21397]: 2022-01-18 18:01:01 0 [Note] InnoDB: 10.6.5 started; log sequence number 6856872000; transaction id 21519052
Jan 18 18:01:01 ss.page mariadbd[21397]: 2022-01-18 18:01:01 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Jan 18 18:01:01 ss.page mariadbd[21397]: 2022-01-18 18:01:01 0 [Note] Plugin 'FEEDBACK' is disabled.
Jan 18 18:01:01 ss.page mariadbd[21397]: 2022-01-18 18:01:01 0 [Note] Server socket created on IP: '127.0.0.1'.
Jan 18 18:01:01 ss.page mariadbd[21397]: 2022-01-18 18:01:01 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 22: Invalid argument
Jan 18 18:01:01 ss.page mariadbd[21397]: 2022-01-18 18:01:01 0 [ERROR] Do you already have another server running on port: 3306 ?
Jan 18 18:01:01 ss.page mariadbd[21397]: 2022-01-18 18:01:01 0 [ERROR] Aborting
Jan 18 18:01:01 ss.page systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jan 18 18:01:01 ss.page systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jan 18 18:01:01 ss.page systemd[1]: Failed to start MariaDB 10.6.5 database server.

 

[ChrisCP]

Same problem to me.

 

[Monty]

What was the previous version that you were using? 10.5? Or older?

 

[ChrisCP]

I run latest version of 10.5 on CentOS 7.

 

[yigitvp]

What was the previous version that you were using? 10.5? Or older?

10.3
The problem seems to be with rockylinux. Even if I remove it completely and reinstall it as 10.3, I get the same error. Since it does not seem possible to get rid of this error, I took a backup and reset the server :/

 

[Monty]

1) Before you started the service, did you check with ps auxw if there was an old process "mysqld" still running? Try stopping the service again and if there are any lingering mysqld processes you may have to kill them first before you start the service again.

2) You may have two systemd services installed, creating a conflict:
Starting with MariaDB 10.5 the binary was renamed from mysqld to mariadbd and during the upgrade some systemd unit files may have been left over in /etc/systemd/system and/or /usr/lib/systemd/system.

Check the output of: ls -al /usr/lib/systemd/system/mysql*

With MariaDB 10.5 or 10.6 this should be:

lrwxrwxrwx 1 root root 17 Nov 10  2020 /usr/lib/systemd/system/mysqld.service -> ./mariadb.service
lrwxrwxrwx 1 root root 17 Nov 10  2020 /usr/lib/systemd/system/mysql.service -> ./mariadb.service

(mysqld.service should be a symlink to mariadb.service)

3) Also check if you have any leftover drop-in files in /etc/systemd/system/mariadb.service.d (or mysqld.service.d)

4) You may also want to post the output of systemctl show mariadb.service here, maybe we can see something weird there.

 

[JulianDot]

i got this error when i updated mariadb with new plesk update
● mariadb.service - MariaDB 10.6.5 database server
Loaded: loaded (/usr/lib/systemd/system/./mariadb.service; disabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Tue 2022-01-18 18:01:01 +03; 931ms ago
Docs: man:mariadbd(8)
systemd
Process: 21397 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 21378 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_S>
Process: 21376 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 21397 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"

Jan 18 18:01:01 ss.page mariadbd[21397]: 2022-01-18 18:01:01 0 [Note] InnoDB: 10.6.5 started; log sequence number 6856872000; transaction id 21519052
Jan 18 18:01:01 ss.page mariadbd[21397]: 2022-01-18 18:01:01 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Jan 18 18:01:01 ss.page mariadbd[21397]: 2022-01-18 18:01:01 0 [Note] Plugin 'FEEDBACK' is disabled.
Jan 18 18:01:01 ss.page mariadbd[21397]: 2022-01-18 18:01:01 0 [Note] Server socket created on IP: '127.0.0.1'.
Jan 18 18:01:01 ss.page mariadbd[21397]: 2022-01-18 18:01:01 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 22: Invalid argument
Jan 18 18:01:01 ss.page mariadbd[21397]: 2022-01-18 18:01:01 0 [ERROR] Do you already have another server running on port: 3306 ?
Jan 18 18:01:01 ss.page mariadbd[21397]: 2022-01-18 18:01:01 0 [ERROR] Aborting
Jan 18 18:01:01 ss.page systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jan 18 18:01:01 ss.page systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jan 18 18:01:01 ss.page systemd[1]: Failed to start MariaDB 10.6.5 database server.

I got the same issue few hours ago, the exact same situation.

Reboot

and everything was magically fixed.

after reboot, don;'t forget to

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin

 

[Gene Steinberg]

OK, cut to the chase:

Running MariaDB 10.5.

Want to upgrade to 10.6.

Running latest Plesk on a CentOS 7 server.

What's the full command I should use to manage this update? I'd rather not interpolate from the above problems.

Peace,
Gene

 

[weltonw]

I wouldn't recommend it. 10.6 doesn't appear to be supported by Plesk.

Is there something in 10.6 you need specifically?

 

[Gene Steinberg]

From latest Plesk release:

Third-Party Component Updates​

• MariaDB 10.6 is now supported.

 

[mizar]

Hello,

MariaDB since 10.6 doesn't allows to bind both ::1 and 127.0.0.1 by setting bind-address = ::ffff:127.0.0.1 in my.cnf. If your upgrade from previous version, you should replace bind-address to 127.0.0.1, otherwise MariaDB won't start (or plesk sbin mysqlmng --bind-address local do it for you)

 

[learning_curve]

Hello,

MariaDB since 10.6 doesn't allows to bind both ::1 and 127.0.0.1 by setting bind-address = ::ffff:127.0.0.1 in my.cnf. If your upgrade from previous version, you should replace bind-address to 127.0.0.1, otherwise MariaDB won't start (or plesk sbin mysqlmng --bind-address local do it for you)

Thank you. Yes that's stated as part of this page: Changes and Improvements in MariaDB 10.6 but directly, it's this specific point (links):

> --bind-address=hostname now listens on both IPv6 and IPv4 addresses (MDEV-6536)

 

[yigitvp]

An expert needs to test this error by performing a mariadb update on RockyLinux. The current issue can be marked as resolved.
@john0001 In the latest version of Plesk it says it supports mariadb.

 

[Apparire]

I've similar issue but in

Plesk Obsidian 18.0.40.3
OS version: Debian 9.13 x86_64
Build date: 2022/01/16 00:00
Revision: b3f50e0b4df16778c2131cc55cb1b14d2c71a62a

and MariaDB 10.1.45 database server

Can I upgrade to?
MariaDB 10.5.10 (for Plesk database)
MariaDB 10.5.10 and 10.3.29 (for customer websites)

 

[mizar]

@Apparire, the original issue is specific to MariaDB server 10.6, so you cannot have it on MariaDB 10.1, and it's better to resolve your issue before MariaDB upgrade because it is unlikely properly upgraded if the service cannot be started up. Could you provide output of systemctl status mariadb (and it might be good idea to create separate topic)

 

[Apparire]

@Apparire, the original issue is specific to MariaDB server 10.6, so you cannot have it on MariaDB 10.1, and it's better to resolve your issue before MariaDB upgrade because it is unlikely properly upgraded if the service cannot be started up. Could you provide output of systemctl status mariadb (and it might be good idea to create separate topic)

Ok, I understand, thanks!

 

[ChrisCP]

Hello,

MariaDB since 10.6 doesn't allows to bind both ::1 and 127.0.0.1 by setting bind-address = ::ffff:127.0.0.1 in my.cnf. If your upgrade from previous version, you should replace bind-address to 127.0.0.1, otherwise MariaDB won't start (or plesk sbin mysqlmng --bind-address local do it for you)

Thank you for the hint. Now the upgrade from 10.5 to 10.6 works.

 

[LTUser]

Backup Error:
"Unable to make database dump. Error: Failed to exec mysqldump: Exit code: 2: WARNING: Forcing protocol to TCP due to option specification. Please explicitly state intended protocol. mysqldump: Got error: 1130: "Host '127.0.0.1' is not allowed to connect to this MariaDB server" when trying to connect"

SQL-Server: MariaDB 10.6.5

Fix:
Set
skip_name_resolve

to:
### skip_name_resolve

in mysql.cnf and/or mariadb.cnf

Hth.

 

[Nasdaq]

same exact issue, running ubuntu 20 on digital ocean here is the output someone asked for below

xfs_scrub_all.service
xfs_scrub_all.timer
[email protected]
root@Local:/usr/lib/systemd/system# systemctl show mariadb.service
Type=notify
Restart=on-abort
NotifyAccess=main
RestartUSec=5s
TimeoutStartUSec=15min
TimeoutStopUSec=15min
TimeoutAbortUSec=15min
RuntimeMaxUSec=infinity
WatchdogUSec=0
WatchdogTimestampMonotonic=0
RootDirectoryStartOnly=no
RemainAfterExit=no
GuessMainPID=yes
MainPID=0
ControlPID=0
FileDescriptorStoreMax=0
NFileDescriptorStore=0
StatusErrno=0
Result=exit-code
ReloadResult=success
CleanResult=success
UID=[not set]
GID=[not set]
NRestarts=0
OOMPolicy=stop
ExecMainStartTimestamp=Sat 2022-03-12 04:59:44 UTC
ExecMainStartTimestampMonotonic=21157983648
ExecMainExitTimestamp=Sat 2022-03-12 04:59:44 UTC
ExecMainExitTimestampMonotonic=21158190275
ExecMainPID=1048019
ExecMainCode=1
ExecMainStatus=1
ExecStartPre={ path=/usr/bin/install ; argv[]=/usr/bin/install -m >ExecStartPre={ path=/bin/sh ; argv[]=/bin/sh -c systemctl unset-en>ExecStartPre={ path=/bin/sh ; argv[]=/bin/sh -c [ ! -e /usr/bin/ga>ExecStartPreEx={ path=/usr/bin/install ; argv[]=/usr/bin/install ->ExecStartPreEx={ path=/bin/sh ; argv[]=/bin/sh -c systemctl unset->ExecStartPreEx={ path=/bin/sh ; argv[]=/bin/sh -c [ ! -e /usr/bin/>ExecStart={ path=/usr/sbin/mysqld ; argv[]=/usr/sbin/mysqld $MYSQL>ExecStartEx={ path=/usr/sbin/mysqld ; argv[]=/usr/sbin/mysqld $MYS>ExecStartPost={ path=/bin/sh ; argv[]=/bin/sh -c systemctl unset-e>ExecStartPost={ path=/etc/mysql/debian-start ; argv[]=/etc/mysql/d>ExecStartPostEx={ path=/bin/sh ; argv[]=/bin/sh -c systemctl unset>ExecStartPostEx={ path=/etc/mysql/debian-start ; argv[]=/etc/mysql>Slice=system.slice
MemoryCurrent=[not set]
CPUUsageNSec=[not set]
EffectiveCPUs=
EffectiveMemoryNodes=
TasksCurrent=[not set]
IPIngressBytes=[no data]
IPIngressPackets=[no data]
IPEgressBytes=[no data]
IPEgressPackets=[no data]
IOReadBytes=18446744073709551615
IOReadOperations=18446744073709551615
IOWriteBytes=18446744073709551615
IOWriteOperations=18446744073709551615
Delegate=no
CPUAccounting=no
CPUWeight=[not set]
StartupCPUWeight=[not set]
CPUShares=[not set]
StartupCPUShares=[not set]
CPUQuotaPerSecUSec=infinity
CPUQuotaPeriodUSec=infinity
AllowedCPUs=
AllowedMemoryNodes=
IOAccounting=no
IOWeight=[not set]
StartupIOWeight=[not set]
BlockIOAccounting=no
BlockIOWeight=[not set]
StartupBlockIOWeight=[not set]
MemoryAccounting=yes
DefaultMemoryLow=0
DefaultMemoryMin=0
MemoryMin=0
MemoryLow=0
MemoryHigh=infinity
MemoryMax=infinity
MemorySwapMax=infinity
MemoryLimit=infinity
DevicePolicy=closed
TasksAccounting=yes
TasksMax=4677
IPAccounting=no
UMask=0007
LimitCPU=infinity
LimitCPUSoft=infinity
LimitFSIZE=infinity
LimitFSIZESoft=infinity
LimitDATA=infinity
LimitDATASoft=infinity
LimitSTACK=infinity
LimitSTACKSoft=8388608
LimitCORE=infinity
LimitCORESoft=0
LimitRSS=infinity
LimitRSSSoft=infinity
LimitNOFILE=32768
LimitNOFILESoft=32768
LimitAS=infinity
LimitASSoft=infinity
LimitNPROC=15591
LimitNPROCSoft=15591
LimitMEMLOCK=65536
LimitMEMLOCKSoft=65536
LimitLOCKS=infinity
LimitLOCKSSoft=infinity
LimitSIGPENDING=15591
LimitSIGPENDINGSoft=15591
LimitMSGQUEUE=819200
LimitMSGQUEUESoft=819200
LimitNICE=0
LimitNICESoft=0
LimitRTPRIO=0
LimitRTPRIOSoft=0
LimitRTTIME=infinity
LimitRTTIMESoft=infinity
OOMScoreAdjust=0
Nice=0
IOSchedulingClass=0
IOSchedulingPriority=0
CPUSchedulingPolicy=0
CPUSchedulingPriority=0
CPUAffinity=
CPUAffinityFromNUMA=no
NUMAPolicy=n/a
NUMAMask=
TimerSlackNSec=50000
CPUSchedulingResetOnFork=no
NonBlocking=no
StandardInput=null
StandardInputData=
StandardOutput=journal
StandardError=inherit
TTYReset=no
TTYVHangup=no
TTYVTDisallocate=no
SyslogPriority=30
SyslogLevelPrefix=yes
SyslogLevel=6
SyslogFacility=3
LogLevelMax=-1
LogRateLimitIntervalUSec=0
LogRateLimitBurst=0
SecureBits=0
CapabilityBoundingSet=cap_ipc_lock
AmbientCapabilities=
User=mysql
Group=mysql
DynamicUser=no
RemoveIPC=no
MountFlags=
PrivateTmp=no
PrivateDevices=yes
ProtectKernelTunables=no
ProtectKernelModules=no
ProtectKernelLogs=no
ProtectControlGroups=no
PrivateNetwork=no
PrivateUsers=no
PrivateMounts=no
ProtectHome=yes
ProtectSystem=full
SameProcessGroup=no
UtmpMode=init
IgnoreSIGPIPE=yes
NoNewPrivileges=no
SystemCallErrorNumber=0
LockPersonality=no
RuntimeDirectoryPreserve=no
RuntimeDirectoryMode=0755
StateDirectoryMode=0755
CacheDirectoryMode=0755
LogsDirectoryMode=0755
ConfigurationDirectoryMode=0755
TimeoutCleanUSec=infinity
MemoryDenyWriteExecute=no
RestrictRealtime=no
RestrictSUIDSGID=no
RestrictNamespaces=no
MountAPIVFS=no
KeyringMode=private
ProtectHostname=no
KillMode=control-group
KillSignal=15
RestartKillSignal=15
FinalKillSignal=9
SendSIGKILL=no
SendSIGHUP=no
WatchdogSignal=6
Id=mariadb.service
Names=mysql.service mysqld.service mariadb.service
Requires=system.slice sysinit.target
WantedBy=plesk-web-socket.service multi-user.target plesk-cloning.>Conflicts=shutdown.target
Before=plesk-cloning.service plesk-web-socket.service plesk-ext-mo>After=systemd-journald.socket system.slice network.target sysinit.>Documentation=man:mysqld(8) https://mariadb.com/kb/en/library/syst>Description=MariaDB 10.3.34 database server
LoadState=loaded
ActiveState=failed
SubState=failed
FragmentPath=/lib/systemd/system/mariadb.service
UnitFileState=enabled
UnitFilePreset=enabled
StateChangeTimestamp=Sat 2022-03-12 04:59:44 UTC
StateChangeTimestampMonotonic=21158190360
InactiveExitTimestamp=Sat 2022-03-12 04:59:44 UTC
InactiveExitTimestampMonotonic=21157919917
ActiveEnterTimestampMonotonic=0
ActiveExitTimestampMonotonic=0
InactiveEnterTimestamp=Sat 2022-03-12 04:59:44 UTC
InactiveEnterTimestampMonotonic=21158190360
CanStart=yes
CanStop=yes
CanReload=no
CanIsolate=no
StopWhenUnneeded=no
RefuseManualStart=no
RefuseManualStop=no
AllowIsolate=no
DefaultDependencies=yes
OnFailureJobMode=replace
IgnoreOnIsolate=no
NeedDaemonReload=no
JobTimeoutUSec=infinity
JobRunningTimeoutUSec=infinity
JobTimeoutAction=none
ConditionResult=yes
AssertResult=yes
lines 189-233
RestartKillSignal=15
FinalKillSignal=9
SendSIGKILL=no
SendSIGHUP=no
WatchdogSignal=6
Id=mariadb.service
Names=mysql.service mysqld.service mariadb.service
Requires=system.slice sysinit.target
WantedBy=plesk-web-socket.service multi-user.target plesk-cloning.>Conflicts=shutdown.target
Before=plesk-cloning.service plesk-web-socket.service plesk-ext-mo>After=systemd-journald.socket system.slice network.target sysinit.>Documentation=man:mysqld(8) https://mariadb.com/kb/en/library/syst>Description=MariaDB 10.3.34 database server
LoadState=loaded
ActiveState=failed
SubState=failed
FragmentPath=/lib/systemd/system/mariadb.service
UnitFileState=enabled
UnitFilePreset=enabled
StateChangeTimestamp=Sat 2022-03-12 04:59:44 UTC
StateChangeTimestampMonotonic=21158190360
InactiveExitTimestamp=Sat 2022-03-12 04:59:44 UTC
InactiveExitTimestampMonotonic=21157919917
ActiveEnterTimestampMonotonic=0
ActiveExitTimestampMonotonic=0
InactiveEnterTimestamp=Sat 2022-03-12 04:59:44 UTC
InactiveEnterTimestampMonotonic=21158190360
CanStart=yes
CanStop=yes
CanReload=no
CanIsolate=no
StopWhenUnneeded=no
RefuseManualStart=no
RefuseManualStop=no
AllowIsolate=no
DefaultDependencies=yes
OnFailureJobMode=replace
IgnoreOnIsolate=no
NeedDaemonReload=no
JobTimeoutUSec=infinity
JobRunningTimeoutUSec=infinity
JobTimeoutAction=none
ConditionResult=yes
AssertResult=yes
ConditionTimestamp=Sat 2022-03-12 04:59:44 UTC
ConditionTimestampMonotonic=21157918039
AssertTimestamp=Sat 2022-03-12 04:59:44 UTC
AssertTimestampMonotonic=21157918039
Transient=no
Perpetual=no
StartLimitIntervalUSec=10s
StartLimitBurst=5
StartLimitAction=none
FailureAction=none
SuccessAction=none
InvocationID=1fbd683268cc47c79c4eafceab17a675
CollectMode=inactive
root@Local:/usr/lib/systemd