"CREATE INDEX" jobs show as pending, "SHOW INDEXES" says they exist


(J. David Lee) #1


We are seeing an issue where jobs that are creating indexes (CREATE INDEX ON...) are being shown in the Pending state by both the web interface and SHOW JOBS query. Some of these were created many days ago. At the same time, SHOW INDEXES queries indicate that the indexes exist. The associated tables are not large: a few MB at most currently.

We are running v2.1.4 on a dedicated cluster (not virtualized).

This doesn’t seem to be causing any issues, but I wanted to check that it was either known about or expected.

Thank you for your help,