XPost: linux.debian.bugs.dist

Package: elpa-org-roam
Version: 2.2.2-1
Severity: important

Dear Maintainer,

Installed debian unstable in a Gnome Boxes VM and then installed the
packages "emacs-pgtk" and "elpa-org-roam".

Following the set up instructions on the org-roam website (https://www.orgroam.com/manual.html#Setting-up-Org_002droam), I opened
Emacs without a configuration file, and in the "*scratch*" buffer, I
pasted and evaluated the following:

(make-directory "~/org-roam")
(setq org-roam-directory (file-truename "~/org-roam")) (org-roam-db-autosync-mode)

This resulted in a "*Backtrace*" pop-up, containing the following text:

Debugger entered--Lisp error: (error "Process emacsql-sqlite not
running:
finished\n")
  process-send-string(#<process emacsql-sqlite> "7 ")
  #f(compiled-function (connection message) #<bytecode -0x648c87926dc2db6>)(#<emacsql-sqlite-connection emacsql-sqlite- connection-1581bb883466> "COMMIT;")
  apply(#f(compiled-function (connection message) #<bytecode -0x648c87926dc2db6>) (#<emacsql-sqlite-connection emacsql-sqlite- connection-1581bb883466> "COMMIT;"))
  #f(compiled-function (&rest args) #<bytecode - 0x1f3d5346d8d99a5c>)(#<emacsql-
sqlite-connection emacsql-sqlite-connection-1581bb883466> "COMMIT;")
  apply(#f(compiled-function (&rest args) #<bytecode -
0x1f3d5346d8d99a5c>)
#<emacsql-sqlite-connection emacsql-sqlite-connection-1581bb883466>
"COMMIT;")
  emacsql-send-message(#<emacsql-sqlite-connection emacsql-sqlite- connection-1581bb883466> "COMMIT;")
  #f(compiled-function (connection sql &rest args) #<bytecode -0x98dafa2cd92d0a4>)(#<emacsql-sqlite-connection emacsql-sqlite- connection-1581bb883466> [:commit])
  apply(#f(compiled-function (connection sql &rest args) #<bytecode -0x98dafa2cd92d0a4>) #<emacsql-sqlite-connection emacsql-sqlite- connection-1581bb883466> [:commit])
  emacsql(#<emacsql-sqlite-connection emacsql-sqlite-connection-
1581bb883466>
[:commit])
  org-roam-db--upgrade-maybe(#<emacsql-sqlite-connection emacsql-
sqlite-
connection-1581bb883466> 0)
  org-roam-db()
  org-roam-db-sync()
  org-roam-db-autosync-mode()
  (progn (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)


   * What exactly did you do (or not do) that was effective (or
     ineffective)?

I am able to get Org-roam working from the MELPA repository. Of course,
that merely avoids using the debian package.

I've also used it on Bookworm with the stable debian Emacs package
(28.2), and it worked as expected there.

   * What outcome did you expect instead?

After installing "elpa-org-roam" on Sid with Sid's Emacs 29.1 package installed, copying the setup code from the Org-roam manual, and
evaluating it in Emacs, I expected org-roam to build its database and
for its other commands to be usable for inserting and finding notes in
the database.


-- System Information:
Debian Release: trixie/sid
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: amd64 (x86_64)

Kernel: Linux 6.4.0-2-amd64 (SMP w/16 CPU threads; PREEMPT)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8),
LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages elpa-org-roam depends on:
ii dh-elpa-helper 2.0.17
ii elpa-dash 2.19.1+git20220608.1.0ac1ecf+dfsg-1
ii elpa-emacsql 3.1.1+ds-1
ii elpa-emacsql-sqlite 3.1.1+ds-1
ii elpa-magit-section 3.3.0-3
ii emacsen-common 3.0.5

Versions of packages elpa-org-roam recommends:
ii emacs 1:29.1+1-2
ii emacs-pgtk [emacs] 1:29.1+1-2

Versions of packages elpa-org-roam suggests:
ii org-roam-doc 2.2.2-1

-- no debconf information

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)