Details
-
Bug
-
Resolution: Fixed
-
Minor
-
4.0.0
-
Security Level: Public
-
Build 1767
-
Untriaged
-
Unknown
Description
Trying to create multiple indexes on travel-sample dataset using GSI does not work.
[1] Install 1767
[2] Install Travel-Sample Dataset from UI
[3] Run the following create index statements:
CREATE PRIMARY INDEX on `travel-sample` USING gsi;
CREATE INDEX def_faa ON `travel-sample`(faa) USING gsi;
CREATE INDEX def_icao ON `travel-sample`(icao) USING gsi;
CREATE INDEX def_city ON `travel-sample`(city) USING gsi;
CREATE INDEX def_airportname ON `travel-sample`(airportname) USING gsi;
CREATE INDEX def_type ON `travel-sample`(type) USING gsi;
CREATE INDEX def_sourceairport ON `travel-sample`(sourceairport) USING gsi;
Error: [Error: Query error 5000: GSI CreateIndex() - cause: Fails to create index. Cannot find available node for new index] code: 5000
When Querying CBQ to check for index status after 15 minutes:
select * from system:indexes;
{
"requestID": "2819464a-c740-4268-843c-cb4db8941568",
"signature":
,
"results": [
{
"indexes":
},
{
"indexes":
}
],
"errors": [
,
,
,
,
{ "code": 12014, "msg": "error: Build Already In Progress. Bucket travel-sample. Index def_city([`city`]). Index state: pending" } ],
"status": "errors",
"metrics":
}
Attachments
Issue Links
- relates to
-
MB-14400 Ability to create multiple indexes on same node, same bucket, simultaneously without using deferred build
- Closed