[MDEV-21179] buildbot upgrade step and MySQL 8.0 Created: 2019-11-29  Updated: 2020-01-23

Status: Stalled
Project: MariaDB Server
Component/s: Tests
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Sergei Golubchik Assignee: Elena Stepanova
Resolution: Unresolved Votes: 0
Labels: 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.

 Comments   
Comment by Elena Stepanova [ 2019-12-01 ]

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.

Comment by Elena Stepanova [ 2019-12-02 ]

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

Generated at Thu Feb 08 09:05:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.