Not the answer you need?
Register and ask your own question!

what's root cuase this problem when Percona Mysql auto restart this message error.

duyduy113duyduy113 Current User Role Beginner
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 ;

Comments

  • duyduy113duyduy113 Current User Role Beginner
    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 files
    2020-06-13T10:43:23.504518Z 0 [ERROR] [MY-010283] [Server] Error in accept: Too many open files
    2020-06-13T10:47:39.591014Z 0 [ERROR] [MY-010283] [Server] Error in accept: Too many open files
    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.
    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 binary
    or 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 information
    collection process might fail.
    Please help us make Percona Server better by reporting any

    key_buffer_size=33554432
    read_buffer_size=131072
    max_used_connections=1111
    max_threads=500
    thread_count=567
    connection_count=566
    It is possible that mysqld could use up to
    key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 248816 K  bytes of memory
    Hope that's ok; if not, decrease some variables in the equation.

    Thread pointer: 0x7f672c125b20
    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 = 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
  • duyduy113duyduy113 Current User Role Beginner
    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 files
    2020-06-13T10:43:23.504518Z 0 [ERROR] [MY-010283] [Server] Error in accept: Too many open files
    2020-06-13T10:47:39.591014Z 0 [ERROR] [MY-010283] [Server] Error in accept: Too many open files
    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.
    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 binary
    or 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 information
    collection process might fail.
    Please help us make Percona Server better by reporting any
    It is possible that mysqld could use up to
    key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 248816 K  bytes of memory
    Hope that's ok; if not, decrease some variables in the equation.
    Thread pointer: 0x7f672c125b20
    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 = 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]
  • vaibhav_upadhyay40vaibhav_upadhyay40 Contributor Current User Role Patron
    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.


Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.