DatabaseError: database disk image is malformed

[RoverBook]

Как воспроизвести

При выполнении операции POST по /wiki/Ru:Help/Action/SelectAll, Trac выдает внутреннюю ошибку.

(просьба предоставить дополнительные подробности здесь)

Параметры запроса:

{'__FORM_TOKEN': u'99644cebf1a69e12eccc3195',
 'action': u'edit',
 'author': u'RoverBook',
 'comment': u'',
 'editrows': u'8',
 'from_editor': u'1',
 'page': u'Ru:Help/Action/SelectAll',
 'save': u'\u041e\u0442\u043f\u0440\u0430\u0432\u0438\u0442\u044c \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f',
 'scroll_bar_pos': u'0',
 'text': u"[[TranslatedPages]]\r\n= \u0412\u044b\u0431\u0440\u0430\u0442\u044c \u0432\u0441\u0435 =\r\n\r\n[[Image(source:/trunk/images/selectall.png)]] ''\u0421\u043e\u0447\u0435\u0442\u0430\u043d\u0438\u0435 \u043a\u043b\u0430\u0432\u0438\u0448'': '''{{{Ctrl+A}}}'''\r\n\r\n\u0412\u044b\u0434\u0435\u043b\u044f\u0435\u0442 \u0432\u0441\u0435 [wiki:Ru:Help/Concepts/Object \u043e\u0431\u044a\u0435\u043a\u0442\u044b] \u043d\u0430 \u0430\u043a\u0442\u0438\u0432\u043d\u043e\u043c \u0441\u043b\u043e\u0435 \u0434\u0430\u043d\u043d\u044b\u0445.\r\n\r\n== \u0421\u043c. \u0442\u0430\u043a\u0436\u0435 ==\r\n * [[Image(source:/trunk/images/unselectall.png)]] [wiki:Ru:Help/Action/UnselectAll \u0421\u043d\u044f\u0442\u044c \u0432\u044b\u0434\u0435\u043b\u0435\u043d\u0438\u0435]\r\n * [wiki:Ru:Help/Concepts/Object \u041e\u0431\u044a\u0435\u043a\u0442\u044b]\r\n----\r\n\u041d\u0430\u0437\u0430\u0434 \u043a [wiki:Ru:Help/Menu/Edit \u041c\u0435\u043d\u044e \u041f\u0440\u0430\u0432\u043a\u0430][[Br]]\r\n\u041d\u0430\u0437\u0430\u0434 \u043a [wiki:Ru:Help \u041e\u0441\u043d\u043e\u0432\u043d\u043e\u0439 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0435]",
 'version': u'0'}

User agent: #USER_AGENT#

Системная информация

Системная информация недоступна

Включенные плагины

Информация о плагинах недоступна

Python Traceback

Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/web/main.py", line 511, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/web/main.py", line 260, in dispatch
    req.session.save()
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/web/session.py", line 156, in save
    @self.env.with_transaction()
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/db/api.py", line 77, in transaction_wrapper
    fn(ldb)
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/web/session.py", line 173, in purge_session_attributes
    """, (mintime,))
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/db/sqlite_backend.py", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/db/sqlite_backend.py", line 56, in execute
    args or [])
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/db/sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
DatabaseError: database disk image is malformed

[Don-vip]

This becomes annoying. Time to move to postgresql ?

[skyper]

I also get this quite a lot.

[stoecker]

We did update the sqlite version. Hopefully this fixes the issue.

[simon04]

Just a second ago, I received this error again. So I reopen the ticket.

[stoecker]

Sorry. This can't be. The database is still valid and it can't magically fix itself. You probably got a "database locked". This happens when a long-time task exceeds the locking wait time.

[simon04]

It was definitively a "database disk image is malformed".