[bug]: 'Edge Not Found' when paying invoices

[mmarsalko]

Background

About a week ago, my node crashed and I was able to recover it by compacting the database -- well, sort of. It wouldn't start unless I added db.no-graph-cache=true to the lnd.conf. Now it's running mostly properly. It's able to receive payments and able to open channels and properly route transactions, but when I try to pay an invoice myself, I'm given an Edge Not Found error from the various interfaces I've tried (Zeus, Alby, and RTL).

Your environment

• lnd version: v0.18.5-beta
• OS: Linux macpiblitz 5.10.0-21-amd64 SMP Debian 5.10.162-1 (2023-01-21) x86_64 GNU/Linux
• bitcoind version: 280000
• any other relevant environment details

Steps to reproduce

chantools compactdb channel.db compacted.db

[guggero]

If you have to disable the graph cache to get your node started, that means there is data corruption in the channel.db file.
I strongly suggest to normally close all channels, wait for all funds to be confirmed and then delete the channel.db file and create new channels.
If you have invoice and payment data that you want to keep, the alternative to deleting the channel.db file entirely (which does contain the invoices and payments), you can run chantools dropchannelgraph.

That might also be a good moment to migrate over to SQLite, which is less error prone (only available if you start the node fresh with an empty data directory, or if you manually migrate the data over to SQLite using lndinit):

lnd.conf

db.backend=sqlite
db.use-native-sql

[mmarsalko]

Dropping the channel graph seems to have done the trick!

Is it possible to switch over to SQLite with channels open?

[guggero]

Yes, I've linked the migration guide above.