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

STOP SLAVE takes very long time on a busy system

    XMLWordPrintable

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 10.0, 10.1, 10.2.8, 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8
    • 10.4, 10.5, 10.6, 10.9, 10.10, 10.11
    • Replication
    • None
    • CentOS 7.4 x86_64

    Description

      150     system user             NULL    Slave_IO        66361   Waiting for master to send event        NULL    0.000
      152     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      153     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      154     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      155     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      156     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      157     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      158     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      159     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      160     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      162     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      161     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      163     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      151     system user             NULL    Slave_SQL       1090    Reading event from the relay log        NULL    0.000
      2415    root    127.0.0.1:42392 NULL    Query   835     Killing slave   STOP SLAVE      0.000
      

      slave machine configuration:

      sync_master_info          = 500000
      sync_relay_log            = 100000
      sync_relay_log_info       = 500000
      slave_parallel_max_queued = 67108864
      slave_parallel_mode       = optimistic
      slave_parallel_threads    = 12
      

      Is that normal?

      Attachments

        Issue Links

          Activity

            People

              bnestere Brandon Nesterenko
              mxu Michael Xu
              Votes:
              3 Vote for this issue
              Watchers:
              14 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.