Percona Toolkit moved to https://jira.percona.com/projects/PT

pt-online-schema-change uses different keys for chunking and triggers

Bug #1003003 reported by Baron Schwartz on 2012-05-22

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	Percona Toolkit moved to https://jira.percona.com/projects/PT	Fix Released	Medium	Brian Fraser	Percona Toolkit moved to https://jira.percona.com/projects/PT 2.1.2

Bug Description

Someone Skype-chatted to me to mention that pt-online-schema-change appeared to chunk by primary key on his table, but chose the table's unique index for the triggers. This is probably not desirable. It may also lead to deadlocks.

Tags:

Related branches

lp:~percona-toolkit-dev/percona-toolkit/fix-1002448

Merged into lp:percona-toolkit/2.1 at revision 273

Brian Fraser (community): Approve on 2012-05-30

Daniel Nichter: Approve on 2012-05-29

Revision history for this message

Daniel Nichter (daniel-nichter) wrote on 2012-05-23:

Probably related to bug 1002448.

tags:	added: chunking pt-online-schema-change
Changed in percona-toolkit:
status:	New → Triaged
milestone:	none → 2.1.2

Daniel Nichter (daniel-nichter) on 2012-05-23

Changed in percona-toolkit:
importance:	Undecided → Medium
assignee:	nobody → Brian Fraser (fraserbn)

Brian Fraser (fraserbn) on 2012-05-30

Changed in percona-toolkit:
status:	Triaged → Fix Committed

Daniel Nichter (daniel-nichter) on 2012-06-19

Changed in percona-toolkit:
status:	Fix Committed → Fix Released

Revision history for this message

Shahriyar Rzayev (rzayev-sehriyar) wrote on 2018-01-24:

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-534

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.