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

debian-start spams the syslog after an upgrade

Details

    Description

      After upgrading MariaDB 10.0 using the MariaDB repository (even a minor upgrade), debian-start.sh executes mysql_upgrade and sends its output to the syslog.

      The default behavior of mysql_upgrade is to output "database.table OK" for each tables that didnt require an upgrade.
      The server i did upgrade have more than 200000 tables, which means that more than 200000 log lines are added to the syslog that does just states that nothing has been done.

      Suggested fix : Add '--silent' to the call of "mysql_upgrade" which should only log tables that have been upgraded.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12576 Upgrade MariaDB 10.0 from Distro to 10.1 from MariaDB Repo does not happen

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            jb-boin Jean Weisbuch created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Status Open [ 1 ] Confirmed [ 10101 ]
            elenst Elena Stepanova made changes -
            Fix Version/s 10.0 [ 16000 ]
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.2 [ 14601 ]
            Affects Version/s 10.0 [ 16000 ]
            elenst Elena Stepanova made changes -
            Component/s Scripts & Clients [ 11002 ]
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            Assignee Ondřej Surý [ oerdnj ]
            danblack Daniel Black made changes -
            Labels beginner-friendly
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.0 [ 16000 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.1 [ 16100 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 79995 ] MariaDB v4 [ 143930 ]
            cvicentiu Vicențiu Ciorbaru made changes -
            Assignee Ondřej Surý [ oerdnj ] Tuukka Pasanen [ JIRAUSER49166 ]
            illuusio Tuukka Pasanen added a comment -

            Is there any down sides that you add '--silent' to upgrade? otto Can you come any downside that user can't see huge logs?

            illuusio Tuukka Pasanen added a comment - Is there any down sides that you add '--silent' to upgrade? otto Can you come any downside that user can't see huge logs?
            otto Otto Kekäläinen added a comment -

            I don't know. Do we have a normal output and --silent output examples to
            view and compare to see what they reveal/hide?

            otto Otto Kekäläinen added a comment - I don't know. Do we have a normal output and --silent output examples to view and compare to see what they reveal/hide?
            illuusio Tuukka Pasanen added a comment -

            Ok I need to test what test suppress

            illuusio Tuukka Pasanen added a comment - Ok I need to test what test suppress
            illuusio Tuukka Pasanen made changes -
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.2 [ 14601 ]
            illuusio Tuukka Pasanen made changes -
            Labels beginner-friendly SySV beginner-friendly packaging
            illuusio Tuukka Pasanen added a comment -

            Testing this on systemd system is not easy but this should not make any harm

            illuusio Tuukka Pasanen added a comment - Testing this on systemd system is not easy but this should not make any harm
            illuusio Tuukka Pasanen made changes -
            Status Confirmed [ 10101 ] In Review [ 10002 ]
            illuusio Tuukka Pasanen made changes -
            Affects Version/s 10.3 [ 22126 ]
            Affects Version/s 10.0.30 [ 22313 ]
            illuusio Tuukka Pasanen made changes -
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.7 [ 24805 ]
            Fix Version/s 10.8 [ 26121 ]
            Fix Version/s 10.9 [ 26905 ]
            illuusio Tuukka Pasanen added a comment -

            danblack could you take look on PR.

            illuusio Tuukka Pasanen added a comment - danblack could you take look on PR.
            danblack Daniel Black made changes -
            issue.field.resolutiondate 2022-05-05 00:22:12.0 2022-05-05 00:22:12.675
            danblack Daniel Black made changes -
            Fix Version/s 10.3.35 [ 27512 ]
            Fix Version/s 10.4.25 [ 27510 ]
            Fix Version/s 10.5.16 [ 27508 ]
            Fix Version/s 10.6.8 [ 27506 ]
            Fix Version/s 10.7.4 [ 27504 ]
            Fix Version/s 10.8.3 [ 27502 ]
            Fix Version/s 10.9.1 [ 27114 ]
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.7 [ 24805 ]
            Fix Version/s 10.8 [ 26121 ]
            Fix Version/s 10.9 [ 26905 ]
            Resolution Fixed [ 1 ]
            Status In Review [ 10002 ] Closed [ 6 ]

            People

              illuusio Tuukka Pasanen
              jb-boin Jean Weisbuch
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.