pytest-dev / pytest-dev/pytest-django

database table is locked: auth_user

Open
#229 11 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

bug
Dominant language
Python
Stars
1.5k
Forks
367
PR merge metrics
No merged PRs in 30d

Description

When i try to log in to live_server with a browser, i get this:

OperationalError at /login/

database table is locked: auth_user

Request Method:     POST
Request URL:    http://localhost:8081/login/

do we keep transaction opened somewhere?

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the POST to /login/ through live_server and investigate why the auth_user table remains locked during the request. The issue is resolved when the login completes without the database-lock error and the transaction handling no longer leaves the table locked.

Written by the indexing model from the issue text.

Assessment

Tech stack
django, python
Domain
backend, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.