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

mariadb-hotcopy requires '--port' set for operation since 10.11

Details

    Description

      As I described here on Zulip,
      I keep hitting this problem with MariaDB 10.11 on Fedora / RHEL.

      mysql <<< "CREATE DATABASE db1; USE db1; CREATE TABLE test_table1 (f1 INT, f2 INT) ENGINE=MyISAM; INSERT INTO test_table1 VALUES (111, 222);"
      		 
       
      		 
      mysql -D db1 -e "SELECT * FROM test_table1;"
      		 
       
      		 
      mysql -D brand_new_db1
      		 
       
      		 
      mysqlhotcopy db1 brand_new_db1

      returns:

      ERROR 1049 (42000): Unknown database 'brand_new_db1'
      		 
      Argument "" isn't numeric in subroutine entry at /usr/lib64/perl5/vendor_perl/DBD/MariaDB.pm line 140.
      		 
      DBI connect(';host=;port=;mariadb_read_default_group=mysqlhotcopy','',...) failed: Connection error: port is not valid number at /usr/bin/mysqlhotcopy line 222.

      It only works in MariaDB 10.11 when --port is specified. (but without --host, which contradicts this)
      In MariaDB 10.5 it works without the need to specify the port.

      Sergei Golubchik said in the Zulip coversation it is likely a bug, not an expected change, so I'm reporting it as such.

      Attachments

        Issue Links

          is caused by

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

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

          Activity

            Transition Time In Source Status Execution Times
            Elena Stepanova made transition -
            Open Confirmed
            		31m 4s 1
            Sergei Golubchik made transition -
            Confirmed In Progress
            		23h 18m 1
            Sergei Golubchik made transition -
            In Progress In Testing
            		3s 1
            Sergei Golubchik made transition -
            In Testing Closed
            		45d 2h 10m 1

            People

              serg Sergei Golubchik
              mschorm Michal Schorm
              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.