Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-5641

Multithreaded slave replication dead lock when set super_read_only to ON

Details

    • Bug
    • Status: Done
    • Medium
    • Resolution: Done
    • 8.0.15-6, 5.7.26-29
    • 8.0.23-14 (Q1 2021)
    • None
    • Red Hat Enterprise Linux Server release 6.3

    Description

      how to repeat:

      (1) master-slave, enable multithreaded replication.

      slave_parallel_type=LOGICAL_CLOCK

      slave_parallel_workers=16

      slave_preserve_commit_order=ON

      (2) write data on master by sysbench

      (3) execute sql on slave continually,sql:
      set global super_read_only=OFF; set global super_read_only=ON;

      when dead lock occur, show processlist as below:

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              zxb4221 zhangxiaobo
              Votes:
              1 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 4 hours, 30 minutes
                  4h 30m

                  Smart Checklist