MySQL Forums
Forum List  »  Chinese

MySQL突然crash报错Error in `/usr/sbin/mysqld': double free or corruption (!prev): 0x00007fce8c0258e0
Posted by: YINGYIFNEG YING
Date: September 12, 2024 02:42AM

MySQL突然自动重启了,MySQL版本是8.0.27,且监控显示主机cpu内存都正常,数据库也没有做过变更。

以下是MySQL的error日志记录的相关信息,麻烦各位分析一下

*** Error in `/usr/sbin/mysqld': double free or corruption (!prev): 0x00007fce8c0258e0 ***
======= Backtrace: =========
/lib64/libc.so.6(+0x81329)[0x7fda3bbb8329]
/usr/sbin/mysqld(_ZN8MEM_ROOT10FreeBlocksEPNS_5BlockE+0x23)[0x1fb9f43]
/usr/sbin/mysqld(_Z14free_tmp_tableP5TABLE+0x10b)[0xe5daab]
/usr/sbin/mysqld(_ZN4JOIN7destroyEv+0x2a9)[0xdfcad9]
/usr/sbin/mysqld(_ZN11Query_block7cleanupEP3THDb+0x75)[0xe6d755]
/usr/sbin/mysqld(_ZN16Query_expression7cleanupEP3THDb+0x8e)[0xe6d92e]
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THDb+0xa8a)[0xd9c6da]
/usr/sbin/mysqld(_Z20dispatch_sql_commandP3THDP12Parser_state+0x412)[0xd9fdc2]
/usr/sbin/mysqld(_Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command+0xe0e)[0xda10ee]
/usr/sbin/mysqld(_Z10do_commandP3THD+0x194)[0xda3194]
/usr/sbin/mysqld[0xed9c70]
/usr/sbin/mysqld[0x248d630]
/lib64/libpthread.so.0(+0x7ea5)[0x7fda3d87aea5]
/lib64/libc.so.6(clone+0x6d)[0x7fda3bc35b0d]
======= Memory map: ========
00400000-037d0000 r-xp 00000000 08:02 1490 /usr/sbin/mysqld
037d0000-03945000 r--p 033cf000 08:02 1490 /usr/sbin/mysqld
03945000-03ccf000 rw-p 03544000 08:02 1490 /usr/sbin/mysqld
03ccf000-041f9000 rw-p 00000000 00:00 0
0565c000-0d2e0000 rw-p 00000000 00:00 0 [heap]
7fcac8000000-7fcae8000000 rw-p 00000000 00:00 0
7fcae8000000-7fcb08000000 rw-s 00000000 08:02 33562377 /tmp/#33562377 (deleted)
7fcb18000000-7fcb28000000 rw-s 00000000 08:02 33554525 /tmp/#33554525 (deleted)
7fcb38000000-7fcb60000000 rw-p 00000000 00:00 0
这一段有点长,类似的我直接跳到最后一段
7ffcc81c0000-7ffcc81c2000 r-xp 00000000 00:00 0 [vdso]
ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall]
05:29:52 UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x7fce8c003730
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 = 7fcefb8fec70 thread_stack 0x100000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x3d) [0x1fc33bd]
/usr/sbin/mysqld(handle_fatal_signal+0x30b) [0xee902b]
/lib64/libpthread.so.0(+0xf630) [0x7fda3d882630]
/lib64/libc.so.6(gsignal+0x37) [0x7fda3bb6d387]
/lib64/libc.so.6(abort+0x148) [0x7fda3bb6ea78]
/lib64/libc.so.6(+0x78f67) [0x7fda3bbaff67]
/lib64/libc.so.6(+0x81329) [0x7fda3bbb8329]
/usr/sbin/mysqld(MEM_ROOT::FreeBlocks(MEM_ROOT::Block*)+0x23) [0x1fb9f43]
/usr/sbin/mysqld(free_tmp_table(TABLE*)+0x10b) [0xe5daab]
/usr/sbin/mysqld(JOIN::destroy()+0x2a9) [0xdfcad9]
/usr/sbin/mysqld(Query_block::cleanup(THD*, bool)+0x75) [0xe6d755]
/usr/sbin/mysqld(Query_expression::cleanup(THD*, bool)+0x8e) [0xe6d92e]
/usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0xa8a) [0xd9c6da]
/usr/sbin/mysqld(dispatch_sql_command(THD*, Parser_state*)+0x412) [0xd9fdc2]
/usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0xe0e) [0xda10ee]
/usr/sbin/mysqld(do_command(THD*)+0x194) [0xda3194]
/usr/sbin/mysqld() [0xed9c70]
/usr/sbin/mysqld() [0x248d630]
/lib64/libpthread.so.0(+0x7ea5) [0x7fda3d87aea5]
/lib64/libc.so.6(clone+0x6d) [0x7fda3bc35b0d]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7fce8c0008e8): SELECT b.* FROM VIEW_SPLITER_WITH_NONULL_COORDINATE b WHERE (b.lat_radius >= 0.529081873335674e0 AND b.lat_radius <= 0.5291445879372011e0) AND (b.lon_radius >= 2.1001055711686654e0 and b.lon_radius <= 2.1001782201540538e0) AND acos(sin(0.5291132306364376e0) * sin(lat_radius) + cos(0.5291132306364376e0) * cos(b.lat_radius) * cos(b.lon_radius - 2.1001418956613596e0)) <= 3.135730076355027e-05 and exists(select 1 from org_area a left join region_space rm on a.area_id = rm.id left join department d on a.organize_id = d.id where d.id in (select d1.id from my_user_data_auth a left join my_user mu on a.user_id = mu.id left join department d1 on a.org_id = d1.id where a
Connection ID (thread ID): 154255880
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.
2024-09-12T13:30:01.270376+08:00 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-commercial) starting as process 25317
2024-09-12T13:30:01.290550+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-09-12T13:30:08.297337+08:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-09-12T13:30:12.090760+08:00 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2024-09-12T13:30:12.097686+08:00 0 [System] [MY-010232] [Server] XA crash recovery finished.
2024-09-12T13:30:14.108847+08:00 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2024-09-12T13:30:14.108891+08:00 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2024-09-12T13:30:14.111384+08:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-09-12T13:30:14.111451+08:00 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-09-12T13:30:14.165426+08:00 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.27-commercial' socket: '/tmp/mysql.sock' port: 3306 MySQL Enterprise Server - Commercial

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL突然crash报错Error in `/usr/sbin/mysqld': double free or corruption (!prev): 0x00007fce8c0258e0
347
September 12, 2024 02:42AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.