Dear Maintainer,

The packaged version of org-roam has a requirement on emacsql-sqlite
(see /usr/share/emacs/site-lisp/elpa-src/org-roam-2.3.1/org-roam.el
line 86) or in salsa:

https://salsa.debian.org/emacsen-team/org-roam/-/blob/v2.3.1/org-roam.el?ref_type=tags#L86

However, that is not currently listed as package requirement.  There
is a requirement on elpa-emacsql which provides only the high level
abstractions but not on the sqlite backend.  Without elpa-emacsql-sqlite
installed, starting org-roam in emacs leads to the following error:

    File is missing: Cannot open load file, No such file or directory, emacsql-sqlite

    To ensure normal operation, you should investigate and remove the
    cause of the error in your initialization file.  Start Emacs with
    the ‘--debug-init’ option to view a complete error backtrace.

and the full backtrace from `--debug-init` is:

    Debugger entered--Lisp error: (file-missing "Cannot open load file" "No such file or directory" "emacsql-sqlite")
      require(emacsql-sqlite)
      load-with-code-conversion("/usr/share/emacs/site-lisp/elpa/org-roam-2.3.1/org-roam.el" "/usr/share/emacs/site-lisp/elpa/org-roam-2.3.1/org-roam.el" nil t)
      require(org-roam)

I suggest that elpa-emacsql-sqlite be added as a requirement for
elpa-org-roam (however, I think that things have changed for the
latest version of org-roam so this may apply only to the version
currently on Debian stable).

Best wishes
David

Hi,

David Miguel Susano Pinto <carandraug+dev@gmail.com> writes:

[snip]

Agreed

Elpa-emacsql-sqlite is an empty dummy package in sid/unstable and this
bug this only affects trixie.  I think this bug meets the criteria for a
stable update because the regression risk is zero.

Give me a few minutes to make the upload and file the unblock bug, but
please ping me if you don't see an unblock bug in a week.

Cheers,
Nicholas

Nicholas D Steeves <nsteeves@gmail.com> writes:

Note that currently trixie and sid/forky share the same version of
elpa-org-roam (2.3.1-1). You cannot upload a higher version in stable
(yet) because there is no version available in between and hence there
is no upgrade path (and your upload to stable-proposed-updates will
likely be rejected with the same reason).

I think you'll need to first upload a no-op 2.3.1-2 and wait for it to
enter Forky, and then prepare 2.3.1-1+deb13u1 for stable so that an
upgrade path is available.

P.S. For stable updates the bug it fixes also needs to be important or
above. I have bumped the severity to important here as well.

Xiyue Deng <manphiz@gmail.com> writes:

+deb13u1 is the "in between" version...the upgrade path is 2.3.1-1,
2.3.1-1+deb13u1, (>> 2.3.1-1+deb13u1).  Point release manager will
install +deb13u1 to testing and unstable when it is installed to
stable-updates, when that is the most correct action.

No, when dependencies are wrong they also need to be fixed in sid and
testing, so I have fixed it there too.

This is actually an RC bug that would have been caught if the
Uploader[s] of this package installed and used the package.

Cheers,
Nicholas

We believe that the bug you reported is fixed in the latest version of
org-roam, which is due to be installed in the Debian FTP archive.

A summary of the changes between this version and the previous one is
attached.

Thank you for reporting the bug, which will now be closed.  If you
have further comments please address them to 1144053@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Nicholas D Steeves <sten@debian.org> (supplier of updated org-roam package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmaster@ftp-master.debian.org)
Format: 1.8
Date: Tue, 11 Aug 2026 14:52:45 -0400
Source: org-roam
Architecture: source
Version: 2.3.1-1+deb13u1
Distribution: trixie
Urgency: medium
Maintainer: Debian Emacsen team <debian-emacsen@lists.debian.org>
Changed-By: Nicholas D Steeves <sten@debian.org>
Closes: 1144053
Changes:
 org-roam (2.3.1-1+deb13u1) trixie; urgency=medium
 .
   * Team upload.
   * Resolve undeclared mandatory dependency.  Org-roam does not function
     without emacsql-sqlite.el.  In trixie this library is provided by
     elpa-emacsql-sqlite, and this dependency must be declared
     (Closes: #1144053).
Checksums-Sha1:
 215275cf2ca7547b808e94626fbfa5e19241cac2 2259 org-roam_2.3.1-1+deb13u1.dsc
 3b2a5ffe2c7521ee81cc071d1c9190313feba32b 5952 org-roam_2.3.1-1+deb13u1.debian.tar.xz
 96f7778a65cae295947d1966b6a6ce4667702d6d 9576 org-roam_2.3.1-1+deb13u1_amd64.buildinfo
Checksums-Sha256:
 20f03d91b8580d975e79864e7384148298d0781bd8c1b9804061edc80b148796 2259 org-roam_2.3.1-1+deb13u1.dsc
 5db46c74460576bcb9fcd86a728c818713d5b0225a83d0684bc613608a5e9ea8 5952 org-roam_2.3.1-1+deb13u1.debian.tar.xz
 9da87a1648aa051473e162108310d112b5f5204ac3fd69afa8382e12409f9886 9576 org-roam_2.3.1-1+deb13u1_amd64.buildinfo
Files:
 470fa86d091ccdf246cb372a36ebfa78 2259 editors optional org-roam_2.3.1-1+deb13u1.dsc
 366ca1dbae79c09e5968c89d7df31734 5952 editors optional org-roam_2.3.1-1+deb13u1.debian.tar.xz
 5a5b04932f57886c9fdaa0596a44f995 9576 editors optional org-roam_2.3.1-1+deb13u1_amd64.buildinfo
-----BEGIN PGP SIGNATURE-----

iQIzBAEBCgAdFiEE4qYmHjkArtfNxmcIWogwR199EGEFAmp7dXgACgkQWogwR199
EGE0Ig//Q5xDdOS2UUjSn5GQ108rlkQKSVWYd/5two4+NYOULF+v48TJD/Ax9izS
0tGGvWA+e0RV8t8zqxvkqyugithHlr4eViI3lTtg0mIV2g4nwZkePGyclUkg2+8A
fTUhigWVdViFg/No7Tsr1kUNGdRwe53NNRNEWfgwgjqMnmbJ9dgT01L1zejIdQfb
Nc2jdKQsdhZzDOY0Bt6AbYiyGTVPZFFgUGiAT1frVH6gINAXgtwysc0WUdzv3/Xc
dw9hR9UVGIwcroRQU1Ylj45qq9FvTOpZeJngMZo/OVKb48JA6+j+tJDtwxwUwqXo
nEJUq+o2UfC47I3LwfQYPilI95hZqx0n/2S7S6L8GYSOerCH6FUJ9JZ4azhqbwac
5US7tAtWP0yAhk477kh8Zt64yhjXBDaeF++TEZga2dNqTXd9UmTg82T+QrwIVeQU
UuKVkPxEjrete8qqTMackM0qyVg53H0QWLxxR7DXWB+1jzItGtCNoJuzLcfoyQLg
Jf2Bma3/6efy6jhfsxhVijlsVevp4jZu4rXhes8UoGW8kbDr/SxglEcH3Id152ms
wVgQ62CilhY59dhZYKWu2+JDCC/Z635HDba8g5hnQyugfCW5XBhc0YU+LDFG1QTu
qLTagzRy0/7b7+iH5t2QoLtNskgaoC8BLEap8p9yuNikn4VGEVU=
=1/0h
-----END PGP SIGNATURE-----