Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  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

    • Bug
    • Status: Done
    • High
    • Resolution: Fixed
    • 8.0.16-7
    • 8.0.16-7
    • None

    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'

      Attachments

        Activity

          People

            satya.bodapati Satya Bodapati
            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

                Smart Checklist