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

InnoDB: Failing assertion: space->n_pending_ops == 0

Details

    Description

      When a tablespace is being removed from the InnoDB tablespace cache, we occasionally have an assertion failing in 10.2:

      2017-04-27 10:38:42 0x4538  InnoDB: Assertion failure in file D:\win32-debug\build\src\storage\innobase\fil\fil0fil.cc line 2875
      		 
      InnoDB: Failing assertion: space->n_pending_ops == 0

      This has failed at least twice in 10.2:
      non-debug x86, Debian Stretch
      debug x86, Microsoft Windows

      The likely cause is the MDEV-12428 fix, which allows I/O threads to increment the fil_space_t::n_pending_ops count even after the tablespace has been marked for dropping.

      We must review the code also in 10.1 before the 10.1.23 release.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11581 Mariadb starts innodb encryption threads when key has not changed or data scrubbing turned off

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11738 Mariadb uses 100% of several of my 8 cpus doing nothing

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11929 During delete: InnoDB: Assertion failure in thread 139757855127296 in file buf0buf.cc line 4803

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12253 Buffer pool blocks are accessed after they have been freed

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12396 MariaDB Server SEGV crash when importing tablespace for a large table (4GB)

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12428 SIGSEGV in buf_page_decrypt_after_read() during DDL

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12637 main.range_vs_index_merge_innodb fails in buildbot with timeout

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12694 test failure: encryption.create_or_replace hangs during DROP for CREATE OR REPLACE TABLE

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12898 encryption.innodb-redo-badkey failed in buildbot, server hung on startup

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            marko Marko Mäkelä created issue -
            marko Marko Mäkelä made changes -
            Field Original Value New Value
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            marko Marko Mäkelä added a comment -

            bb-10.2-marko
            I think that we need this patch also in the 10.1.23 release. For that, we must backport the two-phase freeing of fil_space_t (fil_space_detach(), fil_space_free_low()) from 10.2.

            marko Marko Mäkelä added a comment - bb-10.2-marko I think that we need this patch also in the 10.1.23 release. For that, we must backport the two-phase freeing of fil_space_t (fil_space_detach(), fil_space_free_low()) from 10.2.
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ] Jan Lindström [ jplindst ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            jplindst Jan Lindström (Inactive) added a comment -

            ok to push even without considering my comments, they were just stylistic, technically this patch is correct.

            jplindst Jan Lindström (Inactive) added a comment - ok to push even without considering my comments, they were just stylistic, technically this patch is correct.
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Jan Lindström [ jplindst ] Marko Mäkelä [ marko ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            marko Marko Mäkelä added a comment -

            bb-10.1-marko

            marko Marko Mäkelä added a comment - bb-10.1-marko
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ] Jan Lindström [ jplindst ]
            Status Stalled [ 10000 ] In Review [ 10002 ]
            jplindst Jan Lindström (Inactive) added a comment -

            ok to push.

            jplindst Jan Lindström (Inactive) added a comment - ok to push.
            jplindst Jan Lindström (Inactive) made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Jan Lindström [ jplindst ] Marko Mäkelä [ marko ]
            marko Marko Mäkelä made changes -
            issue.field.resolutiondate 2017-04-28 14:16:22.0 2017-04-28 14:16:22.069
            marko Marko Mäkelä made changes -
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 80489 ] MariaDB v4 [ 152024 ]

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.