[Solved] Index Creation for 1 specific collection fails

Attribute index creation fails, not sure why. Tried other collections and it works fine but this one collection refuses. Not sure if there is a way to check logs or something, don't see anything in the appwrite console apart from a big red "failed"

Tried restarting all containers but no dice.

Any ideas where I could look ?

You can try to run docker logs appwrite-worker-database

• docker logs appwrite-worker-databases

Interesting, logs say index already exists ??? I deleted the existing indexes and all documents in the collection .. How could index exist

Maybe it somehow stayed Try login to MariaDB itself and look in there for any index attached to the collection

Oh boy, not even sure how I will can do that. Any existing posts I can refer to be able to do that ?

Let me try removing the collection and recreating it

Sure thing I've mentioned this few times in the past Let me find one of them

Here you go https://discord.com/channels/564160730845151244/1088290647036923976/1088292555688530010

@Binyamin and @Steven you guys are absolutely fantastic. Very active, knowledgeable and helpful. I really appreciate you both.

Just downloaded HeidiSQL and I am not sure how to get to docker internal network so it could reach the MariaDB IP

You can use the instruction here https://gist.github.com/byawitz/885510a4d9789e97424337e9472276d7

Later I'll try to add some screenshots for each tool,

Sorry the video contained private info so I've recreated it

1. Choose MariaDB (SSH Tunnel)
2. Enter MariaDB Internal IP
3. Enter MariaDB username and password
4. Enter Server IP+port
5. Enter Server SSH user and password (or key)

[Solved] Index Creation for 1 specific collection fails