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

Tool mysqldump does not work, checks for histograms.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.3.7
    • N/A
    • Scripts & Clients
    • None
    • Windows

    Description

      1. Create a table schema 'test' and put something in it, e.g. a table called 'test' with one column.
      2. The following command should dump this table schema: mysqldump -u root -ppassword -P 3310 test > "<path to dump location>"
      3. Output:
      mysqldump: [Warning] Using a password on the command line interface can be insecure.
      mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'test' AND TABLE_NAME = 'test';': Unknown table 'column_statistics' in information_schema (1109)

      I did not experience this issue in MariaDB versions 10.1 or lower. It exists in neither MySQL 5.x versions nor in 8.x versions. However I came across this MySQL report, which might be related: https://bugs.mysql.com/bug.php?id=89825.

      The workaround to this problem is to add the --column-statistics=0 parameter to the command but I figure that should be the default.

      Attachments

        Activity

          People

            Unassigned Unassigned
            user2180613 Remy Fox
            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.