github / github/gh-ost

ERROR args count differs from table column count in BuildDMLInsertQuery

Open
#828 3 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.