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

Redo log overwritten/corrupted

    XMLWordPrintable

Details

    Description

      We have a system with fairly hight amount of deadlocking sessions. At some point (with no apparent precursor like application change or increase of load) it started reporting broken crash recovery (as if a redo log was overflown / overwritten), which results in an unusable database state. 

      2024-03-13  8:33:35 79392757 [ERROR] InnoDB: Crash recovery is broken due to insufficient innodb_log_file_size; last checkpoint LSN=13565873821532, current LSN=13581335735451. Shutdown is in progress.

      This happened on 2 occasions, first with version 10.5.21 and later on 10.5.24 too. Synced replica after failover succumbed to the same issue, not immediately, but within hour(s) in both cases as well.

      In the second case, redo has been increased to 16G with a wishful thinking it might prevent further issues (even though redo should be flushed to disk with a priority at certain thresholds 75/~90? if I am not wrong).

      Error log is modified (removed sensitive information, user disconnect and semaphore wait flood).

      Attachments

        1. mdbcfg.log
          1 kB
          Marek Hlavka
        2. mdberror.log
          38 kB
          Marek Hlavka

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14462 Confusing error message: ib_logfiles are too small for innodb_thread_concurrency=0

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21010 Mariadb hangs, stops responding to new connections

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27774 Reduce scalability bottlenecks in mtr_t::commit()

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29982 Improve the InnoDB log overwrite error message

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34830 LSN in the future is not being treated as serious corruption

          • Major - Major loss of function.
          • Closed

          Activity

            People

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