I’m programmatically creating primary indexes for collections - these indexes are created by a test.
Above created primary indexes can not be deleted either through the UI or through Query.
I’m programmatically creating primary indexes for collections - these indexes are created by a test.
Above created primary indexes can not be deleted either through the UI or through Query.
Track via MB-39609
UI trying to send the drop on bucket vs collection. In mean time use explicit drop statement mentioned below.
This is named primary index. Can you try the following thing.
DROP INDEX `default-default-cihcs-Parent_c-primary` ON `default`.`default`.`cihcs-Parent_c`;
DROP INDEX `default`.`default`.`cihcs-Parent_c`.`default-default-cihcs-Parent_c-primary`;
Also checkout about specific index present or not (in query)
select * from system:indexes;
select * from system:all_indexes;
Check indexes status in indexer.
curl -v user:pass@indexerhost:9102/getIndexStatus
Thanks, below worked:
DROP INDEX `default-default-cihcs-Parent_c-primary` ON `default`.`default`.`cihcs-Parent_c`;