Index Building either stuck or super slow

Help
1

I created a new index this morning, very simple and collection has approximately 54k entries, and it’s still says building and it’s been about 4 hours. Is this normal or is something wrong?

    {
  name: "get_fips_by_fips",
  unique: false,
  serialized: true,
  source: "zips2fips",
  terms: [
    {
      field: ["data", "fips"]
    }
  ]
}

Tried refreshing page, tried calling new index and it says “instance not found” and “Index get_fips_by_fips is not active”.

Thanks for any help you can give!

  • Ivan
2

@WillPwn4Food Indexes on such huge collections ( greater than 128 events on all documents in that collection) are built asynchronously. I am not sure if there was any issue in the background task during that time to cause this delay. I can take a look at it provided if you can send me the output of Paginate(Events(Index("get_fips_by_fips"))).

3

Here is the response to that call in the shell:

Paginate(Events(Index(“get_fips_by_fips”)))

{
data: [
{
ts: 1602855370200000,
action: “create”,
document: Index(“get_fips_by_fips”),
data: null
},
{
ts: 1602872575670000,
action: “update”,
document: Index(“get_fips_by_fips”),
data: null
}
]
}

I did another Index on that same collection later in the day after it finally completed as I realized I messed up the first one and this new one also took nearly 4 hours.

  • Ivan
1 Like