invalid sequence 0 != 1

[decadestory]

mysql 8.0.31
error in canal.go:
t, err := schema.NewTable(c, db, table)

error info:
invalid sequence 0 != 1

any solution please ?

[lance6716]

How to reproduce the problem please?

[decadestory]

Occasionally~~~ my mysqldump version is mysql5.7 , Is this the reason? i will try

[decadestory]

when table struct changed....

file：schema.go
method：func (ta *Table) fetchColumns(conn mysql.Executer) error
line：r, err := conn.Execute(fmt.Sprintf("show full columns from %s.%s", ta.Schema, ta.Name))

error info:
invalid sequence 0 != 1

could you give some advice?

[lance6716]

I don't know how to reproduce based on your response. Can you provide step-by-step actions to reproduce?

[decadestory]

要怎么说呢，这是偶然出现的，运行下来看，貌似表结构变了，就可能会出这个问题，我这边是同一个程序里运行了多个c, err := canal.NewCanal(cfg)实例。我想知道，是不是conn连接的原因：类似#456

[decadestory]

找到问题了，mysql连接设置了超时，mysql服务器会主动断掉conn连接，这时候换个表修改，就有这个问题，我看有一个HeartbeatPeriod 配置好像没有用，不知道有没有其他地方可以设置心跳