DatabaseError: database or disk is full

[mirna.bou@…]

How to Reproduce

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

(please provide additional details here)

Request parameters:

{'__FORM_TOKEN': u'da8353075b94bc2bc5e876a4',
 'add_filter': u'',
 'col': ['id',
         u'summary',
         u'status',
         u'owner',
         u'type',
         u'priority',
         u'component'],
 'group': u'',
 'max': u'100',
 'milestone': u'Mod\xe9le 2D',
 'milestone_mode': u'',
 'order': u'id',
 'owner': [u'jfrappier', u'bjean', u'bjean@nordicewp.com'],
 'owner_mode': u'!',
 'report': u'22',
 'status': [u'accepted', u'assigned', u'new', u'reopened'],
 'update': u'Update'}

User Agent was: Mozilla/4.0 #compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0#

#### System Information ####

Trac	0.11
Python	2.4.3 ##1, Dec 11 2006, 11:38:52# [GCC 4.1.1 20061130 #Red Hat 4.1.1-43#]
setuptools	0.6c9
SQLite	3.3.6
pysqlite	1.1.7
Genshi	0.5.1
Pygments	0.11.1
Subversion	1.5.1 #r32289#
jQuery:	1.2.3

#### Python Traceback ####

Traceback #most recent call last#:
  File "/usr/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/web/main.py", line 423, in _dispatch_request
    dispatcher.dispatch#req#
  File "/usr/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/web/main.py", line 197, in dispatch
    resp # chosen_handler.process_request#req#
  File "/usr/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/ticket/query.py", line 795, in process_request
    req.redirect#query.get_href#req.href##
  File "/usr/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/web/api.py", line 266, in redirect
    self.session.save## # has to be done before the redirect is sent
  File "/usr/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/web/session.py", line 88, in save
    #self.sid,##
  File "/usr/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/db/util.py", line 50, in execute
    return self.cursor.execute#sql_escape_percent#sql#, args#
  File "/usr/lib/python2.4/site-packages/sqlite/main.py", line 255, in execute
    self.rs # self.con.db.execute#SQL % parms#
DatabaseError: database or disk is full

[Christian Boos]

So, do you suggest that we implement some disk cleaning heuristic? We could start removing all those useless *.bak files…

Seriously though, this error usually indicates that SQLite is running out of space for its journal or temp file in /tmp. Check that.

Also, pysqlite 1.1.7 is a bit old, you'd better upgrade to something more recent, see PySqlite (as of today, 2.5.5).