8.0.27, and 8.0.29 unable to restore backup taken from 8.0.26

hi Folks,
We were using

That build seems to have been removed as we are now getting
E: Version '8.0.26-18-1.bionic' for 'percona-xtrabackup-80' was not found when we try to install it on new host.

So we tried using 8.0.27 MyRocks and Xtrabackup on a new host to restore from backup taken by earlier build (8.0.26), and it seems to crash when it tries to “start slave”. This is the stack trace we found in error log. We see same stack trace even if we use 8.0.29 MyRocks and Xtrabackup as well.

11:00:17 UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.

Build ID: a9fa9e3f0b519ac6b75e0806a6e6e156bb57c4be
Server Version: 8.0.27-18 Percona Server (GPL), Release '18', Revision '24801e21b45'

Thread pointer: 0x7f68d1419000
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...

/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f) [0x7f68f864d61f]
stack_bottom = 7f68e8d4dd58 thread_stack 0x40000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x3d) [0x55f72cf76f5d]*
*/usr/sbin/mysqld(handle_fatal_signal+0x3c3) [0x55f72c1d7e83]*
*/lib/x86_64-linux-gnu/libpthread.so.0(+0x12980) [0x7f68fa4e9980]*
*/usr/lib/mysql/plugin/ha_rocksdb.so(myrocks::rdb_should_hide_ttl_rec(myrocks::Rdb_key_def const&, rocksdb::Slice const&, myrocks::Rdb_transaction*)+0x79) [0x7f68d5b5a657]
/usr/lib/mysql/plugin/ha_rocksdb.so(myrocks::Rdb_iterator_base::get(rocksdb::Slice const*, rocksdb::PinnableSlice*, myrocks::Rdb_lock_type, bool, bool)+0x1bb) [0x7f68d5b960cb]
/usr/lib/mysql/plugin/ha_rocksdb.so(myrocks::ha_rocksdb::check_and_lock_unique_pk(myrocks::ha_rocksdb::update_row_info const&, bool*, bool)+0xc5) [0x7f68d5b5b8a9]*
*/usr/lib/mysql/plugin/ha_rocksdb.so(myrocks::ha_rocksdb::check_uniqueness_and_lock(myrocks::ha_rocksdb::update_row_info const&, bool, bool)+0x80) [0x7f68d5b7fc0e]*
*/usr/lib/mysql/plugin/ha_rocksdb.so(myrocks::ha_rocksdb::update_write_row(unsigned char const*, unsigned char const*, bool)+0x1f7) [0x7f68d5b804d5]*
*/usr/lib/mysql/plugin/ha_rocksdb.so(myrocks::ha_rocksdb::write_row(unsigned char*)+0x5d) [0x7f68d5b80545]
/usr/sbin/mysqld(handler::ha_write_row(unsigned char*)+0x1a4) [0x55f72bd93b44]*
*/usr/sbin/mysqld(Write_rows_log_event::write_row(Relay_log_info const*, bool)+0xfd) [0x55f72cc137cd]
/usr/sbin/mysqld(Write_rows_log_event::do_exec_row(Relay_log_info const*)+0x19) [0x55f72cc13b89]*
*/usr/sbin/mysqld(Rows_log_event::do_apply_row(Relay_log_info const*)+0x26) [0x55f72cc00076]
/usr/sbin/mysqld(Rows_log_event::do_apply_event(Relay_log_info const*)+0x1353) [0x55f72cc1f7f3]*
*/usr/sbin/mysqld(slave_worker_exec_job_group(Slave_worker*, Relay_log_info*)+0x171) [0x55f72cc9e1f1]
/usr/sbin/mysqld(+0x1e9b50b) [0x55f72cca550b]
/usr/sbin/mysqld(+0x2680e34) [0x55f72d48ae34]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76db) [0x7f68fa4de6db]

Any clue on why 8.0.27 and 8.0.29 are unable to restore backup taken from older build 8.0.26?


1 Like

Can you please check if you are facing this rocksdb issue?

May be it is not related to backup

1 Like

Thanks a lot Satya! Yes it is the issue. It seems like that issue has been fixed in FB branch? Any estimate of when it will make it to Percona MyRocks?

1 Like

@satya.bodapati has the fix been ported to Percona MyRocks yet? if so, which build? Thanks!