Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-4966

mariadb-dump gets an error dumping schemas

    XMLWordPrintable

Details

    Description

      If I run the mariadb-dump command via MaxScale I get an error on all Schemas which are NOT located on the first shard:

      mariadb-dump --user=app --password=secret --host=10.153.125.219 --port=3306 --single-transaction customer_0010 > /tmp/customer_0010.sql
      mariadb-dump --user=app --password=secret --host=10.153.125.219 --port=3306 --single-transaction customer_0020 > /tmp/customer_0020.sql
      Error: Couldn't read status information for table address ()
      Error: Couldn't read status information for table sales ()
      mariadb-dump --user=app --password=secret --host=10.153.125.219 --port=3306 --single-transaction customer_0030 > /tmp/customer_0030.sql
      Error: Couldn't read status information for table address ()
      Error: Couldn't read status information for table sales ()

      mariadb-dump --user=app --password=secret --host=10.153.125.219 --port=3306 --single-transaction --databases customer_0011 > /tmp/customer_0011.sql
      mariadb-dump --user=app --password=secret --host=10.153.125.219 --port=3306 --single-transaction --databases customer_0021 > /tmp/customer_0021.sql
      Error: Couldn't read status information for table address ()
      Error: Couldn't read status information for table sales ()
      mariadb-dump --user=app --password=secret --host=10.153.125.219 --port=3306 --single-transaction --databases customer_0030 > /tmp/customer_0030.sql
      Error: Couldn't read status information for table address ()
      Error: Couldn't read status information for table sales ()

      customer_001? are on the first shard customer_002? on the second and so on...

      I did not find anything in the docu prohibiting this...

      Attachments

        Issue Links

          Activity

            People

              markus makela markus makela
              oli Oli Sennhauser
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.