MySQL Forums
Forum List  »  Chinese

5.6.21 upgrade to 5.7.30 error
Posted by: xiaobo shi
Date: June 03, 2020 06:09AM

200603 18:17:48 mysqld_safe mysqld from pid file /data/mysql/data/homeos-hr-gate3.pid ended
2020-06-03T11:02:51.452977Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-06-03T11:02:51.453171Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2020-06-03T11:02:51.453211Z 0 [Note] /mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysqld (mysqld 5.7.30-log) starting as process 21397 ...
2020-06-03T11:02:51.457508Z 0 [ERROR] Error message file '/usr/local/mysql/share/english/errmsg.sys' had only 885 error messages,
but it should contain at least 1120 error messages.
Check that the above file is the right version for this program!
2020-06-03T11:02:51.464112Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-06-03T11:02:51.464136Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-06-03T11:02:51.464140Z 0 [Note] InnoDB: Uses event mutexes
2020-06-03T11:02:51.464143Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2020-06-03T11:02:51.464146Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-03T11:02:51.464149Z 0 [Note] InnoDB: Using Linux native AIO
2020-06-03T11:02:51.464699Z 0 [Note] InnoDB: Number of pools: 1
2020-06-03T11:02:51.464787Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-06-03T11:02:51.468125Z 0 [Note] InnoDB: Initializing buffer pool, total size = 10G, instances = 8, chunk size = 128M
2020-06-03T11:02:52.043156Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-03T11:02:52.118586Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-06-03T11:02:52.129532Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-06-03T11:02:52.385987Z 0 [Warning] InnoDB: Upgrading redo log: 3*81920 pages, LSN=82423732781
2020-06-03T11:02:52.498602Z 0 [Warning] InnoDB: Starting to delete and rewrite log files.
2020-06-03T11:02:52.606387Z 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 1280 MB
2020-06-03T11:02:52.607013Z 0 [Note] InnoDB: Progress in MB:
100 200 300 400 500 600 700 800 900 1000 1100 1200
2020-06-03T11:02:54.722965Z 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 1280 MB
2020-06-03T11:02:54.723102Z 0 [Note] InnoDB: Progress in MB:
100 200 300 400 500 600 700 800 900 1000 1100 1200
2020-06-03T11:02:57.600933Z 0 [Note] InnoDB: Setting log file ./ib_logfile2 size to 1280 MB
2020-06-03T11:02:57.601094Z 0 [Note] InnoDB: Progress in MB:
100 200 300 400 500 600 700 800 900 1000 1100 1200
2020-06-03T11:02:59.712909Z 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2020-06-03T11:02:59.712978Z 0 [Warning] InnoDB: New log files created, LSN=82423732781
2020-06-03T11:02:59.728517Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-03T11:02:59.728587Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-03T11:02:59.766475Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-06-03T11:02:59.768189Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-06-03T11:02:59.768217Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-06-03T11:02:59.768575Z 0 [Note] InnoDB: Creating sys_virtual system tables.
2020-06-03T11:02:59.774354Z 0 [Note] InnoDB: sys_virtual table created
2020-06-03T11:02:59.775323Z 0 [Note] InnoDB: 5.7.30 started; log sequence number 0
2020-06-03T11:02:59.775388Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7657ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2020-06-03T11:02:59.775851Z 0 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/data/ib_buffer_pool
2020-06-03T11:02:59.776016Z 0 [ERROR] InnoDB: Cannot open '/data/mysql/data/ib_buffer_pool' for reading: No such file or directory
2020-06-03T11:02:59.776420Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-06-03T11:02:59.786544Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2020-06-03T11:03:00.640208Z 0 [Note] Auto generated SSL certificates are placed in data directory.
2020-06-03T11:03:00.640784Z 0 [Warning] CA certificate ca.pem is self signed.
2020-06-03T11:03:00.839948Z 0 [Note] Auto generated RSA key files are placed in data directory.
2020-06-03T11:03:00.842690Z 0 [Warning] Failed to open optimizer cost constant tables

2020-06-03T11:03:00.850359Z 0 [Warning] System table 'time_zone_leap_second' is expected to be transactional.
2020-06-03T11:03:00.850371Z 0 [Warning] System table 'time_zone_name' is expected to be transactional.
2020-06-03T11:03:00.850373Z 0 [Warning] System table 'time_zone' is expected to be transactional.
2020-06-03T11:03:00.850375Z 0 [Warning] System table 'time_zone_transition_type' is expected to be transactional.
2020-06-03T11:03:00.850377Z 0 [Warning] System table 'time_zone_transition' is expected to be transactional.
2020-06-03T11:03:00.854778Z 0 [Warning] System table 'servers' is expected to be transactional.
2020-06-03T11:03:00.859127Z 0 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2020-06-03T11:03:00.859144Z 0 [ERROR] Error in checking mysql.slave_master_info repository info type of TABLE.
2020-06-03T11:03:00.859149Z 0 [ERROR] Error creating master info: Error checking repositories.
2020-06-03T11:03:00.859151Z 0 [ERROR] Slave: Failed to initialize the master info structure for channel ''; its record may still be present in 'mysql.slave_master_info' table, consider dele
ting it.
2020-06-03T11:03:00.859154Z 0 [ERROR] Failed to create or recover replication info repositories.
2020-06-03T11:03:00.859156Z 0 [Note] Some of the channels are not created/initialized properly. Check for additional messages above. You will not be able to start replication on those chann
els until the issue is resolved and the server restarted.
2020-06-03T11:03:00.860400Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'NESTING_EVENT_TYPE' at position 15 to have type enum('TRANSACTI
ON','STATEMENT','STAGE','WAIT', found type enum('STATEMENT','STAGE','WAIT').
2020-06-03T11:03:00.860954Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'NESTING_EVENT_TYPE' at position 15 to have type enum('TRANSACTI
ON','STATEMENT','STAGE','WAIT', found type enum('STATEMENT','STAGE','WAIT').
2020-06-03T11:03:00.861535Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'NESTING_EVENT_TYPE' at position 15 to have type enum('TRAN
SACTION','STATEMENT','STAGE','WAIT', found type enum('STATEMENT','STAGE','WAIT').
2020-06-03T11:03:00.863391Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_user_by_event_name: expected column 'USER' at position 0 to have type char(32)
, found type char(16).
2020-06-03T11:03:00.863792Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_account_by_event_name: expected column 'USER' at position 0 to have type char(
32), found type char(16).
2020-06-03T11:03:00.870602Z 0 [ERROR]
2020-06-03T11:03:00.871907Z 0 [ERROR] Incorrect definition of table performance_schema.setup_objects: expected column 'OBJECT_TYPE' at position 0 to have type enum('EVENT','FUNCTION','PROCE
DURE','TABLE','TRIGGER', found type enum('TABLE').
2020-06-03T11:03:00.877098Z 0 [ERROR]
2020-06-03T11:03:00.877371Z 0 [ERROR]
2020-06-03T11:03:00.877608Z 0 [ERROR]
2020-06-03T11:03:00.877892Z 0 [ERROR]
2020-06-03T11:03:00.878222Z 0 [ERROR]
2020-06-03T11:03:00.878720Z 0 [ERROR] Incorrect definition of table performance_schema.events_stages_summary_by_account_by_event_name: expected column 'USER' at position 0 to have type char
(32), found type char(16).
2020-06-03T11:03:00.878995Z 0 [ERROR] Incorrect definition of table performance_schema.events_stages_summary_by_user_by_event_name: expected column 'USER' at position 0 to have type char(32
), found type char(16).
2020-06-03T11:03:00.879773Z 0 [ERROR]
2020-06-03T11:03:00.880095Z 0 [ERROR]
2020-06-03T11:03:00.880405Z 0 [ERROR]
2020-06-03T11:03:00.880950Z 0 [ERROR] Incorrect definition of table performance_schema.events_statements_summary_by_account_by_event_name: expected column 'USER' at position 0 to have type
char(32), found type char(16).
2020-06-03T11:03:00.881234Z 0 [ERROR] Incorrect definition of table performance_schema.events_statements_summary_by_user_by_event_name: expected column 'USER' at position 0 to have type cha
r(32), found type char(16).

Options: ReplyQuote


Subject
Views
Written By
Posted
5.6.21 upgrade to 5.7.30 error
481
June 03, 2020 06:09AM


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.