Attribute creations stuck at "processing"

I have a self hosted instance of Appwrite and I am using cursor to connect my ecom frontend and deploy backend with Appwrite.

Cursor is getting stuck at creating attribute stage and going through loops. It gets stuck on certain collections - create attribute steps as shown.

I manually deleted those collections and tried again but its always showing stuck in processing. I can share the database.js script its using for creating these attributes if that helps.

TL;DR

Developers are facing issues with attribute creations stuck at "processing" in Appwrite. One developer suggests checking the database connection, but another confirms seamless self-hosting experience. The original developer switches to Supabase due to attribute challenges. Solution shared: Check logs for the MariaDB container to troubleshoot. The error related to a missing route in the Appwrite API may be a clue to the problem.

Please check logs on your VPS via SSH

Refer this docs for debugging self hosted Appwrite & to view logs https://appwrite.io/docs/advanced/self-hosting/debug

Alright, I wonder if it has to do anything with this docker log

[Error] Method: [Error] URL: /v1/realtime [Error] Type: Appwrite\Extend\Exception [Error] Message: The requested route was not found. Please refer to the API docs and try again. [Error] File: /usr/src/code/app/controllers/general.php [Error] Line: 859

@kamal.panara Ok those errors should not affect I figure. The debug docs just show how to see logs, which I have here. That doesnt help with attributes stuck in processing. Any guidance here please?

I think that there's some issue with your database or connection. Check the logs for the mariaDB container

Those are the only logs you see?

Those are requests from bots, you can ignore them

What are the logs for the mariadb container?

You can get them by runnin docker compose logs appwrite-mariadb

I am sorry, I took the LXC down and went with supabase for now. I found so many threads for attributes and felt it might be too much of a challenge for me to solve. I willl give it a go again when I am more familiar with troubleshooting process.

Self-hosting supabase? 😅

Self hosting part was very easy actually despite what I read. Its up and running. Single database per project limitation is what brought me to Appwrite but I am trying to learn backend functionalities so it might work for me for now.