I have been using the package fine (currently the newest version). However, today when I invoke org-roam-node-find
, error shows up as EmacSQL had an unhandled condition
. I traced with it and here is the output:
Debugger entered--Lisp error: (emacsql-error)
signal(emacsql-error nil)
#f(compiled-function (connection message) #<bytecode 0x3004cbfdd254da9>)(#<emacsql-sqlite-builtin-connection emacsql-sqlite-builtin-connection-10239f1ff29c> "\nSELECT\n title,\n aliases,\n\n id,\n file,\n filetitle,\n \"level\",\n todo,\n\n pos,\n priority ,\n scheduled ,\n deadline ,\n properties ,\n\n olp,\n atime,\n mtime,\n '(' || group_concat(tags, ' ') || ')' as tags,\n refs\nFROM\n (\n SELECT\n id,\n file,\n filetitle,\n \"level\",\n todo,\n pos,\n priority ,\n scheduled ,\n deadline ,\n title,\n properties ,\n olp,\n atime,\n mtime,\n tags,\n '(' || group_concat(aliases, ' ') || ')' as aliases,\n refs\n FROM\n (\n SELECT\n nodes.id as id,\n nodes.file as file,\n nodes.\"level\" as \"level\",\n nodes.todo as todo,\n nodes.pos as pos,\n nodes.priority as priority,\n nodes.scheduled as scheduled,\n nodes.deadline as deadline,\n nodes.title as title,\n nodes.properties as properties,\n nodes.olp as olp,\n files.atime as atime,\n files.mtime as mtime,\n files.title as filetitle,\n tags.tag as tags,\n aliases.alias as aliases,\n '(' || group_concat(RTRIM (refs.\"type\", '\"') || ':' || LTRIM(refs.ref, '\"'), ' ') || ')' as refs\n FROM nodes\n LEFT JOIN files ON files.file = nodes.file\n LEFT JOIN tags ON tags.node_id = nodes.id\n LEFT JOIN aliases ON aliases.node_id = nodes.id\n LEFT JOIN refs ON refs.node_id = nodes.id\n GROUP BY nodes.id, tags.tag, aliases.alias )\n GROUP BY id, tags )\nGROUP BY id\n;")
apply(#f(compiled-function (connection message) #<bytecode 0x3004cbfdd254da9>) (#<emacsql-sqlite-builtin-connection emacsql-sqlite-builtin-connection-10239f1ff29c> "\nSELECT\n title,\n aliases,\n\n id,\n file,\n filetitle,\n \"level\",\n todo,\n\n pos,\n priority ,\n scheduled ,\n deadline ,\n properties ,\n\n olp,\n atime,\n mtime,\n '(' || group_concat(tags, ' ') || ')' as tags,\n refs\nFROM\n (\n SELECT\n id,\n file,\n filetitle,\n \"level\",\n todo,\n pos,\n priority ,\n scheduled ,\n deadline ,\n title,\n properties ,\n olp,\n atime,\n mtime,\n tags,\n '(' || group_concat(aliases, ' ') || ')' as aliases,\n refs\n FROM\n (\n SELECT\n nodes.id as id,\n nodes.file as file,\n nodes.\"level\" as \"level\",\n nodes.todo as todo,\n nodes.pos as pos,\n nodes.priority as priority,\n nodes.scheduled as scheduled,\n nodes.deadline as deadline,\n nodes.title as title,\n nodes.properties as properties,\n nodes.olp as olp,\n files.atime as atime,\n files.mtime as mtime,\n files.title as filetitle,\n tags.tag as tags,\n aliases.alias as aliases,\n '(' || group_concat(RTRIM (refs.\"type\", '\"') || ':' || LTRIM(refs.ref, '\"'), ' ') || ')' as refs\n FROM nodes\n LEFT JOIN files ON files.file = nodes.file\n LEFT JOIN tags ON tags.node_id = nodes.id\n LEFT JOIN aliases ON aliases.node_id = nodes.id\n LEFT JOIN refs ON refs.node_id = nodes.id\n GROUP BY nodes.id, tags.tag, aliases.alias )\n GROUP BY id, tags )\nGROUP BY id\n;"))
#f(compiled-function (&rest args) #<bytecode 0x1fcbe5a0a861f3c7>)(#<emacsql-sqlite-builtin-connection emacsql-sqlite-builtin-connection-10239f1ff29c> "\nSELECT\n title,\n aliases,\n\n id,\n file,\n filetitle,\n \"level\",\n todo,\n\n pos,\n priority ,\n scheduled ,\n deadline ,\n properties ,\n\n olp,\n atime,\n mtime,\n '(' || group_concat(tags, ' ') || ')' as tags,\n refs\nFROM\n (\n SELECT\n id,\n file,\n filetitle,\n \"level\",\n todo,\n pos,\n priority ,\n scheduled ,\n deadline ,\n title,\n properties ,\n olp,\n atime,\n mtime,\n tags,\n '(' || group_concat(aliases, ' ') || ')' as aliases,\n refs\n FROM\n (\n SELECT\n nodes.id as id,\n nodes.file as file,\n nodes.\"level\" as \"level\",\n nodes.todo as todo,\n nodes.pos as pos,\n nodes.priority as priority,\n nodes.scheduled as scheduled,\n nodes.deadline as deadline,\n nodes.title as title,\n nodes.properties as properties,\n nodes.olp as olp,\n files.atime as atime,\n files.mtime as mtime,\n files.title as filetitle,\n tags.tag as tags,\n aliases.alias as aliases,\n '(' || group_concat(RTRIM (refs.\"type\", '\"') || ':' || LTRIM(refs.ref, '\"'), ' ') || ')' as refs\n FROM nodes\n LEFT JOIN files ON files.file = nodes.file\n LEFT JOIN tags ON tags.node_id = nodes.id\n LEFT JOIN aliases ON aliases.node_id = nodes.id\n LEFT JOIN refs ON refs.node_id = nodes.id\n GROUP BY nodes.id, tags.tag, aliases.alias )\n GROUP BY id, tags )\nGROUP BY id\n;")
apply(#f(compiled-function (&rest args) #<bytecode 0x1fcbe5a0a861f3c7>) #<emacsql-sqlite-builtin-connection emacsql-sqlite-builtin-connection-10239f1ff29c> "\nSELECT\n title,\n aliases,\n\n id,\n file,\n filetitle,\n \"level\",\n todo,\n\n pos,\n priority ,\n scheduled ,\n deadline ,\n properties ,\n\n olp,\n atime,\n mtime,\n '(' || group_concat(tags, ' ') || ')' as tags,\n refs\nFROM\n (\n SELECT\n id,\n file,\n filetitle,\n \"level\",\n todo,\n pos,\n priority ,\n scheduled ,\n deadline ,\n title,\n properties ,\n olp,\n atime,\n mtime,\n tags,\n '(' || group_concat(aliases, ' ') || ')' as aliases,\n refs\n FROM\n (\n SELECT\n nodes.id as id,\n nodes.file as file,\n nodes.\"level\" as \"level\",\n nodes.todo as todo,\n nodes.pos as pos,\n nodes.priority as priority,\n nodes.scheduled as scheduled,\n nodes.deadline as deadline,\n nodes.title as title,\n nodes.properties as properties,\n nodes.olp as olp,\n files.atime as atime,\n files.mtime as mtime,\n files.title as filetitle,\n tags.tag as tags,\n aliases.alias as aliases,\n '(' || group_concat(RTRIM (refs.\"type\", '\"') || ':' || LTRIM(refs.ref, '\"'), ' ') || ')' as refs\n FROM nodes\n LEFT JOIN files ON files.file = nodes.file\n LEFT JOIN tags ON tags.node_id = nodes.id\n LEFT JOIN aliases ON aliases.node_id = nodes.id\n LEFT JOIN refs ON refs.node_id = nodes.id\n GROUP BY nodes.id, tags.tag, aliases.alias )\n GROUP BY id, tags )\nGROUP BY id\n;")
emacsql-send-message(#<emacsql-sqlite-builtin-connection emacsql-sqlite-builtin-connection-10239f1ff29c> "\nSELECT\n title,\n aliases,\n\n id,\n file,\n filetitle,\n \"level\",\n todo,\n\n pos,\n priority ,\n scheduled ,\n deadline ,\n properties ,\n\n olp,\n atime,\n mtime,\n '(' || group_concat(tags, ' ') || ')' as tags,\n refs\nFROM\n (\n SELECT\n id,\n file,\n filetitle,\n \"level\",\n todo,\n pos,\n priority ,\n scheduled ,\n deadline ,\n title,\n properties ,\n olp,\n atime,\n mtime,\n tags,\n '(' || group_concat(aliases, ' ') || ')' as aliases,\n refs\n FROM\n (\n SELECT\n nodes.id as id,\n nodes.file as file,\n nodes.\"level\" as \"level\",\n nodes.todo as todo,\n nodes.pos as pos,\n nodes.priority as priority,\n nodes.scheduled as scheduled,\n nodes.deadline as deadline,\n nodes.title as title,\n nodes.properties as properties,\n nodes.olp as olp,\n files.atime as atime,\n files.mtime as mtime,\n files.title as filetitle,\n tags.tag as tags,\n aliases.alias as aliases,\n '(' || group_concat(RTRIM (refs.\"type\", '\"') || ':' || LTRIM(refs.ref, '\"'), ' ') || ')' as refs\n FROM nodes\n LEFT JOIN files ON files.file = nodes.file\n LEFT JOIN tags ON tags.node_id = nodes.id\n LEFT JOIN aliases ON aliases.node_id = nodes.id\n LEFT JOIN refs ON refs.node_id = nodes.id\n GROUP BY nodes.id, tags.tag, aliases.alias )\n GROUP BY id, tags )\nGROUP BY id\n;")
#f(compiled-function (connection sql &rest args) #<bytecode -0x97bff269bbac00b>)(#<emacsql-sqlite-builtin-connection emacsql-sqlite-builtin-connection-10239f1ff29c> "\nSELECT\n title,\n aliases,\n\n id,\n file,\n filetitle,\n \"level\",\n todo,\n\n pos,\n priority ,\n scheduled ,\n deadline ,\n properties ,\n\n olp,\n atime,\n mtime,\n '(' || group_concat(tags, ' ') || ')' as tags,\n refs\nFROM\n (\n SELECT\n id,\n file,\n filetitle,\n \"level\",\n todo,\n pos,\n priority ,\n scheduled ,\n deadline ,\n title,\n properties ,\n olp,\n atime,\n mtime,\n tags,\n '(' || group_concat(aliases, ' ') || ')' as aliases,\n refs\n FROM\n (\n SELECT\n nodes.id as id,\n nodes.file as file,\n nodes.\"level\" as \"level\",\n nodes.todo as todo,\n nodes.pos as pos,\n nodes.priority as priority,\n nodes.scheduled as scheduled,\n nodes.deadline as deadline,\n nodes.title as title,\n nodes.properties as properties,\n nodes.olp as olp,\n files.atime as atime,\n files.mtime as mtime,\n files.title as filetitle,\n tags.tag as tags,\n aliases.alias as aliases,\n '(' || group_concat(RTRIM (refs.\"type\", '\"') || ':' || LTRIM(refs.ref, '\"'), ' ') || ')' as refs\n FROM nodes\n LEFT JOIN files ON files.file = nodes.file\n LEFT JOIN tags ON tags.node_id = nodes.id\n LEFT JOIN aliases ON aliases.node_id = nodes.id\n LEFT JOIN refs ON refs.node_id = nodes.id\n GROUP BY nodes.id, tags.tag, aliases.alias )\n GROUP BY id, tags )\nGROUP BY id\n")
apply(#f(compiled-function (connection sql &rest args) #<bytecode -0x97bff269bbac00b>) #<emacsql-sqlite-builtin-connection emacsql-sqlite-builtin-connection-10239f1ff29c> "\nSELECT\n title,\n aliases,\n\n id,\n file,\n filetitle,\n \"level\",\n todo,\n\n pos,\n priority ,\n scheduled ,\n deadline ,\n properties ,\n\n olp,\n atime,\n mtime,\n '(' || group_concat(tags, ' ') || ')' as tags,\n refs\nFROM\n (\n SELECT\n id,\n file,\n filetitle,\n \"level\",\n todo,\n pos,\n priority ,\n scheduled ,\n deadline ,\n title,\n properties ,\n olp,\n atime,\n mtime,\n tags,\n '(' || group_concat(aliases, ' ') || ')' as aliases,\n refs\n FROM\n (\n SELECT\n nodes.id as id,\n nodes.file as file,\n nodes.\"level\" as \"level\",\n nodes.todo as todo,\n nodes.pos as pos,\n nodes.priority as priority,\n nodes.scheduled as scheduled,\n nodes.deadline as deadline,\n nodes.title as title,\n nodes.properties as properties,\n nodes.olp as olp,\n files.atime as atime,\n files.mtime as mtime,\n files.title as filetitle,\n tags.tag as tags,\n aliases.alias as aliases,\n '(' || group_concat(RTRIM (refs.\"type\", '\"') || ':' || LTRIM(refs.ref, '\"'), ' ') || ')' as refs\n FROM nodes\n LEFT JOIN files ON files.file = nodes.file\n LEFT JOIN tags ON tags.node_id = nodes.id\n LEFT JOIN aliases ON aliases.node_id = nodes.id\n LEFT JOIN refs ON refs.node_id = nodes.id\n GROUP BY nodes.id, tags.tag, aliases.alias )\n GROUP BY id, tags )\nGROUP BY id\n")
emacsql(#<emacsql-sqlite-builtin-connection emacsql-sqlite-builtin-connection-10239f1ff29c> "\nSELECT\n title,\n aliases,\n\n id,\n file,\n filetitle,\n \"level\",\n todo,\n\n pos,\n priority ,\n scheduled ,\n deadline ,\n properties ,\n\n olp,\n atime,\n mtime,\n '(' || group_concat(tags, ' ') || ')' as tags,\n refs\nFROM\n (\n SELECT\n id,\n file,\n filetitle,\n \"level\",\n todo,\n pos,\n priority ,\n scheduled ,\n deadline ,\n title,\n properties ,\n olp,\n atime,\n mtime,\n tags,\n '(' || group_concat(aliases, ' ') || ')' as aliases,\n refs\n FROM\n (\n SELECT\n nodes.id as id,\n nodes.file as file,\n nodes.\"level\" as \"level\",\n nodes.todo as todo,\n nodes.pos as pos,\n nodes.priority as priority,\n nodes.scheduled as scheduled,\n nodes.deadline as deadline,\n nodes.title as title,\n nodes.properties as properties,\n nodes.olp as olp,\n files.atime as atime,\n files.mtime as mtime,\n files.title as filetitle,\n tags.tag as tags,\n aliases.alias as aliases,\n '(' || group_concat(RTRIM (refs.\"type\", '\"') || ':' || LTRIM(refs.ref, '\"'), ' ') || ')' as refs\n FROM nodes\n LEFT JOIN files ON files.file = nodes.file\n LEFT JOIN tags ON tags.node_id = nodes.id\n LEFT JOIN aliases ON aliases.node_id = nodes.id\n LEFT JOIN refs ON refs.node_id = nodes.id\n GROUP BY nodes.id, tags.tag, aliases.alias )\n GROUP BY id, tags )\nGROUP BY id\n")
org-roam-db-query("\nSELECT\n title,\n aliases,\n\n id,\n file,\n filetitle,\n \"level\",\n todo,\n\n pos,\n priority ,\n scheduled ,\n deadline ,\n properties ,\n\n olp,\n atime,\n mtime,\n '(' || group_concat(tags, ' ') || ')' as tags,\n refs\nFROM\n (\n SELECT\n id,\n file,\n filetitle,\n \"level\",\n todo,\n pos,\n priority ,\n scheduled ,\n deadline ,\n title,\n properties ,\n olp,\n atime,\n mtime,\n tags,\n '(' || group_concat(aliases, ' ') || ')' as aliases,\n refs\n FROM\n (\n SELECT\n nodes.id as id,\n nodes.file as file,\n nodes.\"level\" as \"level\",\n nodes.todo as todo,\n nodes.pos as pos,\n nodes.priority as priority,\n nodes.scheduled as scheduled,\n nodes.deadline as deadline,\n nodes.title as title,\n nodes.properties as properties,\n nodes.olp as olp,\n files.atime as atime,\n files.mtime as mtime,\n files.title as filetitle,\n tags.tag as tags,\n aliases.alias as aliases,\n '(' || group_concat(RTRIM (refs.\"type\", '\"') || ':' || LTRIM(refs.ref, '\"'), ' ') || ')' as refs\n FROM nodes\n LEFT JOIN files ON files.file = nodes.file\n LEFT JOIN tags ON tags.node_id = nodes.id\n LEFT JOIN aliases ON aliases.node_id = nodes.id\n LEFT JOIN refs ON refs.node_id = nodes.id\n GROUP BY nodes.id, tags.tag, aliases.alias )\n GROUP BY id, tags )\nGROUP BY id\n")
org-roam-node-list()
org-roam-node-read--completions(nil nil)
consult-org-roam-node-read(nil nil nil nil nil)
apply(consult-org-roam-node-read (nil nil nil))
org-roam-node-read(nil nil nil)
org-roam-node-find()
funcall-interactively(org-roam-node-find)
command-execute(org-roam-node-find)
I tried to delete the .db
file and let it rebuilt , but still no success. I downgrade the org-roam to melpa-stable and the same error shows up again. I tried to recompile all packages, and no success. Interestingly, org-roam-version
yields funcall-interactively: Search failed: "\\(?:;; Version: \\([^z-a]*?$\\)\\)"
( for both the melpa and melpa-stable package version).
What issue am I facing here :(?