About update version 5.7 to 8 Mysql

Question

After start the update version, I receive this message

2023-09-05T18:03:49.563368Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release.
2023-09-05T18:03:49.563439Z 0 [Warning] [MY-011068] [Server] The syntax 'log_slave_updates' is deprecated and will be removed in a future release. Please use log_replica_updates instead.
2023-09-05T18:03:49.563450Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2023-09-05T18:03:49.563457Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2023-09-05T18:03:49.563511Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-file' is deprecated and will be removed in a future release.
2023-09-05T18:03:49.563515Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2023-09-05T18:03:49.563542Z 0 [Warning] [MY-011068] [Server] The syntax 'skip_slave_start' is deprecated and will be removed in a future release. Please use skip_replica_start instead.
2023-09-05T18:03:49.563551Z 0 [Warning] [MY-011068] [Server] The syntax 'slave_exec_mode' is deprecated and will be removed in a future release. Please use replica_exec_mode instead.
2023-09-05T18:03:49.563559Z 0 [Warning] [MY-011068] [Server] The syntax 'slave_load_tmpdir' is deprecated and will be removed in a future release. Please use replica_load_tmpdir instead.
2023-09-05T18:03:49.563765Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-09-05T18:03:49.563784Z 0 [System] [MY-010116] [Server] /rdsdbbin/mysql/bin/mysqld (mysqld 8.0.34) starting as process 807
2023-09-05T18:03:49.566411Z 0 [Warning] [MY-010161] [Server] You need to use --log-bin to make --log-replica-updates work.
2023-09-05T18:03:49.566419Z 0 [Warning] [MY-010161] [Server] You need to use --log-bin to make --binlog-format work.
2023-09-05T18:03:49.568174Z 0 [Warning] [MY-013869] [InnoDB] Ignored deprecated configuration parameter innodb_log_file_size. Used innodb_redo_log_capacity instead.
2023-09-05T18:03:49.568196Z 0 [Warning] [MY-013870] [InnoDB] Ignored deprecated configuration parameter innodb_log_files_in_group. Used innodb_redo_log_capacity instead.
2023-09-05T18:03:49.569632Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2023-09-05T18:03:49.569661Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-09-05T18:03:49.575438Z 1 [Warning] [MY-012191] [InnoDB] Scan path '/rdsdbdata/db/innodb' is ignored because it is a sub-directory of '/rdsdbdata/db/
2023-09-05T18:03:50.670042Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-09-05T18:03:58.441646Z 2 [ERROR] [MY-013140] [Server] Failed to update triggers dictionary object.
2023-09-05T18:04:08.055362Z 2 [Warning] [MY-010772] [Server] db.opt file not found for innodb database. Using default Character set.
2023-09-05T18:04:13.160435Z 0 [ERROR] [MY-010022] [Server] Failed to Populate DD tables.
2023-09-05T18:04:13.160468Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-09-05T18:04:15.647327Z 0 [System] [MY-010910] [Server] /rdsdbbin/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.34)  Source distribution.

I use RDS Mysql 5.7

Anyone have some ideas about this ?

Answer

hunnn I got the idea man, but I dont have any triggers to conflit with this ......
and your script don't bring information about some object.

Answer

![Enter image description here](/media/postImages/original/IMC6KI_RlqQICyw-QigIkzmg)

Answer

Hi,

You definitely need to go through all the warnings, but there is only one error you have so far: `Failed to update triggers dictionary object. `

Here is an example of how to find the problem with `mysql` system database. You need to check your triggers as well. I do not have any triggers to create a query and test. I hope you will be able to find out yourself.

There must be no tables in the MySQL 5.7 `mysql` system database that have the same name as a table used by the MySQL 8.0 data dictionary. To identify tables with those names, execute this query:

```
mysql> SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE LOWER(TABLE_SCHEMA) = 'mysql' and LOWER(TABLE_NAME) IN ('catalogs', 'character_sets', 'collations', 'column_type_elements', 'columns', 'events', 'foreign_key_column_usage', 'foreign_keys', 'index_column_usage', 'index_partitions', 'index_stats', 'indexes', 'parameter_type_elements', 'parameters', 'routines', 'schemata', 'st_spatial_reference_systems', 'table_partition_values', 'table_partitions', 'table_stats', 'tables', 'tablespace_files', 'tablespaces', 'triggers', 'version', 'view_routine_usage', 'view_table_usage');
```

About update version 5.7 to 8 Mysql

Relevant content