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

Mariadb replication hangs

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6.8
    • None
    • None
    • None
    • Centos 7

    Description

      Hello.

      I have random hangs of replication on slave servers.
      I cannot kill SQL thread or restart mariadb when the issue arises.

      Here is some strace output. Nothing else happens.

      [pid 29054] futex(0x556d11c326f0, FUTEX_WAKE_PRIVATE, 1 <unfinished ...>
      [pid 33579] futex(0x556d10554d04, FUTEX_WAIT_BITSET_PRIVATE|FUTEX_CLOCK_REALTIME, 1215783, {tv_sec=1656738020, tv_nsec=74607000}, 0xffffffff <unfinished ...>
      [pid 29054] <... futex resumed>)        = 0
      [pid 29054] clock_gettime(CLOCK_REALTIME, {tv_sec=1656738019, tv_nsec=721983121}) = 0
      [pid 29054] futex(0x556d11c3fa04, FUTEX_WAIT_BITSET_PRIVATE|FUTEX_CLOCK_REALTIME, 874299, {tv_sec=1656738079, tv_nsec=721983121}, 0xffffffff <unfinished ...>
      [pid 33579] <... futex resumed>)        = -1 ETIMEDOUT (Connection timed out)
      [pid 33579] clock_gettime(CLOCK_REALTIME, {tv_sec=1656738020, tv_nsec=74849558}) = 0
      [pid 33579] futex(0x556d10554d40, FUTEX_WAKE_PRIVATE, 1) = 0
      [pid 33579] futex(0x556d10554d04, FUTEX_WAIT_BITSET_PRIVATE|FUTEX_CLOCK_REALTIME, 1215785, {tv_sec=1656738020, tv_nsec=474915000}, 0xffffffff <unfinished ...>
      [pid 34951] <... futex resumed>)        = -1 ETIMEDOUT (Connection timed out)
      [pid 34951] tgkill(33578, 33711, SIGUSR1) = 0
      [pid 33711] <... futex resumed>)        = ? ERESTARTSYS (To be restarted if SA_RESTART is set)
      [pid 34951] futex(0x556d131be2c8, FUTEX_WAKE_PRIVATE, 1 <unfinished ...>
      [pid 33711] --- SIGUSR1 {si_signo=SIGUSR1, si_code=SI_TKILL, si_pid=33578, si_uid=995} ---
      [pid 34951] <... futex resumed>)        = 0
      [pid 33711] rt_sigreturn({mask=[HUP INT QUIT PIPE ALRM TERM TSTP]} <unfinished ...>
      [pid 34951] futex(0x556d131be334, FUTEX_WAIT_BITSET_PRIVATE|FUTEX_CLOCK_REALTIME, 801, {tv_sec=1656738022, tv_nsec=109540000}, 0xffffffff <unfinished ...>
      [pid 33711] <... rt_sigreturn resumed>) = -1 EINTR (Interrupted system call)
      [pid 33711] futex(0x7f7798006b78, FUTEX_WAIT_PRIVATE, 2, NULL <unfinished ...>
      [pid 33579] <... futex resumed>)        = -1 ETIMEDOUT (Connection timed out)
      [pid 33579] clock_gettime(CLOCK_REALTIME, {tv_sec=1656738020, tv_nsec=475173531}) = 0
      [pid 33579] futex(0x556d10554d40, FUTEX_WAKE_PRIVATE, 1) = 0
      [pid 33579] futex(0x556d10554d04, FUTEX_WAIT_BITSET_PRIVATE|FUTEX_CLOCK_REALTIME, 1215787, {tv_sec=1656738020, tv_nsec=721893000}, 0xffffffff^Cstrace: Process 33578 detached
      

      Attachments

        1. mariadb_gdb.txt
          1.27 MB
        2. mariadb_gdb2.txt
          88 kB
        3. mariadb_gdb3.txt
          86 kB

        Activity

          People

            Unassigned Unassigned
            ykos Yevgeny Kosarzhevsky
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.