Issues
- pt-online-schema-change didn't rebuild constraintsPT-2439
- pt-online-schema-change has an uninitialised string causing it to abortPT-2431
- pt-table-checksum : Access denied for user 'root'@'localhost'PT-2429
- pt-archiver brokes when using output-format=csv and has null valuesPT-2410Sveta Smirnova
- pt-archiver throttling to prevent Galera node LagPT-2408Resolved issue: PT-2408
- pt-online-schema-change exit status(return code) is 0 even if it does NOT succeedPT-2407Sveta Smirnova
- pt-online-schema-change 'table does not exist' on macosPT-2401Sveta Smirnova
- pt-table-checksum reports the error for warning code 4164PT-2400Resolved issue: PT-2400Sveta Smirnova
- postgresqlcluster resource is not collectedPT-2396Sveta Smirnova
- pt-show-grants --convert-MariaDB not workingPT-2395
- pt-online-schema-change resume functionality doesn't work with ADD INDEXPT-2392Resolved issue: PT-2392Sveta Smirnova
- pt-online-schema-change loses data when changing a generated column to a regular columnPT-2391
- Version comparisons do not work with versions 10+PT-2390
- pt-online-schema-change resume functionality doesn't work with ADD/DROP columnPT-2389Resolved issue: PT-2389Sveta Smirnova
- pt-k8-debug-collector should have `kubectl get services`PT-2387Sveta Smirnova
- pt-k8-debug-collector should have SHOW GLOBAL VARIABLESPT-2386Sveta Smirnova
- pt-show-grants' --only should support wildcardsPT-2385
- Make pt-show-grants of validate_password pluginPT-2384
- pt-show-grants output unsupported syntax for users with DEFAULT ROLEPT-2383
- pt-query-digest : Data too long for column 'sample' at rowPT-2382
- pt-archiver cannot delete data on the source sidePT-2381
- pt-table-sync does print floating point numbers in SQL statements with insufficient precisionPT-2378Resolved issue: PT-2378Sveta Smirnova
- pt-table-sync does not handle utf8 strings in JSON columns correctlyPT-2377Resolved issue: PT-2377Sveta Smirnova
- pt-slave-restart cannot handle multiple GTIDsPT-2376Resolved issue: PT-2376
- pt-table-sync does not work with generated columnsPT-2375Resolved issue: PT-2375Sveta Smirnova
- pt-show-grants creates invalid DML for 8.0PT-2373
- pt-k8s-debug-collector is not getting certificate information and pg_gather if resource type is autoPT-2372Sveta Smirnova
- pt-summary errors out with "STATUS_THP_SYSTEM: unbound variable"PT-2371Resolved issue: PT-2371Sveta Smirnova
- Head's-up on contribution for Slow Query Log File and suggestion.PT-2370
- CVE reported in Percona Toolkit version 3.6.0 related to PERLPT-2367
- Remove either run-tests.sh or runtests.shPT-2365
- Update README.md, CONTRIBUTING.md and INSTALLPT-2364Sveta Smirnova
- pt-stalk - run after_collect following collect_system_data_loopPT-2363
- pt-table-checksum documentation wrong on PXC limitationPT-2362Sveta Smirnova
- pt-online-schema-change errors out when searching replicas through processlist when host and port are not explicitly setPT-2358
- Avoid running P_S.data_locks queries concurrently on pt-stalkPT-2357
- Every next run of pt-online-schema-change will result in an error and create a new table that won’t be cleaned upPT-2356
- pt-online-schema-change should not resume a job with empty boundariesPT-2355Sveta Smirnova
- pt-mongodb-summary cannot collect information from ARBITER memberPT-2354
- pt-deadlock-logger ignore deadlocks with mariadbPT-2351
- pt-table-sync failing to sync data from Pxc to async environment and trigger errors "WSREP detected deadlock/conflict and aborted the transaction."PT-2349
- t/pt-table-sync/specify_column_or_index.t fails with 5.7PT-2346
- Support MySQL 8.4PT-2340Resolved issue: PT-2340Sveta Smirnova
- pt-table-checksum reports error if recursion method is DSNPT-2250
- pt-table-sync stalls for indices with enumPT-2050
- pt-config-diff does not honor case insensitivity flagPT-2014
- pt-query-digest is not distinguish queries when alias is usedPT-1726
47 of 47
pt-online-schema-change didn't rebuild constraints
General
Escalation
General
Escalation
Description
Environment
None
Details
Assignee
UnassignedUnassignedReporter
Adrián CastilloAdrián CastilloPriority
CriticalComponents
Affects versions
Needs QA
Yes
Details
Details
Assignee
Unassigned
UnassignedReporter
Adrián Castillo
Adrián Castillo
Priority
CriticalComponents
Affects versions
Needs QA
Yes
Smart Checklist
Smart Checklist
Smart Checklist
Created April 4, 2025 at 1:53 PM
Updated April 4, 2025 at 1:53 PM
Activity
Show:
On the latest run of
pt-online-schema-change, we noticed that it did't rebuild the FK constraints.Execution parameters:
The output of execution:
But, we noticed that the FK on the child table did not point to the new renamed table, but to the t1_old table (output from
SHOW CREATE TABLEfrom child table):The pt-osc version: