I can't start mariadb.service [SOLVED]

katarok · 2021-06-30 23:48:15

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)

jonno2002 · 2021-07-01 02:45:49

start here

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

post output of

ss -ae | grep mysql

katarok · 2021-07-01 05:54:37

jonno2002 wrote:

post output of
ss -ae | grep mysql

Here

$ ss -ae | grep mysql
u_str LISTEN     0      80                        /opt/lampp/var/mysql/mysql.sock 13090                              * 0      <-> ino:10228918 dev:0/2098 peers:                                                                                                                                            
tcp   LISTEN     0      80                                                      *:mysql                              *:*      uid:965 ino:13089 sk:201d cgroup:/system.slice/xampp.service v6only:0 <->

jonno2002 · 2021-07-01 08:58:50

you already have mysql running under the xampp service, you need to stop that if you want to run mariadb on the default port

katarok · 2021-07-01 17:43:56

jonno2002 wrote:

you already have mysql running under the xampp service, you need to stop that if you want to run mariadb on the default port

But I need xampp.

When I try to use mysql normally I get this.

$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)

how can I have both xampp and mysql.

loqs · 2021-07-01 17:48:37

The ss output shows mysql from xampp is listening on /opt/lampp/var/mysql/mysql.sock not /run/mysqld/mysqld.sock

katarok · 2021-07-01 17:55:20

loqs wrote:

The ss output shows mysql from xampp is listening on /opt/lampp/var/mysql/mysql.sock not /run/mysqld/mysqld.sock

How can I fix this?

loqs · 2021-07-01 18:17:48

This may be an X-Y problem. What are you actually trying to achieve?
Edit:
xampp provides /opt/lampp/bin/mysql and /opt/lampp/sbin/mysqld
Where do mariadb / mariadbd fit in?

Last edited by loqs (2021-07-01 18:56:30)

katarok · 2021-07-01 18:39:13

loqs wrote:

This may be an X-Y problem. What are you actually trying to achieve?

I need the both the phpmyadmin and the mysql at my terminal work at the same time.

loqs · 2021-07-01 18:49:53

When you run /opt/lampp/bin/mysql does that connect correctly to the mysql server provided by xammp?

katarok · 2021-07-01 19:51:22

loqs wrote:

When you run /opt/lampp/bin/mysql does that connect correctly to the mysql server provided by xammp?

Yes! How do I make this be the default when I just type mysql?

loqs · 2021-07-01 19:58:57

Add /opt/lampp/bin/ to $PATH or create a link from a directory already in $PATH pointing to /opt/lampp/bin/mysql.

katarok · 2021-07-01 23:43:57

loqs wrote:

Add /opt/lampp/bin/ to $PATH or create a link from a directory already in $PATH pointing to /opt/lampp/bin/mysql.

I did that and I can access mysql in terminal again as well as in phpmyadmin. Thanks man

Arch Linux

#1 2021-06-30 23:48:15

I can't start mariadb.service [SOLVED]

#2 2021-07-01 02:45:49

Re: I can't start mariadb.service [SOLVED]

#3 2021-07-01 05:54:37

Re: I can't start mariadb.service [SOLVED]

#4 2021-07-01 08:58:50

Re: I can't start mariadb.service [SOLVED]

#5 2021-07-01 17:43:56

Re: I can't start mariadb.service [SOLVED]

#6 2021-07-01 17:48:37

Re: I can't start mariadb.service [SOLVED]

#7 2021-07-01 17:55:20

Re: I can't start mariadb.service [SOLVED]

#8 2021-07-01 18:17:48

Re: I can't start mariadb.service [SOLVED]

#9 2021-07-01 18:39:13

Re: I can't start mariadb.service [SOLVED]

#10 2021-07-01 18:49:53

Re: I can't start mariadb.service [SOLVED]

#11 2021-07-01 19:51:22

Re: I can't start mariadb.service [SOLVED]

#12 2021-07-01 19:58:57

Re: I can't start mariadb.service [SOLVED]

#13 2021-07-01 23:43:57

Re: I can't start mariadb.service [SOLVED]

Board footer