Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21843

innodb_encryption-page-compression crashes with "Assertion `first || buf_pool_get_dirty_pages_count(i d) == 0'

    XMLWordPrintable

Details

    Description

      innodb_encryption-page-compression crashes with:

      mysqld: /my/maria-10.5/storage/innobase/buf/buf0lru.cc:622: void buf_flush_dirty_pages(ulint, bool, ulint): Assertion `first || buf_pool_get_dirty_pages_count(id) == 0' failed.
      ....
      uf/buf0lru.cc:623(buf_flush_dirty_pages(unsigned long, bool, unsigned long))[0x136732f]
      mysqld: /my/maria-10.5/storage/innobase/buf/buf0lru.cc:622: void buf_flush_dirty
      mysqld: /my/maria-10.5/storage/innobase/buf/buf0lru.cc:622: void buf_flush_dirty
      _pages(ulint, bool, ulint): Assertion `first || buf_pool_get_dirty_pages_count(i
      d) == 0' failed.
      _pages(ulint, bool, ulint): Assertion `first || buf_pool_get_dirty_pages_count(i
      d) == 0' failed.
      buf/buf0lru.cc:636(buf_LRU_flush_or_remove_pages(unsigned long, bool, unsigned long))[0x123ec43]
      row/row0quiesce.cc:540(row_quiesce_table_start(dict_table_t*, trx_t*))[0x103a751]
      handler/ha_innodb.cc:15938(ha_innobase::external_lock(THD*, int))[0xc13db5]
      sql/handler.cc:6345(handler::ha_external_lock(THD*, int))[0xd495de]
      sql/lock.cc:392(lock_external(THD*, TABLE**, unsigned int))[0xd4928a]
      sql/lock.cc:337(mysql_lock_tables(THD*, st_mysql_lock*, unsigned int))[0xd49146]
      sql/lock.cc:300(mysql_lock_tables(THD*, TABLE**, unsigned int, unsigned int))[0x81ea59]
      sql/sql_base.cc:5499(lock_tables(THD*, TABLE_LIST*, unsigned int, unsigned int))[0x81df7c]
      sql/sql_base.cc:5219(open_and_lock_tables(THD*, DDL_options_st const&, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*))[0xa96f4d]
      sql/sql_base.h:278(open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*))[0xa980a6]
      sql/sql_reload.cc:566(flush_tables_with_read_lock(THD*, TABLE_LIST*))[0x8c54ac]
      sql/sql_parse.cc:5316(mysql_execute_command(THD*))[0x8cd806]
      

      Some variables:

      (gdb) p first
      $1 = 0
      (gdb) p id
      $2 = 13
      

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              monty Michael Widenius
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.