[Trac-tickets] Re: [The Trac Project] #1769: "Oops... database is locked" error in standard, fresh installation

[The Trac Project]

#1769: "Oops... database is locked" error in standard, fresh installation
----------------------------------------------+-----------------------------
 Reporter:  airbaggins at users.sourceforge.net  |        Owner:  jonas   
     Type:  defect                            |       Status:  reopened
 Priority:  highest                           |    Milestone:          
Component:  general                           |      Version:  0.8.4   
 Severity:  critical                          |   Resolution:          
 Keywords:  database locked                   |  
----------------------------------------------+-----------------------------
Changes (by NumaanHuq at vtech.ca):

  * status:  closed => reopened
  * severity:  blocker => critical
  * resolution:  invalid =>
  * keywords:  new install database locked => database locked

Comment:

 I've the same problem as described above. Since Friday (Oct 14, 2005)I've
 been running TRAC as www-data.staff and it worked fine and correctly. We
 continued to checkin/checkout our data into subversion and made NO changes
 to TRAC whatsoever. We got the database is locked error totally out of the
 blues. It was working one minute and the next minute the entire system
 just froze up. We can use the Wiki and the ticket system but as soon as we
 try to access the Browse Source the trac.cgi script (seen from top) gets
 hold of 99.9% CPU time and keeps on processing infinitely. We've
 determined that trac is opening the svn repository, reading it, closing
 it, opening the svn repository, reading it, closing it... infinitely.
 Thank you.

 Numaan

 Traceback (most recent call last):
   File "/usr/lib/python2.3/site-packages/trac/core.py", line 531, in
 cgi_start
     real_cgi_start()
   File "/usr/lib/python2.3/site-packages/trac/core.py", line 513, in
 real_cgi_start
     env = open_environment()
   File "/usr/lib/python2.3/site-packages/trac/core.py", line 190, in
 open_environment
     version = env.get_version()
   File "/usr/lib/python2.3/site-packages/trac/Environment.py", line 162,
 in get_version
     cursor.execute("SELECT value FROM system WHERE
 name='database_version'")
   File "/usr/lib/python2.3/site-packages/sqlite/main.py", line 244, in
 execute
     self.rs = self.con.db.execute(SQL)
 OperationalError: database is locked

-- 
Ticket URL: <http://projects.edgewall.com/trac/ticket/1769>
The Trac Project <http://trac.edgewall.com/>