Opened 5 years ago

Closed 5 years ago

Last modified 4 years ago

#13439 closed defect (invalid)

OperationalError: database is locked

Reported by: anonymous Owned by: developers
Priority: normal Milestone: Barrier Breaker 14.07
Component: packages Version: Trunk
Keywords: Cc:


How to Reproduce

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

(please provide additional details here)

Request parameters:

{'__FORM_TOKEN': u'74db9e3ff3519f47325fba4c',
 'author': u'',
 'field_cc': u'',
 'field_component': u'base system',
 'field_description': u'We have Wifi board with model noJWAP603(of JJPLUS) with processor Atheros AR7240,\r\n\r\nWe require Firmware for the above board, please do the needful',
 'field_keywords': u'',
 'field_milestone': u'Backfire 10.03.2',
 'field_priority': u'normal',
 'field_summary': u'Firmware for JJPLUS board model no:JWAP603, Atheros AR7240',
 'field_type': u'enhancement',
 'field_version': u'Backfire 10.03.1 RC6',
 'sfp_email': u'',
 'sfph_mail': u'',
 'submit': u'Create ticket'}

User agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.31 (KHTML, like Gecko) Chrome/26.0.1410.64 Safari/537.31

System Information

System information not available

Enabled Plugins

Plugin information not available

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/trac/web/", line 497, in _dispatch_request
  File "/usr/lib/python2.7/dist-packages/trac/web/", line 214, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.7/dist-packages/trac/ticket/", line 180, in process_request
    return self._process_newticket_request(req)
  File "/usr/lib/python2.7/dist-packages/trac/ticket/", line 463, in _process_newticket_request
    valid = self._validate_ticket(req, ticket)
  File "/usr/lib/python2.7/dist-packages/trac/ticket/", line 1278, in _validate_ticket
    for field, message in manipulator.validate_ticket(req, ticket):
  File "/usr/local/lib/python2.7/dist-packages/TracSpamFilter-0.7.1dev_r0-py2.7.egg/tracspamfilter/", line 65, in validate_ticket
    FilterSystem(self.env).test(req, author, changes)
  File "/usr/local/lib/python2.7/dist-packages/TracSpamFilter-0.7.1dev_r0-py2.7.egg/tracspamfilter/", line 199, in test
    score, ['%s (%d): %s' % r for r in reasons]).insert()
  File "/usr/local/lib/python2.7/dist-packages/TracSpamFilter-0.7.1dev_r0-py2.7.egg/tracspamfilter/", line 138, in insert
  File "/usr/lib/python2.7/dist-packages/trac/db/", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.7/dist-packages/trac/db/", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "/usr/lib/python2.7/dist-packages/trac/db/", line 56, in execute
    args or [])
  File "/usr/lib/python2.7/dist-packages/trac/db/", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: database is locked

Attachments (0)

Change History (3)

comment:1 Changed 5 years ago by jow

  • Resolution set to invalid
  • Status changed from new to closed

transient error

comment:2 Changed 5 years ago by anonymous

Could the text on the Trac error page be changed to decrease users' eagerness to report these database trac bugs?

Currently the trac error page says "please report a bug so that the sysadmins get notified about this problem", and I feed that this is bad advice regarding these transiert trac errors.

comment:3 Changed 4 years ago by jow

  • Milestone changed from Attitude Adjustment 12.09 to Barrier Breaker 14.07

Milestone Attitude Adjustment 12.09 deleted

Add Comment

Modify Ticket

as closed .
The resolution will be deleted. Next status will be 'reopened'.

E-mail address and user name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.