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

semisync thread can be killed after sync binlog but before ACK in the sync state

Details

    Description

      Shutdown of master in semisync when it's in sync can let more transactions in the master than the slaves.
      This is expected in case of a crash as the binlog write before send and wait for the ACK. But this is an issue in case of regular shutdown, as the workload can not be safely be moved to a slave.

      We can make sure the semi sync thread is killed last in shutdown and stopped only if status move to no sync or after receiving the ACK , this would possibly delay shutdown for the maximum time of the rpl_semi_sync_master_timeout

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-28114 Semi-sync Master ACK Receiver Thread Can Error on COM_QUIT

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28141 Slave crashes with Packets out of order when connecting to a shutting down master

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29369 rpl.rpl_semi_sync_shutdown_await_ack fails regularly with Result content mismatch

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32551 "Read semi-sync reply magic number error" warnings on master

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

          Activity

            Transition Time In Source Status Execution Times
            Brandon Nesterenko made transition -
            Open In Progress
            		1732d 16h 30m 1
            Brandon Nesterenko made transition -
            Stalled In Progress
            		3h 32m 1
            Brandon Nesterenko made transition -
            In Progress In Review
            		91d 14h 55m 2
            Andrei Elkin made transition -
            In Review Stalled
            		76d 15h 26m 2
            Brandon Nesterenko made transition -
            Stalled Closed
            		17d 8h 8m 1

            People

              bnestere Brandon Nesterenko
              stephane@skysql.com VAROQUI Stephane
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.