Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-5827

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

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 8.0.16-7
    • Fix Version/s: 8.0.16-7
    • Component/s: None
    • Labels:

      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'

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                satya.bodapati Satya Bodapati
                Reporter:
                mohit.joshi Mohit Joshi
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 6 hours, 30 minutes
                  6h 30m