aurora rds and performance_schema.setup_instruments error

[egorzagorskii]

Hello. Tried to use gh-ost with aurora rds and got an error:

./gh-ost
--initially-drop-ghost-table
--conf=/etc/mysql-aws/xxx.cnf
--host=xxx.eu-central-1.rds.amazonaws.com
--database=new_order_01
--table=ride
--alter="ADD COLUMN foo VARCHAR(255) NOT NULL DEFAULT ''"
--allow-on-master
--execute

[2026/01/16 15:39:22] [info] binlogsyncer.go:191 create BinlogSyncer with config {ServerID:99999 Flavor:mysql Host:xxx.eu-central-1.rds.amazonaws.com Port:3306 User:root Password: Localhost: Charset: SemiSyncEnabled:false RawModeEnabled:false TLSConfig: ParseTime:false TimestampStringLocation:UTC UseDecimal:true RecvBufferSize:0 HeartbeatPeriod:0s ReadTimeout:0s MaxReconnectAttempts:0 DisableRetrySync:false VerifyChecksum:false DumpCommandFlag:0 Option: Logger:0xc00045a3c0 Dialer:0x7a8120 RowsEventDecodeFunc: TableMapOptionalMetaDecodeFunc: DiscardGTIDSet:false EventCacheCount:10240 SynchronousEventHandler:}
[2026/01/16 15:39:22] [info] binlogsyncer.go:443 begin to sync binlog from position (mysql-bin-changelog.000019, 44488)
[2026/01/16 15:39:22] [info] binlogsyncer.go:409 Connected to mysql 8.0.39 server
[2026/01/16 15:39:22] [info] binlogsyncer.go:868 rotate to (mysql-bin-changelog.000019, 44488)
2026-01-16 15:39:24 ERROR query performance_schema.setup_instruments with name wait/lock/metadata/sql/mdl error: sql: no rows in result set
2026-01-16 15:39:24 ERROR Unable to enable metadata lock instrument, see further error details. Bailing out
2026-01-16 15:39:24 FATAL 2026-01-16 15:39:24 ERROR query performance_schema.setup_instruments with name wait/lock/metadata/sql/mdl error: sql: no rows in result set

i haven't found any related options to skip this check.

[meiji163]

Since #1536 it's recommended have performance_schema enabled for the metadata lock check at cut-over time. However I will add a flag in case you need to disable it.