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

MariaDB upgrade fails in postinst (DEB)

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • 10.0.25
    • N/A
    • Packaging
    • None
    • Debian Linux, Ubuntu Linux

    Description

      mariadb-server-10.0 package was failing with exit code 7.
      After trying to track down the exact cause using a number of manual debug techniques we found the error was happening when running "/bin/bash /usr/bin/mysql_install_db --rpm --user=mysql --disable-log-bin" in the postinst script. This was because variables in the my.cnf file were not recognised.

      The following varliables needed to be commented out for it to run:

      query_response_time_stats=ON
      server_audit_output_type=syslog
      server_audit_logging=ON
      server_audit_events=QUERY_DDL

      Uncommenting them after the upgrade seems to be causing no issues.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-8437 plugin variables conflict with bootstrap (debian mariadb-server-10.0.postinst)

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            arjen Arjen Lentz created issue -
            arjen Arjen Lentz added a comment -

            I should note we've had this fail on a number of versions, the upgrade to 10.0.25 being just the latest.

            arjen Arjen Lentz added a comment - I should note we've had this fail on a number of versions, the upgrade to 10.0.25 being just the latest.
            elenst Elena Stepanova added a comment -

            arjen,

            So, you have these plugins installed? Or are they loaded upon server startup?

            elenst Elena Stepanova added a comment - arjen , So, you have these plugins installed? Or are they loaded upon server startup?
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Labels need_feedback
            arjen Arjen Lentz added a comment -

            Hi Elena!
            They are in the mysql.plugins table.

            arjen Arjen Lentz added a comment - Hi Elena! They are in the mysql.plugins table.
            elenst Elena Stepanova made changes -
            Labels need_feedback
            elenst Elena Stepanova made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            elenst Elena Stepanova added a comment -

            This problem was solved in 10.1 in the scope of MDEV-8437.

            svoj, danblack, do you think it's possible and reasonable to backport the fix to 10.0?

            elenst Elena Stepanova added a comment - This problem was solved in 10.1 in the scope of MDEV-8437 . svoj , danblack , do you think it's possible and reasonable to backport the fix to 10.0?
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            Fix Version/s 10.0 [ 16000 ]
            Assignee Sergey Vojtovich [ svoj ]
            danblack Daniel Black added a comment -

            https://github.com/MariaDB/server/commit/60ad339 and https://github.com/MariaDB/server/commit/8e40f9b are the 10.1 commits.

            It looks like both concepts can be applied to 10.0 where the file location is debian/dist/

            {Ubuntu|Debian}

            /mariadb-server-10.0.postinst.

            danblack Daniel Black added a comment - https://github.com/MariaDB/server/commit/60ad339 and https://github.com/MariaDB/server/commit/8e40f9b are the 10.1 commits. It looks like both concepts can be applied to 10.0 where the file location is debian/dist/ {Ubuntu|Debian} /mariadb-server-10.0.postinst.
            Katiushyn Pavel Katiushyn made changes -
            Comment [ The issue was not solved in MDEV-8437.
            I had problem upgrading MariaDB 10.1.
            The problem is caused by "--bootstrap" option. With it mysqld do not load plugins and plugin parameters are not recognized. ]
            svoj Sergey Vojtovich added a comment -

            10.0 is EOL now, so it looks like there's nothing to fix. Should be fixed in 10.1+.

            svoj Sergey Vojtovich added a comment - 10.0 is EOL now, so it looks like there's nothing to fix. Should be fixed in 10.1+.
            svoj Sergey Vojtovich made changes -
            Fix Version/s N/A [ 14700 ]
            Fix Version/s 10.0 [ 16000 ]
            Resolution Fixed [ 1 ]
            Status Confirmed [ 10101 ] Closed [ 6 ]
            svoj Sergey Vojtovich made changes -
            Resolution Fixed [ 1 ]
            Status Closed [ 6 ] Stalled [ 10000 ]
            svoj Sergey Vojtovich made changes -
            Resolution Won't Fix [ 2 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 75628 ] MariaDB v4 [ 150413 ]

            People

              svoj Sergey Vojtovich
              arjen Arjen Lentz
              Votes:
              1 Vote for this issue
              Watchers:
              6 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.