SQLiteDB error: Error: Cannot add #datascript/Datom [789 :block/uuid #uuid "00000002-1454-9866-4100-000000000000" 536870913 true] because of unique constraint: (#datascript/Datom [793 :block/uuid #uuid "00000002-1454-9866-4100-000000000000" 536870913 true])

[niko-novice]

Search first

• I searched and no similar issues were found

What Happened?

I tried to reload my logseq db database sqlite.db and following error happened:

"SQLiteDB error: Error: Cannot add #datascript/Datom [789 :block/uuid #uuid "00000002-1454-9866-4100-000000000000" 536870913 true] because of unique constraint: (#datascript/Datom [793 :block/uuid #uuid "00000002-1454-9866-4100-000000000000" 536870913 true])"

Reproduce the Bug

1. Import
2. Sqlite
3. select sqlite.db file
4. error occurs

Expected Behavior

No response

Screenshots

No response

Desktop or Mobile Platform Information

Windows 11.
Using test.logseq.com (logseqdb version logseq)

Additional Context

No response

Are you willing to submit a PR? If you know how to fix the bug.

• I'm willing to submit a PR (Thank you!)

[logseq-cldwalker]

Hi. I've transferred your issue to https://github.com/logseq/db-test/issues as db version issues are reported in this repo

[tiensonqin]

@niko-novice Thank you for the report.
Which revision are you using?
You can get it by clicking Settings > "0.10.10".

[niko-novice]

@niko-novice Thank you for the report.
Which revision are you using?
You can get it by clicking Settings > "0.10.10".

0fcbe9f