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.

Thanks

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