MySQL Bugs: #108186: mysqld got signal 11 when upgrade 8.0.29 to 8.0.30

Bug #108186	mysqld got signal 11 when upgrade 8.0.29 to 8.0.30
Submitted:	18 Aug 2022 9:28	Modified:	19 Sep 2022 13:37
Reporter:	Takuya Hasegawa	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	8.0.30	OS:	Ubuntu (20.04)
Assigned to:		CPU Architecture:	x86 (AMD Ryzen 7 Pro 5850U)

Description:
I tried In-Place upgrade MySQL Server to 8.0.30 from 8.0.29 but can not upgrade.

hread pointer: 0x55b7cb381180
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 = 7f120ec2aca0 thread_stack 0x100000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x55b7c62751b1]
/usr/sbin/mysqld(print_fatal_signal(int)+0x2f3) [0x55b7c51190d3]
/usr/sbin/mysqld(handle_fatal_signal+0xa5) [0x55b7c5119185]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x14420) [0x7f121bc98420]
/usr/sbin/mysqld(rec_get_offsets(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, ut::Location, mem_block_info_t**)+0x22) [0x55b7c65b0a02]
/usr/sbin/mysqld(Parallel_reader::Scan_ctx::copy_row(unsigned char const*, Parallel_reader::Scan_ctx::Iter*) const+0x41) [0x55b7c64eb301]
/usr/sbin/mysqld(Parallel_reader::Scan_ctx::create_persistent_cursor(page_cur_t const&, mtr_t*) const+0x21c) [0x55b7c64ed58c]
/usr/sbin/mysqld(Parallel_reader::Scan_ctx::create_range(std::vector<std::pair<std::shared_ptr<Parallel_reader::Scan_ctx::Iter>, std::shared_ptr<Parallel_reader::Scan_ctx::Iter> >, ut::allocator<std::pair<std::shared_ptr<Parallel_reader::Scan_ctx::Iter>, std::shared_ptr<Parallel_reader::Scan_ctx::Iter> >, ut::detail::allocator_base_pfs<std::pair<std::shared_ptr<Parallel_reader::Scan_ctx::Iter>, std::shared_ptr<Parallel_reader::Scan_ctx::Iter> > > > >&, page_cur_t&, mtr_t*) const+0x3d) [0x55b7c64ef70d]
/usr/sbin/mysqld(Parallel_reader::Scan_ctx::create_ranges(Parallel_reader::Scan_range const&, unsigned int, unsigned long, unsigned long, std::vector<std::pair<std::shared_ptr<Parallel_reader::Scan_ctx::Iter>, std::shared_ptr<Parallel_reader::Scan_ctx::Iter> >, ut::allocator<std::pair<std::shared_ptr<Parallel_reader::Scan_ctx::Iter>, std::shared_ptr<Parallel_reader::Scan_ctx::Iter> >, ut::detail::allocator_base_pfs<std::pair<std::shared_ptr<Parallel_reader::Scan_ctx::Iter>, std::shared_ptr<Parallel_reader:/usr/sbin/mysqld(Parallel_reader::Scan_ctx::partition(Parallel_reader::Scan_range const&, std::vector<std::pair<std::shared_ptr<Parallel_reader::Scan_ctx::Iter>, std::shared_ptr<Parallel_reader::Scan_ctx::Iter> >, ut::allocator<std::pair<std::shared_ptr<Parallel_reader::Scan_ctx::Iter>, std::shared_ptr<Parallel_reader::Scan_ctx::Iter> >, ut::detail::allocator_base_pfs<std::pair<std::shared_ptr<Parallel_reader::Scan_ctx::Iter>, std::shared_ptr<Parallel_reader::Scan_ctx::Iter> > > > >&, unsigned long)+0x151)/usr/sbin/mysqld(Parallel_reader::add_scan(trx_t*, Parallel_reader::Config const&, std::function<dberr_t (Parallel_reader::Ctx const*)>&&)+0x18f) [0x55b7c64f3a0f]
/usr/sbin/mysqld(ddl::Parallel_cursor::scan(std::vector<ddl::Builder*, ut::allocator<ddl::Builder*, ut::detail::allocator_base_pfs<ddl::Builder*> > >&)+0x7c6) [0x55b7c67205f6]
/usr/sbin/mysqld(ddl::Loader::scan_and_build_indexes()+0xca) [0x55b7c671b60a]
/usr/sbin/mysqld(ddl::Loader::build_all()+0xd8) [0x55b7c671b728]
/usr/sbin/mysqld(ddl::Context::build()+0x39) [0x55b7c670e319]
/usr/sbin/mysqld(bool ha_innobase::inplace_alter_table_impl<dd::Table>(TABLE*, Alter_inplace_info*)+0x3bf) [0x55b7c63a244f]
/usr/sbin/mysqld(ha_innobase::inplace_alter_table(TABLE*, Alter_inplace_info*, dd::Table const*, dd::Table*)+0x52) [0x55b7c63a2a32]
/usr/sbin/mysqld(+0x10e84c2) [0x55b7c504b4c2]
/usr/sbin/mysqld(mysql_alter_table(THD*, char const*, char const*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*)+0x51f9) [0x55b7c5060509]
/usr/sbin/mysqld(Sql_cmd_alter_table::execute(THD*)+0x4cc) [0x55b7c548789c]
/usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0xa00) [0x55b7c4fac620]
/usr/sbin/mysqld(+0x1079a17) [0x55b7c4fdca17]
/usr/sbin/mysqld(Prepared_statement::execute_server_runnable(Server_runnable*)+0x210) [0x55b7c4fdddd0]
/usr/sbin/mysqld(Ed_connection::execute_direct(Server_runnable*)+0x9e) [0x55b7c4fe1e0e]
/usr/sbin/mysqld(Ed_connection::execute_direct(MYSQL_LEX_STRING)+0x3f) [0x55b7c4fe1fef]
/usr/sbin/mysqld(+0x22bf84f) [0x55b7c622284f]
/usr/sbin/mysqld(dd::upgrade::upgrade_system_schemas(THD*)+0xd50) [0x55b7c6226cc0]
/usr/sbin/mysqld(+0x127b6a6) [0x55b7c51de6a6]
/usr/sbin/mysqld(+0x291fb1d) [0x55b7c6882b1d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x8609) [0x7f121bc8c609]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43) [0x7f121b43e133]

How to repeat:
$ systemctl stop mysql
$ apt update && apt upgrade

Add CPU model

Hi Mr. Hasegawa,

Thank you for your bug report.

However, you have not supplied us with all necessary info.

First of all, are you using our own build that you have downloaded from dev.mysql.com, or you are using Ubuntu build. If it is the later, we advise you to try our build.

Next, we need a full section of the  error log ... This includes the part of the messages before and during 8.0.29 and the entire part of 8.0.30 booting up ....

After that, we need a fully repeatable test case. However, this can wait until we analyse what you have sent us. In the case you used Ubuntu binary, we need to know first how did our binary behave.

There are some other reports on the problems in the update and we shall try to find them as your report could be a duplicate .......

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

We can not repeat it , due to the missing repeatable test case .......

Sorry team. I solved this.

MySQL Datadir was broken (maybe ibd or frm is corrupted) so I repaired all tables and in-place upgrade is working.