trac-admin fails to handle addition of duplicate permissions gracefully

[trac-bugs@…]

$ trac-admin server permission add anonymous WIKI_VIEW
$ trac-admin server permission add anonymous WIKI_VIEW
Traceback (most recent call last):
  File "/usr/bin/trac-admin", line 8, in <module>
    load_entry_point('Trac==0.11.2', 'console_scripts', 'trac-admin')()
  File "//usr/lib/python2.5/site-packages/trac/admin/console.py", line 1294, in run
    return admin.onecmd(command)
  File "//usr/lib/python2.5/site-packages/trac/admin/console.py", line 123, in onecmd
    rv = cmd.Cmd.onecmd(self, line) or 0
  File "/usr/lib/python2.5/cmd.py", line 219, in onecmd
    return func(arg)
  File "//usr/lib/python2.5/site-packages/trac/admin/console.py", line 416, in do_permission
    self._do_permission_add(user, action)
  File "//usr/lib/python2.5/site-packages/trac/admin/console.py", line 453, in _do_permission_add
    self._permsys.grant_permission(user, action)
  File "//usr/lib/python2.5/site-packages/trac/perm.py", line 320, in grant_permission
    self.store.grant_permission(username, action)
  File "//usr/lib/python2.5/site-packages/trac/perm.py", line 226, in grant_permission
    (username, action))
  File "//usr/lib/python2.5/site-packages/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "//usr/lib/python2.5/site-packages/trac/db/sqlite_backend.py", line 58, in execute
    args or [])
  File "//usr/lib/python2.5/site-packages/trac/db/sqlite_backend.py", line 50, in _rollback_on_error
    return function(self, *args, **kwargs)
sqlite3.IntegrityError: columns username, action are not unique

(Ticket #3873 seems to be related, but it looks like it may have only been fixed for the web frontend)

[Christian Boos]

Verified.