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

            Activity

              People

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

                Dates

                Created:
                Updated: