OperationalError: database or disk is full

[michelle.lowe@…]

How to Reproduce

While doing a GET operation on /query, Trac issued an internal error.

Oops… Trac detected an internal error: OperationalError: database or disk is full

---

Our Account

Account Name: Timmons Description: Account Level: Equity Account Active: Yes - Enabled Disk Usage 528.1 MB (1.76%)

Request parameters:

{'group': u'resolution',
 'milestone': u'Maintenance Window 2',
 'status': u'closed'}

System Information

Trac	0#11#6
Python	2#5#4 #r254:67916, Dec 3 2009, 14:36:49# ##br## #GCC 4#1#2 20080704 #Red Hat 4#1#2-46##
setuptools	0#6c11
SQLite	3#3#6
pysqlite	2#5#6
Genshi	0#5#1
mod_wsgi	3#1 #WSGIProcessGroup WSGIApplicationGroup %{GLOBAL}#
Pygments	1#1#1
Subversion	1#6#6 #r40053#
RPC	1#0#6

Python Traceback

Traceback #most recent call last#:
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/main.py", line 450, in _dispatch_request
    dispatcher.dispatch#req#
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/main.py", line 229, in dispatch
    req.session.save##
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/session.py", line 100, in save
    #self.sid,##
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/db/util.py", line 64, in execute
    return self.cursor.execute#sql_escape_percent#sql#, args#
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/db/sqlite_backend.py", line 80, in execute
    PyFormatCursor.execute#self, *args#
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/db/sqlite_backend.py", line 59, in execute
    args or [])
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/db/sqlite_backend.py", line 51, in _rollback_on_error
    return function#self, *args, **kwargs#
OperationalError: database or disk is full

[Remy Blank]

InstallationIssue and duplicate (search:"database or disk is full?ticket=on").

(And please post logs as plain text, possibly compressed if they are large.)

[anonymous]

Attached file → inserted here as plain text….

Oops… Trac detected an internal error: OperationalError: database or disk is full

Our Account

Account Name: Timmons Description: Account Level: Equity Account Active: Yes - Enabled Disk Usage 528.1 MB (1.76%)

Python Traceback Most recent call last:

• File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/main.py", line 450, in_dispatch_request

Code fragment:

445. try:
446. if not env and env_error:
447. raise HTTPInternalError(env_error)
448. try:
449. dispatcher = RequestDispatcher(env)
450. dispatcher.dispatch(req)
451. except RequestDone:
452. pass
453. resp = req._response or []
455. except HTTPException, e:

Local variables: Name Value after [u' except RequestDone:', u' pass', u' resp = … before [u' try:', u' if not env and env_error:', u' raise … dispatcher <trac.web.main.RequestDispatcher object at 0x3d0e5d90> e OperationalError('database or disk is full',) env <trac.env.Environment object at 0x3cf87b10> env_error None exc_info (<class 'pysqlite2.dbapi2.OperationalError'>, OperationalError('database … filename '/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/main … frames [{'function': '_dispatch_request', 'lines_before': [u' try:', u' … has_admin True line u' dispatcher.dispatch(req)' lineno 449 message u'OperationalError: database or disk is full' req <Request "GET u'/query'"> resp [] tb <traceback object at 0x3d08ba28> tb_hide None traceback u'Traceback (most recent call last):\n File …

• File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/main.py", line 229, indispatch

Code fragment:

224. req.send(out.getvalue(), 'text/plain')
225. else:
226. output = chrome.render_template(req, template,
227. data, content_type)
228. # Give the session a chance to persist changes
229. req.session.save()
230. req.send(output, content_type or 'text/html')
231. else:
232. self._post_process_request(req)
233. except RequestDone:
234. raise

Local variables: Name Value chosen_handler <trac.ticket.query.QueryModule object at 0x3d0e5b10> chrome <trac.web.chrome.Chrome object at 0x3d0e5750> content_type None data {'tickets': [{u'status': u'closed', u'changetime': datetime.datetime(2011, … err (<class 'pysqlite2.dbapi2.OperationalError'>, OperationalError('database … handler <trac.ticket.query.QueryModule object at 0x3d0e5b10> output '<!DOCTYPE html PUBLIC "-W3CDTD XHTML 1.0 StrictEN" … req <Request "GET u'/query'"> resp ('query.html', {'tickets': [{u'status': u'closed', u'changetime': … self <trac.web.main.RequestDispatcher object at 0x3d0e5d90> template 'query.html'

• File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/session.py", line 100, insave

Code fragment:

95. self.env.log.warning('Session %s already exists: %s' %
96. (self.sid, e))
97. if self._old != self:
98. attrs = [(self.sid, authenticated, k, v) for k, v in self.items()]
99. cursor.execute("DELETE FROM session_attribute WHERE sid=%s",
100. (self.sid,))
101. self._old = dict(self.items())
102. if attrs:
103. # The session variables might already have been updated by a
104. # concurrent request.
105. try:

Local variables: Name Value attrs [('michelle.lowe@…', 1, u'query_time', u'1315519058'), … authenticated 1 cursor <trac.db.util.IterableCursor object at 0x3d231ad0> db <trac.db.pool.PooledConnection object at 0x3d239f00> k u'email' now 1315519059 self {u'query_time': u'1315519058', u'tz': u'US/Eastern', u'name': u'Michelle … v u'michelle.lowe@…'

• File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/db/util.py", line 64, inexecute

Code fragment:

59. return r
60. except Exception, e:
61. self.log.debug('execute exception: %r', e)
62. raise
63. if args:
64. return self.cursor.execute(sql_escape_percent(sql), args)
65. return self.cursor.execute(sql)
67. def executemany(self, sql, args=None):
68. if self.log:
69. self.log.debug('SQL: %r', sql)

Local variables: Name Value args ('michelle.lowe@…',) self <trac.db.util.IterableCursor object at 0x3d231ad0> sql 'DELETE FROM session_attribute WHERE sid=%s'

• File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/db/sqlite_backend.py", line 80, inexecute

Code fragment:

75. PyFormatCursor.init(self, con)
76. self.rows = []
77. self.pos = 0
79. def execute(self, *args):
80. PyFormatCursor.execute(self, *args)
81. self.rows = PyFormatCursor.fetchall(self)
82. self.pos = 0
84. def fetchone(self):
85. try:

Local variables: Name Value args ('DELETE FROM session_attribute WHERE sid=%s', … self <trac.db.sqlite_backend.EagerCursor object at 0x3c339c30>

• File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/db/sqlite_backend.py", line 59, inexecute

Code fragment:

54. raise
55. def execute(self, sql, args=None):
56. if args:
57. sql = sql % (('?',) * len(args))
58. return self._rollback_on_error(sqlite.Cursor.execute, sql,
59. args or [])
60. def executemany(self, sql, args=None):
61. if args:
62. sql = sql % (('?',) * len(args[0]))
63. return self._rollback_on_error(sqlite.Cursor.executemany, sql,
64. args or [])

Local variables: Name Value args ('michelle.lowe@…',) self <trac.db.sqlite_backend.EagerCursor object at 0x3c339c30> sql 'DELETE FROM session_attribute WHERE sid=?'

• File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/db/sqlite_backend.py", line 51, in_rollback_on_error

Code fragment:

46. sqlite_version_string = '%d.%d.%d' % (_ver[0], _ver[1], int(_ver[2]))
48. class PyFormatCursor(sqlite.Cursor):
49. def _rollback_on_error(self, function, *args, kwargs):
50. try:
51. return function(self, *args, kwargs)
52. except sqlite.DatabaseError, e:
53. self.cnx.rollback()
54. raise
55. def execute(self, sql, args=None):
56. if args:

Local variables: Name Value args ('DELETE FROM session_attribute WHERE sid=?', … e OperationalError('database or disk is full',) function <method 'execute' of 'pysqlite2.dbapi2.Cursor' objects> kwargs {} self <trac.db.sqlite_backend.EagerCursor object at 0x3c339c30> File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/main.py", line 450, in _dispatch_request

dispatcher.dispatch(req)

File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/main.py", line 229, in dispatch

req.session.save()

File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/session.py", line 100, in save

(self.sid,))

File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/db/util.py", line 64, in execute

return self.cursor.execute(sql_escape_percent(sql), args)

File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/db/sqlite_backend.py", line 80, in execute

PyFormatCursor.execute(self, *args)

File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/db/sqlite_backend.py", line 59, in execute

args or [])

File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/db/sqlite_backend.py", line 51, in _rollback_on_error

return function(self, *args, kwargs)

System Information: Trac: 0.11.6 Python: 2.5.4 (r254:67916, Dec 3 2009, 14:36:49) [GCC 4.1.2 20080704 (Red Hat 4.1.2-46)] setuptools: 0.6c11 SQLite: 3.3.6 pysqlite: 2.5.6 Genshi: 0.5.1 mod_wsgi: 3.1 (WSGIProcessGroup WSGIApplicationGroup %{GLOBAL}) Pygments: 1.1.1 Subversion: 1.6.6 (r40053) RPC: 1.0.6

[Christian Boos]

Please contact your local Trac Administrator.

The problem is that the "database or disk is full" in your local installation and we unfortunately can't do anything for that… though maybe in one future version of Trac, we could implement a disk vacuum feature triggered by a GET /more-disk-space-please request ;-)