I have a simple flow like this [Screenshot 2025-06-19 at 19.37.57] where the properties of HAS2 SQLite is: [Screenshot 2025-06-19 at 19.39.28] SQLStatement: SELECT metadata_id FROM states_meta WHERE entity_id = 'sensor.octopus_energy_electricity_[meter#]_[mpan#]_current_accumulative_…

Welcome to the forums @CoderN You will need to check access on the Node RED process user to that file path, even select statements, might do some background (non destructive) writes - like a temp table for instance (the mode you mentioned will stop altering data, not necessarily system based tables…

At a guess, the DB is in a directory that the account running the node-red process (inside the HA docker instance), does not have write access to? If you raise this on the HA forum - they will probably understand how these things fit together and be able to offer advice.

@marcus-j-davies Thanks for your help. I have installed Home Assistant and Node-RED as 2 separated docker containers sharing a single user. I have verified the read permission inside the Node-RED container with docker exec. Here are the 2 compose.yaml files. $ cat node-red/compose.yaml --- service…

@Steve-Mcl Thanks for your suggestion. Yeah. I have posted on Home Assistant forums as well. Having said that, the node reporting error is a node-red-node-sqlite node. It seems to me that Node-Red SQLITE should be more relevant.

The SQLite node is reporting it cannot write to the DB. This looks like permissions. If you know how docker works (it is like a virtual machine running inside a host) - that is where HA runs Node-RED (and so that is where the SQLite node is running also). Therefore, the account that runs the Node-R…

I think there is confusion about exactly what you are complaining of. Is it that, when accessing a read only database, it is not possible to read from the DB?

[image] Colin: I think there is confusion about exactly what you are complaining of. oh, I see. I speed read the write error: [image] CoderN: Error: SQLITE_READONLY: attempt to write a readonly database This might then be a quirk of sqlite. For example, I am not certain if select quer…

@Steve-Mcl Sorry for the confusion I have created. I am not complaining. I know it must be my configuration errors. Let me provide more information about it. For another basic test, I changed the file compose.yaml for node-red to $ cat node-red/compose.yaml --- services: node-red: containe…

The docker log might be helpful: 20 Jun 17:21:27 - [info] [sqlitedb:137383098fbd7a8e] opened /mnt/ha2/config/home-assistant_v2.db ok 20 Jun 17:21:29 - [error] [sqlite:HA2] Error: SQLITE_READONLY: attempt to write a readonly database 20 Jun 17:25:25 - [error] [sqlite:HA2] Error: SQLITE_READONLY: att…

Sorry for the confusion. I am not complaining. I know it must be my configuration errors. I have stated the situation again with more information above. This time with the database access set to RWC mode and the read-write permissions of the database file of the node-red user inside the container v…

Error: SQLITE_READONLY: attempt to write a readonly database

General

CoderN 20 June 2025 23:42 13

@Steve-Mcl

Thanks for your help.

I am happy to report that I have found the culprit. There are two more files accompany the sqlite database file. The error is gone once I have mounted the extra files inside the node-red container. In my case, they are home-assistant_v2.db-wal and home-assistant_v2.db-shm.

Topic		Replies	Views
Sqlite Database is Locked General	26	3975	14 February 2019
Running node-red in a docker container with sqlite3 General database , docker	6	878	11 September 2022
Add support for write mode on sqlite database? Feature Requests	11	196	15 March 2026
SQlite error with node red on Docker General database , docker	6	604	31 January 2022
Is it possible to use node-red-node-sqlite in user-authentication.js and dashboard-auth.js? General	8	437	2 April 2022

Error: SQLITE_READONLY: attempt to write a readonly database

Related topics