Back

Int Identify As relationship issue in selfhosted

  • 0
  • Self Hosted
  • Databases
Kmax
9 Mar, 2025, 15:15

When I tried to update a document, attribute value which is int & db identify as relationship on database & returns an error

TL;DR
Developers are experiencing issues with updating an attribute value due to relationships in a self-hosted environment. This is leading to performance problems. One suggestion is to avoid using numbers for the attribute key. Check for any open issues on GitHub related to this problem.
Steven
9 Mar, 2025, 15:17

There might be an open issue for this on GitHub. For now, best not to use numbers for the attribute key

Kmax
9 Mar, 2025, 15:18

Not attribute key, value of the attribute

Kmax
9 Mar, 2025, 15:18
Kmax
9 Mar, 2025, 15:20
Steven
9 Mar, 2025, 15:23

Do you have any relationship attributes?

Maybe the database or collection id isn't right?

Kmax
9 Mar, 2025, 15:24

yep my whole collections connected with each other using relationships

Kmax
9 Mar, 2025, 15:24

how to find which one is is invalid & remove only that? like there are 4k+ documents

Steven
9 Mar, 2025, 15:25

Fyi, relationships are experimental and should be used with caution as they may lead to performance issues

Kmax
9 Mar, 2025, 15:26

yah my whole system have huge performance issue bcz of that

Steven
9 Mar, 2025, 15:26

Maybe keep an eye out for errors

Steven
9 Mar, 2025, 15:27

Is there an error if you update it in the Console?

Kmax
9 Mar, 2025, 15:27

it fails to update bcz of relationships

Kmax
9 Mar, 2025, 15:28

like it goes upto 1GBps read & write speed & fails to update

Steven
9 Mar, 2025, 15:32

Same error or different?

Kmax
9 Mar, 2025, 15:39

No error or success message it simply doesn't return anything as a response just pending & see the speed jsu updating that one attribute value

Kmax
9 Mar, 2025, 15:40

& here is request

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