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

mariadb-hotcopy fails for sys

Details

    Description

      After upgrading from Debian 11 "bullseye" to Debian 12 "bookworm", that
      contains MariaDB version 10.11.4, when using mariadb-hotcopy I receive
      the error:

        DBD::MariaDB::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' `sys`.`host_summary` READ, `sys`.`host_summary_by_file_io` READ, `sys`.`host...' at line 1 at /usr/bin/mysqlhotcopy line 555.

      My patch for this isse, below.

      Maybe see also MDEV-30259 (with a previous fix that did not seem to make it into Debian).

      Cheers, Paul

      Paul Szabo psz@maths.usyd.edu.au www.maths.usyd.edu.au/u/psz
      School of Mathematics and Statistics University of Sydney Australia

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36084 mariadb-hotcopy requires '--port' set for operation since 10.11

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30259 mariadb-hotcopy fails for performance_schema

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          links to

          Web Link PR 2995

          Activity

            Ascending order - Click to sort in descending order
            psz Paul Szabo created issue -
            psz Paul Szabo made changes -
            Field Original Value New Value
            serg Sergei Golubchik made changes -
            Description After upgrading from Debian 11 "bullseye" to Debian 12 "bookworm", that
            contains MariaDB version 10.11.4, when using mariadb-hotcopy I receive
            the error:

              DBD::MariaDB::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' `sys`.`host_summary` READ, `sys`.`host_summary_by_file_io` READ, `sys`.`host...' at line 1 at /usr/bin/mysqlhotcopy line 555.

            My patch for this isse, below.

            Maybe see also https://jira.mariadb.org/browse/MDEV-30259 (with a
            previous fix that did not seem to make it into Debian).

            Cheers, Paul

            Paul Szabo psz@maths.usyd.edu.au www.maths.usyd.edu.au/u/psz
            School of Mathematics and Statistics University of Sydney Australia
            		After upgrading from Debian 11 "bullseye" to Debian 12 "bookworm", that
            contains MariaDB version 10.11.4, when using mariadb-hotcopy I receive
            the error:

              DBD::MariaDB::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' `sys`.`host_summary` READ, `sys`.`host_summary_by_file_io` READ, `sys`.`host...' at line 1 at /usr/bin/mysqlhotcopy line 555.

            My patch for this isse, below.

            Maybe see also MDEV-30259 (with a previous fix that did not seem to make it into Debian).

            Cheers, Paul

            Paul Szabo psz@maths.usyd.edu.au www.maths.usyd.edu.au/u/psz
            School of Mathematics and Statistics University of Sydney Australia
            serg Sergei Golubchik made changes -
            Assignee Anel Husakovic [ anel ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.11 [ 27614 ]
            anel Anel Husakovic made changes -
            Description After upgrading from Debian 11 "bullseye" to Debian 12 "bookworm", that
            contains MariaDB version 10.11.4, when using mariadb-hotcopy I receive
            the error:

              DBD::MariaDB::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' `sys`.`host_summary` READ, `sys`.`host_summary_by_file_io` READ, `sys`.`host...' at line 1 at /usr/bin/mysqlhotcopy line 555.

            My patch for this isse, below.

            Maybe see also MDEV-30259 (with a previous fix that did not seem to make it into Debian).

            Cheers, Paul

            Paul Szabo psz@maths.usyd.edu.au www.maths.usyd.edu.au/u/psz
            School of Mathematics and Statistics University of Sydney Australia
            		After upgrading from Debian 11 "bullseye" to Debian 12 "bookworm", that
            contains {{MariaDB version 10.11.4}}, when using {{mariadb-hotcopy}} I receive
            the error:
            {code:noformat}
              DBD::MariaDB::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' `sys`.`host_summary` READ, `sys`.`host_summary_by_file_io` READ, `sys`.`host...' at line 1 at /usr/bin/mysqlhotcopy line 555.
            {code}
            My patch for this isse, below.

            Maybe see also MDEV-30259 (with a previous fix that did not seem to make it into Debian).

            Cheers, Paul

            Paul Szabo psz@maths.usyd.edu.au www.maths.usyd.edu.au/u/psz
            School of Mathematics and Statistics University of Sydney Australia
            anel Anel Husakovic added a comment -

            Hi psz thank you for you contribution.
            I have created PR 2995 that addresses this MDEV and MDEV-30259.
            Please let me know you thoughts.
            Best regards,
            Anel

            anel Anel Husakovic added a comment - Hi psz thank you for you contribution. I have created PR 2995 that addresses this MDEV and MDEV-30259 . Please let me know you thoughts. Best regards, Anel
            anel Anel Husakovic made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            anel Anel Husakovic made changes -
            Assignee Anel Husakovic [ anel ] Daniel Black [ danblack ]
            Status Confirmed [ 10101 ] In Review [ 10002 ]
            anel Anel Husakovic made changes -
            psz Paul Szabo added a comment -

            Dear Anel,
            Thanks for the commits. However... (looking in "files changed"):

            • please keep the indent for the block of lines 290-293
            • lines 290 and 291 are "doubled up".
              (Also, I now signed the Contributor Licence Agreement.)
              Thanks, Paul
            psz Paul Szabo added a comment - Dear Anel, Thanks for the commits. However... (looking in "files changed"): please keep the indent for the block of lines 290-293 lines 290 and 291 are "doubled up". (Also, I now signed the Contributor Licence Agreement.) Thanks, Paul
            danblack Daniel Black made changes -
            Assignee Daniel Black [ danblack ] Anel Husakovic [ anel ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            anel Anel Husakovic added a comment -

            Dear Paul,
            I have updated indentation, hope you are now ok with change to be merged.
            Best regards,
            Anel

            anel Anel Husakovic added a comment - Dear Paul, I have updated indentation, hope you are now ok with change to be merged. Best regards, Anel
            anel Anel Husakovic made changes -
            Status Stalled [ 10000 ] In Testing [ 10301 ]
            psz Paul Szabo added a comment -

            Thanks, perfect! - Paul

            psz Paul Szabo added a comment - Thanks, perfect! - Paul
            danblack Daniel Black made changes -
            Fix Version/s 10.11.7 [ 29519 ]
            Fix Version/s 10.11 [ 27614 ]
            Resolution Fixed [ 1 ]
            Status In Testing [ 10301 ] Closed [ 6 ]
            JIraAutomate JiraAutomate made changes -
            Fix Version/s 11.0.5 [ 29520 ]
            Fix Version/s 11.1.4 [ 29024 ]
            Fix Version/s 11.2.3 [ 29521 ]
            elenst Elena Stepanova made changes -

            People

              anel Anel Husakovic
              psz Paul Szabo
              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.