[MDEV-27715] what mariadb has with nginx? Created: 2022-02-02  Updated: 2022-03-23  Resolved: 2022-02-14

Status: Closed
Project: MariaDB Server
Component/s: N/A
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Taras Assignee: Tuukka Pasanen
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

Debian 9.3
mariaDB 10.1.41 -> 10.1.48 -> 10.6.5

Issue Links:
Duplicate
is duplicated by MDEV-26466 Failed to get properties: mariadb-ext... Closed
Relates
relates to MDEV-26461 Unit name mariadb-extra@.socket Closed

 Description   

i has ok update to 10.6.5, db works ok, but –

i got next message when reload nginx –

Failed to get properties: Unit name mariadb-extra@.socket is missing the instance name.
 
Failed to get properties: Unit name mariadb@.socket is missing the instance name.

what?? why?? what to do???

process upgrade log says –

Installing new version of config file /etc/mysql/mariadb.conf.d/50-server.cnf ...
 
mariadb-extra.socket is a disabled or a static unit, not starting it.
 
mariadb-extra.socket is a disabled or a static unit, not starting it.
 
Setting up mariadb-server (1:10.6.5+maria~stretch) ...

so what to do with that weird message??
and why i got that??

 Comments   
Comment by Daniel Black [ 2022-02-02 ]

Templated sockets like mariadb-extra@.socket and mariadb@.socket shouldn't be enabled by default. Use systemctl disable mariadb@.socket to disable them. We'll look to see if they are auto-enabled for some reason.

mariadb-extra.socket is a disabled or a static unit, not starting it. Is just an upgrade message and can be ignored.

Comment by Tuukka Pasanen [ 2022-02-02 ]

Yes they shouldn't be auto-enabled but systemd sockets are difficult that in some cases they work as xinetd that they just launch up if there is request for that port. But as danblack said they are disable so they shouldn't I'll check this up.

Comment by Tuukka Pasanen [ 2022-02-02 ]

221V I need more info about NGinX part as I can't reproduce error with plain installation MariaDB 10.1 -> 10.6 and install NGinX it does not cause error. Do you have multi version MariaDB in use with MariaDB@.service file?

Comment by Taras [ 2022-02-02 ]

i got that messages when start/stop any service, not nginx only

this messages with nginx were 1st that i see

Comment by Taras [ 2022-02-02 ]

systemctl disable mariadb@.socket
not works, doing nothing

nginx version: nginx/1.18.0

what to do?

Comment by Tuukka Pasanen [ 2022-02-03 ]

You don't have multi MariaDB installation in you Debian 9 system? What does systemctl list-dependencies nginx.service say? Is there mariadb-extra@.socket or mariadb@.socket under /etc/systemd (including sub-dirs)?

Comment by Tuukka Pasanen [ 2022-02-03 ]

Is there something on journactl -u mariadb about this situation? This is purely systemd problem.

Comment by Taras [ 2022-02-03 ] 

systemctl list-dependencies nginx.service
 
nginx.service
 
● ├─system.slice
 
● ├─network-online.target
 
● │ └─networking.service
 
● └─sysinit.target
 
●   ├─dev-hugepages.mount
 
●   ├─dev-mqueue.mount
 
●   ├─keyboard-setup.service
 
●   ├─kmod-static-nodes.service
 
●   ├─proc-sys-fs-binfmt_misc.automount
 
●   ├─sys-fs-fuse-connections.mount
 
●   ├─sys-kernel-config.mount
 
●   ├─sys-kernel-debug.mount
 
●   ├─systemd-ask-password-console.path
 
●   ├─systemd-binfmt.service
 
●   ├─systemd-hwdb-update.service
 
●   ├─systemd-journal-flush.service
 
●   ├─systemd-journald.service
 
●   ├─systemd-machine-id-commit.service
 
●   ├─systemd-modules-load.service
 
●   ├─systemd-random-seed.service
 
●   ├─systemd-sysctl.service
 
●   ├─systemd-timesyncd.service
 
●   ├─systemd-tmpfiles-setup-dev.service
 
●   ├─systemd-tmpfiles-setup.service
 
●   ├─systemd-udev-trigger.service
 
●   ├─systemd-udevd.service
 
●   ├─systemd-update-utmp.service
 
●   ├─cryptsetup.target
 
●   ├─local-fs.target
 
●   │ ├─-.mount
 
●   │ ├─systemd-fsck-root.service
 
●   │ └─systemd-remount-fs.service
 
●   └─swap.target

Comment by Tuukka Pasanen [ 2022-02-03 ]

And there is no clue in journalctl -u mariadb? Same problem appers when you are running systemctl start mariadb? Asking this as I am trying to figure out you system setup.

Comment by Taras [ 2022-02-03 ]

no, there are nothing in journalctl -u mariadb about that

so what changed in mariadb 10.6.5 - and this problem we have now?
was no this problem with 10.1

what to do?
how to disable - turn off - this weird messages?

Failed to get properties: Unit name mariadb-extra@.socket is missing the instance name.
 
Failed to get properties: Unit name mariadb@.socket is missing the instance name.

this nervious... (((

Comment by Tuukka Pasanen [ 2022-02-03 ]

What reads besides systemctl list-unit-files (if you seek mariadb@.socket) there should be static. 10.1 and 10.6 are different versions.

Comment by Taras [ 2022-02-03 ]

> Same problem appers when you are running systemctl start mariadb?
no, have not problems, only that messages

> What reads besides systemctl list-unit-files (if you seek mariadb@.socket) there should be static.
i do not understand
what i must to do?

Comment by Taras [ 2022-02-03 ] 

$ systemctl list-unit-files
 
UNIT FILE                              STATE    
proc-sys-fs-binfmt_misc.automount      static   
-.mount                                generated
 
dev-hugepages.mount                    static   
dev-mqueue.mount                       static   
media-cdrom0.mount                     generated
 
proc-sys-fs-binfmt_misc.mount          static   
sys-fs-fuse-connections.mount          static   
sys-kernel-config.mount                static   
sys-kernel-debug.mount                 static   
systemd-ask-password-console.path      static   
systemd-ask-password-wall.path         static   
session-1280.scope                     transient
 
session-1715.scope                     transient
 
session-3.scope                        transient
 
apt-daily-upgrade.service              static   
apt-daily.service                      static   
autovt@.service                        enabled  
bootlogd.service                       masked   
bootlogs.service                       masked   
bootmisc.service                       masked   
certbot.service                        static   
checkfs.service                        masked   
checkroot-bootclean.service            masked   
checkroot.service                      masked   
cloud-config.service                   enabled  
cloud-final.service                    enabled  
cloud-init-local.service               enabled  
cloud-init.service                     enabled  
console-getty.service                  disabled 
console-setup.service                  enabled  
container-getty@.service               static   
cron.service                           enabled  
cryptdisks-early.service               masked   
cryptdisks.service                     masked   
dbus-org.freedesktop.hostname1.service static   
dbus-org.freedesktop.locale1.service   static   
dbus-org.freedesktop.login1.service    static   
dbus-org.freedesktop.network1.service  disabled 
dbus-org.freedesktop.resolve1.service  disabled 
dbus-org.freedesktop.timedate1.service static   
dbus.service                           static   
debug-shell.service                    disabled 
emergency.service                      static   
exim4.service                          generated
 
fuse.service                           masked   
getty-static.service                   static   
getty@.service                         enabled  
gogsgit.service                        enabled  
halt.service                           masked   
hostname.service                       masked   
hwclock.service                        masked   
ifup@.service                          static   
initrd-cleanup.service                 static   
initrd-parse-etc.service               static   
initrd-switch-root.service             static   
initrd-udevadm-cleanup-db.service      static   
keyboard-setup.service                 enabled  
killprocs.service                      masked   
kmod-static-nodes.service              static   
kmod.service                           static   
mariadb.service                        enabled  
mariadb@.service                       disabled 
module-init-tools.service              static   
motd.service                           masked   
mountall-bootclean.service             masked   
mountall.service                       masked   
mountdevsubfs.service                  masked   
mountkernfs.service                    masked   
mountnfs-bootclean.service             masked   
mountnfs.service                       masked   
mysql.service                          enabled  
mysqld.service                         enabled  
networking.service                     enabled  
nginx-debug.service                    disabled 
nginx.service                          enabled  
openvpn-client@.service                disabled 
openvpn-server@.service                disabled 
openvpn.service                        enabled  
openvpn@.service                       disabled 
pgbouncer.service                      generated
 
php7.4-fpm.service                     enabled  
phpsessionclean.service                static   
postgresql.service                     enabled  
postgresql@.service                    disabled 
procps.service                         static   
qemu-guest-agent.service               generated
 
quotaon.service                        static   
rc-local.service                       enabled  
rc.local.service                       enabled  
rc.service                             masked   
rcS.service                            masked   
reboot.service                         masked   
rescue.service                         static   
rmnologin.service                      masked   
rsync.service                          enabled  
rsyslog.service                        enabled  
sendsigs.service                       masked   
serial-getty@.service                  disabled 
single.service                         masked   
ssh.service                            enabled  
ssh@.service                           static   
sshd.service                           enabled  
stop-bootlogd-single.service           masked   
stop-bootlogd.service                  masked   
sudo.service                           disabled 
syslog.service                         enabled  
systemd-ask-password-console.service   static   
systemd-ask-password-wall.service      static   
systemd-backlight@.service             static   
systemd-binfmt.service                 static   
systemd-exit.service                   static   
systemd-fsck-root.service              static   
systemd-fsck@.service                  static   
systemd-fsckd.service                  static   
systemd-halt.service                   static   
systemd-hibernate-resume@.service      static   
systemd-hibernate.service              static   
systemd-hostnamed.service              static   
systemd-hwdb-update.service            static   
systemd-hybrid-sleep.service           static   
systemd-initctl.service                static   
systemd-journal-flush.service          static   
systemd-journald.service               static   
systemd-kexec.service                  static   
systemd-localed.service                static   
systemd-logind.service                 static   
systemd-machine-id-commit.service      static   
systemd-modules-load.service           static   
systemd-networkd-wait-online.service   disabled 
systemd-networkd.service               disabled 
systemd-poweroff.service               static   
systemd-quotacheck.service             static   
systemd-random-seed.service            static   
systemd-reboot.service                 static   
systemd-remount-fs.service             static   
systemd-resolved.service               disabled 
systemd-rfkill.service                 static   
systemd-suspend.service                static   
systemd-sysctl.service                 static   
systemd-timedated.service              static   
systemd-timesyncd.service              enabled  
systemd-tmpfiles-clean.service         static   
systemd-tmpfiles-setup-dev.service     static   
systemd-tmpfiles-setup.service         static   
systemd-udev-settle.service            static   
systemd-udev-trigger.service           static   
systemd-udevd.service                  static   
systemd-update-utmp-runlevel.service   static   
systemd-update-utmp.service            static   
systemd-user-sessions.service          static   
udev.service                           static   
umountfs.service                       masked   
umountnfs.service                      masked   
umountroot.service                     masked   
urandom.service                        static   
user@.service                          static   
x11-common.service                     masked   
machine.slice                          static   
system.slice                           static   
user-1000.slice                        transient
 
user.slice                             static   
dbus.socket                            static   
mariadb-extra.socket                   static   
mariadb-extra@.socket                  static   
mariadb.socket                         static   
mariadb@.socket                        static   
ssh.socket                             disabled 
syslog.socket                          static   
systemd-fsckd.socket                   static   
systemd-initctl.socket                 static   
systemd-journald-audit.socket          static   
systemd-journald-dev-log.socket        static   
systemd-journald.socket                static   
systemd-networkd.socket                disabled 
systemd-rfkill.socket                  static   
systemd-udevd-control.socket           static   
systemd-udevd-kernel.socket            static   
basic.target                           static   
bluetooth.target                       static   
busnames.target                        static   
cloud-config.target                    static   
cloud-init.target                      static   
cryptsetup-pre.target                  static   
cryptsetup.target                      static   
ctrl-alt-del.target                    disabled 
default.target                         static   
emergency.target                       static   
exit.target                            disabled 
final.target                           static   
getty.target                           static   
graphical.target                       static   
halt.target                            disabled 
hibernate.target                       static   
hybrid-sleep.target                    static   
initrd-fs.target                       static   
initrd-root-device.target              static   
initrd-root-fs.target                  static   
initrd-switch-root.target              static   
initrd.target                          static   
kexec.target                           disabled 
local-fs-pre.target                    static   
local-fs.target                        static   
multi-user.target                      static   
network-online.target                  static   
network-pre.target                     static   
network.target                         static   
nss-lookup.target                      static   
nss-user-lookup.target                 static   
paths.target                           static   
poweroff.target                        disabled 
printer.target                         static   
reboot.target                          disabled 
remote-fs-pre.target                   static   
remote-fs.target                       enabled  
rescue.target                          disabled 
rpcbind.target                         static   
runlevel0.target                       disabled 
runlevel1.target                       disabled 
runlevel2.target                       static   
runlevel3.target                       static   
runlevel4.target                       static   
runlevel5.target                       static   
runlevel6.target                       disabled 
shutdown.target                        static   
sigpwr.target                          static   
sleep.target                           static   
slices.target                          static   
smartcard.target                       static   
sockets.target                         static   
sound.target                           static   
suspend.target                         static   
swap.target                            static   
sysinit.target                         static   
system-update.target                   static   
time-sync.target                       static   
timers.target                          static   
umount.target                          static   
apt-daily-upgrade.timer                enabled  
apt-daily.timer                        enabled  
certbot.timer                          enabled  
phpsessionclean.timer                  enabled  
systemd-tmpfiles-clean.timer           static   
 
 
242 unit files listed.
 
lines 227-245/245 (END)

Comment by Daniel Black [ 2022-02-03 ]

Thank you for the information.

Please don't panic. The error, where ever it comes from, indicates that nothing is happening and this isn't going to change, and will remain harmless (if nothing changes on your system).

You have a running mariadb.service which is your main goal.

We will get to the bottom of this.

Comment by Tuukka Pasanen [ 2022-02-10 ]

221V thank you for information. As I can't still reproduce proble I'll ask some extra questions:

  1. question is that I MariaDB running as it's enabled? Can you contact MariaDB instance as usual and are databases upgraded as expected
  2. What output you get systemd-analyze blame and systemd-analyze critical-chain mariadb.service and systemd-analyze critical-chain nginx.service is there traces of socket activation
  3. You seem to have PHP 7.4 from external source if you disable that does it make any difference?
  4. Does disabling Gogs make any diffrence?
Comment by Taras [ 2022-02-10 ] 

root@server1 ~ # service nginx stop
 
Failed to get properties: Unit name mariadb-extra@.socket is missing the instance name.
 
Failed to get properties: Unit name mariadb@.socket is missing the instance name.
 
root@server1 ~ # service mariadb stop
 
Failed to get properties: Unit name mariadb-extra@.socket is missing the instance name.
 
Failed to get properties: Unit name mariadb@.socket is missing the instance name.
 
root@server1 ~ # service nginx start
 
Failed to get properties: Unit name mariadb-extra@.socket is missing the instance name.
 
Failed to get properties: Unit name mariadb@.socket is missing the instance name.
 
root@server1 ~ # service mariadb start
 
Failed to get properties: Unit name mariadb-extra@.socket is missing the instance name.
 
Failed to get properties: Unit name mariadb@.socket is missing the instance name.

got messages after mariadb stopped

systemd-analyze blame
 
          2.886s postgresql@11-main.service
 
          1.890s cloud-init-local.service
 
          1.833s networking.service
 
          1.658s cloud-config.service
 
           948ms apt-daily.service
 
           935ms cloud-init.service
 
           739ms certbot.service
 
           692ms apt-daily-upgrade.service
 
           686ms cloud-final.service
 
           593ms php7.4-fpm.service
 
           575ms dev-sda1.device
 
           406ms mariadb.service
 
           386ms keyboard-setup.service
 
           356ms qemu-guest-agent.service
 
           287ms systemd-logind.service
 
           169ms systemd-udev-trigger.service
 
           158ms exim4.service
 
           140ms rc-local.service
 
           124ms phpsessionclean.service
 
           123ms rsyslog.service
 
           117ms systemd-tmpfiles-setup.service
 
            91ms systemd-journald.service
 
            80ms systemd-timesyncd.service
 
            79ms systemd-modules-load.service
 
            72ms kmod-static-nodes.service
 
            69ms dev-hugepages.mount
 
            57ms systemd-random-seed.service
 
            55ms systemd-sysctl.service
 
            55ms systemd-udevd.service
 
            54ms systemd-tmpfiles-setup-dev.service
 
            51ms dev-mqueue.mount
 
            48ms systemd-remount-fs.service
 
            45ms console-setup.service
 
            37ms sys-kernel-debug.mount
 
            35ms systemd-update-utmp.service
 
            29ms systemd-journal-flush.service
 
            25ms openvpn@server.service
 
            22ms user@1000.service
 
            22ms ssh.service
 
            20ms nginx.service
 
            18ms systemd-tmpfiles-clean.service
 
            16ms systemd-update-utmp-runlevel.service
 
            12ms systemd-user-sessions.service
 
             8ms openvpn.service
 
             3ms postgresql.service
 
             1ms mariadb.socket
 
lines 28-46/46 (END)


systemd-analyze critical-chain mariadb.service
 
The time after the unit is active or started is printed after the "@" character.
 
The time the unit takes to start is printed after the "+" character.
 
 
 
mariadb.service +406ms
 
└─basic.target @5.018s
 
  └─sockets.target @5.017s
 
    └─dbus.socket @5.016s
 
      └─sysinit.target @5.007s
 
        └─cloud-init.service @4.068s +935ms
 
          └─networking.service @2.233s +1.833s
 
            └─network-pre.target @2.227s
 
              └─cloud-init-local.service @334ms +1.890s
 
                └─systemd-remount-fs.service @273ms +48ms
 
                  └─system.slice @222ms
 
                    └─-.slice @180ms


systemd-analyze critical-chain nginx.service
 
The time after the unit is active or started is printed after the "@" character.
 
The time the unit takes to start is printed after the "+" character.
 
 
 
nginx.service +20ms
 
└─basic.target @5.018s
 
  └─sockets.target @5.017s
 
    └─dbus.socket @5.016s
 
      └─sysinit.target @5.007s
 
        └─cloud-init.service @4.068s +935ms
 
          └─networking.service @2.233s +1.833s
 
            └─network-pre.target @2.227s
 
              └─cloud-init-local.service @334ms +1.890s
 
                └─systemd-remount-fs.service @273ms +48ms
 
                  └─system.slice @222ms
 
                    └─-.slice @180ms


root@server1 ~ # service mariadb stop
 
Failed to get properties: Unit name mariadb-extra@.socket is missing the instance name.
 
Failed to get properties: Unit name mariadb@.socket is missing the instance name.
 
root@server1 ~ # service nginx stop
 
Failed to get properties: Unit name mariadb-extra@.socket is missing the instance name.
 
Failed to get properties: Unit name mariadb@.socket is missing the instance name.
 
root@server1 ~ # service gogsgit stop
 
Failed to get properties: Unit name mariadb-extra@.socket is missing the instance name.
 
Failed to get properties: Unit name mariadb@.socket is missing the instance name.
 
root@server1 ~ # service php7.4-fpm stop
 
Failed to get properties: Unit name mariadb-extra@.socket is missing the instance name.
 
Failed to get properties: Unit name mariadb@.socket is missing the instance name.
 
root@server1 ~ # service nginx start
 
Failed to get properties: Unit name mariadb-extra@.socket is missing the instance name.
 
Failed to get properties: Unit name mariadb@.socket is missing the instance name.
 
root@server1 ~ # service mariadb start
 
Failed to get properties: Unit name mariadb-extra@.socket is missing the instance name.
 
Failed to get properties: Unit name mariadb@.socket is missing the instance name.
 
root@server1 ~ # service php7.4-fpm start
 
Failed to get properties: Unit name mariadb-extra@.socket is missing the instance name.
 
Failed to get properties: Unit name mariadb@.socket is missing the instance name.
 
root@server1 ~ # service gogsgit start
 
Failed to get properties: Unit name mariadb-extra@.socket is missing the instance name.
 
Failed to get properties: Unit name mariadb@.socket is missing the instance name.

looks like problem not php or gogs...

Comment by Taras [ 2022-02-10 ]

i see not only me have this problem –
https://jira.mariadb.org/browse/MDEV-26461

Comment by Tuukka Pasanen [ 2022-02-11 ]

Problem seems to be using of /usr/sbin/service wrapper script for systemd and with that I can reproduce problem. Can you verify that systemd stop nginx and systemd start nginx works without warning and if service NGinX starts. It should start with service nginx start also but with warning.

Comment by Tuukka Pasanen [ 2022-02-11 ]

Script tries to see what sockets are available for unit/service and enable them also on start and stop when service is stopped. As marriadb@.socket and mariadb-extra@.socket are not associated with any service/unit or they don't have name as they should be enabled like (only when wanted multi instance service of MariaDB besides that you don't need them) mariadb@something.socket after that they have instance name that is missing without name after '@'-char.
Having this warning should not prevent MariaDB/NGinX or anything else to work. If you use systemctl start mariadb.service you can check if service is up with systemctl status mariadb.service or test if MariaDB is accessible with MariaDB client. It also should be visible on ps-command. If it's not as there is plenty config parameters deprecated and you should check journalctl -u mariadb.service to see if there is error messages.

Comment by Alex [ 2022-02-11 ]

systemd stop nginx command does not work on Debian 10:
systemd stop nginx
Excess arguments.

systemd start nginx
Excess arguments.

service nginx stop:
Failed to get properties: Unit name mariadb-extra@.socket is neither a valid invocation ID nor unit name.
Failed to get properties: Unit name mariadb@.socket is neither a valid invocation ID nor unit name.

service nginx start
Failed to get properties: Unit name mariadb-extra@.socket is neither a valid invocation ID nor unit name.
Failed to get properties: Unit name mariadb@.socket is neither a valid invocation ID nor unit name.

Upgrading to 10.6.6-MariaDB-1:10.6.6+maria~buster-log does not solve the problem.

Comment by Taras [ 2022-02-11 ]

my server is debian 9.3, not 10

root@server1 ~ # service mariadb stop
 
Failed to get properties: Unit name mariadb-extra@.socket is missing the instance name.
 
Failed to get properties: Unit name mariadb@.socket is missing the instance name.
 
root@server1 ~ # systemctl start mariadb.service
 
root@server1 ~ # systemctl status mariadb.service
 
● mariadb.service - MariaDB 10.6.5 database server
 
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
 
  Drop-In: /etc/systemd/system/mariadb.service.d
 
           └─migrated-from-my.cnf-settings.conf
 
   Active: active (running) since Fri 2022-02-11 12:03:08 CET; 15s ago
 
     Docs: man:mariadbd(8)
 
           https://mariadb.com/kb/en/library/systemd/
 
  Process: 23783 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
 
  Process: 23780 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 
  Process: 23721 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && sys
 
  Process: 23715 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 
  Process: 23714 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
 
 Main PID: 23770 (mariadbd)
 
   Status: "Taking your SQL requests now..."
 
    Tasks: 12 (limit: 4915)
 
   CGroup: /system.slice/mariadb.service
 
           └─23770 /usr/sbin/mariadbd
 
 
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Note] InnoDB: 10.6.5 started; log sequence number 289651862; transaction id 2460139
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Note] Plugin 'FEEDBACK' is disabled.
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds w
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Note] Server socket created on IP: '0.0.0.0'.
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Note] /usr/sbin/mariadbd: ready for connections.
 
лют 11 12:03:08 server1 mariadbd[23770]: Version: '10.6.5-MariaDB-1:10.6.5+maria~stretch'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary di
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Note] InnoDB: Buffer pool(s) load completed at 220211 12:03:08
 
лют 11 12:03:08 server1 systemd[1]: Started MariaDB 10.6.5 database server.
 
лют 11 12:03:12 server1 mariadbd[23770]: 2022-02-11 12:03:12 3 [Warning] IP address '45.12.24.101' could not be resolved: Name or service not known
 
lines 10-28/28 (END)

Comment by Taras [ 2022-02-11 ] 

root@server1 ~ # journalctl -u mariadb.service
 
-- Logs begin at Mon 2022-02-07 23:27:36 CET, end at Fri 2022-02-11 12:05:16 CET. --
 
лют 07 23:49:44 server1 mariadbd[13357]: 2022-02-07 23:49:44 506 [Warning] Aborted connection 506 to db: 'unconnected' user: 'unauthenticated' host: 'scanner-0
 
лют 08 02:13:56 server1 mariadbd[13357]: 2022-02-08  2:13:56 507 [Warning] Host name 'ip-112-14.nilsat.net' could not be resolved: Name or service not known
 
лют 08 02:13:56 server1 mariadbd[13357]: 2022-02-08  2:13:56 507 [Warning] Aborted connection 507 to db: 'unconnected' user: 'unauthenticated' host: '78.128.11
 
лют 08 06:18:13 server1 mariadbd[13357]: 2022-02-08  6:18:13 508 [Warning] IP address '35.195.93.98' has been resolved to the host name '98.93.195.35.bc.google
 
лют 08 06:18:13 server1 mariadbd[13357]: 2022-02-08  6:18:13 508 [Warning] Aborted connection 508 to db: 'unconnected' user: 'unauthenticated' host: '35.195.93
 
лют 08 06:18:13 server1 mariadbd[13357]: 2022-02-08  6:18:13 509 [Warning] IP address '130.211.54.158' has been resolved to the host name '158.54.211.130.bc.go
 
лют 08 06:18:13 server1 mariadbd[13357]: 2022-02-08  6:18:13 509 [Warning] Access denied for user 'root'@'130.211.54.158' (using password: NO)
 
лют 08 07:14:55 server1 mariadbd[13357]: 2022-02-08  7:14:55 511 [Warning] Aborted connection 511 to db: 'unconnected' user: 'unauthenticated' host: 'scanner-2
 
лют 08 10:15:02 server1 mariadbd[13357]: 2022-02-08 10:15:02 512 [Warning] Aborted connection 512 to db: 'unconnected' user: 'unauthenticated' host: '78.128.11
 
лют 08 15:29:48 server1 mariadbd[13357]: 2022-02-08 15:29:48 513 [Warning] Access denied for user 'root'@'164.90.199.9' (using password: NO)
 
лют 08 15:29:48 server1 mariadbd[13357]: 2022-02-08 15:29:48 514 [Warning] Access denied for user 'root'@'164.90.199.9' (using password: YES)
 
лют 08 15:29:48 server1 mariadbd[13357]: 2022-02-08 15:29:48 515 [Warning] Access denied for user 'root'@'164.90.199.9' (using password: YES)
 
лют 08 15:29:48 server1 mariadbd[13357]: 2022-02-08 15:29:48 516 [Warning] Access denied for user 'root'@'164.90.199.9' (using password: YES)
 
лют 08 15:29:48 server1 mariadbd[13357]: 2022-02-08 15:29:48 517 [Warning] Access denied for user 'root'@'164.90.199.9' (using password: YES)
 
лют 08 15:29:48 server1 mariadbd[13357]: 2022-02-08 15:29:48 518 [Warning] Access denied for user 'root'@'164.90.199.9' (using password: NO)
 
лют 08 15:29:48 server1 mariadbd[13357]: 2022-02-08 15:29:48 519 [Warning] Access denied for user 'root'@'164.90.199.9' (using password: YES)
 
лют 08 15:29:48 server1 mariadbd[13357]: 2022-02-08 15:29:48 520 [Warning] Access denied for user 'root'@'164.90.199.9' (using password: YES)
 
лют 08 15:29:48 server1 mariadbd[13357]: 2022-02-08 15:29:48 521 [Warning] Access denied for user 'root'@'164.90.199.9' (using password: YES)
 
лют 08 15:29:48 server1 mariadbd[13357]: 2022-02-08 15:29:48 522 [Warning] Access denied for user 'root'@'164.90.199.9' (using password: YES)
 
лют 08 15:29:48 server1 mariadbd[13357]: 2022-02-08 15:29:48 523 [Warning] Access denied for user 'root'@'164.90.199.9' (using password: YES)
 
лют 08 15:29:48 server1 mariadbd[13357]: 2022-02-08 15:29:48 524 [Warning] Access denied for user 'root'@'164.90.199.9' (using password: YES)
 
лют 08 15:29:48 server1 mariadbd[13357]: 2022-02-08 15:29:48 525 [Warning] Access denied for user 'root'@'164.90.199.9' (using password: YES)
 
лют 08 15:29:48 server1 mariadbd[13357]: 2022-02-08 15:29:48 526 [Warning] Access denied for user 'root'@'164.90.199.9' (using password: YES)
 
лют 08 15:29:48 server1 mariadbd[13357]: 2022-02-08 15:29:48 527 [Warning] Access denied for user 'root'@'164.90.199.9' (using password: YES)
 
лют 08 15:29:48 server1 mariadbd[13357]: 2022-02-08 15:29:48 528 [Warning] Access denied for user 'root'@'164.90.199.9' (using password: YES)
 
лют 08 15:29:49 server1 mariadbd[13357]: 2022-02-08 15:29:49 529 [Warning] Access denied for user 'root'@'164.90.199.9' (using password: YES)
 
лют 08 15:29:49 server1 mariadbd[13357]: 2022-02-08 15:29:49 530 [Warning] Access denied for user 'root'@'164.90.199.9' (using password: YES)
 
лют 08 15:29:49 server1 mariadbd[13357]: 2022-02-08 15:29:49 531 [Warning] Access denied for user 'root'@'164.90.199.9' (using password: YES)
 
лют 08 15:29:49 server1 mariadbd[13357]: 2022-02-08 15:29:49 532 [Warning] Access denied for user 'root'@'164.90.199.9' (using password: YES)
 
лют 08 15:29:49 server1 mariadbd[13357]: 2022-02-08 15:29:49 533 [Warning] Access denied for user 'root'@'164.90.199.9' (using password: YES)
 
лют 08 15:29:49 server1 mariadbd[13357]: 2022-02-08 15:29:49 534 [Warning] Access denied for user 'root'@'164.90.199.9' (using password: YES)
 
лют 08 16:18:28 server1 mariadbd[13357]: 2022-02-08 16:18:28 535 [Warning] IP address '34.86.35.18' has been resolved to the host name '18.35.86.34.bc.googleus
 
лют 08 16:18:38 server1 mariadbd[13357]: 2022-02-08 16:18:38 535 [Warning] Aborted connection 535 to db: 'unconnected' user: 'unauthenticated' host: '34.86.35.
 
лют 09 00:08:22 server1 mariadbd[13357]: 2022-02-09  0:08:22 537 [Warning] IP address '175.198.181.162' could not be resolved: Name or service not known
 
лют 09 00:08:22 server1 mariadbd[13357]: 2022-02-09  0:08:22 537 [Warning] Aborted connection 537 to db: 'unconnected' user: 'unauthenticated' host: '175.198.1
 
лют 09 00:08:24 server1 mariadbd[13357]: 2022-02-09  0:08:24 538 [Warning] Aborted connection 538 to db: 'unconnected' user: 'unauthenticated' host: '175.198.1
 
лют 09 00:56:43 server1 mariadbd[13357]: 2022-02-09  0:56:43 539 [Warning] Aborted connection 539 to db: 'unconnected' user: 'unauthenticated' host: 'scan-57-1
 
лют 09 05:22:20 server1 mariadbd[13357]: 2022-02-09  5:22:20 543 [Warning] IP address '45.143.200.118' could not be resolved: Name or service not known
 
лют 09 05:22:20 server1 mariadbd[13357]: 2022-02-09  5:22:20 543 [Warning] Aborted connection 543 to db: 'unconnected' user: 'unauthenticated' host: '45.143.20
 
лют 09 05:57:02 server1 mariadbd[13357]: 2022-02-09  5:57:02 544 [Warning] Host name 'jqvrhdo.cn' could not be resolved: Name or service not known
 
лют 09 05:57:02 server1 mariadbd[13357]: 2022-02-09  5:57:02 544 [Warning] Aborted connection 544 to db: 'unconnected' user: 'unauthenticated' host: '106.75.21
 
лют 09 06:11:50 server1 mariadbd[13357]: 2022-02-09  6:11:50 545 [Warning] IP address '35.195.93.98' has been resolved to the host name '98.93.195.35.bc.google
 
лют 09 06:11:50 server1 mariadbd[13357]: 2022-02-09  6:11:50 545 [Warning] Aborted connection 545 to db: 'unconnected' user: 'unauthenticated' host: '35.195.93
 
лют 09 06:11:50 server1 mariadbd[13357]: 2022-02-09  6:11:50 546 [Warning] IP address '35.195.93.98' has been resolved to the host name '98.93.195.35.bc.google
 
лют 09 06:11:50 server1 mariadbd[13357]: 2022-02-09  6:11:50 546 [Warning] Access denied for user 'root'@'35.195.93.98' (using password: NO)
 
лют 09 08:48:09 server1 mariadbd[13357]: 2022-02-09  8:48:09 548 [Warning] Aborted connection 548 to db: 'unconnected' user: 'unauthenticated' host: 'connectin
 
лют 09 08:56:10 server1 mariadbd[13357]: 2022-02-09  8:56:10 549 [Warning] Hostname 'security.criminalip.com' does not resolve to '89.248.169.12'.
 
лют 09 08:56:10 server1 mariadbd[13357]: 2022-02-09  8:56:10 549 [Note] Hostname 'security.criminalip.com' has the following IP addresses:
 
лют 09 08:56:10 server1 mariadbd[13357]: 2022-02-09  8:56:10 549 [Note]  - 15.164.5.209
 
лют 09 08:56:10 server1 mariadbd[13357]: 2022-02-09  8:56:10 549 [Warning] Aborted connection 549 to db: 'unconnected' user: 'unauthenticated' host: '89.248.16
 
лют 09 11:09:33 server1 mariadbd[13357]: 2022-02-09 11:09:33 550 [Warning] Aborted connection 550 to db: 'unconnected' user: 'unauthenticated' host: 'scanner-0
 
лют 09 16:46:32 server1 mariadbd[13357]: 2022-02-09 16:46:32 551 [Warning] IP address '34.96.130.4' has been resolved to the host name '4.130.96.34.bc.googleus
 
лют 09 16:46:42 server1 mariadbd[13357]: 2022-02-09 16:46:42 551 [Warning] Aborted connection 551 to db: 'unconnected' user: 'unauthenticated' host: '34.96.130
 
лют 09 20:52:58 server1 mariadbd[13357]: 2022-02-09 20:52:58 552 [Warning] Aborted connection 552 to db: 'unconnected' user: 'unauthenticated' host: 'scanner-2
 
лют 10 01:14:24 server1 mariadbd[13357]: 2022-02-10  1:14:24 555 [Warning] Aborted connection 555 to db: 'unconnected' user: 'unauthenticated' host: 'scanner-2
 
лют 10 04:11:39 server1 mariadbd[13357]: 2022-02-10  4:11:39 556 [Warning] Aborted connection 556 to db: 'unconnected' user: 'unauthenticated' host: 'battery.c
 
лют 10 04:13:59 server1 mariadbd[13357]: 2022-02-10  4:13:59 557 [Warning] IP address '35.233.62.116' has been resolved to the host name '116.62.233.35.bc.goog
 
лют 10 04:13:59 server1 mariadbd[13357]: 2022-02-10  4:13:59 557 [Warning] Aborted connection 557 to db: 'unconnected' user: 'unauthenticated' host: '35.233.62
 
лют 10 04:14:02 server1 mariadbd[13357]: 2022-02-10  4:14:02 558 [Warning] IP address '130.211.54.158' has been resolved to the host name '158.54.211.130.bc.go
 
лют 10 04:14:02 server1 mariadbd[13357]: 2022-02-10  4:14:02 558 [Warning] Access denied for user 'root'@'130.211.54.158' (using password: NO)
 
лют 10 04:54:22 server1 mariadbd[13357]: 2022-02-10  4:54:22 559 [Warning] IP address '167.99.53.159' could not be resolved: Name or service not known
 
лют 10 04:54:32 server1 mariadbd[13357]: 2022-02-10  4:54:32 559 [Warning] Aborted connection 559 to db: 'unconnected' user: 'unauthenticated' host: '167.99.53
 
лют 10 05:21:11 server1 mariadbd[13357]: 2022-02-10  5:21:11 560 [Warning] Aborted connection 560 to db: 'unconnected' user: 'unauthenticated' host: '167.99.53
 
лют 10 05:41:32 server1 mariadbd[13357]: 2022-02-10  5:41:32 561 [Warning] Aborted connection 561 to db: 'unconnected' user: 'unauthenticated' host: '45.143.20
 
лют 10 05:59:03 server1 mariadbd[13357]: 2022-02-10  5:59:03 562 [Warning] IP address '130.211.54.158' has been resolved to the host name '158.54.211.130.bc.go
 
лют 10 05:59:03 server1 mariadbd[13357]: 2022-02-10  5:59:03 562 [Warning] Aborted connection 562 to db: 'unconnected' user: 'unauthenticated' host: '130.211.5
 
лют 10 05:59:04 server1 mariadbd[13357]: 2022-02-10  5:59:04 563 [Warning] IP address '35.195.93.98' has been resolved to the host name '98.93.195.35.bc.google
 
лют 10 05:59:04 server1 mariadbd[13357]: 2022-02-10  5:59:04 563 [Warning] Access denied for user 'root'@'35.195.93.98' (using password: NO)
 
лют 10 11:28:14 server1 mariadbd[13357]: 2022-02-10 11:28:14 567 [Warning] Aborted connection 567 to db: 'unconnected' user: 'unauthenticated' host: '45.143.20
 
лют 10 13:48:47 server1 mariadbd[13357]: 2022-02-10 13:48:47 568 [Warning] Aborted connection 568 to db: 'unconnected' user: 'unauthenticated' host: 'michael-k
 
лют 10 15:26:21 server1 mariadbd[13357]: 2022-02-10 15:26:21 569 [Warning] IP address '159.223.26.124' could not be resolved: Name or service not known
 
лют 10 15:26:21 server1 mariadbd[13357]: 2022-02-10 15:26:21 569 [Warning] Aborted connection 569 to db: 'unconnected' user: 'unauthenticated' host: '159.223.2
 
лют 10 15:26:21 server1 mariadbd[13357]: 2022-02-10 15:26:21 570 [Warning] Aborted connection 570 to db: 'unconnected' user: 'unauthenticated' host: '159.223.2
 
лют 10 15:26:21 server1 mariadbd[13357]: 2022-02-10 15:26:21 571 [Warning] Aborted connection 571 to db: 'unconnected' user: 'unauthenticated' host: '159.223.2
 
лют 10 15:26:21 server1 mariadbd[13357]: 2022-02-10 15:26:21 572 [Warning] Aborted connection 572 to db: 'unconnected' user: 'unauthenticated' host: '159.223.2
 
лют 10 15:26:21 server1 mariadbd[13357]: 2022-02-10 15:26:21 573 [Warning] Aborted connection 573 to db: 'unconnected' user: 'unauthenticated' host: '159.223.2
 
лют 10 15:26:22 server1 mariadbd[13357]: 2022-02-10 15:26:22 574 [Warning] Aborted connection 574 to db: 'unconnected' user: 'unauthenticated' host: '159.223.2
 
лют 10 15:26:22 server1 mariadbd[13357]: 2022-02-10 15:26:22 575 [Warning] Aborted connection 575 to db: 'unconnected' user: 'unauthenticated' host: '159.223.2
 
лют 10 15:26:22 server1 mariadbd[13357]: 2022-02-10 15:26:22 576 [Warning] Aborted connection 576 to db: 'unconnected' user: 'unauthenticated' host: '159.223.2
 
лют 10 17:30:55 server1 mariadbd[13357]: 2022-02-10 17:30:55 577 [Warning] Aborted connection 577 to db: 'unconnected' user: 'unauthenticated' host: 'connectin
 
лют 10 17:56:34 server1 mariadbd[13357]: 2022-02-10 17:56:34 578 [Warning] IP address '34.86.35.9' has been resolved to the host name '9.35.86.34.bc.googleuser
 
лют 10 17:56:44 server1 mariadbd[13357]: 2022-02-10 17:56:44 578 [Warning] Aborted connection 578 to db: 'unconnected' user: 'unauthenticated' host: '34.86.35.
 
лют 10 18:39:31 server1 mariadbd[13357]: 2022-02-10 18:39:31 579 [Warning] Aborted connection 579 to db: 'unconnected' user: 'unauthenticated' host: 'tor-exit-
 
лют 10 20:17:14 server1 mariadbd[13357]: 2022-02-10 20:17:14 580 [Warning] Aborted connection 580 to db: 'unconnected' user: 'unauthenticated' host: 'michael-k
 
лют 10 23:15:47 server1 systemd[1]: Stopping MariaDB 10.6.5 database server...
 
лют 10 23:15:47 server1 mariadbd[13357]: 2022-02-10 23:15:47 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
 
лют 10 23:15:47 server1 mariadbd[13357]: 2022-02-10 23:15:47 0 [Note] InnoDB: FTS optimize thread exiting.
 
лют 10 23:15:47 server1 mariadbd[13357]: 2022-02-10 23:15:47 0 [Note] InnoDB: Starting shutdown...
 
лют 10 23:15:47 server1 mariadbd[13357]: 2022-02-10 23:15:47 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
 
лют 10 23:15:47 server1 mariadbd[13357]: 2022-02-10 23:15:47 0 [Note] InnoDB: Buffer pool(s) dump completed at 220210 23:15:47
 
лют 10 23:15:47 server1 mariadbd[13357]: 2022-02-10 23:15:47 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
 
лют 10 23:15:47 server1 mariadbd[13357]: 2022-02-10 23:15:47 0 [Note] InnoDB: Shutdown completed; log sequence number 289651838; transaction id 2460143
 
лют 10 23:15:47 server1 mariadbd[13357]: 2022-02-10 23:15:47 0 [Note] /usr/sbin/mariadbd: Shutdown complete
 
лют 10 23:15:47 server1 systemd[1]: Stopped MariaDB 10.6.5 database server.
 
лют 10 23:15:59 server1 systemd[1]: Starting MariaDB 10.6.5 database server...
 
лют 10 23:15:59 server1 mariadbd[10037]: 2022-02-10 23:15:59 0 [Note] /usr/sbin/mariadbd (server 10.6.5-MariaDB-1:10.6.5+maria~stretch) starting as process 100
 
лют 10 23:16:00 server1 mariadbd[10037]: 2022-02-10 23:16:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
 
лют 10 23:16:00 server1 mariadbd[10037]: 2022-02-10 23:16:00 0 [Note] InnoDB: Number of pools: 1
 
лют 10 23:16:00 server1 mariadbd[10037]: 2022-02-10 23:16:00 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
 
лют 10 23:16:00 server1 mariadbd[10037]: 2022-02-10 23:16:00 0 [Note] InnoDB: Using Linux native AIO
 
лют 10 23:16:00 server1 mariadbd[10037]: 2022-02-10 23:16:00 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
 
лют 10 23:16:00 server1 mariadbd[10037]: 2022-02-10 23:16:00 0 [Note] InnoDB: Completed initialization of buffer pool
 
лют 10 23:16:00 server1 mariadbd[10037]: 2022-02-10 23:16:00 0 [Note] InnoDB: 128 rollback segments are active.
 
лют 10 23:16:00 server1 mariadbd[10037]: 2022-02-10 23:16:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
 
лют 10 23:16:00 server1 mariadbd[10037]: 2022-02-10 23:16:00 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please w
 
лют 10 23:16:00 server1 mariadbd[10037]: 2022-02-10 23:16:00 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
 
лют 10 23:16:00 server1 mariadbd[10037]: 2022-02-10 23:16:00 0 [Note] InnoDB: 10.6.5 started; log sequence number 289651838; transaction id 2460139
 
лют 10 23:16:00 server1 mariadbd[10037]: 2022-02-10 23:16:00 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
 
лют 10 23:16:00 server1 mariadbd[10037]: 2022-02-10 23:16:00 0 [Note] Plugin 'FEEDBACK' is disabled.
 
лют 10 23:16:00 server1 mariadbd[10037]: 2022-02-10 23:16:00 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds w
 
лют 10 23:16:00 server1 mariadbd[10037]: 2022-02-10 23:16:00 0 [Note] Using systemd activated socket host :: port 3306
 
лют 10 23:16:00 server1 mariadbd[10037]: 2022-02-10 23:16:00 0 [Note] Using systemd activated unix socket /run/mysqld/mysqld.sock
 
лют 10 23:16:00 server1 mariadbd[10037]: 2022-02-10 23:16:00 0 [Note] Using systemd activated unix socket @mariadbqld/mysqld.sock
 
лют 10 23:16:00 server1 mariadbd[10037]: 2022-02-10 23:16:00 0 [Note] Using systemd activated unix socket /run/mysqld/mysqld.sock-extra (extra)
 
лют 10 23:16:00 server1 mariadbd[10037]: 2022-02-10 23:16:00 0 [Note] Using systemd activated unix socket @mariadb-extrasqld.sock-extra (extra)
 
лют 10 23:16:00 server1 mariadbd[10037]: 2022-02-10 23:16:00 0 [Note] /usr/sbin/mariadbd: ready for connections.
 
лют 10 23:16:00 server1 mariadbd[10037]: Version: '10.6.5-MariaDB-1:10.6.5+maria~stretch'  socket: 'Systemd socket activated ports'  port: 3306  mariadb.org bi
 
лют 10 23:16:00 server1 mariadbd[10037]: 2022-02-10 23:16:00 0 [Note] InnoDB: Buffer pool(s) load completed at 220210 23:16:00
 
лют 10 23:16:00 server1 systemd[1]: Started MariaDB 10.6.5 database server.
 
лют 10 23:21:03 server1 systemd[1]: Stopping MariaDB 10.6.5 database server...
 
лют 10 23:21:03 server1 mariadbd[10037]: 2022-02-10 23:21:03 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
 
лют 10 23:21:03 server1 mariadbd[10037]: 2022-02-10 23:21:03 0 [Note] InnoDB: FTS optimize thread exiting.
 
лют 10 23:21:03 server1 mariadbd[10037]: 2022-02-10 23:21:03 0 [Note] InnoDB: Starting shutdown...
 
лют 10 23:21:03 server1 mariadbd[10037]: 2022-02-10 23:21:03 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
 
лют 10 23:21:03 server1 mariadbd[10037]: 2022-02-10 23:21:03 0 [Note] InnoDB: Buffer pool(s) dump completed at 220210 23:21:03
 
лют 10 23:21:03 server1 mariadbd[10037]: 2022-02-10 23:21:03 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
 
лют 10 23:21:03 server1 mariadbd[10037]: 2022-02-10 23:21:03 0 [Note] InnoDB: Shutdown completed; log sequence number 289651850; transaction id 2460140
 
лют 10 23:21:03 server1 mariadbd[10037]: 2022-02-10 23:21:03 0 [Note] /usr/sbin/mariadbd: Shutdown complete
 
лют 10 23:21:03 server1 systemd[1]: Stopped MariaDB 10.6.5 database server.
 
лют 10 23:21:27 server1 systemd[1]: Starting MariaDB 10.6.5 database server...
 
лют 10 23:21:27 server1 mariadbd[10284]: 2022-02-10 23:21:27 0 [Note] /usr/sbin/mariadbd (server 10.6.5-MariaDB-1:10.6.5+maria~stretch) starting as process 102
 
лют 10 23:21:27 server1 mariadbd[10284]: 2022-02-10 23:21:27 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
 
лют 10 23:21:27 server1 mariadbd[10284]: 2022-02-10 23:21:27 0 [Note] InnoDB: Number of pools: 1
 
лют 10 23:21:27 server1 mariadbd[10284]: 2022-02-10 23:21:27 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
 
лют 10 23:21:27 server1 mariadbd[10284]: 2022-02-10 23:21:27 0 [Note] InnoDB: Using Linux native AIO
 
лют 10 23:21:27 server1 mariadbd[10284]: 2022-02-10 23:21:27 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
 
лют 10 23:21:27 server1 mariadbd[10284]: 2022-02-10 23:21:27 0 [Note] InnoDB: Completed initialization of buffer pool
 
лют 10 23:21:27 server1 mariadbd[10284]: 2022-02-10 23:21:27 0 [Note] InnoDB: 128 rollback segments are active.
 
лют 10 23:21:27 server1 mariadbd[10284]: 2022-02-10 23:21:27 0 [Note] InnoDB: Creating shared tablespace for temporary tables
 
лют 10 23:21:27 server1 mariadbd[10284]: 2022-02-10 23:21:27 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please w
 
лют 10 23:21:27 server1 mariadbd[10284]: 2022-02-10 23:21:27 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
 
лют 10 23:21:27 server1 mariadbd[10284]: 2022-02-10 23:21:27 0 [Note] InnoDB: 10.6.5 started; log sequence number 289651850; transaction id 2460139
 
лют 10 23:21:27 server1 mariadbd[10284]: 2022-02-10 23:21:27 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
 
лют 10 23:21:27 server1 mariadbd[10284]: 2022-02-10 23:21:27 0 [Note] Plugin 'FEEDBACK' is disabled.
 
лют 10 23:21:27 server1 mariadbd[10284]: 2022-02-10 23:21:27 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds w
 
лют 10 23:21:27 server1 mariadbd[10284]: 2022-02-10 23:21:27 0 [Note] Using systemd activated socket host :: port 3306
 
лют 10 23:21:27 server1 mariadbd[10284]: 2022-02-10 23:21:27 0 [Note] Using systemd activated unix socket /run/mysqld/mysqld.sock
 
лют 10 23:21:27 server1 mariadbd[10284]: 2022-02-10 23:21:27 0 [Note] Using systemd activated unix socket @mariadbqld/mysqld.sock
 
лют 10 23:21:27 server1 mariadbd[10284]: 2022-02-10 23:21:27 0 [Note] Using systemd activated unix socket /run/mysqld/mysqld.sock-extra (extra)
 
лют 10 23:21:27 server1 mariadbd[10284]: 2022-02-10 23:21:27 0 [Note] Using systemd activated unix socket @mariadb-extrasqld.sock-extra (extra)
 
лют 10 23:21:27 server1 mariadbd[10284]: 2022-02-10 23:21:27 0 [Note] /usr/sbin/mariadbd: ready for connections.
 
лют 10 23:21:27 server1 mariadbd[10284]: Version: '10.6.5-MariaDB-1:10.6.5+maria~stretch'  socket: 'Systemd socket activated ports'  port: 3306  mariadb.org bi
 
лют 10 23:21:27 server1 mariadbd[10284]: 2022-02-10 23:21:27 0 [Note] InnoDB: Buffer pool(s) load completed at 220210 23:21:27
 
лют 10 23:21:27 server1 systemd[1]: Started MariaDB 10.6.5 database server.
 
лют 11 04:34:57 server1 mariadbd[10284]: 2022-02-11  4:34:57 3 [Warning] IP address '159.89.194.175' could not be resolved: Name or service not known
 
лют 11 04:34:57 server1 mariadbd[10284]: 2022-02-11  4:34:57 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '159.89.194.17
 
лют 11 05:23:01 server1 mariadbd[10284]: 2022-02-11  5:23:01 4 [Warning] IP address '143.244.171.93' could not be resolved: Name or service not known
 
лют 11 05:23:01 server1 mariadbd[10284]: 2022-02-11  5:23:01 4 [Warning] Access denied for user 'root'@'143.244.171.93' (using password: NO)
 
лют 11 05:23:01 server1 mariadbd[10284]: 2022-02-11  5:23:01 5 [Warning] Access denied for user 'root'@'143.244.171.93' (using password: YES)
 
лют 11 05:23:01 server1 mariadbd[10284]: 2022-02-11  5:23:01 6 [Warning] Access denied for user 'root'@'143.244.171.93' (using password: YES)
 
лют 11 05:23:02 server1 mariadbd[10284]: 2022-02-11  5:23:02 7 [Warning] Access denied for user 'root'@'143.244.171.93' (using password: YES)
 
лют 11 05:23:02 server1 mariadbd[10284]: 2022-02-11  5:23:02 8 [Warning] Access denied for user 'root'@'143.244.171.93' (using password: YES)
 
лют 11 05:23:02 server1 mariadbd[10284]: 2022-02-11  5:23:02 9 [Warning] Access denied for user 'root'@'143.244.171.93' (using password: NO)
 
лют 11 05:23:02 server1 mariadbd[10284]: 2022-02-11  5:23:02 10 [Warning] Access denied for user 'root'@'143.244.171.93' (using password: YES)
 
лют 11 05:23:03 server1 mariadbd[10284]: 2022-02-11  5:23:03 11 [Warning] Access denied for user 'root'@'143.244.171.93' (using password: YES)
 
лют 11 05:23:03 server1 mariadbd[10284]: 2022-02-11  5:23:03 12 [Warning] Access denied for user 'root'@'143.244.171.93' (using password: YES)
 
лют 11 05:23:03 server1 mariadbd[10284]: 2022-02-11  5:23:03 13 [Warning] Access denied for user 'root'@'143.244.171.93' (using password: YES)
 
лют 11 05:23:03 server1 mariadbd[10284]: 2022-02-11  5:23:03 14 [Warning] Access denied for user 'root'@'143.244.171.93' (using password: YES)
 
лют 11 05:23:04 server1 mariadbd[10284]: 2022-02-11  5:23:04 15 [Warning] Access denied for user 'root'@'143.244.171.93' (using password: YES)
 
лют 11 05:23:04 server1 mariadbd[10284]: 2022-02-11  5:23:04 16 [Warning] Access denied for user 'root'@'143.244.171.93' (using password: YES)
 
лют 11 05:23:04 server1 mariadbd[10284]: 2022-02-11  5:23:04 17 [Warning] Access denied for user 'root'@'143.244.171.93' (using password: YES)
 
лют 11 05:23:05 server1 mariadbd[10284]: 2022-02-11  5:23:05 18 [Warning] Access denied for user 'root'@'143.244.171.93' (using password: YES)
 
лют 11 05:23:05 server1 mariadbd[10284]: 2022-02-11  5:23:05 19 [Warning] Access denied for user 'root'@'143.244.171.93' (using password: YES)
 
лют 11 05:23:05 server1 mariadbd[10284]: 2022-02-11  5:23:05 20 [Warning] Access denied for user 'root'@'143.244.171.93' (using password: YES)
 
лют 11 05:23:05 server1 mariadbd[10284]: 2022-02-11  5:23:05 21 [Warning] Access denied for user 'root'@'143.244.171.93' (using password: YES)
 
лют 11 05:23:06 server1 mariadbd[10284]: 2022-02-11  5:23:06 22 [Warning] Access denied for user 'root'@'143.244.171.93' (using password: YES)
 
лют 11 05:23:06 server1 mariadbd[10284]: 2022-02-11  5:23:06 23 [Warning] Access denied for user 'root'@'143.244.171.93' (using password: YES)
 
лют 11 05:23:06 server1 mariadbd[10284]: 2022-02-11  5:23:06 24 [Warning] Access denied for user 'root'@'143.244.171.93' (using password: YES)
 
лют 11 05:23:06 server1 mariadbd[10284]: 2022-02-11  5:23:06 25 [Warning] Access denied for user 'root'@'143.244.171.93' (using password: YES)
 
лют 11 05:45:12 server1 mariadbd[10284]: 2022-02-11  5:45:12 26 [Warning] IP address '130.211.54.158' has been resolved to the host name '158.54.211.130.bc.goo
 
лют 11 05:45:12 server1 mariadbd[10284]: 2022-02-11  5:45:12 26 [Warning] Aborted connection 26 to db: 'unconnected' user: 'unauthenticated' host: '130.211.54.
 
лют 11 05:45:13 server1 mariadbd[10284]: 2022-02-11  5:45:13 27 [Warning] IP address '130.211.54.158' has been resolved to the host name '158.54.211.130.bc.goo
 
лют 11 05:45:13 server1 mariadbd[10284]: 2022-02-11  5:45:13 27 [Warning] Access denied for user 'root'@'130.211.54.158' (using password: NO)
 
лют 11 12:02:51 server1 mariadbd[10284]: 2022-02-11 12:02:51 31 [Warning] IP address '45.12.24.101' could not be resolved: Name or service not known
 
лют 11 12:02:57 server1 systemd[1]: Stopping MariaDB 10.6.5 database server...
 
лют 11 12:02:57 server1 mariadbd[10284]: 2022-02-11 12:02:57 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
 
лют 11 12:02:57 server1 mariadbd[10284]: 2022-02-11 12:02:57 0 [Note] InnoDB: FTS optimize thread exiting.
 
лют 11 12:02:57 server1 mariadbd[10284]: 2022-02-11 12:02:57 0 [Note] InnoDB: Starting shutdown...
 
лют 11 12:02:57 server1 mariadbd[10284]: 2022-02-11 12:02:57 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
 
лют 11 12:02:57 server1 mariadbd[10284]: 2022-02-11 12:02:57 0 [Note] InnoDB: Buffer pool(s) dump completed at 220211 12:02:57
 
лют 11 12:02:57 server1 mariadbd[10284]: 2022-02-11 12:02:57 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
 
лют 11 12:02:57 server1 mariadbd[10284]: 2022-02-11 12:02:57 0 [Note] InnoDB: Shutdown completed; log sequence number 289651862; transaction id 2460141
 
лют 11 12:02:57 server1 mariadbd[10284]: 2022-02-11 12:02:57 0 [Note] /usr/sbin/mariadbd: Shutdown complete
 
лют 11 12:02:57 server1 systemd[1]: Stopped MariaDB 10.6.5 database server.
 
лют 11 12:03:07 server1 systemd[1]: Starting MariaDB 10.6.5 database server...
 
лют 11 12:03:07 server1 mariadbd[23770]: 2022-02-11 12:03:07 0 [Note] /usr/sbin/mariadbd (server 10.6.5-MariaDB-1:10.6.5+maria~stretch) starting as process 237
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Note] InnoDB: Number of pools: 1
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Note] InnoDB: Using Linux native AIO
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Note] InnoDB: Completed initialization of buffer pool
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Note] InnoDB: 128 rollback segments are active.
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Note] InnoDB: Creating shared tablespace for temporary tables
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please w
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Note] InnoDB: 10.6.5 started; log sequence number 289651862; transaction id 2460139
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Note] Plugin 'FEEDBACK' is disabled.
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds w
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Note] Server socket created on IP: '0.0.0.0'.
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Note] /usr/sbin/mariadbd: ready for connections.
 
лют 11 12:03:08 server1 mariadbd[23770]: Version: '10.6.5-MariaDB-1:10.6.5+maria~stretch'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary di
 
лют 11 12:03:08 server1 mariadbd[23770]: 2022-02-11 12:03:08 0 [Note] InnoDB: Buffer pool(s) load completed at 220211 12:03:08
 
лют 11 12:03:08 server1 systemd[1]: Started MariaDB 10.6.5 database server.
 
лют 11 12:03:12 server1 mariadbd[23770]: 2022-02-11 12:03:12 3 [Warning] IP address '45.12.24.101' could not be resolved: Name or service not known
 
lines 199-217/217 (END)

Comment by Taras [ 2022-02-11 ]

so what to do ?

Comment by Daniel Black [ 2022-02-11 ]

illuusio, systemd stop nginx is meant to be systemctl stop nginx.

Note how systemctl start mariadb.service above didn't output any "Failed to get properties:" messages.

so what to do ?

Stop using service, use systemctl.

Comment by Tuukka Pasanen [ 2022-02-11 ]

As danblack said start using systemctl start nginx not service nginx start and as you see MariaDB is running and I assume NGinX (It's only warning) also but as said start using systemctl to get rid of warning.

Comment by Taras [ 2022-02-11 ] 

root@server1 ~ # systemctl stop mariadb.service
 
root@server1 ~ # systemctl stop nginx
 
root@server1 ~ # systemctl start mariadb.service
 
root@server1 ~ # systemctl start nginx

hmm.. really! wow!
thank you!)))))

Comment by Daniel Black [ 2022-02-14 ]

Closing "Not a bug", but really its "not our bug", as its in the service implementation of Debian.

Generated at Thu Feb 08 09:55:01 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.