gh-ost
gh-ost copied to clipboard
ERROR Error 1146: Table '<db>._temp_no_ghc' doesn't exist
I am using this command:
./gh-ost --azure=true --host="host" --database="db-name" --user="user" --password="password" --ssl-ca=DigiCertGlobalRootG2.crt.pem --ssl=true --ssl-allow-insecure=true --assume-rbr --allow-on-master=true --alter="ALTER TABLE temp_no ADD COLUMN tempID int NULL DEFAULT NULL"
Error:
[2024/07/09 17:19:44] [info] binlogsyncer.go:374 begin to sync binlog from position (mysql-bin.000112, 77638393)
[2024/07/09 17:19:44] [info] binlogsyncer.go:791 rotate to (mysql-bin.000112, 77638393)
# Migrating `<db>`.`temp_no`; Ghost table is `<db>`.`_temp_no_gho`
# Migration started at Tue Jul 09 17:19:43 -0400 2024
# chunk-size: 1000; max-lag-millis: 1500ms; dml-batch-size: 10; max-load: ; critical-load: ; nice-ratio: 0.000000
# throttle-additional-flag-file: /tmp/gh-ost.throttle
# Serving on unix socket: /tmp/gh-ost.<db>.temp_no.sock
Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 1s(total), 0s(copy); streamer: mysql-bin.000112:77643330; Lag: 0.12s, HeartbeatLag: 0.02s, State: migrating; ETA: due
Copy: 0/150 0.0%; Applied: 0; Backlog: 0/1000; Time: 1s(total), 0s(copy); streamer: mysql-bin.000112:77643330; Lag: 0.12s, HeartbeatLag: 0.02s, State: migrating; ETA: N/A
CREATE TABLE `_temp_no_gho` (
`id` int NOT NULL AUTO_INCREMENT,
`no` varchar(10) DEFAULT NULL,
`status` varchar(25) NOT NULL,
`tempID` int DEFAULT NULL,
PRIMARY KEY (`id`)
) /*!50100 TABLESPACE `innodb_system` */ ENGINE=InnoDB AUTO_INCREMENT=230 DEFAULT CHARSET=utf8mb3
[2024/07/09 17:19:45] [info] binlogsyncer.go:180 syncer is closing...
[2024/07/09 17:19:45] [info] binlogsyncer.go:864 kill last connection id 2090439
[2024/07/09 17:19:45] [info] binlogsyncer.go:210 syncer is closed
2024-07-09 17:19:45 ERROR Error 1146: Table '<db>._temp_no_ghc' doesn't exist
# Done