Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

IT sqllogic-test failed #27878

Closed
jingshanglu opened this issue Sep 8, 2021 · 2 comments · Fixed by #27881
Closed

IT sqllogic-test failed #27878

jingshanglu opened this issue Sep 8, 2021 · 2 comments · Fixed by #27881
Labels
component/test severity/major type/bug The issue is confirmed as a bug.

Comments

@jingshanglu
Copy link
Contributor

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

[2021-09-07T09:42:25.767Z] [2021/09/07 17:41:43.859 +08:00] [INFO] [printer.go:48] ["loaded config"] [config="{\"host\":\"0.0.0.0\",\"advertise-address\":\"10.233.98.46\",\"port\":4003,\"cors\":\"\",\"store\":\"unistore\",\"path\":\"\",\"socket\":\"\",\"lease\":\"0\",\"run-ddl\":true,\"split-table\":false,\"token-limit\":1000,\"oom-use-tmp-storage\":true,\"tmp-storage-path\":\"/tmp/1000_tidb/MC4wLjAuMDo0MDAzLzAuMC4wLjA6OTA4Mw==/tmp-storage\",\"oom-action\":\"cancel\",\"mem-quota-query\":1073741824,\"tmp-storage-quota\":-1,\"enable-batch-dml\":false,\"lower-case-table-names\":2,\"server-version\":\"\",\"log\":{\"level\":\"error\",\"format\":\"text\",\"disable-timestamp\":null,\"enable-timestamp\":null,\"disable-error-stack\":null,\"enable-error-stack\":null,\"file\":{\"filename\":\"\",\"max-size\":300,\"max-days\":0,\"max-backups\":0},\"enable-slow-log\":true,\"slow-query-file\":\"tidb-slow.log\",\"slow-threshold\":300,\"expensive-threshold\":10000,\"query-log-max-len\":4096,\"record-plan-in-slow-log\":1},\"security\":{\"skip-grant-table\":false,\"ssl-ca\":\"\",\"ssl-cert\":\"\",\"ssl-key\":\"\",\"require-secure-transport\":false,\"cluster-ssl-ca\":\"\",\"cluster-ssl-cert\":\"\",\"cluster-ssl-key\":\"\",\"cluster-verify-cn\":null,\"spilled-file-encryption-method\":\"plaintext\",\"enable-sem\":false,\"auto-tls\":true,\"tls-version\":\"\",\"rsa-key-size\":4096},\"status\":{\"status-host\":\"0.0.0.0\",\"metrics-addr\":\"\",\"status-port\":9083,\"metrics-interval\":15,\"report-status\":true,\"record-db-qps\":false},\"performance\":{\"max-procs\":0,\"max-memory\":0,\"server-memory-quota\":0,\"memory-usage-alarm-ratio\":0.8,\"stats-lease\":\"0\",\"stmt-count-limit\":5000,\"feedback-probability\":0,\"query-feedback-limit\":512,\"pseudo-estimate-ratio\":0.8,\"force-priority\":\"NO_PRIORITY\",\"bind-info-lease\":\"3s\",\"txn-entry-size-limit\":6291456,\"txn-total-size-limit\":104857600,\"tcp-keep-alive\":true,\"tcp-no-delay\":true,\"cross-join\":true,\"run-auto-analyze\":true,\"distinct-agg-push-down\":false,\"committer-concurrency\":128,\"max-txn-ttl\":3600000,\"mem-profile-interval\":\"1m\",\"index-usage-sync-lease\":\"0s\",\"gogc\":100,\"enforce-mpp\":false},\"prepared-plan-cache\":{\"enabled\":false,\"capacity\":100,\"memory-guard-ratio\":0.1},\"opentracing\":{\"enable\":false,\"rpc-metrics\":false,\"sampler\":{\"type\":\"const\",\"param\":1,\"sampling-server-url\":\"\",\"max-operations\":0,\"sampling-refresh-interval\":0},\"reporter\":{\"queue-size\":0,\"buffer-flush-interval\":0,\"log-spans\":false,\"local-agent-host-port\":\"\"}},\"proxy-protocol\":{\"networks\":\"\",\"header-timeout\":5},\"pd-client\":{\"pd-server-timeout\":3},\"tikv-client\":{\"grpc-connection-count\":4,\"grpc-keepalive-time\":10,\"grpc-keepalive-timeout\":3,\"grpc-compression-type\":\"none\",\"commit-timeout\":\"41s\",\"async-commit\":{\"keys-limit\":256,\"total-key-size-limit\":4096,\"safe-window\":2000000000,\"allowed-clock-drift\":500000000},\"max-batch-size\":128,\"overload-threshold\":200,\"max-batch-wait-time\":0,\"batch-wait-size\":8,\"enable-chunk-rpc\":true,\"region-cache-ttl\":600,\"store-limit\":0,\"store-liveness-timeout\":\"1s\",\"copr-cache\":{\"capacity-mb\":1000},\"ttl-refreshed-txn-size\":33554432,\"resolve-lock-lite-threshold\":16},\"binlog\":{\"enable\":false,\"ignore-error\":false,\"write-timeout\":\"15s\",\"binlog-socket\":\"\",\"strategy\":\"range\"},\"compatible-kill-query\":false,\"plugin\":{\"dir\":\"\",\"load\":\"\"},\"pessimistic-txn\":{\"max-retry-count\":256,\"deadlock-history-capacity\":10,\"deadlock-history-collect-retryable\":false},\"check-mb4-value-in-utf8\":true,\"max-index-length\":3072,\"index-limit\":64,\"table-column-count-limit\":1017,\"graceful-wait-before-shutdown\":0,\"alter-primary-key\":false,\"treat-old-version-utf8-as-utf8mb4\":true,\"enable-table-lock\":false,\"delay-clean-table-lock\":0,\"split-region-max-num\":1000,\"stmt-summary\":{\"enable\":true,\"enable-internal-query\":false,\"max-stmt-count\":3000,\"max-sql-length\":4096,\"refresh-interval\":1800,\"history-size\":24},\"repair-mode\":false,\"repair-table-list\":[],\"isolation-read\":{\"engines\":[\"tikv\",\"tiflash\",\"tidb\"]},\"max-server-connections\":0,\"new_collations_enabled_on_first_bootstrap\":false,\"experimental\":{},\"enable-collect-execution-info\":true,\"skip-register-to-dashboard\":false,\"enable-telemetry\":true,\"labels\":{},\"enable-global-index\":false,\"deprecate-integer-display-length\":false,\"enable-enum-length-limit\":true,\"stores-refresh-interval\":60,\"enable-tcp4-only\":false,\"enable-forwarding\":false}"]

[2021-09-07T09:42:25.767Z] fatal error: sync: RUnlock of unlocked RWMutex

[2021-09-07T09:42:25.767Z] 

[2021-09-07T09:42:25.767Z] goroutine 51034 [running]:

[2021-09-07T09:42:25.767Z] runtime.throw(0x3bbaa77, 0x21)

[2021-09-07T09:42:25.767Z] 	/usr/local/go/src/runtime/panic.go:1117 +0x72 fp=0xc000d53b68 sp=0xc000d53b38 pc=0x12277d2

[2021-09-07T09:42:25.767Z] sync.throw(0x3bbaa77, 0x21)

[2021-09-07T09:42:25.768Z] 	/usr/local/go/src/runtime/panic.go:1103 +0x35 fp=0xc000d53b88 sp=0xc000d53b68 pc=0x125c7d5

[2021-09-07T09:42:25.768Z] sync.(*RWMutex).rUnlockSlow(0xc00710c000, 0xffffffff)

[2021-09-07T09:42:25.768Z] 	/usr/local/go/src/sync/rwmutex.go:93 +0x3f fp=0xc000d53bb0 sp=0xc000d53b88 pc=0x126f13f

[2021-09-07T09:42:25.768Z] sync.(*RWMutex).RUnlock(...)

[2021-09-07T09:42:25.768Z] 	/usr/local/go/src/sync/rwmutex.go:83

[2021-09-07T09:42:25.768Z] github.com/pingcap/tidb/util/chunk.(*mutexForRowContainer).RUnlock(0xc008456f00)

[2021-09-07T09:42:25.768Z] 	/home/jenkins/agent/workspace/tidb_merged_pr_build/go/src/github.com/pingcap/tidb/util/chunk/row_container.go:73 +0x4c fp=0xc000d53bd0 sp=0xc000d53bb0 pc=0x1fa92cc

[2021-09-07T09:42:25.768Z] github.com/pingcap/tidb/util/chunk.(*RowContainer).Add(0xc009411270, 0xc00a01a000, 0x0, 0x0)

[2021-09-07T09:42:25.768Z] 	/home/jenkins/agent/workspace/tidb_merged_pr_build/go/src/github.com/pingcap/tidb/util/chunk/row_container.go:228 +0xc5 fp=0xc000d53c18 sp=0xc000d53bd0 pc=0x1faa325

[2021-09-07T09:42:25.768Z] github.com/pingcap/tidb/executor.(*hashRowContainer).PutChunkSelected(0xc007c6cfc0, 0xc00a01a000, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0)

[2021-09-07T09:42:25.768Z] 	/home/jenkins/agent/workspace/tidb_merged_pr_build/go/src/github.com/pingcap/tidb/executor/hash_table.go:164 +0xee fp=0xc000d53d28 sp=0xc000d53c18 pc=0x30ddcae

[2021-09-07T09:42:25.768Z] github.com/pingcap/tidb/executor.(*hashRowContainer).PutChunk(...)

[2021-09-07T09:42:25.768Z] 	/home/jenkins/agent/workspace/tidb_merged_pr_build/go/src/github.com/pingcap/tidb/executor/hash_table.go:153

[2021-09-07T09:42:25.768Z] github.com/pingcap/tidb/executor.(*HashJoinExec).buildHashTableForList(0xc00732da00, 0xc0060a4000, 0xc00822a000, 0xc00a010010)

[2021-09-07T09:42:25.768Z] 	/home/jenkins/agent/workspace/tidb_merged_pr_build/go/src/github.com/pingcap/tidb/executor/join.go:771 +0x6d0 fp=0xc000d53e90 sp=0xc000d53d28 pc=0x313fef0

[2021-09-07T09:42:25.768Z] github.com/pingcap/tidb/executor.(*HashJoinExec).fetchAndBuildHashTable(0xc00732da00, 0x4094510, 0xc007774960)

[2021-09-07T09:42:25.768Z] 	/home/jenkins/agent/workspace/tidb_merged_pr_build/go/src/github.com/pingcap/tidb/executor/join.go:730 +0x1b3 fp=0xc000d53f38 sp=0xc000d53e90 pc=0x313f5b3

[2021-09-07T09:42:25.768Z] github.com/pingcap/tidb/executor.(*HashJoinExec).Next.func1()

[2021-09-07T09:42:25.768Z] 	/home/jenkins/agent/workspace/tidb_merged_pr_build/go/src/github.com/pingcap/tidb/executor/join.go:675 +0xa9 fp=0xc000d53fa0 sp=0xc000d53f38 pc=0x31f1729

[2021-09-07T09:42:25.768Z] github.com/pingcap/tidb/util.WithRecovery(0xc008e34aa0, 0xc0068fc770)

[2021-09-07T09:42:25.768Z] 	/home/jenkins/agent/workspace/tidb_merged_pr_build/go/src/github.com/pingcap/tidb/util/misc.go:100 +0x4f fp=0xc000d53fd0 sp=0xc000d53fa0 pc=0x1fca3ef

[2021-09-07T09:42:25.768Z] runtime.goexit()

[2021-09-07T09:42:25.768Z] 	/usr/local/go/src/runtime/asm_amd64.s:1371 +0x1 fp=0xc000d53fd8 sp=0xc000d53fd0 pc=0x1262a81

[2021-09-07T09:42:25.768Z] created by github.com/pingcap/tidb/executor.(*HashJoinExec).Next

[2021-09-07T09:42:25.768Z] 	/home/jenkins/agent/workspace/tidb_merged_pr_build/go/src/github.com/pingcap/tidb/executor/join.go:673 +0x245

[2021-09-07T09:42:25.768Z] 

[2021-09-07T09:42:25.768Z] goroutine 1 [chan receive]:

[2021-09-07T09:42:25.768Z] github.com/pingcap/tidb/server.(*Server).Run(0xc004deaea0, 0xc005e11a70, 0xc0059dcae0)

[2021-09-07T09:42:25.768Z] 	/home/jenkins/agent/workspace/tidb_merged_pr_build/go/src/github.com/pingcap/tidb/server/server.go:343 +0x1c5

[2021-09-07T09:42:25.768Z] main.main()

[2021-09-07T09:42:25.768Z] 	/home/jenkins/agent/workspace/tidb_merged_pr_build/go/src/github.com/pingcap/tidb/tidb-server/main.go:201 +0x33d

ci:
https://ci.pingcap.net/blue/organizations/jenkins/tidb_ghpr_sqllogic_test_1/detail/tidb_ghpr_sqllogic_test_1/6240/pipeline

pr: #27577

2. What did you expect to see? (Required)

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

@jingshanglu jingshanglu added type/bug The issue is confirmed as a bug. component/test severity/major labels Sep 8, 2021
@jingshanglu
Copy link
Contributor Author

/cc @XuHuaiyu

@github-actions
Copy link

github-actions bot commented Sep 8, 2021

Please check whether the issue should be labeled with 'affects-x.y' or 'backport-x.y.z',
and then remove 'needs-more-info' label.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
component/test severity/major type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant