отваливается mysql

[alev013]

Добрый день.

периодически падает mysql
zabbix 5.0

в логах mysql появляется такая запись:

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.
2020-09-16T07:49:25.937447Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.17) starting as process 607266
2020-09-16T07:49:27.672152Z 0 [System] [MY-010229] [Server] Starting crash recovery...
2020-09-16T07:49:27.686791Z 0 [System] [MY-010232] [Server] Crash recovery finished.
2020-09-16T07:49:27.715973Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-09-16T07:49:27.736610Z 0 [System] [MY-010931] [Server] /usr/libexec/mysqld: ready for connections. Version: '8.0.17' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution.
2020-09-16T07:49:27.908690Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/lib/mysql/mysqlx.sock' bind-address: '::' port: 33060
07:49:29 UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x7f538cbcc890
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 = 7f5414135d50 thread_stack 0x46000
/usr/libexec/mysqld(my_print_stacktrace(unsigned char*, unsigned long)+0x41) [0x5567c86c32b1]
/usr/libexec/mysqld(handle_fatal_signal+0x333) [0x5567c77d61a3]
/lib64/libpthread.so.0(+0x12dd0) [0x7f543247cdd0]
/usr/libexec/mysqld(page_cur_search_with_match_bytes(buf_block_ t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, unsigned long*, unsigned long*, page_cur_t*)+0x19a) [0x5567c8856a0a]
/usr/libexec/mysqld(btr_cur_search_to_nth_level(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, unsigned long, btr_cur_t*, unsigned long, char const*, unsigned long, mtr_t*)+0x1afc) [0x5567c89b026c]
/usr/libexec/mysqld(row_search_on_row_ref(btr_pcur_t*, unsigned long, dict_table_t*, dtuple_t const*, mtr_t*)+0xa9) [0x5567c88dc239]
/usr/libexec/mysqld(row_get_clust_rec(unsigned long, unsigned char const*, dict_index_t const*, dict_index_t**, mtr_t*)+0xc8) [0x5567c88dc3b8]
/usr/libexec/mysqld(row_vers_impl_x_locked(unsigned char const*, dict_index_t const*, unsigned long const*)+0x13c) [0x5567c88ff8dc]
/usr/libexec/mysqld(+0x1fe82a6) [0x5567c87fc2a6]
/usr/libexec/mysqld(lock_sec_rec_read_check_and_lock(lock_durat ion_t, buf_block_t const*, unsigned char const*, dict_index_t*, unsigned long const*, select_mode, lock_mode, unsigned long, que_thr_t*)+0x21b) [0x5567c880168b]
/usr/libexec/mysqld(+0x20cfdda) [0x5567c88e3dda]
/usr/libexec/mysqld(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long)+0x1fa4) [0x5567c88e8e44]
/usr/libexec/mysqld(ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int)+0xd3) [0x5567c878c8d3]
/usr/libexec/mysqld(handler::ha_index_next(unsigned char*)+0x200) [0x5567c78e5880]
/usr/libexec/mysqld(handler::read_range_next()+0x3f) [0x5567c78eadcf]
/usr/libexec/mysqld(handler::multi_range_read_next(char**)+0x49 ) [0x5567c78ed259]
/usr/libexec/mysqld(handler::ha_multi_range_read_next(char**)+0 x2c) [0x5567c78e9f4c]
/usr/libexec/mysqld(QUICK_RANGE_SELECT::get_next()+0x5a) [0x5567c75c891a]
/usr/libexec/mysqld(IndexRangeScanIterator::Read()+0x37) [0x5567c75fda27]
/usr/libexec/mysqld(Sql_cmd_delete::delete_from_single_table(TH D*)+0xccd) [0x5567c76570fd]
/usr/libexec/mysqld(Sql_cmd_dml::execute(THD*)+0x418) [0x5567c76f64a8]
/usr/libexec/mysqld(mysql_execute_command(THD*, bool)+0x1480) [0x5567c76a1fd0]
/usr/libexec/mysqld(mysql_parse(THD*, Parser_state*)+0x363) [0x5567c76a6323]
/usr/libexec/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x2d44) [0x5567c76a9574]
/usr/libexec/mysqld(do_command(THD*)+0x1bc) [0x5567c76aa06c]
/usr/libexec/mysqld(+0xfb37e0) [0x5567c77c77e0]
/usr/libexec/mysqld(+0x23b6250) [0x5567c8bca250]
/lib64/libpthread.so.0(+0x82de) [0x7f54324722de]
/lib64/libc.so.6(clone+0x43) [0x7f542fbbde83]

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

проблема возникла после перехода с 4 версии на 5
Подскажите что с этим делать

[dedy]

варианты есть вроде
https://dba.stackexchange.com/questi...uncate-command