Org-roam-db issue, "SQL logic error" "no such table: notes" 1 1

[DominikMendel]

I'm not sure if this is related to Vulpea behavior, or my setup with Vulpea and Org-roam. But see the Discourse thread I opened in org-roam with the bug info and comments : https://org-roam.discourse.group/t/emacsql-sql-logic-error-no-such-table-notes-1-1/3520.

Original issue: Recently my org-roam-db has been having a lot of issues with a lot of files. Here is a sample: ⛔ Error (org-roam): Failed to process /home/user/Dropbox/org/roam/daily/Personal 2021-09-10.org with error EmacSQL had an unhandled condition: nil, nil, nil, ("SQL logic error" "no such table: notes" 1 1), skipping...

There are hundred of entires it’s having issues with. I have tried: A resync. A org-roam-db-clea-all into a resync. Deleting the roam-db file at the org-roam-db-location and syncing again.