pt-online-schema-change fails with virtual columns
Bug #1400929 reported by
sblackstone@gmail.com
This bug affects 3 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Committed
|
Low
|
Carlos Salguero |
Bug Description
Using Maria 5.5
with a table with virtual (persistent) columns, it attempts to include those columns when inserting rows into the new table..
The error(warning) generated is -
# pt_online_
# Retry:3671 27978 Try code failed: Copying rows caused a MySQL error 1906:
# Level: Warning
# Code: 1906
# Message: The value specified for computed column 'is_aff_trans' in table '_transactions_new' ignored
Suggested behavior is that it should skip inserting the columns which are persistent and let them be re-computed when they are inserted by Maria instead..
description: | updated |
description: | updated |
Changed in percona-toolkit: | |
status: | New → Triaged |
importance: | Undecided → Low |
tags: | added: mariadb pt-online-schema-change |
tags: | added: i61246 |
information type: | Public → Public Security |
information type: | Public Security → Public |
description: | updated |
description: | updated |
tags: | added: pt202 |
Changed in percona-toolkit: | |
status: | Triaged → In Progress |
assignee: | nobody → Carlos Salguero (carlos-salguero) |
milestone: | none → 3.0.5 |
Changed in percona-toolkit: | |
status: | In Progress → Fix Committed |
To post a comment you must log in.
I'm using 2.2.7 by the way..