![[Jenkins]](/jenkins/static/62b7ca6c/images/svgs/logo.svg){kind=logo}
Started by user Jenkins Admin Obtained pipelines/pingcap/tidb/latest/ghpr_check.groovy from git https://github.com/PingCAP-QE/ci.git Loading library tipipeline@main Library tipipeline@main is cached. Copying from home. [Pipeline] Start of Pipeline [Pipeline] readJSON [Pipeline] readTrusted Obtained pipelines/pingcap/tidb/latest/pod-ghpr_check.yaml from git https://github.com/PingCAP-QE/ci.git [Pipeline] podTemplate [Pipeline] { [Pipeline] node Created Pod: kubernetes jenkins-tidb/pingcap-tidb-ghpr-check-9378-bg5dx-t9ccz-r1vr5 Agent pingcap-tidb-ghpr-check-9378-bg5dx-t9ccz-r1vr5 is provisioned from template pingcap_tidb_ghpr_check_9378-bg5dx-t9ccz --- apiVersion: "v1" kind: "Pod" metadata: annotations: buildUrl: "http://jenkins.apps.svc.cluster.local:8080/jenkins/job/pingcap/job/tidb/job/ghpr_check/9378/" runUrl: "job/pingcap/job/tidb/job/ghpr_check/9378/" labels: jenkins/jenkins-jenkins-agent: "true" jenkins/label-digest: "2cdd9cb76341dd3997dbe37446103bca3aaa57f1" jenkins/label: "pingcap_tidb_ghpr_check_9378-bg5dx" name: "pingcap-tidb-ghpr-check-9378-bg5dx-t9ccz-r1vr5" namespace: "jenkins-tidb" spec: affinity: nodeAffinity: requiredDuringSchedulingIgnoredDuringExecution: nodeSelectorTerms: - matchExpressions: - key: "kubernetes.io/arch" operator: "In" values: - "amd64" containers: - image: "hub.pingcap.net/wangweizhen/tidb_image:go12120230809" lifecycle: postStart: exec: command: - "/bin/sh" - "/data/bazel-prepare-in-container.sh" name: "golang" resources: limits: memory: "32Gi" cpu: "8" requests: memory: "8Gi" cpu: "8" securityContext: privileged: true tty: true volumeMounts: - mountPath: "/home/jenkins/.tidb/tmp" name: "bazel-out-merged" - mountPath: "/bazel-out-lower" name: "bazel-out-lower" subPath: "tidb/go1.19.2" - mountPath: "/bazel-out-overlay" name: "bazel-out-overlay" - mountPath: "/share/.cache/go-build" name: "gocache" - mountPath: "/share/.go" name: "gopathcache" - mountPath: "/data/" name: "bazel-rc" readOnly: true - mountPath: "/etc/containerinfo" name: "containerinfo" - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false - image: "hub.pingcap.net/jenkins/network-multitool" name: "net-tool" resources: limits: memory: "128Mi" cpu: "100m" tty: true volumeMounts: - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false - image: "hub.pingcap.net/jenkins/python3-requests:latest" name: "report" resources: limits: memory: "256Mi" cpu: "100m" tty: true volumeMounts: - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false - env: - name: "JENKINS_SECRET" value: "********" - name: "JENKINS_TUNNEL" value: "jenkins-agent.apps.svc.cluster.local:50000" - name: "JENKINS_AGENT_NAME" value: "pingcap-tidb-ghpr-check-9378-bg5dx-t9ccz-r1vr5" - name: "JENKINS_NAME" value: "pingcap-tidb-ghpr-check-9378-bg5dx-t9ccz-r1vr5" - name: "JENKINS_AGENT_WORKDIR" value: "/home/jenkins/agent" - name: "JENKINS_URL" value: "http://jenkins.apps.svc.cluster.local:8080/jenkins/" image: "jenkins/inbound-agent:3206.vb_15dcf73f6a_9-2" name: "jnlp" resources: requests: memory: "256Mi" cpu: "100m" volumeMounts: - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false restartPolicy: "Never" securityContext: fsGroup: 1000 volumes: - emptyDir: {} name: "bazel-out-merged" - name: "bazel-rc" secret: secretName: "bazel" - emptyDir: {} name: "bazel-out-overlay" - name: "gocache" persistentVolumeClaim: claimName: "gocache" - downwardAPI: items: - path: "cpu_limit" resourceFieldRef: containerName: "golang" resource: "limits.cpu" - path: "cpu_request" resourceFieldRef: containerName: "golang" resource: "requests.cpu" - path: "mem_limit" resourceFieldRef: containerName: "golang" resource: "limits.memory" - path: "mem_request" resourceFieldRef: containerName: "golang" resource: "requests.memory" name: "containerinfo" - name: "bazel-out-lower" persistentVolumeClaim: claimName: "bazel-out-data" - emptyDir: medium: "" name: "workspace-volume" - name: "gopathcache" persistentVolumeClaim: claimName: "gopathcache" Running on pingcap-tidb-ghpr-check-9378-bg5dx-t9ccz-r1vr5 in /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check [Pipeline] { [Pipeline] stage [Pipeline] { (Declarative: Checkout SCM) [Pipeline] checkout The recommended git tool is: git No credentials specified Cloning the remote Git repository Using shallow clone with depth 1 Cloning repository https://github.com/PingCAP-QE/ci.git > git init /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check # timeout=10 Fetching upstream changes from https://github.com/PingCAP-QE/ci.git > git --version # timeout=10 > git --version # 'git version 2.39.2' > git fetch --tags --force --progress --depth=1 -- https://github.com/PingCAP-QE/ci.git +refs/heads/*:refs/remotes/origin/* # timeout=5 Avoid second fetch Checking out Revision 73d1a8209bddec16d8d58403efcd7a20d12cf867 (origin/main) Commit message: "update utf go build image (#2965)" > git config remote.origin.url https://github.com/PingCAP-QE/ci.git # timeout=10 > git config --add remote.origin.fetch +refs/heads/*:refs/remotes/origin/* # timeout=10 > git rev-parse origin/main^{commit} # timeout=10 > git config core.sparsecheckout # timeout=10 > git checkout -f 73d1a8209bddec16d8d58403efcd7a20d12cf867 # timeout=10 > git rev-list --no-walk 73d1a8209bddec16d8d58403efcd7a20d12cf867 # timeout=10 [Pipeline] } [Pipeline] // stage [Pipeline] withEnv [Pipeline] { [Pipeline] container [Pipeline] { [Pipeline] timeout Timeout set to expire in 30 min [Pipeline] { [Pipeline] stage [Pipeline] { (Debug info) [Pipeline] sh + printenv PROW_JOB_ID=6fcab870-b3d3-460b-84b7-ab6fb0dff406 JENKINS_NODE_COOKIE=1585f1dc-8a81-45e4-a70e-b50e4fea6e2b BUILD_URL=https://do.pingcap.net/jenkins/job/pingcap/job/tidb/job/ghpr_check/9378/ GOLANG_VERSION=1.21.0 HOSTNAME=pingcap-tidb-ghpr-check-9378-bg5dx-t9ccz-r1vr5 HUDSON_SERVER_COOKIE=83ef27fe9acccc92 KUBERNETES_PORT=tcp://10.233.0.1:443 KUBERNETES_PORT_443_TCP_PORT=443 TERM=xterm STAGE_NAME=Debug info BUILD_TAG=jenkins-pingcap-tidb-ghpr_check-9378 KUBERNETES_SERVICE_PORT=443 GIT_PREVIOUS_COMMIT=73d1a8209bddec16d8d58403efcd7a20d12cf867 JOB_SPEC={"type":"presubmit","job":"pingcap/tidb/ghpr_check","buildid":"1791830381322833921","prowjobid":"6fcab870-b3d3-460b-84b7-ab6fb0dff406","refs":{"org":"pingcap","repo":"tidb","repo_link":"https://github.com/pingcap/tidb","base_ref":"master","base_sha":"f5ac93e448a03665274272929b512ce66f05d67b","base_link":"https://github.com/pingcap/tidb/commit/f5ac93e448a03665274272929b512ce66f05d67b","pulls":[{"number":53035,"author":"terry1purcell","sha":"adece32794661b32a231f281d0355a15b631b6dd","title":"planner: reduce topn count to exclude non-skewed values","link":"https://github.com/pingcap/tidb/pull/53035","commit_link":"https://github.com/pingcap/tidb/pull/53035/commits/adece32794661b32a231f281d0355a15b631b6dd","author_link":"https://github.com/terry1purcell"}]}} KUBERNETES_SERVICE_HOST=10.233.0.1 WORKSPACE=/home/jenkins/agent/workspace/pingcap/tidb/ghpr_check JOB_URL=https://do.pingcap.net/jenkins/job/pingcap/job/tidb/job/ghpr_check/ RUN_CHANGES_DISPLAY_URL=https://do.pingcap.net/jenkins/job/pingcap/job/tidb/job/ghpr_check/9378/display/redirect?page=changes RUN_ARTIFACTS_DISPLAY_URL=https://do.pingcap.net/jenkins/job/pingcap/job/tidb/job/ghpr_check/9378/display/redirect?page=artifacts 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/9378/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=#9378 JENKINS_URL=https://do.pingcap.net/jenkins/ BUILD_ID=1791830381322833921 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/9378/display/redirect?page=tests SHLVL=3 HOME=/home/jenkins POD_LABEL=pingcap_tidb_ghpr_check_9378-bg5dx 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_9378-bg5dx pingcap-tidb-ghpr-check-9378-bg5dx-t9ccz-r1vr5 GIT_URL=https://github.com/PingCAP-QE/ci.git HUDSON_HOME=/var/jenkins_home CLASSPATH= NODE_NAME=pingcap-tidb-ghpr-check-9378-bg5dx-t9ccz-r1vr5 GOPATH=/go JOB_DISPLAY_URL=https://do.pingcap.net/jenkins/job/pingcap/job/tidb/job/ghpr_check/display/redirect BUILD_NUMBER=9378 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-build4258803361=/tmp/go-build -gno-record-gcc-switches' + echo ------------------------- ------------------------- + ls -l /dev/null crw-rw-rw-. 1 root root 1, 3 May 18 21:57 /dev/null + echo 'debug command: kubectl -n jenkins-tidb exec -ti pingcap-tidb-ghpr-check-9378-bg5dx-t9ccz-r1vr5 bash' debug command: kubectl -n jenkins-tidb exec -ti pingcap-tidb-ghpr-check-9378-bg5dx-t9ccz-r1vr5 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: 21481 ;; flags: qr aa rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 1 ;; OPT PSEUDOSECTION: ; EDNS: version: 0, flags:; udp: 1232 ; COOKIE: bde8f81c8909a8b0 (echoed) ;; QUESTION SECTION: ;github.com. IN A ;; ANSWER SECTION: github.com. 22 IN A 20.205.243.166 ;; Query time: 0 msec ;; SERVER: 169.254.25.10#53(169.254.25.10) (UDP) ;; WHEN: Sat May 18 13:57:41 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 1.67 secs (323357527 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..adece32794 Fast-forward pkg/statistics/builder.go | 14 +++++++++----- pkg/statistics/statistics_test.go | 6 +++--- pkg/statistics/testdata/integration_suite_out.json | 8 ++++---- 3 files changed, 16 insertions(+), 12 deletions(-) 🧾 Pre-merged result: adece32794661b32a231f281d0355a15b631b6dd adece32794 testcase4 98aca2c454 testcase3 59ace07e2c testcase2 ✅ Pre merged 🎉 📁 update submodules ... ✅ update submodules done ✅ ~~~~~All done.~~~~~~ [Pipeline] } [Pipeline] // retry [Pipeline] } [Pipeline] // script [Pipeline] } Cache saved successfully (git/pingcap/tidb/rev-f5ac93e-adece32) 540356608 bytes in 17.13 secs (31546898 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/aws/aws-sdk-go v1.50.0 go: downloading github.com/opentracing/opentracing-go v1.2.0 go: downloading github.com/pingcap/log v1.1.1-0.20240314023424-862ccc32f18d go: downloading go.uber.org/mock v0.4.0 go: downloading github.com/Masterminds/semver v1.5.0 go: downloading github.com/pingcap/errors v0.11.5-0.20240318064555-6bd07397691f go: downloading github.com/pingcap/kvproto v0.0.0-20240227073058-929ab83f9754 go: downloading github.com/tikv/client-go/v2 v2.0.8-0.20240516031922-38e0dca30c8c go: downloading github.com/sourcegraph/appdash v0.0.0-20190731080439-ebfcffb1b5c0 go: downloading go.uber.org/zap v1.27.0 go: downloading go.uber.org/multierr v1.11.0 go: downloading github.com/spf13/pflag v1.0.5 go: downloading github.com/emirpasic/gods v1.18.1 go: downloading github.com/cheynewallace/tabby v1.1.1 go: downloading cloud.google.com/go/storage v1.36.0 go: downloading github.com/fatih/color v1.16.0 go: downloading github.com/docker/go-units v0.5.0 go: downloading github.com/google/uuid v1.6.0 go: downloading github.com/tikv/pd/client v0.0.0-20240430080403-1679dbca25b3 go: downloading github.com/pingcap/failpoint v0.0.0-20220801062533-2eaa32854a6c go: downloading github.com/go-sql-driver/mysql v1.7.1 go: downloading github.com/google/btree v1.1.2 go: downloading github.com/cheggaaa/pb/v3 v3.0.8 go: downloading github.com/gogo/protobuf v1.3.2 go: downloading github.com/Azure/azure-sdk-for-go/sdk/azcore v1.9.1 go: downloading github.com/Azure/azure-sdk-for-go/sdk/azidentity v1.5.1 go: downloading github.com/Azure/azure-sdk-for-go/sdk/storage/azblob v1.0.0 go: downloading github.com/coreos/go-semver v0.3.1 go: downloading google.golang.org/grpc v1.63.2 go: downloading github.com/vbauerster/mpb/v7 v7.5.3 go: downloading golang.org/x/sync v0.7.0 go: downloading github.com/golang/protobuf v1.5.4 go: downloading golang.org/x/term v0.20.0 go: downloading k8s.io/api v0.28.6 go: downloading github.com/pingcap/tipb v0.0.0-20240318032315-55a7867ddd50 go: downloading github.com/klauspost/compress v1.17.7 go: downloading github.com/aliyun/alibaba-cloud-sdk-go v1.61.1581 go: downloading go.etcd.io/etcd/client/v3 v3.5.12 go: downloading github.com/pkg/errors v0.9.1 go: downloading github.com/prometheus/client_golang v1.19.0 go: downloading github.com/BurntSushi/toml v1.3.2 go: downloading go.opencensus.io v0.24.0 go: downloading go.uber.org/atomic v1.11.0 go: downloading github.com/coocood/freecache v1.2.1 go: downloading github.com/spf13/cobra v1.8.0 go: downloading github.com/ngaut/pools v0.0.0-20180318154953-b7bc8c42aac7 go: downloading golang.org/x/exp v0.0.0-20240404231335-c0f41cb1a7a0 go: downloading go.etcd.io/etcd/client/pkg/v3 v3.5.12 go: downloading github.com/uber/jaeger-client-go v2.22.1+incompatible go: downloading github.com/go-resty/resty/v2 v2.11.0 go: downloading cloud.google.com/go v0.112.0 go: downloading github.com/ks3sdklib/aws-sdk-go v1.2.9 go: downloading golang.org/x/net v0.25.0 go: downloading golang.org/x/oauth2 v0.20.0 go: downloading google.golang.org/api v0.162.0 go: downloading github.com/tiancaiamao/gp v0.0.0-20221230034425-4025bc8a4d4a go: downloading github.com/stretchr/testify v1.9.0 go: downloading go.etcd.io/etcd/api/v3 v3.5.12 go: downloading github.com/twmb/murmur3 v1.1.6 go: downloading github.com/opentracing/basictracer-go v1.0.0 go: downloading github.com/pingcap/sysutil v1.0.1-0.20240311050922-ae81ee01f3a5 go: downloading github.com/prometheus/common v0.53.0 go: downloading golang.org/x/text v0.15.0 go: downloading github.com/blacktear23/go-proxyprotocol v1.0.6 go: downloading github.com/gorilla/mux v1.8.0 go: downloading github.com/pingcap/fn v1.0.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/grpc-ecosystem/go-grpc-middleware v1.4.0 go: downloading github.com/otiai10/copy v1.2.0 go: downloading golang.org/x/sys v0.20.0 go: downloading github.com/shirou/gopsutil/v3 v3.24.4 go: downloading github.com/mattn/go-colorable v0.1.13 go: downloading github.com/mattn/go-isatty v0.0.20 go: downloading gopkg.in/natefinch/lumberjack.v2 v2.2.1 go: downloading github.com/VividCortex/ewma v1.2.0 go: downloading github.com/mattn/go-runewidth v0.0.15 go: downloading github.com/tidwall/btree v1.7.0 go: downloading github.com/prometheus/client_model v0.6.1 go: downloading github.com/cznic/mathutil v0.0.0-20181122101859-297441e03548 go: downloading github.com/cockroachdb/pebble v1.1.0 go: downloading github.com/acarl005/stripansi v0.0.0-20180116102854-5a71ef0e047d go: downloading github.com/carlmjohnson/flagext v0.21.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/cespare/xxhash/v2 v2.3.0 go: downloading github.com/ngaut/sync2 v0.0.0-20141008032647-7a24ed77b2ef go: downloading google.golang.org/protobuf v1.33.0 go: downloading github.com/apache/skywalking-eyes v0.4.0 go: downloading github.com/jellydator/ttlcache/v3 v3.0.1 go: downloading github.com/mgechev/revive v1.3.7 go: downloading golang.org/x/tools v0.21.0 go: downloading gopkg.in/yaml.v2 v2.4.0 go: downloading github.com/tdakkota/asciicheck v0.2.0 go: downloading github.com/timakin/bodyclose v0.0.0-20240125160201-f835fa56326a go: downloading github.com/fatih/structtag v1.2.0 go: downloading github.com/charithe/durationcheck v0.0.10 go: downloading github.com/kisielk/errcheck v1.7.0 go: downloading github.com/kyoh86/exportloopref v0.1.11 go: downloading github.com/beorn7/perks v1.0.1 go: downloading github.com/prometheus/procfs v0.13.0 go: downloading github.com/gostaticanalysis/forcetypeassert v0.1.0 go: downloading github.com/daixiang0/gci v0.13.4 go: downloading github.com/danjacques/gofslock v0.0.0-20191023191349-0a45f885bc37 go: downloading github.com/golangci/gofmt v0.0.0-20231019111953-be8c47862aaa 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/gordonklaus/ineffassign v0.1.0 go: downloading github.com/butuzov/mirror v1.2.0 go: downloading github.com/golangci/misspell v0.5.1 go: downloading github.com/ashanbrown/makezero v1.1.1 go: downloading github.com/golangci/prealloc v0.0.0-20180630174525-215b22d4de21 go: downloading github.com/fatanugraha/noloopclosure v0.1.1 go: downloading github.com/jingyugao/rowserrcheck v1.1.1 go: downloading github.com/nishanths/predeclared v0.2.2 go: downloading honnef.co/go/tools v0.4.7 go: downloading github.com/bazelbuild/rules_go v0.42.1-0.20231101215950-df20c987afcb go: downloading github.com/influxdata/tdigest v0.0.1 go: downloading github.com/google/skylark v0.0.0-20181101142754-a5f7082aabed go: downloading golang.org/x/time v0.5.0 go: downloading github.com/lestrrat-go/jwx/v2 v2.0.21 go: downloading github.com/phayes/freeport v0.0.0-20180830031419-95f893ade6f2 go: downloading go.uber.org/automaxprocs v1.5.3 go: downloading github.com/shurcooL/httpgzip v0.0.0-20190720172056-320755c1c1b0 go: downloading github.com/jedib0t/go-pretty/v6 v6.2.2 go: downloading github.com/dgryski/go-farm v0.0.0-20200201041132-a6ae2369ad13 go: downloading github.com/cloudfoundry/gosigar v1.3.6 go: downloading github.com/jfcg/sorty/v2 v2.1.0 go: downloading github.com/dolthub/swiss v0.2.1 go: downloading github.com/dgraph-io/ristretto v0.1.1 go: downloading github.com/joho/sqltocsv v0.0.0-20210428211105-a6d6801d59df go: downloading github.com/spkg/bom v1.0.0 go: downloading github.com/sasha-s/go-deadlock v0.3.1 go: downloading github.com/xitongsys/parquet-go v1.5.5-0.20201110004701-b09c49d6d457 go: downloading github.com/YangKeao/ldap/v3 v3.4.5-0.20230421065457-369a3bab1117 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 github.com/cockroachdb/errors v1.11.1 go: downloading github.com/google/pprof v0.0.0-20240117000934-35fc243c5815 go: downloading github.com/golang/snappy v0.0.4 go: downloading github.com/wangjohn/quickselect v0.0.0-20161129230411-ed8402a42d5f go: downloading github.com/json-iterator/go v1.1.12 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/compute/metadata v0.3.0 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/uber/jaeger-lib v2.4.1+incompatible go: downloading github.com/rivo/uniseg v0.4.6 go: downloading github.com/shurcooL/vfsgen v0.0.0-20181202132449-6a9ea43bcacd go: downloading github.com/remyoudompheng/bigfft v0.0.0-20230129092748-24d4a6f8daec 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/kylelemons/godebug v1.1.0 go: downloading github.com/pkg/browser v0.0.0-20240102092130-5ac0b6a4141c go: downloading github.com/gostaticanalysis/analysisutil v0.7.1 go: downloading gopkg.in/yaml.v3 v3.0.1 go: downloading github.com/hexops/gotextdiff v1.0.3 go: downloading github.com/pingcap/goleveldb v0.0.0-20191226122134-f82aafb29989 go: downloading google.golang.org/genproto/googleapis/rpc v0.0.0-20240401170217-c3f982113cda go: downloading github.com/nbutton23/zxcvbn-go v0.0.0-20210217022336-fa2cb2858354 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 github.com/jfcg/sixb v1.3.8 go: downloading github.com/dolthub/maphash v0.1.0 go: downloading github.com/petermattis/goid v0.0.0-20231207134359-e60b3f734c67 go: downloading github.com/go-asn1-ber/asn1-ber v1.5.4 go: downloading github.com/Azure/go-ntlmssp v0.0.0-20221128193559-754e69321358 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/apache/thrift v0.16.0 go: downloading github.com/tklauser/go-sysconf v0.3.12 go: downloading go.opentelemetry.io/otel v1.22.0 go: downloading go.opentelemetry.io/otel/trace v1.22.0 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/shurcooL/httpfs v0.0.0-20230704072500-f1e31cf0ba5c 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/golang-jwt/jwt/v5 v5.2.0 go: downloading github.com/eapache/go-resiliency v1.2.0 go: downloading github.com/eapache/go-xerial-snappy v0.0.0-20180814174437-776d5712da21 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/chavacava/garif v0.1.0 go: downloading github.com/olekukonko/tablewriter v0.0.5 go: downloading github.com/gostaticanalysis/comment v1.4.2 go: downloading golang.org/x/mod v0.17.0 go: downloading k8s.io/apimachinery v0.28.6 go: downloading github.com/sirupsen/logrus v1.9.3 go: downloading github.com/Masterminds/sprig/v3 v3.2.2 go: downloading golang.org/x/exp/typeparams v0.0.0-20240314144324-c7f7c6466f7f go: downloading github.com/bmatcuk/doublestar/v2 v2.0.4 go: downloading github.com/golang/groupcache v0.0.0-20210331224755-41bb18bfe9da go: downloading github.com/lestrrat-go/httpcc v1.0.1 go: downloading github.com/dustin/go-humanize v1.0.1 go: downloading github.com/golang/glog v1.2.0 go: downloading github.com/kr/pretty v0.3.1 go: downloading github.com/tklauser/numcpus v0.6.1 go: downloading github.com/DataDog/zstd v1.5.5 go: downloading github.com/cockroachdb/tokenbucket v0.0.0-20230807174530-cc333fc44b06 go: downloading github.com/jcmturner/dnsutils/v2 v2.0.0 go: downloading github.com/hashicorp/go-uuid v1.0.2 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/google/licensecheck v0.3.1 go: downloading github.com/kr/text v0.2.0 go: downloading github.com/rogpeppe/go-internal v1.12.0 go: downloading github.com/jcmturner/rpc/v2 v2.0.3 go: downloading github.com/klauspost/cpuid v1.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/shopspring/decimal v1.2.0 go: downloading github.com/spf13/cast v1.5.0 go: downloading github.com/jcmturner/aescts/v2 v2.0.0 go: downloading github.com/mitchellh/reflectwalk v1.0.1 go: downloading go.opentelemetry.io/otel/metric v1.22.0 go: downloading github.com/go-logr/logr v1.4.1 go: downloading github.com/go-logr/stdr v1.2.2 go: downloading gopkg.in/inf.v0 v0.9.1 go: downloading github.com/google/gofuzz v1.2.0 go: downloading k8s.io/klog/v2 v2.120.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/googleapis/enterprise-certificate-proxy v0.3.2 go: downloading go.opentelemetry.io/contrib/instrumentation/google.golang.org/grpc/otelgrpc v0.47.0 go: downloading github.com/google/s2a-go v0.1.7 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: 5b25b407-c385-43ac-a490-4174c34bcc89 [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_18_13_57_31.2143558881/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 [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 (41 packages loaded, 388 targets configured) [32mAnalyzing:[0m target //:gazelle (44 packages loaded, 410 targets configured) [32mAnalyzing:[0m target //:gazelle (67 packages loaded, 651 targets configured) [32mAnalyzing:[0m target //:gazelle (88 packages loaded, 8101 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 (169 packages loaded, 11095 targets configured) [32mAnalyzing:[0m target //:gazelle (257 packages loaded, 11768 targets configured) [32mINFO: [0mAnalyzed target //:gazelle (268 packages loaded, 11967 targets configured). [32mINFO: [0mFound 1 target... [32m[0 / 10][0m [Prepa] BazelWorkspaceStatusAction stable-status.txt ... ( 1 action running) [32m[24 / 317][0m [Prepa] GoStdlib external/io_bazel_rules_go/stdlib_/pkg [for tool] ... (3 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/compile, 4.9 MiB / 17.2 MiB; 1s remote-cache ... (3 actions, 0 running) [32m[113 / 317][0m GoCompilePkg external/org_golang_x_mod/modfile/modfile.a [for tool]; Downloading external/org_golang_x_mod/modfile/modfile.a, 267.1 KiB / 918.8 KiB; 0s remote-cache ... (8 actions, 0 running) Target //:gazelle up-to-date: bazel-bin/gazelle-runner.bash bazel-bin/gazelle [32mINFO: [0mElapsed time: 33.080s, Critical Path: 3.57s [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: 8ab25808-b21e-46f7-82a5-c80b8cf176bb [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_18_13_57_31.2143558881/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.252s, Critical Path: 0.00s [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: ff7cb1e0-1f84-41ac-bd73-68ae85ef35f8 [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_18_13_57_31.2143558881/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 (115 packages loaded, 949 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 (199 packages loaded, 1292 targets configured) [32mAnalyzing:[0m target //cmd/mirror:mirror (372 packages loaded, 1943 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[1 / 15][0m [Prepa] BazelWorkspaceStatusAction stable-status.txt [32m[267 / 511][0m GoStdlib external/io_bazel_rules_go/stdlib_/pkg; 0s remote-cache [32m[510 / 511][0m GoLink cmd/mirror/mirror_/mirror; Downloading cmd/mirror/mirror_/mirror, 9.0 MiB / 13.7 MiB; 0s remote-cache Target //cmd/mirror:mirror up-to-date: bazel-bin/cmd/mirror/mirror_/mirror [32mINFO: [0mElapsed time: 11.290s, Critical Path: 1.93s [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: 01d42ca9-ca12-4a15-ace8-39eca2831461 [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_18_13_57_31.2143558881/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 (96 packages loaded, 10288 targets configured) [32mAnalyzing:[0m target //tools/tazel:tazel (211 packages loaded, 11824 targets configured) [32mAnalyzing:[0m target //tools/tazel:tazel (371 packages loaded, 12913 targets configured) [32mINFO: [0mAnalyzed target //tools/tazel:tazel (561 packages loaded, 14300 targets configured). [32mINFO: [0mFound 1 target... [32m[0 / 19][0m [Prepa] BazelWorkspaceStatusAction stable-status.txt ... (2 actions, 0 running) [32m[573 / 608][0m GoCompilePkg external/com_github_pingcap_kvproto/pkg/debugpb/debugpb.a; Downloading external/com_github_pingcap_kvproto/pkg/debugpb/debugpb.a, 570.5 KiB / 3.2 MiB; 0s remote-cache ... (3 actions, 0 running) Target //tools/tazel:tazel up-to-date: bazel-bin/tools/tazel/tazel_/tazel [32mINFO: [0mElapsed time: 6.800s, Critical Path: 1.21s [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/fatih/color v1.13.0 go: downloading github.com/BurntSushi/toml v1.1.0 go: downloading github.com/chavacava/garif v0.0.0-20220316182200-5cad0b5181d4 go: downloading github.com/mattn/go-runewidth v0.0.9 go: downloading github.com/mattn/go-isatty v0.0.14 go: downloading github.com/mattn/go-colorable v0.1.9 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: Duplicated error code: variable:1681 Duplicated error code: types:1292 Non-normalized error: insert statement not found Duplicated error code: variable:1298 Non-normalized error: scan break error Non-normalized error: retryable: lock not found Non-normalized error: retryable: already rollback Non-normalized error: retryable: replaced by another transaction Non-normalized error: can not add because sorted Duplicated error code: expression:1235 Non-normalized error: other table can be accessed after locked table dropped Duplicated error code: executor:1317 Duplicated error code: planner:3126 Duplicated error code: executor:8115 Duplicated error code: executor:1295 Duplicated error code: executor:1390 Duplicated error code: executor:8116 Non-normalized error: found backoff error Non-normalized error: found backoff error but don't count Duplicated error code: schema:1049 Non-normalized error: write too slow, maybe gRPC is blocked forever 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:1273 Duplicated error code: ddl:8200 Duplicated error code: ddl:8200 Duplicated error code: ddl:8200 Duplicated error code: ddl:8242 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:1470 Duplicated error code: ddl:8200 Duplicated error code: ddl:8200 Duplicated error code: ddl:1681 Duplicated error code: ddl:8200 Non-normalized error: can't get the database's version Non-normalized error: no data found in table 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: invalid syntax Non-normalized error: SAVEPOINT is not supported when binlog is enabled Non-normalized error: Pattern not match 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 Non-normalized error: attributes should be in format 'key=value' 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: 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 Non-normalized error: watcher already started Non-normalized error: watcher already closed Duplicated error code: BR:PD:ErrPDUknownScatterResult 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: unstable subtasks Non-normalized error: task not found Non-normalized error: task already exists Non-normalized error: subtask not found 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: 13710466-032d-4b88-b4e4-d4c28f4cdfab [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_18_13_57_31.2143558881/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 / 10][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.555s, Critical Path: 0.40s [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 115189 files, valid: 2970, invalid: 0, ignored: 112219, fixed: 0 GO111MODULE=on go build -tags codes -cover -ldflags '-X "github.com/pingcap/tidb/pkg/parser/mysql.TiDBReleaseVersion=v8.2.0-alpha-196-gadece32794-dirty" -X "github.com/pingcap/tidb/pkg/util/versioninfo.TiDBBuildTS=2024-05-18 14:04:34" -X "github.com/pingcap/tidb/pkg/util/versioninfo.TiDBGitHash=adece32794661b32a231f281d0355a15b631b6dd" -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/defined2014/mysql v0.0.0-20231121061906-fcfacaa39f49 go: downloading github.com/pingcap/errors v0.11.5-0.20221009092201-b66cddb77c32 go: downloading github.com/sirupsen/logrus v1.8.1 go: downloading golang.org/x/sys v0.5.0 start tidb-server, log file: ./integration-test.out tidb-server(PID: 54689) started run all integration test cases (disabled new collation) ./t/collation_agg_func.test: ok! 74 test cases passed, take time 0.069569308 s ./t/collation_check_use_collation.test: ok! 93 test cases passed, take time 0.342251892 s ./t/collation_misc.test: ok! 66 test cases passed, take time 0.316844755 s ./t/collation_pointget.test: ok! 106 test cases passed, take time 0.349844744 s Great, All tests passed start tidb-server, log file: ./integration-test.out tidb-server(PID: 54729) started run all integration test cases (enabled new collation) ./t/show.test: ok! 3 test cases passed, take time 0.000496032 s ./t/access_path_selection.test: ok! 9 test cases passed, take time 0.013092885 s ./t/agg_predicate_pushdown.test: ok! 7 test cases passed, take time 0.014126682 s ./t/bindinfo/bind.test: ok! 223 test cases passed, take time 0.946653652 s ./t/bindinfo/session_handle.test: ok! 21 test cases passed, take time 0.041159383 s ./t/bindinfo/temptable.test: ok! 38 test cases passed, take time 0.085803994 s ./t/black_list.test: ok! 55 test cases passed, take time 0.063694472 s ./t/clustered_index.test: ok! 47 test cases passed, take time 2.506320262 s ./t/collation_agg_func.test: ok! 74 test cases passed, take time 0.072294174 s ./t/collation_check_use_collation.test: ok! 93 test cases passed, take time 0.343190075 s ./t/collation_misc.test: ok! 66 test cases passed, take time 0.310147225 s ./t/collation_pointget.test: ok! 106 test cases passed, take time 0.348544603 s ./t/common_collation.test: ok! 26 test cases passed, take time 0.085393004 s ./t/cte.test: ok! 189 test cases passed, take time 1.039625241 s ./t/db_integration.test: ok! 11 test cases passed, take time 0.034956936 s ./t/ddl/attributes_sql.test: ok! 30 test cases passed, take time 0.236030241 s ./t/ddl/bdr_mode.test: ok! 371 test cases passed, take time 3.427949445 s ./t/ddl/column.test: ok! 27 test cases passed, take time 0.159685652 s ./t/ddl/column_change.test: ok! 9 test cases passed, take time 0.040845262 s ./t/ddl/column_modify.test: ok! 164 test cases passed, take time 1.066389613 s ./t/ddl/column_type_change.test: ok! 1285 test cases passed, take time 27.949757878 s ./t/ddl/constraint.test: ok! 440 test cases passed, take time 2.659437161 s ./t/ddl/db.test: ok! 290 test cases passed, take time 3.936032166 s ./t/ddl/db_cache.test: ok! 52 test cases passed, take time 0.383134331 s ./t/ddl/db_change.test: ok! 21 test cases passed, take time 0.238838128 s ./t/ddl/db_foreign_key.test: ok! 20 test cases passed, take time 0.167015029 s ./t/ddl/db_integration.test: ok! 726 test cases passed, take time 7.402396934 s time="2024-05-18T22:07:23+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.420494602 s ./t/ddl/db_table.test: ok! 53 test cases passed, take time 0.466973099 s ./t/ddl/ddl_error.test: ok! 10 test cases passed, take time 0.05305531 s ./t/ddl/ddl_tiflash.test: ok! 14 test cases passed, take time 0.025472813 s ./t/ddl/default_as_expression.test: ok! 364 test cases passed, take time 3.017697493 s ./t/ddl/fail_db.test: ok! 12 test cases passed, take time 0.123235127 s ./t/ddl/foreign_key.test: ok! 158 test cases passed, take time 5.313997523 s ./t/ddl/global_index.test: ok! 25 test cases passed, take time 0.336030418 s ./t/ddl/index_modify.test: ok! 39 test cases passed, take time 0.515358788 s ./t/ddl/integration.test: ok! 87 test cases passed, take time 0.711979469 s ./t/ddl/modify_column.test: ok! 672 test cases passed, take time 12.366859295 s ./t/ddl/multi_schema_change.test: ok! 298 test cases passed, take time 5.670562878 s ./t/ddl/partition.test: ok! 213 test cases passed, take time 1.355825404 s ./t/ddl/primary_key_handle.test: ok! 191 test cases passed, take time 1.524053528 s ./t/ddl/reorg_partition.test: ok! 205 test cases passed, take time 3.204142772 s ./t/ddl/resource_group.test: ok! 16 test cases passed, take time 0.054351429 s ./t/ddl/sequence.test: ok! 268 test cases passed, take time 2.064024184 s ./t/ddl/serial.test: ok! 77 test cases passed, take time 0.632429188 s ./t/ddl/table_modify.test: ok! 47 test cases passed, take time 0.291178865 s ./t/executor/adapter.test: ok! 6 test cases passed, take time 0.013595175 s ./t/executor/admin.test: ok! 171 test cases passed, take time 11.921268026 s ./t/executor/aggregate.test: ok! 886 test cases passed, take time 8.199188589 s ./t/executor/analyze.test: ok! 180 test cases passed, take time 4.125969747 s ./t/executor/autoid.test: ok! 442 test cases passed, take time 2.64869182 s ./t/executor/batch_point_get.test: ok! 85 test cases passed, take time 0.44394691 s ./t/executor/charset.test: ok! 57 test cases passed, take time 0.36439491 s ./t/executor/chunk_reuse.test: ok! 93 test cases passed, take time 0.140410187 s ./t/executor/cluster_table.test: ok! 36 test cases passed, take time 0.16917578 s ./t/executor/compact_table.test: ok! 19 test cases passed, take time 0.124658478 s ./t/executor/cte.test: ok! 133 test cases passed, take time 0.682058848 s ./t/executor/ddl.test: ok! 359 test cases passed, take time 4.711309342 s ./t/executor/delete.test: ok! 71 test cases passed, take time 0.441472465 s ./t/executor/distsql.test: ok! 61 test cases passed, take time 0.824597183 s ./t/executor/executor.test: ok! 2151 test cases passed, take time 12.912293739999999 s ./t/executor/executor_txn.test: ok! 121 test cases passed, take time 0.167535783 s ./t/executor/explain.test: ok! 120 test cases passed, take time 0.602909451 s ./t/executor/explainfor.test: ok! 378 test cases passed, take time 1.11760753 s ./t/executor/foreign_key.test: ok! 318 test cases passed, take time 14.539799584 s ./t/executor/grant.test: ok! 202 test cases passed, take time 1.127092708 s ./t/executor/import_into.test: ok! 88 test cases passed, take time 0.087753706 s ./t/executor/index_advise.test: ok! 30 test cases passed, take time 0.101850055 s ./t/executor/index_lookup_join.test: ok! 190 test cases passed, take time 1.7889590389999999 s ./t/executor/index_lookup_merge_join.test: ok! 83 test cases passed, take time 0.94062859 s ./t/executor/index_merge_reader.test: ok! 244 test cases passed, take time 2.085641618 s ./t/executor/infoschema_reader.test: ok! 174 test cases passed, take time 3.937451293 s ./t/executor/insert.test: ok! 1224 test cases passed, take time 11.956172417 s ./t/executor/inspection_common.test: ok! 4 test cases passed, take time 0.002331729 s ./t/executor/issues.test: ok! 422 test cases passed, take time 4.7051764590000005 s ./t/executor/jointest/hash_join.test: ok! 137 test cases passed, take time 1.19907975 s ./t/executor/jointest/join.test: ok! 866 test cases passed, take time 10.028393219 s time="2024-05-18T22:09:46+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 2.635655894 s ./t/executor/parallel_apply.test: ok! 96 test cases passed, take time 0.876829247 s ./t/executor/partition/global_index.test: ok! 94 test cases passed, take time 1.8071252439999999 s time="2024-05-18T22:09:54+08:00" level=error msg="run test [executor/partition/issues] err: sql:explain select * from t where col_29 between -2 and -1;: failed to run query \n\"explain select * from t where col_29 between -2 and -1;\" \n around line 323, \nwe need(347):\nexplain select * from t where col_29 between -2 and -1;\nid\testRows\ttask\taccess object\toperator info\nTableReader_7\t1.00\troot\tpartition:p1,p2\tdata:Selection_6\n└─Selection_6\t1.00\tcop[tikv]\t\tge(executor__partition__issues.t.col_29, -2), le(executor__partition__issues.t.col_29, -1)\n └─TableFullScan_5\t48.00\tcop[tikv]\ttable:t\tkeep order:false\n\nbut got(347):\nexplain select * from t where col_29 between -2 and -1;\nid\testRows\ttask\taccess object\toperator info\nTableReader_7\t1.85\troot\tpartition:p1,p2\tdata:Selection_6\n└─Selection_6\t1.85\tcop[tikv]\t\tge(executor__partition__issues.t.col_29, -2), le(executor__partition__issues.t.col_29, -1)\n └─TableFullScan_5\t48.00\tcop[tikv]\ttable:t\tkeep order:false\n\n" time="2024-05-18T22:09:54+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-18T22:09:55+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 3.263521965 s ./t/executor/partition/write.test: ok! 355 test cases passed, take time 1.812462649 s ./t/executor/password_management.test: ok! 381 test cases passed, take time 2.147958569 s ./t/executor/point_get.test: ok! 273 test cases passed, take time 1.523203187 s ./t/executor/prepared.test: ok! 214 test cases passed, take time 1.02320503 s ./t/executor/revoke.test: ok! 65 test cases passed, take time 0.485398218 s ./t/executor/rowid.test: ok! 63 test cases passed, take time 0.28585758 s ./t/executor/sample.test: ok! 106 test cases passed, take time 1.429054614 s ./t/executor/set.test: ok! 228 test cases passed, take time 0.234251557 s ./t/executor/show.test: ok! 301 test cases passed, take time 3.7051469040000002 s ./t/executor/simple.test: ok! 303 test cases passed, take time 1.892046283 s ./t/executor/split_table.test: ok! 60 test cases passed, take time 0.470447069 s ./t/executor/stale_txn.test: ok! 28 test cases passed, take time 0.979632977 s ./t/executor/statement_context.test: ok! 63 test cases passed, take time 0.111985418 s ./t/executor/union_scan.test: ok! 231 test cases passed, take time 1.209165417 s ./t/executor/update.test: ok! 513 test cases passed, take time 3.010143873 s ./t/executor/window.test: ok! 22 test cases passed, take time 0.061755742 s ./t/executor/write.test: ok! 1079 test cases passed, take time 9.093940837 s ./t/explain-non-select-stmt.test: ok! 8 test cases passed, take time 0.02471251 s ./t/explain.test: ok! 21 test cases passed, take time 0.141974996 s ./t/explain_complex.test: ok! 41 test cases passed, take time 0.494273499 s ./t/explain_complex_stats.test: ok! 61 test cases passed, take time 2.734904135 s ./t/explain_cte.test: ok! 53 test cases passed, take time 0.362175367 s time="2024-05-18T22:10:34+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.671486922 s ./t/explain_foreign_key.test: ok! 41 test cases passed, take time 0.584549812 s time="2024-05-18T22:10:37+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.044126735 s ./t/explain_join_stats.test: ok! 8 test cases passed, take time 0.193523252 s ./t/explain_shard_index.test: ok! 19 test cases passed, take time 0.115911605 s ./t/explain_stats.test: ok! 10 test cases passed, take time 0.078149581 s ./t/explain_union_scan.test: ok! 9 test cases passed, take time 0.139559371 s ./t/expression/builtin.test: ok! 1332 test cases passed, take time 7.597146327 s ./t/expression/cast.test: ok! 50 test cases passed, take time 0.224394361 s ./t/expression/charset_and_collation.test: ok! 733 test cases passed, take time 5.071186274 s ./t/expression/constant_fold.test: ok! 12 test cases passed, take time 0.055224172 s ./t/expression/enum_set.test: ok! 13 test cases passed, take time 0.07466949 s ./t/expression/explain.test: ok! 77 test cases passed, take time 0.191620118 s ./t/expression/issues.test: ok! 1502 test cases passed, take time 14.171594647 s ./t/expression/json.test: ok! 223 test cases passed, take time 0.765818904 s ./t/expression/misc.test: ok! 404 test cases passed, take time 3.109850307 s ./t/expression/multi_valued_index.test: ok! 314 test cases passed, take time 2.330741133 s ./t/expression/noop_functions.test: ok! 61 test cases passed, take time 0.044895609 s ./t/expression/plan_cache.test: ok! 184 test cases passed, take time 0.546203967 s ./t/expression/time.test: ok! 279 test cases passed, take time 0.652996826 s ./t/expression/vitess_hash.test: ok! 17 test cases passed, take time 0.257952721 s ./t/generated_columns.test: ok! 70 test cases passed, take time 0.862418415 s ./t/globalindex/information_schema.test: ok! 5 test cases passed, take time 0.029254055 s ./t/globalindex/mem_index_lookup.test: ok! 29 test cases passed, take time 0.112245302 s ./t/globalindex/mem_index_merge.test: ok! 51 test cases passed, take time 0.213292858 s ./t/globalindex/mem_index_reader.test: ok! 25 test cases passed, take time 0.09720154 s ./t/globalindex/point_get.test: ok! 21 test cases passed, take time 0.605527602 s ./t/globalindex/update.test: ok! 14 test cases passed, take time 0.089069285 s ./t/imdbload.test: ok! 63 test cases passed, take time 7.058294398 s ./t/index_join.test: ok! 22 test cases passed, take time 0.335346186 s ./t/index_merge.test: ok! 145 test cases passed, take time 0.855733143 s ./t/infoschema/cluster_tables.test: ok! 9 test cases passed, take time 0.041177999 s ./t/infoschema/infoschema.test: ok! 49 test cases passed, take time 0.891710162 s ./t/infoschema/tables.test: ok! 120 test cases passed, take time 0.838910562 s ./t/infoschema/v2.test: ok! 30 test cases passed, take time 0.47443256 s ./t/naaj.test: ok! 134 test cases passed, take time 0.235338551 s ./t/new_character_set.test: ok! 61 test cases passed, take time 0.331575097 s ./t/new_character_set_builtin.test: ok! 217 test cases passed, take time 1.074394094 s ./t/new_character_set_invalid.test: ok! 28 test cases passed, take time 0.28146834 s ./t/parser/integration.test: ok! 8 test cases passed, take time 0.091830095 s ./t/partition.test: ok! 3 test cases passed, take time 0.120919958 s time="2024-05-18T22:11:31+08:00" level=error msg="run test [planner/cardinality/selectivity] err: sql:show stats_topn where db_name = 'planner__cardinality__selectivity';: failed to run query \n\"show stats_topn where db_name = 'planner__cardinality__selectivity';\" \n around line 50, \nwe need(2236):\nshow stats_topn where db_name = 'planner__cardinality__selectivity';\nDb_name\tTable_name\tPartition_name\tColumn_name\tIs_index\tValue\tCount\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.00000000\nbut got(2236):\nshow stats_topn where db_name = 'planner__cardinality__selectivity';\nDb_name\tTable_name\tPartition_name\tColumn_name\tIs_index\tValue\tCount\nplanner__cardinality__selectivity\tct1\t\tPRIMARY\t1\t8\t1\nplanner__cardinality__selectivity\tct1\t\ta\t0\t8\t1\nplanner__cardinality__selectivity\tct1\t\tpk\t0\t8\t1\nplanner__cardinality__selectivity\tct2\t\tPRIMARY\t1\t(8, 8)\t1\nplanner__cardinality__selectivity\tct2\t\ta\t0\t8\t1\nplanner__cardinality__selectivity\tct2\t\tb\t0\t8\t1\nplanner__cardinality__selectivity\tct2\t\tc\t0\t8\t1\nplanner__cardinality__selectivity\ttdatetime\t\ta\t0\t2001-01-04 00:00:00\t1\nplanner__cardinality__selectivity\ttdatetime\t\tb\t0\t2001-01-04 00:00:00\t1\nplanner__cardinality__selectivity\ttdatetime\t\tc\t0\t2001-01-04 00:00:00\t1\nplanner__cardinality__selectivity\ttdatetime\t\tmulti\t1\t(2001-01-04 00:00:00, 2001-01-04 00:00:00)\t1\nplanner__cardinality__selectivity\ttdatetime\t\tsingular\t1\t2001-01-04 00:00:00\t1\nplanner__cardinality__selectivity\ttdecimal\t\ta\t0\t8.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdecimal\t\tb\t0\t8.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdecimal\t\tc\t0\t8.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdecimal\t\tmulti\t1\t(8.00000000000000000000, 8.00000000000000000000)\t1\nplanner__cardinality__selectivity\ttdecimal\t\tsingular\t1\t8.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdouble\t\ta\t0\t8\t1\nplanner__cardinality__selectivity\ttdouble\t\tb\t0\t8\t1\nplanner__cardinality__selectivity\ttdouble\t\tc\t0\t8\t1\nplanner__cardinality__selectivity\ttdouble\t\tmulti\t1\t(8, 8)\t1\nplanner__cardinality__selectivity\ttdouble\t\tsingular\t1\t8\t1\nplanner__cardinality__selectivity\ttint\t\ta\t0\t8\t1\nplanner__cardinality__selectivity\ttint\t\tb\t0\t8\t1\nplanner__cardinality__selectivity\ttint\t\tc\t0\t8\t1\nplanner__cardinality__selectivity\ttint\t\tmulti\t1\t(8, 8)\t1\nplanner__cardinality__selectivity\ttint\t\tsingular\t1\t8\t1\nplanner__cardinality__selectivity\ttprefix\t\ta\t0\t666\t1\nplanner__cardinality__selectivity\ttprefix\t\tb\t0\t666\t1\nplanner__cardinality__selectivity\ttprefix\t\tprefixa\t1\t66\t1\nplanner__cardinality__selectivity\ttstring\t\ta\t0\t8\t1\nplanner__cardinality__selectivity\ttstring\t\tb\t0\t8\t1\nplanner__cardinality__selectivity\ttstring\t\tc\t0\t8\t1\nplanner__cardinality__selectivity\ttstring\t\tmulti\t1\t(8, 8)\t1\nplanner__cardinality__selectivity\ttstring\t\tsingular\t1\t8\t1\n\n" ./t/planner/cardinality/trace.test: ok! 5 test cases passed, take time 0.093657041 s ./t/planner/cascades/integration.test: ok! 246 test cases passed, take time 0.825809154 s ./t/planner/core/binary_plan.test: ok! 6 test cases passed, take time 0.0010557 s ./t/planner/core/casetest/expression_rewriter.test: ok! 23 test cases passed, take time 0.130460843 s ./t/planner/core/casetest/hint/hint.test: ok! 182 test cases passed, take time 2.036413934 s ./t/planner/core/casetest/index/index.test: ok! 225 test cases passed, take time 2.105414654 s time="2024-05-18T22:11:39+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.00992493 s ./t/planner/core/casetest/partition/partition_pruner.test: ok! 275 test cases passed, take time 1.19874779 s ./t/planner/core/casetest/physicalplantest/physical_plan.test: ok! 858 test cases passed, take time 3.296889472 s ./t/planner/core/casetest/point_get_plan.test: ok! 52 test cases passed, take time 0.149882197 s ./t/planner/core/casetest/predicate_simplification.test: ok! 29 test cases passed, take time 0.126064109 s ./t/planner/core/casetest/pushdown/push_down.test: ok! 35 test cases passed, take time 0.131714259 s ./t/planner/core/casetest/rule/rule_derive_topn_from_window.test: ok! 73 test cases passed, take time 0.482318215 s ./t/planner/core/casetest/rule/rule_join_reorder.test: ok! 481 test cases passed, take time 5.04537544 s ./t/planner/core/casetest/rule/rule_result_reorder.test: ok! 87 test cases passed, take time 0.770224814 s time="2024-05-18T22:11:52+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.001426426 s ./t/planner/core/expression_rewriter.test: ok! 206 test cases passed, take time 2.295225656 s ./t/planner/core/indexjoin.test: ok! 41 test cases passed, take time 0.138752371 s ./t/planner/core/indexmerge_intersection.test: ok! 6 test cases passed, take time 0.031674313 s ./t/planner/core/indexmerge_path.test: ok! 231 test cases passed, take time 2.179363039 s ./t/planner/core/integration.test: ok! 1623 test cases passed, take time 18.855522042 s ./t/planner/core/integration_partition.test: ok! 498 test cases passed, take time 6.162429946 s ./t/planner/core/issuetest/planner_issue.test: ok! 106 test cases passed, take time 1.736619826 s ./t/planner/core/memtable_predicate_extractor.test: ok! 45 test cases passed, take time 0.119709441 s time="2024-05-18T22:12:26+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.39589781 s ./t/planner/core/plan.test: ok! 157 test cases passed, take time 1.08273154 s ./t/planner/core/plan_cache.test: ok! 1243 test cases passed, take time 5.872140112 s ./t/planner/core/plan_cost_ver2.test: ok! 70 test cases passed, take time 0.387545799 s ./t/planner/core/point_get_plan.test: ok! 265 test cases passed, take time 1.699742675 s ./t/planner/core/preprocess.test: ok! 6 test cases passed, take time 0.047003925 s ./t/planner/core/range_scan_for_like.test: ok! 183 test cases passed, take time 0.407251048 s ./t/planner/core/rule_constant_propagation.test: ok! 31 test cases passed, take time 0.605417487 s ./t/planner/core/rule_join_reorder.test: ok! 52 test cases passed, take time 0.739469061 s ./t/planner/core/rule_result_reorder.test: ok! 29 test cases passed, take time 0.164490327 s ./t/planner/core/tests/prepare/issue.test: ok! 321 test cases passed, take time 1.4424943780000001 s ./t/planner/core/tests/prepare/prepare.test: ok! 458 test cases passed, take time 2.218246167 s ./t/planner/funcdep/only_full_group_by.test: ok! 142 test cases passed, take time 2.310412791 s ./t/privilege/privileges.test: ok! 411 test cases passed, take time 3.53937628 s ./t/select.test: ok! 189 test cases passed, take time 1.480458067 s ./t/session/bootstrap_upgrade.test: ok! 29 test cases passed, take time 0.131389372 s ./t/session/clustered_index.test: ok! 385 test cases passed, take time 7.654188586 s ./t/session/common.test: ok! 203 test cases passed, take time 4.133677347 s ./t/session/nontransactional.test: ok! 1532 test cases passed, take time 6.182262797 s ./t/session/privileges.test: ok! 66 test cases passed, take time 0.685028094 s ./t/session/session.test: ok! 101 test cases passed, take time 0.981594322 s ./t/session/temporary_table.test: ok! 277 test cases passed, take time 0.323012763 s ./t/session/txn.test: ok! 14 test cases passed, take time 0.045434213 s ./t/session/variable.test: ok! 113 test cases passed, take time 0.231967963 s ./t/session/vars.test: ok! 127 test cases passed, take time 0.067142456 s ./t/sessionctx/setvar.test: ok! 681 test cases passed, take time 0.16208301 s ./t/sessiontxn/externals.test: ok! 56 test cases passed, take time 0.18429743 s ./t/statistics/handle.test: ok! 60 test cases passed, take time 1.2880127 s ./t/statistics/integration.test: ok! 19 test cases passed, take time 0.112210591 s ./t/statistics/lock_table_stats.test: ok! 47 test cases passed, take time 0.465022876 s ./t/subquery.test: ok! 32 test cases passed, take time 0.421255334 s ./t/table/cache.test: ok! 108 test cases passed, take time 8.64111116 s ./t/table/index.test: ok! 38 test cases passed, take time 0.659824194 s ./t/table/partition.test: ok! 229 test cases passed, take time 2.906057457 s ./t/table/tables.test: ok! 6 test cases passed, take time 0.031395236 s ./t/table/temptable.test: ok! 11 test cases passed, take time 0.060256864 s ./t/topn_push_down.test: ok! 20 test cases passed, take time 0.193990761 s ./t/topn_pushdown.test: ok! 2 test cases passed, take time 0.000859106 s ./t/tpch.test: ok! 41 test cases passed, take time 1.73549271 s ./t/types/const.test: ok! 143 test cases passed, take time 1.474438863 s ./t/util/admin.test: ok! 240 test cases passed, take time 2.324168762 s time="2024-05-18T22:13:33+08:00" level=error msg="run test [util/ranger] err: sql:explain format='brief' select * from t where (a,b) in ((1,1),(2,2)) and c > 2 and (a,b,c) in ((1,1,1),(2,2,3));: failed to run query \n\"explain format='brief' select * from t where (a,b) in ((1,1),(2,2)) and c > 2 and (a,b,c) in ((1,1,1),(2,2,3));\" \n around line 136, \nwe need(408):\nexplain format='brief' select * from t where (a,b) in ((1,1),(2,2)) and c > 2 and (a,b,c) in ((1,1,1),(2,2,3));\nid\testRows\ttask\taccess object\toperator info\nSelection\t0.75\troot\t\tgt(util__ranger.t.c, 2), or(and(eq(util__ranger.t.a, 1), eq(util__ranger.t.b, 1)), and(eq(util__ranger.t.a, 2), eq(util__ranger.t.b, 2)))\n└─Batch_Point_Get\t2.00\troot\ttable:t, index:PRIMARY(a, b, c)\tkeep order:false, desc:false\n\nbut got(408):\nexplain format='brief' select * from t where (a,b) in ((1,1),(2,2)) and c > 2 and (a,b,c) in ((1,1,1),(2,2,3));\nid\testRows\ttask\taccess object\toperator info\nSelection\t0.00\troot\t\tgt(util__ranger.t.c, 2), or(and(eq(util__ranger.t.a, 1), eq(util__ranger.t.b, 1)), and(eq(util__ranger.t.a, 2), eq(util__ranger.t.b, 2)))\n└─Batch_Point_Get\t2.00\troot\ttable:t, index:PRIMARY(a, b, c)\tkeep order:false, desc:false\n\n" ./t/window_function.test: ok! 28 test cases passed, take time 0.09633273 s time="2024-05-18T22:13:33+08:00" level=error msg="12 tests failed\n" time="2024-05-18T22:13: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" time="2024-05-18T22:13:33+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-18T22:13:33+08:00" level=error msg="run test [executor/partition/issues] err: sql:explain select * from t where col_29 between -2 and -1;: failed to run query \n\"explain select * from t where col_29 between -2 and -1;\" \n around line 323, \nwe need(347):\nexplain select * from t where col_29 between -2 and -1;\nid\testRows\ttask\taccess object\toperator info\nTableReader_7\t1.00\troot\tpartition:p1,p2\tdata:Selection_6\n└─Selection_6\t1.00\tcop[tikv]\t\tge(executor__partition__issues.t.col_29, -2), le(executor__partition__issues.t.col_29, -1)\n └─TableFullScan_5\t48.00\tcop[tikv]\ttable:t\tkeep order:false\n\nbut got(347):\nexplain select * from t where col_29 between -2 and -1;\nid\testRows\ttask\taccess object\toperator info\nTableReader_7\t1.85\troot\tpartition:p1,p2\tdata:Selection_6\n└─Selection_6\t1.85\tcop[tikv]\t\tge(executor__partition__issues.t.col_29, -2), le(executor__partition__issues.t.col_29, -1)\n └─TableFullScan_5\t48.00\tcop[tikv]\ttable:t\tkeep order:false\n\n" time="2024-05-18T22:13:33+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-18T22:13:33+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-18T22:13:33+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-18T22:13:33+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-18T22:13:33+08:00" level=error msg="run test [planner/cardinality/selectivity] err: sql:show stats_topn where db_name = 'planner__cardinality__selectivity';: failed to run query \n\"show stats_topn where db_name = 'planner__cardinality__selectivity';\" \n around line 50, \nwe need(2236):\nshow stats_topn where db_name = 'planner__cardinality__selectivity';\nDb_name\tTable_name\tPartition_name\tColumn_name\tIs_index\tValue\tCount\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.00000000\nbut got(2236):\nshow stats_topn where db_name = 'planner__cardinality__selectivity';\nDb_name\tTable_name\tPartition_name\tColumn_name\tIs_index\tValue\tCount\nplanner__cardinality__selectivity\tct1\t\tPRIMARY\t1\t8\t1\nplanner__cardinality__selectivity\tct1\t\ta\t0\t8\t1\nplanner__cardinality__selectivity\tct1\t\tpk\t0\t8\t1\nplanner__cardinality__selectivity\tct2\t\tPRIMARY\t1\t(8, 8)\t1\nplanner__cardinality__selectivity\tct2\t\ta\t0\t8\t1\nplanner__cardinality__selectivity\tct2\t\tb\t0\t8\t1\nplanner__cardinality__selectivity\tct2\t\tc\t0\t8\t1\nplanner__cardinality__selectivity\ttdatetime\t\ta\t0\t2001-01-04 00:00:00\t1\nplanner__cardinality__selectivity\ttdatetime\t\tb\t0\t2001-01-04 00:00:00\t1\nplanner__cardinality__selectivity\ttdatetime\t\tc\t0\t2001-01-04 00:00:00\t1\nplanner__cardinality__selectivity\ttdatetime\t\tmulti\t1\t(2001-01-04 00:00:00, 2001-01-04 00:00:00)\t1\nplanner__cardinality__selectivity\ttdatetime\t\tsingular\t1\t2001-01-04 00:00:00\t1\nplanner__cardinality__selectivity\ttdecimal\t\ta\t0\t8.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdecimal\t\tb\t0\t8.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdecimal\t\tc\t0\t8.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdecimal\t\tmulti\t1\t(8.00000000000000000000, 8.00000000000000000000)\t1\nplanner__cardinality__selectivity\ttdecimal\t\tsingular\t1\t8.00000000000000000000\t1\nplanner__cardinality__selectivity\ttdouble\t\ta\t0\t8\t1\nplanner__cardinality__selectivity\ttdouble\t\tb\t0\t8\t1\nplanner__cardinality__selectivity\ttdouble\t\tc\t0\t8\t1\nplanner__cardinality__selectivity\ttdouble\t\tmulti\t1\t(8, 8)\t1\nplanner__cardinality__selectivity\ttdouble\t\tsingular\t1\t8\t1\nplanner__cardinality__selectivity\ttint\t\ta\t0\t8\t1\nplanner__cardinality__selectivity\ttint\t\tb\t0\t8\t1\nplanner__cardinality__selectivity\ttint\t\tc\t0\t8\t1\nplanner__cardinality__selectivity\ttint\t\tmulti\t1\t(8, 8)\t1\nplanner__cardinality__selectivity\ttint\t\tsingular\t1\t8\t1\nplanner__cardinality__selectivity\ttprefix\t\ta\t0\t666\t1\nplanner__cardinality__selectivity\ttprefix\t\tb\t0\t666\t1\nplanner__cardinality__selectivity\ttprefix\t\tprefixa\t1\t66\t1\nplanner__cardinality__selectivity\ttstring\t\ta\t0\t8\t1\nplanner__cardinality__selectivity\ttstring\t\tb\t0\t8\t1\nplanner__cardinality__selectivity\ttstring\t\tc\t0\t8\t1\nplanner__cardinality__selectivity\ttstring\t\tmulti\t1\t(8, 8)\t1\nplanner__cardinality__selectivity\ttstring\t\tsingular\t1\t8\t1\n\n" time="2024-05-18T22:13:33+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-18T22:13:33+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-18T22:13:33+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-18T22:13:33+08:00" level=error msg="run test [util/ranger] err: sql:explain format='brief' select * from t where (a,b) in ((1,1),(2,2)) and c > 2 and (a,b,c) in ((1,1,1),(2,2,3));: failed to run query \n\"explain format='brief' select * from t where (a,b) in ((1,1),(2,2)) and c > 2 and (a,b,c) in ((1,1,1),(2,2,3));\" \n around line 136, \nwe need(408):\nexplain format='brief' select * from t where (a,b) in ((1,1),(2,2)) and c > 2 and (a,b,c) in ((1,1,1),(2,2,3));\nid\testRows\ttask\taccess object\toperator info\nSelection\t0.75\troot\t\tgt(util__ranger.t.c, 2), or(and(eq(util__ranger.t.a, 1), eq(util__ranger.t.b, 1)), and(eq(util__ranger.t.a, 2), eq(util__ranger.t.b, 2)))\n└─Batch_Point_Get\t2.00\troot\ttable:t, index:PRIMARY(a, b, c)\tkeep order:false, desc:false\n\nbut got(408):\nexplain format='brief' select * from t where (a,b) in ((1,1),(2,2)) and c > 2 and (a,b,c) in ((1,1,1),(2,2,3));\nid\testRows\ttask\taccess object\toperator info\nSelection\t0.00\troot\t\tgt(util__ranger.t.c, 2), or(and(eq(util__ranger.t.a, 1), eq(util__ranger.t.b, 1)), and(eq(util__ranger.t.a, 2), eq(util__ranger.t.b, 2)))\n└─Batch_Point_Get\t2.00\troot\ttable:t, index:PRIMARY(a, b, c)\tkeep order:false, desc: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 14:13:36-- 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% 153M=0s 2024-05-18 14:13:36 (153 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