Rocksolid Light

Welcome to RetroBBS

mail  files  register  newsreader  groups  login

Message-ID:  

You can't cheat the phone company.

computers / gnu.emacs.help / Re: Problem with org-roam

SubjectAuthor
* Problem with org-roamCecil Westerhof
`- Re: Problem with org-roamCecil Westerhof

1
Problem with org-roam

<87sf4ink31.fsf@munus.decebal.nl>

  copy mid

https://www.rocksolidbbs.com/computers/article-flat.php?id=34&group=gnu.emacs.help#34

  copy link   Newsgroups: gnu.emacs.help
Path: i2pn2.org!i2pn.org!news.furie.org.uk!usenet.goja.nl.eu.org!weretis.net!feeder8.news.weretis.net!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: Cecil@decebal.nl (Cecil Westerhof)
Newsgroups: gnu.emacs.help
Subject: Problem with org-roam
Date: Mon, 04 Dec 2023 15:00:50 +0100
Organization: Decebal Computing
Lines: 76
Message-ID: <87sf4ink31.fsf@munus.decebal.nl>
MIME-Version: 1.0
Content-Type: text/plain
Injection-Info: dont-email.me; posting-host="45c5a77c49a2ee0602001658fb2ed72f";
logging-data="3628118"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+0xaoosQxS9BxFd7vZKJWRL+CyVskTnRI="
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.2 (gnu/linux)
Cancel-Lock: sha1:9sYBSr2viNGnsGB/B+s+vOvFvjA=
sha1:6BN4ziwaI4/Rnto2jTBwzhwLYqA=
 by: Cecil Westerhof - Mon, 4 Dec 2023 14:00 UTC

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

Re: Problem with org-roam

<87a5qnoamc.fsf@munus.decebal.nl>

  copy mid

https://www.rocksolidbbs.com/computers/article-flat.php?id=35&group=gnu.emacs.help#35

  copy link   Newsgroups: gnu.emacs.help
Path: i2pn2.org!i2pn.org!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: Cecil@decebal.nl (Cecil Westerhof)
Newsgroups: gnu.emacs.help
Subject: Re: Problem with org-roam
Date: Wed, 06 Dec 2023 12:04:27 +0100
Organization: Decebal Computing
Lines: 82
Message-ID: <87a5qnoamc.fsf@munus.decebal.nl>
References: <87sf4ink31.fsf@munus.decebal.nl>
MIME-Version: 1.0
Content-Type: text/plain
Injection-Info: dont-email.me; posting-host="03ed7f2388845c33948a9f975f24f559";
logging-data="792112"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19ULIeqOt+vhmtcNnUdJ8a4Cb70I98Pzdw="
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.2 (gnu/linux)
Cancel-Lock: sha1:Pw1Oa0yuYSvOKLwi4+x0lteAMYI=
sha1:foz3KOlDFmxI/wKk1vdR4BR9FtA=
 by: Cecil Westerhof - Wed, 6 Dec 2023 11:04 UTC

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

computers / gnu.emacs.help / Re: Problem with org-roam

1
server_pubkey.txt

rocksolid light 0.9.81
clearnet tor