Edgewall Software
Modify

Opened 15 years ago

Closed 15 years ago

Last modified 15 years ago

#468 closed defect (fixed)

after upgrade: database is locked

Reported by: anonymous Owned by: Jonas Borgström
Priority: normal Milestone: 0.8
Component: general Version: 0.8
Severity: normal Keywords:
Cc: Branch:
Release Notes:
API Changes:

Description

I just updated svn and after upgrade I got this:


Traceback (most recent call last):

File "/usr/lib/python2.2/site-packages/trac/core.py", line 477, in cgi_start

real_cgi_start()

File "/usr/lib/python2.2/site-packages/trac/core.py", line 423, in real_cgi_start

env = open_environment()

File "/usr/lib/python2.2/site-packages/trac/core.py", line 178, in open_environment

version = env.get_version()

File "/usr/lib/python2.2/site-packages/trac/Environment.py", line 162, in get_version

cursor.execute("SELECT value FROM system WHERE name='database_version'")

File "/usr/lib/python2.2/site-packages/sqlite/main.py", line 237, in execute

self.con._begin()

File "/usr/lib/python2.2/site-packages/sqlite/main.py", line 508, in _begin

self.db.execute("BEGIN")

OperationalError: database is locked


working revision is #602 broken revision is #620

Dmitry

Attachments (0)

Change History (9)

comment:1 by anonymous, 15 years ago

I didn't logged out before upgrade… I wonder if this can couse the problem…

comment:2 by anonymous, 15 years ago

I moved back to the changeset [602]. And everything works fine. Than I logged out, and tried to upgrade again but with the same bad result. So, problem is not related to login.

comment:3 by anonymous, 15 years ago

Milestone: 0.7.1

it happened after i upgraded from db3 to db4….

comment:4 by daniel, 15 years ago

Milestone: 0.7.10.8

Has anyone else experienced this?

comment:5 by anonymous, 15 years ago

I mentioned, that it is important to properly close connection after use. Even in case of exception, connection must be properly closed & cleaned up. Otherwise in my environment I always hit database lock condition. I think this is what is happening but unfortunately I do not have time to test my theory.

Dmitry

comment:6 by anonymous, 15 years ago

I am having the same problem with the latest bleeding edge version. 0.7.1 works fine. The output I get is:

Oops…

Trac detected an internal error:

database is locked Traceback (most recent call last):

File "/usr/lib/python2.3/site-packages/trac/ModPythonHandler.py", line 174, in handler

core.dispatch_request(mpr.path_info, args, mpr, env)

File "/usr/lib/python2.3/site-packages/trac/core.py", line 389, in dispatch_request

req.session = Session.Session(env, req, newsession)

File "/usr/lib/python2.3/site-packages/trac/Session.py", line 50, in init

self.get_session(sid)

File "/usr/lib/python2.3/site-packages/trac/Session.py", line 106, in get_session

" WHERE sid=%s", self.sid)

File "/usr/lib/python2.3/site-packages/sqlite/main.py", line 237, in execute

self.con._begin()

File "/usr/lib/python2.3/site-packages/sqlite/main.py", line 508, in _begin

self.db.execute("BEGIN")

OperationalError: database is locked

I can try it with cgi if you want. I just reverted back to 0.7.1

comment:7 by anonymous, 15 years ago

I am happy to report I solved this problem by upgading to version 0.5 of pysqlite. Just in case anyone else is having this problem.

comment:8 by Jonas Borgström, 15 years ago

Resolution: fixed
Status: newclosed

pysqlite 0.5 has been out for quite some time now so we can safely depend on that version.

comment:9 by dg@…, 15 years ago

Version: 0.70.8

Note to Ubuntu Warty users :

You'll need to upgrade to python2.3-sqlite v1.0-2 and python-sqlite v 1.0-2. Warty's version is 0.4.3 which is not supported, and doesn't work.

(Sarge has the correct packages in, as does Ubuntu's Hoary)

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Jonas Borgström.
The resolution will be deleted. Next status will be 'reopened'.
to as closed The owner will be changed from Jonas Borgström to the specified user.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.