Error “database is locked”

gulabnandanvar · August 7, 2023, 4:21am

Hi All,

Getting the error “database is locked”, i tried to change DB as well but no luck,
I am waiting the your valuable the input.

Thanks
Gulab

usman.ahmad · August 7, 2023, 9:38am

Hi @gulabnandanvar,

Welcome to the community support forums !!

We are excited that you joined our OSS community. Please read about some of the FAQs in the community

This seems to be a known issue as previously reported here:

github.com/grafana/grafana

Grafana 9.4.3 dies silently (on high HDD load?)

opened 06:39AM - 13 Mar 23 UTC

closed 06:53AM - 16 Mar 23 UTC

jan666

needs more info area/backend/config area/backend/db/sqlite

**What happened**: I updated Grafana to 9.4.3 (from 9.3.8). Everything looks good but from time to time (and at least every night) Grafana is just not working anymore. I think this happens when the HDD load is high. **What you expected to happen**: Grafana should keep running **How to reproduce it (as minimally and precisely as possible)**: **Anything else we need to know?**: I set the loglevel to debug, then started updating my FreeBSD ports. Short time after that Grafana was not running anymore. The last lines in the Logfile are ``` logger=alertmanager org=1 t=2023-03-13T07:15:09.327144881+01:00 level=debug component=alertmanager orgID=1 component=dispatcher msg="Received alert" alert=CO2-Alarm[24842ab][active] logger=datasources rule_uid=lp_in6Rnk org_id=1 t=2023-03-13T07:15:09.689849835+01:00 level=debug msg="Querying for data source via SQL store" uid=L5jNJVZ7z orgId=1 logger=ngalert.state.historian rule_uid=TaUBLwd4z org_id=1 t=2023-03-13T07:15:09.991378496+01:00 level=debug msg="Done saving alert annotation batch" logger=ngalert.state.historian rule_uid=EtFi3-x4z org_id=1 t=2023-03-13T07:15:10.901337212+01:00 level=debug msg="Done saving alert annotation batch" logger=datasources t=2023-03-13T07:15:14.007294232+01:00 level=error msg="Failed getting data source" err="database is locked" uid=cb_4ryF7k id=0 name= orgId=1 logger=sqlstore.transactions rule_uid=aYormIFVz org_id=1 t=2023-03-13T07:15:14.007424053+01:00 level=info msg="Database locked, sleeping then retrying" error="database is locked" retry=1 code="database is locked" ``` **Environment**: - Grafana version: 9.4.3 - Data source type & version: InfluxDB 1.8 - OS Grafana is installed on: FreeBSD 13.1 - User OS & Browser: - Grafana plugins: - Others:

Please check it and let us know if that helps you to find the answers to you need.

Update Status

This issue has been fixed with major significant improvements on the Backend Database.

Therefore marking it as a solution

bgates · August 8, 2023, 5:31pm

Wanted to tag onto this.

I was receiving this error randomly in our alerts and when we would run some queries.

The issue was around the default grafana.db sqlite3 file.

Transitioned to MYSQL and have had 0 issues.

yosiasz · August 8, 2023, 6:36pm

you were running queries again the grafana sqlite?

jasonmallory · August 8, 2023, 7:12pm

I’m getting a lot of these as well as high CPU/memory usage

yosiasz · August 9, 2023, 12:28am

@jasonmallory
Does it prevent you from using grafana? Also are you querying the sqlite db itself?

Maybe it’s time to migrate to mysql or postgres

jasonmallory · August 9, 2023, 12:40am

I think I’m going to move that direction this week

jasonmallory · August 9, 2023, 12:40am

And yeah Grafana will lock up the server

bgates · August 23, 2023, 2:42pm

No was just doing alot with grafana and sqlite could not keep up