Skip to content
Back

Row with the requested ID already exists.

  • 0
  • Databases
  • React Native
  • Cloud
SeneMansa
17 Sep, 2025, 00:12

I’m hitting a blocking issue creating rows in Appwrite (both from the console and my React Native app). After successfully inserting the first row, every subsequent create fails with:

[AppwriteException: Row with the requested ID already exists. Try again with a different ID or use ID.unique() to generate a unique ID.]

It looks like the document ID is being treated as already used even when I expect a new unique ID. I only have one two-way one-to-one relationship between two tables. After the first insert, I can’t add any more records.

Schema (essential parts):

Table: profiles

  • Columns: gender (enum: male|female), dob (datetime, required), marketingoptin (bool), userid (string, size 36, required), fullname (string, 128, required), email (string, 254), phonee164 (string, 32, required), locale (string, 8, required), profilepicture (url)
  • Relationship: secure_idprofiles_secure (oneToOne, twoWay=true, twoWayKey=profileid, onDelete=cascade, side=child)
  • Permissions: read("users")
  • Indexes: none

Table: profiles_secure

  • Columns: pregnancystatus (enum: na|pregnant|postpartum), breastfeeding (bool), cninumber (string, 32), allergies (string], 128), emergencycontactname (string, 128), emergencycontactphonee164 (string, 32), consents (string, 4096)
  • Relationship: profile_idprofiles (oneToOne, twoWay=true, twoWayKey=secureid, onDelete=cascade, side=parent)
  • Permissions: read("users")
  • Indexes: indexcni (ASC)

Notes:

  • The error occurs immediately after the first profiles row is added.
  • I expected Appwrite to generate a unique document ID (or to honor ID.unique()), but the platform behaves as if the same ID is reused.
  • Only change since it worked: adding the two-way one-to-one relation above.

Any ideas why additional creates are hitting “Row with the requested ID already exists”? Is there something about two-way one-to-one relations or document IDs I might be misconfiguring?

TL;DR
Issue: Developer is encountering a problem where every subsequent row creation in Appwrite fails with the error message "Row with the requested ID already exists" even though a unique ID is expected. This occurs after the first row is successfully inserted. The error seems to be related to a two-way one-to-one relationship configuration in the database schema. Solution: Try using `ID.unique()` to generate a unique ID or ensure that the platform is correctly handling the creation of new document IDs. Check the configuration of the two-way one-to-one relationship to ensure that it is not causing ID reuse issues.
SeneMansa
17 Sep, 2025, 00:29

@Steven Do you know why this is happening at the moment I see same issue was posted earlier with no response from the team https://discord.com/channels/564160730845151244/1415039983844327476

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