mysql5.7.16升级二进制文件至5.7.44后启动数据库,error.log提示
处理:[root@uat-rds-1 bin]# ./mysql_upgrade --host='127.0.0.1' --port=3306 --user='root' --password="************"
2025-06-18T11:20:10.069264Z mysqld_safe Starting mysqld daemon with databases from /data/mysql/data
2025-06-18T11:20:10.283015Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2025-06-18T11:20:10.283138Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2025-06-18T11:20:10.283143Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2025-06-18T11:20:10.283176Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2025-06-18T11:20:10.283228Z 0 [Note] /data/mysql/install/bin/mysqld (mysqld 5.7.44-log) starting as process 11026 ...
2025-06-18T11:20:10.283277Z 0 [ERROR] Can't find error-message file '/data/mysql/share/mysql/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2025-06-18T11:20:10.320416Z 0 [Note] InnoDB: PUNCH HOLE support available
2025-06-18T11:20:10.320504Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2025-06-18T11:20:10.320510Z 0 [Note] InnoDB: Uses event mutexes
2025-06-18T11:20:10.320515Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2025-06-18T11:20:10.320521Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2025-06-18T11:20:10.320527Z 0 [Note] InnoDB: Using Linux native AIO
2025-06-18T11:20:10.321312Z 0 [Note] InnoDB: Number of pools: 1
2025-06-18T11:20:10.321501Z 0 [Note] InnoDB: Using CPU crc32 instructions
2025-06-18T11:20:10.323737Z 0 [Note] InnoDB: Initializing buffer pool, total size = 32G, instances = 8, chunk size = 128M
2025-06-18T11:20:12.804753Z 0 [Note] InnoDB: Completed initialization of buffer pool
2025-06-18T11:20:13.404016Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2025-06-18T11:20:13.417404Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2025-06-18T11:20:14.908207Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2025-06-18T11:20:14.908392Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2025-06-18T11:20:14.953007Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2025-06-18T11:20:14.954379Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2025-06-18T11:20:14.954427Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2025-06-18T11:20:14.956004Z 0 [Note] InnoDB: 5.7.44 started; log sequence number 940084219326
2025-06-18T11:20:14.957402Z 0 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/data/ib_buffer_pool
2025-06-18T11:20:14.960436Z 0 [Note] Plugin 'FEDERATED' is disabled.
2025-06-18T11:20:14.982034Z 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2025-06-18T11:20:14.982144Z 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2025-06-18T11:20:16.625468Z 0 [Note] InnoDB: Buffer pool(s) load completed at 250618 19:20:16
2025-06-18T11:20:17.113353Z 0 [Note] Auto generated SSL certificates are placed in data directory.
2025-06-18T11:20:17.113437Z 0 [Warning]
2025-06-18T11:20:17.113441Z 0 [Warning]
2025-06-18T11:20:17.117966Z 0 [Warning] CA certificate ca.pem is self signed.
2025-06-18T11:20:17.987665Z 0 [Note] Auto generated RSA key files are placed in data directory.
2025-06-18T11:20:17.990493Z 0 [Note] Server hostname (bind-address): '*'; port: 30001
2025-06-18T11:20:17.990589Z 0 [Note] IPv6 is available.
2025-06-18T11:20:17.990631Z 0 [Note] - '::' resolves to '::';
2025-06-18T11:20:17.990670Z 0 [Note] Server socket created on IP: '::'.
2025-06-18T11:20:18.006757Z 0 [Warning]
2025-06-18T11:20:18.007347Z 0 [Note] Event Scheduler: Loaded 0 events
2025-06-18T11:20:18.007795Z 0 [Note]
2025-06-18T11:20:22.143130Z 15 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2025-06-18T11:20:22.143252Z 15 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2025-06-18T11:20:22.163027Z 15 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2025-06-18T11:20:22.163090Z 15 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2
查看版本:
mysql> select version();
+------------+
| version() |
+------------+
| 5.7.44-log |
+------------+
1 row in set (0.00 sec)
执行升级
[root@uat-rds-1 bin]# ./mysql_upgrade --host='127.0.0.1' --port=3306 --user='root' --password="************"
。。。
yc.upload_inventory_adjust_header OK
yc.upload_location_inventory_his OK
yc.upload_receipt_container OK
yc.upload_receipt_detail OK
yc.upload_receipt_header OK
yc.upload_shipment_detail OK
yc.upload_shipment_header OK
yc.upload_shipping_container_detail OK
yc.upload_shipping_container_header OK
yc.user_action OK
yc.user_print OK
yc.user_settings OK
yc.validity_conversion OK
yc.validity_limit OK
yc.vendor OK
yc.warehouse OK
yc.warehouse_transfer_detail OK
yc.warehouse_transfer_header OK
yc.warehouse_transfer_result OK
yc.warn_settings_assign OK
yc.warn_settings_detail OK
yc.warn_settings_header OK
yc.wave OK
yc.wave_flow_detail OK
yc.wave_flow_header OK
yc.wave_master OK
yc.wave_template OK
yc.waybill_cross_pool OK
yc.waybill_number_pool OK
yc.wms_to_rfid_task OK
yc.work_order_detail OK
yc.work_order_header OK
yc.zone OK
yc.zpl_document OK
Upgrade process completed successfully.
Checking if update is needed.
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。




