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

Failing assertion: table->get_ref_count() == 0 or user_table->get_ref_count() == 1 when running ALTER TABLE

Details

    Description

      On a production server, we experience a crash during an alter table. I have attached the relevant entries from syslog (which is where MariaDB logs to), along with a similar SQL creation statement for the table that was altered. Unfortunately, the table in question was marked as crashed after the service restarted, and there was multiple entries per second being written to the error log about the table being crashed. Another member of the development team made the decision to drop the original table, and we don't have a backup of that table (it is a new table, being used as a summary table).

      The main known difference between the attached SQL for the table and the original is that the original had Foreign Keys to other tables. If you feel this might be relevant, I can attempt to find the foreign keys that were in place, along with the table definitions of those the target tables.

      MDEV-14021 has a similar crash (same assertion fail), so setting as relates to (I don't know enough about this bug to say if it is the same or not).

      Attachments

        1. MariaDb Crash.txt
          5 kB
        2. my.cnf
          6 kB
        3. syslog.portion
          15 kB
        4. table.sql
          3 kB

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16060 InnoDB: Failing assertion: ut_strcmp(index->name, key->name)

          • 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-17552 [Draft] Assertion `user_table->get_ref_count() == 1' failed in commit_try_rebuild

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14021 Failing assertion: table->get_ref_count() == 0 on ALTER TABLE with implicit ALGORITHM=INPLACE

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18062 Assertion `index' failed in ha_innobase::innobase_get_index or locking issues upon concurrent operations with foreign keys

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19539 Assertion failure in file /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.3.15/storage/innobase/row/row0merge.cc line 4509

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            rmhumphries Robert Humphries created issue -
            rmhumphries Robert Humphries made changes -
            Field Original Value New Value
            elenst Elena Stepanova made changes -
            Assignee Matthias Leich [ mleich ]
            elenst Elena Stepanova made changes -
            Fix Version/s 10.2 [ 14601 ]
            elenst Elena Stepanova made changes -
            Fix Version/s 10.2 [ 14601 ]
            elenst Elena Stepanova made changes -
            Fix Version/s 10.2 [ 14601 ]
            elenst Elena Stepanova made changes -
            Fix Version/s 10.2 [ 14601 ]
            bartbogdan Bart made changes -
            Attachment MariaDb Crash.txt [ 46650 ]
            elenst Elena Stepanova made changes -
            Assignee Matthias Leich [ mleich ]
            elenst Elena Stepanova made changes -
            Labels crash crash need_feedback
            rmhumphries Robert Humphries made changes -
            Attachment my.cnf [ 46781 ]
            elenst Elena Stepanova made changes -
            Labels crash need_feedback crash
            elenst Elena Stepanova made changes -
            Assignee Elena Stepanova [ elenst ]
            elenst Elena Stepanova made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            elenst Elena Stepanova made changes -
            Summary Failing assertion: table->get_ref_count() == 0 when running ALTER TABLE ADD COLUMN Failing assertion: table->get_ref_count() == 0 or when running ALTER TABLE
            elenst Elena Stepanova made changes -
            Summary Failing assertion: table->get_ref_count() == 0 or when running ALTER TABLE Failing assertion: table->get_ref_count() == 0 or user_table->get_ref_count() == 1 when running ALTER TABLE
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            Component/s Locking [ 10900 ]
            Fix Version/s 10.0 [ 16000 ]
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Affects Version/s 10.0 [ 16000 ]
            Affects Version/s 10.1 [ 16100 ]
            Affects Version/s 10.2 [ 14601 ]
            Affects Version/s 10.3 [ 22126 ]
            Affects Version/s 10.4 [ 22408 ]
            elenst Elena Stepanova made changes -
            Assignee Elena Stepanova [ elenst ] Marko Mäkelä [ marko ]
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            Labels crash affects-tests crash
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ] Sergey Vojtovich [ svoj ]
            svoj Sergey Vojtovich made changes -
            svoj Sergey Vojtovich made changes -
            Fix Version/s N/A [ 14700 ]
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.0 [ 16000 ]
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Resolution Duplicate [ 3 ]
            Status Confirmed [ 10101 ] Closed [ 6 ]
            alice Alice Sherepa made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 86381 ] MariaDB v4 [ 154092 ]

            People

              svoj Sergey Vojtovich
              rmhumphries Robert Humphries
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.