[Python-apps-team] Bug#560022: pysqlite2.dbapi2.ProgrammingError: Cannot operate on a closed cursor

[Petr Vorel]

Package: trac
Version: 0.11.6-1
Severity: normal

During upgrade from 0.11.5 to 0.11.6 I also run command
trac-admin /home/pevik/etc/trac_xaraya.sipe.cz_sqlite/ resync
which crashed:
Resyncing repository history... 
Traceback (most recent call last):
  File "/usr/bin/trac-admin", line 9, in <module>
    load_entry_point('Trac==0.11.6', 'console_scripts', 'trac-admin')()
  File "/usr/lib/python2.5/site-packages/trac/admin/console.py", line 1321, in run
    return admin.onecmd(command)
  File "/usr/lib/python2.5/site-packages/trac/admin/console.py", line 138, 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 681, in do_resync
    cursor.execute("SELECT count(rev) FROM revision")
  File "/usr/lib/python2.5/site-packages/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql)
  File "/usr/lib/python2.5/site-packages/trac/db/sqlite_backend.py", line 80, in execute
    PyFormatCursor.execute(self, *args)
  File "/usr/lib/python2.5/site-packages/trac/db/sqlite_backend.py", line 59, in execute
    args or [])
  File "/usr/lib/python2.5/site-packages/trac/db/sqlite_backend.py", line 51, in _rollback_on_error
    return function(self, *args, **kwargs)
pysqlite2.dbapi2.ProgrammingError: Cannot operate on a closed cursor.

Site itself it's working, there are some changes made by trac user, but version is still 0.11.5.
I wonder whether this patch has something to do with it:
* Fix a potential pysqlite cursor problem, thanks, Grzegorz Sobanski.
     See debian/patches/60_roadmap_dbx_cursor_fix.dpatch



-- System Information:
Debian Release: squeeze/sid
  APT prefers testing
  APT policy: (900, 'testing'), (800, 'unstable'), (700, 'experimental'), (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux 2.6.18.8-linode19 (SMP w/4 CPU cores)
Locale: LANG=cs_CZ.UTF-8, LC_CTYPE=cs_CZ.UTF-8 (charmap=UTF-8) (ignored: LC_ALL set to cs_CZ.utf8)
Shell: /bin/sh linked to /bin/dash

Versions of packages trac depends on:
ii  python                        2.5.4-2    An interactive high-level object-o
ii  python-central                0.6.13     register and build utility for Pyt
ii  python-genshi                 0.5.1-2    Python XML-based template engine
ii  python-mysqldb                1.2.2-10   A Python interface to MySQL
ii  python-pysqlite2              2.5.5-3    Python interface to SQLite 3
ii  python-setuptools             0.6.8-1    Python Distutils Enhancements (set

Versions of packages trac recommends:
ii  apache2                     2.2.14-2     Apache HTTP Server metapackage
ii  apache2-mpm-prefork [httpd] 2.2.14-2     Apache HTTP Server - traditional n
ii  libjs-jquery                1.3.3-2      JavaScript library for dynamic web
ii  nginx [httpd]               0.7.63-1     small, but very powerful and effic
ii  python-pygments             1.1.1+dfsg-2 syntax highlighting package writte
ii  python-subversion           1.6.6dfsg-2  Python bindings for Subversion
ii  python-tz                   2009p-1      Python version of the Olson timezo

Versions of packages trac suggests:
ii  libapache2-mod-python    3.3.1-8         Python-embedding module for Apache
ii  libapache2-mod-wsgi      2.6-1           Python WSGI adapter module for Apa
pn  python-docutils          <none>          (no description available)
pn  python-textile           <none>          (no description available)
pn  trac-accountmanager      <none>          (no description available)
pn  trac-bzr                 <none>          (no description available)
pn  trac-email2trac          <none>          (no description available)
pn  trac-git                 <none>          (no description available)
pn  trac-mercurial           <none>          (no description available)
ii  trac-spamfilter          0.2.1+svn6871-3 Spam-prevention plugin for Trac

-- no debconf information