v4.0.13 report inconsistent index handles #24868

seiya-annie · 2021-05-24T14:43:15Z

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

MySQL [tptest]> select txn, seq, stmt, is_query from stmt where test_id = "37b7a23b-af9e-4e8f-82d4-76699d877361";
ERROR 1105 (HY000): inconsistent index PRIMARY handle count 146 isn't equal to value count 0
MySQL [tptest]>

-----------------------------------------------------------------------------------------------------------------------------------------------------------+
| stmt | CREATE TABLE stmt (
test_id char(36) NOT NULL,
seq int(11) NOT NULL,
txn int(11) NOT NULL,
stmt text NOT NULL,
is_query tinyint(1) DEFAULT NULL,
PRIMARY KEY (test_id,seq)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

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

3. What did you see instead (Required)

[2021/05/24 22:28:35.006 +08:00] [ERROR] [distsql.go:1044] ["inconsistent index handles"] [conn=10] [index=PRIMARY] [index_cnt=146] [table_cnt=0] [missing_handles="[612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049,612489557912322049]"] ...
[2021/05/24 22:28:35.007 +08:00] [INFO] [conn.go:800] ["command dispatched failed"] [conn=10] [connInfo="id:10, addr:172.16.5.197:38870 status:11, collation:utf8mb4_general_ci, user:root"] [command=Execute] [status="inTxn:1, autocommit:1"] [sql="select txn, seq, stmt, is_query from stmt where test_id = ? order by txn, seq [arguments: 37b7a23b-af9e-4e8f-82d4-76699d877361]"] [txn_mode=PESSIMISTIC] [err="inconsistent index PRIMARY handle count 146 isn't equal to value count 0\ngithub.com/pingcap/tidb/executor.(*tableWorker).executeTask\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/distsql.go:1051\ngithub.com/pingcap/tidb/executor.(*tableWorker).pickAndExecTask\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/distsql.go:867\ngithub.com/pingcap/tidb/executor.(*IndexLookUpExecutor).startTableWorker.func1\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/distsql.go:524\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1357\nselect txn, seq, stmt, is_query from stmt where test_id = ? order by txn, seq [arguments: 37b7a23b-af9e-4e8f-82d4-76699d877361]"]

4. What is your TiDB version? (Required)

| Release Version: v4.0.13
Edition: Community
Git Commit Hash: 57fa70a
Git Branch: heads/refs/tags/v4.0.13
UTC Build Time: 2021-05-24 09:13:43
GoVersion: go1.13
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |

The text was updated successfully, but these errors were encountered:

cfzjywxk · 2021-05-25T05:34:32Z

The distsql index fetch, the result _tidb_row are the same value which is unexpected.

cfzjywxk · 2021-05-25T05:42:30Z

The reproduce steps:

tidb config

alter-primary-key = true
enable-streaming = true
enable-telemetry = false
graceful-wait-before-shutdown = 1
mem-quota-query = 100000000000
new_collations_enabled_on_first_bootstrap = true
oom-action = "cancel"
oom-use-tmp-storage = false
repair-mode = true
skip-register-to-dashboard = false
tmp-storage-quota = 8000000

[experimental]
allow-expression-index = true

[performance]
feedback-probability = 0.05
gogc = 80
max-memory = 5000
max-txn-ttl = 600000
memory-usage-alarm-ratio = 0.9
query-feedback-limit = 1024
server-memory-quota = 0
txn-entry-size-limit = 6291456

[prepared-plan-cache]
enabled = true

[stmt-summary]
enable-internal-query = true

[tikv-client]
enable-chunk-rpc = false
store-liveness-timeout = "2s"
[tikv-client.copr-cache]
admission-max-ranges = 500
admission-max-result-mb = 10.0
admission-min-process-ms = 5
capacity-mb = 100.0

CREATE TABLE `test2` (
  `id` char(36) NOT NULL,
  `init_sql` longtext NOT NULL,
  `status` varchar(20) DEFAULT NULL,
  `started_at` bigint(20) DEFAULT '0',
  `finished_at` bigint(20) DEFAULT '0',
  `message` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
INSERT INTO `test2` VALUES ('fd9ea675-d43d-4074-8ef6-8e0055c12339','[\"create table t ( c_int int, c_str varchar(40), c_datetime datetime, c_timestamp timestamp, c_double double, c_decimal decimal(12, 6) , primary key(c_int) , key(c_int)  , unique key(c_decimal) , unique key(c_datetime) , key(c_timestamp) )\",\"insert into t values (1, \'recursing goldwasser\', \'2020-03-06 06:19:45\', \'2020-03-27 01:35:47\', 44.680726, 7.144), (2, \'admiring margulis\', \'2020-04-16 23:52:08\', \'2020-02-02 10:01:47\', 75.788191, 0.997), (3, \'agitated gates\', \'2020-06-25 22:41:14\', \'2020-02-13 11:16:48\', 49.133758, 4.141), (4, \'recursing keller\', \'2020-02-19 11:02:17\', \'2020-05-28 09:45:47\', 87.865977, 3.806), (5, \'condescending taussig\', \'2020-04-15 00:57:08\', \'2020-04-04 01:45:56\', 48.598808, 6.240)\",\"insert into t values (6, \'flamboyant neumann\', \'2020-03-09 16:05:27\', \'2020-05-17 10:24:49\', 50.150235, 5.808), (7, \'gracious swirles\', \'2020-06-08 00:05:46\', \'2020-03-18 19:11:58\', 86.934100, 1.949), (8, \'interesting lalande\', \'2020-03-28 02:15:21\', \'2020-03-11 17:41:51\', 60.289298, 6.275), (9, \'dreamy williams\', \'2020-03-15 01:40:49\', \'2020-01-09 01:04:52\', 41.895596, 3.385), (10, \'great swirles\', \'2020-04-23 01:14:28\', \'2020-01-21 10:54:57\', 73.971361, 0.030)\",\"insert into t values (11, \'sleepy dirac\', \'2020-04-25 18:28:33\', \'2020-02-06 12:24:51\', 35.142892, 0.058), (12, \'angry shaw\', \'2020-05-07 00:31:47\', \'2020-06-19 07:00:26\', 98.180213, 5.910), (13, \'flamboyant kowalevski\', \'2020-01-02 05:46:09\', \'2020-01-01 16:29:32\', 89.494881, 8.910), (14, \'sharp galileo\', \'2020-01-15 23:32:59\', \'2020-02-08 20:53:28\', 4.895611, 3.359), (15, \'ecstatic lamarr\', \'2020-03-04 16:59:43\', \'2020-04-18 02:38:54\', 64.485448, 0.548)\"]','Pending',0,0,NULL);

admin check table test2;

cfzjywxk · 2021-05-25T05:46:53Z

Without the new_collations_enabled_on_first_bootstrap configurations, there is no error report for admin check.

cfzjywxk · 2021-05-25T06:06:04Z

v4.0.12 could reproduce this issue using the configuration mentioned above.

Release Version: v4.0.12
Edition: Community
Git Commit Hash: 11a9254bec522c1991033a6098f6dccadc6eb7c1

wjhuang2016 · 2021-05-25T06:16:31Z

Without the new_collations_enabled_on_first_bootstrap configurations, there is no error report for admin check.

enable-streaming = true is also needed.

wjhuang2016 · 2021-05-25T07:43:45Z

It has been fixed in master and 5.0 by #20220

wjhuang2016 · 2021-05-25T11:18:00Z

It's caused by streaming which we don't want to use again. FYI: #20759

cfzjywxk · 2021-05-25T13:09:57Z

@seiya-annie @wjhuang2016
I think we need a PR to disable the configurations related to the to be deprecated feature ASAP, since there's still chance users may enable it mistakenly and get encounter such errors.

/cc @zz-jason

seiya-annie · 2021-05-26T03:23:21Z

hi, i closed enable-streaming and reload tidb:
[2021/05/25 21:04:06.229 +08:00] [INFO] [printer.go:33] ["Welcome to TiDB."] ["Release Version"=v4.0.13]
and run tptest continue, still report panic with :
2021/05/25 21:27:41.957 +08:00] [ERROR] [conn.go:727] ["connection running loop panic"] [conn=222] [lastSQL="select * from t1 where c_timestamp in (select c_timestamp from t2 where c_int in (8, 9, 10)) for update"] [err="runtime error: index out of range [7] with length 0"] [stack="goroutine 329138 [running]:\ngithub.com/pingcap/tidb/server.(*clientConn).Run.func1(0x38d2c20, 0xc0019e8090, 0xc000fe6000)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:725 +0xee\npanic(0x3177940, 0xc001872000)\n\t/usr/local/go/src/runtime/panic.go:679 +0x1b2\ngithub.com/pingcap/tidb/executor.(*ExecStmt).Exec.func1(0xc0017854a0, 0xc001042b98, 0xc001042b78)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/adapter.go:300 +0x50c\npanic(0x3177940, 0xc001872000)\n\t/usr/local/go/src/runtime/panic.go:679 +0x1b2\nencoding/binary.littleEndian.PutUint64(...)\n\t/usr/local/go/src/encoding/binary/binary.go:82\ngithub.com/pingcap/tidb/util/chunk.MutRow.SetDatum(0xc0017fe000, 0x0, 0x1, 0x1, 0x0, 0x0, 0x0, 0x9, 0x0, 0x0, ...)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/util/chunk/mutrow.go:294 +0x744\ngithub.com/pingcap/tidb/util/chunk.MutRow.SetDatums(0xc0017fe000, 0x0, 0xc0017b8000, 0x8, 0x8)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/util/chunk/mutrow.go:281 +0xe6\ngithub.com/pingcap/tidb/table/tables.(*partitionedTable).locateRangePartition(0xc0015fdce0, 0x391a220, 0xc0008fa280, 0xc000387570, 0xc0017b8000, 0x8, 0x8, 0x0, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/table/tables/partition.go:428 +0x4cc\ngithub.com/pingcap/tidb/table/tables.(*partitionedTable).locatePartition(0xc0015fdce0, 0x391a220, 0xc0008fa280, 0xc000387570, 0xc0017b8000, 0x8, 0x8, 0x0, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/table/tables/partition.go:355 +0x9a\ngithub.com/pingcap/tidb/table/tables.(*partitionedTable).GetPartitionByRow(0xc0015fdce0, 0x391a220, 0xc0008fa280, 0xc0017b8000, 0x8, 0x8, 0x8, 0x8, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/table/tables/partition.go:518 +0x8d\ngithub.com/pingcap/tidb/executor.(*SelectLockExec).Next(0xc00171fd40, 0x38d2c20, 0xc0015533e0, 0xc00173b720, 0x2330b46, 0xc001a88778)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/executor.go:916 +0x445\ngithub.com/pingcap/tidb/executor.Next(0x38d2c20, 0xc0015533e0, 0x38dcfa0, 0xc00171fd40, 0xc00173b720, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/executor.go:262 +0x225\ngithub.com/pingcap/tidb/executor.(*ProjectionExec).unParallelExecute(0xc00177d440, 0x38d2c20, 0xc0015533e0, 0xc0014a0780, 0x0, 0x2802946e0e900)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/projection.go:193 +0xac\ngithub.com/pingcap/tidb/executor.(*ProjectionExec).Next(0xc00177d440, 0x38d2c20, 0xc0015533e0, 0xc0014a0780, 0x11b8968, 0x70)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/projection.go:179 +0x73\ngithub.com/pingcap/tidb/executor.Next(0x38d2c20, 0xc0015533e0, 0x38dcda0, 0xc00177d440, 0xc0014a0780, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/executor.go:262 +0x225\ngithub.com/pingcap/tidb/executor.(*ExecStmt).runPessimisticSelectForUpdate(0xc0017854a0, 0x38d2c20, 0xc0015533e0, 0x38dcda0, 0xc00177d440, 0x0, 0x0, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/adapter.go:485 +0x28a\ngithub.com/pingcap/tidb/executor.(*ExecStmt).handlePessimisticSelectForUpdate(0xc0017854a0, 0x38d2c20, 0xc0015533e0, 0x38dcda0, 0xc00177d440, 0x54f40c0, 0xc0002feb03, 0x0, 0x2a27f77)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/adapter.go:466 +0x5d\ngithub.com/pingcap/tidb/executor.(*ExecStmt).Exec(0xc0017854a0, 0x38d2c20, 0xc0015533e0, 0x0, 0x0, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-build-t"]

[2021/05/26 11:16:22.758 +08:00] [ERROR] [projection.go:456] ["projection executor panicked"] [error="runtime error: index out of range [7] with length 7"] [stack="goroutine 901780 [running]:\ngithub.com/pingcap/tidb/util.GetStack(...)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/util/misc.go:75\ngithub.com/pingcap/tidb/executor.recoveryProjection(0xc001360f30, 0x3177940, 0xc001966100)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/projection.go:455 +0x90\ngithub.com/pingcap/tidb/executor.(*projectionInputFetcher).run.func1(0xc00147ef80, 0xc000fe23e0)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/projection.go:357 +0x82\npanic(0x3177940, 0xc001966100)\n\t/usr/local/go/src/runtime/panic.go:679 +0x1b2\ngithub.com/pingcap/tidb/util/chunk.MutRow.SetDatum(0xc0012eca00, 0x0, 0x7, 0x1, 0x0, 0x0, 0x0, 0xa, 0x0, 0x0, ...)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/util/chunk/mutrow.go:287 +0x750\ngithub.com/pingcap/tidb/util/chunk.MutRow.SetDatums(0xc0012eca00, 0x0, 0xc00024e480, 0xe, 0xe)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/util/chunk/mutrow.go:281 +0xe6\ngithub.com/pingcap/tidb/table/tables.(*partitionedTable).locateRangePartition(0xc000ecbe40, 0x391a220, 0xc00124ab40, 0xc001680a10, 0xc00024e480, 0xe, 0xe, 0x0, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/table/tables/partition.go:428 +0x4cc\ngithub.com/pingcap/tidb/table/tables.(*partitionedTable).locatePartition(0xc000ecbe40, 0x391a220, 0xc00124ab40, 0xc001680a10, 0xc00024e480, 0xe, 0xe, 0x0, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/table/tables/partition.go:355 +0x9a\ngithub.com/pingcap/tidb/table/tables.(*partitionedTable).GetPartitionByRow(0xc000ecbe40, 0x391a220, 0xc00124ab40, 0xc00024e480, 0xe, 0xe, 0xe, 0xe, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/table/tables/partition.go:518 +0x8d\ngithub.com/pingcap/tidb/executor.(*SelectLockExec).Next(0xc001e55680, 0x38d2c20, 0xc001f88330, 0xc001e67a90, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/executor.go:916 +0x445\ngithub.com/pingcap/tidb/executor.Next(0x38d2c20, 0xc001f88330, 0x38dcfa0, 0xc001e55680, 0xc001e67a90, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-buil

cfzjywxk · 2021-05-26T04:39:27Z

hi, i closed enable-streaming and reload tidb:
[2021/05/25 21:04:06.229 +08:00] [INFO] [printer.go:33] ["Welcome to TiDB."] ["Release Version"=v4.0.13]
and run tptest continue, still report panic with :
2021/05/25 21:27:41.957 +08:00] [ERROR] [conn.go:727] ["connection running loop panic"] [conn=222] [lastSQL="select * from t1 where c_timestamp in (select c_timestamp from t2 where c_int in (8, 9, 10)) for update"] [err="runtime error: index out of range [7] with length 0"] [stack="goroutine 329138 [running]:\ngithub.com/pingcap/tidb/server.(*clientConn).Run.func1(0x38d2c20, 0xc0019e8090, 0xc000fe6000)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:725 +0xee\npanic(0x3177940, 0xc001872000)\n\t/usr/local/go/src/runtime/panic.go:679 +0x1b2\ngithub.com/pingcap/tidb/executor.(*ExecStmt).Exec.func1(0xc0017854a0, 0xc001042b98, 0xc001042b78)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/adapter.go:300 +0x50c\npanic(0x3177940, 0xc001872000)\n\t/usr/local/go/src/runtime/panic.go:679 +0x1b2\nencoding/binary.littleEndian.PutUint64(...)\n\t/usr/local/go/src/encoding/binary/binary.go:82\ngithub.com/pingcap/tidb/util/chunk.MutRow.SetDatum(0xc0017fe000, 0x0, 0x1, 0x1, 0x0, 0x0, 0x0, 0x9, 0x0, 0x0, ...)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/util/chunk/mutrow.go:294 +0x744\ngithub.com/pingcap/tidb/util/chunk.MutRow.SetDatums(0xc0017fe000, 0x0, 0xc0017b8000, 0x8, 0x8)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/util/chunk/mutrow.go:281 +0xe6\ngithub.com/pingcap/tidb/table/tables.(*partitionedTable).locateRangePartition(0xc0015fdce0, 0x391a220, 0xc0008fa280, 0xc000387570, 0xc0017b8000, 0x8, 0x8, 0x0, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/table/tables/partition.go:428 +0x4cc\ngithub.com/pingcap/tidb/table/tables.(*partitionedTable).locatePartition(0xc0015fdce0, 0x391a220, 0xc0008fa280, 0xc000387570, 0xc0017b8000, 0x8, 0x8, 0x0, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/table/tables/partition.go:355 +0x9a\ngithub.com/pingcap/tidb/table/tables.(*partitionedTable).GetPartitionByRow(0xc0015fdce0, 0x391a220, 0xc0008fa280, 0xc0017b8000, 0x8, 0x8, 0x8, 0x8, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/table/tables/partition.go:518 +0x8d\ngithub.com/pingcap/tidb/executor.(*SelectLockExec).Next(0xc00171fd40, 0x38d2c20, 0xc0015533e0, 0xc00173b720, 0x2330b46, 0xc001a88778)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/executor.go:916 +0x445\ngithub.com/pingcap/tidb/executor.Next(0x38d2c20, 0xc0015533e0, 0x38dcfa0, 0xc00171fd40, 0xc00173b720, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/executor.go:262 +0x225\ngithub.com/pingcap/tidb/executor.(*ProjectionExec).unParallelExecute(0xc00177d440, 0x38d2c20, 0xc0015533e0, 0xc0014a0780, 0x0, 0x2802946e0e900)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/projection.go:193 +0xac\ngithub.com/pingcap/tidb/executor.(*ProjectionExec).Next(0xc00177d440, 0x38d2c20, 0xc0015533e0, 0xc0014a0780, 0x11b8968, 0x70)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/projection.go:179 +0x73\ngithub.com/pingcap/tidb/executor.Next(0x38d2c20, 0xc0015533e0, 0x38dcda0, 0xc00177d440, 0xc0014a0780, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/executor.go:262 +0x225\ngithub.com/pingcap/tidb/executor.(*ExecStmt).runPessimisticSelectForUpdate(0xc0017854a0, 0x38d2c20, 0xc0015533e0, 0x38dcda0, 0xc00177d440, 0x0, 0x0, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/adapter.go:485 +0x28a\ngithub.com/pingcap/tidb/executor.(*ExecStmt).handlePessimisticSelectForUpdate(0xc0017854a0, 0x38d2c20, 0xc0015533e0, 0x38dcda0, 0xc00177d440, 0x54f40c0, 0xc0002feb03, 0x0, 0x2a27f77)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/adapter.go:466 +0x5d\ngithub.com/pingcap/tidb/executor.(*ExecStmt).Exec(0xc0017854a0, 0x38d2c20, 0xc0015533e0, 0x0, 0x0, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-build-t"]

[2021/05/26 11:16:22.758 +08:00] [ERROR] [projection.go:456] ["projection executor panicked"] [error="runtime error: index out of range [7] with length 7"] [stack="goroutine 901780 [running]:\ngithub.com/pingcap/tidb/util.GetStack(...)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/util/misc.go:75\ngithub.com/pingcap/tidb/executor.recoveryProjection(0xc001360f30, 0x3177940, 0xc001966100)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/projection.go:455 +0x90\ngithub.com/pingcap/tidb/executor.(*projectionInputFetcher).run.func1(0xc00147ef80, 0xc000fe23e0)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/projection.go:357 +0x82\npanic(0x3177940, 0xc001966100)\n\t/usr/local/go/src/runtime/panic.go:679 +0x1b2\ngithub.com/pingcap/tidb/util/chunk.MutRow.SetDatum(0xc0012eca00, 0x0, 0x7, 0x1, 0x0, 0x0, 0x0, 0xa, 0x0, 0x0, ...)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/util/chunk/mutrow.go:287 +0x750\ngithub.com/pingcap/tidb/util/chunk.MutRow.SetDatums(0xc0012eca00, 0x0, 0xc00024e480, 0xe, 0xe)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/util/chunk/mutrow.go:281 +0xe6\ngithub.com/pingcap/tidb/table/tables.(*partitionedTable).locateRangePartition(0xc000ecbe40, 0x391a220, 0xc00124ab40, 0xc001680a10, 0xc00024e480, 0xe, 0xe, 0x0, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/table/tables/partition.go:428 +0x4cc\ngithub.com/pingcap/tidb/table/tables.(*partitionedTable).locatePartition(0xc000ecbe40, 0x391a220, 0xc00124ab40, 0xc001680a10, 0xc00024e480, 0xe, 0xe, 0x0, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/table/tables/partition.go:355 +0x9a\ngithub.com/pingcap/tidb/table/tables.(*partitionedTable).GetPartitionByRow(0xc000ecbe40, 0x391a220, 0xc00124ab40, 0xc00024e480, 0xe, 0xe, 0xe, 0xe, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/table/tables/partition.go:518 +0x8d\ngithub.com/pingcap/tidb/executor.(*SelectLockExec).Next(0xc001e55680, 0x38d2c20, 0xc001f88330, 0xc001e67a90, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/executor.go:916 +0x445\ngithub.com/pingcap/tidb/executor.Next(0x38d2c20, 0xc001f88330, 0x38dcfa0, 0xc001e55680, 0xc001e67a90, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/optimization-buil

@seiya-annie
Maybe open another issue for it?

wshwsh12 · 2021-06-24T06:20:13Z

enable-streaming has been deprecated in #20760

ti-srebot · 2021-07-15T09:03:38Z

Please edit this comment or add a new comment to complete the following information

Not a bug

Remove the 'type/bug' label
Add notes to indicate why it is not a bug

Duplicate bug

Add the 'type/duplicate' label
Add the link to the original bug

Bug

Note: Make Sure that 'component', and 'severity' labels are added
Example for how to fill out the template: #20100

1. Root Cause Analysis (RCA) (optional)

2. Symptom (optional)

3. All Trigger Conditions (optional)

4. Workaround (optional)

5. Affected versions

6. Fixed versions

seiya-annie added type/bug The issue is confirmed as a bug. severity/critical labels May 24, 2021

cfzjywxk assigned wjhuang2016 May 25, 2021

cfzjywxk added the sig/sql-infra SIG: SQL Infra label May 25, 2021

wjhuang2016 removed their assignment May 25, 2021

seiya-annie added severity/moderate and removed severity/critical labels May 25, 2021

cfzjywxk added severity/major and removed severity/moderate labels May 25, 2021

cfzjywxk added the sig/execution SIG execution label May 25, 2021

ichn-hu mentioned this issue May 25, 2021

Welcome to contribute #20804

Closed

cfzjywxk assigned XuHuaiyu May 28, 2021

wshwsh12 assigned wshwsh12 and unassigned XuHuaiyu Jun 24, 2021

wshwsh12 mentioned this issue Jul 2, 2021

config, sessionctx: deprecate streaming config #25906

Merged

ti-chi-bot closed this as completed in #25906 Jul 15, 2021

ti-srebot added the need-more-info label Jul 15, 2021

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

v4.0.13 report inconsistent index handles #24868

v4.0.13 report inconsistent index handles #24868

seiya-annie commented May 24, 2021

cfzjywxk commented May 25, 2021

cfzjywxk commented May 25, 2021 •

edited

Loading

cfzjywxk commented May 25, 2021

cfzjywxk commented May 25, 2021

wjhuang2016 commented May 25, 2021

wjhuang2016 commented May 25, 2021

wjhuang2016 commented May 25, 2021

cfzjywxk commented May 25, 2021

seiya-annie commented May 26, 2021

cfzjywxk commented May 26, 2021

wshwsh12 commented Jun 24, 2021

ti-srebot commented Jul 15, 2021

v4.0.13 report inconsistent index handles #24868

v4.0.13 report inconsistent index handles #24868

Comments

seiya-annie commented May 24, 2021

Bug Report

1. Minimal reproduce step (Required)

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

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

cfzjywxk commented May 25, 2021

cfzjywxk commented May 25, 2021 • edited Loading

cfzjywxk commented May 25, 2021

cfzjywxk commented May 25, 2021

wjhuang2016 commented May 25, 2021

wjhuang2016 commented May 25, 2021

wjhuang2016 commented May 25, 2021

cfzjywxk commented May 25, 2021

seiya-annie commented May 26, 2021

cfzjywxk commented May 26, 2021

wshwsh12 commented Jun 24, 2021

ti-srebot commented Jul 15, 2021

Please edit this comment or add a new comment to complete the following information

Not a bug

Duplicate bug

Bug

1. Root Cause Analysis (RCA) (optional)

2. Symptom (optional)

3. All Trigger Conditions (optional)

4. Workaround (optional)

5. Affected versions

6. Fixed versions

cfzjywxk commented May 25, 2021 •

edited

Loading