unable to open database file: out of memory (14)

[mcmellow]

Raspberry Pi 3B+ with buster Grafana v8.5.3 - SQLite Plugin v3.0.1 db Name: home/pi/domoticz/domoticz.db path: /home/pi/domoticz

At the db settings screen, when pressing Save & Test 2 messages appear. 1) Upper right corner: Green block with datasource updated 2) Lower left: Red block with error checking db: unable to open database file: out of memory (14)

No error messages in grafana.log What can I do?

[fr-ser]

How does the memory usage and capacity look like on the raspberry?

[mcmellow]

@fr-ser See the picture below. My SD-card has 49.6GB free space

edit (override) the grafana systemd configuration with the following content ` [Service]

PrivateTmp=false ProtectHome=false ` Cannot connect my datasource to Grafana, so stuck at the very first step.

[mcmellow]

@fr-ser This is the grafana log from the moment I do click on Save & Tests to add my SQLite database to Grafana. I hope this gives some more info about my problem. I have set the log level to debug in grafana.ini

logger=plugin.frser-sqlite-datasource t=2022-05-30T11:10:15.61+0200 lvl=info msg="Creating instance" logger=context traceID=00000000000000000000000000000000 userId=1 orgId=1 uname=admin t=2022-05-30T11:10:15.61+0200 lvl=info msg="Request Completed" method=GET path=/api/datasources/7/health status=400 remote_addr=192.168.123.8 time_ms=21 duration=21.12039ms size=98 referer=http://192.168.123.22:3000/datasources/edit/z0kZ-3WRz traceID=00000000000000000000000000000000

[fr-ser]

That log is just the startup log of the plugin for an SQLite database. It does not provide any information sadly.

Can you provide the options you pass to the plugin for the configuration again? Also, can you use the CLI tool sqlite3 to open the database on the raspberry via an SSH session?

The last thing to try would be using v2.2.1 of the plugin.

[mcmellow]

@fr-ser I am able to read data from the domoticz.db by other apps / plugins. It is just Grafana causing trouble. Uninstalled the v3.0.1 of the grafana-sqlite-datasource plugin and installed the v2.2.1. It is visible in the web gui. Adding the domoticz.db to Grafana reuslts in the error error checking db: unable to open database file: no such file or directory

Still not working on my RPI with domoticz.db

[fr-ser]

But that is a different error message 🤔

Can you provide the settings for the database in Grafana again?

[mcmellow]

But that is a different error message 🤔

Can you provide the settings for the database in Grafana again?

Yes because I change bavk to v2.2.1

Name : home/pi/domoticz/domoticz.db Path : home/pi/domoticz

the grafana systemd configuration with the following content ` [Service]

PrivateTmp=false ProtectHome=false `

[fr-ser]

Name : home/pi/domoticz/domoticz.db Path : home/pi/domoticz

The name of the configuration is just the display name in the Grafana UI. the path of the configuration needs to be the full path to the SQLite file not the folder.

Can you try with adjusted settings?

[mcmellow]

@fr-ser Thanks very much. I did understand the the meaning of those field not quite well. The database is connected now. Also the udate of the plugin to v3.0.1 went OK and the database is still connect OK. Problem solved, Issue closed