Error when replicating a big txn

[Rustin170506]

What did you do?

1. create cluster
2. Create a changefeed: tiup cdc:nightly cli changefeed create --sink-uri="mysql://root@xxx:4000/?transaction-atomicity=table" -c "test" --config=changefeed.toml --server xxx:8300
3. Run the sysbench workload to insert 10000000 rows: ../tools/workload -database-host xxx -database-db-name test -row-count 1000000 -table-count 3 -tps 10000
4. When TiCDC already catch up do a big txn update all rows.

use test;
show tables;
begin;
update sbtest0 set k = k + 1;
update sbtest1 set k = k + 1;
update sbtest2 set k = k + 1;
commit;

What did you expect to see?

Replicate it normally.

What did you see instead?

Got an error:

[2022/12/22 15:53:35.188 +08:00] [ERROR] [processor.go:688] ["run processor failed"] [capture=82f1e149-4ef3-4d02-95cf-bb487d1424bd] [namespace=default] [changefeed=test] [error="[CDC:ErrReachMaxTry]reach maximum try: 8, error: [CDC:ErrMySQLTxnError]MySQL txn error: Error 1390: Prepared statement contains too many placeholders: [CDC:ErrMySQLTxnError]MySQL txn error: Error 1390: Prepared statement contains too many placeholders"] [errorVerbose="[CDC:ErrReachMaxTry]reach maximum try: 8, error: [CDC:ErrMySQLTxnError]MySQL txn error: Error 1390: Prepared statement contains too many placeholders: [CDC:ErrMySQLTxnError]MySQL txn error: Error 1390: Prepared statement contains too many placeholders\ngithub.com/pingcap/errors.AddStack\n\tgithub.com/pingcap/errors@v0.11.5-0.20220729040631-518f63d66278/errors.go:174\ngithub.com/pingcap/errors.(*Error).GenWithStackByArgs\n\tgithub.com/pingcap/errors@v0.11.5-0.20220729040631-518f63d66278/normalize.go:164\ngithub.com/pingcap/tiflow/pkg/retry.run\n\tgithub.com/pingcap/tiflow/pkg/retry/retry_with_opt.go:69\ngithub.com/pingcap/tiflow/pkg/retry.Do\n\tgithub.com/pingcap/tiflow/pkg/retry/retry_with_opt.go:34\ngithub.com/pingcap/tiflow/cdc/sinkv2/eventsink/txn/mysql.(*mysqlBackend).execDMLWithMaxRetries\n\tgithub.com/pingcap/tiflow/cdc/sinkv2/eventsink/txn/mysql/mysql.go:508\ngithub.com/pingcap/tiflow/cdc/sinkv2/eventsink/txn/mysql.(*mysqlBackend).Flush\n\tgithub.com/pingcap/tiflow/cdc/sinkv2/eventsink/txn/mysql/mysql.go:158\ngithub.com/pingcap/tiflow/cdc/sinkv2/eventsink/txn.(*worker).doFlush\n\tgithub.com/pingcap/tiflow/cdc/sinkv2/eventsink/txn/worker.go:209\ngithub.com/pingcap/tiflow/cdc/sinkv2/eventsink/txn.(*worker).runBackgroundLoop.func1\n\tgithub.com/pingcap/tiflow/cdc/sinkv2/eventsink/txn/worker.go:159\nruntime.goexit\n\truntime/asm_amd64.s:1594"]

Versions of the cluster

master

[asddongmen]

I set it to moderate is because it can be aviod when enable split big transaction or disable batchDml.
I will fix it ASAP.