Bug#1091945: marked as done (org-roam: FTBFS: error: (void-function emacsql-sqlite))

To: Xiyue Deng <manphiz@gmail.com>
Subject: Bug#1091945: marked as done (org-roam: FTBFS: error: (void-function emacsql-sqlite))
From: "Debian Bug Tracking System" <owner@bugs.debian.org>
Date: Tue, 14 Jan 2025 21:42:03 +0000
Message-id: <[🔎] handler.1091945.D1091945.17368907221364218.ackdone@bugs.debian.org>
Reply-to: 1091945@bugs.debian.org
References: <E1tXocS-005b3l-0S@fasolo.debian.org> <[🔎] E1tTPdI-00GO2Y-Th@paradis.debian.org>

Your message dated Tue, 14 Jan 2025 21:38:40 +0000
with message-id <E1tXocS-005b3l-0S@fasolo.debian.org>
and subject line Bug#1091945: fixed in org-roam 2.2.2+git20250111.425d53d-1
has caused the Debian Bug report #1091945,
regarding org-roam: FTBFS: error: (void-function emacsql-sqlite)
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact owner@bugs.debian.org
immediately.)


-- 
1091945: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1091945
Debian Bug Tracking System
Contact owner@bugs.debian.org with problems

--- Begin Message ---

To: Debian BTS <submit@bugs.debian.org>
Subject: org-roam: FTBFS: error: (void-function emacsql-sqlite)
From: Santiago Vila <sanvila@debian.org>
Date: Thu, 02 Jan 2025 18:09:20 +0000
Message-id: <[🔎] E1tTPdI-00GO2Y-Th@paradis.debian.org>

Package: src:org-roam
Version: 2.2.2-4
Severity: serious
Tags: ftbfs trixie sid

Dear maintainer:

During a rebuild of all packages in unstable, your package failed to build:

--------------------------------------------------------------------------------
[...]
 debian/rules clean
dh clean --with elpa
   dh_clean
 debian/rules binary
dh binary --with elpa
   dh_update_autotools_config
   dh_autoreconf
   dh_auto_configure
   debian/rules override_dh_auto_build
make[1]: Entering directory '/<<PKGBUILDDIR>>'
rm -f doc/org-roam.texi
make -C doc texi
make[2]: Entering directory '/<<PKGBUILDDIR>>/doc'
Loading /etc/emacs/site-start.d/00debian.el (source)...

[... snipped ...]

Î» (emacsql-sqlite "/tmp/org-roam.db")
error: (void-function emacsql-sqlite)

========================================
[31morg-roam-db-sync has the correct number of nodes[0m

Traceback (most recent call last):
M (car
   (car
    (org-roam-db-query
     [:select
      (funcall count)
      :from nodes])))
M (car
   (org-roam-db-query
    [:select
     (funcall count)
     :from nodes]))
Î» (org-roam-db-query
   [:select
    (funcall count)
    :from nodes])
M (apply #'emacsql
         (org-roam-db)
         sql args)
Î» (org-roam-db)
M (if
      (and
       (org-roam-db--get-connection)
       (emacsql-live-p
        (org-roam-db--get-connection)))
      nil
    (let
        ((init-db
  	(not
  	 (file-exists-p org-roam-db-location))))
      (make-directory
       (file-name-directory org-roam-db-location)
       t)
      (let
  	((conn
  	  (funcall
  	   (org-roam-db--conn-fn)
  	   org-roam-db-location)))
        (emacsql conn
  	       [:pragma
  		(= foreign_keys ON)])
        (let*
  	  ((process
  	    (and t
  		 (emacsql-process conn)))
  	   (_
  	    (and process
  		 (processp process))))
  	(if _
  	    (set-process-query-on-exit-flag process nil)))
        (puthash
         (expand-file-name
  	(file-name-as-directory org-roam-directory))
         conn org-roam-db--connection)
        (if init-db
  	  (progn
  	    (org-roam-db--init conn)))
        (let*
  	  ((version
  	    (car
  	     (car
  	      (emacsql conn "PRAGMA user_version"))))
  	   (version
  	    (org-roam-db--upgrade-maybe conn version)))
  	(cond
  	 ((> version org-roam-db-version)
  	  (emacsql-close conn)
  	  (user-error "The Org-roam database was created with a newer Org-roam version.  " "You need to update the Org-roam package"))
  	 ((< version org-roam-db-version)
  	  (emacsql-close conn)
  	  (error "BUG: The Org-roam database scheme changed %s" "and there is no upgrade path")))))))
M (let
      ((init-db
        (not
         (file-exists-p org-roam-db-location))))
    (make-directory
     (file-name-directory org-roam-db-location)
     t)
    (let
        ((conn
  	(funcall
  	 (org-roam-db--conn-fn)
  	 org-roam-db-location)))
      (emacsql conn
  	     [:pragma
  	      (= foreign_keys ON)])
      (let*
  	((process
  	  (and t
  	       (emacsql-process conn)))
  	 (_
  	  (and process
  	       (processp process))))
        (if _
  	  (set-process-query-on-exit-flag process nil)))
      (puthash
       (expand-file-name
        (file-name-as-directory org-roam-directory))
       conn org-roam-db--connection)
      (if init-db
  	(progn
  	  (org-roam-db--init conn)))
      (let*
  	((version
  	  (car
  	   (car
  	    (emacsql conn "PRAGMA user_version"))))
  	 (version
  	  (org-roam-db--upgrade-maybe conn version)))
        (cond
         ((> version org-roam-db-version)
  	(emacsql-close conn)
  	(user-error "The Org-roam database was created with a newer Org-roam version.  " "You need to update the Org-roam package"))
         ((< version org-roam-db-version)
  	(emacsql-close conn)
  	(error "BUG: The Org-roam database scheme changed %s" "and there is no upgrade path"))))))
M (let
      ((conn
        (funcall
         (org-roam-db--conn-fn)
         org-roam-db-location)))
    (emacsql conn
  	   [:pragma
  	    (= foreign_keys ON)])
    (let*
        ((process
  	(and t
  	     (emacsql-process conn)))
         (_
  	(and process
  	     (processp process))))
      (if _
  	(set-process-query-on-exit-flag process nil)))
    (puthash
     (expand-file-name
      (file-name-as-directory org-roam-directory))
     conn org-roam-db--connection)
    (if init-db
        (progn
  	(org-roam-db--init conn)))
    (let*
        ((version
  	(car
  	 (car
  	  (emacsql conn "PRAGMA user_version"))))
         (version
  	(org-roam-db--upgrade-maybe conn version)))
      (cond
       ((> version org-roam-db-version)
        (emacsql-close conn)
        (user-error "The Org-roam database was created with a newer Org-roam version.  " "You need to update the Org-roam package"))
       ((< version org-roam-db-version)
        (emacsql-close conn)
        (error "BUG: The Org-roam database scheme changed %s" "and there is no upgrade path")))))
Î» (funcall emacsql-sqlite "/tmp/org-roam.db")
Î» (emacsql-sqlite "/tmp/org-roam.db")
error: (void-function emacsql-sqlite)

========================================
[31morg-roam-db-sync has the correct number of links[0m

Traceback (most recent call last):
M (car
   (car
    (org-roam-db-query
     [:select
      (funcall count)
      :from links])))
M (car
   (org-roam-db-query
    [:select
     (funcall count)
     :from links]))
Î» (org-roam-db-query
   [:select
    (funcall count)
    :from links])
M (apply #'emacsql
         (org-roam-db)
         sql args)
Î» (org-roam-db)
M (if
      (and
       (org-roam-db--get-connection)
       (emacsql-live-p
        (org-roam-db--get-connection)))
      nil
    (let
        ((init-db
  	(not
  	 (file-exists-p org-roam-db-location))))
      (make-directory
       (file-name-directory org-roam-db-location)
       t)
      (let
  	((conn
  	  (funcall
  	   (org-roam-db--conn-fn)
  	   org-roam-db-location)))
        (emacsql conn
  	       [:pragma
  		(= foreign_keys ON)])
        (let*
  	  ((process
  	    (and t
  		 (emacsql-process conn)))
  	   (_
  	    (and process
  		 (processp process))))
  	(if _
  	    (set-process-query-on-exit-flag process nil)))
        (puthash
         (expand-file-name
  	(file-name-as-directory org-roam-directory))
         conn org-roam-db--connection)
        (if init-db
  	  (progn
  	    (org-roam-db--init conn)))
        (let*
  	  ((version
  	    (car
  	     (car
  	      (emacsql conn "PRAGMA user_version"))))
  	   (version
  	    (org-roam-db--upgrade-maybe conn version)))
  	(cond
  	 ((> version org-roam-db-version)
  	  (emacsql-close conn)
  	  (user-error "The Org-roam database was created with a newer Org-roam version.  " "You need to update the Org-roam package"))
  	 ((< version org-roam-db-version)
  	  (emacsql-close conn)
  	  (error "BUG: The Org-roam database scheme changed %s" "and there is no upgrade path")))))))
M (let
      ((init-db
        (not
         (file-exists-p org-roam-db-location))))
    (make-directory
     (file-name-directory org-roam-db-location)
     t)
    (let
        ((conn
  	(funcall
  	 (org-roam-db--conn-fn)
  	 org-roam-db-location)))
      (emacsql conn
  	     [:pragma
  	      (= foreign_keys ON)])
      (let*
  	((process
  	  (and t
  	       (emacsql-process conn)))
  	 (_
  	  (and process
  	       (processp process))))
        (if _
  	  (set-process-query-on-exit-flag process nil)))
      (puthash
       (expand-file-name
        (file-name-as-directory org-roam-directory))
       conn org-roam-db--connection)
      (if init-db
  	(progn
  	  (org-roam-db--init conn)))
      (let*
  	((version
  	  (car
  	   (car
  	    (emacsql conn "PRAGMA user_version"))))
  	 (version
  	  (org-roam-db--upgrade-maybe conn version)))
        (cond
         ((> version org-roam-db-version)
  	(emacsql-close conn)
  	(user-error "The Org-roam database was created with a newer Org-roam version.  " "You need to update the Org-roam package"))
         ((< version org-roam-db-version)
  	(emacsql-close conn)
  	(error "BUG: The Org-roam database scheme changed %s" "and there is no upgrade path"))))))
M (let
      ((conn
        (funcall
         (org-roam-db--conn-fn)
         org-roam-db-location)))
    (emacsql conn
  	   [:pragma
  	    (= foreign_keys ON)])
    (let*
        ((process
  	(and t
  	     (emacsql-process conn)))
         (_
  	(and process
  	     (processp process))))
      (if _
  	(set-process-query-on-exit-flag process nil)))
    (puthash
     (expand-file-name
      (file-name-as-directory org-roam-directory))
     conn org-roam-db--connection)
    (if init-db
        (progn
  	(org-roam-db--init conn)))
    (let*
        ((version
  	(car
  	 (car
  	  (emacsql conn "PRAGMA user_version"))))
         (version
  	(org-roam-db--upgrade-maybe conn version)))
      (cond
       ((> version org-roam-db-version)
        (emacsql-close conn)
        (user-error "The Org-roam database was created with a newer Org-roam version.  " "You need to update the Org-roam package"))
       ((< version org-roam-db-version)
        (emacsql-close conn)
        (error "BUG: The Org-roam database scheme changed %s" "and there is no upgrade path")))))
Î» (funcall emacsql-sqlite "/tmp/org-roam.db")
Î» (emacsql-sqlite "/tmp/org-roam.db")
error: (void-function emacsql-sqlite)

========================================
[31morg-roam-db-sync respects ROAM_EXCLUDE[0m

Traceback (most recent call last):
M (mapcar #'car
  	(org-roam-db-query
  	 [:select id :from nodes]))
Î» (org-roam-db-query
   [:select id :from nodes])
M (apply #'emacsql
         (org-roam-db)
         sql args)
Î» (org-roam-db)
M (if
      (and
       (org-roam-db--get-connection)
       (emacsql-live-p
        (org-roam-db--get-connection)))
      nil
    (let
        ((init-db
  	(not
  	 (file-exists-p org-roam-db-location))))
      (make-directory
       (file-name-directory org-roam-db-location)
       t)
      (let
  	((conn
  	  (funcall
  	   (org-roam-db--conn-fn)
  	   org-roam-db-location)))
        (emacsql conn
  	       [:pragma
  		(= foreign_keys ON)])
        (let*
  	  ((process
  	    (and t
  		 (emacsql-process conn)))
  	   (_
  	    (and process
  		 (processp process))))
  	(if _
  	    (set-process-query-on-exit-flag process nil)))
        (puthash
         (expand-file-name
  	(file-name-as-directory org-roam-directory))
         conn org-roam-db--connection)
        (if init-db
  	  (progn
  	    (org-roam-db--init conn)))
        (let*
  	  ((version
  	    (car
  	     (car
  	      (emacsql conn "PRAGMA user_version"))))
  	   (version
  	    (org-roam-db--upgrade-maybe conn version)))
  	(cond
  	 ((> version org-roam-db-version)
  	  (emacsql-close conn)
  	  (user-error "The Org-roam database was created with a newer Org-roam version.  " "You need to update the Org-roam package"))
  	 ((< version org-roam-db-version)
  	  (emacsql-close conn)
  	  (error "BUG: The Org-roam database scheme changed %s" "and there is no upgrade path")))))))
M (let
      ((init-db
        (not
         (file-exists-p org-roam-db-location))))
    (make-directory
     (file-name-directory org-roam-db-location)
     t)
    (let
        ((conn
  	(funcall
  	 (org-roam-db--conn-fn)
  	 org-roam-db-location)))
      (emacsql conn
  	     [:pragma
  	      (= foreign_keys ON)])
      (let*
  	((process
  	  (and t
  	       (emacsql-process conn)))
  	 (_
  	  (and process
  	       (processp process))))
        (if _
  	  (set-process-query-on-exit-flag process nil)))
      (puthash
       (expand-file-name
        (file-name-as-directory org-roam-directory))
       conn org-roam-db--connection)
      (if init-db
  	(progn
  	  (org-roam-db--init conn)))
      (let*
  	((version
  	  (car
  	   (car
  	    (emacsql conn "PRAGMA user_version"))))
  	 (version
  	  (org-roam-db--upgrade-maybe conn version)))
        (cond
         ((> version org-roam-db-version)
  	(emacsql-close conn)
  	(user-error "The Org-roam database was created with a newer Org-roam version.  " "You need to update the Org-roam package"))
         ((< version org-roam-db-version)
  	(emacsql-close conn)
  	(error "BUG: The Org-roam database scheme changed %s" "and there is no upgrade path"))))))
M (let
      ((conn
        (funcall
         (org-roam-db--conn-fn)
         org-roam-db-location)))
    (emacsql conn
  	   [:pragma
  	    (= foreign_keys ON)])
    (let*
        ((process
  	(and t
  	     (emacsql-process conn)))
         (_
  	(and process
  	     (processp process))))
      (if _
  	(set-process-query-on-exit-flag process nil)))
    (puthash
     (expand-file-name
      (file-name-as-directory org-roam-directory))
     conn org-roam-db--connection)
    (if init-db
        (progn
  	(org-roam-db--init conn)))
    (let*
        ((version
  	(car
  	 (car
  	  (emacsql conn "PRAGMA user_version"))))
         (version
  	(org-roam-db--upgrade-maybe conn version)))
      (cond
       ((> version org-roam-db-version)
        (emacsql-close conn)
        (user-error "The Org-roam database was created with a newer Org-roam version.  " "You need to update the Org-roam package"))
       ((< version org-roam-db-version)
        (emacsql-close conn)
        (error "BUG: The Org-roam database scheme changed %s" "and there is no upgrade path")))))
Î» (funcall emacsql-sqlite "/tmp/org-roam.db")
Î» (emacsql-sqlite "/tmp/org-roam.db")
error: (void-function emacsql-sqlite)

Ran 13 specs, [31m4 failed[0m, in 287.53ms.
buttercup-run failed: ""
dh_elpa_test: error: buttercup -L . --traceback pretty returned exit code 255
make: *** [debian/rules:4: binary] Error 25
dpkg-buildpackage: error: debian/rules binary subprocess returned exit status 2
--------------------------------------------------------------------------------

The above is just how the build ends and not necessarily the most relevant part.
If required, the full build log is available here:

https://people.debian.org/~sanvila/build-logs/202501/

About the archive rebuild: The build was made on virtual machines from AWS,
using sbuild and a reduced chroot with only build-essential packages.

If you could not reproduce the bug please contact me privately, as I
am willing to provide ssh access to a virtual machine where the bug is
fully reproducible.

If this is really a bug in one of the build-depends, please use
reassign and add an affects on src:org-roam, so that this is still
visible in the BTS web page for this package.

Thanks.

--- End Message ---

--- Begin Message ---

To: 1091945-close@bugs.debian.org
Subject: Bug#1091945: fixed in org-roam 2.2.2+git20250111.425d53d-1
From: Debian FTP Masters <ftpmaster@ftp-master.debian.org>
Date: Tue, 14 Jan 2025 21:38:40 +0000
Message-id: <E1tXocS-005b3l-0S@fasolo.debian.org>
Reply-to: Xiyue Deng <manphiz@gmail.com>

Source: org-roam
Source-Version: 2.2.2+git20250111.425d53d-1
Done: Xiyue Deng <manphiz@gmail.com>

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 1091945@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Xiyue Deng <manphiz@gmail.com> (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)


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

Format: 1.8
Date: Sat, 11 Jan 2025 15:53:19 -0800
Source: org-roam
Architecture: source
Version: 2.2.2+git20250111.425d53d-1
Distribution: unstable
Urgency: medium
Maintainer: Debian Emacsen team <debian-emacsen@lists.debian.org>
Changed-By: Xiyue Deng <manphiz@gmail.com>
Closes: 1048517 1076359 1091945
Changes:
 org-roam (2.2.2+git20250111.425d53d-1) unstable; urgency=medium
 .
   * Update to new upstream snapshot 2.2.2+git20250111.425d53d (Closes:
     #1048517, #1091945)
   * Update d/watch using substitute strings to be more robust
   * Set upstream metadata fields: Bug-Database, Bug-Submit,
     Repository-Browse.
   * Update Standards-Version to 4.7.0; no change needed
   * Set section of org-roam-doc to doc (Closes: #1076359)
   * Add d/org-roam-doc.doc-base for doc-base registration
   * Drop oldoldstable emacs version from Recommends
   * Add myself to Uploaders
   * Add d/gbp.conf matching the current practice
   * Add d/README.source documenting the dgit-maint-debrebase workflow
   * Use regexp match to replace hard-coded path equal test
   * Comment out flaky check in org-roam-file-p test
   * Set org-roam-directory to a non-existent path to ensure robust test
Checksums-Sha1:
 e8fb17095e83bdca7118c81aa9bac4b150444445 2485 org-roam_2.2.2+git20250111.425d53d-1.dsc
 aa15be40a318987725b2c7e5c586b76b8c40070a 34436380 org-roam_2.2.2+git20250111.425d53d.orig.tar.xz
 204071a8ef18377491b73e890e7d3dc62f2f4ddf 5416 org-roam_2.2.2+git20250111.425d53d-1.debian.tar.xz
Checksums-Sha256:
 d7e6b7c321872921049f8f9fe0371eb7e4fd7d7380d77f9c04d56ffdd7d91508 2485 org-roam_2.2.2+git20250111.425d53d-1.dsc
 09a54839e7cd391baef02c53532455dca8c978f5bd329b7e0a9f7430426046f2 34436380 org-roam_2.2.2+git20250111.425d53d.orig.tar.xz
 93997659c717bdd54a2baa8e584af2153dd9fb040dc1b1f966047d29adfb565f 5416 org-roam_2.2.2+git20250111.425d53d-1.debian.tar.xz
Files:
 57a2eb22f2476037048dbe7f4a3af87f 2485 editors optional org-roam_2.2.2+git20250111.425d53d-1.dsc
 c7ba4b12aa36d6006f668c3e96a567c0 34436380 editors optional org-roam_2.2.2+git20250111.425d53d.orig.tar.xz
 86a966d6e5122e0d118553f4f587c9ea 5416 editors optional org-roam_2.2.2+git20250111.425d53d-1.debian.tar.xz

-----BEGIN PGP SIGNATURE-----

iQIzBAEBCgAdFiEEn7AKhFUciKVyzk7dN19hUwLeWCgFAmeG1bcACgkQN19hUwLe
WCjAwRAArAKrBPFL0x4Kx5a78waoN9YXbo+O7nGTVj9eHPH/swUlLdb02fgJS4Xv
YGLqKevcMwOqzJvG8KiLoQYws4m+FxLQbflVzKcXgdSOenf5BXSBnKp2Ph/3/ibL
ofYvAlqcPRrdmfrYmQJMHPfOn4HCLD85yEf6gKmkIVaAvCjikku2nJ9rngfKp7eE
GMIblqLkiskvPgK96dA9tposAZQ54d72fVNXD8/PDWmvxw/DiyoY/t7GG4Mk0HG4
23v8+k+w/jWjXRHMTrIIZRfUHxNp4KFQECdut89dH58fLbB0rYI+7ND0lsG4VOg0
ZQyDnJn2twL1Xy+AbcUpHvxNlWruEZ05IoeHQ0yNb3jgQL8B4Dl+LNeRRzMrJNFm
PsodBWZiH4RBUhqBoxfZiPrKWsnmFdh+taQ13LPbuRiCxRiw9kQQsTgHJ+3zGcDB
70s+3M0XuVWs3ro3FK9amS0HE7IbKXuss5R7HjrYKhe0SW5fPhhYrYE2SYvYuIIC
mVncUB7/AU4dIDrd4b4aistBtnTrzDs0DhU4G9q4JfHNo+ci0a3uBRBVcGpYE8T4
OIxX78eocxIftHqhxL89VDeqsaGPh280olsovA0qvHFA2N+k23VnRFt8DziZTLGi
Z3EDmQmIvVXs1OdBHGCrbPL8ZOnFZyhkj4os3KxnbRtAXf4gmXQ=
=8AD2
-----END PGP SIGNATURE-----

Attachment: pgpbjQ0Rr8OLU.pgp
Description: PGP signature

--- End Message ---

Reply to:

References:
- Bug#1091945: org-roam: FTBFS: error: (void-function emacsql-sqlite)
  - From: Santiago Vila <sanvila@debian.org>

Prev by Date: Bug#1076359: marked as done (org-roam-doc: Section should be “doc”)
Next by Date: Processing of org-roam_2.2.2+git20250111.425d53d-1_source.changes
Previous by thread: Bug#1091945: org-roam: FTBFS: error: (void-function emacsql-sqlite)
Next by thread: Processing of elpa-transient_0.8.2-1_source.changes
Index(es):
- Date
- Thread