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

InnoDB deadlock output does not always include the full SQL statement

    XMLWordPrintable

Details

    Description

      The recent release of MySQL 8.0.35 includes the following change:
      Bug #23036096 - INNODB LAST DETECTED DEADLOCK NOT SHOWING FULL QUERY

      The function innobase_mysql_print_thd() reserves a 1024-byte buffer for the output of a function that in MariaDB has been renamed to thd_get_error_context_description(). At most 600 first bytes of the SQL string will be copied to the buffer. The above fix is increasing that limit to 3000 bytes.

      In MariaDB, at least starting with the fix of MDEV-15359, it is possible that no SQL statement will be output at all. In some MariaDB releases, there also was a lock order inversion problem that caused server hangs; see MDEV-13983 for some details.

      In MariaDB Server 10.6, the locking subsystem was greatly refactored by MDEV-20612, MDEV-24738 and other changes. Therefore, it could make sense to not fix this bug in earlier major versions.

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34645 truncated deadlock output

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13983 Mariadb becomes unresponsive

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15359 Thread stay in "cleaning up" status after finishing

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

          Task - A task that needs to be done. MDEV-30973 Enhance output of innodb deadlocks (SAMU-124, SAMU-131)

          • Major - Major loss of function.
          • In Review

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32579 Merge new release of InnoDB 5.7.44 to 10.4

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

          Activity

            People

              serg Sergei Golubchik
              marko Marko Mäkelä
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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