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

systemd: EXTEND_TIMEOUT_USEC= to avoid startup and shutdown timeouts

Details

    • 10.3.6-1

    Description

      MDEV-9202, MDEV-8509 shows cases where the systemd timeout isn't sufficient to preform initialization/shut-down.

      Since https://github.com/systemd/systemd/commit/a327431bd168b2f327f3cd422379e213c643f2a5 released in system v236 Type=notify service can now advice to the systemd service manager they are still working to avoid the service timing out.

      The use of EXTEND_TIMEOUT_USEC= on older services has no effect and is therefore compatible.

      This needs to be included in (feel free to correct/extend):

      • buffer pool dump - buf_dump (storage/innobase/buf/buf0dump.cc)
      • redo log recovery - log_group_read_log_seg (storage/innobase/log/log0log.cc)
      • undo recovery - recv_recover_page_func (storage/innobase/log/log0recv.cc)
      • change buffer?
      • merge buffer?

      I was planning on making the 15 seconds of recv_sys_t->report() more general with respect to interval, and use a define INNODB_REPORT_INTERVAL (include/univ.i?) as the basis for this form of watchdog. I'd send notify messages of INNODB_REPORT_INTERVAL * 2 as an acceptable margin.

      Anywhere else or other suggestions marko, jplindst?

      • galera SST scripts - donor and recipient

      Any other server/engine slow points to account for?

      Target 10.3 and then look at a backport?

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16149 Failing assertion: node->modification_counter == node->flush_counter with innodb_flush_method=O_DSYNC

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16150 Mariadb 10.3.6 Failing assertion on Docker

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17003 service_manager_extend_timeout() being called too often

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11027 InnoDB log recovery is too noisy

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12323 Rollback progress log messages during crash recovery are intermixed with unrelated log messages

          • 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-12352 InnoDB shutdown should not be blocked by a large transaction rollback

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15554 InnoDB page_cleaner shutdown sometimes hangs

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-15832 With innodb_fast_shutdown=3, skip the rollback of connected transactions

          • 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-17571 Make systemd timeout behavior more compatible with long Galera SSTs

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17934 Make systemd timeout behavior more compatible with longer Galera recovery times

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18224 MTR's internal check of the test case 'innodb.recovery_shutdown' failed due to extra #sql-ib*.ibd files

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9202 Systemd timeout is not sufficient for larger servers

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11035 Restore removed disallow-writes for Galera

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15606 Galera can't perform SST in 10.2.13 if systemd in use due to timeout at startup

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15607 mysqld crashed few after node is being joined with sst

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17571 Make systemd timeout behavior more compatible with long Galera SSTs

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

          Activity

            People

              marko Marko Mäkelä
              danblack Daniel Black
              Votes:
              1 Vote for this issue
              Watchers:
              8 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.