ValueError: timestamp out of range for platform time_t

[mcpbalaji@…]

How to Reproduce

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

(please provide additional details here)

User Agent was: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.0.5) Gecko/2008121911 CentOS/3.0.5-1.el5.centos Firefox/3.0.5

System Information

Trac	0.11
Python	2.5.2 (r252:60911, Jul 22 2009, 15:52:25) [GCC 4.2.4 (Ubuntu 4.2.4-1ubuntu3)]
setuptools	0.6c11
SQLite	3.4.2
pysqlite	2.3.2
Genshi	0.6
mod_python	3.3.1
Subversion	1.4.6 (r28521)
RPC	1.1.0-r7971
jQuery:	1.2.3

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/web/main.py", line 423, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/web/main.py", line 197, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/wiki/web_ui.py", line 114, in process_request
    page = WikiPage(self.env, pagename)
  File "/usr/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/wiki/model.py", line 43, in __init__
    self._fetch(name, version, db)
  File "/usr/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/wiki/model.py", line 70, in _fetch
    self.time = datetime.fromtimestamp(time, utc)
ValueError: timestamp out of range for platform time_t

[Remy Blank]

This looks very much like an InstallationIssue, more precisely a 0.12 database used with a 0.11 installation. Did you try to upgrade to 0.12, then revert back to 0.11?

[mcpbalaji@…]

Yes, But i have downgrade from trac 0.12 to 0.11. Please help to sole this problem. because all the trac 0.11 modules are installed in my box. Then i have did the

~$ sudo apt-get install sqlite3
~$ sudo sqlite3 /forge/trac_pool/grid/db/trac.db
SQLite version 3.3.8
Enter ".help" for instructions
sqlite> select * from system;
database_version|20
sqlite> update system set value = 19 where name = "database_version";
sqlite> .quit

After did the above Trac 0.11 its working fine but suddenly i getting this issue. when i am click the "wiki tab" its giving this error message.

[Remy Blank]

Unfortunately, downgrading from 0.12 to 0.11 is difficult. You would have to manually undo what the upgrade scripts have done. My advice would be to restore a pre-upgrade database (the upgrade should have created a backup in the db folder).

General advice: make a full backup of your environment and database, and test the upgrade on a copy.

So this is an InstallationIssue.

[anonymous]

Thanks a ton. I have done the same . Now working fine. Once again thanks your general advice.