relation "system" does not exist

[John of NOVA]

I have trac .10 using a Postgresql database that has multiple schemas for various applications. Trac is running on a server and the postgres database is on a different server

I read the ticket http://trac.edgewall.org/ticket/3308 but it said it has been resolved. I checked the file I have in my /usr/lib/python2.4/site-packages/trac/db folder and verified the changes are still there.

The address is as follows:
postgres://trac:trac@vp-vm-postgres:5432/APPSUPPORTDB?schema=trac

The error I get reports:
[Fri Sep 07 00:18:09 2012] [info] [client 10.248.54.176] mod_wsgi (pid=30411, process='', application=''): Loading WSGI script '/etc/trac/vp/apache/cgi-bin/trac.wsgi'.
[Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176] mod_wsgi (pid=30411): Exception occurred processing WSGI script '/etc/trac/vp/apache/cgi-bin/trac.wsgi'.
[Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176] Traceback (most recent call last):
[Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176]   File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 391, in dispatch_request
[Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176]     env = _open_environment(env_path, run_once=run_once)
[Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176]   File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 58, in _open_environment
[Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176]     env_cache[env_path] = open_environment(env_path)
[Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176]   File "/usr/lib/python2.4/site-packages/trac/env.py", line 467, in open_environment
[Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176]     if env.needs_upgrade():
[Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176]   File "/usr/lib/python2.4/site-packages/trac/env.py", line 354, in needs_upgrade
[Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176]     if participant.environment_needs_upgrade(db):
[Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176]   File "/usr/lib/python2.4/site-packages/trac/env.py", line 408, in environment_needs_upgrade
[Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176]     dbver = self.env.get_version(db)
[Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176]   File "/usr/lib/python2.4/site-packages/trac/env.py", line 268, in get_version
[Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176]     cursor.execute("SELECT value FROM system WHERE name='database_version'")
[Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176]   File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 51, in execute
[Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176]     return self.cursor.execute(sql)
[Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176]   File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 51, in execute
[Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176]     return self.cursor.execute(sql)
[Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176] ProgrammingError: relation "system" does not exist at character 19

[John of NOVA]

Resolved, apparently someone on my team removed the schema I had for trac and didn't report it. I had to pull up the database pgAdmin III and visually check if it was there.