Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-27394

mariadb systemd socket activation - log messages inaccurage on abstract sockets

    XMLWordPrintable

Details

    Description

      $ systemctl cat mariadb-extra@.socket
      # /etc/systemd/system/mariadb-extra@.socket
       
      [Unit]
       
      Description=MariaDB 10.8.0 database server (socket activation extra port multi-instance %I)
      Documentation=man:mariadbd(8)
      Documentation=https://mariadb.com/kb/en/library/systemd/
       
      [Socket]
       
      Service=mariadb@%i.service
       
      # An "extra" as a descriptor name that means treat these ListenStreams as
      # the same as an extra_port.
      # Ref: https://mariadb.com/kb/en/thread-pool-system-status-variables/#extra_port
       
      FileDescriptorName=extra
       
      ListenStream=@mariadb-extra-%I
      ListenStream=/tmp/mysql.sock-extra-%I
       
       
      # /etc/systemd/system/mariadb-extra@.socket.d/override.conf
      # Requires SELinux permission:
      # allow init_t user_home_t:sock_file { create setattr write };
       
      [Socket]
      SocketUser=%I
      SocketGroup=%I
      SocketMode=770
       
      ProtectHome=false
      ListenStream=
      ListenStream=@mariadb-extra-%I
      ListenStream=/home/%I/mariadb-extra.sock
      

      The nature of abstract sockets not being null terminated results in:

      Dec 31 17:35:06 localhost.localdomain mariadbd[786561]: 2021-12-31 17:35:06 0 [Note] Using systemd activated unix socket /home/dan/mariadb-extra.sock (extra)
      Dec 31 17:35:06 localhost.localdomain mariadbd[786561]: 2021-12-31 17:35:06 0 [Note] Using systemd activated unix socket @mariadb-extra-danextra.sock (extra)
      Dec 31 17:35:06 localhost.localdomain mariadbd[786561]: 2021-12-31 17:35:06 0 [Note] InnoDB: Buffer pool(s) load completed at 211231 17:35:06
      Dec 31 17:35:06 localhost.localdomain mariadbd[786561]: 2021-12-31 17:35:06 0 [Note] Using systemd activated unix socket /home/dan/mariadb.sock
      Dec 31 17:35:06 localhost.localdomain mariadbd[786561]: 2021-12-31 17:35:06 0 [Note] Using systemd activated unix socket @mariadb-danriadb.sock
      

      Attachments

        Activity

          People

            danblack Daniel Black
            danblack Daniel Black
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.