ProgrammingError: invalid input syntax for integer: "trac.wiki.api.WikiSystem.pages"

[eap@…]

How to Reproduce

While doing a GET operation on /wiki, Trac issued an internal error.

Upon upgrading from Trac 0.12 to Trac 1.0.1 we are getting this ProgrammingError when visiting the Wiki

Request parameters:

{}

User agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/536.28.10 (KHTML, like Gecko) Version/6.0.3 Safari/536.28.10

System Information

Trac	0.12.3
Genshi	0.6
mod_python	3.3.1
psycopg2	2.0.6
Pygments	0.9
Python	2.5.2 (r252:60911, Jan 20 2010, 22:05:59) [GCC 4.2.4 (Ubuntu 4.2.4-1ubuntu3)]
RPC	1.1.2
setuptools	0.6c12
Subversion	1.4.6 (r28521)
jQuery	1.4.4

Enabled Plugins

BatchModify	0.8.0-trac0.12
TestManager	1.4.6
TracCustomFieldAdmin	0.2.8-r11409
TracGenericClass	1.0.6
TracGenericWorkflow	1.0.2
TracXMLRPC	1.1.2

Python Traceback

Traceback (most recent call last):
  File "build/bdist.linux-i686/egg/trac/web/main.py", line 522, in _dispatch_request
    dispatcher.dispatch(req)
  File "build/bdist.linux-i686/egg/trac/web/main.py", line 243, in dispatch
    resp = chosen_handler.process_request(req)
  File "build/bdist.linux-i686/egg/trac/wiki/web_ui.py", line 173, in process_request
    return self._render_view(req, versioned_page)
  File "build/bdist.linux-i686/egg/trac/wiki/web_ui.py", line 625, in _render_view
    for template in ws.get_pages(prefix)
  File "build/bdist.linux-i686/egg/trac/wiki/api.py", line 248, in get_pages
    for page in self.pages:
  File "build/bdist.linux-i686/egg/trac/cache.py", line 38, in __get__
    return CacheManager(instance.env).get(id, self.retriever, instance)
  File "build/bdist.linux-i686/egg/trac/cache.py", line 157, in get
    cursor.execute("SELECT generation FROM cache WHERE id=%s", (id,))
  File "build/bdist.linux-i686/egg/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
ProgrammingError: invalid input syntax for integer: "trac.wiki.api.WikiSystem.pages"

[eap@…]

All pages on the Wiki return this error.

[anonymous]

Fixed after restarting apache for a second time.