OperationalError: (1136, "Column count doesn't match value count at row 1")

[trac@…]

How to Reproduce

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

After an upgrade, downgrade and reupgrade I sometimes get this error. If I create a new page, after saving it, there is the issue.

Request parameters:

{}

User agent: Mozilla/5.0 (Windows NT 6.1; rv:11.0) Gecko/20100101 Firefox/11.0

System Information

Trac	0.12.3
Genshi	0.6
mod_python	3.3.1
MySQL	server: "5.1.61-0ubuntu0.10.04.1", client: "5.1.61", thread-safe: 1
MySQLdb	1.2.2
Pygments	1.2.2
Python	2.6.5 (r265:79063, Apr 16 2010, 14:15:55) [GCC 4.4.3]
pytz	2010b
setuptools	0.6
Subversion	1.6.6 (r40053)
jQuery	1.4.4

Enabled Plugins

TracGanttCalendarPlugin

0.6.2-r817

Python Traceback

Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.3-py2.6.egg/trac/web/main.py", line 522, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.3-py2.6.egg/trac/web/main.py", line 208, in dispatch
    chosen_handler)
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.3-py2.6.egg/trac/web/main.py", line 350, in _pre_process_request
    chosen_handler = filter_.pre_process_request(req, chosen_handler)
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.3-py2.6.egg/trac/versioncontrol/api.py", line 332, in pre_process_request
    repo.sync()
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.3-py2.6.egg/trac/versioncontrol/cache.py", line 134, in sync
    @self.env.with_transaction()
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.3-py2.6.egg/trac/db/api.py", line 77, in transaction_wrapper
    fn(ldb)
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.3-py2.6.egg/trac/versioncontrol/cache.py", line 176, in do_transaction
    del self.metadata
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.3-py2.6.egg/trac/cache.py", line 47, in __delete__
    CacheManager(instance.env).invalidate(id)
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.3-py2.6.egg/trac/cache.py", line 185, in invalidate
    @self.env.with_transaction()
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.3-py2.6.egg/trac/db/api.py", line 73, in transaction_wrapper
    fn(ldb)
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.3-py2.6.egg/trac/cache.py", line 195, in do_invalidate
    (id, 0))
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.3-py2.6.egg/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1136, "Column count doesn't match value count at row 1")

[Christian Boos]

Replying to trac@…:

… After an upgrade, downgrade and reupgrade …

Well, you seem to imply 0.12 → 0.13 (upgrade) → 0.12 (downgrade) → 0.13 (reupgrade), but you report using 0.12.3.

The cache table indeed went from 2 columns to 3 columns, from 0.12 to 0.13.

Compare your cache table with what you should have for 0.12.3 or trunk.

trunk cache​:

MySQL [trac013mb4]> describe cache;
+------------+---------+------+-----+---------+-------+
| Field      | Type    | Null | Key | Default | Extra |
+------------+---------+------+-----+---------+-------+
| id         | int(11) | NO   | PRI | 0       |       |
| generation | int(11) | YES  |     | NULL    |       |
| key        | text    | YES  |     | NULL    |       |
+------------+---------+------+-----+---------+-------+

0.12.3 cache​

MySQL [trac0123rc1]> describe cache;
+------------+---------+------+-----+---------+-------+
| Field      | Type    | Null | Key | Default | Extra |
+------------+---------+------+-----+---------+-------+
| id         | text    | NO   | PRI | NULL    |       |
| generation | int(11) | YES  |     | NULL    |       |
+------------+---------+------+-----+---------+-------+

Downgrading is not really supported by us, so you have to be extra careful when doing it… (and double check the version you're running is really the one you want ;-) ).