Modify ↓
      
Opened 13 years ago
Closed 13 years ago
#10946 closed defect (cantfix)
OperationalError: cannot commit transaction - SQL statements in progress
| Reported by: | Owned by: | ||
|---|---|---|---|
| Priority: | normal | Milestone: | |
| Component: | admin/web | Version: | |
| Severity: | normal | Keywords: | |
| Cc: | Branch: | ||
| Release Notes: | |||
| API Changes: | |||
| Internal Changes: | |||
Description
How to Reproduce
While doing a POST operation on /admin/accounts/users, Trac issued an internal error.
(please provide additional details here)
The error can be reproduced when attempting to reset password for a specific user and occurs both from the Web Admin Panel & from the Forgot Password Form.
Method works for other users.
User Agent was: Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0
System Information
| Trac |  0.11.1 
 | 
| Python |  2.5.2 (r252:60911, Jan 24 2010, 17:44:40)  [GCC 4.3.2] 
 | 
| setuptools |  0.6c8 
 | 
| SQLite |  3.5.9 
 | 
| pysqlite |  2.4.1 
 | 
| Genshi |  0.5.1 
 | 
| Pygments |  0.10 
 | 
| GIT |  1.7.1.1 
 | 
| jQuery: |  1.2.6 
 | 
Python Traceback
Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 423, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 197, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.5/site-packages/trac/admin/web_ui.py", line 113, in process_request
    path_info)
  File "build/bdist.linux-x86_64/egg/acct_mgr/admin.py", line 137, in render_admin_panel
    return self._do_users(req)
  File "build/bdist.linux-x86_64/egg/acct_mgr/admin.py", line 253, in _do_users
    acctmod._reset_password(username, email)
  File "build/bdist.linux-x86_64/egg/acct_mgr/web_ui.py", line 333, in _reset_password
    self.store.set_password(username, new_password)
  File "build/bdist.linux-x86_64/egg/acct_mgr/db.py", line 86, in set_password
    db.commit()
OperationalError: cannot commit transaction - SQL statements in progress
Attachments (0)
  Note:
 See   TracTickets
 for help on using tickets.
    


  
PluginIssue (TH:AccountManagerPlugin).
Also, your Trac version is a bit dated. Upgrade to at least the latest minor release of that branch (TracDownload#LegacyStableRelease).