Issues
- Fix for PT-1455 introduced new bugPT-1532
- pt-online-schema-change "Invalid utf8mb4 character string: 'A111E8'"PT-1528Resolved issue: PT-1528
- pt-table-checksum3.0.8 execution time is 50% longer than pt-tc3.0.4PT-1527Resolved issue: PT-1527Carlos Salguero
- Add ndb status to pt-mysql-summaryPT-1526Resolved issue: PT-1526Carlos Salguero
- Add MySQL 8 roles section to pt-mysql-summaryPT-1525Resolved issue: PT-1525Carlos Salguero
- pt-online-schema-change --data-dir fails to change directoryPT-1512Resolved issue: PT-1512
- pt-summary does not reliably read in the transparent huge pages settingPT-1507Resolved issue: PT-1507Carlos Salguero
- pt-table-checksum recognizes cluster node but doesn't follow the cluster recursion method automaticallyPT-1506
8 of 8
Fix for PT-1455 introduced new bug
General
Escalation
General
Escalation
Description
Environment
None
Attachments
1
Smart Checklist
Created April 14, 2018 at 7:16 PM
Updated January 13, 2024 at 8:05 PM
Activity
Lalit ChoudharyDecember 17, 2018 at 10:43 AM
Thank you for the report
Validated against current latest version pt-online-schema-change 3.0.12
Test:
Shashank SahniDecember 16, 2018 at 8:59 PM
Yes. This behavior is a bit unintuitive. Is it possible to just check for slave lag and not look for specific tables being copied?
The fix for --PT-1455-- (which allows a table to be altered even when there's replication filters on the slave that prevent the table from being created) introduced a new bug where the check for EXPLAINs on the slave side fails:
pt-online-schema-change --max-load=threads_running=500 --chunk-size=100000 --execute --progress=time,10 --max-lag=300 --nocheck-replication-filters --nocheck-plan --execute --alter="ADD COLUMN c CHAR(32)" D=test,t=norep1,u=msandbox,p=msandbox,P=20393,h=127.0.0.1 > /tmp/pt-osc.debug 2>&1
This explain is done when table is processed in a single chunk on the master side. See attached pt-osc.debug for full run.