Hi all
Pls help me know what’s the root cause of the error with message bellow. At that time, MySQL will automatically restart. How I can do resolve this problem ?
2020-06-13T10:49:22.120854Z 16315919 [ERROR] [MY-010833] [Server] MYSQL_BIN_LOG::open_crash_safe_index_file failed to open temporary index file.
2020-06-13T10:49:22.123452Z 16315919 [ERROR] [MY-010835] [Server] MYSQL_BIN_LOG::add_log_to_index failed to open the crash safe index file.
10:49:22 UTC - mysqld got signal 6 ;
more information about server crash before auto restart
020-06-13T10:39:07.417765Z 0 [ERROR] [MY-010283] [Server] Error in accept: Too many open files2020-06-13T10:43:23.504518Z 0 [ERROR] [MY-010283] [Server] Error in accept: Too many open files2020-06-13T10:47:39.591014Z 0 [ERROR] [MY-010283] [Server] Error in accept: Too many open files2020-06-13T10:49:22.120854Z 16315919 [ERROR] [MY-010833] [Server] MYSQL_BIN_LOG::open_crash_safe_index_file failed to open temporary index file.2020-06-13T10:49:22.123452Z 16315919 [ERROR] [MY-010835] [Server] MYSQL_BIN_LOG::add_log_to_index failed to open the crash safe index file.2020-06-13T10:49:22.124962Z 16315919 [ERROR] [MY-011072] [Server] Binary logging not possible. Message: Either disk is full, file system is read only or there was an encryption error while opening the binlog. Aborting the server…10:49:22 UTC - mysqld got signal 6 ;This could be because you hit a bug. It is also possible that this binaryor one of the libraries it was linked against is corrupt, improperly built,or misconfigured. This error can also be caused by malfunctioning hardware.Attempting to collect some information that could help diagnose the problem.As this is a crash and something is definitely wrong, the informationcollection process might fail.Please help us make Percona Server better by reporting anybugs at https://bugs.percona.com/
key_buffer_size=33554432read_buffer_size=131072max_used_connections=1111max_threads=500thread_count=567connection_count=566It is possible that mysqld could use up tokey_buffer_size + (read_buffer_size + sort_buffer_size)max_threads = 248816 K bytes of memoryHope that’s ok; if not, decrease some variables in the equation.
Thread pointer: 0x7f672c125b20Attempting backtrace. You can use the following information to find outwhere mysqld died. If you see no messages after this, something wentterribly wrong…stack_bottom = 7f62fe7f9d70 thread_stack 0x46000/usr/sbin/mysqld(my_print_stacktrace(unsigned char, unsigned long)+0x3d) [0x1d7e9fd]/usr/sbin/mysqld(handle_fatal_signal+0x4c1) [0x1056ad1]/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390) [0x7f676e854390]/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38) [0x7f676c902428]/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a) [0x7f676c90402a]/usr/sbin/mysqld() [0x19f40d6]/usr/sbin/mysqld(MYSQL_BIN_LOG::open_binlog(char const*, char const*, unsigned long, bool, bool, bool, Format_description_log_event*, unsigned int)+0xb72) [0x1a05f22]/usr/sbin/mysqld(MYSQL_BIN_LOG::new_file_impl(bool, Format_description_log_event*)+0xadd) [0x1a0749d]/usr/sbin/mysqld(MYSQL_BIN_LOG::rotate(bool, bool*)+0x4d) [0x1a07b8d]/usr/sbin/mysqld(MYSQL_BIN_LOG::ordered_commit(THD*, bool, bool)+0x71e) [0x1a0e9de]/usr/sbin/mysqld(MYSQL_BIN_LOG::commit(THD*, bool)+0x909) [0x1a0fe39]/usr/sbin/mysqld(ha_commit_trans(THD*, bool, bool)+0x4bc) [0xcac81c]/usr/sbin/mysqld(trans_commit(THD*, bool)+0x73) [0x1018aa3]/usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0xa9e) [0xf1a12e]/usr/sbin/mysqld(mysql_parse(THD*, Parser_state*, bool, bool)+0x47c) [0xf1ed0c]/usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x3167) [0xf222e7]/usr/sbin/mysqld(do_command(THD*)+0x200) [0xf23100]/usr/sbin/mysqld() [0x1044c90]
Pls help me known w
Hi all, I add more error logs information about server crash before auto restart
Pls help me know what’s about problem, is this bug?
020-06-13T10:39:07.417765Z 0 [ERROR] [MY-010283] [Server] Error in accept: Too many open files2020-06-13T10:43:23.504518Z 0 [ERROR] [MY-010283] [Server] Error in accept: Too many open files2020-06-13T10:47:39.591014Z 0 [ERROR] [MY-010283] [Server] Error in accept: Too many open files2020-06-13T10:49:22.120854Z 16315919 [ERROR] [MY-010833] [Server] MYSQL_BIN_LOG::open_crash_safe_index_file failed to open temporary index file.2020-06-13T10:49:22.123452Z 16315919 [ERROR] [MY-010835] [Server] MYSQL_BIN_LOG::add_log_to_index failed to open the crash safe index file.2020-06-13T10:49:22.124962Z 16315919 [ERROR] [MY-011072] [Server] Binary logging not possible. Message: Either disk is full, file system is read only or there was an encryption error while opening the binlog. Aborting the server…10:49:22 UTC - mysqld got signal 6 ;This could be because you hit a bug. It is also possible that this binaryor one of the libraries it was linked against is corrupt, improperly built,or misconfigured. This error can also be caused by malfunctioning hardware.Attempting to collect some information that could help diagnose the problem.As this is a crash and something is definitely wrong, the informationcollection process might fail.Please help us make Percona Server better by reporting anybugs at System Dashboard - Percona JIRA is possible that mysqld could use up tokey_buffer_size + (read_buffer_size + sort_buffer_size)max_threads = 248816 K bytes of memoryHope that’s ok; if not, decrease some variables in the equation.Thread pointer: 0x7f672c125b20Attempting backtrace. You can use the following information to find outwhere mysqld died. If you see no messages after this, something wentterribly wrong…stack_bottom = 7f62fe7f9d70 thread_stack 0x46000/usr/sbin/mysqld(my_print_stacktrace(unsigned char, unsigned long)+0x3d) [0x1d7e9fd]/usr/sbin/mysqld(handle_fatal_signal+0x4c1) [0x1056ad1]/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390) [0x7f676e854390]/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38) [0x7f676c902428]/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a) [0x7f676c90402a]/usr/sbin/mysqld() [0x19f40d6]/usr/sbin/mysqld(MYSQL_BIN_LOG::open_binlog(char const*, char const*, unsigned long, bool, bool, bool, Format_description_log_event*, unsigned int)+0xb72) [0x1a05f22]/usr/sbin/mysqld(MYSQL_BIN_LOG::new_file_impl(bool, Format_description_log_event*)+0xadd) [0x1a0749d]/usr/sbin/mysqld(MYSQL_BIN_LOG::rotate(bool, bool*)+0x4d) [0x1a07b8d]/usr/sbin/mysqld(MYSQL_BIN_LOG::ordered_commit(THD*, bool, bool)+0x71e) [0x1a0e9de]/usr/sbin/mysqld(MYSQL_BIN_LOG::commit(THD*, bool)+0x909) [0x1a0fe39]/usr/sbin/mysqld(ha_commit_trans(THD*, bool, bool)+0x4bc) [0xcac81c]/usr/sbin/mysqld(trans_commit(THD*, bool)+0x73) [0x1018aa3]/usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0xa9e) [0xf1a12e]/usr/sbin/mysqld(mysql_parse(THD*, Parser_state*, bool, bool)+0x47c) [0xf1ed0c]/usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x3167) [0xf222e7]/usr/sbin/mysqld(do_command(THD*)+0x200) [0xf23100]/usr/sbin/mysqld() [0x1044c90]
Hi @duyduy113 ,
Looking at the errors chronology , it appears that server/vm and MySQL are short of open_file_limit.
Please check open_file_limit on OS and MySQL both. set it to maximum value and check it this helps.
Note:
Once you set open file limit on OS level after that you also need to configure the same in my.cnf for MySQL.
If you need help on how to check and command to setup this limit, please share OS/MySQL version details.