Please i dont know why mysql is creashing with signal 11. I saw that on the error log and my my.cnf is having just:
[mysqld]
disable-log-bin = 1
default-authentication-plugin = mysql_native_password
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
log-error = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid
innodb_buffer_pool_size = 27487790694
max_allowed_packet = 268435456
open_files_limit = 40000
innodb_file_per_table = 1
mysqlx = 0
max_connections=1000
innodb_flush_log_at_trx_commit = 2
innodb_thread_concurrency = 16
tmp_table_size=637M
max_heap_table_size=637M
table_open_cache = 4000
thread_cache_size=100
innodb_buffer_pool_instances=26
join_buffer_size=3M
key_buffer_size=1G
interactive_timeout=1000
wait_timeout=1000
innodb_redo_log_capacity=6G
skip-name-resolve=0
table_definition_cache=10000
innodb_log_buffer_size=40M
performance_schema=ON
performance-schema-consumer-events-statements-history-long=ON
performance-schema-consumer-events-statements-history=ON
performance-schema-consumer-events-statements-current=ON
performance-schema-consumer-events-stages-current=ON
performance-schema-consumer-events-stages-history=ON
performance-schema-consumer-events-stages-history-long=ON
performance-schema-consumer-events-transactions-current=ON
performance-schema-consumer-events-transactions-history=ON
performance-schema-consumer-events-transactions-history-long=ON
performance-schema-consumer-events-waits-current=ON
performance-schema-consumer-events-waits-history=ON
performance-schema-consumer-events-waits-history-long=ON
performance-schema-instrument='%=ON'
max-digest-length=2048
performance-schema-max-digest-length=2018
Error @ mysqld.log is
2024-08-03T00:33:07.059009Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-08-03T00:33:12.791604Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-08-03T00:33:13Z UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=90e7d8b8c8ddb4292c2ef4bd058ca8ad682f78fb
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)+0x41) [0x15a85d1]
/usr/sbin/mysqld(print_fatal_signal(int)+0x3c7) [0xbe2cd7]
/usr/sbin/mysqld(handle_fatal_signal+0x80) [0xbe2e60]
/lib64/libc.so.6(+0x3e6f0) [0x7fc73f63e6f0]
/usr/sbin/mysqld(Validate_files::check(__gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, std::allocator<dd::Tablespace const*> > > const&, __gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, std::allocator<dd::Tablespace const*> > > const&, unsigned long)+0x7a0) [0x15e9750]
/usr/sbin/mysqld() [0x160820c]
/lib64/libstdc++.so.6(+0xdbad4) [0x7fc73fadbad4]
/lib64/libc.so.6(+0x89c02) [0x7fc73f689c02]
/lib64/libc.so.6(+0x10ec40) [0x7fc73f70ec40]
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-08-03T00:33:13.000000Z 0 [System] [MY-013951] [Server] 2024-08-03T00:33:13Z UTC - mysqld got signal 11 ;
2024-08-03T00:33:13.000001Z 0 [System] [MY-013951] [Server] Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
2024-08-03T00:33:13.000002Z 0 [System] [MY-013951] [Server] BuildID[sha1]=90e7d8b8c8ddb4292c2ef4bd058ca8ad682f78fb
2024-08-03T00:33:13.000003Z 0 [System] [MY-013951] [Server] Thread pointer: 0x0
2024-08-03T00:33:13.000004Z 0 [System] [MY-013951] [Server] Attempting backtrace. You can use the following information to find out
2024-08-03T00:33:13.000005Z 0 [System] [MY-013951] [Server] where mysqld died. If you see no messages after this, something went
2024-08-03T00:33:13.000006Z 0 [System] [MY-013951] [Server] terribly wrong...
2024-08-03T00:33:13.000007Z 0 [System] [MY-013951] [Server] stack_bottom = 0 thread_stack 0x100000
2024-08-03T00:33:13.000008Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x15a85d1]
2024-08-03T00:33:13.000009Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld(print_fatal_signal(int)+0x3c7) [0xbe2cd7]
2024-08-03T00:33:13.000010Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld(handle_fatal_signal+0x80) [0xbe2e60]
2024-08-03T00:33:13.000011Z 0 [System] [MY-013951] [Server] /lib64/libc.so.6(+0x3e6f0) [0x7fc73f63e6f0]
2024-08-03T00:33:13.000012Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld(Validate_files::check(__gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, std::allocator<dd::Tablespace const*> > > const&, __gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, std::allocator<dd::Tablespace const*> > > const&, unsigned long)+0x7a0) [0x15e9750]
2024-08-03T00:33:13.000013Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld() [0x160820c]
2024-08-03T00:33:13.000014Z 0 [System] [MY-013951] [Server] /lib64/libstdc++.so.6(+0xdbad4) [0x7fc73fadbad4]
2024-08-03T00:33:13.000015Z 0 [System] [MY-013951] [Server] /lib64/libc.so.6(+0x89c02) [0x7fc73f689c02]
2024-08-03T00:33:13.000016Z 0 [System] [MY-013951] [Server] /lib64/libc.so.6(+0x10ec40) [0x7fc73f70ec40]
2024-08-03T00:33:13.000017Z 0 [System] [MY-013951] [Server] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
2024-08-03T00:33:13.000018Z 0 [System] [MY-013951] [Server] information that should help you find out what is causing the crash.
2024-08-03T00:33:15.490045Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2024-08-03T00:33:15.490130Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.38-cll-lve) starting as process 2802630
2024-08-03T00:33:15.494404Z 0 [System] [MY-013951] [Server] A backtrace was processed and added to the main error-log in the appropriate format.
2024-08-03T00:33:15.499126Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
I even changed the my.cnf to the minimal
[mysqld]
disable-log-bin = 1
default-authentication-plugin = mysql_native_password
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
log-error = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid
mysqld did not start. I can’t even backup my database at all because mysqldump is not working.
I also tried innodb_force_recovery=1 but still thesame
New contributor
Bikendi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.