MySQL Forums
Forum List  »  General

Error upgrading from 5.7.28 to 8.0.17
Posted by: James Reason
Date: April 23, 2020 02:47AM

Hi,

I am trying to upgrade my AWS RDS Instance from 5.7.28 to 8.0.17 but the upgrade fails.


Here is the error-log:


2020-04-23T07:23:56.676245Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2020-04-23T07:23:56.676269Z 0 [System] [MY-010116] [Server] /rdsdbbin/mysql/bin/mysqld (mysqld 8.0.17) starting as process 2716
2020-04-23T07:23:56.681376Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
100
100
2020-04-23T07:23:59.300448Z 2 [Warning] [MY-010772] [Server] db.opt file not found for innodb database. Using default Character set.
2020-04-23T07:24:00.631570Z 2 [ERROR] [MY-012064] [InnoDB] Column datatype mismatch for col: gps
2020-04-23T07:24:00.631578Z 2 [ERROR] [MY-012070] [InnoDB] Column gps for table: `pcn`.`locations` mismatches with InnoDB Dictionary
2020-04-23T07:24:00.631608Z 2 [ERROR] [MY-010767] [Server] Error in fixing SE data for pcn.locations
2020-04-23T07:24:00.730888Z 2 [ERROR] [MY-012064] [InnoDB] Column datatype mismatch for col: gps
2020-04-23T07:24:00.730896Z 2 [ERROR] [MY-012070] [InnoDB] Column gps for table: `pcn`.`pcn_photos` mismatches with InnoDB Dictionary
2020-04-23T07:24:00.730909Z 2 [ERROR] [MY-010767] [Server] Error in fixing SE data for pcn.pcn_photos
2020-04-23T07:24:01.262798Z 2 [ERROR] [MY-012064] [InnoDB] Column datatype mismatch for col: gps
2020-04-23T07:24:01.262805Z 2 [ERROR] [MY-012070] [InnoDB] Column gps for table: `pcn_staging`.`locations` mismatches with InnoDB Dictionary
2020-04-23T07:24:01.262822Z 2 [ERROR] [MY-010767] [Server] Error in fixing SE data for pcn_staging.locations
2020-04-23T07:24:01.365961Z 2 [ERROR] [MY-012064] [InnoDB] Column datatype mismatch for col: gps
2020-04-23T07:24:01.365969Z 2 [ERROR] [MY-012070] [InnoDB] Column gps for table: `pcn_staging`.`pcn_photos` mismatches with InnoDB Dictionary
2020-04-23T07:24:01.365986Z 2 [ERROR] [MY-010767] [Server] Error in fixing SE data for pcn_staging.pcn_photos
2020-04-23T07:24:05.721550Z 2 [Warning] [MY-010772] [Server] db.opt file not found for tmp database. Using default Character set.
2020-04-23T07:24:05.762390Z 2 [Warning] [MY-013235] [Server] Error in parsing (IGNORED) Routine 'mysql'.'flush_rewrite_rules' during upgrade. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'QUERY CACHE;
IF NOT message_text IS NULL THEN
SIGNAL SQLSTATE '45000' SET ' at line 6
2020-04-23T07:24:05.762396Z 2 [Warning] [MY-010778] [Server] Parsing 'mysql.flush_rewrite_rules' routine body failed. Creating routine without parsing routine body
2020-04-23T07:24:05.766176Z 2 [Warning] [MY-010778] [Server] Parsing 'mysql.rds_collect_global_status_history' routine body failed. Creating routine without parsing routine body
2020-04-23T07:24:05.815768Z 2 [Warning] [MY-010778] [Server] Parsing 'mysql.rds_set_gsh_collector' routine body failed. Creating routine without parsing routine body
2020-04-23T07:24:05.818649Z 2 [Warning] [MY-010778] [Server] Parsing 'mysql.rds_set_gsh_rotation' routine body failed. Creating routine without parsing routine body
2020-04-23T07:24:06.223724Z 0 [ERROR] [MY-010022] [Server] Failed to Populate DD tables.
2020-04-23T07:24:06.223925Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-04-23T07:24:07.879537Z 0 [System] [MY-010910] [Server] /rdsdbbin/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.17) Source distribution.


The columns in question: gps currently all have the same data type: point



The Upgrade Checker displays a couple of warning on the following:
2) Usage of db objects with names conflicting with new reserved keywords
3) Usage of utf8mb3 charset

Errors: 0
Warnings: 1
Database Objects Affected: 11

However, none of the are anything to do with the tables in the error log?
Does anyone have any suggestions?

Thanks

Options: ReplyQuote


Subject
Written By
Posted
Error upgrading from 5.7.28 to 8.0.17
April 23, 2020 02:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.