ElementsProject / lightning

Core Lightning — Lightning Network implementation focusing on spec compliance and performance
Other
2.81k stars 887 forks source link

lightningd: SQLITE version mismatch: compiled 3031001, now 3037002 - after ubuntu upgrade fm 20.04 to 22.04 #6088

Closed NVG2021 closed 1 year ago

NVG2021 commented 1 year ago

Issue and Steps to Reproduce

As the title says, I've upgraded Ubuntu to the newest version and my c-lightning node does not boot and provides the SQLite mismatch version

I've seen that I have to recompile... but no idea what command/s should I use to perform this and if I may have to do a previous back-up just in case-....

Many thanks before hand Nicolas

getinfo output

vincenzopalazzo commented 1 year ago

Or you try the new binary that you find inside the release page regarding your version of ubuntu, or if it is not supported with the binary you need to compile from source

NVG2021 commented 1 year ago

Hi Vincenzo, many thanks for your reply and just wanted to say the following: I've been able to navigate trhough the directories and my Lightning versionis "The long wait is over: the c-lightning team is excited to announce the 0.6 release of [c-lightning][clightning]" and I've installed in August 21... My memory does not stand how I did things since then.... so ... I may need a more detaild help if possible on what commands should I perform... I know you are a pro, but not myself...

Thank you

vincenzopalazzo commented 1 year ago

Mh, ok so what version of ubuntu are you running?

rustyrussell commented 1 year ago

It depends how you installed CLN in the first place :(

  1. Where is CLN? Try which lightningd.
  2. If it's in /usr/local/bin, then you can simply install the new one over the top:
    1. Grab https://github.com/ElementsProject/lightning/releases/download/v23.02/clightning-v23.02-Ubuntu-22.04.tar.xz into /tmp/
    2. cd / && sudo tar xfa /tmp/clightning-v23.02-Ubuntu-22.04.tar.xz
  3. If it's in /usr/bin or something, you might have installed the old PPA? In that case:
    1. Try dpkg -S $(which lightningd) and it will tell you the package name, and uninstall it with sudo apt-get remove PKGNAME.
    2. download and install as above. Hope that helps!
NVG2021 commented 1 year ago

Hi, now i am running Ubuntu 22.04 lts Thanks

Nicolas Velasco

El 13 mar 2023, a las 23:49, Rusty Russell @.***> escribió:



It depends how you installed CLN in the first place :(

  1. Where is CLN? Try which lightningd.
  2. If it's in /usr/local/bin, then you can simply install the new one over the top:
  3. If it's in /usr/bin or something, you might have installed the old PPA? In that case:
    • Try dpkg -S $(which lightningd) and it will tell you the package name, and uninstall it with sudo apt-get remove PKGNAME.
    • download and install as above. Hope that helps!

— Reply to this email directly, view it on GitHubhttps://github.com/ElementsProject/lightning/issues/6088#issuecomment-1467081423, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AVUAE6BDS37TMR7RJ65223LW36P7NANCNFSM6AAAAAAVYHLNLY. You are receiving this because you authored the thread.Message ID: @.***>

[Atención: E-mail Externo- Revise el contenido para verificar la autenticidad del remitente //--------------------------------------------------------------------// Por favor, revise nuestra política de protección de datos: Per favor, revisi la nostra política de protecció de dades: https://www.nironet.es/politicas-de-cookies-y-proteccion-de-datos-2 Antes de imprimir este e-mail, piense en si es realmente necesario: El Medio Ambiente es responsabilidad de todos. Abans d'imprimir aquest e-mail, pensi en si és realment necessari: El Medi ambient és responsabilitat de tots. * Before printing this e-mail, think if you really need to so. The environment is everyone's responsibility. //--------------------------------------------------------------------//

NVG2021 commented 1 year ago

Hi, thank you for the hints and support and I’ve followed your guide with no luck so far My lightningd file was on /usr/local/bin

And after performing the next steps, message is the same @.:/tmp$ ls anydesk clightning-v23.02-Ubuntu-22.04.tar.xz @.:/tmp$ cd / && sudo tar xfa /tmp/clightning-v23.02-Ubuntu-22.04.tar.xz [sudo] password for nicolas: @.:/$ cd /home/nicolas @.:~$ lightningd lightningd: SQLITE version mismatch: compiled 3031001, now 3037002

I’ve rebooted the system and same result… When checking /usr/bin/local directory… the list of files show this @.***

And on /usr/bin directory I’ve found these @.***

Maybe I have to move them from /usr/bin to /usr/bin/local ???

Thank you!

Nicolas Velasco Gestion – Formación Empresas - Energía

@.*** http://www.nironet.eshttp://www.nironet.es/ [twitter]https://twitter.com/NironetSchool[símbolos-redes-sociales-02-1]https://www.facebook.com/Nironet Nironet SL Barcelona – Vilanova i la Geltrú Tel: 938 106 596 Movil: (+34) 607 403 073

De: Rusty Russell @.> Enviado el: lunes, 13 de marzo de 2023 23:49 Para: ElementsProject/lightning @.> CC: Nicolas Velasco - NR @.>; Author @.> Asunto: Re: [ElementsProject/lightning] lightningd: SQLITE version mismatch: compiled 3031001, now 3037002 - after ubuntu upgrade fm 20.04 to 22.04 (Issue #6088)

It depends how you installed CLN in the first place :(

  1. Where is CLN? Try which lightningd.
  2. If it's in /usr/local/bin, then you can simply install the new one over the top:
  3. If it's in /usr/bin or something, you might have installed the old PPA? In that case:
    • Try dpkg -S $(which lightningd) and it will tell you the package name, and uninstall it with sudo apt-get remove PKGNAME.
    • download and install as above. Hope that helps!

— Reply to this email directly, view it on GitHubhttps://github.com/ElementsProject/lightning/issues/6088#issuecomment-1467081423, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AVUAE6BDS37TMR7RJ65223LW36P7NANCNFSM6AAAAAAVYHLNLY. You are receiving this because you authored the thread.Message ID: @.**@.>> [Atención: E-mail Externo- Revise el contenido para verificar la autenticidad del remitente //--------------------------------------------------------------------// Por favor, revise nuestra política de protección de datos: Per favor, revisi la nostra política de protecció de dades: https://www.nironet.es/politicas-de-cookies-y-proteccion-de-datos-2 Antes de imprimir este e-mail, piense en si es realmente necesario: El Medio Ambiente es responsabilidad de todos. Abans d'imprimir aquest e-mail, pensi en si és realment necessari: El Medi ambient és responsabilitat de tots. * Before printing this e-mail, think if you really need to so. The environment is everyone's responsibility. //--------------------------------------------------------------------//

NVG2021 commented 1 year ago

Hi there,

After sending you my previous mail in which the new files where in different location than old file, I’ve copied (and saved the old ones) I’ve copied lightningd & lightning-hsmtool to /usr/local/bin And then executed lightningd from my home directory… and I’ve got the following answer

@.*:~$ lightningd 2023-03-15T18:37:35.243Z UNUSUAL plugin-fetchinvoice: Killing plugin: could not register hook 'onion_message_blinded', either the name doesn't exist or another plugin already registered it. 2023-03-15T18:37:35.262Z BROKEN** plugin-fetchinvoice: Plugin marked as important, shutting down lightningd! lightningd: lightningd/plugin.c:1808: plugins_init: Assertion `ret == plugins' failed. lightningd: FATAL SIGNAL 6 (version 23.02) 0x560f06a58efe send_backtrace common/daemon.c:33 0x560f06a58f95 crashdump common/daemon.c:46 0x7fbd1a43b51f ??? ./signal/../sysdeps/unix/sysv/linux/x86_64/libc_sigaction.c:0 0x7fbd1a48fa7c pthread_kill_implementation ./nptl/pthread_kill.c:44 0x7fbd1a48fa7c __pthread_kill_internal ./nptl/pthread_kill.c:78 0x7fbd1a48fa7c GI_pthread_kill ./nptl/pthread_kill.c:89 0x7fbd1a43b475 __GI_raise ../sysdeps/posix/raise.c:26 0x7fbd1a4217f2 GI_abort ./stdlib/abort.c:79 0x7fbd1a42171a assert_fail_base ./assert/assert.c:92 0x7fbd1a432e95 GI_assert_fail ./assert/assert.c:101 0x560f06a34b44 plugins_init lightningd/plugin.c:1808 0x560f06a1375b main lightningd/lightningd.c:1009 0x7fbd1a422d8f libc_start_call_main ../sysdeps/nptl/libc_start_call_main.h:58 0x7fbd1a422e3f __libc_start_main_impl ../csu/libc-start.c:392 0x560f069f4d14 ??? ???:0 0xffffffffffffffff ??? ???:0 Traceback (most recent call last): File "/home/nicolas/.lightning/plugins/lightning-qt/lightning-qt.py", line 12, in from pyln.client import LightningRpc, Plugin, RpcError ModuleNotFoundError: No module named 'pyln' Aborted (core dumped)

And then I reminded that I should load with more details and I’ve got this @.:~/lightning$ lightningd --plugin=/home/nicolas/c-lightning-REST/plugin.js --rest-port=3001 lightningd: --plugin: Failed to register /home/nicolas/c-lightning-REST/plugin.js: Invalid argument @.:~/lightning$

it looks I am closer… but maybe not…. Any comment???

Many thanks

Nicolas Velasco Gestion – Formación Empresas - Energía

@.*** http://www.nironet.eshttp://www.nironet.es/ [twitter]https://twitter.com/NironetSchool[símbolos-redes-sociales-02-1]https://www.facebook.com/Nironet Nironet SL Barcelona – Vilanova i la Geltrú Tel: 938 106 596 Movil: (+34) 607 403 073

De: Rusty Russell @.> Enviado el: lunes, 13 de marzo de 2023 23:49 Para: ElementsProject/lightning @.> CC: Nicolas Velasco - NR @.>; Author @.> Asunto: Re: [ElementsProject/lightning] lightningd: SQLITE version mismatch: compiled 3031001, now 3037002 - after ubuntu upgrade fm 20.04 to 22.04 (Issue #6088)

It depends how you installed CLN in the first place :(

  1. Where is CLN? Try which lightningd.
  2. If it's in /usr/local/bin, then you can simply install the new one over the top:
  3. If it's in /usr/bin or something, you might have installed the old PPA? In that case:
    • Try dpkg -S $(which lightningd) and it will tell you the package name, and uninstall it with sudo apt-get remove PKGNAME.
    • download and install as above. Hope that helps!

— Reply to this email directly, view it on GitHubhttps://github.com/ElementsProject/lightning/issues/6088#issuecomment-1467081423, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AVUAE6BDS37TMR7RJ65223LW36P7NANCNFSM6AAAAAAVYHLNLY. You are receiving this because you authored the thread.Message ID: @.**@.>> [Atención: E-mail Externo- Revise el contenido para verificar la autenticidad del remitente //--------------------------------------------------------------------// Por favor, revise nuestra política de protección de datos: Per favor, revisi la nostra política de protecció de dades: https://www.nironet.es/politicas-de-cookies-y-proteccion-de-datos-2 Antes de imprimir este e-mail, piense en si es realmente necesario: El Medio Ambiente es responsabilidad de todos. Abans d'imprimir aquest e-mail, pensi en si és realment necessari: El Medi ambient és responsabilitat de tots. * Before printing this e-mail, think if you really need to so. The environment is everyone's responsibility. //--------------------------------------------------------------------//

vincenzopalazzo commented 1 year ago

This is the core of the problem now! looks like that there are two fetchinvoice plugin?

2023-03-15T18:37:35.243Z UNUSUAL plugin-fetchinvoice: Killing plugin: could not register hook 'onion_message_blinded', either the name doesn't exist or another plugin already registered it.
2023-03-15T18:37:35.262Z **BROKEN** plugin-fetchinvoice: Plugin marked as important, shutting down lightningd!
lightningd: lightningd/plugin.c:1808: plugins_init: Assertion `ret == plugins' failed.

I think while you are coping and pasting the following operation something when wrong

I’ve copied lightningd & lightning-hsmtool to /usr/local/bin

Now the suggestion that I can give you here is before clean up your /user/local/bin is to do the following steps

cd /tmp
mkdir lightning && cd lightning
wget https://github.com/ElementsProject/lightning/releases/download/v23.02.2/clightning-v23.02.2-Ubuntu-22.04.tar.xz
tar -czvf clightning-v23.02-Ubuntu-22.04.tar.xz  .
cd lightning
rm clightning-v23.02-Ubuntu-22.04.tar.xz
ls -la
./lightningd

This should run lightning in a new home (/tmp) and in this way we see if the error of the SQL db go away, and we can try to clean up you ppa later

P.S: Please note that my bash commands can be wrong in the sense that typos are always around, so do not just copy and paste them :)

NVG2021 commented 1 year ago

Dear Vincenzo

I’ve performed your indications and I’ve got a new one… see below in yellow…. sorry With and without sudo

@.***:/tmp/lightning$ sudo wget https://github.com/ElementsProject/lightning/releases/download/v23.02.2/clightning-v23.02.2-Ubuntu-22.04.tar.xz --2023-03-17 16:39:20-- https://github.com/ElementsProject/lightning/releases/download/v23.02.2/clightning-v23.02.2-Ubuntu-22.04.tar.xz Resolving github.com (github.com)... 140.82.121.4 Connecting to github.com (github.com)|140.82.121.4|:443... connected. HTTP request sent, awaiting response... 302 Found Location: https://objects.githubusercontent.com/github-production-release-asset-2e65be/37350472/a2edd385-006c-4b0d-930f-2c1d5d7c2313?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIWNJYAX4CSVEH53A%2F20230317%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20230317T153920Z&X-Amz-Expires=300&X-Amz-Signature=bf68db8fca26c6ca22637286c4d5dfbe8117f58d952a2506d83e4e5e7b78949d&X-Amz-SignedHeaders=host&actor_id=0&key_id=0&repo_id=37350472&response-content-disposition=attachment%3B%20filename%3Dclightning-v23.02.2-Ubuntu-22.04.tar.xz&response-content-type=application%2Foctet-stream [following] --2023-03-17 16:39:20-- https://objects.githubusercontent.com/github-production-release-asset-2e65be/37350472/a2edd385-006c-4b0d-930f-2c1d5d7c2313?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIWNJYAX4CSVEH53A%2F20230317%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20230317T153920Z&X-Amz-Expires=300&X-Amz-Signature=bf68db8fca26c6ca22637286c4d5dfbe8117f58d952a2506d83e4e5e7b78949d&X-Amz-SignedHeaders=host&actor_id=0&key_id=0&repo_id=37350472&response-content-disposition=attachment%3B%20filename%3Dclightning-v23.02.2-Ubuntu-22.04.tar.xz&response-content-type=application%2Foctet-stream Resolving objects.githubusercontent.com (objects.githubusercontent.com)... 185.199.110.133, 185.199.108.133, 185.199.111.133, ... Connecting to objects.githubusercontent.com (objects.githubusercontent.com)|185.199.110.133|:443... connected. HTTP request sent, awaiting response... 200 OK Length: 18069812 (17M) [application/octet-stream] Saving to: ‘clightning-v23.02.2-Ubuntu-22.04.tar.xz’

clightning-v23.02.2-Ubuntu-22.04.tar. 100%[=======================================================================>] 17,23M 18,9MB/s in 0,9s

2023-03-17 16:39:21 (18,9 MB/s) - ‘clightning-v23.02.2-Ubuntu-22.04.tar.xz’ saved [18069812/18069812]

@.:/tmp/lightning$ ls -l total 17648 -rw-r--r-- 1 root root 18069812 mar 14 06:29 clightning-v23.02.2-Ubuntu-22.04.tar.xz @.:/tmp/lightning$ tar -czvf clightning-v23.02.2-Ubuntu-22.04.tar.xz tar: Cowardly refusing to create an empty archive Try 'tar --help' or 'tar --usage' for more information.

De: Vincenzo Palazzo @.> Enviado el: jueves, 16 de marzo de 2023 9:58 Para: ElementsProject/lightning @.> CC: Nicolas Velasco - NR @.>; Author @.> Asunto: Re: [ElementsProject/lightning] lightningd: SQLITE version mismatch: compiled 3031001, now 3037002 - after ubuntu upgrade fm 20.04 to 22.04 (Issue #6088)

This is the core of the problem now! looks like that there are two fetchinvoice plugin?

2023-03-15T18:37:35.243Z UNUSUAL plugin-fetchinvoice: Killing plugin: could not register hook 'onion_message_blinded', either the name doesn't exist or another plugin already registered it.

2023-03-15T18:37:35.262Z BROKEN plugin-fetchinvoice: Plugin marked as important, shutting down lightningd!

lightningd: lightningd/plugin.c:1808: plugins_init: Assertion `ret == plugins' failed.

I think while you are coping and pasting the following operation something when wrong

I’ve copied lightningd & lightning-hsmtool to /usr/local/bin

Now the suggestion that I can give you here is before clean up your /user/local/bin is to do the following steps

cd /tmp

mkdir lightning && cd lightning

wget https://github.com/ElementsProject/lightning/releases/download/v23.02.2/clightning-v23.02.2-Ubuntu-22.04.tar.xz

tar -czvf clightning-v23.02-Ubuntu-22.04.tar.xz .

cd lightning

rm clightning-v23.02-Ubuntu-22.04.tar.xz

ls -la

./lightningd

This should run lightning in a new home (/tmp) and in this way we see if the error of the SQL db go away, and we can try to clean up you ppa later

P.S: Please note that my bash commands can be wrong in the sense that typos are always around, so do not just copy and paste them :)

— Reply to this email directly, view it on GitHubhttps://github.com/ElementsProject/lightning/issues/6088#issuecomment-1471549967, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AVUAE6A5YGSGU35HSXYAL3DW4LIYXANCNFSM6AAAAAAVYHLNLY. You are receiving this because you authored the thread.Message ID: @.**@.>> [Atención: E-mail Externo- Revise el contenido para verificar la autenticidad del remitente //--------------------------------------------------------------------// Por favor, revise nuestra política de protección de datos: Per favor, revisi la nostra política de protecció de dades: https://www.nironet.es/politicas-de-cookies-y-proteccion-de-datos-2 Antes de imprimir este e-mail, piense en si es realmente necesario: El Medio Ambiente es responsabilidad de todos. Abans d'imprimir aquest e-mail, pensi en si és realment necessari: El Medi ambient és responsabilitat de tots. * Before printing this e-mail, think if you really need to so. The environment is everyone's responsibility. //--------------------------------------------------------------------//

vincenzopalazzo commented 1 year ago

You need to unzip clightning-v23.02.2-Ubuntu-22.04.tar.xz’ (better if you use google to unzip tar.xz with ubuntu.

Then you go inside the directory and run run the lightnind with a ./lightningd

NVG2021 commented 1 year ago

Hi there,

I’ve extracted the content and see the terminal below… it gives an error with the plugin @.:/tmp/lightning$ tar -xvf clightning-v23.02.2-Ubuntu-22.04.tar.xz ./ ./usr/ ./usr/bin/ ./usr/bin/lightning-cli ./usr/bin/lightning-hsmtool ./usr/bin/lightningd ./usr/bin/reckless ./usr/libexec/ ./usr/libexec/c-lightning/ ./usr/libexec/c-lightning/lightning_channeld ./usr/libexec/c-lightning/lightning_closingd ./usr/libexec/c-lightning/lightning_connectd ./usr/libexec/c-lightning/lightning_dualopend ./usr/libexec/c-lightning/lightning_gossipd ./usr/libexec/c-lightning/lightning_hsmd ./usr/libexec/c-lightning/lightning_onchaind ./usr/libexec/c-lightning/lightning_openingd ./usr/libexec/c-lightning/lightning_websocketd ./usr/libexec/c-lightning/plugins/ ./usr/libexec/c-lightning/plugins/autoclean ./usr/libexec/c-lightning/plugins/bcli ./usr/libexec/c-lightning/plugins/bookkeeper ./usr/libexec/c-lightning/plugins/chanbackup ./usr/libexec/c-lightning/plugins/cln-grpc ./usr/libexec/c-lightning/plugins/commando ./usr/libexec/c-lightning/plugins/fetchinvoice ./usr/libexec/c-lightning/plugins/funder ./usr/libexec/c-lightning/plugins/keysend ./usr/libexec/c-lightning/plugins/offers ./usr/libexec/c-lightning/plugins/pay ./usr/libexec/c-lightning/plugins/spenderp ./usr/libexec/c-lightning/plugins/sql ./usr/libexec/c-lightning/plugins/topology ./usr/libexec/c-lightning/plugins/txprepare ./usr/share/ ./usr/share/doc/ ./usr/share/doc/c-lightning/ ./usr/share/doc/c-lightning/HACKING.md ./usr/share/doc/c-lightning/INSTALL.md ./usr/share/doc/c-lightning/LICENSE ./usr/share/doc/c-lightning/README.md ./usr/share/man/ ./usr/share/man/man1/ ./usr/share/man/man1/lightning-cli.1 ./usr/share/man/man5/ ./usr/share/man/man5/lightningd-config.5 ./usr/share/man/man7/ ./usr/share/man/man7/lightning-addgossip.7 ./usr/share/man/man7/lightning-autoclean-once.7 ./usr/share/man/man7/lightning-autoclean-status.7 ./usr/share/man/man7/lightning-batching.7 ./usr/share/man/man7/lightning-bkpr-channelsapy.7 ./usr/share/man/man7/lightning-bkpr-dumpincomecsv.7 ./usr/share/man/man7/lightning-bkpr-inspect.7 ./usr/share/man/man7/lightning-bkpr-listaccountevents.7 ./usr/share/man/man7/lightning-bkpr-listbalances.7 ./usr/share/man/man7/lightning-bkpr-listincome.7 ./usr/share/man/man7/lightning-check.7 ./usr/share/man/man7/lightning-checkmessage.7 ./usr/share/man/man7/lightning-close.7 ./usr/share/man/man7/lightning-commando-rune.7 ./usr/share/man/man7/lightning-commando.7 ./usr/share/man/man7/lightning-connect.7 ./usr/share/man/man7/lightning-createinvoice.7 ./usr/share/man/man7/lightning-createonion.7 ./usr/share/man/man7/lightning-datastore.7 ./usr/share/man/man7/lightning-decode.7 ./usr/share/man/man7/lightning-decodepay.7 ./usr/share/man/man7/lightning-deldatastore.7 ./usr/share/man/man7/lightning-delexpiredinvoice.7 ./usr/share/man/man7/lightning-delforward.7 ./usr/share/man/man7/lightning-delinvoice.7 ./usr/share/man/man7/lightning-delpay.7 ./usr/share/man/man7/lightning-disableinvoicerequest.7 ./usr/share/man/man7/lightning-disableoffer.7 ./usr/share/man/man7/lightning-disconnect.7 ./usr/share/man/man7/lightning-emergencyrecover.7 ./usr/share/man/man7/lightning-feerates.7 ./usr/share/man/man7/lightning-fetchinvoice.7 ./usr/share/man/man7/lightning-fundchannel.7 ./usr/share/man/man7/lightning-fundchannel_cancel.7 ./usr/share/man/man7/lightning-fundchannel_complete.7 ./usr/share/man/man7/lightning-fundchannel_start.7 ./usr/share/man/man7/lightning-funderupdate.7 ./usr/share/man/man7/lightning-fundpsbt.7 ./usr/share/man/man7/lightning-getinfo.7 ./usr/share/man/man7/lightning-getlog.7 ./usr/share/man/man7/lightning-getroute.7 ./usr/share/man/man7/lightning-help.7 ./usr/share/man/man7/lightning-invoice.7 ./usr/share/man/man7/lightning-invoicerequest.7 ./usr/share/man/man7/lightning-keysend.7 ./usr/share/man/man7/lightning-listchannels.7 ./usr/share/man/man7/lightning-listconfigs.7 ./usr/share/man/man7/lightning-listdatastore.7 ./usr/share/man/man7/lightning-listforwards.7 ./usr/share/man/man7/lightning-listfunds.7 ./usr/share/man/man7/lightning-listhtlcs.7 ./usr/share/man/man7/lightning-listinvoicerequests.7 ./usr/share/man/man7/lightning-listinvoices.7 ./usr/share/man/man7/lightning-listnodes.7 ./usr/share/man/man7/lightning-listoffers.7 ./usr/share/man/man7/lightning-listpays.7 ./usr/share/man/man7/lightning-listpeerchannels.7 ./usr/share/man/man7/lightning-listpeers.7 ./usr/share/man/man7/lightning-listsendpays.7 ./usr/share/man/man7/lightning-listsqlschemas.7 ./usr/share/man/man7/lightning-listtransactions.7 ./usr/share/man/man7/lightning-makesecret.7 ./usr/share/man/man7/lightning-multifundchannel.7 ./usr/share/man/man7/lightning-multiwithdraw.7 ./usr/share/man/man7/lightning-newaddr.7 ./usr/share/man/man7/lightning-notifications.7 ./usr/share/man/man7/lightning-offer.7 ./usr/share/man/man7/lightning-openchannel_abort.7 ./usr/share/man/man7/lightning-openchannel_bump.7 ./usr/share/man/man7/lightning-openchannel_init.7 ./usr/share/man/man7/lightning-openchannel_signed.7 ./usr/share/man/man7/lightning-openchannel_update.7 ./usr/share/man/man7/lightning-parsefeerate.7 ./usr/share/man/man7/lightning-pay.7 ./usr/share/man/man7/lightning-ping.7 ./usr/share/man/man7/lightning-plugin.7 ./usr/share/man/man7/lightning-preapproveinvoice.7 ./usr/share/man/man7/lightning-preapprovekeysend.7 ./usr/share/man/man7/lightning-recoverchannel.7 ./usr/share/man/man7/lightning-reserveinputs.7 ./usr/share/man/man7/lightning-sendcustommsg.7 ./usr/share/man/man7/lightning-sendinvoice.7 ./usr/share/man/man7/lightning-sendonion.7 ./usr/share/man/man7/lightning-sendonionmessage.7 ./usr/share/man/man7/lightning-sendpay.7 ./usr/share/man/man7/lightning-sendpsbt.7 ./usr/share/man/man7/lightning-setchannel.7 ./usr/share/man/man7/lightning-signinvoice.7 ./usr/share/man/man7/lightning-signmessage.7 ./usr/share/man/man7/lightning-signpsbt.7 ./usr/share/man/man7/lightning-sql.7 ./usr/share/man/man7/lightning-staticbackup.7 ./usr/share/man/man7/lightning-stop.7 ./usr/share/man/man7/lightning-txdiscard.7 ./usr/share/man/man7/lightning-txprepare.7 ./usr/share/man/man7/lightning-txsend.7 ./usr/share/man/man7/lightning-unreserveinputs.7 ./usr/share/man/man7/lightning-utxopsbt.7 ./usr/share/man/man7/lightning-waitanyinvoice.7 ./usr/share/man/man7/lightning-waitblockheight.7 ./usr/share/man/man7/lightning-waitinvoice.7 ./usr/share/man/man7/lightning-waitsendpay.7 ./usr/share/man/man7/lightning-withdraw.7 ./usr/share/man/man7/lightningd-rpc.7 ./usr/share/man/man7/reckless.7 ./usr/share/man/man8/ ./usr/share/man/man8/lightning-hsmtool.8 ./usr/share/man/man8/lightningd.8 @.:/tmp/lightning$ ls clightning-v23.02.2-Ubuntu-22.04.tar.xz usr @.:/tmp/lightning$ cd usr @.:/tmp/lightning/usr$ ls bin libexec share @.:/tmp/lightning/usr$ cd bin @.:/tmp/lightning/usr/bin$ ls lightning-cli lightningd lightning-hsmtool reckless @.:/tmp/lightning/usr/bin$ lightningd 2023-03-17T20:01:20.769Z UNUSUAL plugin-fetchinvoice: Killing plugin: could not register hook 'onion_message_blinded', either the name doesn't exist or another plugin already registered it. 2023-03-17T20:01:20.770Z BROKEN plugin-fetchinvoice: Plugin marked as important, shutting down lightningd! lightningd: lightningd/plugin.c:1808: plugins_init: Assertion `ret == plugins' failed. lightningd: FATAL SIGNAL 6 (version 23.02) 0x55cdecf78efe send_backtrace common/daemon.c:33 0x55cdecf78f95 crashdump common/daemon.c:46 0x7f7d8c2c051f ??? ./signal/../sysdeps/unix/sysv/linux/x86_64/libc_sigaction.c:0 0x7f7d8c314a7c pthread_kill_implementation ./nptl/pthread_kill.c:44 0x7f7d8c314a7c __pthread_kill_internal ./nptl/pthread_kill.c:78 0x7f7d8c314a7c GI_pthread_kill ./nptl/pthread_kill.c:89 0x7f7d8c2c0475 __GI_raise ../sysdeps/posix/raise.c:26 0x7f7d8c2a67f2 GI_abort ./stdlib/abort.c:79 0x7f7d8c2a671a assert_fail_base ./assert/assert.c:92 0x7f7d8c2b7e95 GI_assert_fail ./assert/assert.c:101 0x55cdecf54b44 plugins_init lightningd/plugin.c:1808 0x55cdecf3375b main lightningd/lightningd.c:1009 0x7f7d8c2a7d8f libc_start_call_main ../sysdeps/nptl/libc_start_call_main.h:58 0x7f7d8c2a7e3f __libc_start_main_impl ../csu/libc-start.c:392 0x55cdecf14d14 ??? ???:0 0xffffffffffffffff ??? ???:0 Traceback (most recent call last): File "/home/nicolas/.lightning/plugins/lightning-qt/lightning-qt.py", line 12, in from pyln.client import LightningRpc, Plugin, RpcError ModuleNotFoundError: No module named 'pyln' Aborted (core dumped) @.:/tmp/lightning/usr/bin$

Nicolas Velasco Gestion – Formación Empresas - Energía

@.*** http://www.nironet.eshttp://www.nironet.es/ [twitter]https://twitter.com/NironetSchool[símbolos-redes-sociales-02-1]https://www.facebook.com/Nironet Nironet SL Barcelona – Vilanova i la Geltrú Tel: 938 106 596 Movil: (+34) 607 403 073

De: Vincenzo Palazzo @.> Enviado el: jueves, 16 de marzo de 2023 9:58 Para: ElementsProject/lightning @.> CC: Nicolas Velasco - NR @.>; Author @.> Asunto: Re: [ElementsProject/lightning] lightningd: SQLITE version mismatch: compiled 3031001, now 3037002 - after ubuntu upgrade fm 20.04 to 22.04 (Issue #6088)

This is the core of the problem now! looks like that there are two fetchinvoice plugin?

2023-03-15T18:37:35.243Z UNUSUAL plugin-fetchinvoice: Killing plugin: could not register hook 'onion_message_blinded', either the name doesn't exist or another plugin already registered it.

2023-03-15T18:37:35.262Z BROKEN plugin-fetchinvoice: Plugin marked as important, shutting down lightningd!

lightningd: lightningd/plugin.c:1808: plugins_init: Assertion `ret == plugins' failed.

I think while you are coping and pasting the following operation something when wrong

I’ve copied lightningd & lightning-hsmtool to /usr/local/bin

Now the suggestion that I can give you here is before clean up your /user/local/bin is to do the following steps

cd /tmp

mkdir lightning && cd lightning

wget https://github.com/ElementsProject/lightning/releases/download/v23.02.2/clightning-v23.02.2-Ubuntu-22.04.tar.xz

tar -czvf clightning-v23.02-Ubuntu-22.04.tar.xz .

cd lightning

rm clightning-v23.02-Ubuntu-22.04.tar.xz

ls -la

./lightningd

This should run lightning in a new home (/tmp) and in this way we see if the error of the SQL db go away, and we can try to clean up you ppa later

P.S: Please note that my bash commands can be wrong in the sense that typos are always around, so do not just copy and paste them :)

— Reply to this email directly, view it on GitHubhttps://github.com/ElementsProject/lightning/issues/6088#issuecomment-1471549967, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AVUAE6A5YGSGU35HSXYAL3DW4LIYXANCNFSM6AAAAAAVYHLNLY. You are receiving this because you authored the thread.Message ID: @.**@.>> [Atención: E-mail Externo- Revise el contenido para verificar la autenticidad del remitente //--------------------------------------------------------------------// Por favor, revise nuestra política de protección de datos: Per favor, revisi la nostra política de protecció de dades: https://www.nironet.es/politicas-de-cookies-y-proteccion-de-datos-2 Antes de imprimir este e-mail, piense en si es realmente necesario: El Medio Ambiente es responsabilidad de todos. Abans d'imprimir aquest e-mail, pensi en si és realment necessari: El Medi ambient és responsabilitat de tots. * Before printing this e-mail, think if you really need to so. The environment is everyone's responsibility. //--------------------------------------------------------------------//

vincenzopalazzo commented 1 year ago

Ok now the error is this one

2023-03-17T20:01:20.769Z UNUSUAL plugin-fetchinvoice: Killing plugin: could not register hook 'onion_message_blinded', either the name doesn't exist or another plugin already registered it.
2023-03-17T20:01:20.770Z **BROKEN** plugin-fetchinvoice: Plugin marked as important, shutting down lightningd!
lightningd: lightningd/plugin.c:1808: plugins_init: Assertion `ret == plugins' failed.
lightningd: FATAL SIGNAL 6 (version 23.02)

Can you post also your configuration file?

NVG2021 commented 1 year ago

Hi,

The config file (with the one I started today ) is /home/nicolas/.lighnting/config alias=NiroBit

color nodo Azul Cobalto

rgb=0047AB plugin=/home/nicolas/c-lightning-REST/plugin.js

important-plugin=/home/nicolas/.lightning/plugins/backup/backup.py

rest-port=3001 rest-docport=4001 rest-protocol=https bitcoin-rpcuser=bitcoinnv bitcoin-rpcpassword=bitcoinnv

announce-addr=127.0.0.1:9737

proxy=127.0.0.1:9050 bind-addr=127.0.1.1:9735 addr=statictor:127.0.0.1:9051 always-use-proxy=true

Any light?

Also, before the Ubuntu upgrade I’ve started Lightningd with this command line lightningd --plugin=/home/nicolas/c-lightning-REST/plugin.js --rest-port=3001

Should I try???

Nicolas Velasco Gestion – Formación Empresas - Energía

@.*** http://www.nironet.eshttp://www.nironet.es/ [twitter]https://twitter.com/NironetSchool[símbolos-redes-sociales-02-1]https://www.facebook.com/Nironet Nironet SL Barcelona – Vilanova i la Geltrú Tel: 938 106 596 Movil: (+34) 607 403 073

De: Vincenzo Palazzo @.> Enviado el: viernes, 17 de marzo de 2023 21:24 Para: ElementsProject/lightning @.> CC: Nicolas Velasco - NR @.>; Author @.> Asunto: Re: [ElementsProject/lightning] lightningd: SQLITE version mismatch: compiled 3031001, now 3037002 - after ubuntu upgrade fm 20.04 to 22.04 (Issue #6088)

Ok now the error is this one

2023-03-17T20:01:20.769Z UNUSUAL plugin-fetchinvoice: Killing plugin: could not register hook 'onion_message_blinded', either the name doesn't exist or another plugin already registered it.

2023-03-17T20:01:20.770Z BROKEN plugin-fetchinvoice: Plugin marked as important, shutting down lightningd!

lightningd: lightningd/plugin.c:1808: plugins_init: Assertion `ret == plugins' failed.

lightningd: FATAL SIGNAL 6 (version 23.02)

Can you post also your configuration file?

— Reply to this email directly, view it on GitHubhttps://github.com/ElementsProject/lightning/issues/6088#issuecomment-1474369035, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AVUAE6HJYURDABR5ZEAC3J3W4TB6JANCNFSM6AAAAAAVYHLNLY. You are receiving this because you authored the thread.Message ID: @.**@.>> [Atención: E-mail Externo- Revise el contenido para verificar la autenticidad del remitente //--------------------------------------------------------------------// Por favor, revise nuestra política de protección de datos: Per favor, revisi la nostra política de protecció de dades: https://www.nironet.es/politicas-de-cookies-y-proteccion-de-datos-2 Antes de imprimir este e-mail, piense en si es realmente necesario: El Medio Ambiente es responsabilidad de todos. Abans d'imprimir aquest e-mail, pensi en si és realment necessari: El Medi ambient és responsabilitat de tots. * Before printing this e-mail, think if you really need to so. The environment is everyone's responsibility. //--------------------------------------------------------------------//

NVG2021 commented 1 year ago

Hi,

I’ve performed the command as I did in the past and I get this error. Ececuting lightningd on the new install and using details as before

@.***:/tmp/lightning/usr/bin$ lightningd --plugin=/home/nicolas/c-lightning-REST/plugin.js --rest-port=3002 lightningd: --plugin: Failed to register /home/nicolas/c-lightning-REST/plugin.js: Invalid argument

Nicolas Velasco Gestion – Formación Empresas - Energía

@.*** http://www.nironet.eshttp://www.nironet.es/ [twitter]https://twitter.com/NironetSchool[símbolos-redes-sociales-02-1]https://www.facebook.com/Nironet Nironet SL Barcelona – Vilanova i la Geltrú Tel: 938 106 596 Movil: (+34) 607 403 073

De: Vincenzo Palazzo @.> Enviado el: viernes, 17 de marzo de 2023 21:24 Para: ElementsProject/lightning @.> CC: Nicolas Velasco - NR @.>; Author @.> Asunto: Re: [ElementsProject/lightning] lightningd: SQLITE version mismatch: compiled 3031001, now 3037002 - after ubuntu upgrade fm 20.04 to 22.04 (Issue #6088)

Ok now the error is this one

2023-03-17T20:01:20.769Z UNUSUAL plugin-fetchinvoice: Killing plugin: could not register hook 'onion_message_blinded', either the name doesn't exist or another plugin already registered it.

2023-03-17T20:01:20.770Z BROKEN plugin-fetchinvoice: Plugin marked as important, shutting down lightningd!

lightningd: lightningd/plugin.c:1808: plugins_init: Assertion `ret == plugins' failed.

lightningd: FATAL SIGNAL 6 (version 23.02)

Can you post also your configuration file?

— Reply to this email directly, view it on GitHubhttps://github.com/ElementsProject/lightning/issues/6088#issuecomment-1474369035, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AVUAE6HJYURDABR5ZEAC3J3W4TB6JANCNFSM6AAAAAAVYHLNLY. You are receiving this because you authored the thread.Message ID: @.**@.>> [Atención: E-mail Externo- Revise el contenido para verificar la autenticidad del remitente //--------------------------------------------------------------------// Por favor, revise nuestra política de protección de datos: Per favor, revisi la nostra política de protecció de dades: https://www.nironet.es/politicas-de-cookies-y-proteccion-de-datos-2 Antes de imprimir este e-mail, piense en si es realmente necesario: El Medio Ambiente es responsabilidad de todos. Abans d'imprimir aquest e-mail, pensi en si és realment necessari: El Medi ambient és responsabilitat de tots. * Before printing this e-mail, think if you really need to so. The environment is everyone's responsibility. //--------------------------------------------------------------------//

vincenzopalazzo commented 1 year ago

This is an error related to your local env, that you can solve with some experimentation by checking your path I think?

***@***.***:/tmp/lightning/usr/bin$ lightningd --plugin=/home/nicolas/c-lightning-REST/plugin.js --rest-port=3002
lightningd: --plugin: Failed to register /home/nicolas/c-lightning-REST/plugin.js: Invalid argument

When all the path mistake are gone, you will see if the db error still persist or not, if yes please report the stack trace and the steps that you did

NVG2021 commented 1 year ago

Is strange, as I¡ve use the same path since started the node….

Maybe… where should be located the unzipped files??? Maybe if I back up the old install and put the new one on the /usr…. Location it may work???

If not… I am lost—

Nicolas Velasco Gestion – Formación Empresas - Energía

@.*** http://www.nironet.eshttp://www.nironet.es/ [twitter]https://twitter.com/NironetSchool[símbolos-redes-sociales-02-1]https://www.facebook.com/Nironet Nironet SL Barcelona – Vilanova i la Geltrú Tel: 938 106 596 Movil: (+34) 607 403 073

De: Vincenzo Palazzo @.> Enviado el: sábado, 18 de marzo de 2023 11:50 Para: ElementsProject/lightning @.> CC: Nicolas Velasco - NR @.>; Author @.> Asunto: Re: [ElementsProject/lightning] lightningd: SQLITE version mismatch: compiled 3031001, now 3037002 - after ubuntu upgrade fm 20.04 to 22.04 (Issue #6088)

This is an error related to your local env, that you can solve with some experimentation by checking your path I think?

@.:/tmp/lightning/usr/bin$<mailto:@.:/tmp/lightning/usr/bin$> lightningd --plugin=/home/nicolas/c-lightning-REST/plugin.js --rest-port=3002

lightningd: --plugin: Failed to register /home/nicolas/c-lightning-REST/plugin.js: Invalid argument

When all the path mistake are gone, you will see if the db error still persist or not, if yes please report the stack trace and the steps that you did

— Reply to this email directly, view it on GitHubhttps://github.com/ElementsProject/lightning/issues/6088#issuecomment-1474810604, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AVUAE6GTAU7FQ4HNQ2FJSP3W4WHLVANCNFSM6AAAAAAVYHLNLY. You are receiving this because you authored the thread.Message ID: @.**@.>> [Atención: E-mail Externo- Revise el contenido para verificar la autenticidad del remitente //--------------------------------------------------------------------// Por favor, revise nuestra política de protección de datos: Per favor, revisi la nostra política de protecció de dades: https://www.nironet.es/politicas-de-cookies-y-proteccion-de-datos-2 Antes de imprimir este e-mail, piense en si es realmente necesario: El Medio Ambiente es responsabilidad de todos. Abans d'imprimir aquest e-mail, pensi en si és realment necessari: El Medi ambient és responsabilitat de tots. * Before printing this e-mail, think if you really need to so. The environment is everyone's responsibility. //--------------------------------------------------------------------//

ShahanaFarooqui commented 1 year ago

@NVG2021 Can you try running lightningd without c-lightning-REST plugin first? Remember to comment rest options in your config as well:

plugin=/home/nicolas/c-lightning-REST/plugin.js rest-port=3001 rest-docport=4001 rest-protocol=https

It will help us to separate point of failures. If your lightningd works without rest, then we can fix c-lightning-REST error with https://github.com/Ride-The-Lightning/c-lightning-REST/issues/165 and combine them together afterwards.

NVG2021 commented 1 year ago

Hi

I’ve runned the command alone itself, but do not remember where is the config file for lightning. This is the result

@.*:~$ lightningd 2023-04-07T07:51:49.405Z UNUSUAL plugin-fetchinvoice: Killing plugin: could not register hook 'onion_message_blinded', either the name doesn't exist or another plugin already registered it. 2023-04-07T07:51:49.409Z BROKEN** plugin-fetchinvoice: Plugin marked as important, shutting down lightningd! lightningd: lightningd/plugin.c:1808: plugins_init: Assertion `ret == plugins' failed. lightningd: FATAL SIGNAL 6 (version 23.02) Traceback (most recent call last): File "/home/nicolas/.lightning/plugins/lightning-qt/lightning-qt.py", line 12, in from pyln.client import LightningRpc, Plugin, RpcError ModuleNotFoundError: No module named 'pyln' 0x561b5f5c3efe send_backtrace common/daemon.c:33 0x561b5f5c3f95 crashdump common/daemon.c:46 0x7f9d2612f51f ??? ./signal/../sysdeps/unix/sysv/linux/x86_64/libc_sigaction.c:0 0x7f9d26183a7c pthread_kill_implementation ./nptl/pthread_kill.c:44 0x7f9d26183a7c __pthread_kill_internal ./nptl/pthread_kill.c:78 0x7f9d26183a7c GI_pthread_kill ./nptl/pthread_kill.c:89 0x7f9d2612f475 __GI_raise ../sysdeps/posix/raise.c:26 0x7f9d261157f2 GI_abort ./stdlib/abort.c:79 0x7f9d2611571a assert_fail_base ./assert/assert.c:92 0x7f9d26126e95 GI_assert_fail ./assert/assert.c:101 0x561b5f59fb44 plugins_init lightningd/plugin.c:1808 0x561b5f57e75b main lightningd/lightningd.c:1009 0x7f9d26116d8f libc_start_call_main ../sysdeps/nptl/libc_start_call_main.h:58 0x7f9d26116e3f __libc_start_main_impl ../csu/libc-start.c:392 0x561b5f55fd14 ??? ???:0 0xffffffffffffffff ??? ???:0 Aborted (core dumped) Nicolas Velasco Gestion – Formación Empresas - Energía

@.*** http://www.nironet.eshttp://www.nironet.es/ [twitter]https://twitter.com/NironetSchool[símbolos-redes-sociales-02-1]https://www.facebook.com/Nironet Nironet SL Barcelona – Vilanova i la Geltrú Tel: 938 106 596 Movil: (+34) 607 403 073

De: ShahanaFarooqui @.> Enviado el: martes, 4 de abril de 2023 19:34 Para: ElementsProject/lightning @.> CC: Nicolas Velasco - NR @.>; Mention @.> Asunto: Re: [ElementsProject/lightning] lightningd: SQLITE version mismatch: compiled 3031001, now 3037002 - after ubuntu upgrade fm 20.04 to 22.04 (Issue #6088)

@NVG2021https://github.com/NVG2021 Can you try running lightningd without c-lightning-REST plugin first? Remember to comment rest options in your config as well:

plugin=/home/nicolas/c-lightning-REST/plugin.js rest-port=3001 rest-docport=4001 rest-protocol=https

It will help us to separate point of failures. If your lightningd works without rest, then we can fix c-lightning-REST error with https://github.com/Ride-The-Lightning/c-lightning-REST/issues/165 and combine them together afterwards.

— Reply to this email directly, view it on GitHubhttps://github.com/ElementsProject/lightning/issues/6088#issuecomment-1496349192, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AVUAE6F7JOZCZCZKTKDOXOTW7RLRDANCNFSM6AAAAAAVYHLNLY. You are receiving this because you were mentioned.Message ID: @.**@.>> [Atención: E-mail Externo- Revise el contenido para verificar la autenticidad del remitente //--------------------------------------------------------------------// Por favor, revise nuestra política de protección de datos: Per favor, revisi la nostra política de protecció de dades: https://www.nironet.es/politicas-de-cookies-y-proteccion-de-datos-2 Antes de imprimir este e-mail, piense en si es realmente necesario: El Medio Ambiente es responsabilidad de todos. Abans d'imprimir aquest e-mail, pensi en si és realment necessari: El Medi ambient és responsabilitat de tots. * Before printing this e-mail, think if you really need to so. The environment is everyone's responsibility. //--------------------------------------------------------------------//

rustyrussell commented 1 year ago

OK, try this:

cd / && sudo tar xvfa /tmp/lightning/clightning-v23.02.2-Ubuntu-22.04.tar.xz
rm -f /usr/local/bin/lightningd

That will install cln v23.02.2 on your system, into /usr/bin where it normally is, and all the plugins, and undo the version you put in /usr/local/bin.

NVG2021 commented 1 year ago

Hi, I did what you indicated, and this is what I’ve got… First with the config inline @.***:~$ lightningd --plugin=/home/nicolas/c-lightning-REST/plugin.js --rest-port=3001 lightningd: --plugin: Failed to register /home/nicolas/c-lightning-REST/plugin.js: No such file or directory

Second without anything

@.***:~$ lightningd Traceback (most recent call last): File "/home/nicolas/.lightning/plugins/lightning-qt/lightning-qt.py", line 12, in from pyln.client import LightningRpc, Plugin, RpcError ModuleNotFoundError: No module named 'pyln' 2023-04-14T19:33:43.443Z INFO plugin-lightning-qt.py: Killing plugin: exited before replying to getmanifest 2023-04-14T19:33:43.550Z INFO lightningd: Refusing to irreversibly upgrade db from version 176 to 216 in non-final version 23.02.2 (use --database-upgrade=true to override) Refusing to irreversibly upgrade db from version 176 to 216 in non-final version 23.02.2 (use --database-upgrade=true to override)

Any more hints??? Thanks a lot!!!

Nicolas Velasco Gestion – Formación Empresas - Energía

@.*** http://www.nironet.eshttp://www.nironet.es/ [twitter]https://twitter.com/NironetSchool[símbolos-redes-sociales-02-1]https://www.facebook.com/Nironet Nironet SL Barcelona – Vilanova i la Geltrú Tel: 938 106 596 Movil: (+34) 607 403 073

De: Rusty Russell @.> Enviado el: viernes, 14 de abril de 2023 2:39 Para: ElementsProject/lightning @.> CC: Nicolas Velasco - NR @.>; Mention @.> Asunto: Re: [ElementsProject/lightning] lightningd: SQLITE version mismatch: compiled 3031001, now 3037002 - after ubuntu upgrade fm 20.04 to 22.04 (Issue #6088)

OK, try this:

cd / && sudo tar xvfa /tmp/lightning/clightning-v23.02.2-Ubuntu-22.04.tar.xz

rm -f /usr/local/bin/lightningd

That will install cln v23.02.2 on your system, into /usr/bin where it normally is, and all the plugins, and undo the version you put in /usr/local/bin.

— Reply to this email directly, view it on GitHubhttps://github.com/ElementsProject/lightning/issues/6088#issuecomment-1507770423, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AVUAE6EJBOWYOYT3PFLMXQLXBCMDNANCNFSM6AAAAAAVYHLNLY. You are receiving this because you were mentioned.Message ID: @.**@.>> [Atención: E-mail Externo- Revise el contenido para verificar la autenticidad del remitente //--------------------------------------------------------------------// Por favor, revise nuestra política de protección de datos: Per favor, revisi la nostra política de protecció de dades: https://www.nironet.es/politicas-de-cookies-y-proteccion-de-datos-2 Antes de imprimir este e-mail, piense en si es realmente necesario: El Medio Ambiente es responsabilidad de todos. Abans d'imprimir aquest e-mail, pensi en si és realment necessari: El Medi ambient és responsabilitat de tots. * Before printing this e-mail, think if you really need to so. The environment is everyone's responsibility. //--------------------------------------------------------------------//

ShahanaFarooqui commented 1 year ago

Please run it as lightningd --database-upgrade=true but note that it will irreversibly upgrade your db from version 176 to 216.

ShahanaFarooqui commented 1 year ago

I would also recommend commenting out the lightning-qt plugin configuration for now to reduce the potential for failure. You can add it back once lightningd starts working.

NVG2021 commented 1 year ago

And thisnis good or bad??? Thks

Nicolas Velasco

El 14 abr 2023, a las 21:45, ShahanaFarooqui @.***> escribió:



I would also recommend commenting out the lightning-qt configuration for now to reduce the potential for failure. You can add it back once lightningd starts working.

— Reply to this email directly, view it on GitHubhttps://github.com/ElementsProject/lightning/issues/6088#issuecomment-1509139515, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AVUAE6BWT3D6QBW7BTUXJDTXBGSMTANCNFSM6AAAAAAVYHLNLY. You are receiving this because you were mentioned.Message ID: @.***>

[Atención: E-mail Externo- Revise el contenido para verificar la autenticidad del remitente //--------------------------------------------------------------------// Por favor, revise nuestra política de protección de datos: Per favor, revisi la nostra política de protecció de dades: https://www.nironet.es/politicas-de-cookies-y-proteccion-de-datos-2 Antes de imprimir este e-mail, piense en si es realmente necesario: El Medio Ambiente es responsabilidad de todos. Abans d'imprimir aquest e-mail, pensi en si és realment necessari: El Medi ambient és responsabilitat de tots. * Before printing this e-mail, think if you really need to so. The environment is everyone's responsibility. //--------------------------------------------------------------------//

ShahanaFarooqui commented 1 year ago

Commenting out plugin's configuration? It is okay because it will allow us to debug one issue at a time. Once we will fix lightningd issue, we can again un-comment qt configurations and can debug that plugin afterwards. Right now, we do not know if the issue is coming from lightningd or lightning-qt.

NVG2021 commented 1 year ago

Hi, thanks for the hints

See the result of DB upgrade

@.***:~$ lightningd --database-upgrade=true Traceback (most recent call last): File "/home/nicolas/.lightning/plugins/lightning-qt/lightning-qt.py", line 12, in from pyln.client import LightningRpc, Plugin, RpcError ModuleNotFoundError: No module named 'pyln' 2023-04-14T22:05:55.614Z INFO plugin-lightning-qt.py: Killing plugin: exited before replying to getmanifest 2023-04-14T22:05:55.669Z INFO lightningd: Updating database from version 176 to 216 2023-04-14T22:06:42.547Z INFO connectd: Static Tor service onion address: "ylzuyuajogin3xc7syxxukoq65agpev7lzcvsjmx7ibbehhqvjjfkvqd.onion:9735,127.0.1.1:9735" bound from extern port 9735 2023-04-14T22:06:42.990Z INFO plugin-bcli: bitcoin-cli initialized and connected to bitcoind. 2023-04-14T22:06:55.616Z INFO plugin-chanbackup: Creating Emergency Recovery 2023-04-14T22:06:55.656Z INFO plugin-bookkeeper: Creating database 2023-04-14T22:06:58.909Z UNUSUAL plugin-clrest.js: --- Starting the cl-rest server --- 2023-04-14T22:06:58.987Z INFO lightningd: -------------------------------------------------- 2023-04-14T22:06:58.987Z INFO lightningd: Server started with public key 03d96b1c917d88a1019734a29d2dcbbe94d0460becf8ffcd22ab9a27fa2a1d7b3f, alias NiroBit (color #0047ab) and lightningd 23.02.2 2023-04-14T22:06:58.991Z UNUSUAL plugin-clrest.js: --- cl-rest api server is ready and listening on :::3001 --- 2023-04-14T22:06:58.992Z UNUSUAL plugin-clrest.js: --- cl-rest doc server is ready and listening on :::4001 --- 2023-04-14T22:07:06.051Z INFO 02cf7712c7dfe3576c9b96b5a9b01be67d5a453176949879cecfdcee8b7eb816e5-chan#8: Peer transient failure in CHANNELD_NORMAL: Disconnected

It seems is going better…

Nicolas Velasco Gestion – Formación Empresas - Energía

@.*** http://www.nironet.eshttp://www.nironet.es/ [twitter]https://twitter.com/NironetSchool[símbolos-redes-sociales-02-1]https://www.facebook.com/Nironet Nironet SL Barcelona – Vilanova i la Geltrú Tel: 938 106 596 Movil: (+34) 607 403 073

De: ShahanaFarooqui @.> Enviado el: viernes, 14 de abril de 2023 21:52 Para: ElementsProject/lightning @.> CC: Nicolas Velasco - NR @.>; Mention @.> Asunto: Re: [ElementsProject/lightning] lightningd: SQLITE version mismatch: compiled 3031001, now 3037002 - after ubuntu upgrade fm 20.04 to 22.04 (Issue #6088)

Commenting out plugin's configuration? It is okay because it will allow us to debug one issue at a time. Once we will fix lightningd issue, we can again un-comment qt configurations and can debug that plugin afterwards. Right now, we do not know if the issue is coming from lightningd or lightning-qt.

— Reply to this email directly, view it on GitHubhttps://github.com/ElementsProject/lightning/issues/6088#issuecomment-1509151591, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AVUAE6DK3R3GCRABZTJDTS3XBGTGVANCNFSM6AAAAAAVYHLNLY. You are receiving this because you were mentioned.Message ID: @.**@.>> [Atención: E-mail Externo- Revise el contenido para verificar la autenticidad del remitente //--------------------------------------------------------------------// Por favor, revise nuestra política de protección de datos: Per favor, revisi la nostra política de protecció de dades: https://www.nironet.es/politicas-de-cookies-y-proteccion-de-datos-2 Antes de imprimir este e-mail, piense en si es realmente necesario: El Medio Ambiente es responsabilidad de todos. Abans d'imprimir aquest e-mail, pensi en si és realment necessari: El Medi ambient és responsabilitat de tots. * Before printing this e-mail, think if you really need to so. The environment is everyone's responsibility. //--------------------------------------------------------------------//

ShahanaFarooqui commented 1 year ago

Can you try after removing lightning-qt from your /home/nicolas/.lightning/plugins folder. It looks like either it is an older version which is incompatible with newer lightningd or the plugin is unable to resolve it's dependencies.

NVG2021 commented 1 year ago

Hi I’ve seen that the node is running… I’ve been able to access the info through Ride The Lighning app and all is there…. So, it looks you have been able to solve it!!! I’ll try later to remove the -qt plugin to see if the messages are gone

Many thanks for your help, which has been great!!!!

Nicolas Velasco Gestion – Formación Empresas - Energía

@.*** http://www.nironet.eshttp://www.nironet.es/ [twitter]https://twitter.com/NironetSchool[símbolos-redes-sociales-02-1]https://www.facebook.com/Nironet Nironet SL Barcelona – Vilanova i la Geltrú Tel: 938 106 596 Movil: (+34) 607 403 073

De: ShahanaFarooqui @.> Enviado el: sábado, 15 de abril de 2023 7:26 Para: ElementsProject/lightning @.> CC: Nicolas Velasco - NR @.>; Mention @.> Asunto: Re: [ElementsProject/lightning] lightningd: SQLITE version mismatch: compiled 3031001, now 3037002 - after ubuntu upgrade fm 20.04 to 22.04 (Issue #6088)

Can you try after removing lightning-qt from your /home/nicolas/.lightning/plugins folder. It looks like either it is an older version which is incompatible with newer lightningd or the plugin is unable to resolve it's dependencies.

— Reply to this email directly, view it on GitHubhttps://github.com/ElementsProject/lightning/issues/6088#issuecomment-1509520378, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AVUAE6CZLEIIGJOKRKQVD6LXBIWPHANCNFSM6AAAAAAVYHLNLY. You are receiving this because you were mentioned.Message ID: @.**@.>> [Atención: E-mail Externo- Revise el contenido para verificar la autenticidad del remitente //--------------------------------------------------------------------// Por favor, revise nuestra política de protección de datos: Per favor, revisi la nostra política de protecció de dades: https://www.nironet.es/politicas-de-cookies-y-proteccion-de-datos-2 Antes de imprimir este e-mail, piense en si es realmente necesario: El Medio Ambiente es responsabilidad de todos. Abans d'imprimir aquest e-mail, pensi en si és realment necessari: El Medi ambient és responsabilitat de tots. * Before printing this e-mail, think if you really need to so. The environment is everyone's responsibility. //--------------------------------------------------------------------//

ShahanaFarooqui commented 1 year ago

Closing the issue now as it is resolved. Please feel free to comment if needed.