[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
@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
- Choose MariaDB (SSH Tunnel)
- Enter MariaDB Internal IP
- Enter MariaDB username and password
- Enter Server IP+port
- Enter Server SSH user and password (or key)
[Solved] Index Creation for 1 specific collection fails
