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

MariaDB server getting stuck when ntp server switch time in midst of start up

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 10.6.16, 10.11.6
    • 10.6, 10.11
    • Server
    • None
    • MLOS is based out of CentOS 7.

      Linux MLOS-NSM 4.19.245-3.mlos3.x86_64 #1 SMP Wed Jul 19 06:01:56 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux

    Description

      The Mariadb process become non-responsive in 1-3 days time after its start in environment where NTP is enabled.

      This could be specifically seen when the ntp server switches system time in the middle on mariadb server start up.

      Checking the process list on DB shows all the queries in stuck state

      below is strace on the mariadb server process :

      The issue is not seen on 10.6.14-MariaDB-log MariaDB Server . The problems start appearing after we upgraded to 10.6.16-MariaDB-log MariaDB Server & 10.11.6-MariaDB-log

      Attachments

        1. image-2024-07-23-21-09-50-259.png
          45 kB
          Ullas Ramakrishnan
        2. image-2024-07-23-21-11-07-279.png
          75 kB
          Ullas Ramakrishnan
        3. image-2024-07-23-21-12-30-739.png
          587 kB
          Ullas Ramakrishnan
        4. image-2024-07-23-21-14-07-364.png
          3 kB
          Ullas Ramakrishnan
        5. mariadb.strace.out
          3 kB
          Ullas Ramakrishnan
        6. mariadbd_full_bt_all_threads_29Jun_after_30_sec.txt
          745 kB
          Ullas Ramakrishnan
        7. mariadbd_full_bt_all_threads_29Jun.txt
          745 kB
          Ullas Ramakrishnan
        8. mariadbd_full_bt_all_threads.txt
          745 kB
          Ullas Ramakrishnan
        9. ntp.logs
          11 kB
          Ullas Ramakrishnan
        10. processlist.sql
          31 kB
          Ullas Ramakrishnan

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32861 InnoDB hangs when running out of I/O slots

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33669 mariabackup --backup hangs

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33820 Deadlock if system time changes repeatedly during concurrent INSERTs

          • 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-33594 Invoking log_free_check() while holding exclusive dictionary latch may block most InnoDB threads for a long time

          • Major - Major loss of function.
          • Confirmed

          Activity

            People

              danblack Daniel Black
              ullasram Ullas Ramakrishnan
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.