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

SST fails when donor node has problem with logging file descriptor

Details

    Description

      Hi there,

      we are running a MariaDB Galera Cluster on Debian Jessie and we are sometimes experiencing the issue analyzed here: https://serverfault.com/a/715940/115361

      I suspect it happens when systemd-journald is being restarted while everything else is running.

      The immediately visible hint to that is when systemctl status mariadb.service on a node does not show any recent logging output anymore (although there should be some).
      mysqld is still running normally, accepting queries and replicating to the other nodes, but an SST that tries to use such a defective node as donor will always fail with Will never receive state. Need to abort.

      Restarting mariadb.service on the defective donor node fixes the issue until the logger process dies the next time.

      mariadb-service-convert created the dropin configuration file to make mysqld log directly to syslog:

      StandardOutput=syslog
      StandardError=syslog
      SyslogFacility=daemon
      SyslogLevel=err
      SyslogIdentifier=mysqld

      I'd be happy to assist with more information to solve this issue soon.

      Attachments

        Activity

          schlarbm Moritz Schlarb created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Assignee Andrii Nikitin [ anikitin ]
          anikitin Andrii Nikitin (Inactive) made changes -
          Status Open [ 1 ] Confirmed [ 10101 ]
          anikitin Andrii Nikitin (Inactive) made changes -
          Fix Version/s N/A [ 14700 ]
          Resolution Won't Fix [ 2 ]
          Status Confirmed [ 10101 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 82065 ] MariaDB v4 [ 152611 ]

          People

            anikitin Andrii Nikitin (Inactive)
            schlarbm Moritz Schlarb
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.