Assertion failure: buf0lru.cc:672:err == DB_INTERRUPTED || err == DB_FAIL || buf_pool_get_dirty_pages_count(buf_pool, id, observer) == 0

Description

While testing on latest 8.0, following crash has been encountered. The crash may not reproducible in single thread. Below is the stack trace:
stack_bottom = 7f713418ed18 thread_stack 0x46000
/home/mohit.joshi/PS050819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(my_print_stacktrace(unsigned char*, unsigned long)+0x55) [0x48088b8]
/home/mohit.joshi/PS050819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(handle_fatal_signal+0x2c6) [0x363a1a1]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390) [0x7f71553eb390]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38) [0x7f71536c3428]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a) [0x7f71536c502a]
/home/mohit.joshi/PS050819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x1aa) [0x4db560b]
/home/mohit.joshi/PS050819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld() [0x4e98dc2]
/home/mohit.joshi/PS050819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld() [0x4e994ad]
/home/mohit.joshi/PS050819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(buf_LRU_flush_or_remove_pages(unsigned int, buf_remove_t, trx_t const*, bool)+0x80) [0x4e99547]
/home/mohit.joshi/PS050819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(fsp_alter_encrypt_tablespace(THD*, unsigned int, unsigned int, bool, bool, void*)+0x99c) [0x4fc274e]
/home/mohit.joshi/PS050819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld() [0x4a78cbf]
/home/mohit.joshi/PS050819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld() [0x4a79121]
/home/mohit.joshi/PS050819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld() [0x4a7afc8]
/home/mohit.joshi/PS050819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(Sql_cmd_alter_tablespace::execute(THD*)+0x4e6) [0x3536f3e]
/home/mohit.joshi/PS050819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(mysql_execute_command(THD*, bool)+0x61fe) [0x34483a8]
/home/mohit.joshi/PS050819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(mysql_parse(THD*, Parser_state*, bool)+0x6cd) [0x344ae79]
/home/mohit.joshi/PS050819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x1571) [0x343f3a2]
/home/mohit.joshi/PS050819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(do_command(THD*)+0x50b) [0x343d7bb]
/home/mohit.joshi/PS050819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld() [0x36239bf]
/home/mohit.joshi/PS050819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld() [0x4902764]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba) [0x7f71553e16ba]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d) [0x7f715379541d]
 
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7f7074159a98): ALTER TABLESPACE tab04k ENCRYPTION 'Y'

Environment

None

Smart Checklist

Activity

Show:
Done

Details

Assignee

Reporter

Time tracking

6h 30m logged

Fix versions

Affects versions

Priority

Smart Checklist

Created August 6, 2019 at 5:40 AM
Updated March 6, 2024 at 11:58 AM
Resolved August 7, 2019 at 5:11 PM

Flag notifications