首页 新闻 会员 周边

MySQL安装中遇到的问题,求大佬们帮忙解答。

0
悬赏园豆:200 [待解决问题]

记录一个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.

1506444122的主页 1506444122 | 初学一级 | 园豆:2
提问于:2024-07-17 11:50
< >
分享
所有回答(4)
0

换一台服务器安装试一试罗。

angelshelter | 园豆:9907 (大侠五级) | 2024-07-17 13:59
0

从提供的日志来看,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

NaughtyBee | 园豆:202 (菜鸟二级) | 2024-07-17 14:00
0

更新一下mysql,这可能是一个bug,在新版本里已经解决了

银弹社宾狗 | 园豆:202 (菜鸟二级) | 2024-07-19 12:31
0

你这个我遇到过一次,我重新安装了,就解决了

单字个6 | 园豆:160 (初学一级) | 2024-08-09 17:12
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册