[MDEV-33187] mariadb-hotcopy fails for sys Created: 2024-01-05  Updated: 2024-01-13  Resolved: 2024-01-13

Status: Closed
Project: MariaDB Server
Component/s: Scripts & Clients
Affects Version/s: 10.11.4
Fix Version/s: 10.11.7, 11.0.5, 11.1.4, 11.2.3

Type: Bug Priority: Minor
Reporter: Paul Szabo Assignee: Anel Husakovic
Resolution: Fixed Votes: 0
Labels: contribution
Environment:

Debian 12 "bookworm"

Attachments: File hotcopy.patch    
Issue Links:
Relates
relates to MDEV-30259 mariadb-hotcopy fails for performance... Closed

 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

 Comments   
Comment by Anel Husakovic [ 2024-01-11 ]

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

Comment by Paul Szabo [ 2024-01-11 ]

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
Comment by Anel Husakovic [ 2024-01-12 ]

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

Comment by Paul Szabo [ 2024-01-12 ]

Thanks, perfect! - Paul

Generated at Thu Feb 08 10:37:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.