ERROR args count differs from table column count in BuildDMLInsertQuery
- Dominant language
- Go
- Stars
- 13.6k
- Forks
- 1.4k
- Avg merge
- 2h 31m
- Merged PRs (30d)
- 4
Description
gh-ost 1.0.48
table : table rows :67748199
cmd:
gh-ost --aliyun-rds --max-load=Threads_running=200 --critical-load=Threads_running=200 --host="xxxx" --port=3306 --assume-master-host=xxxx --user="xxxx" --password="xxxxx" --database="xxx" --table="oauth_user" --alter="ADD boundTime BIGINT(20) NOT NULL DEFAULT 0 COMMENT ''" --verbose --allow-on-master --allow-master-master --assume-rbr --default-retries=3 --replica-server-id=78583 --critical-load-interval-millis=8000 --serve-socket-file=/tmp/oauth_user.sock --initially-drop-socket-file --ok-to-drop-table --panic-flag-file=/tmp/oauth_user1.flag --throttle-flag-file=/tmp/oauth_user3.flag --postpone-cut-over-flag-file=/tmp/oauth_user2.flag --execute
INFO starting gh-ost 1.0.48
。
。
。
2020-03-09 23:47:08 INFO Dropping magic cut-over table
2020-03-09 23:47:08 INFO Releasing lock from `tutor_oauth`.`oauth_user`, `tutor_oauth`.`_oauth_user_del`
2020-03-09 23:47:08 INFO Tables unlocked
2020-03-09 23:47:27 INFO Tables renamed
2020-03-09 23:47:28 ERROR args count differs from table column count in BuildDMLInsertQuery
2020-03-09 23:47:28 INFO Grabbing voluntary lock: gh-ost.47090413.lock
2020-03-09 23:47:28 INFO Setting LOCK timeout as 6 seconds
2020-03-09 23:47:28 INFO Looking for magic cut-over table
2020-03-09 23:47:28 ERROR Expected magic comment on _oauth_user_del, did not find it
2020-03-09 23:47:28 INFO Looking for magic cut-over table
2020-03-09 23:47:28 ERROR Expected magic comment on _oauth_user_del, did not find it
2020-03-09 23:47:29 ERROR args count differs from table column count in BuildDMLInsertQuery
2020-03-09 23:47:29 INFO Grabbing voluntary lock: gh-ost.47090413.lock
2020-03-09 23:47:29 INFO Setting LOCK timeout as 6 seconds
2020-03-09 23:47:29 INFO Looking for magic cut-over table
2020-03-09 23:47:29 ERROR Expected magic comment on _oauth_user_del, did not find it
2020-03-09 23:47:29 INFO Looking for magic cut-over table
2020-03-09 23:47:29 ERROR Expected magic comment on _oauth_user_del, did not find it
2020-03-09 23:47:29 INFO Removing socket file: /tmp/ghost.oauth_user.sock
2020-03-09 23:47:29 INFO Tearing down inspector
2020-03-09 23:47:29 FATAL Expected magic comment on _oauth_user_del, did not find it
2020-03-09 23:47:29 INFO Tearing down applier
Error occurs in the cut over stage. The table has been renamed. Is the cut over normal? Will data be lost?
Contributor guide
Assessment
This issue has not been assessed yet.