Bug Report: Self-hosted functions via domain: deployment_not_found

Reproduction steps

1. Create a function + deployment
2. Access the generated domain or a custom domain
3. Then this error appears: This page is empty; activate a deployment to make it live. deployment_not_found

Expected behavior

The activated deployment should be automatically assigned by the corresponding domain

Actual Behavior

Whether it's a custom domain or the generated domain, the following error always appears: "This page is empty; activate a deployment to make it live. deployment_not_found"

Creating a new deployment or activating a different deployment does not solve the problem; instead, you must activate the deployment using the following commands - every time:

• DB_CONTAINER=$(docker compose ps -q postgresql)
• docker exec -it "$DB_CONTAINER" psql -U user -d appwrite -c "UPDATE appwrite._console_rules SET \"deploymentId\" = '<DEPLOYMENT_ID>' WHERE domain = '<FUNCTION_DOMAIN>';"

After that, the deployment works via the corresponding URL. The same problem also affects sites, as has already been reported here: #13088

Appwrite version

Different version (specify in environment)

Operating system

Linux

Your Environment

Self-Hosted 2.0

Have you spent some time to check if this issue has been raised before?

• I checked and didn't find similar issue

Have you read the Code of Conduct?

• I have read the Code of Conduct