docker image broken due to sqlite not supporting a query.

[2Fast2BCn]

68f3649

introduced a query that isn't supported by the sqlite that is shipped with the docker image.
This is fine:

docker run -d --name cln --network=host --platform=linux/amd64 -v clnLightningVolume:/root/.lightning -v bitcoindRegtestVolume:/root/.bitcoin -e LIGHTNINGD_DATA=/root/.lightning elementsproject/lightningd:v25.02 --network=regtest

this is not:

docker run -d --name cln --network=host --platform=linux/amd64 -v clnLightningVolume:/root/.lightning -v bitcoindRegtestVolume:/root/.bitcoin -e LIGHTNINGD_DATA=/root/.lightning elementsproject/lightningd:latest --network=regtest

2025-04-11T07:55:06.761Z **BROKEN** lightningd: Error executing statement: wallet/db.c:2044: UPDATE addresses SET addrtype = ? FROM channels  WHERE addre
sses.keyidx = channels.shutdown_keyidx_local AND channels.state != ? AND channels.state != ? AND channels.state != ?: near "FROM": syntax error
Error executing statement: wallet/db.c:2044: UPDATE addresses SET addrtype = ? FROM channels  WHERE addresses.keyidx = channels.shutdown_keyidx_local AND
 channels.state != ? AND channels.state != ? AND channels.state != ?: near "FROM": syntax error

[whitslack]

What version of SQLite is needed for UPDATE…FROM syntax? (I want to know so I can bump up the dependency specifier in my Gentoo ebuild for CLN.)

[freerko]

I have this error as well when updating from 25.02 to 25.02.1 on Ubuntu 20.04:

root@server:~# lightningd
Error executing statement: wallet/db.c:2044: UPDATE addresses SET addrtype = ? FROM channels WHERE addresses.keyidx = channels.shutdown_keyidx_local AND channels.state != ? AND channels.state != ? AND channels.state != ?: near "FROM": syntax error

edit: I updated the OS to Ubuntu 22.04 (which lifted sqlite from 3.31.1 to 3.37.2) and now it works fine. Since the standard support for Ubuntu 20.04 ends in 6 weeks, it probably doesn't make sense to support that OS anymore.

[endothermicdev]

I believe sqlite 3.33 that supports this syntax.

[whitslack]

I believe sqlite 3.33 that supports this syntax.

Thank you. That looks correct.

[ShahanaFarooqui]

Updated milestone to point release 2 for Feb release, as both the latest and v25.02.1 images are currently non-functional.

[ShahanaFarooqui]

Hi @vincenzopalazzo, Do we have any ETA for the fix as latest Docker images are non-functional due to this issue?