strange, it looks to be done, but

facet

value is still

false

for my field (i modified it to be

true

)

It could have failed due to a validation error... Are you on Typesense Cloud? If so could you email your cluster ID to support at typesense dot org and we can take a closer look

I just tried it again, but after 30 seconds the request timed out and then it displayed the "Another collection update operation is in progress." error

Got it. Here's the error I see in your cluster's logs when altering the orders collection:

Alter failed validation: Referenced document having `id: xxxxxx` not found in the collection `customer`

oh, that's odd. maybe a customer account was removed or merged but the associated order was not updated properly.

I don't have access to the cloud clusters. Only Kishore or Jason can help you with it.

okay, thanks for letting me know

Found the bugged document using the following approach: Collect all the customer ids using the export endpoint like,

curl -H "X-TYPESENSE-API-KEY: ${TYPESENSE_API_KEY}" -X GET \
    "<http://localhost:8108/collections/customer/documents/export?include_fields=id>"

Then send this query to the

order

collection:

curl "<http://localhost:8108/multi_search?query_by=name>" \
        -X POST \
        -H "Content-Type: application/json" \
        -H "X-TYPESENSE-API-KEY: ${TYPESENSE_API_KEY}" \
        -d '{
          "searches": [
            {
              "collection": "order",
              "filter_by": "customer.id: !=[<all of the ids from previous step>]"
            }
          ]
        }'

Using

multi_search

endpoint will not limit the size of your request.

yes, @Harpreet Sangar was a life-saver, thanks 😁