unstable test TestNewMySQLBackendExecDML

[CharlesCheung96]

Which jobs are flaking?

verify

Which test(s) are flaking?

TestNewMySQLBackendExecDML

Jenkins logs or GitHub Actions link

[2022-08-25T14:02:53.155Z]     mysql_test.go:362: 

[2022-08-25T14:02:53.155Z]         	Error Trace:	/home/jenkins/agent/workspace/ut-check/tiflow/cdc/sinkv2/eventsink/txn/mysql/mysql_test.go:362

[2022-08-25T14:02:53.155Z]         	Error:      	Expected nil, but got: [CDC:ErrReachMaxTry]reach maximum try: 8, error: [CDC:ErrMySQLTxnError]MySQL txn error: call to database transaction Begin, was not expected, next expectation is: ExpectedExec => expecting Exec or ExecContext which:

[2022-08-25T14:02:53.155Z]         	            	  - matches sql: 'REPLACE INTO `s1`.`t1`(`a`,`b`) VALUES (?,?),(?,?)'

[2022-08-25T14:02:53.155Z]         	            	  - is with arguments:

[2022-08-25T14:02:53.155Z]         	            	    0 - 1

[2022-08-25T14:02:53.155Z]         	            	    1 - test

[2022-08-25T14:02:53.155Z]         	            	    2 - 2

[2022-08-25T14:02:53.155Z]         	            	    3 - test

[2022-08-25T14:02:53.155Z]         	            	  - should return Result having:

[2022-08-25T14:02:53.155Z]         	            	      LastInsertId: 2

[2022-08-25T14:02:53.155Z]         	            	      RowsAffected: 2: [CDC:ErrMySQLTxnError]MySQL txn error: call to database transaction Begin, was not expected, next expectation is: ExpectedExec => expecting Exec or ExecContext which:

[2022-08-25T14:02:53.155Z]         	            	  - matches sql: 'REPLACE INTO `s1`.`t1`(`a`,`b`) VALUES (?,?),(?,?)'

[2022-08-25T14:02:53.155Z]         	            	  - is with arguments:

[2022-08-25T14:02:53.156Z]         	            	    0 - 1

[2022-08-25T14:02:53.156Z]         	            	    1 - test

[2022-08-25T14:02:53.156Z]         	            	    2 - 2

[2022-08-25T14:02:53.156Z]         	            	    3 - test

[2022-08-25T14:02:53.156Z]         	            	  - should return Result having:

[2022-08-25T14:02:53.156Z]         	            	      LastInsertId: 2

[2022-08-25T14:02:53.156Z]         	            	      RowsAffected: 2

[2022-08-25T14:02:53.156Z]         	Test:       	TestNewMySQLBackendExecDML

Anything else we need to know

• Does this test exist for other branches as well?

• Has there been a high frequency of failure lately?

[ti-chi-bot]

@CharlesCheung96: The label(s) area/cdc cannot be applied, because the repository doesn't have them.

In response to this:

/area cdc

Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the ti-community-infra/tichi repository.

[CharlesCheung96]

https://ci.pingcap.net/blue/organizations/jenkins/ut-check/detail/ut-check/31524/pipeline/

[ti-chi-bot]

@CharlesCheung96: The label(s) area/cdc cannot be applied, because the repository doesn't have them.

In response to this:

/area cdc

Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the ti-community-infra/tichi repository.

[Rustin170506]

closed by #6816