记录一个MySQL安装时的日志,麻烦大佬们帮忙看看。
2024-07-15T14:12:49.255307Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.33) initializing of server in progress as process 22794
2024-07-15T14:12:49Z UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=0d441faec2944aba473cbc69eb61e27c4074d942
Thread pointer: 0x0
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 = 0 thread_stack 0x100000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x3d) [0x2106c6d]
/usr/sbin/mysqld(print_fatal_signal(int)+0x37f) [0xfcd47f]
/usr/sbin/mysqld(handle_fatal_signal+0xa5) [0xfcd535]
/lib64/libpthread.so.0(+0xf630) [0x7f46df560630]
/usr/sbin/mysqld(Delegate::Delegate(unsigned int)+0xaf) [0x1d8e16f]
/usr/sbin/mysqld(delegates_init()+0x31) [0x1d8eaf1]
/usr/sbin/mysqld() [0xd55414]
/usr/sbin/mysqld(mysqld_main(int, char**)+0x1eea) [0xd5d40a]
/lib64/libc.so.6(__libc_start_main+0xf5) [0x7f46dda96555]
/usr/sbin/mysqld() [0xd3fb74]
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.
你这个我遇到过一次,我重新安装了,就解决了
换一台服务器安装试一试罗。
从提供的日志来看,MySQL 在初始化服务器过程中遇到了一个崩溃错误,并且产生了信号 11 (SIGSEGV),通常表示一个段错误。段错误可能是由于软件bug或硬件故障引起的
检查MySQL配置文件:
确保配置文件(通常是 /etc/my.cnf 或 /etc/mysql/my.cnf)中没有配置错误。
升级MySQL:
尝试升级到MySQL的最新版本。具体步骤如下:
sudo apt-get update
sudo apt-get install mysql-server
检查硬件健康:
使用 memtest86 进行内存测试,使用 smartctl 检查硬盘健康:
sudo smartctl -a /dev/sda
检查系统日志:
查看系统日志是否有其他相关错误:
sudo tail -n 100 /var/log/syslog
sudo tail -n 100 /var/log/messages
更新一下mysql,这可能是一个bug,在新版本里已经解决了