Skip to content
Back

Attribute already exists in schema

  • 0
  • Self Hosted
  • Databases
Lexy
13 Jun, 2025, 12:06

I created an attribute, deleted it and now I can't create it again. It says "Failed" and "Attribute already exists in schema".

TypeScript
{
    "27": {
        "key": "sectionId",
        "type": "string",
        "status": "failed",
        "error": "Attribute already exists in schema",
        "required": false,
        "array": false,
        "$createdAt": "2025-06-13T11:59:07.359+00:00",
        "$updatedAt": "2025-06-13T11:59:07.388+00:00",
        "size": 32,
        "default": null,
        "encrypt": false
    }
}

Is there any way to delete it and recreate it? Using self hosted 1.7.4.

When I try to update it in the console it says " The requested attribute is not yet available. Please try again later."

TL;DR
Developers deleted an attribute using SQL, but it still exists in the database. They then tried to recreate it through console but received an error "Attribute already exists in schema." The issue persists even after trying to update it, getting a message saying "The requested attribute is not yet available. Please try again later." Solution: Try dropping the attribute properly from the schema. Before recreating it, ensure there are no remnants in the database or schema that might prevent its successful creation.
Lexy
13 Jun, 2025, 12:32

The attribute still exists in the _1_database_1_collection_15 table when inspecting the database, even when it has been deleted from the console

Lexy
13 Jun, 2025, 12:35

I deleted the attribute with ALTER TABLE _1_database_1_collection_15 DROP IF EXISTS sectionId; and now it can be created in the console without errors 🙂

Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more