Closed3

pt-online-schema-change は Generated Column を扱えない

エラーはこんな感じ


2016-08-11T17:55:29 Error copying rows from cache to _cache_new:

2016-08-11T17:55:29 DBD::mysql::st execute failed: The value specified for generated column 'score' in table '_cache_new' is not allowed.

[for Statement "INSERT LOW_PRIORITY IGNORE INTO _cache_new (domain, company, companyjson, score) SELECT domain, company, companyjson, score FROM cache FORCE INDEX(PRIMARY) WHERE ((domain >= ?)) AND ((domain <= ?)) LOCK IN SHARE MODE /pt-online-schema-change 23000 copy nibble/" with ParamValues:] at /usr/bin/pt-online-schema-change line 10805.


https://jira.percona.com/browse/PT-815?focusedCommentId=220370&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-220370

このスクラップは2021/07/07にクローズされました
ログインするとコメントできます