MySQL [oceanbase]> select * from CDB_OB_MAJOR_COMPACTION; +-----------+---------------------+----------------------------+----------------------+---------------------+----------------------------+----------------------------+------------+----------+--------------+------+ | TENANT_ID | FROZEN_SCN | FROZEN_TIME | GLOBAL_BROADCAST_SCN | LAST_SCN | LAST_FINISH_TIME | START_TIME | STATUS | IS_ERROR | IS_SUSPENDED | INFO | +-----------+---------------------+----------------------------+----------------------+---------------------+----------------------------+----------------------------+------------+----------+--------------+------+ | 1 | 1720461604258304868 | 2024-07-09 02:00:04.258305 | 1720461604258304868 | 1720461604258304868 | 2024-07-09 02:02:48.807203 | 2024-07-09 02:00:04.350306 | IDLE | NO | NO | | | 1001 | 1720461602946099865 | 2024-07-09 02:00:02.946100 | 1720461602946099865 | 1720461602946099865 | 2024-07-09 02:01:36.920571 | 2024-07-09 02:00:02.978812 | IDLE | NO | NO | | | 1002 | 1720461604751333021 | 2024-07-09 02:00:04.751333 | 1720461604751333021 | 1720461604751333021 | 2024-07-09 02:08:40.013661 | 2024-07-09 02:00:04.786864 | IDLE | NO | NO | | | 1003 | 1720461603582450409 | 2024-07-09 02:00:03.582450 | 1720461603582450409 | 1720461603582450409 | 2024-07-09 02:03:18.496328 | 2024-07-09 02:00:03.628461 | IDLE | NO | NO | | | 1004 | 1720461602036096072 | 2024-07-09 02:00:02.036096 | 1720461602036096072 | 1720461602036096072 | 2024-07-09 03:55:42.272195 | 2024-07-09 02:00:02.079717 | IDLE | NO | NO | | | 1005 | 1720461602125828456 | 2024-07-09 02:00:02.125828 | 1720461602125828456 | 1720461602125828456 | 2024-07-09 02:02:06.841824 | 2024-07-09 02:00:02.185275 | IDLE | NO | NO | | | 1006 | 1720461600392570691 | 2024-07-09 02:00:00.392571 | 1720461600392570691 | 1720461600392570691 | 2024-07-09 02:03:33.959745 | 2024-07-09 02:00:00.416073 | IDLE | NO | NO | | | 1007 | 1720461600118558700 | 2024-07-09 02:00:00.118559 | 1720461600118558700 | 1720461600118558700 | 2024-07-09 02:02:58.404706 | 2024-07-09 02:00:00.142309 | IDLE | NO | NO | | | 1008 | 1720461604121059659 | 2024-07-09 02:00:04.121060 | 1720461604121059659 | 1720461604121059659 | 2024-07-09 02:03:48.744554 | 2024-07-09 02:00:04.182268 | IDLE | NO | NO | | | 1009 | 1720461600655406743 | 2024-07-09 02:00:00.655407 | 1720461600655406743 | 1720461600655406743 | 2024-07-09 02:02:55.013889 | 2024-07-09 02:00:00.676123 | IDLE | NO | NO | | | 1010 | 1720461603089947846 | 2024-07-09 02:00:03.089948 | 1720461603089947846 | 1720461603089947846 | 2024-07-09 02:02:59.905727 | 2024-07-09 02:00:03.131289 | IDLE | NO | NO | | | 1011 | 1720461604476140174 | 2024-07-09 02:00:04.476140 | 1720461604476140174 | 1720461604476140174 | 2024-07-09 02:02:29.285990 | 2024-07-09 02:00:04.540337 | IDLE | NO | NO | | | 1012 | 1720461603684142115 | 2024-07-09 02:00:03.684142 | 1720461603684142115 | 1720461603684142115 | 2024-07-09 02:04:52.344756 | 2024-07-09 02:00:03.715082 | IDLE | NO | NO | | | 1013 | 1720461600926320098 | 2024-07-09 02:00:00.926320 | 1720461600926320098 | 1720461600926320098 | 2024-07-09 02:01:55.718777 | 2024-07-09 02:00:00.968423 | IDLE | NO | NO | | | 1014 | 1720461600496713368 | 2024-07-09 02:00:00.496713 | 1720461600496713368 | 1720461600496713368 | 2024-07-09 02:02:59.827981 | 2024-07-09 02:00:00.521713 | IDLE | NO | NO | | | 1015 | 1720461600990411557 | 2024-07-09 02:00:00.990412 | 1720461600990411557 | 1720461600990411557 | 2024-07-09 02:00:34.920742 | 2024-07-09 02:00:01.010905 | IDLE | NO | NO | | | 1016 | 1720461601103983649 | 2024-07-09 02:00:01.103984 | 1720461601103983649 | 1720461601103983649 | 2024-07-09 02:03:19.130115 | 2024-07-09 02:00:01.127257 | IDLE | NO | NO | | | 1019 | 1720461600692551185 | 2024-07-09 02:00:00.692551 | 1720461600692551185 | 1720461600692551185 | 2024-07-09 02:02:35.307463 | 2024-07-09 02:00:00.713134 | IDLE | NO | NO | | | 1020 | 1720461600044124373 | 2024-07-09 02:00:00.044124 | 1720461600044124373 | 1720461600044124373 | 2024-07-09 02:01:43.932904 | 2024-07-09 02:00:00.073909 | IDLE | NO | NO | | | 1021 | 1720461600955549675 | 2024-07-09 02:00:00.955550 | 1720461600955549675 | 1720461600955549675 | 2024-07-09 02:01:55.677645 | 2024-07-09 02:00:00.976433 | IDLE | NO | NO | | | 1022 | 1720461603259802483 | 2024-07-09 02:00:03.259802 | 1720461603259802483 | 1720461603259802483 | 2024-07-09 02:04:25.235563 | 2024-07-09 02:00:03.306916 | IDLE | NO | NO | | | 1023 | 1720461603155815782 | 2024-07-09 02:00:03.155816 | 1720461603155815782 | 1720461603155815782 | 2024-07-09 02:01:37.691893 | 2024-07-09 02:00:03.181042 | IDLE | NO | NO | | | 1024 | 1720461602268853614 | 2024-07-09 02:00:02.268854 | 1720461602268853614 | 1720461602268853614 | 2024-07-09 02:02:55.514714 | 2024-07-09 02:00:02.304686 | IDLE | NO | NO | | | 1025 | 1720461604946974497 | 2024-07-09 02:00:04.946974 | 1720461604946974497 | 1720461604946974497 | 2024-07-09 02:03:39.421236 | 2024-07-09 02:00:04.971335 | IDLE | NO | NO | | | 1026 | 1720461602779260206 | 2024-07-09 02:00:02.779260 | 1720461602779260206 | 1720461602779260206 | 2024-07-09 02:04:13.951947 | 2024-07-09 02:00:02.821681 | IDLE | NO | NO | | | 1027 | 1720461603800544612 | 2024-07-09 02:00:03.800545 | 1720461603800544612 | 1720461603800544612 | 2024-07-09 02:01:57.546574 | 2024-07-09 02:00:03.825216 | IDLE | NO | NO | | | 1028 | 1720461603283329950 | 2024-07-09 02:00:03.283330 | 1720461603283329950 | 1720461603283329950 | 2024-07-09 02:04:16.794692 | 2024-07-09 02:00:03.313583 | IDLE | NO | NO | | | 1029 | 1720461600291663740 | 2024-07-09 02:00:00.291664 | 1720461600291663740 | 1720461600291663740 | 2024-07-09 02:01:44.567569 | 2024-07-09 02:00:00.327192 | IDLE | NO | NO | | | 1030 | 1720461601737315563 | 2024-07-09 02:00:01.737316 | 1720461601737315563 | 1720461601737315563 | 2024-07-09 02:02:35.648768 | 2024-07-09 02:00:01.763373 | IDLE | NO | NO | | | 1031 | 1720461732740568309 | 2024-07-09 02:02:12.740568 | 1720461732740568309 | 1720461732740568309 | 2024-07-09 02:04:18.353120 | 2024-07-09 02:02:12.826294 | IDLE | NO | NO | | | 1032 | 1720461603092118628 | 2024-07-09 02:00:03.092119 | 1720461603092118628 | 1720375201308555499 | 2024-07-08 05:00:12.659183 | 2024-07-09 02:00:03.468341 | COMPACTING | NO | NO | | | 1033 | 1720461602416171130 | 2024-07-09 02:00:02.416171 | 1720461602416171130 | 1720461602416171130 | 2024-07-09 02:02:57.362223 | 2024-07-09 02:00:02.446500 | IDLE | NO | NO | | | 1034 | 1720461602660441766 | 2024-07-09 02:00:02.660442 | 1720461602660441766 | 1720461602660441766 | 2024-07-09 02:03:22.590845 | 2024-07-09 02:00:02.687193 | IDLE | NO | NO | | | 1035 | 1720461603422223490 | 2024-07-09 02:00:03.422223 | 1720461603422223490 | 1720461603422223490 | 2024-07-09 02:03:38.131109 | 2024-07-09 02:00:03.445345 | IDLE | NO | NO | | | 1036 | 1720461604237337578 | 2024-07-09 02:00:04.237338 | 1720461604237337578 | 1720461604237337578 | 2024-07-09 02:03:51.301727 | 2024-07-09 02:00:04.266082 | IDLE | NO | NO | | | 1037 | 1720461601465137306 | 2024-07-09 02:00:01.465137 | 1720461601465137306 | 1720461601465137306 | 2024-07-09 02:01:55.528608 | 2024-07-09 02:00:01.483310 | IDLE | NO | NO | | | 1038 | 1720461603334843335 | 2024-07-09 02:00:03.334843 | 1720461603334843335 | 1720461603334843335 | 2024-07-09 02:11:03.983116 | 2024-07-09 02:00:03.359566 | IDLE | NO | NO | | | 1041 | 1720461602827888724 | 2024-07-09 02:00:02.827889 | 1720461602827888724 | 1720461602827888724 | 2024-07-09 02:02:06.931320 | 2024-07-09 02:00:02.860479 | IDLE | NO | NO | | | 1042 | 1720461604132931794 | 2024-07-09 02:00:04.132932 | 1720461604132931794 | 1720461604132931794 | 2024-07-09 02:03:49.075661 | 2024-07-09 02:00:04.172562 | IDLE | NO | NO | | | 1043 | 1720461603632688404 | 2024-07-09 02:00:03.632688 | 1720461603632688404 | 1720461603632688404 | 2024-07-09 02:02:37.723641 | 2024-07-09 02:00:03.665323 | IDLE | NO | NO | | | 1044 | 1720461604164060671 | 2024-07-09 02:00:04.164061 | 1720461604164060671 | 1720461604164060671 | 2024-07-09 02:02:47.662452 | 2024-07-09 02:00:04.189943 | IDLE | NO | NO | | | 1047 | 1720461602855046221 | 2024-07-09 02:00:02.855046 | 1720461602855046221 | 1720461602855046221 | 2024-07-09 02:02:47.492841 | 2024-07-09 02:00:02.899784 | IDLE | NO | NO | | | 1048 | 1720461604068235168 | 2024-07-09 02:00:04.068235 | 1720461604068235168 | 1720461604068235168 | 2024-07-09 02:08:17.590874 | 2024-07-09 02:00:04.102043 | IDLE | NO | NO | | | 1049 | 1720461603012542744 | 2024-07-09 02:00:03.012543 | 1720461603012542744 | 1720461603012542744 | 2024-07-09 02:02:27.521359 | 2024-07-09 02:00:03.065116 | IDLE | NO | NO | | | 1050 | 1720461602624167731 | 2024-07-09 02:00:02.624168 | 1720461602624167731 | 1720461602624167731 | 2024-07-09 02:02:46.591255 | 2024-07-09 02:00:02.658373 | IDLE | NO | NO | | | 1061 | 1720461602830693266 | 2024-07-09 02:00:02.830693 | 1720461602830693266 | 1720461602830693266 | 2024-07-09 02:02:47.585866 | 2024-07-09 02:00:02.853846 | IDLE | NO | NO | | | 1062 | 1720461601550745051 | 2024-07-09 02:00:01.550745 | 1720461601550745051 | 1720461601550745051 | 2024-07-09 02:03:22.273574 | 2024-07-09 02:00:01.574305 | IDLE | NO | NO | | | 1065 | 1720461604324414777 | 2024-07-09 02:00:04.324415 | 1720461604324414777 | 1720461604324414777 | 2024-07-09 02:02:18.393334 | 2024-07-09 02:00:04.350482 | IDLE | NO | NO | | | 1066 | 1720461600102389279 | 2024-07-09 02:00:00.102389 | 1720461600102389279 | 1720461600102389279 | 2024-07-09 02:04:13.416960 | 2024-07-09 02:00:00.122574 | IDLE | NO | NO | | | 1067 | 1720461601572192739 | 2024-07-09 02:00:01.572193 | 1720461601572192739 | 1720461601572192739 | 2024-07-09 02:02:15.379748 | 2024-07-09 02:00:01.594732 | IDLE | NO | NO | | | 1068 | 1720461604050674659 | 2024-07-09 02:00:04.050675 | 1720461604050674659 | 1720461604050674659 | 2024-07-09 02:09:57.003582 | 2024-07-09 02:00:04.141837 | IDLE | NO | NO | | | 1069 | 1720461601153639708 | 2024-07-09 02:00:01.153640 | 1720461601153639708 | 1720461601153639708 | 2024-07-09 02:01:55.330822 | 2024-07-09 02:00:01.199152 | IDLE | NO | NO | | | 1070 | 1720461604292123967 | 2024-07-09 02:00:04.292124 | 1720461604292123967 | 1720461604292123967 | 2024-07-09 02:03:29.462178 | 2024-07-09 02:00:04.324565 | IDLE | NO | NO | | | 1075 | 1720461600592937225 | 2024-07-09 02:00:00.592937 | 1720461600592937225 | 1720461600592937225 | 2024-07-09 02:02:54.399036 | 2024-07-09 02:00:00.611656 | IDLE | NO | NO | | | 1076 | 1720461600249971631 | 2024-07-09 02:00:00.249972 | 1720461600249971631 | 1720461600249971631 | 2024-07-09 02:02:40.459053 | 2024-07-09 02:00:00.304100 | IDLE | NO | NO | | | 1077 | 1720461600055487454 | 2024-07-09 02:00:00.055487 | 1720461600055487454 | 1720461600055487454 | 2024-07-09 02:01:44.218545 | 2024-07-09 02:00:00.075911 | IDLE | NO | NO | | | 1078 | 1720461602714543153 | 2024-07-09 02:00:02.714543 | 1720461602714543153 | 1720461602714543153 | 2024-07-09 02:03:17.022406 | 2024-07-09 02:00:02.743817 | IDLE | NO | NO | | | 1079 | 1720461603664299461 | 2024-07-09 02:00:03.664299 | 1720461603664299461 | 1720461603664299461 | 2024-07-09 02:01:47.889072 | 2024-07-09 02:00:03.684295 | IDLE | NO | NO | | | 1080 | 1720461601684475980 | 2024-07-09 02:00:01.684476 | 1720461601684475980 | 1720461601684475980 | 2024-07-09 02:02:35.921027 | 2024-07-09 02:00:01.710283 | IDLE | NO | NO | | | 1083 | 1720461603201506853 | 2024-07-09 02:00:03.201507 | 1720461603201506853 | 1720461603201506853 | 2024-07-09 02:02:17.625942 | 2024-07-09 02:00:03.236732 | IDLE | NO | NO | | | 1084 | 1720461601420444154 | 2024-07-09 02:00:01.420444 | 1720461601420444154 | 1720461601420444154 | 2024-07-09 02:04:40.826321 | 2024-07-09 02:00:01.477735 | IDLE | NO | NO | | | 1085 | 1720461601335363486 | 2024-07-09 02:00:01.335363 | 1720461601335363486 | 1720461601335363486 | 2024-07-09 02:01:55.478454 | 2024-07-09 02:00:01.352267 | IDLE | NO | NO | | | 1086 | 1720461600498162934 | 2024-07-09 02:00:00.498163 | 1720461600498162934 | 1720461600498162934 | 2024-07-09 02:04:04.467405 | 2024-07-09 02:00:00.523904 | IDLE | NO | NO | | | 1089 | 1720461602031780223 | 2024-07-09 02:00:02.031780 | 1720461602031780223 | 1720461602031780223 | 2024-07-09 02:02:46.189024 | 2024-07-09 02:00:02.056160 | IDLE | NO | NO | | | 1090 | 1720461603122263179 | 2024-07-09 02:00:03.122263 | 1720461603122263179 | 1720461603122263179 | 2024-07-09 02:03:09.377128 | 2024-07-09 02:00:03.158223 | IDLE | NO | NO | | | 1091 | 1720461602328340770 | 2024-07-09 02:00:02.328341 | 1720461602328340770 | 1720461602328340770 | 2024-07-09 02:02:26.548010 | 2024-07-09 02:00:02.347169 | IDLE | NO | NO | | | 1092 | 1720461600510547433 | 2024-07-09 02:00:00.510547 | 1720461600510547433 | 1720461600510547433 | 2024-07-09 02:03:23.963828 | 2024-07-09 02:00:00.533572 | IDLE | NO | NO | | | 1095 | 1720461600769460561 | 2024-07-09 02:00:00.769461 | 1720461600769460561 | 1720461600769460561 | 2024-07-09 02:01:24.621324 | 2024-07-09 02:00:00.790111 | IDLE | NO | NO | | | 1096 | 1720461602583507905 | 2024-07-09 02:00:02.583508 | 1720461602583507905 | 1720461602583507905 | 2024-07-09 02:03:41.584147 | 2024-07-09 02:00:02.608447 | IDLE | NO | NO | | | 1099 | 1720461600348851641 | 2024-07-09 02:00:00.348852 | 1720461600348851641 | 1720461600348851641 | 2024-07-09 02:02:44.346030 | 2024-07-09 02:00:00.373192 | IDLE | NO | NO | | | 1100 | 1720461603107588426 | 2024-07-09 02:00:03.107588 | 1720461603107588426 | 1720461603107588426 | 2024-07-09 02:03:06.020229 | 2024-07-09 02:00:03.136844 | IDLE | NO | NO | | | 1101 | 1720461603405214761 | 2024-07-09 02:00:03.405215 | 1720461603405214761 | 1720461603405214761 | 2024-07-09 02:01:48.239230 | 2024-07-09 02:00:03.425645 | IDLE | NO | NO | | | 1102 | 1720461601238369824 | 2024-07-09 02:00:01.238370 | 1720461601238369824 | 1720461601238369824 | 2024-07-09 02:16:44.426059 | 2024-07-09 02:00:01.307962 | IDLE | NO | NO | | +-----------+---------------------+----------------------------+----------------------+---------------------+----------------------------+----------------------------+------------+----------+--------------+------+ 73 rows in set (0.39 sec) MySQL [oceanbase]> select count(*) from GV$OB_COMPACTION_PROGRESS where tenant_id = 1032 and compaction_scn = 1720461603092118628 and STATUS != 'FINISH'; +----------+ | count(*) | +----------+ | 1 | +----------+ 1 row in set (0.02 sec) MySQL [oceanbase]> select * from GV$OB_COMPACTION_DIAGNOSE_INFO; +---------------+----------+-----------+--------------+---------------------+---------------------+--------+----------------------------+------------------------------------------------------------------------------+ | SVR_IP | SVR_PORT | TENANT_ID | TYPE | LS_ID | TABLET_ID | STATUS | CREATE_TIME | DIAGNOSE_INFO | +---------------+----------+-----------+--------------+---------------------+---------------------+--------+----------------------------+------------------------------------------------------------------------------+ | 10.172.146.97 | 2882 | 1032 | MEDIUM_MERGE | 9223372036854775807 | 9223372036854775807 | FAILED | 2024-07-08 14:48:08.013998 | schedule_suspect_info="info="refresh ls locality cache failed";errno=-4016;" | +---------------+----------+-----------+--------------+---------------------+---------------------+--------+----------------------------+------------------------------------------------------------------------------+ 1 row in set (20.96 sec) MySQL [oceanbase]> select * from GV$OB_TABLET_COMPACTION_PROGRESS; +---------------+----------+-----------+--------------+-------+---------------------+---------------------+-----------------------------------+--------------+-------------+----------------------+------------------------------+----------------------------+----------------------------+----------------------------+ | SVR_IP | SVR_PORT | TENANT_ID | TYPE | LS_ID | TABLET_ID | COMPACTION_SCN | TASK_ID | STATUS | DATA_SIZE | UNFINISHED_DATA_SIZE | PROGRESSIVE_COMPACTION_ROUND | CREATE_TIME | START_TIME | ESTIMATED_FINISH_TIME | +---------------+----------+-----------+--------------+-------+---------------------+---------------------+-----------------------------------+--------------+-------------+----------------------+------------------------------+----------------------------+----------------------------+----------------------------+ | 10.172.146.89 | 2882 | 1004 | MINOR_MERGE | 1003 | 206453 | 0 | YB420AAC9259-000609B7971C1046-0-0 | NODE_RUNNING | 17537487912 | 13727236096 | 0 | 2024-07-09 11:41:26.327462 | 2024-07-09 11:41:30.506088 | 2024-07-10 11:41:30.506088 | | 10.172.146.97 | 2882 | 1048 | MEDIUM_MERGE | 1001 | 282684 | 1720494846612590717 | YB420AAC9261-000609B109BC3E6C-0-0 | NODE_RUNNING | 34946228 | 34945864 | 1 | 2024-07-09 11:42:02.349463 | 2024-07-09 11:42:02.349487 | 2024-07-09 11:46:17.017079 | | 10.172.146.97 | 2882 | 1048 | MEDIUM_MERGE | 1002 | 282689 | 1720494910837094542 | YB420AAC9261-000609B109BC3E6D-0-0 | NODE_RUNNING | 7373577 | 7373433 | 1 | 2024-07-09 11:42:02.558496 | 2024-07-09 11:42:02.558521 | 2024-07-09 11:45:02.299236 | | 10.172.146.97 | 2882 | 1048 | MEDIUM_MERGE | 1002 | 282692 | 1720494930976966834 | YB420AAC9261-000609B109BC3E70-0-0 | NODE_RUNNING | 22247759 | 22247468 | 1 | 2024-07-09 11:42:02.914140 | 2024-07-09 11:42:02.914185 | 2024-07-09 11:50:39.086537 | | 10.172.146.97 | 2882 | 1048 | MEDIUM_MERGE | 1002 | 1152921504606929864 | 1720494910837094542 | YB420AAC9261-000609B109BC3E71-0-0 | NODE_RUNNING | 4050813 | 4050734 | 1 | 2024-07-09 11:42:02.952454 | 2024-07-09 11:42:02.952477 | 2024-07-09 11:44:46.352762 | | 10.172.146.98 | 2882 | 1004 | MEDIUM_MERGE | 1002 | 207354 | 1720496467441541916 | YB420AAC9262-00060A0946CED8B3-0-0 | NODE_RUNNING | 153700303 | 55244936 | 1 | 2024-07-09 11:41:57.141990 | 2024-07-09 11:41:57.142011 | 2024-07-09 12:09:04.293046 | +---------------+----------+-----------+--------------+-------+---------------------+---------------------+-----------------------------------+--------------+-------------+----------------------+------------------------------+----------------------------+----------------------------+----------------------------+ 6 rows in set (0.05 sec)