Error creating index, possible bug?

SQL++
1 
SELECT  keyspace_id, name, state FROM system:indexes

[
  {
    "keyspace_id": "alfheim",
    "name": "#primary",
    "state": "online"
  },
  {
    "keyspace_id": "midgard",
    "name": "idx_entity_midgard",
    "state": "online"
  },
  {
    "keyspace_id": "midgard",
    "name": "#primary",
    "state": "online"
  }
]

When I try to create an index that I droped and is not currenltly there i get this exception:

CREATE INDEX `idx_entity_alfheim` ON `alfheim`(`type`,`domain`,`updatedAt`)

[
  {
    "code": 5000,
    "msg": "GSI CreateIndex() - cause: Index already exist.  Fail to create idx_entity_alfheim in bucket alfheim",
    "query_from_user": "CREATE INDEX `idx_entity_alfheim` ON `alfheim`(`type`,`domain`,`updatedAt`)"
  }
]

You are running Couchbase Server Community Edition 6.0.0 build 1693.

2

Hi @mmarmol_navent I am not able to reproduce the error that you are seeing. I need some more information to investigate further.

  • Did you see any error when dropping the index idx_entity_alfheim ?
  • Would it be possible to upload logs from your cluster ?

Regards
Mihir

3

I did not see an error on the drop, was done from the we console.
Can you point me on the logs you would like to see?

4

Thanks @mmarmol_navent. Here’s how you should collect logs and upload : https://docs.couchbase.com/server/5.5/clustersetup/ui-logs.html