EmacSQL SQL logic error : No such table: notes 1 1

Troubleshooting
1

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.

2

One thing you could check is the value of org-roam-database-connector.

If it is not sqlite-builtin, try it. The docstring says this:

If you are using Emacs 29, then the recommended connector is
‘sqlite-builtin’, which uses the new builtin support for SQLite.
You need to install the ‘emacsql-sqlite-builtin’ package to use
this connector.

3

You installed some extension to org roam then forgot.
There is no notes table in the database. I suspect you were using vulpea.

4

Yes I’m already using sqlite-builtin for org-roam-database-connector. I’m on Doom, they might’ve done that for me.

5

This is correct. I am using Vulpea.
So is the problem then that Vulpea is adding an additional entry to the database?

6

no - we merely uncovered the condition-of-possibility of such an error.

We can infer now that a function call is happening that presumes vulpea definitions are in order- that the database has been informed, etc. But this function call cannot get the requisite details from the database.

My first step of inquiry should be in disabling vulpea definitions and re-initiating vulpea however its done. The problem should lie somewhere here.

1 Like