Skipping 256 KB.. Full Log

[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
................................................................................................................................................................................................................[2025/04/01 18:02:23.277 +08:00] [WARN] [tidb.go:148] [compiling] [source="drop database test; create database test;  use test; -- 418\nBEGIN;\n    CREATE TABLE t (i int);\n    INSERT INTO t VALUES(42), (24);\nCOMMIT;\nSELECT * FROM t LIMIT 10 OFFSET -1;\n"] [error="line 6 column 34 near \"-1;\n\" "] [errorVerbose="line 6 column 34 near \"-1;\n\" \ngithub.com/pingcap/errors.AddStack\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/errors.go:174\ngithub.com/pingcap/errors.Trace\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/juju_adaptor.go:15\ngithub.com/pingcap/parser.(*Parser).Parse\n\t/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20190903084634-0daf3f706c76/yy_parser.go:150\ngithub.com/pingcap/tidb/session.Parse\n\t/go/pkg/mod/github.com/pingcap/tidb@v1.1.0-beta.0.20190911032414-d88cd749f56d/session/tidb.go:143\nmain.runTest\n\t/home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/tidb_test/main.go:289\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1700"]
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
.....................................[2025/04/01 18:02:23.501 +08:00] [WARN] [tidb.go:148] [compiling] [source="drop database test; create database test;  use test; -- 425\nBEGIN;\n    CREATE TABLE t (i int);\n    INSERT INTO t VALUES(42), (24);\nCOMMIT;\nSELECT * FROM t LIMIT -1;\n"] [error="line 6 column 24 near \"-1;\n\" "] [errorVerbose="line 6 column 24 near \"-1;\n\" \ngithub.com/pingcap/errors.AddStack\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/errors.go:174\ngithub.com/pingcap/errors.Trace\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/juju_adaptor.go:15\ngithub.com/pingcap/parser.(*Parser).Parse\n\t/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20190903084634-0daf3f706c76/yy_parser.go:150\ngithub.com/pingcap/tidb/session.Parse\n\t/go/pkg/mod/github.com/pingcap/tidb@v1.1.0-beta.0.20190911032414-d88cd749f56d/session/tidb.go:143\nmain.runTest\n\t/home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/tidb_test/main.go:289\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1700"]
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
..............................................[2025/04/01 18:02:23.875 +08:00] [WARN] [tidb.go:148] [compiling] [source="drop database test; create database test;  use test; \n     BEGIN;\n\t\tCREATE TABLE department (\n\t\t\tDepartmentID   int,\n\t\t\tDepartmentName text\n\t\t);\n\t\tINSERT INTO department VALUES\n\t\t\t(31, \"Sales\"),\n\t\t\t(33, \"Engineering\"),\n\t\t\t(34, \"Clerical\"),\n\t\t\t(35, \"Marketing\")\n\t\t;\n\t\tCREATE TABLE employee (\n\t\t\tLastName     text,\n\t\t\tDepartmentID int\n\t\t);\n\t\tINSERT INTO employee VALUES\n\t\t\t(\"Rafferty\", 31),\n\t\t\t(\"Jones\", 33),\n\t\t\t(\"Heisenberg\", 33),\n\t\t\t(\"Robinson\", 34),\n\t\t\t(\"Smith\", 34),\n\t\t\t(\"Williams\", NULL)\n\t\t;\n     COMMIT;\n-- S 50\nSELECT * FROM;\n"] [error="line 27 column 15 near \";\n\" "] [errorVerbose="line 27 column 15 near \";\n\" \ngithub.com/pingcap/errors.AddStack\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/errors.go:174\ngithub.com/pingcap/errors.Trace\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/juju_adaptor.go:15\ngithub.com/pingcap/parser.(*Parser).Parse\n\t/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20190903084634-0daf3f706c76/yy_parser.go:150\ngithub.com/pingcap/tidb/session.Parse\n\t/go/pkg/mod/github.com/pingcap/tidb@v1.1.0-beta.0.20190911032414-d88cd749f56d/session/tidb.go:143\nmain.runTest\n\t/home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/tidb_test/main.go:289\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1700"]
...............[2025/04/01 18:02:23.992 +08:00] [WARN] [tidb.go:148] [compiling] [source="drop database test; create database test;  use test; \n     BEGIN;\n\t\tCREATE TABLE department (\n\t\t\tDepartmentID   int,\n\t\t\tDepartmentName text\n\t\t);\n\t\tINSERT INTO department VALUES\n\t\t\t(31, \"Sales\"),\n\t\t\t(33, \"Engineering\"),\n\t\t\t(34, \"Clerical\"),\n\t\t\t(35, \"Marketing\")\n\t\t;\n\t\tCREATE TABLE employee (\n\t\t\tLastName     text,\n\t\t\tDepartmentID int\n\t\t);\n\t\tINSERT INTO employee VALUES\n\t\t\t(\"Rafferty\", 31),\n\t\t\t(\"Jones\", 33),\n\t\t\t(\"Heisenberg\", 33),\n\t\t\t(\"Robinson\", 34),\n\t\t\t(\"Smith\", 34),\n\t\t\t(\"Williams\", NULL)\n\t\t;\n     COMMIT;\n-- S 53\nSELECT none FROM (\n\tSELECT * FROM employee\n\tSELECT * FROM department\n);\n"] [error="line 29 column 8 near \"SELECT * FROM department\n);\n\" "] [errorVerbose="line 29 column 8 near \"SELECT * FROM department\n);\n\" \ngithub.com/pingcap/errors.AddStack\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/errors.go:174\ngithub.com/pingcap/errors.Trace\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/juju_adaptor.go:15\ngithub.com/pingcap/parser.(*Parser).Parse\n\t/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20190903084634-0daf3f706c76/yy_parser.go:150\ngithub.com/pingcap/tidb/session.Parse\n\t/go/pkg/mod/github.com/pingcap/tidb@v1.1.0-beta.0.20190911032414-d88cd749f56d/session/tidb.go:143\nmain.runTest\n\t/home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/tidb_test/main.go:289\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1700"]
go: downloading gorm.io/driver/postgres v1.3.5
go: downloading github.com/google/uuid v1.3.0
go: downloading gorm.io/driver/mysql v1.3.3
go: downloading gorm.io/driver/sqlserver v1.3.2
go: downloading gorm.io/driver/sqlite v1.3.2
go: downloading github.com/jinzhu/now v1.1.5
go: downloading github.com/lib/pq v1.10.5
go: downloading github.com/jackc/pgx/v4 v4.16.0
go: downloading github.com/go-sql-driver/mysql v1.6.0
go: downloading github.com/denisenkom/go-mssqldb v0.12.0
go: downloading github.com/mattn/go-sqlite3 v1.14.12
go: downloading github.com/jackc/pgconn v1.12.0
go: downloading github.com/jackc/pgproto3/v2 v2.3.0
go: downloading github.com/jackc/pgio v1.0.0
go: downloading github.com/jackc/pgtype v1.11.0
go: downloading golang.org/x/text v0.3.7
go: downloading golang.org/x/crypto v0.0.0-20220411220226-7b82a4e95df4
go: downloading github.com/jackc/pgpassfile v1.0.0
go: downloading github.com/jackc/chunkreader/v2 v2.0.1
go: downloading github.com/jackc/pgservicefile v0.0.0-20200714003250-2b9c44734f2b
go: downloading github.com/jackc/pgproto3 v1.1.0
go: downloading github.com/jackc/chunkreader v1.0.0
go: downloading github.com/golang-sql/civil v0.0.0-20220223132316-b832511892a9
go: downloading github.com/golang-sql/sqlexp v0.0.0-20170517235910-f1bb20e5a188
..................................................................................................................................................................[2025/04/01 18:02:25.203 +08:00] [WARN] [tidb.go:148] [compiling] [source="drop database test; create database test;  use test; -- 710\nBEGIN;\n    CREATE TABLE t (i TEXT) DEFAULT CHARSET Badcharset;\nCOMMIT;\n"] [error="[parser:1115]Unknown character set: 'Badcharset'"] [errorVerbose="[parser:1115]Unknown character set: 'Badcharset'\ngithub.com/pingcap/errors.AddStack\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/errors.go:174\ngithub.com/pingcap/parser/terror.(*Error).GenWithStackByArgs\n\t/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20190903084634-0daf3f706c76/terror/terror.go:238\ngithub.com/pingcap/parser.yyParse\n\t/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20190903084634-0daf3f706c76/parser.go:14055\ngithub.com/pingcap/parser.(*Parser).Parse\n\t/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20190903084634-0daf3f706c76/yy_parser.go:141\ngithub.com/pingcap/tidb/session.Parse\n\t/go/pkg/mod/github.com/pingcap/tidb@v1.1.0-beta.0.20190911032414-d88cd749f56d/session/tidb.go:143\nmain.runTest\n\t/home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/tidb_test/main.go:289\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1700"]
.............................................................................................................
Great, All tests passed
TIDB TEST END
TIDB TEST FINISHED SUCCESSFULLY!
[Pipeline] }
[Pipeline] // container
[Pipeline] }
Cache not saved (ws/jenkins-pingcap-tidb-merged_integration_common_test-3297/tidb-test already exists)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
tidb_test start

+ [[ ! -e ./tidb_test ]]
+ [[ -z '' ]]
+ TIDB_CONFIG=./config.toml
+ [[ -z /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/bin/tidb-server ]]
+ [[ ! -e /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/bin/tidb-server ]]
+ [[ -z '' ]]
+ TIDB_PARALLELISM=8
+ [[ -z '' ]]
+ TEST_FILE=./ql.t
+ rm -rf './tidb.log*'
+ echo 'START tidb_server, LOG FILE: ./tidb.log'
START tidb_server, LOG FILE: ./tidb.log
+ '[' tikv = tikv ']'
+ TIDB_PARALLELISM=1
+ SERVER_PID=314
+ echo 'tidb-server(PID: 314) STARTED'
tidb-server(PID: 314) STARTED
+ sleep 10
+ /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/bin/tidb-server -config ./config.toml -store tikv -path 127.0.0.1:2379
analyze_test start 

go: downloading github.com/go-sql-driver/mysql v1.4.0
go: downloading github.com/pingcap/errors v0.11.4
go: downloading github.com/sirupsen/logrus v1.8.1
go: downloading golang.org/x/sys v0.0.0-20220808155132-1c4a2a72c664
gosqltest start
/go
randgen_test start

START tidb_server, LOG FILE: ./tidb.log
tidb-server(PID: 278) STARTED
gormtest start
/home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm
go path is /go
go: downloading github.com/jinzhu/now v1.1.4
go: downloading github.com/jinzhu/inflection v1.0.0
/home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm
go: downloading github.com/pingcap/tidb v1.1.0-beta.0.20190911032414-d88cd749f56d
go: downloading github.com/go-sql-driver/mysql v1.4.0
go: downloading github.com/sirupsen/logrus v1.8.1
go: downloading github.com/pingcap/errors v0.11.4
go: downloading golang.org/x/sys v0.0.0-20191026070338-33540a1f6037
go: downloading github.com/opentracing/opentracing-go v1.0.2
go: downloading github.com/pingcap/parser v0.0.0-20190903084634-0daf3f706c76
go: downloading github.com/pingcap/failpoint v0.0.0-20190512135322-30cc7431d99c
go: downloading go.uber.org/zap v1.12.0
go: downloading github.com/prometheus/client_golang v0.9.0
go: downloading github.com/ngaut/pools v0.0.0-20180318154953-b7bc8c42aac7
go: downloading github.com/pingcap/tidb-tools v2.1.3-0.20190321065848-1e8b48f5c168+incompatible
go: downloading github.com/coreos/etcd v3.3.13+incompatible
go: downloading github.com/cznic/mathutil v0.0.0-20181122101859-297441e03548
go: downloading github.com/uber/jaeger-client-go v2.15.0+incompatible
go: downloading go.uber.org/atomic v1.5.0
go: downloading github.com/gogo/protobuf v1.2.0
go: downloading github.com/google/btree v1.0.0
go: downloading google.golang.org/grpc v1.17.0
go: downloading github.com/grpc-ecosystem/go-grpc-middleware v1.0.1-0.20190118093823-f849b5445de4
go: downloading github.com/pingcap/tipb v0.0.0-20190806070524-16909e03435e
go: downloading github.com/dgryski/go-farm v0.0.0-20190104051053-3adb47b1fb0f
go: downloading github.com/BurntSushi/toml v0.3.1
go: downloading github.com/pingcap/kvproto v0.0.0-20190904075355-9a1bd6a31da2
go: downloading github.com/pingcap/log v0.0.0-20190307075452-bd41d9273596
go: downloading github.com/cznic/sortutil v0.0.0-20150617083342-4c7342852e65
go: downloading github.com/golang/protobuf v1.2.0
go: downloading github.com/spaolacci/murmur3 v0.0.0-20180118202830-f09979ecbc72
go: downloading github.com/ngaut/sync2 v0.0.0-20141008032647-7a24ed77b2ef
go: downloading gopkg.in/natefinch/lumberjack.v2 v2.0.0
go: downloading github.com/klauspost/cpuid v0.0.0-20170728055534-ae7887de9fa5
go: downloading github.com/twinj/uuid v1.0.0
go: downloading github.com/google/uuid v1.1.1
go: downloading golang.org/x/text v0.3.0
go: downloading golang.org/x/tools v0.0.0-20191107010934-f79515f33823
go: downloading github.com/shirou/gopsutil v2.18.10+incompatible
go: downloading github.com/opentracing/basictracer-go v1.0.0
go: downloading sourcegraph.com/sourcegraph/appdash v0.0.0-20180531100431-4c381bd170b4
go: downloading github.com/pingcap/pd v0.0.0-20190712044914-75a1f9f3062b
go: downloading golang.org/x/net v0.0.0-20190620200207-3b0461eec859
go: downloading github.com/remyoudompheng/bigfft v0.0.0-20190512091148-babf20351dd7
go: downloading github.com/prometheus/procfs v0.0.0-20181005140218-185b4288413d
go: downloading github.com/beorn7/perks v0.0.0-20180321164747-3a771d992973
go: downloading github.com/prometheus/client_model v0.0.0-20180712105110-5c3871d89910
go: downloading github.com/prometheus/common v0.0.0-20181020173914-7e9e6cabbd39
go: downloading go.uber.org/multierr v1.4.0
go: downloading github.com/pkg/errors v0.9.1
go: downloading github.com/uber/jaeger-lib v1.5.0
go: downloading github.com/matttproud/golang_protobuf_extensions v1.0.1
go: downloading github.com/codahale/hdrhistogram v0.0.0-20161010025455-3a0bb77429bd
go: downloading google.golang.org/genproto v0.0.0-20190108161440-ae2f86662275
RUN ALL RANDGEN TEST CASES
time="2025-04-01T18:02:37+08:00" level=info msg="running tests: [enum enum_aggregate enum_expression_1 enum_expression_2 enum_expression_3 enum_expression_4 generated_columns greatest ifnull index_join_union_scan isnull least partition plus point_get udaf_avg udaf_avg_union udaf_bitand udaf_bitand_union udaf_bitor udaf_bitor_union udaf_bitxor udaf_bitxor_union udaf_count udaf_count_union udaf_group_concat udaf_max_min udaf_max_min_union udaf_sum udaf_sum_union udf_abs udf_acos udf_asin udf_ceil udf_div udf_floor udf_is_true_false udf_logic_xor]"
time="2025-04-01T18:02:37+08:00" level=warning msg="ping db failed, retry count 0 (remain 120) err dial tcp 127.0.0.1:4001: connect: connection refused"
time="2025-04-01T18:02:37+08:00" level=warning msg="ping db failed, retry count 1 (remain 119) err dial tcp 127.0.0.1:4001: connect: connection refused"
time="2025-04-01T18:02:38+08:00" level=warning msg="ping db failed, retry count 2 (remain 118) err dial tcp 127.0.0.1:4001: connect: connection refused"
time="2025-04-01T18:02:38+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc00020c000 {{} {} 0} {0 0} [0xc0001b5900] {[]} 1 0xc000212000 false map[0xc0001b5900:map[0xc0001b5900:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:02:38+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
build analyze_test successfully
START tidb_server, LOG FILE: ./tidb.log
tidb-server(PID: 2072) STARTED
+ set +x
START RUNNING TIDB TEST
START RUNNING ANALYZE TEST
./t/enum.test: ok! 150 test cases passed, take time 4.984542379 s
time="2025-04-01T18:02:44+08:00" level=info msg="run test [enum] ok"
time="2025-04-01T18:02:44+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0000f06f8 {{} {} 0} {0 0} [0xc000256e00] {[]} 1 0xc00003be30 false map[0xc000256e00:map[0xc000256e00:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:02:44+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
ANALYZE TEST END
ANALYZE TEST FINISHED SUCCESSFULLY!
[Pipeline] }
[Pipeline] // container
[Pipeline] }
Cache not saved (ws/jenkins-pingcap-tidb-merged_integration_common_test-3297/tidb-test already exists)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
..................................................[2025/04/01 18:02:47.243 +08:00] [WARN] [tidb.go:148] [compiling] [source="drop database test; create database test;  use test; \n     BEGIN;\n\t\tCREATE TABLE department (\n\t\t\tDepartmentID   int,\n\t\t\tDepartmentName text\n\t\t);\n\t\tINSERT INTO department VALUES\n\t\t\t(31, \"Sales\"),\n\t\t\t(33, \"Engineering\"),\n\t\t\t(34, \"Clerical\"),\n\t\t\t(35, \"Marketing\")\n\t\t;\n\t\tCREATE TABLE employee (\n\t\t\tLastName     text,\n\t\t\tDepartmentID int\n\t\t);\n\t\tINSERT INTO employee VALUES\n\t\t\t(\"Rafferty\", 31),\n\t\t\t(\"Jones\", 33),\n\t\t\t(\"Heisenberg\", 33),\n\t\t\t(\"Robinson\", 34),\n\t\t\t(\"Smith\", 34),\n\t\t\t(\"Williams\", NULL)\n\t\t;\n     COMMIT;\n-- S 50\nSELECT * FROM;\n"] [error="line 27 column 15 near \";\n\" "] [errorVerbose="line 27 column 15 near \";\n\" \ngithub.com/pingcap/errors.AddStack\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/errors.go:174\ngithub.com/pingcap/errors.Trace\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/juju_adaptor.go:15\ngithub.com/pingcap/parser.(*Parser).Parse\n\t/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20190903084634-0daf3f706c76/yy_parser.go:150\ngithub.com/pingcap/tidb/session.Parse\n\t/go/pkg/mod/github.com/pingcap/tidb@v1.1.0-beta.0.20190911032414-d88cd749f56d/session/tidb.go:143\nmain.runTest\n\t/home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/tidb_test/main.go:289\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1700"]
go: downloading github.com/lib/pq v1.10.5
go: downloading github.com/google/uuid v1.3.0
go: downloading gorm.io/driver/postgres v1.3.5
go: downloading github.com/jinzhu/now v1.1.5
go: downloading gorm.io/driver/sqlserver v1.3.2
go: downloading gorm.io/driver/sqlite v1.3.2
go: downloading gorm.io/driver/mysql v1.3.3
go: downloading github.com/go-sql-driver/mysql v1.6.0
go: downloading github.com/denisenkom/go-mssqldb v0.12.0
go: downloading github.com/jackc/pgx/v4 v4.16.0
go: downloading github.com/mattn/go-sqlite3 v1.14.12
go: downloading github.com/jackc/pgtype v1.11.0
go: downloading github.com/jackc/pgconn v1.12.0
go: downloading github.com/jackc/pgio v1.0.0
go: downloading github.com/jackc/pgproto3/v2 v2.3.0
go: downloading github.com/jackc/chunkreader/v2 v2.0.1
go: downloading github.com/jackc/pgpassfile v1.0.0
go: downloading github.com/jackc/pgservicefile v0.0.0-20200714003250-2b9c44734f2b
go: downloading golang.org/x/crypto v0.0.0-20220411220226-7b82a4e95df4
go: downloading golang.org/x/text v0.3.7
go: downloading github.com/jackc/chunkreader v1.0.0
go: downloading github.com/jackc/pgproto3 v1.1.0
go: downloading github.com/golang-sql/civil v0.0.0-20220223132316-b832511892a9
go: downloading github.com/golang-sql/sqlexp v0.0.0-20170517235910-f1bb20e5a188
..[2025/04/01 18:02:47.500 +08:00] [WARN] [tidb.go:148] [compiling] [source="drop database test; create database test;  use test; \n     BEGIN;\n\t\tCREATE TABLE department (\n\t\t\tDepartmentID   int,\n\t\t\tDepartmentName text\n\t\t);\n\t\tINSERT INTO department VALUES\n\t\t\t(31, \"Sales\"),\n\t\t\t(33, \"Engineering\"),\n\t\t\t(34, \"Clerical\"),\n\t\t\t(35, \"Marketing\")\n\t\t;\n\t\tCREATE TABLE employee (\n\t\t\tLastName     text,\n\t\t\tDepartmentID int\n\t\t);\n\t\tINSERT INTO employee VALUES\n\t\t\t(\"Rafferty\", 31),\n\t\t\t(\"Jones\", 33),\n\t\t\t(\"Heisenberg\", 33),\n\t\t\t(\"Robinson\", 34),\n\t\t\t(\"Smith\", 34),\n\t\t\t(\"Williams\", NULL)\n\t\t;\n     COMMIT;\n-- S 53\nSELECT none FROM (\n\tSELECT * FROM employee\n\tSELECT * FROM department\n);\n"] [error="line 29 column 8 near \"SELECT * FROM department\n);\n\" "] [errorVerbose="line 29 column 8 near \"SELECT * FROM department\n);\n\" \ngithub.com/pingcap/errors.AddStack\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/errors.go:174\ngithub.com/pingcap/errors.Trace\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/juju_adaptor.go:15\ngithub.com/pingcap/parser.(*Parser).Parse\n\t/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20190903084634-0daf3f706c76/yy_parser.go:150\ngithub.com/pingcap/tidb/session.Parse\n\t/go/pkg/mod/github.com/pingcap/tidb@v1.1.0-beta.0.20190911032414-d88cd749f56d/session/tidb.go:143\nmain.runTest\n\t/home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/tidb_test/main.go:289\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1700"]
./t/enum_aggregate.test: ok! 1031 test cases passed, take time 9.106067409 s
time="2025-04-01T18:02:53+08:00" level=info msg="run test [enum_aggregate] ok"
time="2025-04-01T18:02:53+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0000f0788 {{} {} 0} {0 0} [0xc00039b600] {[]} 1 0xc0004d8700 false map[0xc00039b600:map[0xc00039b600:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:02:53+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
2025/04/01 18:03:01 testing mysql...

2025/04/01 18:03:01 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/associations_belongs_to_test.go:139 Error 1452: Cannot add or update a child row: a foreign key constraint fails (`test`.`users`, CONSTRAINT `fk_users_company` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`))
[0.874ms] [rows:0] INSERT INTO `users` (`created_at`,`updated_at`,`deleted_at`,`name`,`age`,`birthday`,`company_id`,`manager_id`,`active`) VALUES ('2025-04-01 18:03:01.718','2025-04-01 18:03:01.718',NULL,'invalid-user-with-invalid-belongs-to-foreign-key',0,NULL,10000001,NULL,false)

2025/04/01 18:03:02 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/associations_many2many_test.go:99 Error 1452: Cannot add or update a child row: a foreign key constraint fails (`test`.`user_speaks`, CONSTRAINT `fk_user_speaks_language` FOREIGN KEY (`language_code`) REFERENCES `languages` (`code`))
[0.613ms] [rows:0] INSERT INTO `user_speaks` (`user_id`,`language_code`) VALUES (53,'many2many_omit_associations_locale_1'),(53,'many2many_omit_associations_locale_2') ON DUPLICATE KEY UPDATE `user_id`=`user_id`

2025/04/01 18:03:02 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/associations_many2many_test.go:99 Error 1452: Cannot add or update a child row: a foreign key constraint fails (`test`.`user_speaks`, CONSTRAINT `fk_user_speaks_language` FOREIGN KEY (`language_code`) REFERENCES `languages` (`code`))
[1.579ms] [rows:1] INSERT INTO `users` (`created_at`,`updated_at`,`deleted_at`,`name`,`age`,`birthday`,`company_id`,`manager_id`,`active`) VALUES ('2025-04-01 18:03:02.155','2025-04-01 18:03:02.155',NULL,'many2many_omit_associations',18,'2025-04-01 18:03:02',NULL,NULL,false)

2025/04/01 18:03:02 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/associations_many2many_test.go:118 Error 1452: Cannot add or update a child row: a foreign key constraint fails (`test`.`user_speaks`, CONSTRAINT `fk_user_speaks_language` FOREIGN KEY (`language_code`) REFERENCES `languages` (`code`))
[0.555ms] [rows:0] INSERT INTO `user_speaks` (`user_id`,`language_code`) VALUES (53,'omitmany2many') ON DUPLICATE KEY UPDATE `user_id`=`user_id`

2025/04/01 18:03:02 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/associations_many2many_test.go:118 Error 1452: Cannot add or update a child row: a foreign key constraint fails (`test`.`user_speaks`, CONSTRAINT `fk_user_speaks_language` FOREIGN KEY (`language_code`) REFERENCES `languages` (`code`))
[1.724ms] [rows:1] UPDATE `users` SET `updated_at`='2025-04-01 18:03:02.16' WHERE `users`.`deleted_at` IS NULL AND `id` = 53

2025/04/01 18:03:02 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/associations_test.go:66 Error 1048: Column 'member_id' cannot be null
[1.754ms] [rows:0] UPDATE `profiles` SET `member_id`=NULL WHERE `profiles`.`member_id` = 1 AND `profiles`.`deleted_at` IS NULL

2025/04/01 18:03:02 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/associations_test.go:117 record not found
[0.544ms] [rows:0] SELECT * FROM `members` WHERE `members`.`id` = 1 ORDER BY `members`.`id` LIMIT 1

2025/04/01 18:03:02 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/associations_test.go:121 record not found
[0.570ms] [rows:0] SELECT * FROM `profiles` WHERE `profiles`.`id` = 1 AND `profiles`.`id` = 1 ORDER BY `profiles`.`id` LIMIT 1

2025/04/01 18:03:02 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/associations_test.go:171 record not found
[0.651ms] [rows:0] SELECT * FROM `members` WHERE `members`.`id` = 1 ORDER BY `members`.`id` LIMIT 1

2025/04/01 18:03:02 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/associations_test.go:175 record not found
[0.598ms] [rows:0] SELECT * FROM `profiles` WHERE `profiles`.`id` = 1 AND `profiles`.`id` = 1 ORDER BY `profiles`.`id` LIMIT 1

2025/04/01 18:03:02 /usr/local/go/src/reflect/value.go:581
[error] Got error when compile callbacks, got conflicting callback c3 with before c1

2025/04/01 18:03:02 /usr/local/go/src/reflect/value.go:581
[warn] removing callback `c2` from /usr/local/go/src/reflect/value.go:581

2025/04/01 18:03:02 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/connpool_test.go:151 record not found
[1.463ms] [rows:0] SELECT * FROM `users` WHERE name = 'transaction' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:03:02 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/count_test.go:153 model value required when using preload
[1.047ms] [rows:1] SELECT count(*) FROM `users` WHERE name in ('count-1','count-2','count-3')

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/create_test.go:352 empty slice found
[0.338ms] [rows:0] INSERT INTO `users` (`created_at`,`updated_at`,`deleted_at`,`name`,`age`,`birthday`,`company_id`,`manager_id`,`active`) VALUES 

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/create_test.go:357 empty slice found
[0.267ms] [rows:0] INSERT INTO `users` VALUES()

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/create_test.go:369 slice data #2 is invalid: unsupported data
[0.508ms] [rows:0] INSERT INTO `users` (`created_at`,`updated_at`,`deleted_at`,`name`,`age`,`birthday`,`company_id`,`manager_id`,`active`) VALUES ('2025-04-01 18:03:03.011','2025-04-01 18:03:03.011',NULL,'invalid_slice_1',18,'2025-04-01 18:03:03',NULL,NULL,false),('2025-04-01 18:03:03.011','2025-04-01 18:03:03.011',NULL,'invalid_slice_2',18,'2025-04-01 18:03:03',NULL,NULL,false),()

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/customize_field_test.go:143 record not found
[1.463ms] [rows:0] SELECT * FROM `customize_field_structs` WHERE `customize_field_structs`.`name` = 'create' AND `customize_field_structs`.`field_readonly` = 'create_allow_readonly' AND `customize_field_structs`.`deleted_at` IS NULL ORDER BY `customize_field_structs`.`id` LIMIT 1

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/delete_test.go:30 record not found
[0.804ms] [rows:0] SELECT * FROM `users` WHERE id = 231 AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/delete_test.go:52 WHERE conditions required
[0.329ms] [rows:0] UPDATE `users` SET `deleted_at`='2025-04-01 18:03:03.156' WHERE `users`.`deleted_at` IS NULL

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/delete_test.go:56 record not found
[0.761ms] [rows:0] SELECT * FROM `users` WHERE id = 230 AND `users`.`deleted_at` IS NULL AND `users`.`id` = 232 ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/delete_test.go:85 record not found
[0.664ms] [rows:0] SELECT * FROM `deleted_users` WHERE `deleted_users`.`id` = 1 AND `deleted_users`.`deleted_at` IS NULL ORDER BY `deleted_users`.`id` LIMIT 1

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/delete_test.go:99 record not found
[0.631ms] [rows:0] SELECT * FROM `deleted_users` WHERE `deleted_users`.`id` = 1 ORDER BY `deleted_users`.`id` LIMIT 1

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/delete_test.go:111 record not found
[1.672ms] [rows:0] SELECT * FROM `users` WHERE name = 'inline_delete_1' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/delete_test.go:117 record not found
[1.531ms] [rows:0] SELECT * FROM `users` WHERE name = 'inline_delete_2' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/delete_test.go:123 WHERE conditions required
[0.296ms] [rows:0] UPDATE `users` SET `deleted_at`='2025-04-01 18:03:03.184' WHERE `users`.`deleted_at` IS NULL

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/hooks_test.go:133 record not found
[0.812ms] [rows:0] SELECT * FROM `products` WHERE Code = 'unique_code' AND `products`.`deleted_at` IS NULL AND `products`.`id` = 1 ORDER BY `products`.`id` LIMIT 1

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/hooks_test.go:156 record not found
[1.074ms] [rows:0] SELECT * FROM `products` WHERE code = 'Invalid' AND `products`.`deleted_at` IS NULL ORDER BY `products`.`id` LIMIT 1

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/hooks_test.go:176 record not found
[1.267ms] [rows:0] SELECT * FROM `products` WHERE code = 'dont_update' AND `products`.`deleted_at` IS NULL ORDER BY `products`.`id` LIMIT 1

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/hooks_test.go:196 can't save
[1.982ms] [rows:1] INSERT INTO `products` (`created_at`,`updated_at`,`deleted_at`,`name`,`code`,`price`,`after_find_call_times`,`before_create_call_times`,`after_create_call_times`,`before_update_call_times`,`after_update_call_times`,`before_save_call_times`,`after_save_call_times`,`before_delete_call_times`,`after_delete_call_times`) VALUES ('2025-04-01 18:03:03.615','2025-04-01 18:03:03.615',NULL,'','after_save_error',100.000000,0,1,0,0,0,1,0,0,0)

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/hooks_test.go:197 record not found
[2.232ms] [rows:0] SELECT * FROM `products` WHERE code = 'after_save_error' AND `products`.`deleted_at` IS NULL ORDER BY `products`.`id` LIMIT 1

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/hooks_test.go:207 can't delete
[1.143ms] [rows:1] UPDATE `products` SET `deleted_at`='2025-04-01 18:03:03.624' WHERE `products`.`id` = 4 AND `products`.`deleted_at` IS NULL

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/hooks_test.go:485 invalid item
[1.054ms] [rows:1] INSERT INTO `product4` (`created_at`,`updated_at`,`deleted_at`,`name`,`code`,`price`,`owner`) VALUES ('2025-04-01 18:03:03.744','2025-04-01 18:03:03.744',NULL,'Product-1','',100,'')

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/hooks_test.go:489 record not found
[0.962ms] [rows:0] SELECT * FROM `product4` WHERE name = 'Product-1' AND `product4`.`deleted_at` IS NULL ORDER BY `product4`.`id` LIMIT 1

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/joins_test.go:82 record not found
[3.657ms] [rows:0] SELECT `users`.`id`,`users`.`created_at`,`users`.`updated_at`,`users`.`deleted_at`,`users`.`name`,`users`.`age`,`users`.`birthday`,`users`.`company_id`,`users`.`manager_id`,`users`.`active` FROM `users` inner join pets on pets.user_id = users.id AND pets.name = 'joins-conds_pet_1' join accounts on accounts.user_id = users.id AND accounts.number = 'joins-conds_accountnon-exist' WHERE users.name = 'joins-conds' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/joins_test.go:107 dry run mode unsupported
[0.024ms] [rows:0] SELECT id, name, iv.total, iv.paid, iv.balance FROM `table_employees` LEFT JOIN (SELECT seller, SUM(total) as total, SUM(paid) as paid, SUM(balance) as balance FROM `table_invoices` GROUP BY `seller`) AS iv ON iv.seller = table_employees.id

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/main_test.go:19 Error 1054: Unknown column 'sdsd.zaaa' in 'where clause'
[0.296ms] [rows:0] SELECT `aaa` FROM `users` WHERE sdsd.zaaa = 'sd;;;aa' AND `users`.`deleted_at` IS NULL

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/main_test.go:23 Error 1054: Unknown column 'sdsd.zaaa' in 'where clause'
[0.199ms] [rows:0] SELECT * FROM `users` WHERE sdsd.zaaa = 'sd;;;aa' AND `users`.`deleted_at` IS NULL

2025/04/01 18:03:03 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/main_test.go:33 record not found
[1.338ms] [rows:0] SELECT * FROM `users` WHERE name = 'jinzhu; delete * from users' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1
./t/enum_expression_1.test: ok! 1018 test cases passed, take time 10.171324525 s
time="2025-04-01T18:03:04+08:00" level=info msg="run test [enum_expression_1] ok"
time="2025-04-01T18:03:04+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0000f0360 {{} {} 0} {0 0} [0xc000324a00] {[]} 1 0xc0002807e0 false map[0xc000324a00:map[0xc000324a00:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:03:04+08:00" level=info msg="enable tidb_enable_analyze_snapshot"

2025/04/01 18:03:06 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/named_argument_test.go:72 record not found
[1.252ms] [rows:0] SELECT * FROM `named_users` WHERE (name1 = 'jinzhu-new' OR name2 = 'jinzhu-new') AND name3 = 'jinzhu-new3' AND `named_users`.`deleted_at` IS NULL ORDER BY `named_users`.`id` LIMIT 1

2025/04/01 18:03:06 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/named_argument_test.go:79 record not found
[1.005ms] [rows:0] SELECT * FROM `named_users` WHERE (name1 = 'jinzhu-new' OR name2 = 'jinzhu-new') AND `named_users`.`deleted_at` IS NULL ORDER BY `named_users`.`id` LIMIT 1

2025/04/01 18:03:06 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/preload_suits_test.go:56 record not found
[0.723ms] [rows:0] SELECT * FROM `level3` WHERE name = 'not_found' AND `level3`.`id` = 1 ORDER BY `level3`.`id` LIMIT 1

2025/04/01 18:03:07 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/preload_suits_test.go:941 record not found
[0.643ms] [rows:0] SELECT * FROM `level3` WHERE value = 'not_found' AND `level3`.`id` = 1 ORDER BY `level3`.`id` LIMIT 1

2025/04/01 18:03:07 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/preload_suits_test.go:996 record not found
[0.614ms] [rows:0] SELECT * FROM `level3` WHERE value = 'not_found' AND `level3`.`id` = 1 ORDER BY `level3`.`id` LIMIT 1

2025/04/01 18:03:08 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/preload_suits_test.go:1268 record not found
[0.708ms] [rows:0] SELECT * FROM `level2` WHERE value = 'bogus' ORDER BY `level2`.`id` LIMIT 1

2025/04/01 18:03:09 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/query_test.go:378 Error 1146: Table 'test.wrong_table' doesn't exist
[0.212ms] [rows:0] SELECT * FROM `wrong_table` WHERE name = 'find_in_batches_with_error' AND `wrong_table`.`deleted_at` IS NULL ORDER BY `wrong_table`.`id` LIMIT 2

2025/04/01 18:03:10 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/query_test.go:1007 Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 97 near "OFFSET 3" 
[0.199ms] [rows:20] SELECT * FROM `users` WHERE name like 'OffsetUser%' AND `users`.`deleted_at` IS NULL ORDER BY age desc OFFSET 3

2025/04/01 18:03:10 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/query_test.go:1169 sql: Scan error on column index 0, name "avgage": unsupported Scan, storing driver.Value type []uint8 into type *tests.User; sql: Scan error on column index 0, name "avgage": unsupported Scan, storing driver.Value type []uint8 into type *tests.User
[2.815ms] [rows:2] SELECT AVG(age) as avgage FROM `users` WHERE name LIKE 'subquery_having%' AND `users`.`deleted_at` IS NULL GROUP BY `name` HAVING AVG(age) > (SELECT AVG(age) FROM `users` WHERE name LIKE 'subquery_having%')

2025/04/01 18:03:10 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/scanner_valuer_test.go:123 sql: converting argument $11 type: Should not start with 'x'
[0.305ms] [rows:0] INSERT INTO `scanner_valuer_structs` (`created_at`,`updated_at`,`deleted_at`,`name`,`gender`,`age`,`male`,`height`,`birthday`,`allergen`,`password`,`bytes`,`num`,`strings`,`structs`,`role`,`user_id`,`empty_time`,`example_struct`,`example_struct_ptr`) VALUES ('2025-04-01 18:03:10.263','2025-04-01 18:03:10.263',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','0','null','null','',NULL,'2025-04-01 18:03:10.263','{"Name":"","Val":"value1"}','{"Name":"","Val":"value2"}')

2025/04/01 18:03:10 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/scanner_valuer_test.go:132 sql: converting argument $1 type: Should not start with 'x'
[0.282ms] [rows:0] UPDATE `scanner_valuer_structs` SET `password`=NULL,`updated_at`='2025-04-01 18:03:10.265' WHERE `scanner_valuer_structs`.`deleted_at` IS NULL AND `id` = 1

2025/04/01 18:03:10 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/soft_delete_test.go:42 record not found
[1.348ms] [rows:0] SELECT * FROM `users` WHERE name = 'SoftDelete' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:03:10 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/soft_delete_test.go:71 record not found
[1.024ms] [rows:0] SELECT * FROM `users` WHERE name = 'SoftDelete' ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:03:10 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/sql_builder_test.go:99 record not found
[1.458ms] [rows:0] SELECT * FROM `users` WHERE name in ('ExecRawSqlUser1','ExecRawSqlUser2','ExecRawSqlUser3') AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:03:10 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/transaction_test.go:40 record not found
[1.418ms] [rows:0] SELECT * FROM `users` WHERE name = 'transaction' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:03:10 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/transaction_test.go:109 record not found
[1.281ms] [rows:0] SELECT * FROM `users` WHERE name = 'transaction-block' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:03:10 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/transaction_test.go:146 record not found
[1.385ms] [rows:0] SELECT * FROM `users` WHERE name = 'transaction-block-3' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:03:10 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/transaction_test.go:192 record not found
[1.523ms] [rows:0] SELECT * FROM `users` WHERE name = 'transaction-save-point-1' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:03:10 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/transaction_test.go:215 record not found
[1.334ms] [rows:0] SELECT * FROM `users` WHERE name = 'transaction-save-point-1' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:03:10 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/transaction_test.go:250 record not found
[1.540ms] [rows:0] SELECT * FROM `users` WHERE name = 'transaction-nested-1' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:03:10 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/transaction_test.go:278 record not found
[1.419ms] [rows:0] SELECT * FROM `users` WHERE name = 'transaction-nested-1' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1
2025/04/01 18:03:10 testing mysql...
./t/enum_expression_2.test: ok! 1019 test cases passed, take time 7.723746875 s
time="2025-04-01T18:03:12+08:00" level=info msg="run test [enum_expression_2] ok"
time="2025-04-01T18:03:12+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0001fc5d0 {{} {} 0} {0 0} [0xc000680a00] {[]} 1 0xc0002c33b0 false map[0xc000680a00:map[0xc000680a00:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:03:12+08:00" level=info msg="enable tidb_enable_analyze_snapshot"

2025/04/01 18:03:13 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/update_test.go:236 WHERE conditions required
[0.245ms] [rows:0] UPDATE `users` SET `name`='jinzhu',`updated_at`='2025-04-01 18:03:13.073' WHERE `users`.`deleted_at` IS NULL

2025/04/01 18:03:16 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/upsert_test.go:284 Error 1062: Duplicate entry '259' for key 'users.PRIMARY'
[0.822ms] [rows:0] INSERT INTO `users` (`created_at`,`updated_at`,`deleted_at`,`name`,`age`,`birthday`,`company_id`,`manager_id`,`active`,`id`) VALUES ('2025-04-01 18:03:16.34','2025-04-01 18:03:16.352',NULL,'find or create 4',44,NULL,NULL,NULL,false,259)
PASS
ok  	gorm.io/gorm/tests	14.928s
gormtest end
[Pipeline] }
[Pipeline] // container
[Pipeline] }
Cache not saved (ws/jenkins-pingcap-tidb-merged_integration_common_test-3297/tidb-test already exists)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
./t/enum_expression_3.test: ok! 1031 test cases passed, take time 9.031657162 s
time="2025-04-01T18:03:22+08:00" level=info msg="run test [enum_expression_3] ok"
time="2025-04-01T18:03:22+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0001fc460 {{} {} 0} {0 0} [0xc00030c580] {[]} 1 0xc0002c2b60 false map[0xc00030c580:map[0xc00030c580:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:03:22+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
PASS
ok  	github.com/pingcap/tidb-test/go-sql-test/sqltest	5.290s
[mysql] 2025/04/01 18:03:20 packets.go:122: closing bad idle connection: EOF
[mysql] 2025/04/01 18:03:23 packets.go:122: closing bad idle connection: EOF
..............................................................................................................................................................................................................................................................................................[2025/04/01 18:03:25.348 +08:00] [WARN] [tidb.go:148] [compiling] [source="drop database test; create database test;  use test; -- 418\nBEGIN;\n    CREATE TABLE t (i int);\n    INSERT INTO t VALUES(42), (24);\nCOMMIT;\nSELECT * FROM t LIMIT 10 OFFSET -1;\n"] [error="line 6 column 34 near \"-1;\n\" "] [errorVerbose="line 6 column 34 near \"-1;\n\" \ngithub.com/pingcap/errors.AddStack\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/errors.go:174\ngithub.com/pingcap/errors.Trace\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/juju_adaptor.go:15\ngithub.com/pingcap/parser.(*Parser).Parse\n\t/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20190903084634-0daf3f706c76/yy_parser.go:150\ngithub.com/pingcap/tidb/session.Parse\n\t/go/pkg/mod/github.com/pingcap/tidb@v1.1.0-beta.0.20190911032414-d88cd749f56d/session/tidb.go:143\nmain.runTest\n\t/home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/tidb_test/main.go:289\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1700"]
......[2025/04/01 18:03:25.876 +08:00] [WARN] [tidb.go:148] [compiling] [source="drop database test; create database test;  use test; -- 425\nBEGIN;\n    CREATE TABLE t (i int);\n    INSERT INTO t VALUES(42), (24);\nCOMMIT;\nSELECT * FROM t LIMIT -1;\n"] [error="line 6 column 24 near \"-1;\n\" "] [errorVerbose="line 6 column 24 near \"-1;\n\" \ngithub.com/pingcap/errors.AddStack\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/errors.go:174\ngithub.com/pingcap/errors.Trace\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/juju_adaptor.go:15\ngithub.com/pingcap/parser.(*Parser).Parse\n\t/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20190903084634-0daf3f706c76/yy_parser.go:150\ngithub.com/pingcap/tidb/session.Parse\n\t/go/pkg/mod/github.com/pingcap/tidb@v1.1.0-beta.0.20190911032414-d88cd749f56d/session/tidb.go:143\nmain.runTest\n\t/home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/tidb_test/main.go:289\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1700"]
[mysql] 2025/04/01 18:03:26 packets.go:122: closing bad idle connection: EOF
[mysql] 2025/04/01 18:03:26 packets.go:174: failed to write
.....................................................[2025/04/01 18:03:31.145 +08:00] [WARN] [tidb.go:148] [compiling] [source="drop database test; create database test;  use test; -- 479\nSELECT Name, Unique FROM __Index;\n"] [error="line 2 column 20 near \"Unique FROM __Index;\n\" "] [errorVerbose="line 2 column 20 near \"Unique FROM __Index;\n\" \ngithub.com/pingcap/errors.AddStack\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/errors.go:174\ngithub.com/pingcap/errors.Trace\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/juju_adaptor.go:15\ngithub.com/pingcap/parser.(*Parser).Parse\n\t/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20190903084634-0daf3f706c76/yy_parser.go:150\ngithub.com/pingcap/tidb/session.Parse\n\t/go/pkg/mod/github.com/pingcap/tidb@v1.1.0-beta.0.20190911032414-d88cd749f56d/session/tidb.go:143\nmain.runTest\n\t/home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/tidb_test/main.go:289\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1700"]
[mysql] 2025/04/01 18:03:32 statement.go:54: invalid connection
./t/enum_expression_4.test: ok! 1031 test cases passed, take time 9.866012567 s
time="2025-04-01T18:03:32+08:00" level=info msg="run test [enum_expression_4] ok"
time="2025-04-01T18:03:32+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0001fc110 {{} {} 0} {0 0} [0xc000324480] {[]} 1 0xc000742460 false map[0xc000324480:map[0xc000324480:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:03:32+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
2025/04/01 18:03:35 testing mysql...

2025/04/01 18:03:36 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/tests_test.go:109 SLOW SQL >= 200ms
[361.083ms] [rows:0] CREATE TABLE `accounts` (`id` bigint unsigned AUTO_INCREMENT,`created_at` datetime(3) NULL,`updated_at` datetime(3) NULL,`deleted_at` datetime(3) NULL,`user_id` bigint unsigned,`number` longtext,PRIMARY KEY (`id`),INDEX idx_accounts_deleted_at (`deleted_at`),CONSTRAINT `fk_users_account` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`))

2025/04/01 18:03:36 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/associations_belongs_to_test.go:139 Error 1452: Cannot add or update a child row: a foreign key constraint fails (`test`.`users`, CONSTRAINT `fk_users_company` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`))
[2.152ms] [rows:0] INSERT INTO `users` (`created_at`,`updated_at`,`deleted_at`,`name`,`age`,`birthday`,`company_id`,`manager_id`,`active`) VALUES ('2025-04-01 18:03:36.892','2025-04-01 18:03:36.892',NULL,'invalid-user-with-invalid-belongs-to-foreign-key',0,NULL,10000001,NULL,false)

2025/04/01 18:03:38 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/associations_many2many_test.go:99 Error 1452: Cannot add or update a child row: a foreign key constraint fails (`test`.`user_speaks`, CONSTRAINT `fk_user_speaks_language` FOREIGN KEY (`language_code`) REFERENCES `languages` (`code`))
[2.781ms] [rows:0] INSERT INTO `user_speaks` (`user_id`,`language_code`) VALUES (53,'many2many_omit_associations_locale_1'),(53,'many2many_omit_associations_locale_2') ON DUPLICATE KEY UPDATE `user_id`=`user_id`

2025/04/01 18:03:38 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/associations_many2many_test.go:99 Error 1452: Cannot add or update a child row: a foreign key constraint fails (`test`.`user_speaks`, CONSTRAINT `fk_user_speaks_language` FOREIGN KEY (`language_code`) REFERENCES `languages` (`code`))
[6.597ms] [rows:1] INSERT INTO `users` (`created_at`,`updated_at`,`deleted_at`,`name`,`age`,`birthday`,`company_id`,`manager_id`,`active`) VALUES ('2025-04-01 18:03:38.378','2025-04-01 18:03:38.378',NULL,'many2many_omit_associations',18,'2025-04-01 18:03:38',NULL,NULL,false)

2025/04/01 18:03:38 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/associations_many2many_test.go:118 Error 1452: Cannot add or update a child row: a foreign key constraint fails (`test`.`user_speaks`, CONSTRAINT `fk_user_speaks_language` FOREIGN KEY (`language_code`) REFERENCES `languages` (`code`))
[2.681ms] [rows:0] INSERT INTO `user_speaks` (`user_id`,`language_code`) VALUES (53,'omitmany2many') ON DUPLICATE KEY UPDATE `user_id`=`user_id`

2025/04/01 18:03:38 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/associations_many2many_test.go:118 Error 1452: Cannot add or update a child row: a foreign key constraint fails (`test`.`user_speaks`, CONSTRAINT `fk_user_speaks_language` FOREIGN KEY (`language_code`) REFERENCES `languages` (`code`))
[7.074ms] [rows:1] UPDATE `users` SET `updated_at`='2025-04-01 18:03:38.404' WHERE `users`.`deleted_at` IS NULL AND `id` = 53

2025/04/01 18:03:38 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/associations_test.go:66 Error 1048: Column 'member_id' cannot be null
[5.600ms] [rows:0] UPDATE `profiles` SET `member_id`=NULL WHERE `profiles`.`member_id` = 1 AND `profiles`.`deleted_at` IS NULL

2025/04/01 18:03:39 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/associations_test.go:117 record not found
[2.123ms] [rows:0] SELECT * FROM `members` WHERE `members`.`id` = 1 ORDER BY `members`.`id` LIMIT 1

2025/04/01 18:03:39 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/associations_test.go:121 record not found
[2.025ms] [rows:0] SELECT * FROM `profiles` WHERE `profiles`.`id` = 1 AND `profiles`.`id` = 1 ORDER BY `profiles`.`id` LIMIT 1

2025/04/01 18:03:39 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/associations_test.go:171 record not found
[1.285ms] [rows:0] SELECT * FROM `members` WHERE `members`.`id` = 1 ORDER BY `members`.`id` LIMIT 1

2025/04/01 18:03:39 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/associations_test.go:175 record not found
[1.053ms] [rows:0] SELECT * FROM `profiles` WHERE `profiles`.`id` = 1 AND `profiles`.`id` = 1 ORDER BY `profiles`.`id` LIMIT 1

2025/04/01 18:03:39 /usr/local/go/src/reflect/value.go:581
[error] Got error when compile callbacks, got conflicting callback c3 with before c1

2025/04/01 18:03:39 /usr/local/go/src/reflect/value.go:581
[warn] removing callback `c2` from /usr/local/go/src/reflect/value.go:581

2025/04/01 18:03:39 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/connpool_test.go:151 record not found
[3.526ms] [rows:0] SELECT * FROM `users` WHERE name = 'transaction' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:03:39 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/count_test.go:153 model value required when using preload
[4.146ms] [rows:1] SELECT count(*) FROM `users` WHERE name in ('count-1','count-2','count-3')

2025/04/01 18:03:41 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/create_test.go:352 empty slice found
[1.095ms] [rows:0] INSERT INTO `users` (`created_at`,`updated_at`,`deleted_at`,`name`,`age`,`birthday`,`company_id`,`manager_id`,`active`) VALUES 

2025/04/01 18:03:41 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/create_test.go:357 empty slice found
[0.760ms] [rows:0] INSERT INTO `users` VALUES()

2025/04/01 18:03:41 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/create_test.go:369 slice data #2 is invalid: unsupported data
[0.706ms] [rows:0] INSERT INTO `users` (`created_at`,`updated_at`,`deleted_at`,`name`,`age`,`birthday`,`company_id`,`manager_id`,`active`) VALUES ('2025-04-01 18:03:41.217','2025-04-01 18:03:41.217',NULL,'invalid_slice_1',18,'2025-04-01 18:03:41',NULL,NULL,false),('2025-04-01 18:03:41.217','2025-04-01 18:03:41.217',NULL,'invalid_slice_2',18,'2025-04-01 18:03:41',NULL,NULL,false),()

2025/04/01 18:03:41 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/customize_field_test.go:143 record not found
[4.737ms] [rows:0] SELECT * FROM `customize_field_structs` WHERE `customize_field_structs`.`name` = 'create' AND `customize_field_structs`.`field_readonly` = 'create_allow_readonly' AND `customize_field_structs`.`deleted_at` IS NULL ORDER BY `customize_field_structs`.`id` LIMIT 1

2025/04/01 18:03:42 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/default_value_test.go:24 SLOW SQL >= 200ms
[330.342ms] [rows:0] CREATE TABLE `harumphs` (`id` bigint unsigned AUTO_INCREMENT,`created_at` datetime(3) NULL,`updated_at` datetime(3) NULL,`deleted_at` datetime(3) NULL,`email` varchar(191) NOT NULL,`name` varchar(191) NOT NULL DEFAULT 'foo',`name2` varchar(233) NOT NULL DEFAULT 'foo',`name3` varchar(233) NOT NULL DEFAULT '',`age` bigint DEFAULT 18,`created` datetime(3) NULL DEFAULT '2000-01-02 00:00:00',`enabled` boolean DEFAULT true,PRIMARY KEY (`id`),INDEX idx_harumphs_deleted_at (`deleted_at`),UNIQUE INDEX idx_harumphs_email (`email`))

2025/04/01 18:03:42 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/delete_test.go:30 record not found
[2.429ms] [rows:0] SELECT * FROM `users` WHERE id = 231 AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:03:42 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/delete_test.go:52 WHERE conditions required
[0.752ms] [rows:0] UPDATE `users` SET `deleted_at`='2025-04-01 18:03:42.169' WHERE `users`.`deleted_at` IS NULL

2025/04/01 18:03:42 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/delete_test.go:56 record not found
[1.230ms] [rows:0] SELECT * FROM `users` WHERE id = 230 AND `users`.`deleted_at` IS NULL AND `users`.`id` = 232 ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:03:42 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/delete_test.go:85 record not found
[1.103ms] [rows:0] SELECT * FROM `deleted_users` WHERE `deleted_users`.`id` = 1 AND `deleted_users`.`deleted_at` IS NULL ORDER BY `deleted_users`.`id` LIMIT 1

2025/04/01 18:03:42 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/delete_test.go:99 record not found
[1.059ms] [rows:0] SELECT * FROM `deleted_users` WHERE `deleted_users`.`id` = 1 ORDER BY `deleted_users`.`id` LIMIT 1

2025/04/01 18:03:42 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/delete_test.go:111 record not found
[3.819ms] [rows:0] SELECT * FROM `users` WHERE name = 'inline_delete_1' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:03:42 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/delete_test.go:117 record not found
[3.424ms] [rows:0] SELECT * FROM `users` WHERE name = 'inline_delete_2' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:03:42 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/delete_test.go:123 WHERE conditions required
[0.820ms] [rows:0] UPDATE `users` SET `deleted_at`='2025-04-01 18:03:42.253' WHERE `users`.`deleted_at` IS NULL

2025/04/01 18:03:43 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/embedded_struct_test.go:165 SLOW SQL >= 200ms
[256.280ms] [rows:0] ALTER TABLE `user_friends` ADD CONSTRAINT `fk_user_friends_advanced_user` FOREIGN KEY (`advanced_user_id`) REFERENCES `advanced_users`(`id`)

2025/04/01 18:03:43 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/embedded_struct_test.go:165 SLOW SQL >= 200ms
[250.098ms] [rows:0] ALTER TABLE `user_speaks` ADD CONSTRAINT `fk_user_speaks_advanced_user` FOREIGN KEY (`advanced_user_id`) REFERENCES `advanced_users`(`id`)

2025/04/01 18:03:44 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/hooks_test.go:133 record not found
[2.073ms] [rows:0] SELECT * FROM `products` WHERE Code = 'unique_code' AND `products`.`deleted_at` IS NULL AND `products`.`id` = 1 ORDER BY `products`.`id` LIMIT 1

2025/04/01 18:03:44 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/hooks_test.go:156 record not found
[3.514ms] [rows:0] SELECT * FROM `products` WHERE code = 'Invalid' AND `products`.`deleted_at` IS NULL ORDER BY `products`.`id` LIMIT 1

2025/04/01 18:03:44 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/hooks_test.go:176 record not found
[2.144ms] [rows:0] SELECT * FROM `products` WHERE code = 'dont_update' AND `products`.`deleted_at` IS NULL ORDER BY `products`.`id` LIMIT 1

2025/04/01 18:03:44 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/hooks_test.go:196 can't save
[3.556ms] [rows:1] INSERT INTO `products` (`created_at`,`updated_at`,`deleted_at`,`name`,`code`,`price`,`after_find_call_times`,`before_create_call_times`,`after_create_call_times`,`before_update_call_times`,`after_update_call_times`,`before_save_call_times`,`after_save_call_times`,`before_delete_call_times`,`after_delete_call_times`) VALUES ('2025-04-01 18:03:44.173','2025-04-01 18:03:44.173',NULL,'','after_save_error',100.000000,0,1,0,0,0,1,0,0,0)

2025/04/01 18:03:44 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/hooks_test.go:197 record not found
[2.162ms] [rows:0] SELECT * FROM `products` WHERE code = 'after_save_error' AND `products`.`deleted_at` IS NULL ORDER BY `products`.`id` LIMIT 1

2025/04/01 18:03:44 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/hooks_test.go:207 can't delete
[4.797ms] [rows:1] UPDATE `products` SET `deleted_at`='2025-04-01 18:03:44.19' WHERE `products`.`id` = 4 AND `products`.`deleted_at` IS NULL

2025/04/01 18:03:44 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/hooks_test.go:485 invalid item
[5.183ms] [rows:1] INSERT INTO `product4` (`created_at`,`updated_at`,`deleted_at`,`name`,`code`,`price`,`owner`) VALUES ('2025-04-01 18:03:44.65','2025-04-01 18:03:44.65',NULL,'Product-1','',100,'')

2025/04/01 18:03:44 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/hooks_test.go:489 record not found
[3.034ms] [rows:0] SELECT * FROM `product4` WHERE name = 'Product-1' AND `product4`.`deleted_at` IS NULL ORDER BY `product4`.`id` LIMIT 1

2025/04/01 18:03:45 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/joins_test.go:82 record not found
[14.364ms] [rows:0] SELECT `users`.`id`,`users`.`created_at`,`users`.`updated_at`,`users`.`deleted_at`,`users`.`name`,`users`.`age`,`users`.`birthday`,`users`.`company_id`,`users`.`manager_id`,`users`.`active` FROM `users` inner join pets on pets.user_id = users.id AND pets.name = 'joins-conds_pet_1' join accounts on accounts.user_id = users.id AND accounts.number = 'joins-conds_accountnon-exist' WHERE users.name = 'joins-conds' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:03:45 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/joins_test.go:107 dry run mode unsupported
[0.051ms] [rows:0] SELECT id, name, iv.total, iv.paid, iv.balance FROM `table_employees` LEFT JOIN (SELECT seller, SUM(total) as total, SUM(paid) as paid, SUM(balance) as balance FROM `table_invoices` GROUP BY `seller`) AS iv ON iv.seller = table_employees.id

2025/04/01 18:03:45 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/main_test.go:19 Error 1054: Unknown column 'sdsd.zaaa' in 'where clause'
[0.438ms] [rows:0] SELECT `aaa` FROM `users` WHERE sdsd.zaaa = 'sd;;;aa' AND `users`.`deleted_at` IS NULL

2025/04/01 18:03:45 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/main_test.go:23 Error 1054: Unknown column 'sdsd.zaaa' in 'where clause'
[0.738ms] [rows:0] SELECT * FROM `users` WHERE sdsd.zaaa = 'sd;;;aa' AND `users`.`deleted_at` IS NULL

2025/04/01 18:03:45 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/main_test.go:33 record not found
[5.616ms] [rows:0] SELECT * FROM `users` WHERE name = 'jinzhu; delete * from users' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:03:55 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/named_argument_test.go:72 record not found
[3.051ms] [rows:0] SELECT * FROM `named_users` WHERE (name1 = 'jinzhu-new' OR name2 = 'jinzhu-new') AND name3 = 'jinzhu-new3' AND `named_users`.`deleted_at` IS NULL ORDER BY `named_users`.`id` LIMIT 1

2025/04/01 18:03:55 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/named_argument_test.go:79 record not found
[1.973ms] [rows:0] SELECT * FROM `named_users` WHERE (name1 = 'jinzhu-new' OR name2 = 'jinzhu-new') AND `named_users`.`deleted_at` IS NULL ORDER BY `named_users`.`id` LIMIT 1

2025/04/01 18:03:56 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/preload_suits_test.go:56 record not found
[2.495ms] [rows:0] SELECT * FROM `level3` WHERE name = 'not_found' AND `level3`.`id` = 1 ORDER BY `level3`.`id` LIMIT 1
[mysql] 2025/04/01 18:03:54 packets.go:59: malformed packet
[mysql] 2025/04/01 18:03:54 packets.go:37: connection is closed
[mysql] 2025/04/01 18:03:54 packets.go:37: too many reads
PASS
ok  	github.com/go-sql-driver/mysql	36.818s
gosqltest end
[Pipeline] }
[Pipeline] // container
[Pipeline] }
Cache not saved (ws/jenkins-pingcap-tidb-merged_integration_common_test-3297/tidb-test already exists)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }

2025/04/01 18:04:02 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/preload_suits_test.go:941 record not found
[2.525ms] [rows:0] SELECT * FROM `level3` WHERE value = 'not_found' AND `level3`.`id` = 1 ORDER BY `level3`.`id` LIMIT 1

2025/04/01 18:04:02 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/preload_suits_test.go:996 record not found
[3.422ms] [rows:0] SELECT * FROM `level3` WHERE value = 'not_found' AND `level3`.`id` = 1 ORDER BY `level3`.`id` LIMIT 1

2025/04/01 18:04:05 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/preload_suits_test.go:1268 record not found
[2.247ms] [rows:0] SELECT * FROM `level2` WHERE value = 'bogus' ORDER BY `level2`.`id` LIMIT 1
......................................................................................................................................................................................................[2025/04/01 18:04:07.798 +08:00] [WARN] [tidb.go:148] [compiling] [source="drop database test; create database test;  use test; -- 710\nBEGIN;\n    CREATE TABLE t (i TEXT) DEFAULT CHARSET Badcharset;\nCOMMIT;\n"] [error="[parser:1115]Unknown character set: 'Badcharset'"] [errorVerbose="[parser:1115]Unknown character set: 'Badcharset'\ngithub.com/pingcap/errors.AddStack\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/errors.go:174\ngithub.com/pingcap/parser/terror.(*Error).GenWithStackByArgs\n\t/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20190903084634-0daf3f706c76/terror/terror.go:238\ngithub.com/pingcap/parser.yyParse\n\t/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20190903084634-0daf3f706c76/parser.go:14055\ngithub.com/pingcap/parser.(*Parser).Parse\n\t/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20190903084634-0daf3f706c76/yy_parser.go:141\ngithub.com/pingcap/tidb/session.Parse\n\t/go/pkg/mod/github.com/pingcap/tidb@v1.1.0-beta.0.20190911032414-d88cd749f56d/session/tidb.go:143\nmain.runTest\n\t/home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/tidb_test/main.go:289\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1700"]

2025/04/01 18:04:08 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/query_test.go:378 Error 1146: Table 'test.wrong_table' doesn't exist
[0.299ms] [rows:0] SELECT * FROM `wrong_table` WHERE name = 'find_in_batches_with_error' AND `wrong_table`.`deleted_at` IS NULL ORDER BY `wrong_table`.`id` LIMIT 2

2025/04/01 18:04:08 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/query_test.go:1007 Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 97 near "OFFSET 3" 
[0.456ms] [rows:20] SELECT * FROM `users` WHERE name like 'OffsetUser%' AND `users`.`deleted_at` IS NULL ORDER BY age desc OFFSET 3

2025/04/01 18:04:08 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/query_test.go:1169 sql: Scan error on column index 0, name "avgage": unsupported Scan, storing driver.Value type []uint8 into type *tests.User; sql: Scan error on column index 0, name "avgage": unsupported Scan, storing driver.Value type []uint8 into type *tests.User
[8.740ms] [rows:2] SELECT AVG(age) as avgage FROM `users` WHERE name LIKE 'subquery_having%' AND `users`.`deleted_at` IS NULL GROUP BY `name` HAVING AVG(age) > (SELECT AVG(age) FROM `users` WHERE name LIKE 'subquery_having%')

2025/04/01 18:04:09 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/scanner_valuer_test.go:123 sql: converting argument $11 type: Should not start with 'x'
[0.781ms] [rows:0] INSERT INTO `scanner_valuer_structs` (`created_at`,`updated_at`,`deleted_at`,`name`,`gender`,`age`,`male`,`height`,`birthday`,`allergen`,`password`,`bytes`,`num`,`strings`,`structs`,`role`,`user_id`,`empty_time`,`example_struct`,`example_struct_ptr`) VALUES ('2025-04-01 18:04:09.629','2025-04-01 18:04:09.629',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','0','null','null','',NULL,'2025-04-01 18:04:09.629','{"Name":"","Val":"value1"}','{"Name":"","Val":"value2"}')

2025/04/01 18:04:09 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/scanner_valuer_test.go:132 sql: converting argument $1 type: Should not start with 'x'
[0.776ms] [rows:0] UPDATE `scanner_valuer_structs` SET `password`=NULL,`updated_at`='2025-04-01 18:04:09.639' WHERE `scanner_valuer_structs`.`deleted_at` IS NULL AND `id` = 1
.............................
Great, All tests passed
TIDB TEST END
TIDB TEST FINISHED SUCCESSFULLY!
[Pipeline] }
[Pipeline] // container
[Pipeline] }
Cache not saved (ws/jenkins-pingcap-tidb-merged_integration_common_test-3297/tidb-test already exists)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv

2025/04/01 18:04:10 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/scopes_test.go:54 SLOW SQL >= 200ms
[212.177ms] [rows:0] ALTER TABLE `custom_table` ADD CONSTRAINT `fk_custom_table_company` FOREIGN KEY (`company_id`) REFERENCES `companies`(`id`)

2025/04/01 18:04:10 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/scopes_test.go:54 SLOW SQL >= 200ms
[222.164ms] [rows:0] ALTER TABLE `custom_table` ADD CONSTRAINT `fk_custom_table_manager` FOREIGN KEY (`manager_id`) REFERENCES `users`(`id`)
[Pipeline] }
[Pipeline] // stage
[Pipeline] }

2025/04/01 18:04:11 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/soft_delete_test.go:42 record not found
[4.468ms] [rows:0] SELECT * FROM `users` WHERE name = 'SoftDelete' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:04:11 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/soft_delete_test.go:71 record not found
[2.831ms] [rows:0] SELECT * FROM `users` WHERE name = 'SoftDelete' ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:04:11 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/sql_builder_test.go:99 record not found
[4.708ms] [rows:0] SELECT * FROM `users` WHERE name in ('ExecRawSqlUser1','ExecRawSqlUser2','ExecRawSqlUser3') AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:04:11 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/transaction_test.go:40 record not found
[4.275ms] [rows:0] SELECT * FROM `users` WHERE name = 'transaction' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:04:11 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/transaction_test.go:109 record not found
[4.644ms] [rows:0] SELECT * FROM `users` WHERE name = 'transaction-block' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:04:11 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/transaction_test.go:146 record not found
[4.280ms] [rows:0] SELECT * FROM `users` WHERE name = 'transaction-block-3' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:04:11 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/transaction_test.go:192 record not found
[4.451ms] [rows:0] SELECT * FROM `users` WHERE name = 'transaction-save-point-1' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:04:11 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/transaction_test.go:215 record not found
[4.738ms] [rows:0] SELECT * FROM `users` WHERE name = 'transaction-save-point-1' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:04:12 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/transaction_test.go:250 record not found
[4.655ms] [rows:0] SELECT * FROM `users` WHERE name = 'transaction-nested-1' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1

2025/04/01 18:04:12 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/transaction_test.go:278 record not found
[4.210ms] [rows:0] SELECT * FROM `users` WHERE name = 'transaction-nested-1' AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1
2025/04/01 18:04:12 testing mysql...

2025/04/01 18:04:14 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/update_test.go:236 WHERE conditions required
[0.877ms] [rows:0] UPDATE `users` SET `name`='jinzhu',`updated_at`='2025-04-01 18:04:14.755' WHERE `users`.`deleted_at` IS NULL

2025/04/01 18:04:18 /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_common_test/tidb-test/gorm_test/gorm/tests/upsert_test.go:284 Error 1062: Duplicate entry '259' for key 'users.PRIMARY'
[2.555ms] [rows:0] INSERT INTO `users` (`created_at`,`updated_at`,`deleted_at`,`name`,`age`,`birthday`,`company_id`,`manager_id`,`active`,`id`) VALUES ('2025-04-01 18:04:18.653','2025-04-01 18:04:18.668',NULL,'find or create 4',44,NULL,NULL,NULL,false,259)
PASS
ok  	gorm.io/gorm/tests	43.279s
gormtest end
[Pipeline] }
[Pipeline] // container
[Pipeline] }
Cache not saved (ws/jenkins-pingcap-tidb-merged_integration_common_test-3297/tidb-test already exists)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
./t/generated_columns.test: ok! 499 test cases passed, take time 57.747988091 s
time="2025-04-01T18:04:30+08:00" level=info msg="run test [generated_columns] ok"
time="2025-04-01T18:04:30+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0001fd678 {{} {} 0} {0 0} [0xc0001b5a80] {[]} 1 0xc0005d8620 false map[0xc0001b5a80:map[0xc0001b5a80:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:04:30+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/greatest.test: ok! 1551 test cases passed, take time 7.067269349 s
time="2025-04-01T18:04:37+08:00" level=info msg="run test [greatest] ok"
time="2025-04-01T18:04:37+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0000f05f0 {{} {} 0} {0 0} [0xc00051d800] {[]} 1 0xc00042ad90 false map[0xc00051d800:map[0xc00051d800:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:04:37+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/ifnull.test: ok! 1178 test cases passed, take time 4.886826919 s
time="2025-04-01T18:04:43+08:00" level=info msg="run test [ifnull] ok"
time="2025-04-01T18:04:43+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0000f0178 {{} {} 0} {0 0} [0xc00063e200] {[]} 1 0xc0005d8150 false map[0xc00063e200:map[0xc00063e200:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:04:43+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/index_join_union_scan.test: ok! 3076 test cases passed, take time 41.918267392 s
time="2025-04-01T18:05:25+08:00" level=info msg="run test [index_join_union_scan] ok"
time="2025-04-01T18:05:25+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0001fc020 {{} {} 0} {0 0} [0xc002534200] {[]} 1 0xc0005d8070 false map[0xc002534200:map[0xc002534200:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:05:25+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/isnull.test: ok! 1551 test cases passed, take time 5.784857844 s
time="2025-04-01T18:05:31+08:00" level=info msg="run test [isnull] ok"
time="2025-04-01T18:05:31+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc001646530 {{} {} 0} {0 0} [0xc0002eec80] {[]} 1 0xc0004a7500 false map[0xc0002eec80:map[0xc0002eec80:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:05:31+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/least.test: ok! 1551 test cases passed, take time 5.68356362 s
time="2025-04-01T18:05:36+08:00" level=info msg="run test [least] ok"
time="2025-04-01T18:05:36+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0016468d0 {{} {} 0} {0 0} [0xc00062b800] {[]} 1 0xc0002c5c00 false map[0xc00062b800:map[0xc00062b800:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:05:36+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/partition.test: ok! 791 test cases passed, take time 6.747735174 s
time="2025-04-01T18:05:43+08:00" level=info msg="run test [partition] ok"
time="2025-04-01T18:05:43+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0016465c0 {{} {} 0} {0 0} [0xc000300100] {[]} 1 0xc000439f80 false map[0xc000300100:map[0xc000300100:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:05:43+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/plus.test: ok! 1551 test cases passed, take time 5.9249482 s
time="2025-04-01T18:05:49+08:00" level=info msg="run test [plus] ok"
time="2025-04-01T18:05:49+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0000f0238 {{} {} 0} {0 0} [0xc000208480] {[]} 1 0xc0001b8310 false map[0xc000208480:map[0xc000208480:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:05:49+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/point_get.test: ok! 3076 test cases passed, take time 13.185198705 s
time="2025-04-01T18:06:03+08:00" level=info msg="run test [point_get] ok"
time="2025-04-01T18:06:03+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc00072e018 {{} {} 0} {0 0} [0xc0008a2000] {[]} 1 0xc0007ae000 false map[0xc0008a2000:map[0xc0008a2000:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:06:03+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/udaf_avg.test: ok! 2551 test cases passed, take time 11.506032581 s
time="2025-04-01T18:06:14+08:00" level=info msg="run test [udaf_avg] ok"
time="2025-04-01T18:06:14+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0000f04d8 {{} {} 0} {0 0} [0xc00042b900] {[]} 1 0xc0006591f0 false map[0xc00042b900:map[0xc00042b900:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:06:14+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/udaf_avg_union.test: ok! 1051 test cases passed, take time 6.61946484 s
time="2025-04-01T18:06:21+08:00" level=info msg="run test [udaf_avg_union] ok"
time="2025-04-01T18:06:21+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0000f0270 {{} {} 0} {0 0} [0xc000212200] {[]} 1 0xc00003a3f0 false map[0xc000212200:map[0xc000212200:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:06:21+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/udaf_bitand.test: ok! 1050 test cases passed, take time 4.630021954 s
time="2025-04-01T18:06:26+08:00" level=info msg="run test [udaf_bitand] ok"
time="2025-04-01T18:06:26+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0006321d8 {{} {} 0} {0 0} [0xc0005ce000] {[]} 1 0xc00064e540 false map[0xc0005ce000:map[0xc0005ce000:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:06:26+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/udaf_bitand_union.test: ok! 1051 test cases passed, take time 5.385641733 s
time="2025-04-01T18:06:31+08:00" level=info msg="run test [udaf_bitand_union] ok"
time="2025-04-01T18:06:31+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc000804748 {{} {} 0} {0 0} [0xc000259800] {[]} 1 0xc00003ae00 false map[0xc000259800:map[0xc000259800:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:06:31+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/udaf_bitor.test: ok! 1050 test cases passed, take time 4.575780687 s
time="2025-04-01T18:06:36+08:00" level=info msg="run test [udaf_bitor] ok"
time="2025-04-01T18:06:36+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc000804610 {{} {} 0} {0 0} [0xc000259400] {[]} 1 0xc00003b2d0 false map[0xc000259400:map[0xc000259400:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:06:36+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/udaf_bitor_union.test: ok! 1051 test cases passed, take time 5.988699104 s
time="2025-04-01T18:06:42+08:00" level=info msg="run test [udaf_bitor_union] ok"
time="2025-04-01T18:06:42+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0008043a8 {{} {} 0} {0 0} [0xc000271780] {[]} 1 0xc00003abd0 false map[0xc000271780:map[0xc000271780:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:06:42+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/udaf_bitxor.test: ok! 1050 test cases passed, take time 5.013995712 s
time="2025-04-01T18:06:47+08:00" level=info msg="run test [udaf_bitxor] ok"
time="2025-04-01T18:06:47+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0001585b8 {{} {} 0} {0 0} [0xc000480000] {[]} 1 0xc0003bb9d0 false map[0xc000480000:map[0xc000480000:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:06:47+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/udaf_bitxor_union.test: ok! 1051 test cases passed, take time 5.326254011 s
time="2025-04-01T18:06:53+08:00" level=info msg="run test [udaf_bitxor_union] ok"
time="2025-04-01T18:06:53+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc00048a128 {{} {} 0} {0 0} [0xc0001b5d00] {[]} 1 0xc000542230 false map[0xc0001b5d00:map[0xc0001b5d00:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:06:53+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/udaf_count.test: ok! 945 test cases passed, take time 4.258847433 s
time="2025-04-01T18:06:57+08:00" level=info msg="run test [udaf_count] ok"
time="2025-04-01T18:06:57+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc000158318 {{} {} 0} {0 0} [0xc00020e380] {[]} 1 0xc00003b110 false map[0xc00020e380:map[0xc00020e380:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:06:57+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/udaf_count_union.test: ok! 1051 test cases passed, take time 4.725955116 s
time="2025-04-01T18:07:02+08:00" level=info msg="run test [udaf_count_union] ok"
time="2025-04-01T18:07:02+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0006ea6d8 {{} {} 0} {0 0} [0xc000371180] {[]} 1 0xc00003b7a0 false map[0xc000371180:map[0xc000371180:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:07:02+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/udaf_group_concat.test: ok! 1551 test cases passed, take time 5.965085565 s
time="2025-04-01T18:07:08+08:00" level=info msg="run test [udaf_group_concat] ok"
time="2025-04-01T18:07:08+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0001586d0 {{} {} 0} {0 0} [0xc000371080] {[]} 1 0xc00003b3b0 false map[0xc000371080:map[0xc000371080:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:07:08+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/udaf_max_min.test: ok! 1008 test cases passed, take time 5.535333777 s
time="2025-04-01T18:07:14+08:00" level=info msg="run test [udaf_max_min] ok"
time="2025-04-01T18:07:14+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0006ea6a8 {{} {} 0} {0 0} [0xc0003cc980] {[]} 1 0xc0002031f0 false map[0xc0003cc980:map[0xc0003cc980:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:07:14+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/udaf_max_min_union.test: ok! 1051 test cases passed, take time 5.071476564 s
time="2025-04-01T18:07:19+08:00" level=info msg="run test [udaf_max_min_union] ok"
time="2025-04-01T18:07:19+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0002f4688 {{} {} 0} {0 0} [0xc000409680] {[]} 1 0xc00003b490 false map[0xc000409680:map[0xc000409680:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:07:19+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/udaf_sum.test: ok! 893 test cases passed, take time 5.516845966 s
time="2025-04-01T18:07:25+08:00" level=info msg="run test [udaf_sum] ok"
time="2025-04-01T18:07:25+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc000682810 {{} {} 0} {0 0} [0xc000408a80] {[]} 1 0xc000689a40 false map[0xc000408a80:map[0xc000408a80:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:07:25+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/udaf_sum_union.test: ok! 1051 test cases passed, take time 5.479773555 s
time="2025-04-01T18:07:30+08:00" level=info msg="run test [udaf_sum_union] ok"
time="2025-04-01T18:07:30+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0008a44f8 {{} {} 0} {0 0} [0xc000440980] {[]} 1 0xc000338b60 false map[0xc000440980:map[0xc000440980:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:07:30+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/udf_abs.test: ok! 1051 test cases passed, take time 4.63494951 s
time="2025-04-01T18:07:35+08:00" level=info msg="run test [udf_abs] ok"
time="2025-04-01T18:07:35+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0008a40f8 {{} {} 0} {0 0} [0xc000440380] {[]} 1 0xc0002c21c0 false map[0xc000440380:map[0xc000440380:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:07:35+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/udf_acos.test: ok! 1050 test cases passed, take time 5.05161974 s
time="2025-04-01T18:07:40+08:00" level=info msg="run test [udf_acos] ok"
time="2025-04-01T18:07:40+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0008a4558 {{} {} 0} {0 0} [0xc000441100] {[]} 1 0xc00003afc0 false map[0xc000441100:map[0xc000441100:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:07:40+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/udf_asin.test: ok! 1032 test cases passed, take time 4.492642571 s
time="2025-04-01T18:07:45+08:00" level=info msg="run test [udf_asin] ok"
time="2025-04-01T18:07:45+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0008a4160 {{} {} 0} {0 0} [0xc00032c200] {[]} 1 0xc000502770 false map[0xc00032c200:map[0xc00032c200:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:07:45+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/udf_ceil.test: ok! 1051 test cases passed, take time 5.079452052 s
time="2025-04-01T18:07:50+08:00" level=info msg="run test [udf_ceil] ok"
time="2025-04-01T18:07:50+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc000136510 {{} {} 0} {0 0} [0xc0005b7680] {[]} 1 0xc00003bb20 false map[0xc0005b7680:map[0xc0005b7680:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:07:50+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/udf_div.test: ok! 1051 test cases passed, take time 5.20541746 s
time="2025-04-01T18:07:55+08:00" level=info msg="run test [udf_div] ok"
time="2025-04-01T18:07:55+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0008a4248 {{} {} 0} {0 0} [0xc00032c400] {[]} 1 0xc00003a8c0 false map[0xc00032c400:map[0xc00032c400:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:07:55+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/udf_floor.test: ok! 1051 test cases passed, take time 5.260237553 s
time="2025-04-01T18:08:01+08:00" level=info msg="run test [udf_floor] ok"
time="2025-04-01T18:08:01+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0008a4668 {{} {} 0} {0 0} [0xc000488000] {[]} 1 0xc0007916c0 false map[0xc000488000:map[0xc000488000:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:08:01+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/udf_is_true_false.test: ok! 1051 test cases passed, take time 5.020512261 s
time="2025-04-01T18:08:06+08:00" level=info msg="run test [udf_is_true_false] ok"
time="2025-04-01T18:08:06+08:00" level=warning msg="Create new db&{{{} {} 0} 0xc0000f01b0 {{} {} 0} {0 0} [0xc00080a280] {[]} 1 0xc00048a0e0 false map[0xc00080a280:map[0xc00080a280:true]] map[] 0 0 0 0 <nil> 0 0 0 0 0x4a5ea0}"
time="2025-04-01T18:08:06+08:00" level=info msg="enable tidb_enable_analyze_snapshot"
./t/udf_logic_xor.test: ok! 1051 test cases passed, take time 5.488125341 s
time="2025-04-01T18:08:12+08:00" level=info msg="run test [udf_logic_xor] ok"

Great, All tests passed
RANDGEN TEST FINISHED SUCCESSFULLY!
[Pipeline] }
[Pipeline] // container
[Pipeline] }
Cache not saved (ws/jenkins-pingcap-tidb-merged_integration_common_test-3297/tidb-test already exists)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // parallel
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // withCredentials
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] End of Pipeline
Finished: SUCCESS