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

MariaDB 10.6.11 - InnoDB: Assertion failure in file /home/buildbot/buildbot/build/storage/innobase/trx/trx0trx.cc line 1270

Details

    Description

      Hello all,

      one of our MariaDB instances keeps crashing once in a while with errors like the on below.
      The application connecting to the database is pimcore.

      We already checked/tried these things:

      • checked hardware (CPU/RAM)
      • checked configuration with MySQL Tuner
      • upgrade from 10.5.9 to 10.6.10
      • another update from MariaDB 10.6.10 to 10.6.11
      • build a new instance to seperate the databases
      • developer checked queries (also if too many queries at same time)
      • updates of pimcore

      We are running out of ideas and would be very thankful for support.

      This is the error-message from the last crash:

      2023-10-04 15:29:03 0x7fb205f1e700 InnoDB: Assertion failure in file /home/buildbot/buildbot/build/storage/innobase/trx/trx0trx.cc line 1270
      InnoDB: Failing assertion: UT_LIST_GET_LEN(lock.trx_locks) == 0
      InnoDB: We intentionally generate a memory trap.
      InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
      InnoDB: If you get repeated assertion failures or crashes, even
      InnoDB: immediately after the mariadbd startup, there may be
      InnoDB: corruption in the InnoDB tablespace. Please refer to
      InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
      InnoDB: about forcing recovery.
      231004 15:29:03 [ERROR] mysqld got signal 6 ;
      This could be because you hit a bug. It is also possible that this binary
      or one of the libraries it was linked against is corrupt, improperly built,
      or misconfigured. This error can also be caused by malfunctioning hardware.

      To report this bug, see https://mariadb.com/kb/en/reporting-bugs

      We will try our best to scrape up some info that will hopefully help
      diagnose the problem, but since we have already crashed,
      something is definitely wrong and this may fail.

      Server version: 10.6.11-MariaDB-log
      key_buffer_size=134217728
      read_buffer_size=131072
      max_used_connections=39
      max_threads=52
      thread_count=36
      It is possible that mysqld could use up to
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 245554 K bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.

      Thread pointer: 0x7fb1e00e49a8
      Attempting backtrace. You can use the following information to find out
      where mysqld died. If you see no messages after this, something went
      terribly wrong...
      stack_bottom = 0x7fb205f1dcc0 thread_stack 0x49000
      /DBA/mysql/SQL/5.7.latest/bin/mysqld(my_print_stacktrace+0x2e)[0x56512259429e]
      /DBA/mysql/SQL/5.7.latest/bin/mysqld(handle_fatal_signal+0x307)[0x565121f5b947]
      2023-10-04 15:29:05 0x7fb230ed4700 InnoDB: Assertion failure in file /home/buildbot/buildbot/build/storage/innobase/trx/trx0trx.cc line 1270
      InnoDB: Failing assertion: UT_LIST_GET_LEN(lock.trx_locks) == 0
      InnoDB: We intentionally generate a memory trap.
      InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
      InnoDB: If you get repeated assertion failures or crashes, even
      InnoDB: immediately after the mariadbd startup, there may be
      InnoDB: corruption in the InnoDB tablespace. Please refer to
      InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
      InnoDB: about forcing recovery.

      Attachments

        Issue Links

          Activity

            We just recently fixed one cause of this: MDEV-25163.

            marko Marko Mäkelä added a comment - We just recently fixed one cause of this: MDEV-25163 .

            Could this be a duplicate of MDEV-25163? That is, does this crash go away if you disable the rowid filter?

            marko Marko Mäkelä added a comment - Could this be a duplicate of MDEV-25163 ? That is, does this crash go away if you disable the rowid filter?

            Thank you for your very quick respond.
            I just had a look at MDEV-25163. It seems to be a slightly different path, but they have that in common '/home/buildbot/buildbot/'.
            Do you think, that the disabling of the rowid filter will be a solution here too?

            atte005 Sandra Attermeyer added a comment - Thank you for your very quick respond. I just had a look at MDEV-25163 . It seems to be a slightly different path, but they have that in common '/home/buildbot/buildbot/'. Do you think, that the disabling of the rowid filter will be a solution here too?
            atte005 Sandra Attermeyer added a comment - - edited

            Hi marko,

            are there any new developments concerning this bug?

            My colleague found this bug_report, which seems also to be connected with pimcore: MDEV-29536

            Best regards
            Sandra

            atte005 Sandra Attermeyer added a comment - - edited Hi marko , are there any new developments concerning this bug? My colleague found this bug_report, which seems also to be connected with pimcore: MDEV-29536 Best regards Sandra

            Hi, atte005. A fix of MDEV-25163 was only recently released, and we are yet to hear from any further crash reports when using the newest releases. Similar open reports include MDEV-24035 and MDEV-31780. One root cause when using the OQGraph storage engine was identified in MDEV-31941.

            Did you have a chance to update to the latest releases?

            marko Marko Mäkelä added a comment - Hi, atte005 . A fix of MDEV-25163 was only recently released, and we are yet to hear from any further crash reports when using the newest releases. Similar open reports include MDEV-24035 and MDEV-31780 . One root cause when using the OQGraph storage engine was identified in MDEV-31941 . Did you have a chance to update to the latest releases?

            People

              Unassigned Unassigned
              atte005 Sandra Attermeyer
              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.