Skip to content
This repository has been archived by the owner on Jan 28, 2021. It is now read-only.

Problems dropping outdated index #674

Closed
ajnavarro opened this issue Apr 12, 2019 · 0 comments · Fixed by #677
Closed

Problems dropping outdated index #674

ajnavarro opened this issue Apr 12, 2019 · 0 comments · Fixed by #677
Assignees
Labels
bug Something isn't working

Comments

@ajnavarro
Copy link
Contributor

I got the following message from the shell:

WARN[0000] index "blobs_idx" is outdated and will not be used, you can remove it using `DROP INDEX blobs_idx` 

After that, I tried to remove the index using the specified command:

mysql> drop index blobs_idx;
ERROR 1105 (HY000): unknown error: expecting "on" but got "" instead

It throws an error because the table is not specified, So I tried again adding on blobs:

mysql> drop index blobs_idx on blobs;
ERROR 1105 (HY000): unknown error: index "blobs_idx" is still not ready for usage and can't be deleted

I should be able to delete it.

@ajnavarro ajnavarro added the bug Something isn't working label Apr 12, 2019
@erizocosmico erizocosmico self-assigned this Apr 12, 2019
erizocosmico added a commit to erizocosmico/go-mysql-server that referenced this issue Apr 16, 2019
Fixes src-d#674

Status of the index was not being correctly checked, so outdated
indexes could not be dropped.
Also, the message stating you could drop the index was not printing
correct SQL, not it does.

Signed-off-by: Miguel Molina <miguel@erizocosmi.co>
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants