Re-creating the DB seems to have worked better than the first time. Now
I've got the following relations:
koji=> \ds
List of relations
Schema | Name | Type | Owner
--------+----------------------------+----------+-------
public | archiveinfo_id_seq | sequence | koji
public | archivetypes_id_seq | sequence | koji
public | build_id_seq | sequence | koji
public | build_notifications_id_seq | sequence | koji
public | build_target_id_seq | sequence | koji
public | buildroot_id_seq | sequence | koji
public | channels_id_seq | sequence | koji
public | events_id_seq | sequence | koji
public | external_repo_id_seq | sequence | koji
public | groups_id_seq | sequence | koji
public | host_id_seq | sequence | koji
public | imageinfo_id_seq | sequence | koji
public | log_messages_id_seq | sequence | koji
public | package_id_seq | sequence | koji
public | permissions_id_seq | sequence | koji
public | repo_id_seq | sequence | koji
public | rpminfo_id_seq | sequence | koji
public | sessions_id_seq | sequence | koji
public | tag_id_seq | sequence | koji
public | task_id_seq | sequence | koji
public | users_id_seq | sequence | koji
(21 rows)
Thanks for all of the help guys! I'll move forward with this and see what
happens. :)
- Steve
On Fri, 5 Nov 2010, Mike McLean wrote:
On 11/05/2010 01:45 PM, steve.webb(a)beatport.com wrote:
> On Fri, 5 Nov 2010, Mike McLean wrote:
>> On 11/05/2010 12:52 PM, steve.webb(a)beatport.com wrote:
>>> DatabaseError: error 'ERROR: relation "sessions_id_seq" does
not exist
>> The \ds command in psql will do this.
>
> koji=> \ds
> List of relations
> Schema | Name | Type | Owner
> --------+----------------------+----------+-------
> public | archiveinfo_id_seq | sequence | koji
> public | archivetypes_id_seq | sequence | koji
> public | build_id_seq | sequence | koji
> public | buildroot_id_seq | sequence | koji
> public | channels_id_seq | sequence | koji
> public | events_id_seq | sequence | koji
> public | external_repo_id_seq | sequence | koji
> public | host_id_seq | sequence | koji
> public | package_id_seq | sequence | koji
> public | repo_id_seq | sequence | koji
> public | rpminfo_id_seq | sequence | koji
> public | tag_id_seq | sequence | koji
> public | task_id_seq | sequence | koji
> public | users_id_seq | sequence | koji
> (14 rows)
Yep, something must have gone wrong during db initialization. I suggest
you drop the db and re-initialize it (and keep the output for reference).
Also missing: build_notifications_id_seq, buildroot_id_seq,
groups_id_seq, imageinfo_id_seq, log_messages_id_seq,
permissions_id_seq, rpmdeps_pkey_seq.
Based on the missing sequences, it looks like an error occurred
somewhere between the creation of the external_repo table and the
buildroot table. This is odd because schema.sql wraps all those
definitions in a transaction to prevent /exactly/ this sort of partial
initialization. Did you manually cut and paste the sql commands into
psql or something? Generally you want to run schema.sql through psql
directly from the command line (I believe the ServerHowTo doc covers this).
--
buildsys mailing list
buildsys(a)lists.fedoraproject.org
https://admin.fedoraproject.org/mailman/listinfo/buildsys
--
Steve Webb | System Administrator
Beatport | Music for DJ's
------------------------------------------
2399 Blake Street, Suite 170
Denver, Colorado USA 80205
tel: +1.720.932.9103
fax: +1.720.932.9104
noc: +1.303.565.2710
mobile: +1.303.564.4269