| 912847 | usera | 192.168.2.11 | aa | Query | 2068 | 2 | admin check table aa | 0 | 04-23 21:33:11.284(424459577926352951) |
processlist 存在 这个 我直接kill tidb id了
好 我执行看看
您这面的 表结构能提供一下吗 。show create table。
另外麻烦到 tidb 的日志中搜索一下关键字 inconsistent index handles
[2021/04/23 11:04:01.878 +08:00] [ERROR] [distsql.go:986] [“inconsistent index handles”] [conn=1524807] [index=idx_groupID_customerID] [index_cnt=121] [table_cnt=0] [missing_handles=“[267833816,271764617,271765279,271765386,271765815,271766349,271766409,271766949,271767301,271767446,271788362,271788372,271788537,271788599,271789215,271789710,271789879,271790078,271790132,271790360,271790889,271790986,271791113,271791145,271791469,271791582,271791878,271791928,271792045,271792101,271792345,271815307,271815520,271815749,271815912,271815965,271815998,271816299,271816915,271817237,271817431,271817683,271817785,271817807,271818642,271818673,271837588,271837619,271837907,271838350,271838374,271838536,271838918,271839386,271839403,271839473,271839649,271839766,271839796,271840001,271840022,271840056,271840133,271840222,271840246,271840944,271861018,271861320,271861392,271861569,271861931,271862010,271862228,271862373,271862588,271862764,271862801,271862871,271862956,271863091,271863100,271863109,271863561,271863581,271863594,271863808,271863965,271863999,271887745,271887802,271887830,271887980,271888106,271888140,271888279,271888298,271888302,271888380,271888425,271888539,271889313,271889488,271889530,271889669,271889677,271889980,271889988,271890003,271890096,271890123,271890596,271890757,271891180,271891843,277654105,284969414,288664916,323330273,330443499,330549399,347884158]”] [total_handles=“[267833816,271764617,271765279,271765386,271765815,271766349,271766409,271766949,271767301,271767446,271788362,271788372,271788537,271788599,271789215,271789710,271789879,271790078,271790132,271790360,271790889,271790986,271791113,271791145,271791469,271791582,271791878,271791928,271792045,271792101,271792345,271815307,271815520,271815749,271815912,271815965,271815998,271816299,271816915,271817237,271817431,271817683,271817785,271817807,271818642,271818673,271837588,271837619,271837907,271838350,271838374,271838536,271838918,271839386,271839403,271839473,271839649,271839766,271839796,271840001,271840022,271840056,271840133,271840222,271840246,271840944,271861018,271861320,271861392,271861569,271861931,271862010,271862228,271862373,271862588,271862764,271862801,271862871,271862956,271863091,271863100,271863109,271863561,271863581,271863594,271863808,271863965,271863999,271887745,271887802,271887830,271887980,271888106,271888140,271888279,271888298,271888302,271888380,271888425,271888539,271889313,271889488,271889530,271889669,271889677,271889980,271889988,271890003,271890096,271890123,271890596,271890757,271891180,271891843,277654105,284969414,288664916,323330273,330443499,330549399,347884158]”]
[2021/04/23 11:04:01.879 +08:00] [ERROR] [distsql.go:986] [“inconsistent index handles”] [conn=1524807] [index=idx_groupID_customerID] [index_cnt=218] [table_cnt=0] [missing_handles=“[267833816,271764617,271764814,271764919,271765435,271765436,271765815,271766349,271766407,271766949,271766951,271767045,271767164,271767397,271767446,271767453,271788182,271788372,271788537,271788599,271788673,271789215,271789438,271789655,271789710,271789879,271790132,271790332,271790351,271790360,271790889,271790986,271791425,271791582,271791613,271791870,271791928,271792045,271792101,271815307,271815749,271815918,271815998,271816189,271816455,271816485,271816665,271816834,271817237,271817431,271817467,271817504,271817687,271817785,271817807,271818502,271818521,271818642,271819148,271837588,271837619,271838165,271838350,271838536,271838681,271839766,271839796,271840056,271840078,271840131,271840716,271840800,271840993,271861320,271861931,271861996,271862010,271862228,271862588,271862764,271862801,271862841,271862956,271863047,271863091,271863100,271863109,271863594,271863965,271864322,271864355,271864417,271887770,271887980,271887983,271888279,271888539,271889313,271889360,271889488,271889669,271889980,271889988,271890096,271890164,271890388,271890405,271891180,271891415,271891444,271891608,271891824,271891843,271892231,271892414,273277641,273564568,277584296,277603477,277654105,280979478,281060113,281837216,281838821,283834312,284287752,284407427,284410828,284531815,284969414,288657893,288664916,288709326,288726743,288870923,290948078,291911271,292018463,292076029,292144587,292145565,292331563,294843740,295051077,297504745,298324922,298363125,298365513,298471534,302800301,302941012,303810912,304943092,305483758,305830931,306891773,308229799,308256118,308256418,308263344,308399303,310956697,324202656,324266277,324286070,324338318,324342221,324448246,324553392,325562685,325620863,328002752,328106419,330443499,330494017,330549399,330577142,330577519,330579155,330580690,330601263,330622899,330699502,330825204,333006712,334562784,334594832,334682018,334757875,334758840,334784164,334784497,334785589,334787153,334818539,334841894,334871625,334872149,334897119,335128195,335487491,336006562,336579115,336875705,336934542,337178138,337197455,337280031,337305732,337825759,337929671,337979626,337979933,340651076,342435444,342793909,347884158,351085763]”] [total_handles=“[267833816,271764617,271764814,271764919,271765435,271765436,271765815,271766349,271766407,271766949,271766951,271767045,271767164,271767397,271767446,271767453,271788182,271788372,271788537,271788599,271788673,271789215,271789438,271789655,271789710,271789879,271790132,271790332,271790351,271790360,271790889,271790986,271791425,271791582,271791613,271791870,271791928,271792045,271792101,271815307,271815749,271815918,271815998,271816189,271816455,271816485,271816665,271816834,271817237,271817431,271817467,271817504,271817687,271817785,271817807,271818502,271818521,271818642,271819148,271837588,271837619,271838165,271838350,271838536,271838681,271839766,271839796,271840056,271840078,271840131,271840716,271840800,271840993,271861320,271861931,271861996,271862010,271862228,271862588,271862764,271862801,271862841,271862956,271863047,271863091,271863100,271863109,271863594,271863965,271864322,271864355,271864417,271887770,271887980,271887983,271888279,271888539,271889313,271889360,271889488,271889669,271889980,271889988,271890096,271890164,271890388,271890405,271891180,271891415,271891444,271891608,271891824,271891843,271892231,271892414,273277641,273564568,277584296,277603477,277654105,280979478,281060113,281837216,281838821,283834312,284287752,284407427,284410828,284531815,284969414,288657893,288664916,288709326,288726743,288870923,290948078,291911271,292018463,292076029,292144587,292145565,292331563,294843740,295051077,297504745,298324922,298363125,298365513,298471534,302800301,302941012,303810912,304943092,305483758,305830931,306891773,308229799,308256118,308256418,308263344,308399303,310956697,324202656,324266277,324286070,324338318,324342221,324448246,324553392,325562685,325620863,328002752,328106419,330443499,330494017,330549399,330577142,330577519,330579155,330580690,330601263,330622899,330699502,330825204,333006712,334562784,334594832,334682018,334757875,334758840,334784164,334784497,334785589,334787153,334818539,334841894,334871625,334872149,334897119,335128195,335487491,336006562,336579115,336875705,336934542,337178138,337197455,337280031,337305732,337825759,337929671,337979626,337979933,340651076,342435444,342793909,347884158,351085763]”]
[2021/04/23 11:15:19.929 +08:00] [ERROR] [distsql.go:986] [“inconsistent index handles”] [conn=1525441] [index=idx_groupID_customerID] [index_cnt=204] [table_cnt=38] [missing_handles=“[199122672,199124752,199124813,199124858,199124861,199124882,199124925,199125006,199125056,199125349,199125414,199125431,199125451,199125536,199125588,199125599,199125610,199125611,199125714,199125878,199125918,199125924,199125993,199126010,199126270,199126277,199126292,199126314,199126375,199126385,199126414,199126462,199126484,199126494,199126511,199126578,199126626,199126627,199126635,199126657,199126662,199126663,199126666,199126668,199126805,199126807,199126816,199126824,199126897,199127272,199127277,199127362,199127407,199127449,199127597,199127623,199127628,199127670,199127955,199128051,199128790,199128795,199128796,199128846,199128954,199128968,199128972,199129003,199129031,199129047,199129135,199129182,199129212,199129346,199129447,199129464,199129479,199129520,199129543,199129585,199129595,199129596,199129834,199180691,199369577,199496720,199534422,199535467,199764920,199946498,200703806,207924381,208673192,209605082,209675672,211307982,211814318,212749972,213573994,214962738,214971910,215005702,215268579,215283535,215390454,215583634,215742755,215768250,215994827,216100645,216490999,216628617,216668720,216669043,217948082,218185991,218834596,218934669,219285217,219431447,222558077,223660915,226321550,231099930,235834938,237104503,249116515,249445172,252295926,253269904,255738264,256177073,256197458,257120722,257217069,257831205,257841893,258141970,258361610,260082688,262180724,262493743,262672227,265861750,266279612,267266534,267563969,267587139,273274209,273436719,275414359,275577851,279129585,279426225,282118131,290100995,293743355,294613459,298408321,298439134,298599798,298661067,298661104,298661295,298680475,298681089]”] [total_handles=“[199122672,199124752,199124813,199124858,199124861,199124882,199124925,199125006,199125056,199125349,199125414,199125431,199125451,199125536,199125588,199125599,199125610,199125611,199125714,199125878,199125918,199125924,199125993,199126010,199126270,199126277,199126292,199126314,199126375,199126385,199126414,199126462,199126484,199126494,199126511,199126578,199126626,199126627,199126635,199126657,199126662,199126663,199126666,199126668,199126805,199126807,199126816,199126824,199126897,199127272,199127277,199127362,199127407,199127449,199127597,199127623,199127628,199127670,199127955,199128051,199128790,199128795,199128796,199128846,199128954,199128968,199128972,199129003,199129031,199129047,199129135,199129182,199129212,199129346,199129447,199129464,199129479,199129520,199129543,199129585,199129595,199129596,199129834,199180691,199369577,199496720,199534422,199535467,199764920,199946498,200703806,207924381,208673192,209605082,209675672,211307982,211814318,212749972,213573994,214962738,214971910,215005702,215268579,215283535,215390454,215583634,215742755,215768250,215994827,216100645,216490999,216628617,216668720,216669043,217948082,218185991,218834596,218934669,219285217,219431447,222558077,223660915,226321550,231099930,235834938,237104503,249116515,249445172,252295926,253269904,255738264,256177073,256197458,257120722,257217069,257831205,257841893,258141970,258361610,260082688,262180724,262493743,262672227,265861750,266279612,267266534,267563969,267587139,273274209,273436719,275414359,275577851,279129585,279426225,282118131,290100995,293743355,294613459,298408321,298439134,298599798,298661067,298661104,298661295,298680475,298681089,298813228,298826598,299136311,299183539,299188955,299259509,299279110,300452851,300726636,300968720,301022749,301025618,301038185,301510416,301716969,302035104,302051503,302090459,302183865,302467993,302678459,309232824,309621421,311924916,316672204,330494128,333898187,344265070,344619691,344646513,349864433,349922748,359228848,359231236,359237429,359248274,359262783,360116661]”]
[2021/04/23 11:29:50.327 +08:00] [ERROR] [distsql.go:986] [“inconsistent index handles”] [conn=1526245] [index=idx_groupID_customerID] [index_cnt=363] [table_cnt=325] [missing_handles=“[308323722,308346077,308346442,308530113,308569288,308575620,308582610,308593268,308633052,308668952,308725309,308755104,308762281,308798226,308827462,308843206,308923129,308935103,308964304,309010312,309046174,309117732,309117848,309145655,309147126,309335721,309367000,309369593,309454576,309481544,309516027,309533737,309660476,309889159,309911828,309937952,309948855,309969308]”] [total_handles=“[308323722,308346077,308346442,308530113,308569288,308575620,308582610,308593268,308633052,308668952,308725309,308755104,308762281,308798226,308827462,308843206,308923129,308935103,308964304,309010312,309046174,309117732,309117848,309145655,309147126,309335721,309367000,309369593,309454576,309481544,309516027,309533737,309660476,309889159,309911828,309937952,309948855,309969308,309971872,310019221,310028952,310036937,310113504,310126354,310162054,310168890,310532427,310567292,310771269,310804589,310808649,310905422,311199201,311253777,311263680,311469171,311608064,311621862,311857455,311992030,312149703,312280074,312307835,312311639,312316675,312461814,312492542,312495977,312507464,312522152,312544933,312552664,312728843,313089747,313127427,313189134,313316839,313318928,313332336,313545876,313592531,314229930,314514019,314521994,314784200,314847982,315139142,315241046,315370439,315862751,315911023,315941350,316078446,316149268,316259809,316290984,316442659,316611103,317006448,317157777,317374631,317470600,317485684,317674359,317694991,319070189,321429429,321430068,321458446,321459245,321462627,321487292,321488603,321488760,321489495,321516723,321517881,321545131,321545602,321546459,321599763,321786132,321989574,322011159,322416492,322750921,322998225,323123866,323175459,323188240,323550577,323580104,323896857,323919891,324123721,324384906,324535997,324653113,324678900,324736692,324908024,324928858,324974995,324981258,325170128,325298540,325544742,325910981,326470610,326492043,326952075,327678251,328204281,328344946,328387008,328443079,328579493,328649319,330533476,330692535,330838278,331164824,331213386,331263031,332574297,332903537,332977255,333327099,333364105,333584690,333638458,334015253,334032609,334268177,334286302,334406982,334527202,334569473,334694875,334846009,334933323,335134244,335422290,335447656,335640462,335644415,335698230,335876752,335895524,335965143,335992860,336130622,336161210,336275134,336503086,336670016,336682229,336874968,337061243,337070571,337178543,337510532,337606633,337640302,337928598,337969762,338163253,338556735,338676169,338695891,338795640,338875502,338990593,339111803,339120036,339158816,339205812,339247526,339278539,339289878,339321027,339323766,339351396,339383929,339461468,339512545,339694947,339796172,339904860,339995780,340001704,340014322,340204903,340305545,340338868,340463275,340543116,342498351,342552756,342612819,342623102,342924497,342941913,343014467,343155810,343555166,343740834,343753353,343754402,343755599,343826561,343910941,344066833,344118385,344127020,344261714,344304636,344345252,344413691,344438451,344688260,344969290,345050164,345163401,345197971,345502609,345574648,345711782,345874994,345958363,346049745,346379351,346443023,346536385,347677515,347779346,347972554,348135505,348173395,348300381,348349747,348392288,348393985,348652777,348667937,348678218,349039259,349182347,349186478,349373038,349468492,349584526,349602718,349622660,349945995,350065185,350102445,350371244,350471974,350553931,350556213,350569142,350786943,350799850,350807647,350940966,350985446,351099913,351142853,351213524,351391680,351471447,351489198,351510920,351532353,351569883,351573748,351612644,351650347,351741890,351941154,352120113,352159950,352464139,352544584,359300070,359481902,360064000,360316208,360511710,360520744,360586349,360586729,360677046,360694814,360705329,360729028,361428865,361672759,361843763,361860637,361878294,361936504,361967038,361979669,362011166,362035529,362342715,362412894,362445518,362471362,362517541,362579661,362669531,362719114,363014557,363044503,363392376,363967428,363989812,363993727,364247058,364419163]”]
[2021/04/23 12:18:58.067 +08:00] [ERROR] [distsql.go:986] [“inconsistent index handles”] [conn=1528279] [index=idx_groupID_cardTypeID] [index_cnt=1] [table_cnt=0] [missing_handles=“[15865177]”] [total_handles=“[15865177]”]
表结构提供一下。
已经提供 发群里了
admin check index 这个已经执行很久 ，继续执行吗
ERROR 1105 (HY000): table count 22084543248 != index(idx_groupID_shopID_reportDate_saasOrderKey) count 22084782660
执行了一个晚上还没结束，这个能有办法看进度吗？
admin show ddl jobs 应该有进度
V3.0.19 验证过了 没进度的
可以根据 row count 的变化估算一下。如果需要进度，可以提需求，多谢。
请问这个最后是怎么解决的呢？
这个最后是怎么解决的，大佬帮助一下我。
我也遇到了这样的场景，
[Err] 1105 - inconsistent index ncayu_scdcd handle count 20480 isn’t equal to value count 9344
集群一般使用force index来指定，先重建下索引，随便取一个名字，添加好后把旧的rename 了 ，，新的rename成旧的索引名字
集群出什么异常了？导致数据丢失
此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。