Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-1455

LP #1730168: pt-online-schema-change is stuck when the table that is being altered is filtered out in the slave

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Fixed
    • None
    • 3.0.7
    • None

    Description

      **Reported in Launchpad by Jaime Sicam last update 05-01-2018 12:22:27

      pt-online-schema-change --execute --alter="engine=innodb" --no-check-replication-filters h=127.0.0.1,P=20594,u=root,p=msandbox,D=employees,t=titles --skip-check-slave-lag=h=127.0.0.1,P=20595,u=root,p=msandbox
      Found 2 slaves:
      kits-desktop -> SBslave1:20595
      kits-desktop -> SBslave2:20596
      Will check slave lag on:
      kits-desktop -> SBslave1:20595
      kits-desktop -> SBslave2:20596
      Operation, tries, wait:
      analyze_table, 10, 1
      copy_rows, 10, 0.25
      create_triggers, 10, 1
      drop_triggers, 10, 1
      swap_tables, 10, 1
      update_foreign_keys, 10, 1
      Altering `employees`.`titles`...
      Creating new table...
      Created new table employees._titles_new OK.
      Waiting forever for new table `employees`.`_titles_new` to replicate to kits-desktop...
      Waiting for kits-desktop: 0% 00:00 remain
      Waiting for kits-desktop: 0% 00:00 remain
      Waiting for kits-desktop: 0% 00:00 remain
      Waiting for kits-desktop: 0% 00:00 remain
      Waiting for kits-desktop: 0% 00:00 remain
      Waiting for kits-desktop: 0% 00:00 remain
      Waiting for kits-desktop: 0% 00:00 remain
      Waiting for kits-desktop: 0% 00:00 remain
      Waiting for kits-desktop: 0% 00:00 remain

      To reproduce, add a filter on the database of the slave's my.cnf config and restart:
      replicate-wild-ignore-table=employees.%

      Then try running pt-online-schema-change on a table of the filtered database on the master:
      pt-online-schema-change --execute --alter="engine=innodb" --no-check-replication-filters h=127.0.0.1,P=20594,u=root,p=msandbox,D=employees,t=titles

      Attachments

        Issue Links

          Activity

            People

              carlos.salguero Carlos Salguero (Inactive)
              sveta.smirnova Sveta Smirnova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 4 days
                  4d

                  Smart Checklist