Graphite

django.db.utils.OperationalError: database is locked

Asked by Rishi Khandelwal

I am running graphite at local as follows:

docker run -d\
 --name graphite\
 --restart=always\
 -p 80:80\
 -p 2003-2004:2003-2004\
 -p 2023-2024:2023-2024\
 -p 8125:8125/udp\
 -p 8126:8126\
 graphiteapp/graphite-statsd

and when I load Graphite UI at http://localhost it gives me below error:

django.db.utils.OperationalError: database is locked

Due to this error, I am not able to load the Graphite UI. It automatically resolves as well sometimes. If I refresh the page 10 times, I get this error 7 times.

Can anyone let me know if I need to change any configuration to make it work?
Thanks

Question information

Language:
English Edit question
Status:
Answered
For:
Graphite Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Denis Zhdanov (deniszhdanov) said : 		#1

By default Graphite using SQLite, which is not designed for significant load, looks like you overloading it by tagging requests. You can disable tagging by setting `ENABLE_TAGS=False` in carbon.conf or you can try to enable Redis for tagging db by using `REDIS_TAGDB =True`

See https://github.com/graphite-project/carbon/issues/816

Can you help with this problem?

Provide an answer of your own, or ask Rishi Khandelwal for more information if necessary.

To post a message you must log in.