1. Forum
  2. USENET
  3. gnu.emacs.help

  • Problem with org-roam

    From Cecil Westerhof@Cecil@decebal.nl to gnu.emacs.help on Mon Dec 4 15:00:50 2023
    From Newsgroup: gnu.emacs.help

    I am working on Debian 12 with xfce4.
    I installed emacs 29.1 from backports because I want to try out
    org-roam.
    When looking at:
    https://www.orgroam.com/manual.html#Setting-up-Org_002droam

    Then the following should be enough:
    (setq org-roam-directory (file-truename "~/org/roam"))
    (org-roam-db-autosync-mode)

    But I get:
    Debugger entered--Lisp error: (emacsql-error "incomplete input" 1)
    signal(emacsql-error ("incomplete input" 1))
    #f(compiled-function (_ code message) "Get condition for MESSAGE provided from SQLite." #<bytecode -0x1efd49e407452c74>)(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a293a3c32> 1 "incomplete input")
    apply(#f(compiled-function (_ code message) "Get condition for MESSAGE provided from SQLite." #<bytecode -0x1efd49e407452c74>) #<emacsql-sqlite-connection emacsql-sqlite-connection-155a293a3c32> (1 "incomplete input"))
    emacsql-handle(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a293a3c32> 1 "incomplete input")
    #f(compiled-function (connection) "Parse well-formed output into an s-expression." #<bytecode 0x6ae616b26e89a6a>)(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a293a3c32>)
    apply(#f(compiled-function (connection) "Parse well-formed output into an s-expression." #<bytecode 0x6ae616b26e89a6a>) #<emacsql-sqlite-connection emacsql-sqlite-connection-155a293a3c32> nil)
    emacsql-parse(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a293a3c32>)
    #f(compiled-function (connection sql &rest args) #<bytecode -0x98d231c19cc83a4>)(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a293a3c32> [:create-index $i1 :on $i2 $S3] alias-node-id aliases [node-id])
    apply(#f(compiled-function (connection sql &rest args) #<bytecode -0x98d231c19cc83a4>) #<emacsql-sqlite-connection emacsql-sqlite-connection-155a293a3c32> ([:create-index $i1 :on $i2 $S3] alias-node-id aliases [node-id]))
    emacsql(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a293a3c32> [:create-index $i1 :on $i2 $S3] alias-node-id aliases [node-id])
    org-roam-db--init(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a293a3c32>)
    org-roam-db()
    org-roam-db-sync(t)
    org-roam-db--upgrade-maybe(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a29395310> 0)
    org-roam-db()
    org-roam-db-sync()
    org-roam-db-autosync-mode()
    elisp--eval-last-sexp(nil)
    eval-last-sexp(nil)
    funcall-interactively(eval-last-sexp nil)
    command-execute(eval-last-sexp)

    And when I close that, I also see:
    Debugger entered--Lisp error: (error "Process emacsql-sqlite not running: finished\n")
    process-send-string(#<process emacsql-sqlite> "9 ")
    #f(compiled-function (connection message) #<bytecode 0x625692ba2c5664a>)(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a29395310> "ROLLBACK;")
    apply(#f(compiled-function (connection message) #<bytecode 0x625692ba2c5664a>) (#<emacsql-sqlite-connection emacsql-sqlite-connection-155a29395310> "ROLLBACK;"))
    #f(compiled-function (&rest args) #<bytecode -0x1f3d5346d8e5b31c>)(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a29395310> "ROLLBACK;")
    apply(#f(compiled-function (&rest args) #<bytecode -0x1f3d5346d8e5b31c>) #<emacsql-sqlite-connection emacsql-sqlite-connection-155a29395310> "ROLLBACK;")
    emacsql-send-message(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a29395310> "ROLLBACK;")
    #f(compiled-function (connection sql &rest args) #<bytecode -0x98d231c19cc83a4>)(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a29395310> [:rollback])
    apply(#f(compiled-function (connection sql &rest args) #<bytecode -0x98d231c19cc83a4>) #<emacsql-sqlite-connection emacsql-sqlite-connection-155a29395310> [:rollback])
    emacsql(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a29395310> [:rollback])
    #f(compiled-function () #<bytecode 0x3533fbf87f28899>)()
    org-roam-db--upgrade-maybe(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a29395310> 0)
    org-roam-db()
    org-roam-db-sync()
    org-roam-db-autosync-mode()
    elisp--eval-last-sexp(nil)
    eval-last-sexp(nil)
    funcall-interactively(eval-last-sexp nil)
    command-execute(eval-last-sexp)

    I extended the initialisation to:
    (use-package emacsql-sqlite
    :ensure t
    )
    (setq org-roam-database-connector 'sqlite)
    (setq org-roam-directory (file-truename "~/org/roam"))
    (setq org-roam-db-location (file-truename "~/Databases/org-roam.sqlite"))
    (use-package org-roam
    :ensure t)
    (org-roam-db-autosync-mode)

    But that did not change anything.
    What could be happening here?

    It seems that emacsql-sqlite is not running.
    But why? How do I get it started?
    --
    Cecil Westerhof
    Senior Software Engineer
    LinkedIn: http://www.linkedin.com/in/cecilwesterhof
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From Cecil Westerhof@Cecil@decebal.nl to gnu.emacs.help on Wed Dec 6 12:04:27 2023
    From Newsgroup: gnu.emacs.help

    On another system I installed Sid. There org-roam does work. But on
    the system where it is about I do not want to install Sid.
    I will do some more investigation.

    Cecil Westerhof <Cecil@decebal.nl> writes:

    I am working on Debian 12 with xfce4.
    I installed emacs 29.1 from backports because I want to try out
    org-roam.
    When looking at:
    https://www.orgroam.com/manual.html#Setting-up-Org_002droam

    Then the following should be enough:
    (setq org-roam-directory (file-truename "~/org/roam"))
    (org-roam-db-autosync-mode)

    But I get:
    Debugger entered--Lisp error: (emacsql-error "incomplete input" 1)
    signal(emacsql-error ("incomplete input" 1))
    #f(compiled-function (_ code message) "Get condition for MESSAGE provided from SQLite." #<bytecode -0x1efd49e407452c74>)(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a293a3c32> 1 "incomplete input")
    apply(#f(compiled-function (_ code message) "Get condition for MESSAGE provided from SQLite." #<bytecode -0x1efd49e407452c74>) #<emacsql-sqlite-connection emacsql-sqlite-connection-155a293a3c32> (1 "incomplete input"))
    emacsql-handle(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a293a3c32> 1 "incomplete input")
    #f(compiled-function (connection) "Parse well-formed output into an s-expression." #<bytecode 0x6ae616b26e89a6a>)(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a293a3c32>)
    apply(#f(compiled-function (connection) "Parse well-formed output into an s-expression." #<bytecode 0x6ae616b26e89a6a>) #<emacsql-sqlite-connection emacsql-sqlite-connection-155a293a3c32> nil)
    emacsql-parse(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a293a3c32>)
    #f(compiled-function (connection sql &rest args) #<bytecode -0x98d231c19cc83a4>)(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a293a3c32> [:create-index $i1 :on $i2 $S3] alias-node-id aliases [node-id])
    apply(#f(compiled-function (connection sql &rest args) #<bytecode -0x98d231c19cc83a4>) #<emacsql-sqlite-connection emacsql-sqlite-connection-155a293a3c32> ([:create-index $i1 :on $i2 $S3] alias-node-id aliases [node-id]))
    emacsql(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a293a3c32> [:create-index $i1 :on $i2 $S3] alias-node-id aliases [node-id])
    org-roam-db--init(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a293a3c32>)
    org-roam-db()
    org-roam-db-sync(t)
    org-roam-db--upgrade-maybe(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a29395310> 0)
    org-roam-db()
    org-roam-db-sync()
    org-roam-db-autosync-mode()
    elisp--eval-last-sexp(nil)
    eval-last-sexp(nil)
    funcall-interactively(eval-last-sexp nil)
    command-execute(eval-last-sexp)

    And when I close that, I also see:
    Debugger entered--Lisp error: (error "Process emacsql-sqlite not running: finished\n")
    process-send-string(#<process emacsql-sqlite> "9 ")
    #f(compiled-function (connection message) #<bytecode 0x625692ba2c5664a>)(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a29395310> "ROLLBACK;")
    apply(#f(compiled-function (connection message) #<bytecode 0x625692ba2c5664a>) (#<emacsql-sqlite-connection emacsql-sqlite-connection-155a29395310> "ROLLBACK;"))
    #f(compiled-function (&rest args) #<bytecode -0x1f3d5346d8e5b31c>)(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a29395310> "ROLLBACK;")
    apply(#f(compiled-function (&rest args) #<bytecode -0x1f3d5346d8e5b31c>) #<emacsql-sqlite-connection emacsql-sqlite-connection-155a29395310> "ROLLBACK;")
    emacsql-send-message(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a29395310> "ROLLBACK;")
    #f(compiled-function (connection sql &rest args) #<bytecode -0x98d231c19cc83a4>)(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a29395310> [:rollback])
    apply(#f(compiled-function (connection sql &rest args) #<bytecode -0x98d231c19cc83a4>) #<emacsql-sqlite-connection emacsql-sqlite-connection-155a29395310> [:rollback])
    emacsql(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a29395310> [:rollback])
    #f(compiled-function () #<bytecode 0x3533fbf87f28899>)()
    org-roam-db--upgrade-maybe(#<emacsql-sqlite-connection emacsql-sqlite-connection-155a29395310> 0)
    org-roam-db()
    org-roam-db-sync()
    org-roam-db-autosync-mode()
    elisp--eval-last-sexp(nil)
    eval-last-sexp(nil)
    funcall-interactively(eval-last-sexp nil)
    command-execute(eval-last-sexp)

    I extended the initialisation to:
    (use-package emacsql-sqlite
    :ensure t
    )
    (setq org-roam-database-connector 'sqlite)
    (setq org-roam-directory (file-truename "~/org/roam"))
    (setq org-roam-db-location (file-truename "~/Databases/org-roam.sqlite"))
    (use-package org-roam
    :ensure t)
    (org-roam-db-autosync-mode)

    But that did not change anything.
    What could be happening here?

    It seems that emacsql-sqlite is not running.
    But why? How do I get it started?
    --
    Cecil Westerhof
    Senior Software Engineer
    LinkedIn: http://www.linkedin.com/in/cecilwesterhof
    --- Synchronet 3.21d-Linux NewsLink 1.2