I KNOW I’m not the only one who has issues with SQLITE3 in Raspberry Pi and Node-Red, so next time it happens to you… here is some invaluable info…

I just used the lines below on a Raspberry Pi 4 upgraded some days ago to Raspbian Buster from Raspbian Stretch.

As user PI… go to the /home/pi/.node-red directory

node-red-stop
npm rebuild sqlite3
node-red-start

Be warned – the rebuild will throw out several warnings…

That’s it, nothing else, just those 3 lines exactly as above. Will take several minutes for the rebuild to complete before you restart node-red.

But REALLY – the answer if possible is to DITCH SQLITE – this nonsense hs been going on for MANY MONTHS…. it is the ONLY  package that gives me constant grief like this.

I needed to write that down – I didn’t invent it, but Node-Red hung up on me again, in the past it was when using Raspbian Stretch, now days after an UPGRADE to Raspbian Buster (not a new install – but thanks to Antonio I also have one of those as well)….

Sorted.