[Question] Using only local db: "Diagnostic Error: Cannot update a record with pending changes"

Author: p4bl1t0Created May 21, 2025Updated Jan 30, 2026

I'm using WatermelonDB solely as a local database, without syncing to any server. The issue I'm facing is that I have some records marked as having pending changes in the local database, and I can't seem to bypass the error:

Cannot update a record with pending changes

Even when I re-fetch the record from the database (discarding the previous instance), the error persists.

My question is: Is there any way to manually mark a record as having no pending changes so I can update or overwrite it with the latest version?

I’ve searched through the documentation and GitHub issues, but all the relevant solutions seem to apply only when syncing with a remote server.

I've also tried using multiple AI models to find a workaround, but none have been helpful so far.

For context, I'm not using the latest version of WatermelonDB.

Thanks in advance for any help or guidance.