Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Trac: Users

relation "system" does not exist

 

 

Trac users RSS feed   Index | Next | Previous | View Threaded


aggieborn at gmail

Sep 10, 2012, 8:17 AM

Post #1 of 2 (195 views)
Permalink
relation "system" does not exist

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 [at] vp-vm-postgre: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



--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To view this discussion on the web visit https://groups.google.com/d/msg/trac-users/-/M9kFU0N4Qa8J.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.


aggieborn at gmail

Sep 12, 2012, 8:27 AM

Post #2 of 2 (182 views)
Permalink
Re: relation "system" does not exist [In reply to]

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.

On Monday, September 10, 2012 11:17:21 AM UTC-4, John of NOVA wrote:
>
>
> 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 [at] vp-vm-postgre: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
>
>
>
>

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To view this discussion on the web visit https://groups.google.com/d/msg/trac-users/-/KxqsTQnh_2UJ.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.

Trac users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.