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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 8.0.15-6, 5.7.26-29
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Environment:

      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:

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Unassigned
                Reporter:
                zxb4221 zhangxiaobo
                Votes:
                0 Vote for this issue
                Watchers:
                9 Start watching this issue

                  Dates

                  Created:
                  Updated:

                    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