# Updating to node-red-node-sqlite v2.0.0 broke my flows
**URL:** https://discourse.nodered.org/t/updating-to-node-red-node-sqlite-v2-0-0-broke-my-flows/100737
**Category:** FlowFuse
**Created:** [9 April 2026 13:14 UTC](https://discourse.nodered.org/t/updating-to-node-red-node-sqlite-v2-0-0-broke-my-flows/100737 "2026-04-09T13:14:22Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@dudleyjosh](https://discourse.nodered.org/u/dudleyjosh)
#### Post date: [9 April 2026 13:14 UTC](https://discourse.nodered.org/t/updating-to-node-red-node-sqlite-v2-0-0-broke-my-flows/100737/1 "2026-04-09T13:14:22Z")
Has anyone else updated their node-red-node-sqlite to v2.0.0 and experienced missing nodes and thus a broken flow?
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [9 April 2026 13:22 UTC](https://discourse.nodered.org/t/updating-to-node-red-node-sqlite-v2-0-0-broke-my-flows/100737/2 "2026-04-09T13:22:07Z")
Hi is it the sqlite node that is "missing" or are other nodes showing as missing?
If you want to revert temporarily in FlowFuse you can set the module version number in settings -\> palette, add or update the entry node-red-node-sqlite, save
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [9 April 2026 13:24 UTC](https://discourse.nodered.org/t/updating-to-node-red-node-sqlite-v2-0-0-broke-my-flows/100737/3 "2026-04-09T13:24:39Z")
Any chance you could post a copy of the logs from the node-red instance (from the node-red logs tab in flowfuse) before you revert though please? (feel free to DM me if sensitive)
---
### Author:  [@dudleyjosh](https://discourse.nodered.org/u/dudleyjosh)
#### Post date: [9 April 2026 13:55 UTC](https://discourse.nodered.org/t/updating-to-node-red-node-sqlite-v2-0-0-broke-my-flows/100737/4 "2026-04-09T13:55:03Z")
I had already reverted back to node-red-node-sqlite v1.1.1 by installing it manually from the command line, but I just updated it again so I could capture the logs for you.
---
### Author:  [@hardillb](https://discourse.nodered.org/u/hardillb)
#### Post date: [9 April 2026 14:04 UTC](https://discourse.nodered.org/t/updating-to-node-red-node-sqlite-v2-0-0-broke-my-flows/100737/5 "2026-04-09T14:04:47Z")
OK, so this is a Remote instance running on a Pi?
Looks like a 64bit Pi from the logs.
I'm about to hit the road, but will test the 2.0.0 build on a Pi when I get home.
---
### Author:  [@hardillb](https://discourse.nodered.org/u/hardillb)
#### Post date: [9 April 2026 14:15 UTC](https://discourse.nodered.org/t/updating-to-node-red-node-sqlite-v2-0-0-broke-my-flows/100737/6 "2026-04-09T14:15:16Z")
Ahhh, just spotted the error in the logs.
What version of Raspbery Pi OS are you running (how old is it, it looks like the sqlite binary is expecting a newer glibc version)
---
### Author:  [@dudleyjosh](https://discourse.nodered.org/u/dudleyjosh)
#### Post date: [9 April 2026 18:51 UTC](https://discourse.nodered.org/t/updating-to-node-red-node-sqlite-v2-0-0-broke-my-flows/100737/7 "2026-04-09T18:51:08Z")
It's a Pi 5 running running Bookwork with all of the latest updates.
Just checked the version of GLIBC on the Pi using `ldd --version` and it is 2.36.
I have another Pi here running Trixie and I checked it and it has version 2.41.
The issue would be that I have a lot of Pi's in production running Bookworm already.
---
### Author:  [@hardillb](https://discourse.nodered.org/u/hardillb)
#### Post date: [9 April 2026 19:06 UTC](https://discourse.nodered.org/t/updating-to-node-red-node-sqlite-v2-0-0-broke-my-flows/100737/8 "2026-04-09T19:06:49Z")
Yeah, the sqlite binary is expecting at least GLIBC 2.38.
The problem is the nodejs pacakge this is all based on has been basically abandoned, the last update (a few weeks ago) is very likely to be the last ever build and we needed to move up to close a HUGE number of CVEs that were open for it's tar dependency.
So the choices are going to be live with the old version of the node-red-node-sqlite or upgrade to Trixie.
I am now glad that @dceejay made it a major version bump as that does imply a possible breaking change.
---
### Author:  [@hardillb](https://discourse.nodered.org/u/hardillb)
#### Post date: [9 April 2026 19:16 UTC](https://discourse.nodered.org/t/updating-to-node-red-node-sqlite-v2-0-0-broke-my-flows/100737/9 "2026-04-09T19:16:19Z")
You **may** also be able to force a local recompile once it's been installed by running
```auto
npm run rebuild
```
in the `sqlite3` directory under the `/opt/flowfuse-device/project/node_modules` directory, but that would be a manual step after the deploy, so not great
---
### Author:  [@hardillb](https://discourse.nodered.org/u/hardillb)
#### Post date: [11 April 2026 16:10 UTC](https://discourse.nodered.org/t/updating-to-node-red-node-sqlite-v2-0-0-broke-my-flows/100737/10 "2026-04-11T16:10:48Z")
OK, tested `npm run rebuild` and that works for bookworm
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [11 April 2026 19:44 UTC](https://discourse.nodered.org/t/updating-to-node-red-node-sqlite-v2-0-0-broke-my-flows/100737/11 "2026-04-11T19:44:46Z")
Did you mean `npm rebuild`?
---
### Author:  [@hardillb](https://discourse.nodered.org/u/hardillb)
#### Post date: [11 April 2026 19:57 UTC](https://discourse.nodered.org/t/updating-to-node-red-node-sqlite-v2-0-0-broke-my-flows/100737/12 "2026-04-11T19:57:18Z")
> Did you mean `npm rebuild`?
Very much **no**
`npm rebuild` does not actually rebuild from the source code in this case, it just downloads the pre-built version
`npm run rebuild` is a script in the `sqlite3` package.json that actually does rebuild from source.
Yes I know this breaks the built in commands, but not my circus and not my monkeys
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [11 April 2026 20:00 UTC](https://discourse.nodered.org/t/updating-to-node-red-node-sqlite-v2-0-0-broke-my-flows/100737/13 "2026-04-11T20:00:53Z")
Which folder is it necessary to run that from? When I run it in .node-red it says it is missing the script 'rebuild'.
---
### Author:  [@hardillb](https://discourse.nodered.org/u/hardillb)
#### Post date: [11 April 2026 20:01 UTC](https://discourse.nodered.org/t/updating-to-node-red-node-sqlite-v2-0-0-broke-my-flows/100737/14 "2026-04-11T20:01:57Z")
> [@hardillb](#):
>
> in the `sqlite3` directory
My first post is pretty clear, it needs to be run in the `sqlite3` directory.
The original question is specific to the FlowFuse Device Agent, but in a generic Node-RED install it would be `.node-red/node_modules/sqlite3`
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [11 April 2026 20:04 UTC](https://discourse.nodered.org/t/updating-to-node-red-node-sqlite-v2-0-0-broke-my-flows/100737/15 "2026-04-11T20:04:59Z")
Sorry, I missed that post (or forgot about it).
---
### Author:  [@tonylane26](https://discourse.nodered.org/u/tonylane26)
#### Post date: [12 April 2026 15:05 UTC](https://discourse.nodered.org/t/updating-to-node-red-node-sqlite-v2-0-0-broke-my-flows/100737/16 "2026-04-12T15:05:04Z")
I looked up the process for upgrading Bookworm to Trixie, and it looks like a lot of work, especially as a clean install is recommended. I understand that versions have to move forward, but it leaves me wondering if GLIBC 2.38 is such a leap forward from 2.36, and if it was really that difficult to accommodate both. As they say, is the juice worth the squeeze?
---
### Author:  [@hardillb](https://discourse.nodered.org/u/hardillb)
#### Post date: [12 April 2026 15:22 UTC](https://discourse.nodered.org/t/updating-to-node-red-node-sqlite-v2-0-0-broke-my-flows/100737/17 "2026-04-12T15:22:15Z")
I doubt this was a conscious choice by the `sqite3` folk is will just be down to what they built the pre-compiled binaries on, which I suspect will be a version of Ubuntu (most likely a GitHub Action runner) which is using GLIBC 2.38.
But as I mention, that team is no more, this was the last build to clear a bunch of `tar` dependency CVEs and `sqlite3` is now listed as deprecated and unmaintained.
We will need to find a replacement long term, but this was a best option in the short term.
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [12 April 2026 15:36 UTC](https://discourse.nodered.org/t/updating-to-node-red-node-sqlite-v2-0-0-broke-my-flows/100737/18 "2026-04-12T15:36:04Z")
> [@hardillb](#):
>
> `sqlite3` is not listed as deprecated and unmaintained.
I think that should be 'now listed as deprecated'.
---
### Author:  [@hardillb](https://discourse.nodered.org/u/hardillb)
#### Post date: [12 April 2026 16:09 UTC](https://discourse.nodered.org/t/updating-to-node-red-node-sqlite-v2-0-0-broke-my-flows/100737/19 "2026-04-12T16:09:15Z")
yes, it should
---
### Author:  [@tonylane26](https://discourse.nodered.org/u/tonylane26)
#### Post date: [16 April 2026 13:22 UTC](https://discourse.nodered.org/t/updating-to-node-red-node-sqlite-v2-0-0-broke-my-flows/100737/20 "2026-04-16T13:22:00Z")
Thanks for the explanation. I have found SQLite to be a great fit with node-red on a Pi. I use it for all my logging, and I like that it is file based, so I can easily backup onto a SSD or USB stick. Are there any contenders in that range?
[Next page](https://discourse.nodered.org/t/updating-to-node-red-node-sqlite-v2-0-0-broke-my-flows/100737.md?page=2)