Upgrade go version to 1.19

[purelind]

Enhancement

Upgrade go version to 1.19

[purelind]

make leak_test failed

--- FAIL: TestNewMySQLBackendExecDML (136.26s)
    mysql_test.go:362:
                Error Trace:    /home/jenkins/tiflow/cdc/sinkv2/eventsink/txn/mysql/mysql_test.go:362
                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:
                                  - matches sql: 'REPLACE INTO `s1`.`t1`(`a`,`b`) VALUES (?,?),(?,?)'
                                  - is with arguments:
                                    0 - 1
                                    1 - test
                                    2 - 2
                                    3 - test
                                  - should return Result having:
                                      LastInsertId: 2
                                      RowsAffected: 2: [CDC:ErrMySQLTxnError]MySQL txn error: call to database transaction Begin, was not expected, next expectation is: ExpectedExec => expecting Exec or ExecContext which:
                                  - matches sql: 'REPLACE INTO `s1`.`t1`(`a`,`b`) VALUES (?,?),(?,?)'
                                  - is with arguments:
                                    0 - 1
                                    1 - test
                                    2 - 2
                                    3 - test
                                  - should return Result having:
                                      LastInsertId: 2
                                      RowsAffected: 2
                Test:           TestNewMySQLBackendExecDML

[purelind]

make check failed

./scripts/generate-msgp-code.sh
scripts/generate-engine-mock.sh
generate dataflow engine mock code...
go: downloading github.com/go-ozzo/ozzo-validation/v4 v4.3.0
go: downloading github.com/VividCortex/mysqlerr v1.0.0
go: downloading gorm.io/gorm v1.23.8
go: downloading github.com/gavv/monotime v0.0.0-20190418164738-30dba4353424
go: downloading github.com/glebarez/go-sqlite v1.17.3
go: downloading github.com/edwingeng/deque v0.0.0-20191220032131-8596380dee17
go: downloading github.com/glebarez/sqlite v1.4.6
go: downloading gorm.io/driver/mysql v1.3.3
go: downloading modernc.org/libc v1.16.8
go: downloading modernc.org/sqlite v1.17.3
go: downloading github.com/jinzhu/inflection v1.0.0
go: downloading github.com/jinzhu/now v1.1.5
go: downloading modernc.org/mathutil v1.4.1
go: downloading modernc.org/memory v1.1.1
generate dataflow engine mock code successfully
gofmt (simplify)
tools/bin/gofumports -l -w $(find . -name '*.go' -type f | grep -vE 'vendor|kv_gen|proto|pb\.go|pb\.gw\.go') 2>&1 | awk '{ print } END { if (NR > 0) { exit 1  }  }'
./dm/syncer/ddl.go
make: *** [fmt] Error 1

[purelind]

/cc @3pointer Please have a look make check and make leak_test failed log.

[lance6716]

@purelind should be fixed in #6943 . And make leak_test is an unstable test I guess

[purelind]

dm integration test, IT-sharding2 frequently encountered failures
link https://ci2.pingcap.net/blue/organizations/jenkins/dm_ghpr_integration_test/detail/dm_ghpr_integration_test/9274/pipeline/140/

[2022-09-02T09:32:21.392Z] wait process dm-worker1 exit...

[2022-09-02T09:32:21.392Z] process dm-worker1 already exit

[2022-09-02T09:32:21.392Z] kill dm-worker2

[2022-09-02T09:32:22.324Z] wait process dm-worker2 exit...

[2022-09-02T09:32:22.324Z] process dm-worker2 already exit

[2022-09-02T09:32:22.582Z] [Fri Sep  2 17:32:22 CST 2022] <<<<<< START DM-WORKER on port 8262, config: /home/jenkins/agent/workspace/dm_ghpr_integration_test/go/src/github.com/pingcap/tiflow/dm/tests/sharding2/conf/dm-worker1.toml >>>>>>

[2022-09-02T09:32:22.582Z] wait for rpc addr 127.0.0.1:8262 alive the 1-th time

[2022-09-02T09:32:23.514Z] rpc addr 127.0.0.1:8262 is alive

[2022-09-02T09:32:23.514Z] [Fri Sep  2 17:32:23 CST 2022] <<<<<< START DM-WORKER on port 8263, config: /home/jenkins/agent/workspace/dm_ghpr_integration_test/go/src/github.com/pingcap/tiflow/dm/tests/sharding2/conf/dm-worker2.toml >>>>>>

[2022-09-02T09:32:23.772Z] wait for rpc addr 127.0.0.1:8263 alive the 1-th time

[2022-09-02T09:32:24.709Z] wait for rpc addr 127.0.0.1:8263 alive the 2-th time

[2022-09-02T09:32:25.641Z] wait for rpc addr 127.0.0.1:8263 alive the 3-th time

[2022-09-02T09:32:27.014Z] wait for rpc addr 127.0.0.1:8263 alive the 4-th time

[2022-09-02T09:32:27.948Z] wait for rpc addr 127.0.0.1:8263 alive the 5-th time

[2022-09-02T09:32:28.881Z] wait for rpc addr 127.0.0.1:8263 alive the 6-th time

[2022-09-02T09:32:29.813Z] wait for rpc addr 127.0.0.1:8263 alive the 7-th time

[2022-09-02T09:32:30.747Z] wait for rpc addr 127.0.0.1:8263 alive the 8-th time

[2022-09-02T09:32:31.679Z] wait for rpc addr 127.0.0.1:8263 alive the 9-th time

[2022-09-02T09:32:33.055Z] wait for rpc addr 127.0.0.1:8263 alive the 10-th time

[2022-09-02T09:32:33.988Z] wait for rpc addr 127.0.0.1:8263 alive the 11-th time

[2022-09-02T09:32:34.920Z] wait for rpc addr 127.0.0.1:8263 alive the 12-th time

[2022-09-02T09:32:35.852Z] wait for rpc addr 127.0.0.1:8263 alive the 13-th time

[2022-09-02T09:32:36.783Z] wait for rpc addr 127.0.0.1:8263 alive the 14-th time

[2022-09-02T09:32:38.156Z] wait for rpc addr 127.0.0.1:8263 alive the 15-th time

[2022-09-02T09:32:39.087Z] wait for rpc addr 127.0.0.1:8263 alive the 16-th time

[2022-09-02T09:32:40.020Z] wait for rpc addr 127.0.0.1:8263 alive the 17-th time

[2022-09-02T09:32:40.951Z] wait for rpc addr 127.0.0.1:8263 alive the 18-th time

[2022-09-02T09:32:41.884Z] wait for rpc addr 127.0.0.1:8263 alive the 19-th time

[2022-09-02T09:32:43.255Z] wait for rpc addr 127.0.0.1:8263 alive the 20-th time

[2022-09-02T09:32:44.187Z] rpc addr 127.0.0.1:8263 check alive timeout

[2022-09-02T09:32:44.187Z] curl: (7) Failed connect to 127.0.0.1:8361; Connection refused

[2022-09-02T09:32:44.187Z] curl: (7) Failed connect to 127.0.0.1:8461; Connection refused

[2022-09-02T09:32:44.187Z] curl: (7) Failed connect to 127.0.0.1:8561; Connection refused

[2022-09-02T09:32:44.187Z] curl: (7) Failed connect to 127.0.0.1:8661; Connection refused

[2022-09-02T09:32:44.187Z] curl: (7) Failed connect to 127.0.0.1:8761; Connection refused

[2022-09-02T09:32:44.187Z] curl: (7) Failed connect to 127.0.0.1:8262; Connection refused

[2022-09-02T09:32:44.187Z] curl: (7) Failed connect to 127.0.0.1:8263; Connection refused

[2022-09-02T09:32:44.187Z] curl: (7) Failed connect to 127.0.0.1:8264; Connection refused

[2022-09-02T09:32:44.187Z] curl: (7) Failed connect to 127.0.0.1:18262; Connection refused

[2022-09-02T09:32:44.187Z] curl: (7) Failed connect to 127.0.0.1:18263; Connection refused

[2022-09-02T09:32:44.187Z] make: *** [dm_integration_test] Error 1

script returned exit code 2

compare run this with go1.18.5
link https://ci2.pingcap.net/blue/organizations/jenkins/dm_ghpr_integration_test/detail/dm_ghpr_integration_test/9276/pipeline/

[dveeden]

https://github.com/pingcap/tiflow/blob/master/go.mod#L3 seems to suggest this issue should be closed.

@lance6716, @purelind what do you think?