MySql启动错误1067之 InnoDB: .\ibdata1 can't be opened in read-write mode

最新推荐文章于 2025-10-16 11:47:13 发布
原创 最新推荐文章于 2025-10-16 11:47:13 发布 · 4k 阅读 · 2 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

博客讲述免安装版MySQL启动服务提示错误1067的解决过程。查看系统日志得知错误信息为InnoDB:.\\ibdata1 can't be opened in read - write mode，通过终止mysqld进程、删除mysql安装目录data文件夹下特定2个文件，最后重新启动，MySQL成功启动。

免安装版MySql，启动服务一直提示错误1067

多方百度，查看windows系统日志

错误信息:   InnoDB: .\ibdata1 can't be opened in read-write mode

继续百度解决方法：

1、打开任务管理器终止mysqld进程；

2、打开mysql安装目录的data文件夹，删除以下2个文件：

ib_logfile0和ib_logfile1

3、重新启动mysql

启动成功

【服务与运维】2.0 centos7安装mysql——源码:cmake安装mysql
qq_24428851的博客
01-30 739
以下内容凡是执行过程中找不到某个文件的，手动新建该文件即可。直到不报错为止。删除mariadbxshell传输文件的指令zy -y2.0 cmake方式安装mysql（企业级使用）下载cmake安装cmakeimage.pngimage.pngimage.pngimage.png安装依赖包下载安装boost1.59.0(这里mysql5.7版本要求boost版本为1.59.0)解压(未使用）image.pngimage.png设置组合用户。
MySQL 5.7.42 主从复制环境搭建
fanzhuozhuo的博客
06-25 1022
本次安装环境：OS版本：Red Hat Enterprise Linux Server release 6.8 (Santiago)MySQL版本：5.7.42架构：同一台机器，多实例安装搭建ip地址：10.1.11.250安装方式：采用MySQL二进制安装。
mysql ibdata1 mode_MySql：InnoDB: .\ibdata1 can't be opened in read-write mode
weixin_35789885的博客
02-07 458
场景还原：1.厂商A正常安装MySql5.6，占用端口33062.我方正常安装MariaDB，占用端口83063.服务器部署完成后，检测正常(未注意到A厂服务，不确定是否造成冲突，任务管理器两个mysqld均正常)4.隔天A厂操作了一把，然后发现MariaDB服务宕机，加上服务后，提示和事件检查器显示如下：服务启动提示：1067 进程意外终止事件启动器提示：InnoDB: .\ibdata1 ca...
MYSQL服务无法启动：InnoDB: .\ibdata1 can't be opened in read-write mode
菜鸟攻城师的一亩三分地
02-16 2222
在一台window server 2008 64，安装了两个mysql服务， 第一个mysql安装时正常的安装方法，第二个的安装时通过第一已安装好的mysql所有文件复制，在mysqld -install myql2命令安装的，服务是安装成功了，但是mysql2服务启动不了（但是系统进程中有mysql2的进程），看了下系统日志，居然有很多报错，贴个图哈 主要错误有： InnoDB:
【实战】MySQL 8.0 Xtrabackup 全量备份与恢复：从环境搭建到故障排障（附完整命令+参数详解）
W3368314149的博客
10-16 1235
在 MySQL 运维中，数据备份与恢复是保障业务连续性的核心能力。Percona Xtrabackup 作为开源免费的热备工具，支持在线无锁备份，广泛应用于生产环境。本文基于，从「全量备份→数据破坏模拟→全量恢复」完整流程出发，手把手带你解决备份恢复中的典型问题（路径冲突、权限错误、日志缺失等），所有命令可直接复制使用，适合新手入门与运维实战参考。
MySQL启动报错问题InnoDB:Unable to lock/ibdata1 error
09-09
主要介绍了MySQL启动报错问题InnoDB:Unable to lock/ibdata1 error,文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值,需要的朋友可以参考下
MYSQL服务无法启动：InnoDB: .\ibdata1 can‘t be opened in read-write mode
Beginner_G的博客
04-20 1074
今天启动mysql数据库，后来发现服务无法启动，查看日志报错如下： 2015-01-07 17:48:54 9136 [ERROR] InnoDB: .\ibdata1 can't be opened in read-write mode 2015-01-07 17:48:54 9136 [ERROR] InnoDB: The system tablespace must be writable! 2015-01-07 17:48:54 9136 [ERROR] Plugin 'InnoDB' init f
[ERROR] InnoDB: .\ibdata1 can't be opened in read-write mode
weixin_34402408的博客
03-24 408
mysql数据库服务无法启动，查看日志报错如下：2015-01-07 17:48:54 9136 [ERROR] InnoDB: .\ibdata1 can't be opened in read-write mode2015-01-07 17:48:54 9136 [ERROR] InnoDB: The system tablespace must be writable!...
mysql ibdata1 mode_mysql [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode
weixin_42394573的博客
01-18 484
最近开始研究mysql，有一台服务器，第一次部署时有一些配置文件的路径有问题，打算重新部署，因为mysql用的二进制安装方式，删除了mysql目录，重新部署是报错：# ./scripts/mysql_install_db --defaults-file=/etc/my.cnf --user=mysqlInstalling MySQL system tables...2015-05-29 11:1...
2025-06-19 13:54:33 10592 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Normal shutdown 2025-06-19 13:54:33 10592 [Note] Giving 15 client threads a chance to die gracefully 2025-06-19 13:54:33 10592 [Note] Event Scheduler: Killing the scheduler thread, thread id 116 2025-06-19 13:54:33 10592 [Note] Event Scheduler: Waiting for the scheduler thread to reply 2025-06-19 13:54:33 10592 [Note] Event Scheduler: Stopped 2025-06-19 13:54:33 10592 [Note] Event Scheduler: Purging the queue. 2 events 2025-06-19 13:54:33 10592 [Note] Shutting down slave threads 2025-06-19 13:54:35 10592 [Note] Forcefully disconnecting 3 remaining clients 2025-06-19 13:54:35 10592 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 35 user: 'wcs' 2025-06-19 13:54:35 10592 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 8 user: 'wcs' 2025-06-19 13:54:35 10592 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 3729 user: 'wcs' 2025-06-19 13:54:35 10592 [Note] Binlog end 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'partition' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_METRICS' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_CMPMEM' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_CMP' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_LOCKS' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'INNODB_TRX' 2025-06-19 13:54:35 10592 [Note] Shutting down plugin 'InnoDB' 2025-06-19 13:54:35 10592 [Note] InnoDB: FTS optimize thread exiting. 2025-06-19 13:54:35 10592 [Note] InnoDB: Starting shutdown... 2025-06-19 13:54:37 10592 [Note] InnoDB: Shutdown completed; log sequence number 31950984072 2025-06-19 13:54:37 10592 [Note] Shutting down plugin 'BLACKHOLE' 2025-06-19 13:54:37 10592 [Note] Shutting down plugin 'ARCHIVE' 2025-06-19 13:54:37 10592 [Note] Shutting down plugin 'MRG_MYISAM' 2025-06-19 13:54:37 10592 [Note] Shutting down plugin 'MyISAM' 2025-06-19 13:54:37 10592 [Note] Shutting down plugin 'MEMORY' 2025-06-19 13:54:37 10592 [Note] Shutting down plugin 'CSV' 2025-06-19 13:54:37 10592 [Note] Shutting down plugin 'sha256_password' 2025-06-19 13:54:37 10592 [Note] Shutting down plugin 'mysql_old_password' 2025-06-19 13:54:37 10592 [Note] Shutting down plugin 'mysql_native_password' 2025-06-19 13:54:37 10592 [Note] Shutting down plugin 'binlog' 2025-06-19 13:54:37 10592 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Shutdown complete 2025-06-19 13:54:38 3896 [Note] Plugin 'FEDERATED' is disabled. 2025-06-19 13:54:38 289c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2025-06-19 13:54:38 3896 [Note] InnoDB: Using atomics to ref count buffer pool pages 2025-06-19 13:54:38 3896 [Note] InnoDB: The InnoDB memory heap is disabled 2025-06-19 13:54:38 3896 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2025-06-19 13:54:38 3896 [Note] InnoDB: Memory barrier is not used 2025-06-19 13:54:38 3896 [Note] InnoDB: Compressed tables use zlib 1.2.3 2025-06-19 13:54:38 3896 [Note] InnoDB: Not using CPU crc32 instructions 2025-06-19 13:54:38 3896 [Note] InnoDB: Initializing buffer pool, size = 8.0G 2025-06-19 13:54:38 3896 [Note] InnoDB: Completed initialization of buffer pool 2025-06-19 13:54:38 3896 [Note] InnoDB: Highest supported file format is Barracuda. 2025-06-19 13:54:39 3896 [Note] InnoDB: 128 rollback segment(s) are active. 2025-06-19 13:54:39 3896 [Note] InnoDB: Waiting for purge to start 2025-06-19 13:54:39 3896 [Note] InnoDB: 5.6.21 started; log sequence number 31950984072 2025-06-19 13:54:39 3896 [Note] Server hostname (bind-address): '*'; port: 3306 2025-06-19 13:54:39 3896 [Note] IPv6 is available. 2025-06-19 13:54:39 3896 [Note] - '::' resolves to '::'; 2025-06-19 13:54:39 3896 [Note] Server socket created on IP: '::'. 2025-06-19 13:54:39 3896 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem. 2025-06-19 13:54:39 3896 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened. 2025-06-19 13:54:39 3896 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem. 2025-06-19 13:54:39 3896 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem. 2025-06-19 13:54:39 3896 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened. 2025-06-19 13:54:39 3896 [Note] Event Scheduler: Loaded 2 events 2025-06-19 13:54:39 3896 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: ready for connections. Version: '5.6.21-log' socket: '' port: 3306 MySQL Community Server (GPL) 2025-06-19 13:54:39 3896 [Warning] Hostname 'DESKTOP-56G0R2L' does not resolve to '11.1.85.22'. 2025-06-19 13:54:39 3896 [Warning] Hostname 'DESKTOP-56G0R2L' does not resolve to '11.1.85.22'. 2025-06-19 13:54:39 3896 [Note] Hostname 'DESKTOP-56G0R2L' has the following IP addresses: 2025-06-19 13:54:39 3896 [Note] Hostname 'DESKTOP-56G0R2L' has the following IP addresses: 2025-06-19 13:54:39 3896 [Note] - fe80::659c:c088:9d63:4346%17 2025-06-19 13:54:39 3896 [Note] - fe80::659c:c088:9d63:4346%17 2025-06-19 13:54:39 3896 [Note] - 11.1.85.24 2025-06-19 13:54:39 3896 [Note] - 169.254.119.0 2025-06-19 13:54:39 26c InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:39 26c2025-06-19 13:54:39 2a90 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:39 2a90 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."feedercameradata" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."feedercameradata" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:39 2cb0 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:39 2cb0 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."alreadysortinfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:39 2028 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:39 20282025-06-19 13:54:39 249c InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:39 249c InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."alreadysortinfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."alreadysortinfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:39 1c84 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:39 1c84 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."errorrecord" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:39 808 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:39 808 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."systemlog" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:41 2d04 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:41 2d04 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."devicestate_monitorinfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:41 3896 [Warning] Hostname 'DESKTOP-56G0R2L' does not resolve to '11.1.85.31'. 2025-06-19 13:54:41 3896 [Note] Hostname 'DESKTOP-56G0R2L' has the following IP addresses: 2025-06-19 13:54:41 3896 [Note] - fe80::e985:a0f1:2751:eada%17 2025-06-19 13:54:41 3896 [Note] - 169.254.170.71 2025-06-19 13:54:42 24b8 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:42 24b8 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."userinfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:42 3896 [Warning] Hostname 'DESKTOP-1LL2I5F' does not resolve to '11.1.85.33'. 2025-06-19 13:54:42 3896 [Note] Hostname 'DESKTOP-1LL2I5F' has the following IP addresses: 2025-06-19 13:54:42 3896 [Note] - fe80::7082:fd95:7ec0:bcc8%17 2025-06-19 13:54:42 3896 [Note] - 169.254.255.9 2025-06-19 13:54:42 3896 [Warning] Hostname 'DESKTOP-56G0R2L' does not resolve to '11.1.85.26'. 2025-06-19 13:54:42 3896 [Note] Hostname 'DESKTOP-56G0R2L' has the following IP addresses: 2025-06-19 13:54:42 3896 [Note] - fe80::daa7:903b:6a3c:c735%17 2025-06-19 13:54:42 3896 [Note] - 11.1.85.31 2025-06-19 13:54:42 3896 [Warning] Hostname 'DESKTOP-56G0R2L' does not resolve to '11.1.85.22'. 2025-06-19 13:54:42 3896 [Note] Hostname 'DESKTOP-56G0R2L' has the following IP addresses: 2025-06-19 13:54:42 3896 [Note] - fe80::659c:c088:9d63:4346%17 2025-06-19 13:54:42 3896 [Note] - 11.1.85.37 2025-06-19 13:54:43 808 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:43 808 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."portcode_timing" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:43 25a0 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:43 25a0 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."helpmanual" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:45 3896 [Warning] Hostname 'DESKTOP-56G0R2L' does not resolve to '11.1.85.30'. 2025-06-19 13:54:45 3896 [Note] Hostname 'DESKTOP-56G0R2L' has the following IP addresses: 2025-06-19 13:54:45 3896 [Note] - fe80::6b84:3a08:e1d0:e750%17 2025-06-19 13:54:45 3896 [Note] - 11.1.85.31 2025-06-19 13:54:45 3896 [Warning] Hostname 'DESKTOP-56G0R2L' does not resolve to '11.1.85.24'. 2025-06-19 13:54:45 3896 [Note] Hostname 'DESKTOP-56G0R2L' has the following IP addresses: 2025-06-19 13:54:45 3896 [Note] - fe80::daa7:903b:6a3c:c735%17 2025-06-19 13:54:45 3896 [Note] - 11.1.85.28 2025-06-19 13:54:47 3896 [Warning] Hostname 'DESKTOP-S1Q82IV' does not resolve to '11.1.85.27'. 2025-06-19 13:54:47 3896 [Note] Hostname 'DESKTOP-S1Q82IV' has the following IP addresses: 2025-06-19 13:54:47 3896 [Note] - fe80::3711:88ce:2316:8596%17 2025-06-19 13:54:47 3896 [Note] - 169.254.226.201 2025-06-19 13:54:47 808 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2c6c InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2c6c2025-06-19 13:54:47 808 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."feedinginfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."feedinginfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 24b8 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 24b82025-06-19 13:54:47 78c InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."feedinginfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 78c InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."feedinginfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."alreadysortinfohist" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."arrival" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."arrival_copy" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."bagcheckalarmforsto" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."bagcode_base64" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."baglifeinfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."bagscanresultinfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."basisdata" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."billlog" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."billloghist" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."checkscaleinfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."countinfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."customerinfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."departure" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."departure_copy" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."devicestateinfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."devicestateinfooferrorclosewcs" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."eachscanresult" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."electricenergyrecord" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."event_log" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."fail_upload" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."failsortinfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."failsortinfohist" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."failuploaddata" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."feedinginfo1" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."feedinginfohist" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."interfaceusagedetail" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."jdv2picinfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."loading_occupancy" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."manualcodingresult" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."manualcodingresulthist" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."moduleversion" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."nccountinfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."orderauto" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."packagecode" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."packageprintinfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."port_bagid" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."port_printer" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."portandboxcode" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."portcode_timinghist" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."queue_task" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."readtarget" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."reuploadopccodedata" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."routingtable" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."scannersortinfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."scanresult" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."show_billcode" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."sortcodeinfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."statisticsofpackagesupplyrecords" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."switchshiftofsto" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."ts" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."upload_fail" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."uploaddata" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."uploadpicinfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."user" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."useractioninfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."userrank_rankname" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."userrankinfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."webpointparameter" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."webpointparameter2" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."yzgjsortinfo" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:47 2738 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2025-06-19 13:54:47 2738 InnoDB: Error: Fetch of persistent statistics requested for table "db_wcs"."yzshift" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2025-06-19 13:54:49 3896 [Warning] Hostname 'DESKTOP-S1Q82IV' does not resolve to '11.1.85.25'. 2025-06-19 13:54:49 3896 [Note] Hostname 'DESKTOP-S1Q82IV' has the following IP addresses: 2025-06-19 13:54:49 3896 [Note] - fe80::a18:a682:b681:52a8%17 2025-06-19 13:54:49 3896 [Note] - 169.254.226.201 2025-06-19 13:54:49 3896 [Warning] Hostname 'DESKTOP-S1Q82IV' does not resolve to '11.1.85.39'. 2025-06-19 13:54:49 3896 [Note] Hostname 'DESKTOP-S1Q82IV' has the following IP addresses: 2025-06-19 13:54:49 3896 [Note] - fe80::416:a93d:15ac:92bc%17 2025-06-19 13:54:49 3896 [Note] - 169.254.226.201 2025-06-19 13:54:49 3896 [Warning] Hostname 'DESKTOP-56G0R2L' does not resolve to '11.1.85.40'. 2025-06-19 13:54:49 3896 [Note] Hostname 'DESKTOP-56G0R2L' has the following IP addresses: 2025-06-19 13:54:49 3896 [Note] - fe80::e985:a0f1:2751:eada%17 2025-06-19 13:54:49 3896 [Note] - 11.1.85.28 2025-06-19 13:54:50 3896 [Warning] Hostname 'DESKTOP-S1Q82IV' does not resolve to '11.1.85.32'. 2025-06-19 13:54:50 3896 [Note] Hostname 'DESKTOP-S1Q82IV' has the following IP addresses: 2025-06-19 13:54:50 3896 [Note] - fe80::3711:88ce:2316:8596%17 2025-06-19 13:54:50 3896 [Note] - 169.254.226.201 2025-06-19 13:54:50 3896 [Warning] Hostname 'DESKTOP-56G0R2L' does not resolve to '11.1.85.38'. 2025-06-19 13:54:50 3896 [Note] Hostname 'DESKTOP-56G0R2L' has the following IP addresses: 2025-06-19 13:54:50 3896 [Note] - fe80::e985:a0f1:2751:eada%17 2025-06-19 13:54:50 3896 [Note] - 169.254.178.147 2025-06-19 13:54:51 3896 [Warning] Hostname 'DESKTOP-56G0R2L' does not resolve to '11.1.85.36'. 2025-06-19 13:54:51 3896 [Note] Hostname 'DESKTOP-56G0R2L' has the following IP addresses: 2025-06-19 13:54:51 3896 [Note] - fe80::e985:a0f1:2751:eada%17 2025-06-19 13:54:51 3896 [Note] - 169.254.170.71 2025-06-19 13:54:52 3896 [Warning] Hostname 'DESKTOP-56G0R2L' does not resolve to '11.1.85.28'. 2025-06-19 13:54:52 3896 [Note] Hostname 'DESKTOP-56G0R2L' has the following IP addresses: 2025-06-19 13:54:52 3896 [Note] - fe80::daa7:903b:6a3c:c735%17 2025-06-19 13:54:52 3896 [Note] - 11.1.85.36 2025-06-19 13:54:53 3896 [Warning] Hostname 'DESKTOP-56G0R2L' does not resolve to '11.1.85.37'. 2025-06-19 13:54:53 3896 [Note] Hostname 'DESKTOP-56G0R2L' has the following IP addresses: 2025-06-19 13:54:53 3896 [Note] - fe80::daa7:903b:6a3c:c735%17 2025-06-19 13:54:53 3896 [Note] - 11.1.85.28 windows2019下安装的mysql5.6 今天启动报错1067，重启服务器后正常了，以上是收集的mysql日志，帮忙分析报错1067的原因
06-21
`[ERROR] InnoDB: .\ibdata1 can't be opened in read-write mode` `[ERROR] Plugin 'InnoDB' init function returned error` 5. **兼容性问题** - Windows Server 2019 的权限策略或驱动与 MySQL 5.6 冲突 -...
InnoDB: The innodb_system data file 'ibdata1' must be writable InnoDB: The innodb_system data file 'ibdata1' must be writable InnoDB: Plugin initialization aborted with error Generic error Plugin 'InnoDB' init function returned error. Plugin 'InnoDB' registration as a STORAGE ENGINE failed. Failed to initialize builtin plugins. Aborting
07-15
当 MySQL 启动时出现 `InnoDB: ibdata1 can't be opened in read-write mode` 或类似的错误提示，表明 InnoDB 存储引擎无法以读写模式打开共享表空间数据文件 `ibdata1`。此类问题可能由多种原因导致，包括： - **...
服务器突然断电，重启后找不到mysql.sock文件、innodb引擎表（日志表）损坏
weixin_43194701的博客
05-27 838
服务器突然断电，重启后找不到mysql.sock文件、innodb引擎表（日志表）损坏 一. 1.mysql启动报错 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) 2.检查mysqld状态（数据出现损坏）： 连接失败！ 2015-01-07 17:48:54 9136 [ERROR] InnoDB: .\ibdata1 can't be opened in read-
Mysql ./ibdata1 can't be opened in read-write mode
清若尘的博客
06-28 6774
服务器： Window Server 2012进入Mysql时出现如下问题ERROR 1045 (28000): Access denied for user 'xxx'@'localhost' (using password: YES) 使用命令 Mysqld --console 发现如下异常2016-06-28T01:05:00.808135Z 0 [ERROR] InnoDB: The i
mysql ibdata1 mode_解决mysql 5.6 的 ./ibdata1 can't be opened in read-write mode问题
weixin_29738537的博客
01-18 239
2015-08-19 01:12:31 6608 [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode2015-08-19 01:12:31 6608 [ERROR] InnoDB: The system tablespace must be writable!2015-08-19 01:12:31 6608 [ERROR] Pl...
windows mysql 启动报1067错误 .\ibdata1 can't be opened in read-write mode
w123456woaini的博客
05-15 653
1、错误提示如下： 2019-05-15 10:39:26 8204 [ERROR] InnoDB: .\ibdata1 can't be opened in read-write mode 2019-05-15 10:39:26 8204 [ERROR] InnoDB: The system tablespace must be writable! 2019-05-15 10:39:26 82...
mysql ibdata1 mode_[ERROR] InnoDB: .\ibdata1 can't be opened in read-write mode
weixin_39611070的博客
02-07 147
mysql数据库服务无法启动，查看日志报错如下：2015-01-07 17:48:54 9136 [ERROR] InnoDB: .\ibdata1 can‘t be opened in read-write mode2015-01-07 17:48:54 9136 [ERROR] InnoDB: The system tablespace must be writable!2015-01-07 ...
[ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode
ckumtg3452的博客
01-25 440
问题： [root@localhost mysql]# ./scripts/mysql_install_db --user=mysql --basedir=/u01/app/mysql --datadir=/u01/app/m...
mysql ibdata1 mode_MYSQL服务无法启动：InnoDB: .\ibdata1 can't be opened in read-write mode
weixin_35539437的博客
01-20 350
今天在那做实验倒腾mysql数据库，后来发现服务无法启动，查看日志报错如下：2015-01-07 17:48:54 9136 [ERROR] InnoDB: .\ibdata1 can't be opened in read-write mode2015-01-07 17:48:54 9136 [ERROR] InnoDB: The system tablespace must be writab...
[root@master mysql]# [root@master mysql]# cat /export/server/mysql/data/error.log 2025-10-23T01:13:55.414279Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2025-10-23T01:13:55.414408Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2025-10-23T01:13:55.414450Z 0 [Note] /export/server/mysql/bin/mysqld (mysqld 5.7.43) starting as process 75223 ... 2025-10-23T01:13:55.420835Z 0 [Note] InnoDB: PUNCH HOLE support available 2025-10-23T01:13:55.420908Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2025-10-23T01:13:55.420916Z 0 [Note] InnoDB: Uses event mutexes 2025-10-23T01:13:55.420919Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier 2025-10-23T01:13:55.420922Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 2025-10-23T01:13:55.420925Z 0 [Note] InnoDB: Using Linux native AIO 2025-10-23T01:13:55.421185Z 0 [Note] InnoDB: Number of pools: 1 2025-10-23T01:13:55.421275Z 0 [Note] InnoDB: Using CPU crc32 instructions 2025-10-23T01:13:55.435005Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2025-10-23T01:13:55.444667Z 0 [Note] InnoDB: Completed initialization of buffer pool 2025-10-23T01:13:55.450205Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2025-10-23T01:13:55.463031Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2025-10-23T01:13:55.473691Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2025-10-23T01:13:55.473830Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2025-10-23T01:13:55.495089Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2025-10-23T01:13:55.495883Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2025-10-23T01:13:55.496011Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2025-10-23T01:13:55.496616Z 0 [Note] InnoDB: Waiting for purge to start 2025-10-23T01:13:55.547361Z 0 [Note] InnoDB: 5.7.43 started; log sequence number 2766921 2025-10-23T01:13:55.549046Z 0 [Note] InnoDB: Loading buffer pool(s) from /export/server/mysql/data/ib_buffer_pool 2025-10-23T01:13:55.549951Z 0 [Note] Plugin 'FEDERATED' is disabled. 2025-10-23T01:13:55.551197Z 0 [Note] InnoDB: Buffer pool(s) load completed at 251023 9:13:55 2025-10-23T01:13:55.556296Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2025-10-23T01:13:55.556312Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2025-10-23T01:13:55.556317Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher. 2025-10-23T01:13:55.556320Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher. 2025-10-23T01:13:55.560623Z 0 [Warning] CA certificate ca.pem is self signed. 2025-10-23T01:13:55.560676Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2025-10-23T01:13:55.561456Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2025-10-23T01:13:55.561525Z 0 [Note] IPv6 is available. 2025-10-23T01:13:55.561533Z 0 [Note] - '::' resolves to '::'; 2025-10-23T01:13:55.561553Z 0 [Note] Server socket created on IP: '::'. 2025-10-23T01:13:55.572947Z 0 [Note] Event Scheduler: Loaded 0 events 2025-10-23T01:13:55.573171Z 0 [Note] /export/server/mysql/bin/mysqld: ready for connections. Version: '5.7.43' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) 2025-10-23T01:14:34.896537Z 2 [Note] Access denied for user 'root'@'localhost' (using password: YES) 2025-10-23T01:38:33.169627Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2025-10-23T01:38:33.169753Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2025-10-23T01:38:33.169798Z 0 [Note] /export/server/mysql/bin/mysqld (mysqld 5.7.43) starting as process 118444 ... 2025-10-23T01:38:33.177313Z 0 [Note] InnoDB: PUNCH HOLE support available 2025-10-23T01:38:33.177351Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2025-10-23T01:38:33.177357Z 0 [Note] InnoDB: Uses event mutexes 2025-10-23T01:38:33.177361Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier 2025-10-23T01:38:33.177364Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 2025-10-23T01:38:33.177367Z 0 [Note] InnoDB: Using Linux native AIO 2025-10-23T01:38:33.177700Z 0 [Note] InnoDB: Number of pools: 1 2025-10-23T01:38:33.178030Z 0 [Note] InnoDB: Using CPU crc32 instructions 2025-10-23T01:38:33.182715Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2025-10-23T01:38:33.192178Z 0 [Note] InnoDB: Completed initialization of buffer pool 2025-10-23T01:38:33.194675Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2025-10-23T01:38:33.204980Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:33.205030Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:33.205040Z 0 [Note] InnoDB: Retrying to lock the first data file 2025-10-23T01:38:34.206008Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:34.206060Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:35.206300Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:35.206348Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:36.206929Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:36.206965Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:37.207044Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:37.207082Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:38.207378Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:38.207423Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:39.207891Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:39.207968Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:40.208356Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:40.208493Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:41.209159Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:41.209210Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:42.209436Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:42.209466Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:43.222502Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:43.222576Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:44.223360Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:44.223423Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:45.223766Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:45.223802Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:46.224017Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:46.224080Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:47.224624Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:47.224687Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:48.224825Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:48.224865Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:49.225531Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:49.225584Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:50.225762Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:50.225826Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:51.226964Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:51.227011Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:52.227384Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:52.227425Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:53.227939Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:53.227989Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:54.228400Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:54.228452Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:55.228603Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:55.228636Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:56.229104Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:56.229169Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:57.229819Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:57.229876Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:58.230309Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:58.230365Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:38:59.230752Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:38:59.230806Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:00.231287Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:00.231348Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:01.232308Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:01.232384Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:02.232711Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:02.232767Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:03.233423Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:03.233489Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:04.233976Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:04.234016Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:05.234460Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:05.234513Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:06.234802Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:06.234869Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:07.235875Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:07.235955Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:08.236527Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:08.236589Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:09.237178Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:09.237244Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:10.237935Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:10.238204Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:11.238609Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:11.238711Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:12.239379Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:12.239434Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:13.239799Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:13.239851Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:14.240048Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:14.240108Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:15.240305Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:15.240360Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:16.240582Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:16.240638Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:17.241380Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:17.241418Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:18.242303Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:18.242439Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:19.243096Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:19.243153Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:20.243484Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:20.243556Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:21.243759Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:21.243809Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:22.244131Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:22.244186Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:23.244922Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:23.245052Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:24.246341Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:24.246388Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:25.246626Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:25.246675Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:26.247096Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:26.248258Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:27.248681Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:27.248748Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:28.249386Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:28.249439Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:29.249626Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:29.249667Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:30.249910Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:30.249963Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:31.251042Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:31.251083Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:32.251255Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:32.251299Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:33.251726Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:33.251777Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:34.251973Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:34.252030Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:35.252544Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:35.252592Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:36.252876Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:36.252931Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:37.253711Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:37.253768Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:38.253946Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:38.253991Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:39.254333Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:39.254390Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:40.254700Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:40.254765Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:41.255174Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:41.255238Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:42.255552Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:42.255628Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:43.256063Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:43.256124Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:44.256363Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:44.256418Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:45.257169Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:45.257245Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:46.257802Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:46.257874Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:47.258303Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:47.258358Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:48.258913Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:48.258968Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:49.259298Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:49.259355Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:50.259563Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:50.259631Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:51.259846Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:51.259902Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:52.260069Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:52.260123Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:53.260689Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:53.260743Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:54.261138Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:54.261195Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:55.261401Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:55.261458Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:56.261669Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:56.261722Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:57.262101Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:57.262154Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:58.262590Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:58.262646Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:39:59.263205Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:39:59.263261Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:40:00.263719Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:40:00.263776Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:40:01.263992Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:40:01.264027Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:40:02.264200Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:40:02.264249Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:40:03.264605Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:40:03.264675Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:40:04.265198Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:40:04.265244Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:40:05.265605Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:40:05.265713Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:40:06.265930Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:40:06.265987Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:40:07.266540Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:40:07.266604Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:40:08.267198Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:40:08.267254Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:40:09.267931Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:40:09.268002Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:40:10.268330Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:40:10.268373Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:40:11.268930Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:40:11.268982Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:40:12.269604Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:40:12.269658Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:40:13.269932Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 2025-10-23T01:40:13.269980Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2025-10-23T01:40:13.269985Z 0 [Note] InnoDB: Unable to open the first data file 2025-10-23T01:40:13.270007Z 0 [ERROR] InnoDB: Operating system error number 11 in a file operation. 2025-10-23T01:40:13.270028Z 0 [ERROR] InnoDB: Error number 11 means 'Resource temporarily unavailable' 2025-10-23T01:40:13.270034Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html 2025-10-23T01:40:13.270038Z 0 [ERROR] InnoDB: Cannot open datafile './ibdata1' 2025-10-23T01:40:13.270045Z 0 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data! 2025-10-23T01:40:13.270059Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Cannot open a file 2025-10-23T01:40:13.470950Z 0 [ERROR] Plugin 'InnoDB' init function returned error. 2025-10-23T01:40:13.470999Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2025-10-23T01:40:13.471006Z 0 [ERROR] Failed to initialize builtin plugins. 2025-10-23T01:40:13.471008Z 0 [ERROR] Aborting 2025-10-23T01:40:13.471026Z 0 [Note] Binlog end 2025-10-23T01:40:13.471098Z 0 [Note] Shutting down plugin 'MyISAM' 2025-10-23T01:40:13.471480Z 0 [Note] /export/server/mysql/bin/mysqld: Shutdown complete [root@master mysql]#
最新发布
10-24
该文件为 **“普通文本型”**，内容是用户在尝试启动 MySQL 服务时产生的完整错误日志输出，核心问题是： > **InnoDB: Unable to lock ./ibdata1 error: 11** 这是一个典型的 **MySQL 启动失败故障排查请求**，需...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值