Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Deleted index still showed in the SHOW TAG INDEX STATUS results #2616

Closed
randomJoe211 opened this issue Aug 19, 2021 · 1 comment
Closed
Labels
type/question Type: question about the product

Comments

@randomJoe211
Copy link
Contributor

Nebula Graph version: 2.5.0

I have an index date1_index, and I have rebuilt it once:
image

But even after I dropped this index, the rebuilding history is still there:
image

I submitted a compaction job, but the history is still there. This logic is not good. Will the rebuilding history ever be updated? I think we should clear the history of the dropped indexes.
image

nGQL code:

(root@nebula) [basketballplayer]> SHOW TAG INDEX STATUS;
+------------------------------------+--------------+
| Name                               | Index Status |
+------------------------------------+--------------+
| "date1_index"                      | "FINISHED"   |
+------------------------------------+--------------+
| "basketballplayer_all_tag_indexes" | "FINISHED"   |
+------------------------------------+--------------+
Got 2 rows (time spent 697/1031 us)

Thu, 19 Aug 2021 08:28:07 UTC

(root@nebula) [basketballplayer]> drop tag index date1_index
Execution succeeded (time spent 903/1182 us)

Thu, 19 Aug 2021 08:28:58 UTC

(root@nebula) [basketballplayer]> SHOW TAG INDEX STATUS;
+------------------------------------+--------------+
| Name                               | Index Status |
+------------------------------------+--------------+
| "date1_index"                      | "FINISHED"   |
+------------------------------------+--------------+
| "basketballplayer_all_tag_indexes" | "FINISHED"   |
+------------------------------------+--------------+
Got 2 rows (time spent 621/1015 us)

Thu, 19 Aug 2021 08:29:01 UTC

(root@nebula) [basketballplayer]> drop tag index date1_index
[ERROR (-1005)]: Index not existed!

Thu, 19 Aug 2021 08:29:04 UTC

(root@nebula) [basketballplayer]> SHOW TAG INDEX STATUS;
+------------------------------------+--------------+
| Name                               | Index Status |
+------------------------------------+--------------+
| "date1_index"                      | "FINISHED"   |
+------------------------------------+--------------+
| "basketballplayer_all_tag_indexes" | "FINISHED"   |
+------------------------------------+--------------+
Got 2 rows (time spent 540/890 us)

Thu, 19 Aug 2021 08:29:09 UTC

(root@nebula) [basketballplayer]> SUBMIT JOB COMPACT
+------------+
| New Job Id |
+------------+
| 12         |
+------------+
Got 1 rows (time spent 753/1203 us)

Thu, 19 Aug 2021 08:29:42 UTC

(root@nebula) [basketballplayer]> SHOW JOBS
+--------+---------------------+------------+----------------------------+----------------------------+
| Job Id | Command             | Status     | Start Time                 | Stop Time                  |
+--------+---------------------+------------+----------------------------+----------------------------+
| 12     | "COMPACT"           | "FINISHED" | 2021-08-19T08:29:42.000000 | 2021-08-19T08:29:42.000000 |
+--------+---------------------+------------+----------------------------+----------------------------+
| 11     | "REBUILD_TAG_INDEX" | "FINISHED" | 2021-08-19T08:05:58.000000 | 2021-08-19T08:05:58.000000 |
+--------+---------------------+------------+----------------------------+----------------------------+
| 10     | "REBUILD_TAG_INDEX" | "FINISHED" | 2021-08-19T07:53:53.000000 | 2021-08-19T07:53:53.000000 |
+--------+---------------------+------------+----------------------------+----------------------------+
Got 3 rows (time spent 802/1256 us)

Thu, 19 Aug 2021 08:29:45 UTC

(root@nebula) [basketballplayer]> SHOW TAG INDEX STATUS;
+------------------------------------+--------------+
| Name                               | Index Status |
+------------------------------------+--------------+
| "date1_index"                      | "FINISHED"   |
+------------------------------------+--------------+
| "basketballplayer_all_tag_indexes" | "FINISHED"   |
+------------------------------------+--------------+
Got 2 rows (time spent 625/1012 us)

@CPWstatic CPWstatic transferred this issue from vesoft-inc/nebula-graph Aug 27, 2021
@CPWstatic CPWstatic added the type/question Type: question about the product label Aug 28, 2021
@critical27
Copy link
Contributor

The history won't be update by design. SHOW JOBS literally show all jobs you have submitted, it should not interfere with DDL.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/question Type: question about the product
Projects
None yet
Development

No branches or pull requests

3 participants