Back

Relationship attribute stuck at processing

  • 0
  • Databases
  • Web
  • Apple
  • Cloud
IJustDev
17 Jun, 2024, 19:04

Hey I am in urgent need of help. I am using the hosted version of appwrite and I tried to create a relationship attribute. This time however it looks like it has been stuck in processing for over an hour.

I can call the getAttribute endpoint which returns

TypeScript
    {
      "key": "reports",
      "type": "relationship",
      "status": "processing",
      "error": "",
      "required": false,
      "array": false,
      "relatedCollection": "reports",
      "relationType": "manyToOne",
      "twoWay": true,
      "twoWayKey": "customer",
      "onDelete": "setNull",
      "side": "child"
    }

However I can not delete this attribute, since it is not available.

Unfortunately with this state I can not access the customers collection. Which makes all calls to this collection crash...

TL;DR
Developers are experiencing an issue where a relationship attribute is stuck at processing status, preventing access to the data despite creation via the UI 18 hours ago. Even though list collections work, the related collections cannot be accessed. The error persists and may have occurred during attribute creation. The support team requests the project ID for further investigation.
IJustDev
17 Jun, 2024, 19:11

Can anybody help me with this who has access to the database of appwrite? Or how does it work?

Steven
18 Jun, 2024, 02:11

Something probably failed while creating the attribute. How did you create the attribute?

IJustDev
18 Jun, 2024, 05:37

via the ui

IJustDev
18 Jun, 2024, 05:37

@Steven

IJustDev
18 Jun, 2024, 05:38

The error still persists. I can give you the project id if you want to take a look at it. it's "isar-maintenance"

Steven
18 Jun, 2024, 14:38

When?

Steven
18 Jun, 2024, 14:39

Get attribute returns this. What about list collections? Or is there a list attributes call?

IJustDev
18 Jun, 2024, 14:56

I have created it around 18 hours from now

IJustDev
18 Jun, 2024, 14:57

List collections works, but since the collections work together I can not access the data

IJustDev
18 Jun, 2024, 14:58

The json snippet that I have provided at the beginning was from listAttributes. Fortunately it didn't fail. It is still in processing

Steven
18 Jun, 2024, 14:58

What do you mean?

IJustDev
18 Jun, 2024, 14:59

Sorry, let me rephrase it.

Get attribute returned following: { "key": "reports", "type": "relationship", "status": "processing", "error": "", "required": false, "array": false, "relatedCollection": "reports", "relationType": "manyToOne", "twoWay": true, "twoWayKey": "customer", "onDelete": "setNull", "side": "child" }

Note the status:processing

After I have created a two way relationship via the UI (around 18 hours ago)

IJustDev
18 Jun, 2024, 15:00

The collection reportsdoes not show the field that correlates with this two way relationship on customers

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