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

Rowid filter does not process storage engine error correctly.

Details

    Description

      We had this crash on production database, but we cant see reason for this.
      It was not possible to restart the server again and got error message (see picture below).

      We managed to run it again by setting innodb_force_recovery=1. The server is running fine, but not knowing what caused this makes me worry

      Mar 15 15:59:54 mysql02-server mariadbd: 2021-03-15 15:59:54 3535477 [Warning] Sort aborted, host: web06, user: dbuser, thread: 3535477, 
      query: SELECT * FROM `******` WHERE id = 123 ORDER BY id ASC, id ASC LIMIT 1 FOR UPDATE
      Mar 15 15:59:54 mysql02-server mariadbd: 2021-03-15 15:59:54 0x7fc49e404700 
       InnoDB: Assertion failure in file /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.5.8/storage/innobase/trx/trx0trx.cc line 1336
      Mar 15 15:59:54 mysql02-server mariadbd: InnoDB: Failing assertion: UT_LIST_GET_LEN(lock.trx_locks) == 0
      Mar 15 15:59:54 mysql02-server mariadbd: InnoDB: We intentionally generate a memory trap.
      Mar 15 15:59:54 mysql02-server mariadbd: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
      Mar 15 15:59:54 mysql02-server mariadbd: InnoDB: If you get repeated assertion failures or crashes, even
      Mar 15 15:59:54 mysql02-server mariadbd: InnoDB: immediately after the mysqld startup, there may be
      Mar 15 15:59:54 mysql02-server mariadbd: InnoDB: corruption in the InnoDB tablespace. Please refer to
      Mar 15 15:59:54 mysql02-server mariadbd: InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
      Mar 15 15:59:54 mysql02-server mariadbd: InnoDB: about forcing recovery.
      Mar 15 15:59:54 mysql02-server mariadbd: 210315 15:59:54 [ERROR] mysqld got signal 6 ;
      Mar 15 15:59:54 mysql02-server mariadbd: This could be because you hit a bug. It is also possible that this binary
      Mar 15 15:59:54 mysql02-server mariadbd: or one of the libraries it was linked against is corrupt, improperly built,
      Mar 15 15:59:54 mysql02-server mariadbd: or misconfigured. This error can also be caused by malfunctioning hardware.
      Mar 15 15:59:54 mysql02-server mariadbd: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
      Mar 15 15:59:54 mysql02-server mariadbd: We will try our best to scrape up some info that will hopefully help
      Mar 15 15:59:54 mysql02-server mariadbd: diagnose the problem, but since we have already crashed,
      Mar 15 15:59:54 mysql02-server mariadbd: something is definitely wrong and this may fail.
      

      Attachments

        1. image-2021-03-16-13-47-55-914.png
          image-2021-03-16-13-47-55-914.png
          278 kB
        2. screenshot-1.png
          screenshot-1.png
          6 kB
        3. gdb_output.txt
          135 kB
        4. mariadb_log.txt
          20 kB

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Roel Van de Paar made transition -
            Open Closed
            48d 19h 37m 1
            Marko Mäkelä made transition -
            Closed Stalled
            44d 3h 40m 1
            Sergei Golubchik made transition -
            Stalled Open
            73d 21h 7m 1
            Marko Mäkelä made transition -
            Open Needs Feedback
            706d 23h 31m 1
            Marko Mäkelä made transition -
            Needs Feedback Open
            9d 19h 21m 1
            Vladislav Lesin made transition -
            Open In Progress
            29d 3h 15m 1
            Vladislav Lesin made transition -
            In Progress In Review
            16s 1
            Sergei Petrunia made transition -
            In Review Stalled
            10d 3h 45m 1
            Vladislav Lesin made transition -
            Stalled Closed
            3h 26m 1

            People

              vlad.lesin Vladislav Lesin
              ingig Ingi Gauti Ragnarsson
              Votes:
              3 Vote for this issue
              Watchers:
              12 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.