Runtime error: index out of range [3] with length 1

translator_bot · June 21, 2024, 4:50am

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: runtime error: index out of range [3] with length 1

| username: CAICAI

[TiDB Usage Environment] Test Environment
[TiDB Version] 7.5.0

Table Structure:

CREATE TABLE `_of_com_mq` (
  `mark` char(35) NOT NULL COMMENT 'Unique message ID (virtual host + queue name + message type + message ID)',
  `vHost` char(50) NOT NULL COMMENT 'Virtual host',
  `queue` char(50) NOT NULL COMMENT 'Queue name',
  `type` char(50) NOT NULL COMMENT 'Message type',
  `msgId` char(100) NOT NULL COMMENT 'Message ID',
  `data` mediumtext NOT NULL COMMENT 'Queue data',
  `syncCount` int(11) NOT NULL COMMENT 'Number of synchronizations',
  `updateTime` timestamp NOT NULL DEFAULT '1999-12-31 16:00:00' COMMENT 'Last update time of the message',
  `createTime` timestamp NOT NULL DEFAULT '1999-12-31 16:00:00' COMMENT 'First creation time of the message',
  `syncLevel` int(11) NOT NULL COMMENT 'Synchronization level, the higher the value, the lower the priority',
  `lockTime` timestamp NOT NULL DEFAULT '1999-12-31 16:00:00' COMMENT 'Lock time, retry every syncLevel * 5 minutes',
  `lockMark` char(35) NOT NULL COMMENT 'Unique ID generated when locked',
  PRIMARY KEY (`type`,`mark`) /*T![clustered_index] CLUSTERED */,
  KEY `Regular Sorting Search` (`type`,`lockTime`,`queue`,`vHost`,`msgId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='Message queue table'
PARTITION BY KEY (`type`)
(PARTITION `p0`,
 PARTITION `p1`,
 PARTITION `p10`,
 PARTITION `p100`,
 PARTITION `p101`,
 PARTITION `p102`,
 PARTITION `p103`,
 PARTITION `p104`,
 PARTITION `p105`,
 PARTITION `p106`,
 PARTITION `p107`,
 PARTITION `p108`,
 PARTITION `p109`,
 PARTITION `p11`,
 PARTITION `p110`,
 PARTITION `p111`,
 PARTITION `p112`,
 PARTITION `p113`,
 PARTITION `p114`,
 PARTITION `p115`,
 PARTITION `p116`,
 PARTITION `p117`,
 PARTITION `p118`,
 PARTITION `p119`,
 PARTITION `p12`,
 PARTITION `p120`,
 PARTITION `p121`,
 PARTITION `p122`,
 PARTITION `p123`,
 PARTITION `p124`,
 PARTITION `p125`,
 PARTITION `p126`,
 PARTITION `p127`,
 PARTITION `p128`,
 PARTITION `p129`,
 PARTITION `p13`,
 PARTITION `p130`,
 PARTITION `p131`,
 PARTITION `p132`,
 PARTITION `p133`,
 PARTITION `p134`,
 PARTITION `p135`,
 PARTITION `p136`,
 PARTITION `p137`,
 PARTITION `p138`,
 PARTITION `p139`,
 PARTITION `p14`,
 PARTITION `p140`,
 PARTITION `p141`,
 PARTITION `p142`,
 PARTITION `p143`,
 PARTITION `p144`,
 PARTITION `p145`,
 PARTITION `p146`,
 PARTITION `p147`,
 PARTITION `p148`,
 PARTITION `p149`,
 PARTITION `p15`,
 PARTITION `p150`,
 PARTITION `p151`,
 PARTITION `p152`,
 PARTITION `p153`,
 PARTITION `p154`,
 PARTITION `p155`,
 PARTITION `p156`,
 PARTITION `p157`,
 PARTITION `p158`,
 PARTITION `p159`,
 PARTITION `p16`,
 PARTITION `p160`,
 PARTITION `p161`,
 PARTITION `p162`,
 PARTITION `p163`,
 PARTITION `p164`,
 PARTITION `p165`,
 PARTITION `p166`,
 PARTITION `p167`,
 PARTITION `p168`,
 PARTITION `p169`,
 PARTITION `p17`,
 PARTITION `p170`,
 PARTITION `p171`,
 PARTITION `p172`,
 PARTITION `p173`,
 PARTITION `p174`,
 PARTITION `p175`,
 PARTITION `p176`,
 PARTITION `p177`,
 PARTITION `p178`,
 PARTITION `p179`,
 PARTITION `p18`,
 PARTITION `p180`,
 PARTITION `p181`,
 PARTITION `p182`,
 PARTITION `p183`,
 PARTITION `p184`,
 PARTITION `p185`,
 PARTITION `p186`,
 PARTITION `p187`,
 PARTITION `p188`,
 PARTITION `p189`,
 PARTITION `p19`,
 PARTITION `p190`,
 PARTITION `p191`,
 PARTITION `p192`,
 PARTITION `p193`,
 PARTITION `p194`,
 PARTITION `p195`,
 PARTITION `p196`,
 PARTITION `p197`,
 PARTITION `p198`,
 PARTITION `p199`,
 PARTITION `p2`,
 PARTITION `p20`,
 PARTITION `p200`,
 PARTITION `p201`,
 PARTITION `p202`,
 PARTITION `p203`,
 PARTITION `p204`,
 PARTITION `p205`,
 PARTITION `p206`,
 PARTITION `p207`,
 PARTITION `p208`,
 PARTITION `p209`,
 PARTITION `p21`,
 PARTITION `p210`,
 PARTITION `p211`,
 PARTITION `p212`,
 PARTITION `p213`,
 PARTITION `p214`,
 PARTITION `p215`,
 PARTITION `p216`,
 PARTITION `p217`,
 PARTITION `p218`,
 PARTITION `p219`,
 PARTITION `p22`,
 PARTITION `p220`,
 PARTITION `p221`,
 PARTITION `p222`,
 PARTITION `p223`,
 PARTITION `p224`,
 PARTITION `p225`,
 PARTITION `p226`,
 PARTITION `p227`,
 PARTITION `p228`,
 PARTITION `p229`,
 PARTITION `p23`,
 PARTITION `p230`,
 PARTITION `p231`,
 PARTITION `p232`,
 PARTITION `p233`,
 PARTITION `p234`,
 PARTITION `p235`,
 PARTITION `p236`,
 PARTITION `p237`,
 PARTITION `p238`,
 PARTITION `p239`,
 PARTITION `p24`,
 PARTITION `p240`,
 PARTITION `p241`,
 PARTITION `p242`,
 PARTITION `p243`,
 PARTITION `p244`,
 PARTITION `p245`,
 PARTITION `p246`,
 PARTITION `p247`,
 PARTITION `p248`,
 PARTITION `p249`,
 PARTITION `p25`,
 PARTITION `p26`,
 PARTITION `p27`,
 PARTITION `p28`,
 PARTITION `p29`,
 PARTITION `p3`,
 PARTITION `p30`,
 PARTITION `p31`,
 PARTITION `p32`,
 PARTITION `p33`,
 PARTITION `p34`,
 PARTITION `p35`,
 PARTITION `p36`,
 PARTITION `p37`,
 PARTITION `p38`,
 PARTITION `p39`,
 PARTITION `p4`,
 PARTITION `p40`,
 PARTITION `p41`,
 PARTITION `p42`,
 PARTITION `p43`,
 PARTITION `p44`,
 PARTITION `p45`,
 PARTITION `p46`,
 PARTITION `p47`,
 PARTITION `p48`,
 PARTITION `p49`,
 PARTITION `p5`,
 PARTITION `p50`,
 PARTITION `p51`,
 PARTITION `p52`,
 PARTITION `p53`,
 PARTITION `p54`,
 PARTITION `p55`,
 PARTITION `p56`,
 PARTITION `p57`,
 PARTITION `p58`,
 PARTITION `p59`,
 PARTITION `p6`,
 PARTITION `p60`,
 PARTITION `p61`,
 PARTITION `p62`,
 PARTITION `p63`,
 PARTITION `p64`,
 PARTITION `p65`,
 PARTITION `p66`,
 PARTITION `p67`,
 PARTITION `p68`,
 PARTITION `p69`,
 PARTITION `p7`,
 PARTITION `p70`,
 PARTITION `p71`,
 PARTITION `p72`,
 PARTITION `p73`,
 PARTITION `p74`,
 PARTITION `p75`,
 PARTITION `p76`,
 PARTITION `p77`,
 PARTITION `p78`,
 PARTITION `p79`,
 PARTITION `p8`,
 PARTITION `p80`,
 PARTITION `p81`,
 PARTITION `p82`,
 PARTITION `p83`,
 PARTITION `p84`,
 PARTITION `p85`,
 PARTITION `p86`,
 PARTITION `p87`,
 PARTITION `p88`,
 PARTITION `p89`,
 PARTITION `p9`,
 PARTITION `p90`,
 PARTITION `p91`,
 PARTITION `p92`,
 PARTITION `p93`,
 PARTITION `p94`,
 PARTITION `p95`,
 PARTITION `p96`,
 PARTITION `p97`,
 PARTITION `p98`,
 PARTITION `p99`)

Data:

INSERT INTO `_of_com_mq`(`mark`, `vHost`, `queue`, `type`, `msgId`, `data`, `syncCount`, `updateTime`, `createTime`, `syncLevel`, `lockTime`, `lockMark`) VALUES ('20428a37c0f6ac61dd86885fca8cc679', 'default', 'ipds', 'analysisOriginalData', '8b36ac42cfe37e0e55744dd38829f2e7', '\"8b36ac42cfe37e0e55744dd38829f2e7\"', 81, '2023-08-18 12:31:50', '2023-08-18 12:31:50', 81, '2023-08-29 19:44:23', '');
INSERT INTO `_of_com_mq`(`mark`, `vHost`, `queue`, `type`, `msgId`, `data`, `syncCount`, `updateTime`, `createTime`, `syncLevel`, `lockTime`, `lockMark`) VALUES ('25467736153374f516dc5f7a79fa9314', 'default', 'ipds', 'analysisOriginalData', 'b0c7fbc7dd9c50572440d6bac893cad6', '\"b0c7fbc7dd9c50572440d6bac893cad6\"', 104, '2023-08-10 05:18:01', '2023-08-10 05:18:01', 104, '2023-08-30 00:45:25', '');
INSERT INTO `_of_com_mq`(`mark`, `vHost`, `queue`, `type`, `msgId`, `data`, `syncCount`, `updateTime`, `createTime`, `syncLevel`, `lockTime`, `lockMark`) VALUES ('68b5fe3e20c6247cc240cb7d1aef85f6', 'default', 'ipds', 'analysisOriginalData', '159b0f2fdb20e975793353f6725bfb07', '\"159b0f2fdb20e975793353f6725bfb07\"', 104, '2023-08-07 02:23:29', '2023-08-07 02:23:29', 104, '2023-08-30 00:43:46', '');
INSERT INTO `_of_com_mq`(`mark`, `vHost`, `queue`, `type`, `msgId`, `data`, `syncCount`, `updateTime`, `createTime`, `syncLevel`, `lockTime`, `lockMark`) VALUES ('73e48bb0cf9f6d0162c9fffd20f4a741', 'default', 'ipds', 'analysisOriginalData', '3212107a282e50b480a888395881a3f4', '\"3212107a282e50b480a888395881a3f4\"', 99, '2023-08-13 18:36:42', '2023-08-13 18:36:42', 97, '2023-08-29 23:29:11', '');
INSERT INTO `_of_com_mq`(`mark`, `vHost`, `queue`, `type`, `msgId`, `data`, `syncCount`, `updateTime`, `createTime`, `syncLevel`, `lockTime`, `lockMark`) VALUES ('7516f2bf72ea7f0b1aaa4d4b4527b45d', 'default', 'ipds', 'analysisOriginalData', '2c80044fb56f660531aa6b2e974f5be7', '\"2c80044fb56f660531aa6b2e974f5be7\"', 105, '2023-08-17 19:04:53', '2023-08-17 19:04:53', 83, '2023-08-29 22:43:02', '');
INSERT INTO `_of_com_mq`(`mark`, `vHost`, `queue`, `type`, `msgId`, `data`, `syncCount`, `updateTime`, `createTime`, `syncLevel`, `lockTime`, `lockMark`) VALUES ('8045c309166863d1ccb636520b44d95e', 'default', 'ipds', 'analysisOriginalData', '98bc496644cdfd1c007abf9df892e05b', '\"98bc496644cdfd1c007abf9df892e05b\"', 133, '2023-08-13 18:43:18', '2023-08-13 18:43:18', 97, '2023-08-29 23:29:16', '');
INSERT INTO `_of_com_mq`(`mark`, `vHost`, `queue`, `type`, `msgId`, `data`, `syncCount`, `updateTime`, `createTime`, `syncLevel`, `lockTime`, `lockMark`) VALUES ('8a563eb6b98317117859c7a7d8ef4a80', 'default', 'ipds', 'analysisOriginalData', 'a00ee55655dfa9fd9e2134de62af5016', '\"a00ee55655dfa9fd9e2134de62af5016\"', 64, '2023-08-22 15:45:30', '2023-08-22 15:45:30', 64, '2023-08-29 19:19:25', '');
INSERT INTO `_of_com_mq`(`mark`, `vHost`, `queue`, `type`, `msgId`, `data`, `syncCount`, `updateTime`, `createTime`, `syncLevel`, `lockTime`, `lockMark`) VALUES ('8ba62e1ca64818f4535d560eb0d97c4e', 'default', 'ipds', 'analysisOriginalData', '63ca6398bccd5b4b4375a3ccece96cf0', '\"63ca6398bccd5b4b4375a3ccece96cf0\"', 104, '2023-08-10 22:42:34', '2023-08-10 22:42:34', 104, '2023-08-30 00:44:16', '');
INSERT INTO `_of_com_mq`(`mark`, `vHost`, `queue`, `type`, `msgId`, `data`, `syncCount`, `updateTime`, `createTime`, `syncLevel`, `lockTime`, `lockMark`) VALUES ('919b1b2e65b9f456a77c75cd68988c2f', 'default', 'ipds', 'analysisOriginalData', '30190e7d07967c73406d43138d5078af', '\"30190e7d07967c73406d43138d5078af\"', 104, '2023-08-10 22:33:51', '2023-08-10 22:33:51', 104, '2023-08-30 00:43:20', '');
INSERT INTO `_of_com_mq`(`mark`, `vHost`, `queue`, `type`, `msgId`, `data`, `syncCount`, `updateTime`, `createTime`, `syncLevel`, `lockTime`, `lockMark`) VALUES ('b2950a83d84b5ece0d6e2ea571defa01', 'default', 'ipds', 'analysisOriginalData', 'e22b7c49083fd1b49fd1de9729838534', '\"e22b7c49083fd1b49fd1de9729838534\"', 81, '2023-08-19 11:47:28', '2023-08-19 11:47:28', 78, '2023-08-29 20:13:32', '');
INSERT INTO `_of_com_mq`(`mark`, `vHost`, `queue`, `type`, `msgId`, `data`, `syncCount`, `updateTime`, `createTime`, `syncLevel`, `lockTime`, `lockMark`) VALUES ('cf7bdc05360dc35d2bb971f6f18a5d39', 'default', 'ipds', 'analysisOriginalData', 'f8100c816ae744b17fb97b91f4ef1751', '\"f8100c816ae744b17fb97b91f4ef1751\"', 85, '2023-08-17 01:45:37', '2023-08-17 01:45:37', 85, '2023-08-30 01:43:01', '');
INSERT INTO `_of_com_mq`(`mark`, `vHost`, `queue`, `type`, `msgId`, `data`, `syncCount`, `updateTime`, `createTime`, `syncLevel`, `lockTime`, `lockMark`) VALUES ('d555fc3b657697b2c7774fe1d277c274', 'default', 'ipds', 'analysisOriginalData', '3e2b4dc2c19bb80907f53c0f505f61a9', '\"3e2b4dc2c19bb80907f53c0f505f61a9\"', 104, '2023-08-10 10:42:16', '2023-08-10 10:42:16', 104, '2023-08-30 00:43:39', '');
INSERT INTO `_of_com_mq`(`mark`, `vHost`, `queue`, `type`, `msgId`, `data`, `syncCount`, `updateTime`, `createTime`, `syncLevel`, `lockTime`, `lockMark`) VALUES ('d849f765c3f76b812a76b12c438af

translator_bot · June 21, 2024, 4:50am

| username: 小龙虾爱大龙虾 | Original post link

It should be a bug

translator_bot · June 21, 2024, 4:50am

| username: tidb菜鸟一只 | Original post link

It’s not surprising to have bugs when it comes to partitioned tables…

translator_bot · June 21, 2024, 4:50am

| username: TiDBer_jYQINSnf | Original post link

Look at the specific TiKV error.

translator_bot · June 21, 2024, 4:50am

| username: aytrack | Original post link

In a key Partition table, when performing a point get query using the Partition key, if the Partition key is not the first column in the table creation, it will cause a panic. You can work around this issue by placing the type column as the first column when creating the table: query key Partition table get panic while Partition Key is not first column · Issue #50698 · pingcap/tidb · GitHub

translator_bot · June 21, 2024, 4:50am

| username: CAICAI | Original post link

Currently, this method works. Moving the partition field to the first column can bypass this issue, but our system has a large number of partitioned tables.

translator_bot · June 21, 2024, 4:50am

| username: oceanzhang | Original post link

This is a bug, check if there is a latest upgrade package.

translator_bot · June 21, 2024, 4:50am

| username: xingzhenxiang | Original post link

It should be a bug

translator_bot · June 21, 2024, 4:50am

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.