can't addBuildPortsQueueEntry - postgresql error?

Chris Whitehouse cwhiteh at onetel.com
Fri Sep 2 17:16:35 EDT 2011


On 01/09/2011 14:32, Glen Barber wrote:
> On 9/1/11 9:28 AM, Chris Whitehouse wrote:
>> Hi,
>>
>> this is a tinderbox that I set up from scratch a while ago using
>> postgresql. It's the first time I've used postgresql so I probably did
>> something wrong when setting it up.
>>
>> eco9# ./tc addBuildPortsQueueEntry -b 9-tbports -d editors/zim
>> ERROR: Failed to add port editors/zim to the datastore: ERROR:  insert
>> or update on table "build_ports_queue" violates foreign key constraint
>> "build_ports_queue_user_id_fkey"
>> DETAIL:  Key (user_id)=(0) is not present in table "users"..
>
> Hi Chris,
>
> "tc" is using your root user for the build since you did not specify
> "-u".  If you haven't already, add a user to tinderbox, and rerun the
> above command followed by "-u username".
>
> Regards,
>
Hi Glen,

Yes that works thank you. I'm confused by two things though.

1 I'm sure I didn't create a user with ./tc addUser for my previous 
tinderbox, nor was it necessary to add the -u argument.

2 Section 8.9 of the README 
http://tinderbox.marcuscom.com/README/x740.html says "To use tinderd 
scheduling via the web you must first create a User:". I'm not using the 
web interface.

My previous tinderbox was using MySQL.

thanks

Chris




More information about the tinderbox-list mailing list