Console Output

Skipping 15 KB.. Full Log
JENKINS_HOME=/var/jenkins_home
GIT_COMMIT=73d1a8209bddec16d8d58403efcd7a20d12cf867
PATH=/go/bin:/usr/local/go/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
RUN_DISPLAY_URL=https://do.pingcap.net/jenkins/job/pingcap/job/tidb/job/ghpr_check/9372/display/redirect
GOPROXY=http://goproxy.apps.svc,https://proxy.golang.org,direct
_=/usr/bin/printenv
POD_CONTAINER=golang
PWD=/home/jenkins/agent/workspace/pingcap/tidb/ghpr_check
HUDSON_URL=https://do.pingcap.net/jenkins/
JOB_NAME=pingcap/tidb/ghpr_check
TZ=Asia/Shanghai
BUILD_DISPLAY_NAME=#9372
JENKINS_URL=https://do.pingcap.net/jenkins/
BUILD_ID=1791617603303641089
GOLANG_DOWNLOAD_SHA256=d0398903a16ba2232b389fb31032ddf57cac34efda306a0eebac34f0965a0742
JOB_BASE_NAME=ghpr_check
GIT_PREVIOUS_SUCCESSFUL_COMMIT=73d1a8209bddec16d8d58403efcd7a20d12cf867
RUN_TESTS_DISPLAY_URL=https://do.pingcap.net/jenkins/job/pingcap/job/tidb/job/ghpr_check/9372/display/redirect?page=tests
SHLVL=3
HOME=/home/jenkins
POD_LABEL=pingcap_tidb_ghpr_check_9372-3jzxr
GOROOT=/usr/local/go
GIT_BRANCH=origin/main
KUBERNETES_PORT_443_TCP_PROTO=tcp
CI=true
KUBERNETES_SERVICE_PORT_HTTPS=443
WORKSPACE_TMP=/home/jenkins/agent/workspace/pingcap/tidb/ghpr_check@tmp
EXECUTOR_NUMBER=0
JENKINS_SERVER_COOKIE=durable-0f026237f94058661f1361e079a52466d5f86c0bc907e3dd7130bafbe31113f4
NODE_LABELS=pingcap-tidb-ghpr-check-9372-3jzxr-s7r01-txr40 pingcap_tidb_ghpr_check_9372-3jzxr
GIT_URL=https://github.com/PingCAP-QE/ci.git
HUDSON_HOME=/var/jenkins_home
CLASSPATH=
NODE_NAME=pingcap-tidb-ghpr-check-9372-3jzxr-s7r01-txr40
GOPATH=/go
JOB_DISPLAY_URL=https://do.pingcap.net/jenkins/job/pingcap/job/tidb/job/ghpr_check/display/redirect
BUILD_NUMBER=9372
KUBERNETES_PORT_443_TCP_ADDR=10.233.0.1
KUBERNETES_PORT_443_TCP=tcp://10.233.0.1:443
GOLANG_DOWNLOAD_URL=https://dl.google.com/go/go1.21.0.linux-amd64.tar.gz
+ echo -------------------------
-------------------------
+ go env
GO111MODULE=''
GOARCH='amd64'
GOBIN=''
GOCACHE='/home/jenkins/.cache/go-build'
GOENV='/home/jenkins/.config/go/env'
GOEXE=''
GOEXPERIMENT=''
GOFLAGS=''
GOHOSTARCH='amd64'
GOHOSTOS='linux'
GOINSECURE=''
GOMODCACHE='/go/pkg/mod'
GONOPROXY=''
GONOSUMDB=''
GOOS='linux'
GOPATH='/go'
GOPRIVATE=''
GOPROXY='http://goproxy.apps.svc,https://proxy.golang.org,direct'
GOROOT='/usr/local/go'
GOSUMDB='sum.golang.org'
GOTMPDIR=''
GOTOOLCHAIN='auto'
GOTOOLDIR='/usr/local/go/pkg/tool/linux_amd64'
GOVCS=''
GOVERSION='go1.21.0'
GCCGO='gccgo'
GOAMD64='v1'
AR='ar'
CC='gcc'
CXX='g++'
CGO_ENABLED='1'
GOMOD='/dev/null'
GOWORK=''
CGO_CFLAGS='-O2 -g'
CGO_CPPFLAGS=''
CGO_CXXFLAGS='-O2 -g'
CGO_FFLAGS='-O2 -g'
CGO_LDFLAGS='-O2 -g'
PKG_CONFIG='pkg-config'
GOGCCFLAGS='-fPIC -m64 -pthread -Wl,--no-gc-sections -fmessage-length=0 -fdebug-prefix-map=/tmp/go-build2166786499=/tmp/go-build -gno-record-gcc-switches'
+ echo -------------------------
-------------------------
+ ls -l /dev/null
crw-rw-rw-. 1 root root 1, 3 May 18 07:51 /dev/null
+ echo 'debug command: kubectl -n jenkins-tidb exec -ti pingcap-tidb-ghpr-check-9372-3jzxr-s7r01-txr40 bash'
debug command: kubectl -n jenkins-tidb exec -ti pingcap-tidb-ghpr-check-9372-3jzxr-s7r01-txr40 bash
[Pipeline] container
[Pipeline] {
[Pipeline] sh
+ dig github.com

; <<>> DiG 9.18.16 <<>> github.com
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 3554
;; flags: qr aa rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 1

;; OPT PSEUDOSECTION:
; EDNS: version: 0, flags:; udp: 1232
; COOKIE: 76bfd4a1a127693e (echoed)
;; QUESTION SECTION:
;github.com.			IN	A

;; ANSWER SECTION:
github.com.		25	IN	A	20.205.243.166

;; Query time: 0 msec
;; SERVER: 169.254.25.10#53(169.254.25.10) (UDP)
;; WHEN: Fri May 17 23:52:09 UTC 2024
;; MSG SIZE  rcvd: 77

[Pipeline] script
[Pipeline] {
[Pipeline] }
[Pipeline] // script
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Checkout)
[Pipeline] dir
Running in /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb
[Pipeline] {
[Pipeline] cache
Cache restored successfully (git/pingcap/tidb/rev-f5ac93e)
540292608 bytes in 6.14 secs (87940780 bytes/sec)
[Pipeline] {
[Pipeline] script
[Pipeline] {
[Pipeline] withCredentials
Masking supported pattern matches of $SSH_KEY
[Pipeline] {
[Pipeline] sh
+ '[' -d /home/jenkins/.ssh ']'
+ mkdir /home/jenkins/.ssh
+ chmod 0700 /home/jenkins/.ssh
+ cp **** /home/jenkins/.ssh/id_rsa
+ chmod 400 /home/jenkins/.ssh/id_rsa
+ ssh-keyscan -t rsa,dsa github.com
# github.com:22 SSH-2.0-babeld-33961236
# github.com:22 SSH-2.0-babeld-33961236
[Pipeline] }
[Pipeline] // withCredentials
[Pipeline] retry
[Pipeline] {
[Pipeline] sh
git version 2.37.2
Reinitialized existing Git repository in /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/.git/
.git
HEAD is now at f5ac93e448 executor: add a new column `is_global` into `information_schema.tidb_indexes` table (#53345)
POST git-upload-pack (656 bytes)
POST git-upload-pack (973 bytes)
From https://github.com/pingcap/tidb
 = [up to date]            master               -> origin/master
 * [new ref]               refs/pull/53035/head -> origin/pr/53035/head
HEAD is now at f5ac93e448 executor: add a new column `is_global` into `information_schema.tidb_indexes` table (#53345)
🚧 Checkouting to base SHA:f5ac93e448a03665274272929b512ce66f05d67b...
HEAD is now at f5ac93e448 executor: add a new column `is_global` into `information_schema.tidb_indexes` table (#53345)
✅ Checked. 🎉
🧾 HEAD info:
f5ac93e448a03665274272929b512ce66f05d67b
f5ac93e448 executor: add a new column `is_global` into `information_schema.tidb_indexes` table (#53345)
335af251b3 config: set max token limit to 1M (#53361)
2ef3ac9e34 planner: skip fast-point-get for select-into-outfile statements (#53364)
🚧 Pre-merge heads of pull requests to base SHA: f5ac93e448a03665274272929b512ce66f05d67b ...
Updating f5ac93e448..fc7136ca3c
Fast-forward
 pkg/statistics/builder.go | 14 +++++++++-----
 1 file changed, 9 insertions(+), 5 deletions(-)
🧾 Pre-merged result:
fc7136ca3c28df5273f5024bdfe40116e7996564
fc7136ca3c minor reset
f5ac93e448 executor: add a new column `is_global` into `information_schema.tidb_indexes` table (#53345)
335af251b3 config: set max token limit to 1M (#53361)
✅ Pre merged 🎉
📁 update submodules ...
✅ update submodules done
✅ ~~~~~All done.~~~~~~
[Pipeline] }
[Pipeline] // retry
[Pipeline] }
[Pipeline] // script
[Pipeline] }
Cache saved successfully (git/pingcap/tidb/rev-f5ac93e-fc7136c)
540308480 bytes in 16.67 secs (32410242 bytes/sec)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Checks)
[Pipeline] withCredentials
Masking supported pattern matches of $CODECOV_TOKEN
[Pipeline] {
[Pipeline] dir
Running in /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb
[Pipeline] {
[Pipeline] sh
+ make gogenerate check integrationtest
go generate ./...
./tools/check/check-gogenerate.sh
go: downloading github.com/mgechev/revive v1.3.7
go: downloading github.com/pingcap/log v1.1.1-0.20240314023424-862ccc32f18d
go: downloading github.com/pingcap/kvproto v0.0.0-20240227073058-929ab83f9754
go: downloading go.uber.org/zap v1.27.0
go: downloading go.uber.org/mock v0.4.0
go: downloading github.com/aws/aws-sdk-go v1.50.0
go: downloading github.com/tikv/client-go/v2 v2.0.8-0.20240516031922-38e0dca30c8c
go: downloading github.com/gogo/protobuf v1.3.2
go: downloading golang.org/x/exp v0.0.0-20240404231335-c0f41cb1a7a0
go: downloading github.com/spf13/pflag v1.0.5
go: downloading github.com/BurntSushi/toml v1.3.2
go: downloading github.com/google/uuid v1.6.0
go: downloading github.com/pingcap/errors v0.11.5-0.20240318064555-6bd07397691f
go: downloading github.com/apache/skywalking-eyes v0.4.0
go: downloading github.com/opentracing/opentracing-go v1.2.0
go: downloading github.com/pkg/errors v0.9.1
go: downloading github.com/emirpasic/gods v1.18.1
go: downloading github.com/docker/go-units v0.5.0
go: downloading github.com/pingcap/failpoint v0.0.0-20220801062533-2eaa32854a6c
go: downloading golang.org/x/sync v0.7.0
go: downloading github.com/go-sql-driver/mysql v1.7.1
go: downloading github.com/coreos/go-semver v0.3.1
go: downloading github.com/google/btree v1.1.2
go: downloading github.com/tikv/pd/client v0.0.0-20240430080403-1679dbca25b3
go: downloading google.golang.org/grpc v1.63.2
go: downloading github.com/cheynewallace/tabby v1.1.1
go: downloading github.com/fatih/color v1.16.0
go: downloading github.com/stretchr/testify v1.9.0
go: downloading github.com/Masterminds/semver v1.5.0
go: downloading github.com/golang/protobuf v1.5.4
go: downloading github.com/cheggaaa/pb/v3 v3.0.8
go: downloading github.com/timakin/bodyclose v0.0.0-20240125160201-f835fa56326a
go: downloading cloud.google.com/go/storage v1.36.0
go: downloading github.com/tdakkota/asciicheck v0.2.0
go: downloading go.uber.org/multierr v1.11.0
go: downloading k8s.io/api v0.28.6
go: downloading github.com/klauspost/compress v1.17.7
go: downloading go.uber.org/atomic v1.11.0
go: downloading github.com/prometheus/client_golang v1.19.0
go: downloading github.com/vbauerster/mpb/v7 v7.5.3
go: downloading github.com/coocood/freecache v1.2.1
go: downloading github.com/ngaut/pools v0.0.0-20180318154953-b7bc8c42aac7
go: downloading github.com/pingcap/tipb v0.0.0-20240318032315-55a7867ddd50
go: downloading github.com/Azure/azure-sdk-for-go/sdk/azcore v1.9.1
go: downloading go.etcd.io/etcd/client/v3 v3.5.12
go: downloading golang.org/x/tools v0.21.0
go: downloading golang.org/x/term v0.20.0
go: downloading github.com/sourcegraph/appdash v0.0.0-20190731080439-ebfcffb1b5c0
go: downloading github.com/uber/jaeger-client-go v2.22.1+incompatible
go: downloading github.com/spf13/cobra v1.8.0
go: downloading go.etcd.io/etcd/client/pkg/v3 v3.5.12
go: downloading github.com/Azure/azure-sdk-for-go/sdk/azidentity v1.5.1
go: downloading go.etcd.io/etcd/api/v3 v3.5.12
go: downloading github.com/Azure/azure-sdk-for-go/sdk/storage/azblob v1.0.0
go: downloading go.opencensus.io v0.24.0
go: downloading github.com/prometheus/client_model v0.6.1
go: downloading honnef.co/go/tools v0.4.7
go: downloading github.com/grpc-ecosystem/go-grpc-middleware v1.4.0
go: downloading github.com/fatih/structtag v1.2.0
go: downloading github.com/aliyun/alibaba-cloud-sdk-go v1.61.1581
go: downloading github.com/opentracing/basictracer-go v1.0.0
go: downloading golang.org/x/net v0.25.0
go: downloading github.com/tiancaiamao/gp v0.0.0-20221230034425-4025bc8a4d4a
go: downloading github.com/pingcap/sysutil v1.0.1-0.20240311050922-ae81ee01f3a5
go: downloading github.com/go-resty/resty/v2 v2.11.0
go: downloading github.com/tidwall/btree v1.7.0
go: downloading github.com/shirou/gopsutil/v3 v3.24.4
go: downloading github.com/gorilla/mux v1.8.0
go: downloading github.com/joho/sqltocsv v0.0.0-20210428211105-a6d6801d59df
go: downloading github.com/twmb/murmur3 v1.1.6
go: downloading github.com/ks3sdklib/aws-sdk-go v1.2.9
go: downloading github.com/charithe/durationcheck v0.0.10
go: downloading github.com/prometheus/common v0.53.0
go: downloading golang.org/x/oauth2 v0.20.0
go: downloading cloud.google.com/go v0.112.0
go: downloading google.golang.org/api v0.162.0
go: downloading github.com/cockroachdb/pebble v1.1.0
go: downloading golang.org/x/sys v0.20.0
go: downloading github.com/cznic/mathutil v0.0.0-20181122101859-297441e03548
go: downloading github.com/blacktear23/go-proxyprotocol v1.0.6
go: downloading github.com/pingcap/fn v1.0.0
go: downloading gopkg.in/yaml.v2 v2.4.0
go: downloading github.com/kisielk/errcheck v1.7.0
go: downloading golang.org/x/text v0.15.0
go: downloading github.com/soheilhy/cmux v0.1.5
go: downloading github.com/tiancaiamao/appdash v0.0.0-20181126055449-889f96f722a2
go: downloading github.com/sourcegraph/appdash-data v0.0.0-20151005221446-73f23eafcf67
go: downloading github.com/carlmjohnson/flagext v0.21.0
go: downloading github.com/otiai10/copy v1.2.0
go: downloading github.com/spkg/bom v1.0.0
go: downloading github.com/jellydator/ttlcache/v3 v3.0.1
go: downloading github.com/xitongsys/parquet-go v1.5.5-0.20201110004701-b09c49d6d457
go: downloading github.com/mattn/go-colorable v0.1.13
go: downloading github.com/cespare/xxhash/v2 v2.3.0
go: downloading github.com/mattn/go-isatty v0.0.20
go: downloading gopkg.in/natefinch/lumberjack.v2 v2.2.1
go: downloading github.com/kyoh86/exportloopref v0.1.11
go: downloading github.com/ngaut/sync2 v0.0.0-20141008032647-7a24ed77b2ef
go: downloading github.com/gostaticanalysis/analysisutil v0.7.1
go: downloading github.com/dgraph-io/ristretto v0.1.1
go: downloading github.com/VividCortex/ewma v1.2.0
go: downloading github.com/mattn/go-runewidth v0.0.15
go: downloading github.com/gostaticanalysis/forcetypeassert v0.1.0
go: downloading github.com/daixiang0/gci v0.13.4
go: downloading github.com/golangci/gofmt v0.0.0-20231019111953-be8c47862aaa
go: downloading github.com/acarl005/stripansi v0.0.0-20180116102854-5a71ef0e047d
go: downloading github.com/golangci/golangci-lint v1.58.1
go: downloading github.com/golangci/gosec v0.0.0-20180901114220-8afd9cbb6cfb
go: downloading github.com/danjacques/gofslock v0.0.0-20191023191349-0a45f885bc37
go: downloading github.com/jfcg/sorty/v2 v2.1.0
go: downloading github.com/YangKeao/ldap/v3 v3.4.5-0.20230421065457-369a3bab1117
go: downloading github.com/dolthub/swiss v0.2.1
go: downloading google.golang.org/protobuf v1.33.0
go: downloading github.com/influxdata/tdigest v0.0.1
go: downloading github.com/gordonklaus/ineffassign v0.1.0
go: downloading github.com/lestrrat-go/jwx/v2 v2.0.21
go: downloading golang.org/x/time v0.5.0
go: downloading github.com/ashanbrown/makezero v1.1.1
go: downloading github.com/butuzov/mirror v1.2.0
go: downloading github.com/Azure/azure-sdk-for-go/sdk/internal v1.5.1
go: downloading github.com/AzureAD/microsoft-authentication-library-for-go v1.2.1
go: downloading golang.org/x/crypto v0.23.0
go: downloading github.com/dgryski/go-farm v0.0.0-20200201041132-a6ae2369ad13
go: downloading github.com/golangci/misspell v0.5.1
go: downloading github.com/cockroachdb/errors v1.11.1
go: downloading github.com/fatanugraha/noloopclosure v0.1.1
go: downloading github.com/golangci/prealloc v0.0.0-20180630174525-215b22d4de21
go: downloading github.com/nishanths/predeclared v0.2.2
go: downloading github.com/jingyugao/rowserrcheck v1.1.1
go: downloading github.com/cloudfoundry/gosigar v1.3.6
go: downloading github.com/bazelbuild/rules_go v0.42.1-0.20231101215950-df20c987afcb
go: downloading github.com/google/skylark v0.0.0-20181101142754-a5f7082aabed
go: downloading github.com/phayes/freeport v0.0.0-20180830031419-95f893ade6f2
go: downloading go.uber.org/automaxprocs v1.5.3
go: downloading github.com/jedib0t/go-pretty/v6 v6.2.2
go: downloading github.com/golang/snappy v0.0.4
go: downloading github.com/shurcooL/httpgzip v0.0.0-20190720172056-320755c1c1b0
go: downloading github.com/uber/jaeger-lib v2.4.1+incompatible
go: downloading github.com/sasha-s/go-deadlock v0.3.1
go: downloading github.com/beorn7/perks v1.0.1
go: downloading github.com/prometheus/procfs v0.13.0
go: downloading github.com/json-iterator/go v1.1.12
go: downloading github.com/asaskevich/govalidator v0.0.0-20230301143203-a9d515a09cc2
go: downloading github.com/pingcap/badger v1.5.1-0.20230103063557-828f39b09b6d
go: downloading go.uber.org/goleak v1.3.0
go: downloading github.com/Shopify/sarama v1.29.0
go: downloading github.com/robfig/cron/v3 v3.0.1
go: downloading cloud.google.com/go/compute/metadata v0.3.0
go: downloading github.com/remyoudompheng/bigfft v0.0.0-20230129092748-24d4a6f8daec
go: downloading github.com/google/pprof v0.0.0-20240117000934-35fc243c5815
go: downloading github.com/wangjohn/quickselect v0.0.0-20161129230411-ed8402a42d5f
go: downloading github.com/xitongsys/parquet-go-source v0.0.0-20200817004010-026bad9b25d0
go: downloading github.com/bazelbuild/buildtools v0.0.0-20230926111657-7d855c59baeb
go: downloading cloud.google.com/go/iam v1.1.6
go: downloading github.com/googleapis/gax-go/v2 v2.12.0
go: downloading google.golang.org/genproto v0.0.0-20240227224415-6ceb2ff114de
go: downloading github.com/gostaticanalysis/comment v1.4.2
go: downloading github.com/davecgh/go-spew v1.1.2-0.20180830191138-d8f796af33cc
go: downloading github.com/pmezard/go-difflib v1.0.1-0.20181226105442-5d4384ee4fb2
go: downloading gopkg.in/yaml.v3 v3.0.1
go: downloading github.com/rivo/uniseg v0.4.6
go: downloading github.com/shurcooL/vfsgen v0.0.0-20181202132449-6a9ea43bcacd
go: downloading github.com/dolthub/maphash v0.1.0
go: downloading google.golang.org/genproto/googleapis/api v0.0.0-20240304212257-790db918fca8
go: downloading github.com/coreos/go-systemd/v22 v22.5.0
go: downloading github.com/tklauser/go-sysconf v0.3.12
go: downloading github.com/jfcg/sixb v1.3.8
go: downloading github.com/Azure/go-ntlmssp v0.0.0-20221128193559-754e69321358
go: downloading github.com/go-asn1-ber/asn1-ber v1.5.4
go: downloading github.com/hexops/gotextdiff v1.0.3
go: downloading github.com/apache/thrift v0.16.0
go: downloading github.com/nbutton23/zxcvbn-go v0.0.0-20210217022336-fa2cb2858354
go: downloading github.com/kylelemons/godebug v1.1.0
go: downloading github.com/pkg/browser v0.0.0-20240102092130-5ac0b6a4141c
go: downloading github.com/petermattis/goid v0.0.0-20231207134359-e60b3f734c67
go: downloading github.com/lestrrat-go/blackmagic v1.0.2
go: downloading github.com/lestrrat-go/httprc v1.0.5
go: downloading github.com/lestrrat-go/iter v1.0.2
go: downloading github.com/lestrrat-go/option v1.0.1
go: downloading github.com/cockroachdb/logtags v0.0.0-20230118201751-21c54148d20b
go: downloading github.com/cockroachdb/redact v1.1.5
go: downloading github.com/getsentry/sentry-go v0.27.0
go: downloading github.com/chavacava/garif v0.1.0
go: downloading github.com/olekukonko/tablewriter v0.0.5
go: downloading github.com/modern-go/concurrent v0.0.0-20180306012644-bacd9c7ef1dd
go: downloading github.com/modern-go/reflect2 v1.0.2
go: downloading github.com/pingcap/goleveldb v0.0.0-20191226122134-f82aafb29989
go: downloading golang.org/x/exp/typeparams v0.0.0-20240314144324-c7f7c6466f7f
go: downloading go.opentelemetry.io/otel v1.22.0
go: downloading go.opentelemetry.io/otel/trace v1.22.0
go: downloading google.golang.org/genproto/googleapis/rpc v0.0.0-20240401170217-c3f982113cda
go: downloading github.com/shurcooL/httpfs v0.0.0-20230704072500-f1e31cf0ba5c
go: downloading github.com/eapache/go-xerial-snappy v0.0.0-20180814174437-776d5712da21
go: downloading github.com/eapache/go-resiliency v1.2.0
go: downloading github.com/eapache/queue v1.1.0
go: downloading github.com/jcmturner/gofork v1.0.0
go: downloading github.com/jcmturner/gokrb5/v8 v8.4.2
go: downloading github.com/pierrec/lz4 v2.6.1+incompatible
go: downloading github.com/rcrowley/go-metrics v0.0.0-20201227073835-cf1acfcdf475
go: downloading github.com/tklauser/numcpus v0.6.1
go: downloading golang.org/x/mod v0.17.0
go: downloading github.com/dustin/go-humanize v1.0.1
go: downloading github.com/golang/glog v1.2.0
go: downloading github.com/golang-jwt/jwt/v5 v5.2.0
go: downloading github.com/kr/pretty v0.3.1
go: downloading github.com/lestrrat-go/httpcc v1.0.1
go: downloading github.com/golang/groupcache v0.0.0-20210331224755-41bb18bfe9da
go: downloading github.com/sirupsen/logrus v1.9.3
go: downloading github.com/Masterminds/sprig/v3 v3.2.2
go: downloading github.com/bmatcuk/doublestar/v2 v2.0.4
go: downloading github.com/ncw/directio v1.0.5
go: downloading github.com/coocood/rtutil v0.0.0-20190304133409-c84515f646f2
go: downloading github.com/coocood/bbloom v0.0.0-20190830030839-58deb6228d64
go: downloading github.com/rogpeppe/go-internal v1.12.0
go: downloading github.com/kr/text v0.2.0
go: downloading github.com/google/licensecheck v0.3.1
go: downloading github.com/Masterminds/goutils v1.1.1
go: downloading github.com/Masterminds/semver/v3 v3.2.1
go: downloading github.com/huandu/xstrings v1.3.1
go: downloading github.com/imdario/mergo v0.3.16
go: downloading github.com/mitchellh/copystructure v1.0.0
go: downloading github.com/spf13/cast v1.5.0
go: downloading github.com/shopspring/decimal v1.2.0
go: downloading github.com/klauspost/cpuid v1.3.1
go: downloading github.com/mitchellh/reflectwalk v1.0.1
go: downloading github.com/jcmturner/dnsutils/v2 v2.0.0
go: downloading github.com/jcmturner/aescts/v2 v2.0.0
go: downloading github.com/hashicorp/go-uuid v1.0.2
go: downloading github.com/jcmturner/rpc/v2 v2.0.3
go: downloading k8s.io/apimachinery v0.28.6
go: downloading github.com/DataDog/zstd v1.5.5
go: downloading github.com/cockroachdb/tokenbucket v0.0.0-20230807174530-cc333fc44b06
go: downloading github.com/go-logr/logr v1.4.1
go: downloading go.opentelemetry.io/otel/metric v1.22.0
go: downloading github.com/go-logr/stdr v1.2.2
go: downloading k8s.io/klog/v2 v2.120.1
go: downloading github.com/google/gofuzz v1.2.0
go: downloading gopkg.in/inf.v0 v0.9.1
go: downloading sigs.k8s.io/structured-merge-diff/v4 v4.4.1
go: downloading sigs.k8s.io/json v0.0.0-20221116044647-bc3834ca7abd
go: downloading k8s.io/utils v0.0.0-20230726121419-3b25d923346b
go: downloading go.opentelemetry.io/contrib/instrumentation/net/http/otelhttp v0.47.0
go: downloading github.com/google/s2a-go v0.1.7
go: downloading go.opentelemetry.io/contrib/instrumentation/google.golang.org/grpc/otelgrpc v0.47.0
go: downloading github.com/googleapis/enterprise-certificate-proxy v0.3.2
go: downloading github.com/felixge/httpsnoop v1.0.4
go: downloading github.com/jmespath/go-jmespath v0.4.0
make bazel_prepare
./tools/check/check-bazel-prepare.sh
make[1]: Entering directory `/home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb'
bazel --output_user_root=/home/jenkins/.tidb/tmp run --config=ci --repository_cache=/home/jenkins/.tidb/tmp //:gazelle
Extracting Bazel installation...
Starting local Bazel server and connecting to it...
[32mINFO: [0mInvocation ID: 826e7429-cb5c-45f8-a6e0-07d70d437676
[32mINFO: [0mReading 'startup' options from /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/.bazelrc: --host_jvm_args=-Xmx4g, --unlimit_coredumps
[32mINFO: [0mOptions provided by the client:
  Inherited 'common' options: --isatty=0 --terminal_columns=80
[32mINFO: [0mReading rc options for 'run' from /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/.bazelrc:
  Inherited 'build' options: --announce_rc --experimental_guard_against_concurrent_changes --experimental_remote_merkle_tree_cache --java_language_version=17 --java_runtime_version=17 --tool_java_language_version=17 --tool_java_runtime_version=17 --incompatible_strict_action_env --incompatible_enable_cc_toolchain_resolution
[32mINFO: [0mReading rc options for 'run' from /data/..2024_05_17_23_51_57.4044411750/bazel:
  Inherited 'build' options: --remote_cache=http://ats.apps.svc/brc/tidb --remote_timeout=30s
[32mINFO: [0mReading rc options for 'run' from /home/jenkins/.bazelrc:
  Inherited 'build' options: --local_ram_resources=29491 --local_cpu_resources=8 --jobs=8
[32mINFO: [0mFound applicable config definition build:ci in file /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/.bazelrc: --color=yes --experimental_remote_cache_compression
[32mINFO: [0mFound applicable config definition run:ci in file /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/.bazelrc: --color=yes
[32mLoading:[0m 
[32mLoading:[0m 
[32mLoading:[0m 
[32mLoading:[0m 
[32mLoading:[0m 
[32mLoading:[0m 0 packages loaded
[32mAnalyzing:[0m target //:gazelle (1 packages loaded, 0 targets configured)
[32mAnalyzing:[0m target //:gazelle (41 packages loaded, 388 targets configured)
[32mAnalyzing:[0m target //:gazelle (41 packages loaded, 388 targets configured)
[32mAnalyzing:[0m target //:gazelle (44 packages loaded, 413 targets configured)
[32mAnalyzing:[0m target //:gazelle (45 packages loaded, 413 targets configured)
[32mAnalyzing:[0m target //:gazelle (76 packages loaded, 3779 targets configured)
[32mAnalyzing:[0m target //:gazelle (98 packages loaded, 10444 targets configured)
[32mAnalyzing:[0m target //:gazelle (99 packages loaded, 10465 targets configured)
[32mAnalyzing:[0m target //:gazelle (99 packages loaded, 10465 targets configured)
[32mAnalyzing:[0m target //:gazelle (165 packages loaded, 10671 targets configured)
[32mAnalyzing:[0m target //:gazelle (204 packages loaded, 11371 targets configured)
[32mINFO: [0mAnalyzed target //:gazelle (268 packages loaded, 11967 targets configured).
[0m checking cached actions
[32mINFO: [0mFound 1 target...
[32m[0 / 10][0m [Prepa] Creating source manifest for //:gazelle ... ( 1 action running)
[32m[20 / 317][0m [Prepa] GoStdlib external/io_bazel_rules_go/stdlib_/pkg [for tool] ... (2 actions, 0 running)
[32m[24 / 317][0m GoStdlib external/io_bazel_rules_go/stdlib_/pkg [for tool]; Downloading external/io_bazel_rules_go/stdlib_/pkg/tool/linux_amd64/pprof, 6.0 MiB / 10.7 MiB; 1s remote-cache ... (3 actions, 0 running)
[32m[24 / 317][0m GoStdlib external/io_bazel_rules_go/stdlib_/pkg [for tool]; 2s remote-cache ... (3 actions, 0 running)
[32m[129 / 317][0m GoStdlib external/io_bazel_rules_go/stdlib_/pkg [for tool]; 3s remote-cache ... (8 actions, 0 running)
Target //:gazelle up-to-date:
  bazel-bin/gazelle-runner.bash
  bazel-bin/gazelle
[32mINFO: [0mElapsed time: 39.830s, Critical Path: 4.03s
[32mINFO: [0m317 processes: 297 remote cache hit, 20 internal.
[32mINFO:[0m Build completed successfully, 317 total actions
[32mINFO: [0mRunning command line: bazel-bin/gazelle
[0mbazel --output_user_root=/home/jenkins/.tidb/tmp run --config=ci --repository_cache=/home/jenkins/.tidb/tmp //:gazelle -- update-repos -from_file=go.mod -to_macro DEPS.bzl%go_deps  -build_file_proto_mode=disable -prune
[32mINFO: [0mInvocation ID: f3d68f6e-5fa5-47f0-bd19-352efc1e6e36
[32mINFO: [0mReading 'startup' options from /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/.bazelrc: --host_jvm_args=-Xmx4g, --unlimit_coredumps
[32mINFO: [0mOptions provided by the client:
  Inherited 'common' options: --isatty=0 --terminal_columns=80
[32mINFO: [0mReading rc options for 'run' from /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/.bazelrc:
  Inherited 'build' options: --announce_rc --experimental_guard_against_concurrent_changes --experimental_remote_merkle_tree_cache --java_language_version=17 --java_runtime_version=17 --tool_java_language_version=17 --tool_java_runtime_version=17 --incompatible_strict_action_env --incompatible_enable_cc_toolchain_resolution
[32mINFO: [0mReading rc options for 'run' from /data/..2024_05_17_23_51_57.4044411750/bazel:
  Inherited 'build' options: --remote_cache=http://ats.apps.svc/brc/tidb --remote_timeout=30s
[32mINFO: [0mReading rc options for 'run' from /home/jenkins/.bazelrc:
  Inherited 'build' options: --local_ram_resources=29491 --local_cpu_resources=8 --jobs=8
[32mINFO: [0mFound applicable config definition build:ci in file /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/.bazelrc: --color=yes --experimental_remote_cache_compression
[32mINFO: [0mFound applicable config definition run:ci in file /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/.bazelrc: --color=yes
[32mLoading:[0m 
[32mLoading:[0m 
[32mLoading:[0m 0 packages loaded
[32mAnalyzing:[0m target //:gazelle (0 packages loaded, 0 targets configured)
[32mINFO: [0mAnalyzed target //:gazelle (0 packages loaded, 0 targets configured).
[32mINFO: [0mFound 1 target...
[32m[0 / 1][0m [Prepa] BazelWorkspaceStatusAction stable-status.txt
Target //:gazelle up-to-date:
  bazel-bin/gazelle-runner.bash
  bazel-bin/gazelle
[32mINFO: [0mElapsed time: 0.316s, Critical Path: 0.01s
[32mINFO: [0m1 process: 1 internal.
[32mINFO:[0m Build completed successfully, 1 total action
[32mINFO: [0mRunning command line: bazel-bin/gazelle update-repos '-from_file=go.mod' -to_macro DEPS.bzl%go_deps '-build_file_proto_mode=disable' -prune
[0mgazelle: go_repository does not support file path replacements for github.com/pingcap/tidb/pkg/parser -> ./pkg/parser
bazel --output_user_root=/home/jenkins/.tidb/tmp run --config=ci --repository_cache=/home/jenkins/.tidb/tmp  //cmd/mirror:mirror -- --mirror> tmp.txt
[32mINFO: [0mInvocation ID: 0755276b-6531-4688-b43f-9d275cca791c
[32mINFO: [0mReading 'startup' options from /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/.bazelrc: --host_jvm_args=-Xmx4g, --unlimit_coredumps
[32mINFO: [0mOptions provided by the client:
  Inherited 'common' options: --isatty=0 --terminal_columns=80
[32mINFO: [0mReading rc options for 'run' from /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/.bazelrc:
  Inherited 'build' options: --announce_rc --experimental_guard_against_concurrent_changes --experimental_remote_merkle_tree_cache --java_language_version=17 --java_runtime_version=17 --tool_java_language_version=17 --tool_java_runtime_version=17 --incompatible_strict_action_env --incompatible_enable_cc_toolchain_resolution
[32mINFO: [0mReading rc options for 'run' from /data/..2024_05_17_23_51_57.4044411750/bazel:
  Inherited 'build' options: --remote_cache=http://ats.apps.svc/brc/tidb --remote_timeout=30s
[32mINFO: [0mReading rc options for 'run' from /home/jenkins/.bazelrc:
  Inherited 'build' options: --local_ram_resources=29491 --local_cpu_resources=8 --jobs=8
[32mINFO: [0mFound applicable config definition build:ci in file /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/.bazelrc: --color=yes --experimental_remote_cache_compression
[32mINFO: [0mFound applicable config definition run:ci in file /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/.bazelrc: --color=yes
[32mLoading:[0m 
[32mLoading:[0m 
[32mLoading:[0m 0 packages loaded
[32mAnalyzing:[0m target //cmd/mirror:mirror (1 packages loaded, 0 targets configured)
[32mAnalyzing:[0m target //cmd/mirror:mirror (7 packages loaded, 482 targets configured)
[32mAnalyzing:[0m target //cmd/mirror:mirror (68 packages loaded, 738 targets configured)
[32mAnalyzing:[0m target //cmd/mirror:mirror (114 packages loaded, 888 targets configured)
[32mAnalyzing:[0m target //cmd/mirror:mirror (167 packages loaded, 1273 targets configured)
[32mAnalyzing:[0m target //cmd/mirror:mirror (167 packages loaded, 1273 targets configured)
[32mAnalyzing:[0m target //cmd/mirror:mirror (183 packages loaded, 1292 targets configured)
[32mAnalyzing:[0m target //cmd/mirror:mirror (199 packages loaded, 1292 targets configured)
[32mAnalyzing:[0m target //cmd/mirror:mirror (296 packages loaded, 1617 targets configured)
[32mAnalyzing:[0m target //cmd/mirror:mirror (345 packages loaded, 1825 targets configured)
[32mAnalyzing:[0m target //cmd/mirror:mirror (399 packages loaded, 2517 targets configured)
[32mINFO: [0mAnalyzed target //cmd/mirror:mirror (403 packages loaded, 2609 targets configured).
[32mINFO: [0mFound 1 target...
[32m[0 / 3][0m [Prepa] BazelWorkspaceStatusAction stable-status.txt
[32m[266 / 511][0m Creating runfiles tree bazel-out/k8-fastbuild/bin/cmd/mirror/mirror_/mirror.runfiles; 1s local ... (2 actions, 1 running)
[32m[269 / 511][0m GoCompilePkg external/org_golang_google_api/iterator/iterator.a; Downloading external/org_golang_google_api/iterator/iterator.a; 0s remote-cache ... (8 actions, 0 running)
[32m[508 / 511][0m [Prepa] GoCompilePkg external/com_google_cloud_go_storage/storage.a
Target //cmd/mirror:mirror up-to-date:
  bazel-bin/cmd/mirror/mirror_/mirror
[32mINFO: [0mElapsed time: 17.475s, Critical Path: 3.40s
[32mINFO: [0m247 processes: 244 remote cache hit, 3 internal.
[32mINFO:[0m Build completed successfully, 247 total actions
[32mINFO: [0mRunning command line: bazel-bin/cmd/mirror/mirror_/mirror --mirror
[0mmv tmp.txt DEPS.bzl
bazel --output_user_root=/home/jenkins/.tidb/tmp run --config=ci --repository_cache=/home/jenkins/.tidb/tmp  \
	--run_under="cd /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb && " \
	 //tools/tazel:tazel
[32mINFO: [0mInvocation ID: 5ef91cb3-8958-4e34-b3b3-14895b77e628
[32mINFO: [0mReading 'startup' options from /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/.bazelrc: --host_jvm_args=-Xmx4g, --unlimit_coredumps
[32mINFO: [0mOptions provided by the client:
  Inherited 'common' options: --isatty=0 --terminal_columns=80
[32mINFO: [0mReading rc options for 'run' from /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/.bazelrc:
  Inherited 'build' options: --announce_rc --experimental_guard_against_concurrent_changes --experimental_remote_merkle_tree_cache --java_language_version=17 --java_runtime_version=17 --tool_java_language_version=17 --tool_java_runtime_version=17 --incompatible_strict_action_env --incompatible_enable_cc_toolchain_resolution
[32mINFO: [0mReading rc options for 'run' from /data/..2024_05_17_23_51_57.4044411750/bazel:
  Inherited 'build' options: --remote_cache=http://ats.apps.svc/brc/tidb --remote_timeout=30s
[32mINFO: [0mReading rc options for 'run' from /home/jenkins/.bazelrc:
  Inherited 'build' options: --local_ram_resources=29491 --local_cpu_resources=8 --jobs=8
[32mINFO: [0mFound applicable config definition build:ci in file /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/.bazelrc: --color=yes --experimental_remote_cache_compression
[32mINFO: [0mFound applicable config definition run:ci in file /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/.bazelrc: --color=yes
[32mLoading:[0m 
[32mLoading:[0m 
[32mLoading:[0m 0 packages loaded
[32mINFO: [0mBuild option --run_under has changed, discarding analysis cache.
[32mAnalyzing:[0m target //tools/tazel:tazel (1 packages loaded, 0 targets configured)
[32mAnalyzing:[0m target //tools/tazel:tazel (75 packages loaded, 10156 targets configured)
[32mAnalyzing:[0m target //tools/tazel:tazel (123 packages loaded, 10356 targets configured)
[32mAnalyzing:[0m target //tools/tazel:tazel (209 packages loaded, 11914 targets configured)
[32mAnalyzing:[0m target //tools/tazel:tazel (317 packages loaded, 12606 targets configured)
[32mAnalyzing:[0m target //tools/tazel:tazel (534 packages loaded, 13791 targets configured)
[32mINFO: [0mAnalyzed target //tools/tazel:tazel (561 packages loaded, 14300 targets configured).
[32mINFO: [0mFound 1 target...
[32m[0 / 9][0m [Prepa] Creating source manifest for //tools/tazel:tazel
[32m[574 / 608][0m GoCompilePkg external/com_github_pingcap_kvproto/pkg/pdpb/pdpb.a; 0s remote-cache ... (2 actions, 0 running)
Target //tools/tazel:tazel up-to-date:
  bazel-bin/tools/tazel/tazel_/tazel
[32mINFO: [0mElapsed time: 9.225s, Critical Path: 1.43s
[32mINFO: [0m235 processes: 232 remote cache hit, 3 internal.
[32mINFO:[0m Build completed successfully, 235 total actions
[32mINFO: [0mRunning command line: /bin/bash -c 'cd /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb &&  bazel-bin/tools/tazel/tazel_/tazel '
[0mmake[1]: Leaving directory `/home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb'
make[1]: Entering directory `/home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/pkg/parser'
GO111MODULE=on go build -o bin/goyacc goyacc/main.go goyacc/format_yacc.go
go: downloading golang.org/x/exp v0.0.0-20240205201215-2c58cdc269a3
go: downloading github.com/pingcap/errors v0.11.5-0.20240311024730-e056997136bb
bin/goyacc -o parser.go -p yy -t Parser parser.y
Parse table entries: 3238199 of 7716492, x 16 bits == 6476398 bytes
bin/goyacc -o hintparser.go -p yyhint -t hintParser hintparser.y
Parse table entries: 25978 of 42344, x 16 bits == 51956 bytes
make[1]: Leaving directory `/home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/pkg/parser'
GOBIN=/home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/tools/bin GO111MODULE=on go install github.com/mgechev/revive@v1.2.1
go: downloading github.com/mgechev/revive v1.2.1
go: downloading github.com/BurntSushi/toml v1.1.0
go: downloading github.com/chavacava/garif v0.0.0-20220316182200-5cad0b5181d4
go: downloading github.com/fatih/color v1.13.0
go: downloading github.com/mattn/go-runewidth v0.0.9
go: downloading github.com/mattn/go-colorable v0.1.9
go: downloading github.com/mattn/go-isatty v0.0.14
go: downloading golang.org/x/sys v0.0.0-20211019181941-9d821ace8654
linting
go run tools/dashboard-linter/main.go pkg/metrics/grafana/overview.json
go run tools/dashboard-linter/main.go pkg/metrics/grafana/performance_overview.json
go run tools/dashboard-linter/main.go pkg/metrics/grafana/tidb.json
go run tools/dashboard-linter/main.go pkg/metrics/grafana/tidb_resource_control.json
go run tools/dashboard-linter/main.go pkg/metrics/grafana/tidb_runtime.json
go run tools/dashboard-linter/main.go pkg/metrics/grafana/tidb_summary.json
go mod tidy
./tools/check/check-tidy.sh
testSuite
./tools/check/check_testSuite.sh
GOBIN=/home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/tools/bin GO111MODULE=on go install github.com/pingcap/errors/errdoc-gen@518f63d
go: downloading github.com/pingcap/errors v0.11.5-0.20220729040631-518f63d66278
generator errors.toml
./tools/check/check-errdoc.sh
Generate successfully, output:
Non-normalized error: attributes should be in format 'key=value'
Non-normalized error: retryable: lock not found
Non-normalized error: retryable: already rollback
Non-normalized error: retryable: replaced by another transaction
Non-normalized error: timer not exist
Non-normalized error: timer already exists
Non-normalized error: timer version not match
Non-normalized error: timer event id not match
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:8200
Duplicated error code: ddl:1681
Duplicated error code: ddl:8200
Non-normalized error: found backoff error
Non-normalized error: found backoff error but don't count
Non-normalized error: SAVEPOINT is not supported when binlog is enabled
Non-normalized error: other table can be accessed after locked table dropped
Non-normalized error: invalid group settings
Non-normalized error: resource group name too long
Non-normalized error: group settings with invalid format
Non-normalized error: cannot set RU mode and Raw mode options at the same time
Non-normalized error: unknown resource group mode
Non-normalized error: can't drop reserved resource group
Non-normalized error: invalid exec elapsed time
Non-normalized error: unknown resource group runaway action
Non-normalized error: cancel subtasks
Non-normalized error: finish subtasks
Non-normalized error: subtask in running state and is not idempotent
Non-normalized error: proto: negative length found during unmarshaling
Non-normalized error: proto: integer overflow
Non-normalized error: proto: unexpected end of group
Non-normalized error: write too slow, maybe gRPC is blocked forever
Non-normalized error: insert statement not found
Non-normalized error: this pool has been closed
Non-normalized error: the number of concurrency has reached the upper limit and Block is set
Non-normalized error: the pool params are invalid
Duplicated error code: expression:1235
Duplicated error code: variable:1681
Duplicated error code: types:1292
Duplicated error code: planner:3126
Duplicated error code: schema:1049
Duplicated error code: ddl:1273
Duplicated error code: executor:8115
Duplicated error code: executor:8116
Duplicated error code: executor:1295
Duplicated error code: executor:1390
Duplicated error code: executor:1317
Duplicated error code: ddl:1470
Duplicated error code: ddl:8200
Non-normalized error: Pattern not match
Non-normalized error: label constraint should be in format '{+|-}key=value'
Non-normalized error: unsupported label constraint
Non-normalized error: conflicting label constraints
Non-normalized error: label constraints in map syntax have invalid replicas
Non-normalized error: invalid label constraints format
Non-normalized error: survival preference format should be in format [xxx=yyy, ...]
Non-normalized error: label constraints with invalid REPLICAS
Non-normalized error: invalid bundle ID
Non-normalized error: invalid bundle ID format
Non-normalized error: REPLICAS must be 1 if ROLE=leader
Non-normalized error: the ROLE field is not specified
Non-normalized error: no rule of such role to drop
Non-normalized error: invalid placement option
Non-normalized error: mappings use a colon and space (“: ”) to mark each key/value pair
Non-normalized error: no colon found
Non-normalized error: unstable subtasks
Non-normalized error: task not found
Non-normalized error: task already exists
Non-normalized error: subtask not found
Duplicated error code: ddl:8242
Non-normalized error: scan break error
Non-normalized error: invalid syntax
Duplicated error code: variable:1298
Non-normalized error: watcher already started
Non-normalized error: watcher already closed
Duplicated error code: BR:PD:ErrPDUknownScatterResult
Non-normalized error: can not add because sorted
Non-normalized error: can't get the database's version
Non-normalized error: no data found in table

bazel --output_user_root=/home/jenkins/.tidb/tmp run --config=ci --repository_cache=/home/jenkins/.tidb/tmp \
	--run_under="cd /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb && " \
	 @com_github_apache_skywalking_eyes//cmd/license-eye:license-eye --run_under="cd /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb && "  -- -c ./.github/licenserc.yml  header check
[32mINFO: [0mInvocation ID: 9402cec0-ac75-4f14-a2a7-9f1047d3cbc4
[32mINFO: [0mReading 'startup' options from /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/.bazelrc: --host_jvm_args=-Xmx4g, --unlimit_coredumps
[32mINFO: [0mOptions provided by the client:
  Inherited 'common' options: --isatty=0 --terminal_columns=80
[32mINFO: [0mReading rc options for 'run' from /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/.bazelrc:
  Inherited 'build' options: --announce_rc --experimental_guard_against_concurrent_changes --experimental_remote_merkle_tree_cache --java_language_version=17 --java_runtime_version=17 --tool_java_language_version=17 --tool_java_runtime_version=17 --incompatible_strict_action_env --incompatible_enable_cc_toolchain_resolution
[32mINFO: [0mReading rc options for 'run' from /data/..2024_05_17_23_51_57.4044411750/bazel:
  Inherited 'build' options: --remote_cache=http://ats.apps.svc/brc/tidb --remote_timeout=30s
[32mINFO: [0mReading rc options for 'run' from /home/jenkins/.bazelrc:
  Inherited 'build' options: --local_ram_resources=29491 --local_cpu_resources=8 --jobs=8
[32mINFO: [0mFound applicable config definition build:ci in file /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/.bazelrc: --color=yes --experimental_remote_cache_compression
[32mINFO: [0mFound applicable config definition run:ci in file /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb/.bazelrc: --color=yes
[32mLoading:[0m 
[32mLoading:[0m 
[32mLoading:[0m 0 packages loaded
[32mAnalyzing:[0m target @com_github_apache_skywalking_eyes//cmd/license-eye:license-eye (1 packages loaded, 0 targets configured)
[32mAnalyzing:[0m target @com_github_apache_skywalking_eyes//cmd/license-eye:license-eye (55 packages loaded, 809 targets configured)
[32mINFO: [0mAnalyzed target @com_github_apache_skywalking_eyes//cmd/license-eye:license-eye (69 packages loaded, 1036 targets configured).
[32mINFO: [0mFound 1 target...
[32m[0 / 9][0m [Prepa] BazelWorkspaceStatusAction stable-status.txt
Target @com_github_apache_skywalking_eyes//cmd/license-eye:license-eye up-to-date:
  bazel-bin/external/com_github_apache_skywalking_eyes/cmd/license-eye/license-eye_/license-eye
[32mINFO: [0mElapsed time: 2.882s, Critical Path: 0.41s
[32mINFO: [0m65 processes: 62 remote cache hit, 3 internal.
[32mINFO:[0m Build completed successfully, 65 total actions
[32mINFO: [0mRunning command line: /bin/bash -c 'cd /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb &&  bazel-bin/external/com_github_apache_skywalking_eyes/cmd/license-eye/license-eye_/license-eye -c ./.github/licenserc.yml header check'
[0m[36mINFO[0m Loading configuration from file: ./.github/licenserc.yml 
[36mINFO[0m Totally checked 115168 files, valid: 2970, invalid: 0, ignored: 112198, fixed: 0 
GO111MODULE=on go build -tags codes -cover  -ldflags '-X "github.com/pingcap/tidb/pkg/parser/mysql.TiDBReleaseVersion=v8.2.0-alpha-192-gfc7136ca3c-dirty" -X "github.com/pingcap/tidb/pkg/util/versioninfo.TiDBBuildTS=2024-05-18 00:00:46" -X "github.com/pingcap/tidb/pkg/util/versioninfo.TiDBGitHash=fc7136ca3c28df5273f5024bdfe40116e7996564" -X "github.com/pingcap/tidb/pkg/util/versioninfo.TiDBGitBranch=HEAD" -X "github.com/pingcap/tidb/pkg/util/versioninfo.TiDBEdition=Community" -X "github.com/pingcap/tidb/pkg/config.checkBeforeDropLDFlag=1"' -o bin/tidb-server ./cmd/tidb-server
extracting statistics: s
skip building tidb-server, using existing binary: ../../bin/tidb-server
building portgenerator binary: ./portgenerator
building mysql-tester binary: ./mysql_tester
go: downloading github.com/pingcap/mysql-tester v0.0.0-20231124064544-17b728effac3
go: downloading github.com/pingcap/errors v0.11.5-0.20221009092201-b66cddb77c32
go: downloading github.com/sirupsen/logrus v1.8.1
go: downloading github.com/defined2014/mysql v0.0.0-20231121061906-fcfacaa39f49
go: downloading golang.org/x/sys v0.5.0
start tidb-server, log file: ./integration-test.out
tidb-server(PID: 60494) started
run all integration test cases (disabled new collation)
./t/collation_agg_func.test: ok! 74 test cases passed, take time 0.157029591 s
./t/collation_check_use_collation.test: ok! 93 test cases passed, take time 0.758597044 s
./t/collation_misc.test: ok! 66 test cases passed, take time 0.708757227 s
./t/collation_pointget.test: ok! 106 test cases passed, take time 0.781258494 s

Great, All tests passed
start tidb-server, log file: ./integration-test.out
tidb-server(PID: 60536) started
run all integration test cases (enabled new collation)
./t/show.test: ok! 3 test cases passed, take time 0.001017248 s
./t/access_path_selection.test: ok! 9 test cases passed, take time 0.031139192 s
./t/agg_predicate_pushdown.test: ok! 7 test cases passed, take time 0.026430373 s
./t/bindinfo/bind.test: ok! 223 test cases passed, take time 1.651291668 s
./t/bindinfo/session_handle.test: ok! 21 test cases passed, take time 0.064072956 s
./t/bindinfo/temptable.test: ok! 38 test cases passed, take time 0.172894071 s
./t/black_list.test: ok! 55 test cases passed, take time 0.119172994 s
./t/clustered_index.test: ok! 47 test cases passed, take time 3.68279974 s
./t/collation_agg_func.test: ok! 74 test cases passed, take time 0.107335669 s
./t/collation_check_use_collation.test: ok! 93 test cases passed, take time 0.53693993 s
./t/collation_misc.test: ok! 66 test cases passed, take time 0.506517929 s
./t/collation_pointget.test: ok! 106 test cases passed, take time 0.63773827 s
./t/common_collation.test: ok! 26 test cases passed, take time 0.150783944 s
./t/cte.test: ok! 189 test cases passed, take time 1.557739712 s
./t/db_integration.test: ok! 11 test cases passed, take time 0.035244879 s
./t/ddl/attributes_sql.test: ok! 30 test cases passed, take time 0.350285486 s
./t/ddl/bdr_mode.test: ok! 371 test cases passed, take time 4.203829544 s
./t/ddl/column.test: ok! 27 test cases passed, take time 0.188140219 s
./t/ddl/column_change.test: ok! 9 test cases passed, take time 0.038060549 s
./t/ddl/column_modify.test: ok! 164 test cases passed, take time 1.518532861 s
./t/ddl/column_type_change.test: ok! 1285 test cases passed, take time 40.736311212 s
./t/ddl/constraint.test: ok! 440 test cases passed, take time 4.381822579 s
./t/ddl/db.test: ok! 290 test cases passed, take time 5.807343946 s
./t/ddl/db_cache.test: ok! 52 test cases passed, take time 0.441899388 s
./t/ddl/db_change.test: ok! 21 test cases passed, take time 0.242783117 s
./t/ddl/db_foreign_key.test: ok! 20 test cases passed, take time 0.206966542 s
./t/ddl/db_integration.test: ok! 726 test cases passed, take time 10.986965455 s
time="2024-05-18T08:04:33+08:00" level=error msg="run test [ddl/db_partition] err: sql:explain format = 'brief' select * from t where a between \"3\" and \"4\";: failed to run query \n\"explain format = 'brief' select * from t where a between \"3\" and \"4\";\" \n around line 365, \nwe need(583):\nexplain format = 'brief' select * from t where a between \"3\" and \"4\";\nid\testRows\ttask\taccess object\toperator info\nPartitionUnion\t2.00\troot\t\t\n├─TableReader\t1.00\troot\t\tdata:Selection\n│ └─Selection\t1.00\tcop[tikv]\t\tge(ddl__db_partition.t.a, \"3\"), le(ddl__db_partition.t.a, \"4\")\n│   └─TableFullScan\t1.00\tcop[tikv]\ttable:t, partition:p0\tkeep order:false\n└─TableReader\t1.00\troot\t\tdata:Selection\n  └─Selection\t1.00\tcop[tikv]\t\tge(ddl__db_partition.t.a, \"3\"), le(ddl__db_partition.t.a, \"4\")\n    └─TableFullScan\t4.00\tcop[tikv]\ttable:t, partition:p1\tkeep order:false\n\nbut got(583):\nexplain format = 'brief' select * from t where a between \"3\" and \"4\";\nid\testRows\ttask\taccess object\toperator info\nPartitionUnion\t3.00\troot\t\t\n├─TableReader\t1.00\troot\t\tdata:Selection\n│ └─Selection\t1.00\tcop[tikv]\t\tge(ddl__db_partition.t.a, \"3\"), le(ddl__db_partition.t.a, \"4\")\n│   └─TableFullScan\t1.00\tcop[tikv]\ttable:t, partition:p0\tkeep order:false\n└─TableReader\t2.00\troot\t\tdata:Selection\n  └─Selection\t2.00\tcop[tikv]\t\tge(ddl__db_partition.t.a, \"3\"), le(ddl__db_partition.t.a, \"4\")\n    └─TableFullScan\t4.00\tcop[tikv]\ttable:t, partition:p1\tkeep order:false\n\n"
./t/ddl/db_rename.test: ok! 21 test cases passed, take time 0.681013076 s
./t/ddl/db_table.test: ok! 53 test cases passed, take time 0.70267804 s
./t/ddl/ddl_error.test: ok! 10 test cases passed, take time 0.097262616 s
./t/ddl/ddl_tiflash.test: ok! 14 test cases passed, take time 0.036003604 s
./t/ddl/default_as_expression.test: ok! 364 test cases passed, take time 4.069925799 s
./t/ddl/fail_db.test: ok! 12 test cases passed, take time 0.167575417 s
./t/ddl/foreign_key.test: ok! 158 test cases passed, take time 6.823162232 s
./t/ddl/global_index.test: ok! 25 test cases passed, take time 0.581612868 s
./t/ddl/index_modify.test: ok! 39 test cases passed, take time 0.791549188 s
./t/ddl/integration.test: ok! 87 test cases passed, take time 0.970398152 s
./t/ddl/modify_column.test: ok! 672 test cases passed, take time 19.863859878 s
./t/ddl/multi_schema_change.test: ok! 298 test cases passed, take time 9.643231874 s
./t/ddl/partition.test: ok! 213 test cases passed, take time 1.972994052 s
./t/ddl/primary_key_handle.test: ok! 191 test cases passed, take time 2.501954386 s
./t/ddl/reorg_partition.test: ok! 205 test cases passed, take time 4.761605746 s
./t/ddl/resource_group.test: ok! 16 test cases passed, take time 0.072678659 s
./t/ddl/sequence.test: ok! 268 test cases passed, take time 3.125837878 s
./t/ddl/serial.test: ok! 77 test cases passed, take time 0.98054244 s
./t/ddl/table_modify.test: ok! 47 test cases passed, take time 0.499545307 s
./t/executor/adapter.test: ok! 6 test cases passed, take time 0.02503248 s
./t/executor/admin.test: ok! 171 test cases passed, take time 13.795614392 s
./t/executor/aggregate.test: ok! 886 test cases passed, take time 10.3492138 s
./t/executor/analyze.test: ok! 180 test cases passed, take time 6.442225468 s
./t/executor/autoid.test: ok! 442 test cases passed, take time 3.003396878 s
./t/executor/batch_point_get.test: ok! 85 test cases passed, take time 0.4734489 s
./t/executor/charset.test: ok! 57 test cases passed, take time 0.412662166 s
./t/executor/chunk_reuse.test: ok! 93 test cases passed, take time 0.174334344 s
./t/executor/cluster_table.test: ok! 36 test cases passed, take time 0.176222679 s
./t/executor/compact_table.test: ok! 19 test cases passed, take time 0.137236946 s
./t/executor/cte.test: ok! 133 test cases passed, take time 0.835507877 s
./t/executor/ddl.test: ok! 359 test cases passed, take time 7.234777825 s
./t/executor/delete.test: ok! 71 test cases passed, take time 0.578165716 s
./t/executor/distsql.test: ok! 61 test cases passed, take time 1.114140136 s
./t/executor/executor.test: ok! 2151 test cases passed, take time 17.255237184 s
./t/executor/executor_txn.test: ok! 121 test cases passed, take time 0.334604538 s
./t/executor/explain.test: ok! 120 test cases passed, take time 1.225171836 s
./t/executor/explainfor.test: ok! 378 test cases passed, take time 1.89988158 s
./t/executor/foreign_key.test: ok! 318 test cases passed, take time 15.709267674 s
./t/executor/grant.test: ok! 202 test cases passed, take time 2.007355021 s
./t/executor/import_into.test: ok! 88 test cases passed, take time 0.122997302 s
./t/executor/index_advise.test: ok! 30 test cases passed, take time 0.117743746 s
./t/executor/index_lookup_join.test: ok! 190 test cases passed, take time 2.543489386 s
./t/executor/index_lookup_merge_join.test: ok! 83 test cases passed, take time 1.422983714 s
./t/executor/index_merge_reader.test: ok! 244 test cases passed, take time 3.293749553 s
./t/executor/infoschema_reader.test: ok! 174 test cases passed, take time 4.851436445 s
./t/executor/insert.test: ok! 1224 test cases passed, take time 17.530729471 s
./t/executor/inspection_common.test: ok! 4 test cases passed, take time 0.003494159 s
./t/executor/issues.test: ok! 422 test cases passed, take time 5.273713609 s
./t/executor/jointest/hash_join.test: ok! 137 test cases passed, take time 1.412742487 s
./t/executor/jointest/join.test: ok! 866 test cases passed, take time 13.187727207 s
time="2024-05-18T08:07:48+08:00" level=error msg="run test [executor/kv] err: sql:select count(*)>0 from mysql.stats_top_n where table_id = @a;: failed to run query \n\"select count(*)>0 from mysql.stats_top_n where table_id = @a;\" \n around line 12, \nwe need(75):\nselect count(*)>0 from mysql.stats_top_n where table_id = @a;\ncount(*)>0\n1\n\nbut got(75):\nselect count(*)>0 from mysql.stats_top_n where table_id = @a;\ncount(*)>0\n0\n\n"
./t/executor/merge_join.test: ok! 259 test cases passed, take time 3.884297166 s
./t/executor/parallel_apply.test: ok! 96 test cases passed, take time 1.287419831 s
./t/executor/partition/global_index.test: ok! 94 test cases passed, take time 2.694790115 s
time="2024-05-18T08:07:59+08:00" level=error msg="run test [executor/partition/issues] err: sql:explain select * from t where col_51 between 9223372036854775812 and 9223372036854775813;: failed to run query \n\"explain select * from t where col_51 between 9223372036854775812 and 9223372036854775813;\" \n around line 272, \nwe need(308):\nexplain select * from t where col_51 between 9223372036854775812 and 9223372036854775813;\nid\testRows\ttask\taccess object\toperator info\nTableReader_6\t2.00\troot\tpartition:p3,p4\tdata:TableRangeScan_5\n└─TableRangeScan_5\t2.00\tcop[tikv]\ttable:t\trange:[9223372036854775812,9223372036854775813], keep order:false\n\nbut got(308):\nexplain select * from t where col_51 between 9223372036854775812 and 9223372036854775813;\nid\testRows\ttask\taccess object\toperator info\nTableReader_6\t2.80\troot\tpartition:p3,p4\tdata:TableRangeScan_5\n└─TableRangeScan_5\t2.80\tcop[tikv]\ttable:t\trange:[9223372036854775812,9223372036854775813], keep order:false\n\n"
time="2024-05-18T08:07:59+08:00" level=error msg="run test [executor/partition/partition_boundaries] err: sql:explain format='brief' SELECT * FROM t WHERE a = 3000000;: failed to run query \n\"explain format='brief' SELECT * FROM t WHERE a = 3000000;\" \n around line 57, \nwe need(308):\nexplain format='brief' SELECT * FROM t WHERE a = 3000000;\nid\testRows\ttask\taccess object\toperator info\nTableReader\t0.00\troot\tpartition:dual\tdata:Selection\n└─Selection\t0.00\tcop[tikv]\t\teq(executor__partition__partition_boundaries.t.a, 3000000)\n  └─TableFullScan\t14.00\tcop[tikv]\ttable:t\tkeep order:false\n\nbut got(308):\nexplain format='brief' SELECT * FROM t WHERE a = 3000000;\nid\testRows\ttask\taccess object\toperator info\nTableReader\t1.00\troot\tpartition:dual\tdata:Selection\n└─Selection\t1.00\tcop[tikv]\t\teq(executor__partition__partition_boundaries.t.a, 3000000)\n  └─TableFullScan\t14.00\tcop[tikv]\ttable:t\tkeep order:false\n\n"
time="2024-05-18T08:08:00+08:00" level=error msg="run test [executor/partition/partition_with_expression] err: sql:explain select * from tp where a > '2020-09-11 00:00:00';: failed to run query \n\"explain select * from tp where a > '2020-09-11 00:00:00';\" \n around line 57, \nwe need(339):\nexplain select * from tp where a > '2020-09-11 00:00:00';\nid\testRows\ttask\taccess object\toperator info\nTableReader_7\t1.00\troot\tpartition:p2\tdata:Selection_6\n└─Selection_6\t1.00\tcop[tikv]\t\tgt(executor__partition__partition_with_expression.tp.a, 2020-09-11 00:00:00.000000)\n  └─TableFullScan_5\t4.00\tcop[tikv]\ttable:tp\tkeep order:false\n\nbut got(339):\nexplain select * from tp where a > '2020-09-11 00:00:00';\nid\testRows\ttask\taccess object\toperator info\nTableReader_7\t0.00\troot\tpartition:p2\tdata:Selection_6\n└─Selection_6\t0.00\tcop[tikv]\t\tgt(executor__partition__partition_with_expression.tp.a, 2020-09-11 00:00:00.000000)\n  └─TableFullScan_5\t4.00\tcop[tikv]\ttable:tp\tkeep order:false\n\n"
./t/executor/partition/table.test: ok! 224 test cases passed, take time 4.94083032 s
./t/executor/partition/write.test: ok! 355 test cases passed, take time 2.505356508 s
./t/executor/password_management.test: ok! 381 test cases passed, take time 3.139299522 s
./t/executor/point_get.test: ok! 273 test cases passed, take time 2.108053696 s
./t/executor/prepared.test: ok! 214 test cases passed, take time 1.420031339 s
./t/executor/revoke.test: ok! 65 test cases passed, take time 0.73449509 s
./t/executor/rowid.test: ok! 63 test cases passed, take time 0.39973501 s
./t/executor/sample.test: ok! 106 test cases passed, take time 1.832227331 s
./t/executor/set.test: ok! 228 test cases passed, take time 0.411836236 s
./t/executor/show.test: ok! 301 test cases passed, take time 5.020485303 s
./t/executor/simple.test: ok! 303 test cases passed, take time 2.904415075 s
./t/executor/split_table.test: ok! 60 test cases passed, take time 0.586913513 s
./t/executor/stale_txn.test: ok! 28 test cases passed, take time 1.091229529 s
./t/executor/statement_context.test: ok! 63 test cases passed, take time 0.168137642 s
./t/executor/union_scan.test: ok! 231 test cases passed, take time 1.800874871 s
./t/executor/update.test: ok! 513 test cases passed, take time 4.314818517 s
./t/executor/window.test: ok! 22 test cases passed, take time 0.087544843 s
./t/executor/write.test: ok! 1079 test cases passed, take time 11.343353248 s
./t/explain-non-select-stmt.test: ok! 8 test cases passed, take time 0.03003105 s
./t/explain.test: ok! 21 test cases passed, take time 0.188846101 s
./t/explain_complex.test: ok! 41 test cases passed, take time 0.678351355 s
./t/explain_complex_stats.test: ok! 61 test cases passed, take time 3.440207472 s
./t/explain_cte.test: ok! 53 test cases passed, take time 0.406114862 s
time="2024-05-18T08:08:53+08:00" level=error msg="run test [explain_easy] err: sql:explain format = 'brief' select * from t where a >= 3 and a <= 8;: failed to run query \n\"explain format = 'brief' select * from t where a >= 3 and a <= 8;\" \n around line 193, \nwe need(291):\nexplain format = 'brief' select * from t where a >= 3 and a <= 8;\nid\testRows\ttask\taccess object\toperator info\nTableReader\t0.00\troot\t\tdata:Selection\n└─Selection\t0.00\tcop[tikv]\t\tge(explain_easy.t.a, 3), le(explain_easy.t.a, 8)\n  └─TableFullScan\t8.00\tcop[tikv]\ttable:t\tkeep order:false\n\nbut got(291):\nexplain format = 'brief' select * from t where a >= 3 and a <= 8;\nid\testRows\ttask\taccess object\toperator info\nTableReader\t1.56\troot\t\tdata:Selection\n└─Selection\t1.56\tcop[tikv]\t\tge(explain_easy.t.a, 3), le(explain_easy.t.a, 8)\n  └─TableFullScan\t8.00\tcop[tikv]\ttable:t\tkeep order:false\n\n"
./t/explain_easy_stats.test: ok! 50 test cases passed, take time 0.841180956 s
./t/explain_foreign_key.test: ok! 41 test cases passed, take time 0.77772718 s
time="2024-05-18T08:08:56+08:00" level=error msg="run test [explain_generate_column_substitute] err: sql:desc format = 'brief' select * from t where (lower(b) = \"a\" and a+1 = 2) or (lower(b) = \"b\" and a+1 = 5);: failed to run query \n\"desc format = 'brief' select * from t where (lower(b) = \"a\" and a+1 = 2) or (lower(b) = \"b\" and a+1 = 5);\" \n around line 198, \nwe need(629):\ndesc format = 'brief' select * from t where (lower(b) = \"a\" and a+1 = 2) or (lower(b) = \"b\" and a+1 = 5);\nid\testRows\ttask\taccess object\toperator info\nProjection\t1.00\troot\t\texplain_generate_column_substitute.t.a, explain_generate_column_substitute.t.b\n└─IndexLookUp\t1.00\troot\t\t\n  ├─IndexRangeScan(Build)\t1.00\tcop[tikv]\ttable:t, index:expression_index(lower(`b`), `a` + 1)\trange:[\"a\" 2,\"a\" 2], [\"b\" 5,\"b\" 5], keep order:false\n  └─TableRowIDScan(Probe)\t1.00\tcop[tikv]\ttable:t\tkeep order:false\ndesc format = 'brief' select * from t where not (lower(b) >= \"a\");\nid\testRows\ttask\taccess object\toperator info\nProjection\t0.00\t\nbut got(629):\ndesc format = 'brief' select * from t where (lower(b) = \"a\" and a+1 = 2) or (lower(b) = \"b\" and a+1 = 5);\nid\testRows\ttask\taccess object\toperator info\nProjection\t2.00\troot\t\texplain_generate_column_substitute.t.a, explain_generate_column_substitute.t.b\n└─Selection\t4.80\troot\t\tor(and(eq(lower(explain_generate_column_substitute.t.b), \"a\"), eq(plus(explain_generate_column_substitute.t.a, 1), 2)), and(eq(lower(explain_generate_column_substitute.t.b), \"b\"), eq(plus(explain_generate_column_substitute.t.a, 1), 5)))\n  └─TableReader\t6.00\troot\t\tdata:TableFullScan\n    └─TableFullScan\t6.00\tcop[tikv]\ttable:t\tkeep order:false\n\n"
./t/explain_indexmerge_stats.test: ok! 30 test cases passed, take time 1.14280732 s
./t/explain_join_stats.test: ok! 8 test cases passed, take time 0.210796946 s
./t/explain_shard_index.test: ok! 19 test cases passed, take time 0.139472622 s
./t/explain_stats.test: ok! 10 test cases passed, take time 0.087353054 s
./t/explain_union_scan.test: ok! 9 test cases passed, take time 0.163862729 s
./t/expression/builtin.test: ok! 1332 test cases passed, take time 10.113169046 s
./t/expression/cast.test: ok! 50 test cases passed, take time 0.329728012 s
./t/expression/charset_and_collation.test: ok! 733 test cases passed, take time 7.540931165 s
./t/expression/constant_fold.test: ok! 12 test cases passed, take time 0.060544175 s
./t/expression/enum_set.test: ok! 13 test cases passed, take time 0.113198339 s
./t/expression/explain.test: ok! 77 test cases passed, take time 0.28260206 s
./t/expression/issues.test: ok! 1502 test cases passed, take time 17.453667892 s
./t/expression/json.test: ok! 223 test cases passed, take time 1.081700436 s
./t/expression/misc.test: ok! 404 test cases passed, take time 5.031333355 s
./t/expression/multi_valued_index.test: ok! 314 test cases passed, take time 3.276286322 s
./t/expression/noop_functions.test: ok! 61 test cases passed, take time 0.043229723 s
./t/expression/plan_cache.test: ok! 184 test cases passed, take time 0.690951436 s
./t/expression/time.test: ok! 279 test cases passed, take time 0.664737866 s
./t/expression/vitess_hash.test: ok! 17 test cases passed, take time 0.288338463 s
./t/generated_columns.test: ok! 70 test cases passed, take time 0.975357279 s
./t/globalindex/information_schema.test: ok! 5 test cases passed, take time 0.030632099 s
./t/globalindex/mem_index_lookup.test: ok! 29 test cases passed, take time 0.144401139 s
./t/globalindex/mem_index_merge.test: ok! 51 test cases passed, take time 0.284245101 s
./t/globalindex/mem_index_reader.test: ok! 25 test cases passed, take time 0.129133148 s
./t/globalindex/point_get.test: ok! 21 test cases passed, take time 0.714238019 s
./t/globalindex/update.test: ok! 14 test cases passed, take time 0.127922713 s
./t/imdbload.test: ok! 63 test cases passed, take time 9.275526504 s
./t/index_join.test: ok! 22 test cases passed, take time 0.456399843 s
./t/index_merge.test: ok! 145 test cases passed, take time 1.182761666 s
./t/infoschema/cluster_tables.test: ok! 9 test cases passed, take time 0.038908045 s
./t/infoschema/infoschema.test: ok! 49 test cases passed, take time 1.115419763 s
./t/infoschema/tables.test: ok! 120 test cases passed, take time 1.031841567 s
./t/infoschema/v2.test: ok! 30 test cases passed, take time 0.612759223 s
./t/naaj.test: ok! 134 test cases passed, take time 0.327549939 s
./t/new_character_set.test: ok! 61 test cases passed, take time 0.414337995 s
./t/new_character_set_builtin.test: ok! 217 test cases passed, take time 1.319235985 s
./t/new_character_set_invalid.test: ok! 28 test cases passed, take time 0.383868181 s
./t/parser/integration.test: ok! 8 test cases passed, take time 0.114872649 s
./t/partition.test: ok! 3 test cases passed, take time 0.145954475 s
time="2024-05-18T08:10:08+08:00" level=error msg="run test [planner/cardinality/selectivity] err: sql:show stats_buckets where db_name = 'planner__cardinality__selectivity';: failed to run query \n\"show stats_buckets where db_name = 'planner__cardinality__selectivity';\" \n around line 52, \nwe need(7391):\nplanner__cardinality__selectivity\tct1\t\tPRIMARY\t1\t1\t1\nplanner__cardinality__selectivity\tct1\t\tPRIMARY\t1\t2\t1\nplanner__cardinality__selectivity\tct1\t\ta\t0\t1\t1\nplanner__cardinality__selectivity\tct1\t\ta\t0\t2\t1\nplanner__cardinality__selectivity\tct1\t\tpk\t0\t1\t1\nplanner__cardinality__selectivity\tct1\t\tpk\t0\t2\t1\nplanner__cardinality__selectivity\tct2\t\tPRIMARY\t1\t(1, 1)\t1\nplanner__cardinality__selectivity\tct2\t\tPRIMARY\t1\t(2, 2)\t1\nplanner__cardinality__selectivity\tct2\t\ta\t0\t1\t1\nplanner__cardinality__selectivity\tct2\t\ta\t0\t2\t1\nplanner__cardinality__selectivity\tct2\t\tb\t0\t1\t1\nplanner__cardinality__selectivity\tct2\t\tb\t0\t2\t1\nplanner__cardinality__selectivity\tct2\t\tc\t0\t1\t1\nplanner__cardinality__selectivity\tct2\t\tc\t0\t2\t1\nplanner__cardinality__selectivity\ttdatetime\t\ta\t0\t2001-01-01 00:00:00\t1\nplanner__cardinality__selectivity\ttdatetime\t\ta\t0\t2001-01-02 00:00:00\t1\nplanner__cardinality__selectivity\ttdatetime\t\tb\t0\t2001-01-01 00:00:00\t1\nplanner__cardinality__selectivity\ttdatetime\t\tb\t0\t2001-01-02 00:00:00\t1\nplanner__cardinality__selectivity\ttdatetime\t\tc\t0\t2001-01-01 00:00:00\t1\nplanner__cardinality__selectivity\ttdatetime\t\tc\t0\t2001-01-02 00:00:00\t1\nplanner__cardinality__selectivity\ttdatetime\t\tmulti\t1\t(2001-01-01 00:00:00, 2001-01-01 00:00:00)\t1\nplanner__cardinality__selectivity\ttdatetime\t\tmulti\t1\t(2001-01-02 00:00:00, 2001-01-02 00:00:00)\t1\nplanner__cardinality__selectivity\ttdatetime\t\tsingular\t1\t2001-01-01 00:00:00\t1\nplanner__cardinality__selectivity\ttdatetime\t\tsingular\t1\t2001-01-02 00:00:00\t1\nplanner__cardinality__selectivity\ttdecimal\t\ta\t0\t1.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdecimal\t\ta\t0\t2.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdecimal\t\tb\t0\t1.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdecimal\t\tb\t0\t2.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdecimal\t\tc\t0\t1.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdecimal\t\tc\t0\t2.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdecimal\t\tmulti\t1\t(1.00000000000000000000, 1.00000000000000000000)\t1\nplanner__cardinality__selectivity\ttdecimal\t\tmulti\t1\t(2.00000000000000000000, 2.00000000000000000000)\t1\nplanner__cardinality__selectivity\ttdecimal\t\tsingular\t1\t1.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdecimal\t\tsingular\t1\t2.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdouble\t\ta\t0\t1\t1\nplanner__cardinality__selectivity\ttdouble\t\ta\t0\t2\t1\nplanner__cardinality__selectivity\ttdouble\t\tb\t0\t1\t1\nplanner__cardinality__selectivity\ttdouble\t\tb\t0\t2\t1\nplanner__cardinality__selectivity\ttdouble\t\tc\t0\t1\t1\nplanner__cardinality__selectivity\ttdouble\t\tc\t0\t2\t1\nplanner__cardinality__selectivity\ttdouble\t\tmulti\t1\t(1, 1)\t1\nplanner__cardinality__selectivity\ttdouble\t\tmulti\t1\t(2, 2)\t1\nplanner__cardinality__selectivity\ttdouble\t\tsingular\t1\t1\t1\nplanner__cardinality__selectivity\ttdouble\t\tsingular\t1\t2\t1\nplanner__cardinality__selectivity\ttint\t\ta\t0\t1\t1\nplanner__cardinality__selectivity\ttint\t\ta\t0\t2\t1\nplanner__cardinality__selectivity\ttint\t\tb\t0\t1\t1\nplanner__cardinality__selectivity\ttint\t\tb\t0\t2\t1\nplanner__cardinality__selectivity\ttint\t\tc\t0\t1\t1\nplanner__cardinality__selectivity\ttint\t\tc\t0\t2\t1\nplanner__cardinality__selectivity\ttint\t\tmulti\t1\t(1, 1)\t1\nplanner__cardinality__selectivity\ttint\t\tmulti\t1\t(2, 2)\t1\nplanner__cardinality__selectivity\ttint\t\tsingular\t1\t1\t1\nplanner__cardinality__selectivity\ttint\t\tsingular\t1\t2\t1\nplanner__cardinality__selectivity\ttprefix\t\ta\t0\t111\t1\nplanner__cardinality__selectivity\ttprefix\t\ta\t0\t222\t1\nplanner__cardinality__selectivity\ttprefix\t\tb\t0\t111\t1\nplanner__cardinality__selectivity\ttprefix\t\tb\t0\t222\t1\nplanner__cardinality__selectivity\ttprefix\t\tprefixa\t1\t11\t1\nplanner__cardinality__selectivity\ttprefix\t\tprefixa\t1\t22\t1\nplanner__cardinality__selectivity\ttstring\t\ta\t0\t1\t1\nplanner__cardinality__selectivity\ttstring\t\ta\t0\t2\t1\nplanner__cardinality__selectivity\ttstring\t\tb\t0\t1\t1\nplanner__cardinality__selectivity\ttstring\t\tb\t0\t2\t1\nplanner__cardinality__selectivity\ttstring\t\tc\t0\t1\t1\nplanner__cardinality__selectivity\ttstring\t\tc\t0\t2\t1\nplanner__cardinality__selectivity\ttstring\t\tmulti\t1\t(1, 1)\t1\nplanner__cardinality__selectivity\ttstring\t\tmulti\t1\t(2, 2)\t1\nplanner__cardinality__selectivity\ttstring\t\tsingular\t1\t1\t1\nplanner__cardinality__selectivity\ttstring\t\tsingular\t1\t2\t1\nshow stats_buckets where db_name = 'planner__cardinality__selectivity';\nDb_name\tTable_name\tPartition_name\tColumn_name\tIs_index\tBucket_id\tCount\tRepeats\tLower_Bound\tUpper_Bound\tNdv\nplanner__cardinality__selectivity\tct1\t\tPRIMARY\t1\t0\t3\t1\t3\t5\t0\nplanner__cardinality__selectivity\tct1\t\tPRIMARY\t1\t1\t6\t1\t6\t8\t0\nplanner__cardinality__selectivity\tct1\t\ta\t0\t0\t3\t1\t3\t5\t0\nplanner__cardinality__selectivity\tct1\t\ta\t0\t1\t6\t1\t6\t8\t0\nplanner__cardinality__selectivity\tct1\t\tpk\t0\t0\t3\t1\t3\t5\t0\nplanner__cardinality__selectivity\tct1\t\tpk\t0\t1\t6\t1\t6\t8\t0\nplanner__cardinality__selectivity\tct2\t\tPRIMARY\t1\t0\t3\t1\t(3, 3)\t(5, 5)\t0\nplanner__cardinality__selectivity\tct2\t\tPRIMARY\t1\t1\t6\t1\t(6, 6)\t(8, 8)\t0\nplanner__cardinality__selectivity\tct2\t\ta\t0\t0\t3\t1\t3\t5\t0\nplanner__cardinality__selectivity\tct2\t\ta\t0\t1\t6\t1\t6\t8\t0\nplanner__cardinality__selectivity\tct2\t\tb\t0\t0\t3\t1\t3\t5\t0\nplanner__cardinality__selectivity\tct2\t\tb\t0\t1\t6\t1\t6\t8\t0\nplanner__cardinality__selectivity\tct2\t\tc\t0\t0\t3\t1\t3\t5\t0\nplanner__cardinality__selectivity\tct2\t\tc\t0\t1\t6\t1\t6\t8\t0\nplanner__cardinality__selectivity\ttdatetime\t\ta\t0\t0\t1\t1\t2001-01-03 00:00:00\t2001-01-03 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\ta\t0\t1\t2\t1\t2001-01-04 00:00:00\t2001-01-04 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tb\t0\t0\t1\t1\t2001-01-03 00:00:00\t2001-01-03 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tb\t0\t1\t2\t1\t2001-01-04 00:00:00\t2001-01-04 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tc\t0\t0\t1\t1\t2001-01-03 00:00:00\t2001-01-03 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tc\t0\t1\t2\t1\t2001-01-04 00:00:00\t2001-01-04 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tmulti\t1\t0\t1\t1\t(2001-01-03 00:00:00, 2001-01-03 00:00:00)\t(2001-01-03 00:00:00, 2001-01-03 00:00:00)\t0\nplanner__cardinality__selectivity\ttdatetime\t\tmulti\t1\t1\t2\t1\t(2001-01-04 00:00:00, 2001-01-04 00:00:00)\t(2001-01-04 00:00:00, 2001-01-04 00:00:00)\t0\nplanner__cardinality__selectivity\ttdatetime\t\tsingular\t1\t0\t1\t1\t2001-01-03 00:00:00\t2001-01-03 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tsingular\t1\t1\t2\t1\t2001-01-04 00:00:00\t2001-01-04 00:00:00\t0\nplanner__cardinality__selectivity\ttdecimal\t\ta\t0\t0\t3\t1\t3.00000000000000000000\t5.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\ta\t0\t1\t6\t1\t6.00000000000000000000\t8.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tb\t0\t0\t3\t1\t3.00000000000000000000\t5.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tb\t0\t1\t6\t1\t6.00000000000000000000\t8.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tc\t0\t0\t3\t1\t3.00000000000000000000\t5.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tc\t0\t1\t6\t1\t6.00000000000000000000\t8.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tmulti\t1\t0\t3\t1\t(3.00000000000000000000, 3.00000000000000000000)\t(5.00000000000000000000, 5.00000000000000000000)\t0\nplanner__cardinality__selectivity\ttdecimal\t\tmulti\t1\t1\t6\t1\t(6.00000000000000000000, 6.00000000000000000000)\t(8.00000000000000000000, 8.00000000000000000000)\t0\nplanner__cardinality__selectivity\ttdecimal\t\tsingular\t1\t0\t3\t1\t3.00000000000000000000\t5.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tsingular\t1\t1\t6\t1\t6.000000000000\nbut got(7391):\nshow stats_buckets where db_name = 'planner__cardinality__selectivity';\nDb_name\tTable_name\tPartition_name\tColumn_name\tIs_index\tBucket_id\tCount\tRepeats\tLower_Bound\tUpper_Bound\tNdv\nplanner__cardinality__selectivity\tct1\t\tPRIMARY\t1\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\tct1\t\tPRIMARY\t1\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\tct1\t\tPRIMARY\t1\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\tct1\t\ta\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\tct1\t\ta\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\tct1\t\ta\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\tct1\t\tpk\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\tct1\t\tpk\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\tct1\t\tpk\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\tct2\t\tPRIMARY\t1\t0\t3\t1\t(1, 1)\t(3, 3)\t0\nplanner__cardinality__selectivity\tct2\t\tPRIMARY\t1\t1\t6\t1\t(4, 4)\t(6, 6)\t0\nplanner__cardinality__selectivity\tct2\t\tPRIMARY\t1\t2\t8\t1\t(7, 7)\t(8, 8)\t0\nplanner__cardinality__selectivity\tct2\t\ta\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\tct2\t\ta\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\tct2\t\ta\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\tct2\t\tb\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\tct2\t\tb\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\tct2\t\tb\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\tct2\t\tc\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\tct2\t\tc\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\tct2\t\tc\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttdatetime\t\ta\t0\t0\t2\t1\t2001-01-01 00:00:00\t2001-01-02 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\ta\t0\t1\t4\t1\t2001-01-03 00:00:00\t2001-01-04 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tb\t0\t0\t2\t1\t2001-01-01 00:00:00\t2001-01-02 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tb\t0\t1\t4\t1\t2001-01-03 00:00:00\t2001-01-04 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tc\t0\t0\t2\t1\t2001-01-01 00:00:00\t2001-01-02 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tc\t0\t1\t4\t1\t2001-01-03 00:00:00\t2001-01-04 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tmulti\t1\t0\t2\t1\t(2001-01-01 00:00:00, 2001-01-01 00:00:00)\t(2001-01-02 00:00:00, 2001-01-02 00:00:00)\t0\nplanner__cardinality__selectivity\ttdatetime\t\tmulti\t1\t1\t4\t1\t(2001-01-03 00:00:00, 2001-01-03 00:00:00)\t(2001-01-04 00:00:00, 2001-01-04 00:00:00)\t0\nplanner__cardinality__selectivity\ttdatetime\t\tsingular\t1\t0\t2\t1\t2001-01-01 00:00:00\t2001-01-02 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tsingular\t1\t1\t4\t1\t2001-01-03 00:00:00\t2001-01-04 00:00:00\t0\nplanner__cardinality__selectivity\ttdecimal\t\ta\t0\t0\t3\t1\t1.00000000000000000000\t3.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\ta\t0\t1\t6\t1\t4.00000000000000000000\t6.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\ta\t0\t2\t8\t1\t7.00000000000000000000\t8.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tb\t0\t0\t3\t1\t1.00000000000000000000\t3.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tb\t0\t1\t6\t1\t4.00000000000000000000\t6.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tb\t0\t2\t8\t1\t7.00000000000000000000\t8.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tc\t0\t0\t3\t1\t1.00000000000000000000\t3.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tc\t0\t1\t6\t1\t4.00000000000000000000\t6.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tc\t0\t2\t8\t1\t7.00000000000000000000\t8.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tmulti\t1\t0\t3\t1\t(1.00000000000000000000, 1.00000000000000000000)\t(3.00000000000000000000, 3.00000000000000000000)\t0\nplanner__cardinality__selectivity\ttdecimal\t\tmulti\t1\t1\t6\t1\t(4.00000000000000000000, 4.00000000000000000000)\t(6.00000000000000000000, 6.00000000000000000000)\t0\nplanner__cardinality__selectivity\ttdecimal\t\tmulti\t1\t2\t8\t1\t(7.00000000000000000000, 7.00000000000000000000)\t(8.00000000000000000000, 8.00000000000000000000)\t0\nplanner__cardinality__selectivity\ttdecimal\t\tsingular\t1\t0\t3\t1\t1.00000000000000000000\t3.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tsingular\t1\t1\t6\t1\t4.00000000000000000000\t6.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tsingular\t1\t2\t8\t1\t7.00000000000000000000\t8.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdouble\t\ta\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttdouble\t\ta\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttdouble\t\ta\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttdouble\t\tb\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttdouble\t\tb\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttdouble\t\tb\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttdouble\t\tc\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttdouble\t\tc\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttdouble\t\tc\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttdouble\t\tmulti\t1\t0\t3\t1\t(1, 1)\t(3, 3)\t0\nplanner__cardinality__selectivity\ttdouble\t\tmulti\t1\t1\t6\t1\t(4, 4)\t(6, 6)\t0\nplanner__cardinality__selectivity\ttdouble\t\tmulti\t1\t2\t8\t1\t(7, 7)\t(8, 8)\t0\nplanner__cardinality__selectivity\ttdouble\t\tsingular\t1\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttdouble\t\tsingular\t1\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttdouble\t\tsingular\t1\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttint\t\ta\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttint\t\ta\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttint\t\ta\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttint\t\tb\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttint\t\tb\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttint\t\tb\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttint\t\tc\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttint\t\tc\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttint\t\tc\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttint\t\tmulti\t1\t0\t3\t1\t(1, 1)\t(3, 3)\t0\nplanner__cardinality__selectivity\ttint\t\tmulti\t1\t1\t6\t1\t(4, 4)\t(6, 6)\t0\nplanner__cardinality__selectivity\ttint\t\tmulti\t1\t2\t8\t1\t(7, 7)\t(8, 8)\t0\nplanner__cardinality__selectivity\ttint\t\tsingular\t1\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttint\t\tsingular\t1\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttint\t\tsingular\t1\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttprefix\t\ta\t0\t0\t3\t1\t111\t333\t0\nplanner__cardinality__selectivity\ttprefix\t\ta\t0\t1\t6\t1\t444\t666\t0\nplanner__cardinality__selectivity\ttprefix\t\tb\t0\t0\t3\t1\t111\t333\t0\nplanner__cardinality__selectivity\ttprefix\t\tb\t0\t1\t6\t1\t444\t666\t0\nplanner__cardinality__selectivity\ttprefix\t\tprefixa\t1\t0\t3\t1\t11\t33\t0\nplanner__cardinality__selectivity\ttprefix\t\tprefixa\t1\t1\t6\t1\t44\t66\t0\nplanner__cardinality__selectivity\ttstring\t\ta\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttstring\t\ta\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttstring\t\ta\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttstring\t\tb\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttstring\t\tb\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttstring\t\tb\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttstring\t\tc\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttstring\t\tc\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttstring\t\tc\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttstring\t\tmulti\t1\t0\t3\t1\t(1, 1)\t(3, 3)\t0\nplanner__cardinality__selectivity\ttstring\t\tmulti\t1\t1\t6\t1\t(4, 4)\t(6, 6)\t0\nplanner__cardinality__selectivity\ttstring\t\tmulti\t1\t2\t8\t1\t(7, 7)\t(8, 8)\t0\nplanner__cardinality__selectivity\ttstring\t\tsingular\t1\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttstring\t\tsingular\t1\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttstring\t\tsingular\t1\t2\t8\t1\t7\t8\t0\n\n"
./t/planner/cardinality/trace.test: ok! 5 test cases passed, take time 0.104485282 s
./t/planner/cascades/integration.test: ok! 246 test cases passed, take time 1.065529309 s
./t/planner/core/binary_plan.test: ok! 6 test cases passed, take time 0.001975579 s
./t/planner/core/casetest/expression_rewriter.test: ok! 23 test cases passed, take time 0.214896145 s
./t/planner/core/casetest/hint/hint.test: ok! 182 test cases passed, take time 3.155526998 s
./t/planner/core/casetest/index/index.test: ok! 225 test cases passed, take time 2.995092436 s
time="2024-05-18T08:10:20+08:00" level=error msg="run test [planner/core/casetest/integration] err: sql:explain format = 'verbose' select * from t where b = 6 order by a limit 1;: failed to run query \n\"explain format = 'verbose' select * from t where b = 6 order by a limit 1;\" \n around line 390, \nwe need(453):\nexplain format = 'verbose' select * from t where b = 6 order by a limit 1;\nid\testRows\testCost\ttask\taccess object\toperator info\nLimit_11\t0.00\t98.74\troot\t\toffset:0, count:1\n└─TableReader_24\t0.00\t98.74\troot\t\tdata:Limit_23\n  └─Limit_23\t0.00\t1386.04\tcop[tikv]\t\toffset:0, count:1\n    └─Selection_22\t0.00\t1386.04\tcop[tikv]\t\teq(planner__core__casetest__integration.t.b, 6)\n      └─TableFullScan_21\t5.00\t1136.54\tcop[tikv]\ttable:t\tkeep order:true\n\nbut got(453):\nexplain format = 'verbose' select * from t where b = 6 order by a limit 1;\nid\testRows\testCost\ttask\taccess object\toperator info\nLimit_11\t1.00\t98.74\troot\t\toffset:0, count:1\n└─TableReader_24\t1.00\t98.74\troot\t\tdata:Limit_23\n  └─Limit_23\t1.00\t1386.04\tcop[tikv]\t\toffset:0, count:1\n    └─Selection_22\t1.00\t1386.04\tcop[tikv]\t\teq(planner__core__casetest__integration.t.b, 6)\n      └─TableFullScan_21\t5.00\t1136.54\tcop[tikv]\ttable:t\tkeep order:true\n\n"
./t/planner/core/casetest/partition/integration_partition.test: ok! 138 test cases passed, take time 1.9723958719999999 s
./t/planner/core/casetest/partition/partition_pruner.test: ok! 275 test cases passed, take time 2.128472428 s
./t/planner/core/casetest/physicalplantest/physical_plan.test: ok! 858 test cases passed, take time 4.925892722 s
./t/planner/core/casetest/point_get_plan.test: ok! 52 test cases passed, take time 0.260644229 s
./t/planner/core/casetest/predicate_simplification.test: ok! 29 test cases passed, take time 0.169655991 s
./t/planner/core/casetest/pushdown/push_down.test: ok! 35 test cases passed, take time 0.222554782 s
./t/planner/core/casetest/rule/rule_derive_topn_from_window.test: ok! 73 test cases passed, take time 0.674680369 s
./t/planner/core/casetest/rule/rule_join_reorder.test: ok! 481 test cases passed, take time 7.247913145 s
./t/planner/core/casetest/rule/rule_result_reorder.test: ok! 87 test cases passed, take time 1.264367625 s
time="2024-05-18T08:10:40+08:00" level=error msg="run test [planner/core/cbo] err: sql:explain analyze select t1.a, t1.b, sum(t1.c) from t1 join t2 on t1.a = t2.b where t1.a > 1;: failed to run query \n\"explain analyze select t1.a, t1.b, sum(t1.c) from t1 join t2 on t1.a = t2.b where t1.a > 1;\" \n around line 63, \nwe need(1817):\nexplain analyze select t1.a, t1.b, sum(t1.c) from t1 join t2 on t1.a = t2.b where t1.a > 1;\nid\testRows\tactRows\ttask\taccess object\texecution info\toperator info\tmemory\tdisk\nProjection_9\t1.00\t1\troot\tNULL\ttime:<num>, loops:<num>, RU:<num>, Concurrency:OFF\tplanner__core__cbo.t1.a, planner__core__cbo.t1.b, Column#8\t<num>\tN/A\n└─StreamAgg_11\t1.00\t1\troot\tNULL\ttime:<num>, loops:<num>\tfuncs:sum(Column#16)->Column#8, funcs:firstrow(Column#17)->planner__core__cbo.t1.a, funcs:firstrow(Column#18)->planner__core__cbo.t1.b\t<num>\tN/A\n  └─Projection_53\t4.00\t3\troot\tNULL\ttime:<num>, loops:<num>, Concurrency:OFF\tcast(planner__core__cbo.t1.c, decimal(10,0) BINARY)->Column#16, planner__core__cbo.t1.a->Column#17, planner__core__cbo.t1.b->Column#18\t<num>\tN/A\n    └─HashJoin_51\t4.00\t3\troot\tNULL\ttime:<num>, loops:<num>, build_hash_table:{total:<num>, fetch:<num>, build:<num>}, probe:{concurrency:<num>, total:<num>, max:<num>, probe:<num>, fetch and wait:<num>}\tinner join, equal:[eq(planner__core__cbo.t1.a, planner__core__cbo.t2.b)]\t<num>\t<num>\n      ├─TableReader_30(Build)\t6.00\t6\troot\tNULL\ttime.*loops.*cop_task.*\tdata:Selection_29\t<num>\tN/A\n      │ └─Selection_29\t6.00\t6\tcop[tikv]\tNULL\ttikv_task:{time:<num>, loops:<num>}\tgt(planner__core__cbo.t2.b, 1), not(isnull(planner__core__cbo.t2.b))\tN/A\tN/A\n      │   └─TableFullScan_28\t6.00\t6\tcop[tikv]\ttable:t2\ttikv_task:{time:<num>, loops:<num>}\tkeep order:false\tN/A\tN/A\n      └─TableReader_33(Probe)\t4.00\t4\troot\tNULL\ttime.*loops.*cop_task.*\tdata:Selection_32\t<num>\tN/A\n        └─Selection_32\t4.00\t4\tcop[tikv]\tNULL\ttikv_task:{time:<num>, loops:<num>}\tgt(planner__core__cbo.t1.a, 1), not(isnull(planner__core__cbo.t1.a))\tN/A\tN/A\n          └─TableFullScan_31\t5.00\t5\tcop[tikv]\ttable:t1\ttikv_task:{time:<num>, loops:<num>}\tkeep order:false\tN/A\tN/A\n\nbut got(1817):\nexplain analyze select t1.a, t1.b, sum(t1.c) from t1 join t2 on t1.a = t2.b where t1.a > 1;\nid\testRows\tactRows\ttask\taccess object\texecution info\toperator info\tmemory\tdisk\nProjection_9\t1.00\t1\troot\tNULL\ttime:<num>, loops:<num>, RU:<num>, Concurrency:OFF\tplanner__core__cbo.t1.a, planner__core__cbo.t1.b, Column#8\t<num>\tN/A\n└─StreamAgg_11\t1.00\t1\troot\tNULL\ttime:<num>, loops:<num>\tfuncs:sum(Column#16)->Column#8, funcs:firstrow(Column#17)->planner__core__cbo.t1.a, funcs:firstrow(Column#18)->planner__core__cbo.t1.b\t<num>\tN/A\n  └─Projection_53\t4.00\t3\troot\tNULL\ttime:<num>, loops:<num>, Concurrency:OFF\tcast(planner__core__cbo.t1.c, decimal(10,0) BINARY)->Column#16, planner__core__cbo.t1.a->Column#17, planner__core__cbo.t1.b->Column#18\t<num>\tN/A\n    └─HashJoin_51\t4.00\t3\troot\tNULL\ttime:<num>, loops:<num>, build_hash_table:{total:<num>, fetch:<num>, build:<num>}, probe:{concurrency:<num>, total:<num>, max:<num>, probe:<num>, fetch and wait:<num>}\tinner join, equal:[eq(planner__core__cbo.t1.a, planner__core__cbo.t2.b)]\t<num>\t<num>\n      ├─TableReader_30(Build)\t5.00\t6\troot\tNULL\ttime.*loops.*cop_task.*\tdata:Selection_29\t<num>\tN/A\n      │ └─Selection_29\t5.00\t6\tcop[tikv]\tNULL\ttikv_task:{time:<num>, loops:<num>}\tgt(planner__core__cbo.t2.b, 1), not(isnull(planner__core__cbo.t2.b))\tN/A\tN/A\n      │   └─TableFullScan_28\t6.00\t6\tcop[tikv]\ttable:t2\ttikv_task:{time:<num>, loops:<num>}\tkeep order:false\tN/A\tN/A\n      └─TableReader_33(Probe)\t4.00\t4\troot\tNULL\ttime.*loops.*cop_task.*\tdata:Selection_32\t<num>\tN/A\n        └─Selection_32\t4.00\t4\tcop[tikv]\tNULL\ttikv_task:{time:<num>, loops:<num>}\tgt(planner__core__cbo.t1.a, 1), not(isnull(planner__core__cbo.t1.a))\tN/A\tN/A\n          └─TableFullScan_31\t5.00\t5\tcop[tikv]\ttable:t1\ttikv_task:{time:<num>, loops:<num>}\tkeep order:false\tN/A\tN/A\n\n"
./t/planner/core/enforce_mpp.test: ok! 8 test cases passed, take time 0.001636727 s
./t/planner/core/expression_rewriter.test: ok! 206 test cases passed, take time 3.461403309 s
./t/planner/core/indexjoin.test: ok! 41 test cases passed, take time 0.171670916 s
./t/planner/core/indexmerge_intersection.test: ok! 6 test cases passed, take time 0.044590181 s
./t/planner/core/indexmerge_path.test: ok! 231 test cases passed, take time 3.136590467 s
./t/planner/core/integration.test: ok! 1623 test cases passed, take time 21.748585201 s
./t/planner/core/integration_partition.test: ok! 498 test cases passed, take time 7.924876186 s
./t/planner/core/issuetest/planner_issue.test: ok! 106 test cases passed, take time 2.123502385 s
./t/planner/core/memtable_predicate_extractor.test: ok! 45 test cases passed, take time 0.132668005 s
time="2024-05-18T08:11:22+08:00" level=error msg="run test [planner/core/partition_pruner] err: sql:explain format='brief' select * from t where a in (1,2) and b in (3,4);: failed to run query \n\"explain format='brief' select * from t where a in (1,2) and b in (3,4);\" \n around line 907, \nwe need(325):\nexplain format='brief' select * from t where a in (1,2) and b in (3,4);\nid\testRows\ttask\taccess object\toperator info\nTableReader\t2.57\troot\tpartition:pDef\tdata:Selection\n└─Selection\t2.57\tcop[tikv]\t\tin(listdefaultprune.t.a, 1, 2), in(listdefaultprune.t.b, 3, 4)\n  └─TableFullScan\t7.00\tcop[tikv]\ttable:t\tkeep order:false\n\nbut got(325):\nexplain format='brief' select * from t where a in (1,2) and b in (3,4);\nid\testRows\ttask\taccess object\toperator info\nTableReader\t1.27\troot\tpartition:pDef\tdata:Selection\n└─Selection\t1.27\tcop[tikv]\t\tin(listdefaultprune.t.a, 1, 2), in(listdefaultprune.t.b, 3, 4)\n  └─TableFullScan\t7.00\tcop[tikv]\ttable:t\tkeep order:false\n\n"
./t/planner/core/physical_plan.test: ok! 43 test cases passed, take time 0.59669443 s
./t/planner/core/plan.test: ok! 157 test cases passed, take time 1.43541285 s
./t/planner/core/plan_cache.test: ok! 1243 test cases passed, take time 7.618993697 s
./t/planner/core/plan_cost_ver2.test: ok! 70 test cases passed, take time 0.513611152 s
./t/planner/core/point_get_plan.test: ok! 265 test cases passed, take time 2.223481032 s
./t/planner/core/preprocess.test: ok! 6 test cases passed, take time 0.059825196 s
./t/planner/core/range_scan_for_like.test: ok! 183 test cases passed, take time 0.506454974 s
./t/planner/core/rule_constant_propagation.test: ok! 31 test cases passed, take time 0.745548257 s
./t/planner/core/rule_join_reorder.test: ok! 52 test cases passed, take time 0.92235427 s
./t/planner/core/rule_result_reorder.test: ok! 29 test cases passed, take time 0.221304542 s
./t/planner/core/tests/prepare/issue.test: ok! 321 test cases passed, take time 1.924483884 s
./t/planner/core/tests/prepare/prepare.test: ok! 458 test cases passed, take time 2.83910304 s
./t/planner/funcdep/only_full_group_by.test: ok! 142 test cases passed, take time 2.909436711 s
./t/privilege/privileges.test: ok! 411 test cases passed, take time 4.371361134 s
./t/select.test: ok! 189 test cases passed, take time 1.5018653400000002 s
./t/session/bootstrap_upgrade.test: ok! 29 test cases passed, take time 0.134310958 s
./t/session/clustered_index.test: ok! 385 test cases passed, take time 8.739787305 s
./t/session/common.test: ok! 203 test cases passed, take time 5.122262878 s
./t/session/nontransactional.test: ok! 1532 test cases passed, take time 7.917323156 s
./t/session/privileges.test: ok! 66 test cases passed, take time 0.870929878 s
./t/session/session.test: ok! 101 test cases passed, take time 1.045150821 s
./t/session/temporary_table.test: ok! 277 test cases passed, take time 0.356973187 s
./t/session/txn.test: ok! 14 test cases passed, take time 0.04190045 s
./t/session/variable.test: ok! 113 test cases passed, take time 0.260541651 s
./t/session/vars.test: ok! 127 test cases passed, take time 0.110322744 s
./t/sessionctx/setvar.test: ok! 681 test cases passed, take time 0.172382221 s
./t/sessiontxn/externals.test: ok! 56 test cases passed, take time 0.216861667 s
./t/statistics/handle.test: ok! 60 test cases passed, take time 1.443577158 s
./t/statistics/integration.test: ok! 19 test cases passed, take time 0.147577507 s
./t/statistics/lock_table_stats.test: ok! 47 test cases passed, take time 0.579106255 s
./t/subquery.test: ok! 32 test cases passed, take time 0.504424953 s
./t/table/cache.test: ok! 108 test cases passed, take time 8.726027911 s
./t/table/index.test: ok! 38 test cases passed, take time 0.908976493 s
./t/table/partition.test: ok! 229 test cases passed, take time 3.5461041189999998 s
./t/table/tables.test: ok! 6 test cases passed, take time 0.033864059 s
./t/table/temptable.test: ok! 11 test cases passed, take time 0.06913987 s
./t/topn_push_down.test: ok! 20 test cases passed, take time 0.225968605 s
./t/topn_pushdown.test: ok! 2 test cases passed, take time 0.000574716 s
./t/tpch.test: ok! 41 test cases passed, take time 2.02577282 s
./t/types/const.test: ok! 143 test cases passed, take time 1.691427024 s
./t/util/admin.test: ok! 240 test cases passed, take time 3.1835942 s
time="2024-05-18T08:12:43+08:00" level=error msg="run test [util/ranger] err: sql:explain format='brief' select * from t where a > 0;: failed to run query \n\"explain format='brief' select * from t where a > 0;\" \n around line 87, \nwe need(487):\nexplain format='brief' select * from t where a > 0;\nid\testRows\ttask\taccess object\toperator info\nPartitionUnion\t3.00\troot\t\t\n├─TableReader\t0.00\troot\t\tdata:Selection\n│ └─Selection\t0.00\tcop[tikv]\t\tgt(util__ranger.t.a, 0)\n│   └─TableFullScan\t1.00\tcop[tikv]\ttable:t, partition:p0\tkeep order:false\n└─TableReader\t3.00\troot\t\tdata:Selection\n  └─Selection\t3.00\tcop[tikv]\t\tgt(util__ranger.t.a, 0)\n    └─TableFullScan\t3.00\tcop[tikv]\ttable:t, partition:p1\tkeep order:false\n\nbut got(487):\nexplain format='brief' select * from t where a > 0;\nid\testRows\ttask\taccess object\toperator info\nPartitionUnion\t0.00\troot\t\t\n├─TableReader\t0.00\troot\t\tdata:Selection\n│ └─Selection\t0.00\tcop[tikv]\t\tgt(util__ranger.t.a, 0)\n│   └─TableFullScan\t1.00\tcop[tikv]\ttable:t, partition:p0\tkeep order:false\n└─TableReader\t0.00\troot\t\tdata:Selection\n  └─Selection\t0.00\tcop[tikv]\t\tgt(util__ranger.t.a, 0)\n    └─TableFullScan\t3.00\tcop[tikv]\ttable:t, partition:p1\tkeep order:false\n\n"
./t/window_function.test: ok! 28 test cases passed, take time 0.176731984 s

time="2024-05-18T08:12:43+08:00" level=error msg="12 tests failed\n"
time="2024-05-18T08:12:43+08:00" level=error msg="run test [ddl/db_partition] err: sql:explain format = 'brief' select * from t where a between \"3\" and \"4\";: failed to run query \n\"explain format = 'brief' select * from t where a between \"3\" and \"4\";\" \n around line 365, \nwe need(583):\nexplain format = 'brief' select * from t where a between \"3\" and \"4\";\nid\testRows\ttask\taccess object\toperator info\nPartitionUnion\t2.00\troot\t\t\n├─TableReader\t1.00\troot\t\tdata:Selection\n│ └─Selection\t1.00\tcop[tikv]\t\tge(ddl__db_partition.t.a, \"3\"), le(ddl__db_partition.t.a, \"4\")\n│   └─TableFullScan\t1.00\tcop[tikv]\ttable:t, partition:p0\tkeep order:false\n└─TableReader\t1.00\troot\t\tdata:Selection\n  └─Selection\t1.00\tcop[tikv]\t\tge(ddl__db_partition.t.a, \"3\"), le(ddl__db_partition.t.a, \"4\")\n    └─TableFullScan\t4.00\tcop[tikv]\ttable:t, partition:p1\tkeep order:false\n\nbut got(583):\nexplain format = 'brief' select * from t where a between \"3\" and \"4\";\nid\testRows\ttask\taccess object\toperator info\nPartitionUnion\t3.00\troot\t\t\n├─TableReader\t1.00\troot\t\tdata:Selection\n│ └─Selection\t1.00\tcop[tikv]\t\tge(ddl__db_partition.t.a, \"3\"), le(ddl__db_partition.t.a, \"4\")\n│   └─TableFullScan\t1.00\tcop[tikv]\ttable:t, partition:p0\tkeep order:false\n└─TableReader\t2.00\troot\t\tdata:Selection\n  └─Selection\t2.00\tcop[tikv]\t\tge(ddl__db_partition.t.a, \"3\"), le(ddl__db_partition.t.a, \"4\")\n    └─TableFullScan\t4.00\tcop[tikv]\ttable:t, partition:p1\tkeep order:false\n\n"
time="2024-05-18T08:12:43+08:00" level=error msg="run test [executor/kv] err: sql:select count(*)>0 from mysql.stats_top_n where table_id = @a;: failed to run query \n\"select count(*)>0 from mysql.stats_top_n where table_id = @a;\" \n around line 12, \nwe need(75):\nselect count(*)>0 from mysql.stats_top_n where table_id = @a;\ncount(*)>0\n1\n\nbut got(75):\nselect count(*)>0 from mysql.stats_top_n where table_id = @a;\ncount(*)>0\n0\n\n"
time="2024-05-18T08:12:43+08:00" level=error msg="run test [executor/partition/issues] err: sql:explain select * from t where col_51 between 9223372036854775812 and 9223372036854775813;: failed to run query \n\"explain select * from t where col_51 between 9223372036854775812 and 9223372036854775813;\" \n around line 272, \nwe need(308):\nexplain select * from t where col_51 between 9223372036854775812 and 9223372036854775813;\nid\testRows\ttask\taccess object\toperator info\nTableReader_6\t2.00\troot\tpartition:p3,p4\tdata:TableRangeScan_5\n└─TableRangeScan_5\t2.00\tcop[tikv]\ttable:t\trange:[9223372036854775812,9223372036854775813], keep order:false\n\nbut got(308):\nexplain select * from t where col_51 between 9223372036854775812 and 9223372036854775813;\nid\testRows\ttask\taccess object\toperator info\nTableReader_6\t2.80\troot\tpartition:p3,p4\tdata:TableRangeScan_5\n└─TableRangeScan_5\t2.80\tcop[tikv]\ttable:t\trange:[9223372036854775812,9223372036854775813], keep order:false\n\n"
time="2024-05-18T08:12:43+08:00" level=error msg="run test [executor/partition/partition_boundaries] err: sql:explain format='brief' SELECT * FROM t WHERE a = 3000000;: failed to run query \n\"explain format='brief' SELECT * FROM t WHERE a = 3000000;\" \n around line 57, \nwe need(308):\nexplain format='brief' SELECT * FROM t WHERE a = 3000000;\nid\testRows\ttask\taccess object\toperator info\nTableReader\t0.00\troot\tpartition:dual\tdata:Selection\n└─Selection\t0.00\tcop[tikv]\t\teq(executor__partition__partition_boundaries.t.a, 3000000)\n  └─TableFullScan\t14.00\tcop[tikv]\ttable:t\tkeep order:false\n\nbut got(308):\nexplain format='brief' SELECT * FROM t WHERE a = 3000000;\nid\testRows\ttask\taccess object\toperator info\nTableReader\t1.00\troot\tpartition:dual\tdata:Selection\n└─Selection\t1.00\tcop[tikv]\t\teq(executor__partition__partition_boundaries.t.a, 3000000)\n  └─TableFullScan\t14.00\tcop[tikv]\ttable:t\tkeep order:false\n\n"
time="2024-05-18T08:12:43+08:00" level=error msg="run test [executor/partition/partition_with_expression] err: sql:explain select * from tp where a > '2020-09-11 00:00:00';: failed to run query \n\"explain select * from tp where a > '2020-09-11 00:00:00';\" \n around line 57, \nwe need(339):\nexplain select * from tp where a > '2020-09-11 00:00:00';\nid\testRows\ttask\taccess object\toperator info\nTableReader_7\t1.00\troot\tpartition:p2\tdata:Selection_6\n└─Selection_6\t1.00\tcop[tikv]\t\tgt(executor__partition__partition_with_expression.tp.a, 2020-09-11 00:00:00.000000)\n  └─TableFullScan_5\t4.00\tcop[tikv]\ttable:tp\tkeep order:false\n\nbut got(339):\nexplain select * from tp where a > '2020-09-11 00:00:00';\nid\testRows\ttask\taccess object\toperator info\nTableReader_7\t0.00\troot\tpartition:p2\tdata:Selection_6\n└─Selection_6\t0.00\tcop[tikv]\t\tgt(executor__partition__partition_with_expression.tp.a, 2020-09-11 00:00:00.000000)\n  └─TableFullScan_5\t4.00\tcop[tikv]\ttable:tp\tkeep order:false\n\n"
time="2024-05-18T08:12:43+08:00" level=error msg="run test [explain_easy] err: sql:explain format = 'brief' select * from t where a >= 3 and a <= 8;: failed to run query \n\"explain format = 'brief' select * from t where a >= 3 and a <= 8;\" \n around line 193, \nwe need(291):\nexplain format = 'brief' select * from t where a >= 3 and a <= 8;\nid\testRows\ttask\taccess object\toperator info\nTableReader\t0.00\troot\t\tdata:Selection\n└─Selection\t0.00\tcop[tikv]\t\tge(explain_easy.t.a, 3), le(explain_easy.t.a, 8)\n  └─TableFullScan\t8.00\tcop[tikv]\ttable:t\tkeep order:false\n\nbut got(291):\nexplain format = 'brief' select * from t where a >= 3 and a <= 8;\nid\testRows\ttask\taccess object\toperator info\nTableReader\t1.56\troot\t\tdata:Selection\n└─Selection\t1.56\tcop[tikv]\t\tge(explain_easy.t.a, 3), le(explain_easy.t.a, 8)\n  └─TableFullScan\t8.00\tcop[tikv]\ttable:t\tkeep order:false\n\n"
time="2024-05-18T08:12:43+08:00" level=error msg="run test [explain_generate_column_substitute] err: sql:desc format = 'brief' select * from t where (lower(b) = \"a\" and a+1 = 2) or (lower(b) = \"b\" and a+1 = 5);: failed to run query \n\"desc format = 'brief' select * from t where (lower(b) = \"a\" and a+1 = 2) or (lower(b) = \"b\" and a+1 = 5);\" \n around line 198, \nwe need(629):\ndesc format = 'brief' select * from t where (lower(b) = \"a\" and a+1 = 2) or (lower(b) = \"b\" and a+1 = 5);\nid\testRows\ttask\taccess object\toperator info\nProjection\t1.00\troot\t\texplain_generate_column_substitute.t.a, explain_generate_column_substitute.t.b\n└─IndexLookUp\t1.00\troot\t\t\n  ├─IndexRangeScan(Build)\t1.00\tcop[tikv]\ttable:t, index:expression_index(lower(`b`), `a` + 1)\trange:[\"a\" 2,\"a\" 2], [\"b\" 5,\"b\" 5], keep order:false\n  └─TableRowIDScan(Probe)\t1.00\tcop[tikv]\ttable:t\tkeep order:false\ndesc format = 'brief' select * from t where not (lower(b) >= \"a\");\nid\testRows\ttask\taccess object\toperator info\nProjection\t0.00\t\nbut got(629):\ndesc format = 'brief' select * from t where (lower(b) = \"a\" and a+1 = 2) or (lower(b) = \"b\" and a+1 = 5);\nid\testRows\ttask\taccess object\toperator info\nProjection\t2.00\troot\t\texplain_generate_column_substitute.t.a, explain_generate_column_substitute.t.b\n└─Selection\t4.80\troot\t\tor(and(eq(lower(explain_generate_column_substitute.t.b), \"a\"), eq(plus(explain_generate_column_substitute.t.a, 1), 2)), and(eq(lower(explain_generate_column_substitute.t.b), \"b\"), eq(plus(explain_generate_column_substitute.t.a, 1), 5)))\n  └─TableReader\t6.00\troot\t\tdata:TableFullScan\n    └─TableFullScan\t6.00\tcop[tikv]\ttable:t\tkeep order:false\n\n"
time="2024-05-18T08:12:43+08:00" level=error msg="run test [planner/cardinality/selectivity] err: sql:show stats_buckets where db_name = 'planner__cardinality__selectivity';: failed to run query \n\"show stats_buckets where db_name = 'planner__cardinality__selectivity';\" \n around line 52, \nwe need(7391):\nplanner__cardinality__selectivity\tct1\t\tPRIMARY\t1\t1\t1\nplanner__cardinality__selectivity\tct1\t\tPRIMARY\t1\t2\t1\nplanner__cardinality__selectivity\tct1\t\ta\t0\t1\t1\nplanner__cardinality__selectivity\tct1\t\ta\t0\t2\t1\nplanner__cardinality__selectivity\tct1\t\tpk\t0\t1\t1\nplanner__cardinality__selectivity\tct1\t\tpk\t0\t2\t1\nplanner__cardinality__selectivity\tct2\t\tPRIMARY\t1\t(1, 1)\t1\nplanner__cardinality__selectivity\tct2\t\tPRIMARY\t1\t(2, 2)\t1\nplanner__cardinality__selectivity\tct2\t\ta\t0\t1\t1\nplanner__cardinality__selectivity\tct2\t\ta\t0\t2\t1\nplanner__cardinality__selectivity\tct2\t\tb\t0\t1\t1\nplanner__cardinality__selectivity\tct2\t\tb\t0\t2\t1\nplanner__cardinality__selectivity\tct2\t\tc\t0\t1\t1\nplanner__cardinality__selectivity\tct2\t\tc\t0\t2\t1\nplanner__cardinality__selectivity\ttdatetime\t\ta\t0\t2001-01-01 00:00:00\t1\nplanner__cardinality__selectivity\ttdatetime\t\ta\t0\t2001-01-02 00:00:00\t1\nplanner__cardinality__selectivity\ttdatetime\t\tb\t0\t2001-01-01 00:00:00\t1\nplanner__cardinality__selectivity\ttdatetime\t\tb\t0\t2001-01-02 00:00:00\t1\nplanner__cardinality__selectivity\ttdatetime\t\tc\t0\t2001-01-01 00:00:00\t1\nplanner__cardinality__selectivity\ttdatetime\t\tc\t0\t2001-01-02 00:00:00\t1\nplanner__cardinality__selectivity\ttdatetime\t\tmulti\t1\t(2001-01-01 00:00:00, 2001-01-01 00:00:00)\t1\nplanner__cardinality__selectivity\ttdatetime\t\tmulti\t1\t(2001-01-02 00:00:00, 2001-01-02 00:00:00)\t1\nplanner__cardinality__selectivity\ttdatetime\t\tsingular\t1\t2001-01-01 00:00:00\t1\nplanner__cardinality__selectivity\ttdatetime\t\tsingular\t1\t2001-01-02 00:00:00\t1\nplanner__cardinality__selectivity\ttdecimal\t\ta\t0\t1.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdecimal\t\ta\t0\t2.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdecimal\t\tb\t0\t1.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdecimal\t\tb\t0\t2.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdecimal\t\tc\t0\t1.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdecimal\t\tc\t0\t2.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdecimal\t\tmulti\t1\t(1.00000000000000000000, 1.00000000000000000000)\t1\nplanner__cardinality__selectivity\ttdecimal\t\tmulti\t1\t(2.00000000000000000000, 2.00000000000000000000)\t1\nplanner__cardinality__selectivity\ttdecimal\t\tsingular\t1\t1.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdecimal\t\tsingular\t1\t2.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdouble\t\ta\t0\t1\t1\nplanner__cardinality__selectivity\ttdouble\t\ta\t0\t2\t1\nplanner__cardinality__selectivity\ttdouble\t\tb\t0\t1\t1\nplanner__cardinality__selectivity\ttdouble\t\tb\t0\t2\t1\nplanner__cardinality__selectivity\ttdouble\t\tc\t0\t1\t1\nplanner__cardinality__selectivity\ttdouble\t\tc\t0\t2\t1\nplanner__cardinality__selectivity\ttdouble\t\tmulti\t1\t(1, 1)\t1\nplanner__cardinality__selectivity\ttdouble\t\tmulti\t1\t(2, 2)\t1\nplanner__cardinality__selectivity\ttdouble\t\tsingular\t1\t1\t1\nplanner__cardinality__selectivity\ttdouble\t\tsingular\t1\t2\t1\nplanner__cardinality__selectivity\ttint\t\ta\t0\t1\t1\nplanner__cardinality__selectivity\ttint\t\ta\t0\t2\t1\nplanner__cardinality__selectivity\ttint\t\tb\t0\t1\t1\nplanner__cardinality__selectivity\ttint\t\tb\t0\t2\t1\nplanner__cardinality__selectivity\ttint\t\tc\t0\t1\t1\nplanner__cardinality__selectivity\ttint\t\tc\t0\t2\t1\nplanner__cardinality__selectivity\ttint\t\tmulti\t1\t(1, 1)\t1\nplanner__cardinality__selectivity\ttint\t\tmulti\t1\t(2, 2)\t1\nplanner__cardinality__selectivity\ttint\t\tsingular\t1\t1\t1\nplanner__cardinality__selectivity\ttint\t\tsingular\t1\t2\t1\nplanner__cardinality__selectivity\ttprefix\t\ta\t0\t111\t1\nplanner__cardinality__selectivity\ttprefix\t\ta\t0\t222\t1\nplanner__cardinality__selectivity\ttprefix\t\tb\t0\t111\t1\nplanner__cardinality__selectivity\ttprefix\t\tb\t0\t222\t1\nplanner__cardinality__selectivity\ttprefix\t\tprefixa\t1\t11\t1\nplanner__cardinality__selectivity\ttprefix\t\tprefixa\t1\t22\t1\nplanner__cardinality__selectivity\ttstring\t\ta\t0\t1\t1\nplanner__cardinality__selectivity\ttstring\t\ta\t0\t2\t1\nplanner__cardinality__selectivity\ttstring\t\tb\t0\t1\t1\nplanner__cardinality__selectivity\ttstring\t\tb\t0\t2\t1\nplanner__cardinality__selectivity\ttstring\t\tc\t0\t1\t1\nplanner__cardinality__selectivity\ttstring\t\tc\t0\t2\t1\nplanner__cardinality__selectivity\ttstring\t\tmulti\t1\t(1, 1)\t1\nplanner__cardinality__selectivity\ttstring\t\tmulti\t1\t(2, 2)\t1\nplanner__cardinality__selectivity\ttstring\t\tsingular\t1\t1\t1\nplanner__cardinality__selectivity\ttstring\t\tsingular\t1\t2\t1\nshow stats_buckets where db_name = 'planner__cardinality__selectivity';\nDb_name\tTable_name\tPartition_name\tColumn_name\tIs_index\tBucket_id\tCount\tRepeats\tLower_Bound\tUpper_Bound\tNdv\nplanner__cardinality__selectivity\tct1\t\tPRIMARY\t1\t0\t3\t1\t3\t5\t0\nplanner__cardinality__selectivity\tct1\t\tPRIMARY\t1\t1\t6\t1\t6\t8\t0\nplanner__cardinality__selectivity\tct1\t\ta\t0\t0\t3\t1\t3\t5\t0\nplanner__cardinality__selectivity\tct1\t\ta\t0\t1\t6\t1\t6\t8\t0\nplanner__cardinality__selectivity\tct1\t\tpk\t0\t0\t3\t1\t3\t5\t0\nplanner__cardinality__selectivity\tct1\t\tpk\t0\t1\t6\t1\t6\t8\t0\nplanner__cardinality__selectivity\tct2\t\tPRIMARY\t1\t0\t3\t1\t(3, 3)\t(5, 5)\t0\nplanner__cardinality__selectivity\tct2\t\tPRIMARY\t1\t1\t6\t1\t(6, 6)\t(8, 8)\t0\nplanner__cardinality__selectivity\tct2\t\ta\t0\t0\t3\t1\t3\t5\t0\nplanner__cardinality__selectivity\tct2\t\ta\t0\t1\t6\t1\t6\t8\t0\nplanner__cardinality__selectivity\tct2\t\tb\t0\t0\t3\t1\t3\t5\t0\nplanner__cardinality__selectivity\tct2\t\tb\t0\t1\t6\t1\t6\t8\t0\nplanner__cardinality__selectivity\tct2\t\tc\t0\t0\t3\t1\t3\t5\t0\nplanner__cardinality__selectivity\tct2\t\tc\t0\t1\t6\t1\t6\t8\t0\nplanner__cardinality__selectivity\ttdatetime\t\ta\t0\t0\t1\t1\t2001-01-03 00:00:00\t2001-01-03 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\ta\t0\t1\t2\t1\t2001-01-04 00:00:00\t2001-01-04 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tb\t0\t0\t1\t1\t2001-01-03 00:00:00\t2001-01-03 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tb\t0\t1\t2\t1\t2001-01-04 00:00:00\t2001-01-04 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tc\t0\t0\t1\t1\t2001-01-03 00:00:00\t2001-01-03 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tc\t0\t1\t2\t1\t2001-01-04 00:00:00\t2001-01-04 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tmulti\t1\t0\t1\t1\t(2001-01-03 00:00:00, 2001-01-03 00:00:00)\t(2001-01-03 00:00:00, 2001-01-03 00:00:00)\t0\nplanner__cardinality__selectivity\ttdatetime\t\tmulti\t1\t1\t2\t1\t(2001-01-04 00:00:00, 2001-01-04 00:00:00)\t(2001-01-04 00:00:00, 2001-01-04 00:00:00)\t0\nplanner__cardinality__selectivity\ttdatetime\t\tsingular\t1\t0\t1\t1\t2001-01-03 00:00:00\t2001-01-03 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tsingular\t1\t1\t2\t1\t2001-01-04 00:00:00\t2001-01-04 00:00:00\t0\nplanner__cardinality__selectivity\ttdecimal\t\ta\t0\t0\t3\t1\t3.00000000000000000000\t5.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\ta\t0\t1\t6\t1\t6.00000000000000000000\t8.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tb\t0\t0\t3\t1\t3.00000000000000000000\t5.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tb\t0\t1\t6\t1\t6.00000000000000000000\t8.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tc\t0\t0\t3\t1\t3.00000000000000000000\t5.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tc\t0\t1\t6\t1\t6.00000000000000000000\t8.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tmulti\t1\t0\t3\t1\t(3.00000000000000000000, 3.00000000000000000000)\t(5.00000000000000000000, 5.00000000000000000000)\t0\nplanner__cardinality__selectivity\ttdecimal\t\tmulti\t1\t1\t6\t1\t(6.00000000000000000000, 6.00000000000000000000)\t(8.00000000000000000000, 8.00000000000000000000)\t0\nplanner__cardinality__selectivity\ttdecimal\t\tsingular\t1\t0\t3\t1\t3.00000000000000000000\t5.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tsingular\t1\t1\t6\t1\t6.000000000000\nbut got(7391):\nshow stats_buckets where db_name = 'planner__cardinality__selectivity';\nDb_name\tTable_name\tPartition_name\tColumn_name\tIs_index\tBucket_id\tCount\tRepeats\tLower_Bound\tUpper_Bound\tNdv\nplanner__cardinality__selectivity\tct1\t\tPRIMARY\t1\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\tct1\t\tPRIMARY\t1\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\tct1\t\tPRIMARY\t1\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\tct1\t\ta\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\tct1\t\ta\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\tct1\t\ta\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\tct1\t\tpk\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\tct1\t\tpk\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\tct1\t\tpk\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\tct2\t\tPRIMARY\t1\t0\t3\t1\t(1, 1)\t(3, 3)\t0\nplanner__cardinality__selectivity\tct2\t\tPRIMARY\t1\t1\t6\t1\t(4, 4)\t(6, 6)\t0\nplanner__cardinality__selectivity\tct2\t\tPRIMARY\t1\t2\t8\t1\t(7, 7)\t(8, 8)\t0\nplanner__cardinality__selectivity\tct2\t\ta\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\tct2\t\ta\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\tct2\t\ta\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\tct2\t\tb\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\tct2\t\tb\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\tct2\t\tb\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\tct2\t\tc\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\tct2\t\tc\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\tct2\t\tc\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttdatetime\t\ta\t0\t0\t2\t1\t2001-01-01 00:00:00\t2001-01-02 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\ta\t0\t1\t4\t1\t2001-01-03 00:00:00\t2001-01-04 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tb\t0\t0\t2\t1\t2001-01-01 00:00:00\t2001-01-02 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tb\t0\t1\t4\t1\t2001-01-03 00:00:00\t2001-01-04 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tc\t0\t0\t2\t1\t2001-01-01 00:00:00\t2001-01-02 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tc\t0\t1\t4\t1\t2001-01-03 00:00:00\t2001-01-04 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tmulti\t1\t0\t2\t1\t(2001-01-01 00:00:00, 2001-01-01 00:00:00)\t(2001-01-02 00:00:00, 2001-01-02 00:00:00)\t0\nplanner__cardinality__selectivity\ttdatetime\t\tmulti\t1\t1\t4\t1\t(2001-01-03 00:00:00, 2001-01-03 00:00:00)\t(2001-01-04 00:00:00, 2001-01-04 00:00:00)\t0\nplanner__cardinality__selectivity\ttdatetime\t\tsingular\t1\t0\t2\t1\t2001-01-01 00:00:00\t2001-01-02 00:00:00\t0\nplanner__cardinality__selectivity\ttdatetime\t\tsingular\t1\t1\t4\t1\t2001-01-03 00:00:00\t2001-01-04 00:00:00\t0\nplanner__cardinality__selectivity\ttdecimal\t\ta\t0\t0\t3\t1\t1.00000000000000000000\t3.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\ta\t0\t1\t6\t1\t4.00000000000000000000\t6.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\ta\t0\t2\t8\t1\t7.00000000000000000000\t8.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tb\t0\t0\t3\t1\t1.00000000000000000000\t3.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tb\t0\t1\t6\t1\t4.00000000000000000000\t6.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tb\t0\t2\t8\t1\t7.00000000000000000000\t8.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tc\t0\t0\t3\t1\t1.00000000000000000000\t3.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tc\t0\t1\t6\t1\t4.00000000000000000000\t6.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tc\t0\t2\t8\t1\t7.00000000000000000000\t8.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tmulti\t1\t0\t3\t1\t(1.00000000000000000000, 1.00000000000000000000)\t(3.00000000000000000000, 3.00000000000000000000)\t0\nplanner__cardinality__selectivity\ttdecimal\t\tmulti\t1\t1\t6\t1\t(4.00000000000000000000, 4.00000000000000000000)\t(6.00000000000000000000, 6.00000000000000000000)\t0\nplanner__cardinality__selectivity\ttdecimal\t\tmulti\t1\t2\t8\t1\t(7.00000000000000000000, 7.00000000000000000000)\t(8.00000000000000000000, 8.00000000000000000000)\t0\nplanner__cardinality__selectivity\ttdecimal\t\tsingular\t1\t0\t3\t1\t1.00000000000000000000\t3.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tsingular\t1\t1\t6\t1\t4.00000000000000000000\t6.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdecimal\t\tsingular\t1\t2\t8\t1\t7.00000000000000000000\t8.00000000000000000000\t0\nplanner__cardinality__selectivity\ttdouble\t\ta\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttdouble\t\ta\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttdouble\t\ta\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttdouble\t\tb\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttdouble\t\tb\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttdouble\t\tb\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttdouble\t\tc\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttdouble\t\tc\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttdouble\t\tc\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttdouble\t\tmulti\t1\t0\t3\t1\t(1, 1)\t(3, 3)\t0\nplanner__cardinality__selectivity\ttdouble\t\tmulti\t1\t1\t6\t1\t(4, 4)\t(6, 6)\t0\nplanner__cardinality__selectivity\ttdouble\t\tmulti\t1\t2\t8\t1\t(7, 7)\t(8, 8)\t0\nplanner__cardinality__selectivity\ttdouble\t\tsingular\t1\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttdouble\t\tsingular\t1\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttdouble\t\tsingular\t1\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttint\t\ta\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttint\t\ta\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttint\t\ta\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttint\t\tb\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttint\t\tb\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttint\t\tb\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttint\t\tc\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttint\t\tc\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttint\t\tc\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttint\t\tmulti\t1\t0\t3\t1\t(1, 1)\t(3, 3)\t0\nplanner__cardinality__selectivity\ttint\t\tmulti\t1\t1\t6\t1\t(4, 4)\t(6, 6)\t0\nplanner__cardinality__selectivity\ttint\t\tmulti\t1\t2\t8\t1\t(7, 7)\t(8, 8)\t0\nplanner__cardinality__selectivity\ttint\t\tsingular\t1\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttint\t\tsingular\t1\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttint\t\tsingular\t1\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttprefix\t\ta\t0\t0\t3\t1\t111\t333\t0\nplanner__cardinality__selectivity\ttprefix\t\ta\t0\t1\t6\t1\t444\t666\t0\nplanner__cardinality__selectivity\ttprefix\t\tb\t0\t0\t3\t1\t111\t333\t0\nplanner__cardinality__selectivity\ttprefix\t\tb\t0\t1\t6\t1\t444\t666\t0\nplanner__cardinality__selectivity\ttprefix\t\tprefixa\t1\t0\t3\t1\t11\t33\t0\nplanner__cardinality__selectivity\ttprefix\t\tprefixa\t1\t1\t6\t1\t44\t66\t0\nplanner__cardinality__selectivity\ttstring\t\ta\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttstring\t\ta\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttstring\t\ta\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttstring\t\tb\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttstring\t\tb\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttstring\t\tb\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttstring\t\tc\t0\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttstring\t\tc\t0\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttstring\t\tc\t0\t2\t8\t1\t7\t8\t0\nplanner__cardinality__selectivity\ttstring\t\tmulti\t1\t0\t3\t1\t(1, 1)\t(3, 3)\t0\nplanner__cardinality__selectivity\ttstring\t\tmulti\t1\t1\t6\t1\t(4, 4)\t(6, 6)\t0\nplanner__cardinality__selectivity\ttstring\t\tmulti\t1\t2\t8\t1\t(7, 7)\t(8, 8)\t0\nplanner__cardinality__selectivity\ttstring\t\tsingular\t1\t0\t3\t1\t1\t3\t0\nplanner__cardinality__selectivity\ttstring\t\tsingular\t1\t1\t6\t1\t4\t6\t0\nplanner__cardinality__selectivity\ttstring\t\tsingular\t1\t2\t8\t1\t7\t8\t0\n\n"
time="2024-05-18T08:12:43+08:00" level=error msg="run test [planner/core/casetest/integration] err: sql:explain format = 'verbose' select * from t where b = 6 order by a limit 1;: failed to run query \n\"explain format = 'verbose' select * from t where b = 6 order by a limit 1;\" \n around line 390, \nwe need(453):\nexplain format = 'verbose' select * from t where b = 6 order by a limit 1;\nid\testRows\testCost\ttask\taccess object\toperator info\nLimit_11\t0.00\t98.74\troot\t\toffset:0, count:1\n└─TableReader_24\t0.00\t98.74\troot\t\tdata:Limit_23\n  └─Limit_23\t0.00\t1386.04\tcop[tikv]\t\toffset:0, count:1\n    └─Selection_22\t0.00\t1386.04\tcop[tikv]\t\teq(planner__core__casetest__integration.t.b, 6)\n      └─TableFullScan_21\t5.00\t1136.54\tcop[tikv]\ttable:t\tkeep order:true\n\nbut got(453):\nexplain format = 'verbose' select * from t where b = 6 order by a limit 1;\nid\testRows\testCost\ttask\taccess object\toperator info\nLimit_11\t1.00\t98.74\troot\t\toffset:0, count:1\n└─TableReader_24\t1.00\t98.74\troot\t\tdata:Limit_23\n  └─Limit_23\t1.00\t1386.04\tcop[tikv]\t\toffset:0, count:1\n    └─Selection_22\t1.00\t1386.04\tcop[tikv]\t\teq(planner__core__casetest__integration.t.b, 6)\n      └─TableFullScan_21\t5.00\t1136.54\tcop[tikv]\ttable:t\tkeep order:true\n\n"
time="2024-05-18T08:12:43+08:00" level=error msg="run test [planner/core/cbo] err: sql:explain analyze select t1.a, t1.b, sum(t1.c) from t1 join t2 on t1.a = t2.b where t1.a > 1;: failed to run query \n\"explain analyze select t1.a, t1.b, sum(t1.c) from t1 join t2 on t1.a = t2.b where t1.a > 1;\" \n around line 63, \nwe need(1817):\nexplain analyze select t1.a, t1.b, sum(t1.c) from t1 join t2 on t1.a = t2.b where t1.a > 1;\nid\testRows\tactRows\ttask\taccess object\texecution info\toperator info\tmemory\tdisk\nProjection_9\t1.00\t1\troot\tNULL\ttime:<num>, loops:<num>, RU:<num>, Concurrency:OFF\tplanner__core__cbo.t1.a, planner__core__cbo.t1.b, Column#8\t<num>\tN/A\n└─StreamAgg_11\t1.00\t1\troot\tNULL\ttime:<num>, loops:<num>\tfuncs:sum(Column#16)->Column#8, funcs:firstrow(Column#17)->planner__core__cbo.t1.a, funcs:firstrow(Column#18)->planner__core__cbo.t1.b\t<num>\tN/A\n  └─Projection_53\t4.00\t3\troot\tNULL\ttime:<num>, loops:<num>, Concurrency:OFF\tcast(planner__core__cbo.t1.c, decimal(10,0) BINARY)->Column#16, planner__core__cbo.t1.a->Column#17, planner__core__cbo.t1.b->Column#18\t<num>\tN/A\n    └─HashJoin_51\t4.00\t3\troot\tNULL\ttime:<num>, loops:<num>, build_hash_table:{total:<num>, fetch:<num>, build:<num>}, probe:{concurrency:<num>, total:<num>, max:<num>, probe:<num>, fetch and wait:<num>}\tinner join, equal:[eq(planner__core__cbo.t1.a, planner__core__cbo.t2.b)]\t<num>\t<num>\n      ├─TableReader_30(Build)\t6.00\t6\troot\tNULL\ttime.*loops.*cop_task.*\tdata:Selection_29\t<num>\tN/A\n      │ └─Selection_29\t6.00\t6\tcop[tikv]\tNULL\ttikv_task:{time:<num>, loops:<num>}\tgt(planner__core__cbo.t2.b, 1), not(isnull(planner__core__cbo.t2.b))\tN/A\tN/A\n      │   └─TableFullScan_28\t6.00\t6\tcop[tikv]\ttable:t2\ttikv_task:{time:<num>, loops:<num>}\tkeep order:false\tN/A\tN/A\n      └─TableReader_33(Probe)\t4.00\t4\troot\tNULL\ttime.*loops.*cop_task.*\tdata:Selection_32\t<num>\tN/A\n        └─Selection_32\t4.00\t4\tcop[tikv]\tNULL\ttikv_task:{time:<num>, loops:<num>}\tgt(planner__core__cbo.t1.a, 1), not(isnull(planner__core__cbo.t1.a))\tN/A\tN/A\n          └─TableFullScan_31\t5.00\t5\tcop[tikv]\ttable:t1\ttikv_task:{time:<num>, loops:<num>}\tkeep order:false\tN/A\tN/A\n\nbut got(1817):\nexplain analyze select t1.a, t1.b, sum(t1.c) from t1 join t2 on t1.a = t2.b where t1.a > 1;\nid\testRows\tactRows\ttask\taccess object\texecution info\toperator info\tmemory\tdisk\nProjection_9\t1.00\t1\troot\tNULL\ttime:<num>, loops:<num>, RU:<num>, Concurrency:OFF\tplanner__core__cbo.t1.a, planner__core__cbo.t1.b, Column#8\t<num>\tN/A\n└─StreamAgg_11\t1.00\t1\troot\tNULL\ttime:<num>, loops:<num>\tfuncs:sum(Column#16)->Column#8, funcs:firstrow(Column#17)->planner__core__cbo.t1.a, funcs:firstrow(Column#18)->planner__core__cbo.t1.b\t<num>\tN/A\n  └─Projection_53\t4.00\t3\troot\tNULL\ttime:<num>, loops:<num>, Concurrency:OFF\tcast(planner__core__cbo.t1.c, decimal(10,0) BINARY)->Column#16, planner__core__cbo.t1.a->Column#17, planner__core__cbo.t1.b->Column#18\t<num>\tN/A\n    └─HashJoin_51\t4.00\t3\troot\tNULL\ttime:<num>, loops:<num>, build_hash_table:{total:<num>, fetch:<num>, build:<num>}, probe:{concurrency:<num>, total:<num>, max:<num>, probe:<num>, fetch and wait:<num>}\tinner join, equal:[eq(planner__core__cbo.t1.a, planner__core__cbo.t2.b)]\t<num>\t<num>\n      ├─TableReader_30(Build)\t5.00\t6\troot\tNULL\ttime.*loops.*cop_task.*\tdata:Selection_29\t<num>\tN/A\n      │ └─Selection_29\t5.00\t6\tcop[tikv]\tNULL\ttikv_task:{time:<num>, loops:<num>}\tgt(planner__core__cbo.t2.b, 1), not(isnull(planner__core__cbo.t2.b))\tN/A\tN/A\n      │   └─TableFullScan_28\t6.00\t6\tcop[tikv]\ttable:t2\ttikv_task:{time:<num>, loops:<num>}\tkeep order:false\tN/A\tN/A\n      └─TableReader_33(Probe)\t4.00\t4\troot\tNULL\ttime.*loops.*cop_task.*\tdata:Selection_32\t<num>\tN/A\n        └─Selection_32\t4.00\t4\tcop[tikv]\tNULL\ttikv_task:{time:<num>, loops:<num>}\tgt(planner__core__cbo.t1.a, 1), not(isnull(planner__core__cbo.t1.a))\tN/A\tN/A\n          └─TableFullScan_31\t5.00\t5\tcop[tikv]\ttable:t1\ttikv_task:{time:<num>, loops:<num>}\tkeep order:false\tN/A\tN/A\n\n"
time="2024-05-18T08:12:43+08:00" level=error msg="run test [planner/core/partition_pruner] err: sql:explain format='brief' select * from t where a in (1,2) and b in (3,4);: failed to run query \n\"explain format='brief' select * from t where a in (1,2) and b in (3,4);\" \n around line 907, \nwe need(325):\nexplain format='brief' select * from t where a in (1,2) and b in (3,4);\nid\testRows\ttask\taccess object\toperator info\nTableReader\t2.57\troot\tpartition:pDef\tdata:Selection\n└─Selection\t2.57\tcop[tikv]\t\tin(listdefaultprune.t.a, 1, 2), in(listdefaultprune.t.b, 3, 4)\n  └─TableFullScan\t7.00\tcop[tikv]\ttable:t\tkeep order:false\n\nbut got(325):\nexplain format='brief' select * from t where a in (1,2) and b in (3,4);\nid\testRows\ttask\taccess object\toperator info\nTableReader\t1.27\troot\tpartition:pDef\tdata:Selection\n└─Selection\t1.27\tcop[tikv]\t\tin(listdefaultprune.t.a, 1, 2), in(listdefaultprune.t.b, 3, 4)\n  └─TableFullScan\t7.00\tcop[tikv]\ttable:t\tkeep order:false\n\n"
time="2024-05-18T08:12:43+08:00" level=error msg="run test [util/ranger] err: sql:explain format='brief' select * from t where a > 0;: failed to run query \n\"explain format='brief' select * from t where a > 0;\" \n around line 87, \nwe need(487):\nexplain format='brief' select * from t where a > 0;\nid\testRows\ttask\taccess object\toperator info\nPartitionUnion\t3.00\troot\t\t\n├─TableReader\t0.00\troot\t\tdata:Selection\n│ └─Selection\t0.00\tcop[tikv]\t\tgt(util__ranger.t.a, 0)\n│   └─TableFullScan\t1.00\tcop[tikv]\ttable:t, partition:p0\tkeep order:false\n└─TableReader\t3.00\troot\t\tdata:Selection\n  └─Selection\t3.00\tcop[tikv]\t\tgt(util__ranger.t.a, 0)\n    └─TableFullScan\t3.00\tcop[tikv]\ttable:t, partition:p1\tkeep order:false\n\nbut got(487):\nexplain format='brief' select * from t where a > 0;\nid\testRows\ttask\taccess object\toperator info\nPartitionUnion\t0.00\troot\t\t\n├─TableReader\t0.00\troot\t\tdata:Selection\n│ └─Selection\t0.00\tcop[tikv]\t\tgt(util__ranger.t.a, 0)\n│   └─TableFullScan\t1.00\tcop[tikv]\ttable:t, partition:p0\tkeep order:false\n└─TableReader\t0.00\troot\t\tdata:Selection\n  └─Selection\t0.00\tcop[tikv]\t\tgt(util__ranger.t.a, 0)\n    └─TableFullScan\t3.00\tcop[tikv]\ttable:t, partition:p1\tkeep order:false\n\n"
make: *** [integrationtest] Error 1
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] dir
Running in /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check/tidb
[Pipeline] {
[Pipeline] sh
+ logs_dir=test_logs
+ mkdir -p test_logs
+ mv tests/integrationtest/integration-test.out test_logs
+ tar -czvf test_logs.tar.gz test_logs
test_logs/
test_logs/integration-test.out
[Pipeline] archiveArtifacts
Archiving artifacts
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
[Pipeline] // withCredentials
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Declarative: Post Actions)
[Pipeline] container
[Pipeline] {
[Pipeline] sh
+ bash scripts/plugins/report_job_result.sh FAILURE result.json
http://fileserver.pingcap.net
--2024-05-18 00:12:46--  http://fileserver.pingcap.net/download/rd-atom-agent/agent_upload_verifyci_metadata.py
Resolving fileserver.pingcap.net (fileserver.pingcap.net)... 10.2.12.82
Connecting to fileserver.pingcap.net (fileserver.pingcap.net)|10.2.12.82|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 4181 (4.1K) [application/octet-stream]
Saving to: ‘agent_upload_verifyci_metadata.py’

     0K ....                                                  100%  269M=0s

2024-05-18 00:12:46 (269 MB/s) - ‘agent_upload_verifyci_metadata.py’ saved [4181/4181]

No junit report file
parse result file result.json success
upload data succesfully.
[Pipeline] }
[Pipeline] // container
[Pipeline] archiveArtifacts
Archiving artifacts
Recording fingerprints
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] End of Pipeline
ERROR: script returned exit code 2
Finished: FAILURE