Details

    • Bug
    • Status: Done
    • Medium
    • Resolution: Invalid
    • 5.7.25-31.35
    • None
    • None
    • None

    Description

      With 5.7.22-29.26 and 5.7.24-31.33,  a ddl blocks the donor during a SST.   That wasn't the case with 5.6.  On the donor the receive queue grows very large until the SST completes.  Local writes are also blocked.

       

      here's 2 threads on the donor:

      }}{{*************************** 11. row ***************************
      {{ Id: 14}}
      {{ User: root}}
      {{ Host: localhost}}
      {{ db: test}}
      {{ Command: Query}}
      {{ Time: 305}}
      {{ State: Waiting for backup lock}}
      {{ Info: create table test2 (id int)}}
      {{ Rows_sent: 0}}
      Rows_examined: 0
      *************************** 12. row ***************************
      {{ Id: 15}}
      {{ User: root}}
      {{ Host: localhost}}
      {{ db: test}}
      {{ Command: Query}}
      {{ Time: 139}}
      {{ State: wsrep: initiating pre-commit for write set (2)}}
      {{ Info: insert into testtable (data) values (now())}}
      {{ Rows_sent: 0}}
      Rows_examined: 0

       

      Attachments

        Issue Links

          Activity

            People

              zsolt.parragi Zsolt Parragi
              yves@percona.com Yves Trudeau
              Votes:
              2 Vote for this issue
              Watchers:
              12 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 - 5 hours, 56 minutes
                  5h 56m

                  Smart Checklist