Sample Header Ad - 728x90

Cannot start mysql server. Error

-2 votes
1 answer
1025 views
I'm on Ubuntu 20.4 and did some apt update/upgrade. Not sure what package was changed, but I'm unable to start my mysql server due to these error: === 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. 2022-06-09T04:05:14.093531Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead. 2022-06-09T04:05:14.093553Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.29-0ubuntu0.20.04.3) starting as process 1974 2022-06-09T04:05:14.097652Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2022-06-09T04:05:14.895737Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2022-06-09T04:05:15.184723Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2022-06-09T04:05:15.184755Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2022-06-09T04:05:15.208172Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock 2022-06-09T04:05:15.208213Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.29-0ubuntu0.20.04.3' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu). 04:05:15 UTC - mysqld got signal 11 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x7f854c000b60 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 = 7f85667fbc10 thread_stack 0x78000 /usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x5632646f8ad1] /usr/sbin/mysqld(print_fatal_signal(int)+0x2fb) [0x5632635997db] /usr/sbin/mysqld(handle_fatal_signal+0xa5) [0x563263599895] /lib/x86_64-linux-gnu/libpthread.so.0(+0x14420) [0x7f85e376e420] /usr/sbin/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*)+0x1c2) [0x56326484f482] /usr/sbin/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*)+0x1f62) [0x5632649c0c82] /usr/sbin/mysqld(row_search_on_row_ref(btr_pcur_t*, unsigned long, dict_table_t*, dtuple_t const*, mtr_t*)+0xd3) [0x5632648c40b3] /usr/sbin/mysqld(+0x2452899) [0x5632648ba899] /usr/sbin/mysqld(+0x24532d1) [0x5632648bb2d1] /usr/sbin/mysqld(row_purge_step(que_thr_t*)+0x92a) [0x5632648bf33a] /usr/sbin/mysqld(que_run_threads(que_thr_t*)+0xe28) [0x563264870348] /usr/sbin/mysqld(srv_worker_thread()+0x580) [0x5632648fc400] /usr/sbin/mysqld(std::thread::_State_impl > >::_M_run()+0xbc) [0x56326480208c] /lib/x86_64-linux-gnu/libstdc++.so.6(+0xd6de4) [0x7f85e2cc5de4] /lib/x86_64-linux-gnu/libpthread.so.0(+0x8609) [0x7f85e3762609] /lib/x86_64-linux-gnu/libc.so.6(clone+0x43) [0x7f85e29b2133] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0): is an invalid pointer Connection ID (thread ID): 0 Status: NOT_KILLED === Stuck and my web sites are down. Any help regarding the bug or reverting all the update the last hours appreciated.
Asked by user42124 (1 rep)
Jun 9, 2022, 04:15 AM
Last activity: Jun 9, 2022, 07:23 PM