293510
请问一下这是为啥
回帖数 3
阅读数 1487
发表时间 2022-12-28 17:58:56
2022-12-28 17:50:07 140576082810752 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2022-12-28 17:50:07 140576082810752 [Note] InnoDB: The InnoDB memory heap is disabled
2022-12-28 17:50:07 140576082810752 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-12-28 17:50:07 140576082810752 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2022-12-28 17:50:07 140576082810752 [Note] InnoDB: Compressed tables use zlib 1.2.3.4
2022-12-28 17:50:07 140576082810752 [Note] InnoDB: Using SSE crc32 instructions
2022-12-28 17:50:07 140576082810752 [Note] InnoDB: Initializing buffer pool, size = 512.0M
2022-12-28 17:50:07 140576082810752 [Note] InnoDB: Completed initialization of buffer pool
2022-12-28 17:50:07 140576082810752 [Note] InnoDB: Highest supported file format is Barracuda.
2022-12-28 17:50:07 140576082810752 [Note] InnoDB: The log sequence numbers 4852356 and 4852356 in ibdata files do not match the log sequence number 4852748 in the ib_logfiles!
2022-12-28 17:50:07 140576082810752 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
InnoDB: wrong number of columns in SYS_INDEXES record
InnoDB: wrong number of columns in SYS_INDEXES record
InnoDB: wrong number of columns in SYS_INDEXES record
InnoDB: wrong number of columns in SYS_INDEXES record
InnoDB: wrong number of columns in SYS_INDEXES record
InnoDB: wrong number of columns in SYS_INDEXES record
2022-12-28 17:50:07 140576082810752 [Note] InnoDB: Creating tablespace and datafile system tables.
2022-12-28 17:50:07 140576082810752 [ERROR] InnoDB: Creation of SYS_TABLESPACES and SYS_DATAFILES has failed with error 18. Tablespace is full. Dropping incompletely created tables.
2022-12-28 17:50:07 7fda6b7ad780 InnoDB: Assertion failure in thread 140576082810752 in file dict0crea.cc line 1903
InnoDB: Failing assertion: err == DB_OUT_OF_FILE_SPACE || err == DB_TOO_MANY_CONCURRENT_TRXS
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
2022-12-28 17:50:07 140576082810752 [Note] InnoDB: The InnoDB memory heap is disabled
2022-12-28 17:50:07 140576082810752 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-12-28 17:50:07 140576082810752 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2022-12-28 17:50:07 140576082810752 [Note] InnoDB: Compressed tables use zlib 1.2.3.4
2022-12-28 17:50:07 140576082810752 [Note] InnoDB: Using SSE crc32 instructions
2022-12-28 17:50:07 140576082810752 [Note] InnoDB: Initializing buffer pool, size = 512.0M
2022-12-28 17:50:07 140576082810752 [Note] InnoDB: Completed initialization of buffer pool
2022-12-28 17:50:07 140576082810752 [Note] InnoDB: Highest supported file format is Barracuda.
2022-12-28 17:50:07 140576082810752 [Note] InnoDB: The log sequence numbers 4852356 and 4852356 in ibdata files do not match the log sequence number 4852748 in the ib_logfiles!
2022-12-28 17:50:07 140576082810752 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
InnoDB: wrong number of columns in SYS_INDEXES record
InnoDB: wrong number of columns in SYS_INDEXES record
InnoDB: wrong number of columns in SYS_INDEXES record
InnoDB: wrong number of columns in SYS_INDEXES record
InnoDB: wrong number of columns in SYS_INDEXES record
InnoDB: wrong number of columns in SYS_INDEXES record
2022-12-28 17:50:07 140576082810752 [Note] InnoDB: Creating tablespace and datafile system tables.
2022-12-28 17:50:07 140576082810752 [ERROR] InnoDB: Creation of SYS_TABLESPACES and SYS_DATAFILES has failed with error 18. Tablespace is full. Dropping incompletely created tables.
2022-12-28 17:50:07 7fda6b7ad780 InnoDB: Assertion failure in thread 140576082810752 in file dict0crea.cc line 1903
InnoDB: Failing assertion: err == DB_OUT_OF_FILE_SPACE || err == DB_TOO_MANY_CONCURRENT_TRXS
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
3个回复
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
可以参考这个mysql官网手册尝试在数据库配置文件里将forcing-innodb-recovery相关配置改下值看下
2022-12-28 18:39:04 于涛 回帖
3个回复
innodb_force_recovery =1
这个参数范围是1-6 ,1不行的话,可以考虑逐步增加参数值试一下。
2022-12-29 10:47:46 于涛 回帖
联系我们
联系人
张淑钧/高级客户经理
电话(微信)
13156280939
QQ号码
2082428410
联系邮箱
zhangshujun@chandao.com

相关帖子
dongs | 最后回帖 2016-06-29 12:15 石洋洋
一身肌肉的皮带 | 最后回帖 2025-03-07 09:09 马超
jack | 最后回帖 2017-11-22 11:30 石洋洋
李先生 | 最后回帖 2024-10-19 22:21 William
蒋莹凯 | 最后回帖 2019-03-22 18:16 禅道-李锡碧
Chrysalis | 最后回帖 2016-12-15 10:34 石洋洋
于涛

精品资料包
1V1产品演示
免费试用增强功能
专属顾问答疑支持


