[SOLVED] Index stuck on deleting | Appwrite | Page 1

solid pasture Oct 1, 2024, 8:43 PM

#

An index on one of my collections is causing errors with migration. It's not an index I need anymore so I've deleted it. However, the deletion is still pending on appwrite console, and has been for a while. I'd like to request the offending be deleted by a core member if possible. Thanks.

solid pasture Oct 2, 2024, 11:40 PM

#

@river sonnet Don't mean to disrupt you but pls can you help?

river sonnet Oct 3, 2024, 12:14 AM

#

solid pasture An index on one of my collections is causing errors with migration. It's not an ...

What's your project id, collection, and index?

solid pasture Oct 3, 2024, 4:31 AM

#

river sonnet What's your project id, collection, and index?

Project Id: 64360aedb8159c5c7bfa
Collection: 6468a779921388415f4f
Index: phoneNumbers

solid pasture Oct 4, 2024, 5:57 AM

#

Still waiting for a resolution pls

solid pasture Oct 7, 2024, 11:22 AM

#

Pinging one last time, sorry for the disruption @river sonnet

quartz zenith Oct 7, 2024, 8:47 PM

#

solid pasture Pinging one last time, sorry for the disruption <@462046107556511744>

You're migrating from cloud to self-hosting or what?

solid pasture Oct 7, 2024, 9:08 PM

#

quartz zenith You're migrating from cloud to self-hosting or what?

Yeah. I wanted a copy of the project (& data) on my self-hosted instance. But I have an index that is was causing errors and when I tried deleting it the deletion stuck.

quartz zenith Oct 7, 2024, 9:09 PM

#

solid pasture Yeah. I wanted a copy of the project (& data) on my self-hosted instance. But I ...

Is it still persisting?

#

I think there were some issues with the database if I'm not wrong that should be solved now

solid pasture Oct 7, 2024, 9:11 PM

#

quartz zenith Is it still persisting?

Yes

solid pasture Oct 7, 2024, 9:12 PM

#

quartz zenith I think there were some issues with the database if I'm not wrong that should be...

Just checked and it's still stuck

#

It's fine I'm just gonna start over. It wasn't production ready and the development wasn't that far along.

quartz zenith Oct 7, 2024, 9:13 PM

#

I see. That should not happen anyways 😕

solid pasture Oct 7, 2024, 9:22 PM

#

quartz zenith I see. That should not happen anyways 😕

I think I might know why this happened. It was a full-text index on a string array attribute which was a workaround I was using in 1.3.x since there was no Query.contains() method for arrays then. However, along the line with newer versions (I'm not sure which one exactly) the ability to create a full-text index on an array was removed throwing errors instead. Because of this when migrating the project it fails to be able to create the index and thus the migration fails part way. That's why I tried deleting it but since such an index state shouldn't be possible appwrite maybe be encountering error when trying to delete it hence it got stuck

#