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

STOP SLAVE SQL_THREAD should not be allowed under LTFB even if run from a different session

    XMLWordPrintable

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Won't Fix
    • None
    • None
    • None
    • None
    • Yes
    • Yes

    Description

      Currently, in the following scenario
      1. LOCK TABLE FOR BACKUP is executed in "session 1".
      2. STOP REPLICA is executed either
      2a. in the same session ("session 1")
      2b. in another session ("session 2").

      (2a) generates an ER_LOCK_OR_ACTIVE_TRANSACTION error
      (2b) succeeds

      (2b) must also generate an error.

      Attachments

        Issue Links

          created by

          New Feature - A new feature of the product, which has yet to be developed. PXB-2867 Return the behavior of safe-slave-backup before the lock-ddl implementation

          • Low - Minor issues that have minimal impact on the system's functionality or usability.
          • Done
          relates to

          Bug - A problem which impairs or prevents the functions of the product. PS-4758 A sequence of LOCK TABLES FOR BACKUP and STOP SLAVE SQL_THREAD can cause replication to be blocked and cannot be restarted normally

          • High - Significant issues that affect core functionality and should be resolved relatively soon.
          • Done

          Activity

            People

              Unassigned Unassigned
              yura.sorokin Yura Sorokin
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Smart Checklist