search

pingcap / tidb

TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try AI-powered Chat2Query free at : https://www.pingcap.com/tidb-serverless/
https://pingcap.com
Apache License 2.0
36.54k stars 5.75k forks source link

tidb lightning encountered error: [Lightning:PreCheck:ErrCheckTableEmpty]check table empty error: check table contains data failed: check table empty failed: Error 1105 (HY000): PD returned no region, range num: 1, limit: 128 #54277

Closed lance6716 closed 2 days ago

lance6716 commented 1 week ago

Found in CI

https://do.pingcap.net/jenkins/blue/organizations/jenkins/pingcap%2Ftidb%2Fpull_lightning_integration_test/detail/pull_lightning_integration_test/916/pipeline/324/

lance6716 commented 1 week ago

lightning uses SQL to do the precheck

[2024/06/27 15:13:13.457 +08:00] [INFO] [conn.go:1162] ["command dispatched failed"] [conn=3080716336] [session_alias=] [connInfo="id:3080716336, addr:127.0.0.1:37034 status:10, collation:utf8mb4_general_ci, user:root"] [command=Query] [status="inTxn:0, autocommit:1"] [sql="SELECT 1 FROM `restore_tsr`.`tbl20` USE INDEX() LIMIT 1"] [txn_mode=OPTIMISTIC] [timestamp=450749371105148966] [err="PD returned no region, range num: 1, limit: 128\ngithub.com/tikv/client-go/v2/internal/locate.(*RegionCache).batchScanRegions\n\t/go/pkg/mod/github.com/tikv/client-go/v2@v2.0.8-0.20240626064248-4a72526f6c30/internal/locate/region_cache.go:2210\ngithub.com/tikv/client-go/v2/internal/locate.(*RegionCache).BatchLoadRegionsWithKeyRanges\n\t/go/pkg/mod/github.com/tikv/client-go/v2@v2.0.8-0.20240626064248-4a72526f6c30/internal/locate/region_cache.go:1742\ngithub.com/tikv/client-go/v2/internal/locate.(*RegionCache).BatchLocateKeyRanges\n\t/go/pkg/mod/github.com/tikv/client-go/v2@v2.0.8-0.20240626064248-4a72526f6c30/internal/locate/region_cache.go:1268\ngithub.com/pingcap/tidb/pkg/store/copr.(*RegionCache).SplitKeyRangesByLocations\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/region_cache.go:190\ngithub.com/pingcap/tidb/pkg/store/copr.(*RegionCache).SplitKeyRangesByBuckets\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/region_cache.go:234\ngithub.com/pingcap/tidb/pkg/store/copr.buildCopTasks\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:362\ngithub.com/pingcap/tidb/pkg/store/copr.(*CopClient).BuildCopIterator.func3\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:155\ngithub.com/pingcap/tidb/pkg/kv.(*KeyRanges).ForEachPartitionWithErr\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/kv/kv.go:473\ngithub.com/pingcap/tidb/pkg/store/copr.(*CopClient).BuildCopIterator\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:169\ngithub.com/pingcap/tidb/pkg/store/copr.(*CopClient).Send\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:99\ngithub.com/pingcap/tidb/pkg/distsql.Select\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/distsql/distsql.go:91\ngithub.com/pingcap/tidb/pkg/distsql.SelectWithRuntimeStats\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/distsql/distsql.go:146\ngithub.com/pingcap/tidb/pkg/executor.selectResultHook.SelectResult\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/table_reader.go:70\ngithub.com/pingcap/tidb/pkg/executor.(*TableReaderExecutor).buildResp\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/table_reader.go:416\ngithub.com/pingcap/tidb/pkg/executor.(*TableReaderExecutor).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/table_reader.go:297\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:387\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.(*BaseExecutorV2).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:288\ngithub.com/pingcap/tidb/pkg/executor.(*LimitExec).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/executor.go:1395\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:387\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.(*BaseExecutorV2).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:288\ngithub.com/pingcap/tidb/pkg/executor.(*ProjectionExec).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/projection.go:88\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:387\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).openExecutor\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/adapter.go:1243\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).Exec\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/adapter.go:584\ngithub.com/pingcap/tidb/pkg/session.runStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/session/session.go:2289\ngithub.com/pingcap/tidb/pkg/session.(*session).ExecuteStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/session/session.go:2150\ngithub.com/pingcap/tidb/pkg/server.(*TiDBContext).ExecuteStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/driver_tidb.go:294\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).handleStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:2031\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).handleQuery\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:1785\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).dispatch\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:1359\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).Run\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:1125\ngithub.com/pingcap/tidb/pkg/server.(*Server).onConn\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/server.go:739\ngithub.com/pingcap/errors.AddStack\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20240318064555-6bd07397691f/errors.go:178\ngithub.com/pingcap/errors.Trace\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20240318064555-6bd07397691f/juju_adaptor.go:15\ngithub.com/pingcap/tidb/pkg/store/driver/error.ToTiDBErr\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/driver/error/error.go:200\ngithub.com/pingcap/tidb/pkg/store/copr.(*RegionCache).SplitKeyRangesByLocations\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/region_cache.go:192\ngithub.com/pingcap/tidb/pkg/store/copr.(*RegionCache).SplitKeyRangesByBuckets\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/region_cache.go:234\ngithub.com/pingcap/tidb/pkg/store/copr.buildCopTasks\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:362\ngithub.com/pingcap/tidb/pkg/store/copr.(*CopClient).BuildCopIterator.func3\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:155\ngithub.com/pingcap/tidb/pkg/kv.(*KeyRanges).ForEachPartitionWithErr\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/kv/kv.go:473\ngithub.com/pingcap/tidb/pkg/store/copr.(*CopClient).BuildCopIterator\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:169\ngithub.com/pingcap/tidb/pkg/store/copr.(*CopClient).Send\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:99\ngithub.com/pingcap/tidb/pkg/distsql.Select\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/distsql/distsql.go:91\ngithub.com/pingcap/tidb/pkg/distsql.SelectWithRuntimeStats\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/distsql/distsql.go:146\ngithub.com/pingcap/tidb/pkg/executor.selectResultHook.SelectResult\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/table_reader.go:70\ngithub.com/pingcap/tidb/pkg/executor.(*TableReaderExecutor).buildResp\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/table_reader.go:416\ngithub.com/pingcap/tidb/pkg/executor.(*TableReaderExecutor).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/table_reader.go:297\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:387\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.(*BaseExecutorV2).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:288\ngithub.com/pingcap/tidb/pkg/executor.(*LimitExec).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/executor.go:1395\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:387\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.(*BaseExecutorV2).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:288\ngithub.com/pingcap/tidb/pkg/executor.(*ProjectionExec).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/projection.go:88\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:387\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).openExecutor\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/adapter.go:1243\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).Exec\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/adapter.go:584\ngithub.com/pingcap/tidb/pkg/session.runStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/session/session.go:2289\ngithub.com/pingcap/tidb/pkg/session.(*session).ExecuteStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/session/session.go:2150\ngithub.com/pingcap/tidb/pkg/server.(*TiDBContext).ExecuteStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/driver_tidb.go:294\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).handleStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:2031\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).handleQuery\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:1785\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).dispatch\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:1359\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).Run\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:1125\ngithub.com/pingcap/tidb/pkg/server.(*Server).onConn\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/server.go:739"]
[2024/06/27 15:13:16.460 +08:00] [INFO] [conn.go:1162] ["command dispatched failed"] [conn=3080716306] [session_alias=] [connInfo="id:3080716306, addr:127.0.0.1:36896 status:10, collation:utf8mb4_general_ci, user:root"] [command=Query] [status="inTxn:0, autocommit:1"] [sql="SELECT 1 FROM `restore_tsr`.`tbl20` USE INDEX() LIMIT 1"] [txn_mode=OPTIMISTIC] [timestamp=450749371891580929] [err="PD returned no region, range num: 1, limit: 128\ngithub.com/tikv/client-go/v2/internal/locate.(*RegionCache).batchScanRegions\n\t/go/pkg/mod/github.com/tikv/client-go/v2@v2.0.8-0.20240626064248-4a72526f6c30/internal/locate/region_cache.go:2210\ngithub.com/tikv/client-go/v2/internal/locate.(*RegionCache).BatchLoadRegionsWithKeyRanges\n\t/go/pkg/mod/github.com/tikv/client-go/v2@v2.0.8-0.20240626064248-4a72526f6c30/internal/locate/region_cache.go:1742\ngithub.com/tikv/client-go/v2/internal/locate.(*RegionCache).BatchLocateKeyRanges\n\t/go/pkg/mod/github.com/tikv/client-go/v2@v2.0.8-0.20240626064248-4a72526f6c30/internal/locate/region_cache.go:1268\ngithub.com/pingcap/tidb/pkg/store/copr.(*RegionCache).SplitKeyRangesByLocations\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/region_cache.go:190\ngithub.com/pingcap/tidb/pkg/store/copr.(*RegionCache).SplitKeyRangesByBuckets\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/region_cache.go:234\ngithub.com/pingcap/tidb/pkg/store/copr.buildCopTasks\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:362\ngithub.com/pingcap/tidb/pkg/store/copr.(*CopClient).BuildCopIterator.func3\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:155\ngithub.com/pingcap/tidb/pkg/kv.(*KeyRanges).ForEachPartitionWithErr\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/kv/kv.go:473\ngithub.com/pingcap/tidb/pkg/store/copr.(*CopClient).BuildCopIterator\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:169\ngithub.com/pingcap/tidb/pkg/store/copr.(*CopClient).Send\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:99\ngithub.com/pingcap/tidb/pkg/distsql.Select\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/distsql/distsql.go:91\ngithub.com/pingcap/tidb/pkg/distsql.SelectWithRuntimeStats\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/distsql/distsql.go:146\ngithub.com/pingcap/tidb/pkg/executor.selectResultHook.SelectResult\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/table_reader.go:70\ngithub.com/pingcap/tidb/pkg/executor.(*TableReaderExecutor).buildResp\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/table_reader.go:416\ngithub.com/pingcap/tidb/pkg/executor.(*TableReaderExecutor).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/table_reader.go:297\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:387\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.(*BaseExecutorV2).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:288\ngithub.com/pingcap/tidb/pkg/executor.(*LimitExec).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/executor.go:1395\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:387\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.(*BaseExecutorV2).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:288\ngithub.com/pingcap/tidb/pkg/executor.(*ProjectionExec).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/projection.go:88\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:387\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).openExecutor\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/adapter.go:1243\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).Exec\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/adapter.go:584\ngithub.com/pingcap/tidb/pkg/session.runStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/session/session.go:2289\ngithub.com/pingcap/tidb/pkg/session.(*session).ExecuteStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/session/session.go:2150\ngithub.com/pingcap/tidb/pkg/server.(*TiDBContext).ExecuteStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/driver_tidb.go:294\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).handleStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:2031\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).handleQuery\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:1785\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).dispatch\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:1359\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).Run\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:1125\ngithub.com/pingcap/tidb/pkg/server.(*Server).onConn\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/server.go:739\ngithub.com/pingcap/errors.AddStack\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20240318064555-6bd07397691f/errors.go:178\ngithub.com/pingcap/errors.Trace\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20240318064555-6bd07397691f/juju_adaptor.go:15\ngithub.com/pingcap/tidb/pkg/store/driver/error.ToTiDBErr\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/driver/error/error.go:200\ngithub.com/pingcap/tidb/pkg/store/copr.(*RegionCache).SplitKeyRangesByLocations\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/region_cache.go:192\ngithub.com/pingcap/tidb/pkg/store/copr.(*RegionCache).SplitKeyRangesByBuckets\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/region_cache.go:234\ngithub.com/pingcap/tidb/pkg/store/copr.buildCopTasks\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:362\ngithub.com/pingcap/tidb/pkg/store/copr.(*CopClient).BuildCopIterator.func3\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:155\ngithub.com/pingcap/tidb/pkg/kv.(*KeyRanges).ForEachPartitionWithErr\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/kv/kv.go:473\ngithub.com/pingcap/tidb/pkg/store/copr.(*CopClient).BuildCopIterator\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:169\ngithub.com/pingcap/tidb/pkg/store/copr.(*CopClient).Send\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:99\ngithub.com/pingcap/tidb/pkg/distsql.Select\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/distsql/distsql.go:91\ngithub.com/pingcap/tidb/pkg/distsql.SelectWithRuntimeStats\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/distsql/distsql.go:146\ngithub.com/pingcap/tidb/pkg/executor.selectResultHook.SelectResult\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/table_reader.go:70\ngithub.com/pingcap/tidb/pkg/executor.(*TableReaderExecutor).buildResp\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/table_reader.go:416\ngithub.com/pingcap/tidb/pkg/executor.(*TableReaderExecutor).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/table_reader.go:297\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:387\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.(*BaseExecutorV2).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:288\ngithub.com/pingcap/tidb/pkg/executor.(*LimitExec).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/executor.go:1395\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:387\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.(*BaseExecutorV2).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:288\ngithub.com/pingcap/tidb/pkg/executor.(*ProjectionExec).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/projection.go:88\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:387\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).openExecutor\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/adapter.go:1243\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).Exec\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/adapter.go:584\ngithub.com/pingcap/tidb/pkg/session.runStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/session/session.go:2289\ngithub.com/pingcap/tidb/pkg/session.(*session).ExecuteStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/session/session.go:2150\ngithub.com/pingcap/tidb/pkg/server.(*TiDBContext).ExecuteStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/driver_tidb.go:294\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).handleStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:2031\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).handleQuery\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:1785\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).dispatch\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:1359\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).Run\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:1125\ngithub.com/pingcap/tidb/pkg/server.(*Server).onConn\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/server.go:739"]
[2024/06/27 15:13:19.462 +08:00] [INFO] [conn.go:1162] ["command dispatched failed"] [conn=3080716306] [session_alias=] [connInfo="id:3080716306, addr:127.0.0.1:36896 status:10, collation:utf8mb4_general_ci, user:root"] [command=Query] [status="inTxn:0, autocommit:1"] [sql="SELECT 1 FROM `restore_tsr`.`tbl20` USE INDEX() LIMIT 1"] [txn_mode=OPTIMISTIC] [timestamp=450749372678012929] [err="PD returned no region, range num: 1, limit: 128\ngithub.com/tikv/client-go/v2/internal/locate.(*RegionCache).batchScanRegions\n\t/go/pkg/mod/github.com/tikv/client-go/v2@v2.0.8-0.20240626064248-4a72526f6c30/internal/locate/region_cache.go:2210\ngithub.com/tikv/client-go/v2/internal/locate.(*RegionCache).BatchLoadRegionsWithKeyRanges\n\t/go/pkg/mod/github.com/tikv/client-go/v2@v2.0.8-0.20240626064248-4a72526f6c30/internal/locate/region_cache.go:1742\ngithub.com/tikv/client-go/v2/internal/locate.(*RegionCache).BatchLocateKeyRanges\n\t/go/pkg/mod/github.com/tikv/client-go/v2@v2.0.8-0.20240626064248-4a72526f6c30/internal/locate/region_cache.go:1268\ngithub.com/pingcap/tidb/pkg/store/copr.(*RegionCache).SplitKeyRangesByLocations\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/region_cache.go:190\ngithub.com/pingcap/tidb/pkg/store/copr.(*RegionCache).SplitKeyRangesByBuckets\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/region_cache.go:234\ngithub.com/pingcap/tidb/pkg/store/copr.buildCopTasks\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:362\ngithub.com/pingcap/tidb/pkg/store/copr.(*CopClient).BuildCopIterator.func3\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:155\ngithub.com/pingcap/tidb/pkg/kv.(*KeyRanges).ForEachPartitionWithErr\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/kv/kv.go:473\ngithub.com/pingcap/tidb/pkg/store/copr.(*CopClient).BuildCopIterator\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:169\ngithub.com/pingcap/tidb/pkg/store/copr.(*CopClient).Send\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:99\ngithub.com/pingcap/tidb/pkg/distsql.Select\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/distsql/distsql.go:91\ngithub.com/pingcap/tidb/pkg/distsql.SelectWithRuntimeStats\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/distsql/distsql.go:146\ngithub.com/pingcap/tidb/pkg/executor.selectResultHook.SelectResult\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/table_reader.go:70\ngithub.com/pingcap/tidb/pkg/executor.(*TableReaderExecutor).buildResp\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/table_reader.go:416\ngithub.com/pingcap/tidb/pkg/executor.(*TableReaderExecutor).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/table_reader.go:297\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:387\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.(*BaseExecutorV2).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:288\ngithub.com/pingcap/tidb/pkg/executor.(*LimitExec).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/executor.go:1395\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:387\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.(*BaseExecutorV2).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:288\ngithub.com/pingcap/tidb/pkg/executor.(*ProjectionExec).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/projection.go:88\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:387\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).openExecutor\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/adapter.go:1243\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).Exec\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/adapter.go:584\ngithub.com/pingcap/tidb/pkg/session.runStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/session/session.go:2289\ngithub.com/pingcap/tidb/pkg/session.(*session).ExecuteStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/session/session.go:2150\ngithub.com/pingcap/tidb/pkg/server.(*TiDBContext).ExecuteStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/driver_tidb.go:294\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).handleStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:2031\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).handleQuery\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:1785\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).dispatch\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:1359\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).Run\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:1125\ngithub.com/pingcap/tidb/pkg/server.(*Server).onConn\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/server.go:739\ngithub.com/pingcap/errors.AddStack\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20240318064555-6bd07397691f/errors.go:178\ngithub.com/pingcap/errors.Trace\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20240318064555-6bd07397691f/juju_adaptor.go:15\ngithub.com/pingcap/tidb/pkg/store/driver/error.ToTiDBErr\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/driver/error/error.go:200\ngithub.com/pingcap/tidb/pkg/store/copr.(*RegionCache).SplitKeyRangesByLocations\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/region_cache.go:192\ngithub.com/pingcap/tidb/pkg/store/copr.(*RegionCache).SplitKeyRangesByBuckets\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/region_cache.go:234\ngithub.com/pingcap/tidb/pkg/store/copr.buildCopTasks\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:362\ngithub.com/pingcap/tidb/pkg/store/copr.(*CopClient).BuildCopIterator.func3\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:155\ngithub.com/pingcap/tidb/pkg/kv.(*KeyRanges).ForEachPartitionWithErr\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/kv/kv.go:473\ngithub.com/pingcap/tidb/pkg/store/copr.(*CopClient).BuildCopIterator\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:169\ngithub.com/pingcap/tidb/pkg/store/copr.(*CopClient).Send\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/store/copr/coprocessor.go:99\ngithub.com/pingcap/tidb/pkg/distsql.Select\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/distsql/distsql.go:91\ngithub.com/pingcap/tidb/pkg/distsql.SelectWithRuntimeStats\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/distsql/distsql.go:146\ngithub.com/pingcap/tidb/pkg/executor.selectResultHook.SelectResult\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/table_reader.go:70\ngithub.com/pingcap/tidb/pkg/executor.(*TableReaderExecutor).buildResp\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/table_reader.go:416\ngithub.com/pingcap/tidb/pkg/executor.(*TableReaderExecutor).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/table_reader.go:297\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:387\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.(*BaseExecutorV2).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:288\ngithub.com/pingcap/tidb/pkg/executor.(*LimitExec).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/executor.go:1395\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:387\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.(*BaseExecutorV2).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:288\ngithub.com/pingcap/tidb/pkg/executor.(*ProjectionExec).Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/projection.go:88\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.Open\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/internal/exec/executor.go:387\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).openExecutor\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/adapter.go:1243\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).Exec\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/executor/adapter.go:584\ngithub.com/pingcap/tidb/pkg/session.runStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/session/session.go:2289\ngithub.com/pingcap/tidb/pkg/session.(*session).ExecuteStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/session/session.go:2150\ngithub.com/pingcap/tidb/pkg/server.(*TiDBContext).ExecuteStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/driver_tidb.go:294\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).handleStmt\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:2031\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).handleQuery\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:1785\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).dispatch\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:1359\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).Run\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/conn.go:1125\ngithub.com/pingcap/tidb/pkg/server.(*Server).onConn\n\t/home/jenkins/agent/workspace/pingcap/tidb/pull_lightning_integration_test/tidb/pkg/server/server.go:739"]

log-G06 (1).tar.gz

lance6716 commented 1 week ago

can you check it @okJiang

okJiang commented 1 week ago

Sry, I have no idea about this

lance6716 commented 2 days ago

Fixed by https://github.com/pingcap/tidb/pull/54365