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

buildbot upgrade step and MySQL 8.0

Details

    • Task
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • N/A
    • Tests
    • None

    Description

      currently buildbot tests migration from MySQL 8.0 the usual way, like it does for all previous versions. But this process doesn't work for 8.0, so the test fails on Ubuntu 19.10 Eoan Ermine.

      Users are supposed dump the data and restore the dump in MariaDB. So buildbot should test this procedure instead.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          elenst Elena Stepanova added a comment - - edited

          Problems start with

          ERROR 1273 (HY000) at line 24: Unknown collation: 'utf8mb4_0900_ai_ci'

          Line 24

          		 
          CREATE DATABASE /*!32312 IF NOT EXISTS*/ `db` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;

          utf8mb4_0900_ai_ci appears to be a default collation in 8.0.18, at least I didn't set it.

          System tables probably don't have a chance to be salvaged, I won't attempt it yet. serg, if you think they should be, please let me know.

          elenst Elena Stepanova added a comment - - edited Problems start with ERROR 1273 (HY000) at line 24: Unknown collation: 'utf8mb4_0900_ai_ci' Line 24 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `db` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */; utf8mb4_0900_ai_ci appears to be a default collation in 8.0.18, at least I didn't set it. System tables probably don't have a chance to be salvaged, I won't attempt it yet. serg , if you think they should be, please let me know.
          elenst Elena Stepanova added a comment -

          https://github.com/MariaDB/mariadb.org-tools/commit/5c401d75122ab127c45f8967ecddd66015b49482

          elenst Elena Stepanova added a comment - https://github.com/MariaDB/mariadb.org-tools/commit/5c401d75122ab127c45f8967ecddd66015b49482

          People

            elenst Elena Stepanova
            serg Sergei Golubchik
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.