Hey all, I just tried to update a field on my coll...
# community-helpy
Yoshi Gillaspie
10/12/2023, 6:25 PMHey all, I just tried to update a field on my collection in order to change it to sort: true, but having done so seems to have crashed Typesense. Latency is way up, and is always times out. Monitoring says it’s still healthy though…
j
Jason Bosco
10/12/2023, 6:27 PMDoing an in-place schema migration is a blocking operation... So all reads / writes will be blocked until the operation is complete
Jason Bosco
10/12/2023, 6:28 PMWe've improved this in the upcoming version of Typesense (v0.26) so it only blocks writes
Jason Bosco
10/12/2023, 6:28 PMUntil then, I'd recommend using the alias method to change the collection schema in a zero downtime way
Jason Bosco
10/12/2023, 6:28 PMJason Bosco
10/12/2023, 6:29 PMFor the issue at hand, I can confirm that the nodes are still executing the alter command
y
Yoshi Gillaspie
10/12/2023, 6:29 PMI see…ok. How long does this operation generally take to complete for a collection of ~900k elements?
Yoshi Gillaspie
10/12/2023, 6:29 PMAnd do you have a general target of when 0.26 will be released?
j
Jason Bosco
10/12/2023, 6:32 PMLooks like each round of modification takes about 20 minutes for your dataset, and I see multiple alters running one after another
Jason Bosco
10/12/2023, 6:33 PMWe're probably at least two months out from a 0.26 GA release... But we have users using the RC builds in production already. Although the latest RC build has a known performance regression when using
group_byJason Bosco
10/12/2023, 6:34 PMThe alter seems to have completed now
y
Yoshi Gillaspie
10/12/2023, 6:34 PMCool, seeing data come through again. Sincerely appreciate the fast responses and detailed answers, thank you
👍 1