[SAC] [OSGeo] #357: random server errors

[OSGeo]

#357: random server errors
-------------------+--------------------------------------------------------
Reporter:  pcav    |       Owner:  sac at lists.osgeo.org
    Type:  defect  |      Status:  new                
Priority:  normal  |   Component:  SAC                
Keywords:          |  
-------------------+--------------------------------------------------------
 I get random errors:
 ===
 Internal Server Error

 The server encountered an internal error or misconfiguration and was
 unable to complete your request.

 Please contact the server administrator, root at localhost and inform them
 of the time the error occurred, and anything you might have done that
 may have caused the error.

 More information about this error may be available in the server error
 log.
 Apache/2.0.52 (Red Hat) Server at trac.osgeo.org Port 443
 ===

 and

 ===
 Oops…
 Trac detected an internal error:


 Traceback (most recent call last):
   File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 387, in
 dispatch_request
     dispatcher.dispatch(req)
   File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 191, in
 dispatch
     chosen_handler = self._pre_process_request(req, chosen_handler)
   File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 263, in
 _pre_process_request
     chosen_handler = f.pre_process_request(req, chosen_handler)
   File "/usr/lib/python2.3/site-packages/trac/versioncontrol/api.py",
 line 73, in pre_process_request
     self.get_repository(req.authname) # triggers a sync if applicable
   File "/usr/lib/python2.3/site-packages/trac/versioncontrol/api.py",
 line 101, in get_repository
     repos = self._connector.get_repository(rtype, rdir, authname)
   File "/usr/lib/python2.3/site-packages/trac/versioncontrol/svn_fs.py",
 line 260, in get_repository
     crepos = CachedRepository(self.env.get_db_cnx(), repos, None,
 self.log)
   File "/usr/lib/python2.3/site-packages/trac/versioncontrol/cache.py",
 line 34, in __init__
     self.sync()
   File "/usr/lib/python2.3/site-packages/trac/versioncontrol/cache.py",
 line 56, in sync
     cursor.execute("SELECT value FROM system WHERE name='repository_dir'")
   File "/usr/lib/python2.3/site-packages/trac/db/util.py", line 51, in
 execute
     return self.cursor.execute(sql)
   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
 ===
 More generally, the server is quite slow. Also, it appears partly
 misconfigured, and based on a rather old apache. And very old python.

-- 
Ticket URL: <http://trac.osgeo.org/osgeo/ticket/357>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.