暂无图片
mysql server have restarted in a while time
我来答
分享
czxin788
2022-08-25
mysql server have restarted in a while time
After I upgraded my MySQL version from 8.0.28 to 8.0.29, my mysql-server often restarted in a white time,and the error log is :

2022-08-25T15:35:06.269918+08:00 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2022-08-25T15:35:06.269970+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_skip_errors' is deprecated and will be removed in a future release. Please use replica_skip_errors instead.
2022-08-25T15:35:06.270185+08:00 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2022-08-25T15:35:06.270290+08:00 0 [System] [MY-010116] [Server] /u01/app/mysql-8.0.29/bin/mysqld (mysqld 8.0.29) starting as process 10686
2022-08-25T15:35:06.307016+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-08-25T15:35:10.748115+08:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-08-25T15:35:26.783633+08:00 0 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:3654:rec thread 140706231158528
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/8.0/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
07:35:26 UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x7ff8ac014670
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 7ff8b8ecfcc8 thread_stack 0x100000
/u01/app/mysql-8.0.29/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2e) [0x1f80d4e]
/u01/app/mysql-8.0.29/bin/mysqld(print_fatal_signal(int)+0x2eb) [0x103587b]
/u01/app/mysql-8.0.29/bin/mysqld(my_server_abort()+0x5e) [0x103597e]
/u01/app/mysql-8.0.29/bin/mysqld(my_abort()+0xa) [0x1f7b4fa]
/u01/app/mysql-8.0.29/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x30c) [0x223b96c]
/u01/app/mysql-8.0.29/bin/mysqld() [0x227c25e]
/u01/app/mysql-8.0.29/bin/mysqld() [0x24154ab]
/u01/app/mysql-8.0.29/bin/mysqld() [0x241586a]
/u01/app/mysql-8.0.29/bin/mysqld(row_undo_mod(undo_node_t*, que_thr_t*)+0xcef) [0x24191ef]
/u01/app/mysql-8.0.29/bin/mysqld(row_undo_step(que_thr_t*)+0x52) [0x21b66e2]
/u01/app/mysql-8.0.29/bin/mysqld(que_run_threads(que_thr_t*)+0xc98) [0x215baa8]
/u01/app/mysql-8.0.29/bin/mysqld(trx_rollback_or_clean_recovered(bool)+0x1343) [0x2212513]
/u01/app/mysql-8.0.29/bin/mysqld(trx_recovery_rollback_thread()+0x1b) [0x221357b]
/u01/app/mysql-8.0.29/bin/mysqld(std::thread::_State_impl<std::thread::_Invoker<std::tuple<Detached_thread, void (*)()> > >::_M_run()+0xac) [0x20ffdcc]
/u01/app/mysql-8.0.29/bin/mysqld() [0x277a69f]
/lib64/libpthread.so.0(+0x7e65) [0x7ffb45480e65]
/lib64/libc.so.6(clone+0x6d) [0x7ffb4378a88d]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): is an invalid pointer
Connection ID (thread ID): 0
Status: NOT_KILLED

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.



What can i do to solve the problem
我来答
添加附件
收藏
分享
问题补充
5条回答
默认
最新
严少安
暂无图片

可能遇到bug了,做好备份,
可以尝试完全停机再升级到 8.0.30 看下

暂无图片 评论
暂无图片 有用 0
暂无图片
czxin788

我把mysql从8.0.28升级到8.0.29后,每过一两天数据库就会重启,并报如上错误,不知道什么原因。

暂无图片 评论
暂无图片 有用 0
Kubee

image.png
这上面有说明原因和方法

暂无图片 评论
暂无图片 有用 0
czxin788

根据日志,是说innodb 表空间损坏了,需要用innodb_force_recovery参数启动数据库,做一次强制恢复。

或者是你遭遇了一个bug,但这个bug一般是由于硬件损坏导致的。


我们没有断电导致数据库意外重启过。我们只是做了一次升级,从mysql 8.0.28升级到mysql 8.0.29后,才出现这样的情况。

我们怀疑是升级导致的,但又不知道具体什么原因以及解决办法。

暂无图片 评论
暂无图片 有用 0
张sir

怀疑是升级到的页损坏,如果重启频繁的话,建议还是先做好备份,重新部署数据库,迁移过去吧,防止哪天宕机真起不来就麻烦了。

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏