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

Crashing on a corrupted page is unhelpful

    XMLWordPrintable

    Details

      Description

      InnoDB is notoriously aborting the whole MariaDB server if it is trying to access a corrupted page.
      MDEV-12253 alleviated the issue somewhat, but not for background processing, such as the purge of no-longer-needed history.
      This bug exists in all InnoDB and XtraDB versions.
      MariaDB essentially must fix MySQL Bug#10132 Crashing the server on corrupt InnoDB page is unhelpful that was filed on April 25, 2005.

      In 10.3 with MDEV-12288 and MDEV-13536, the InnoDB purge threads will access pages more often, causing all sorts of debug assertion failures in the B-tree code. To work around this problem, tests that intentionally cause B-tree pages to be unreadable are amended with the following parameters, so that everything will be purged before the server is restarted to deal with the corruption:

      --innodb-purge-rseg-truncate-frequency=1
      		 
      --skip-innodb-fast-shutdown

        Attachments

          Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15827 Running mariabackup with insufficient system privileges cause crash / coredump

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18519 0x7f0118195700 InnoDB: Assertion failure in file /home/buildbot/buildbot/build/mariadb-10.3.7/storage/innobase/btr/btr0cur.cc line 4308

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21098 indexes in subquery causing MariaDB crash ???

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22388 Corrupted undo log record leads to server crash

          • Major - Major loss of function.
          • Open
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16497 Server crashes on corrupted pages during DROP TABLE

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26550 [FATAL] [ERROR] mysqld got signal 6 ;InnoDB: Aborting because of a corrupt database page.

          • Critical - Crashes, loss of data, severe memory leak.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12112 corruption in encrypted table may be overlooked

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13680 InnoDB may crash when btr_page_alloc() fails

          • Major - Major loss of function.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17810 Improve error printout when decryption fails or we identify page as both encrypted and unencrypted

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17957 Make Innodb_checksum_algorithm stricter for strict_* values

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17958 Make bug-endian innodb_checksum_algorithm=crc32 optional

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18025 Mariabackup fails to detect corrupted page_compressed=1 tables

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18026 Make mariabackup option to double read the pages from data file.

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18691 Failing assertion: page_is_comp(next_page) == page_is_comp(page) in btr0pcur.cc

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18932 MariaDB 10.3.10-10.3.13 corrupts table and refuses to start with assertion in row0sel.cc 2986

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19081 DB crashes periodicly with - InnoDB: Assertion failure

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19541 InnoDB crashes when trying to recover a corrupted page

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21030 MariaDB keepts crashing on start

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21513 Fix some crashes in ALTER TABLE…IMPORT TABLESPACE

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21863 InnoDB: Assertion failure rem0rec.cc 1878

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22373 Unable to find a record to delete-mark ends up crashing mysqld process after upgrading from 10.1.43 to 10.4

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22481 Server crash after access to table with imported tablespace (after restart)

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22624 mariadb used for wordpress restarts and crashes continuously

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23344 InnoDB: Fatal: Trying to access page number 57 in space 182 space name zabbix/items.

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23734 InnoDB: File (unknown): 'read' returned OS error 205. Cannot continue operation

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-11125 Introduce a reduced doublewrite mode, handling error detection only

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12253 Buffer pool blocks are accessed after they have been freed

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-12288 Reset DB_TRX_ID when the history is removed, to speed up MVCC

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13536 DB_TRX_ID is not actually being reset when the history is removed

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13559 encryption.innodb-redo-badkey failed in buildbot

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14132 innodb.innodb-64k failed in buildbot, lost connection to server

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

          Task - A task that needs to be done. MDEV-14481 Execute InnoDB crash recovery in the background

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16763 SIGNAL 6 ERROR

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17482 InnoDB fails to say which fatal error fsync() returned

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17638 Improve error message about corruption of encrypted page

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17641 start slave and mariadb server crash

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17947 mariabackup SST encounters InnoDB tablespace errors during prepare, ignores them, server crashes

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

          Task - A task that needs to be done. MDEV-18115 Remove dummy tablespace for the redo log

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18529 InnoDB wrongly skips decryption of encrypted page if unencrypted and post-encrypted checksums match

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18606 innodb crashes on large update and it gets corrupted

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19711 Assertion failure during IMPORT TABLESPACE

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20931 ALTER...IMPORT can crash the server

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24287 mysqlcheck unexpectedly causes table to be marked as corrupt

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24412 Mariadb 10.5: InnoDB: Upgrade after a crash is not supported

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24578 MariaDB 10.5 fails to join Galera cluster of MariaDB 10.1, root cause SST failure, symptom is InnoDB: Assertion failure

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26537 InnoDB corrupts files due to incorrect st_blksize calculation

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

          Web Link Intentionally cause an I/O error in Linux?

            Activity

              People

              Assignee:
              marko Marko Mäkelä
              Reporter:
              marko Marko Mäkelä
              Votes:
              7 Vote for this issue
              Watchers:
              22 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration