/account/login times out when trying to authenticate on web

Asked by V on 2012-07-24

Hello,

Whenever I am trying to login to graphite ,I am getting a bad gateway/timed out from nginx.

Setup is as follows:

Platform is 11.04 natty

python-graphite-web 0.9.9
python-carbon 0.9.9
python-django 1.3
nginx

Graphite is proxied behind nginx, load on the machine its a bit high ~3 .

I can provide a full trace if needed, please find below the error:

Request Method: POST
Request URL: http://localhost:3031/account/login/
Django Version: 1.3
Exception Type: DatabaseError
Exception Value:

database is locked

Exception Location: /usr/local/lib/python2.7/dist-packages/django/db/backends/sqlite3/base.py in execute, line 234
Python Executable: /usr/bin/python
Python Version: 2.7.1
Python Path:

['/opt/graphite/webapp/',
 '/opt/graphite/webapp/graphite/thirdparty/',
 '/usr/local/bin',
 '/opt/graphite/webapp',
 '/usr/lib/python2.7',
 '/usr/lib/python2.7/plat-linux2',
 '/usr/lib/python2.7/lib-tk',
 '/usr/lib/python2.7/lib-old',
 '/usr/lib/python2.7/lib-dynload',
 '/usr/local/lib/python2.7/dist-packages',
 '/usr/lib/python2.7/dist-packages',
 '/usr/lib/python2.7/dist-packages/gtk-2.0',
 '/usr/lib/pymodules/python2.7']

Server time: Tue, 24 Jul 2012 20:22:27 +0200

Please advise, thank you !

Question information

Language:
English Edit question
Status:
Answered
For:
Graphite Edit question
Assignee:
No assignee Edit question
Last query:
2012-07-24
Last reply:
2012-07-29
Michael Leinartas (mleinartas) said : #1

This is a problem with the sqlite database being used as your database backend. Google around for 'sqlite database locked' for some solutions. Generally it's caused by an unclean shutdown while a write was in progress.

Can you help with this problem?

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

To post a message you must log in.