Foreman rake db:migrate fault when moving to postgresql

Support
1

I receive the following migration error

postgres 8.4
puppet 2.6.4

RAILS_ENV=production rake db:migrate
(in /usr/share/foreman)
== AddOwnerToHosts: migrating ================================================
– add_column(:hosts, :owner_id, :integer)
-> 0.0010s
– add_column(:hosts, :owner_type, :string)
-> 0.0004s
– setting default owner for all hosts
rake aborted!
An error has occurred, this and all later migrations canceled:

PGError: ERROR: invalid input syntax for integer: ""
LINE 1: UPDATE "hosts" SET owner_id = ''
^
: UPDATE "hosts" SET owner_id = ''

(See full trace by running task with --trace)

Met vriendelijke groeten,
Pieter Baele
www.pieterb.be

2

can you try the fix in Bug #465: Migration AddOwnerToHosts fails with PostgreSQL - Foreman?

Thanks,
Ohad

··· On Wed, Dec 15, 2010 at 2:36 PM, Pieter Baele wrote:

I receive the following migration error

postgres 8.4
puppet 2.6.4

RAILS_ENV=production rake db:migrate
(in /usr/share/foreman)
== AddOwnerToHosts: migrating

– add_column(:hosts, :owner_id, :integer)
-> 0.0010s
– add_column(:hosts, :owner_type, :string)
-> 0.0004s
– setting default owner for all hosts
rake aborted!
An error has occurred, this and all later migrations canceled:

PGError: ERROR: invalid input syntax for integer: ""
LINE 1: UPDATE “hosts” SET owner_id = ‘’
^
: UPDATE “hosts” SET owner_id = ‘’

(See full trace by running task with --trace)

Met vriendelijke groeten,
Pieter Baele
www.pieterb.be

–
You received this message because you are subscribed to the Google Groups
"Foreman users" group.
To post to this group, send email to foreman-users@googlegroups.com.
To unsubscribe from this group, send email to
foreman-users+unsubscribe@googlegroups.comforeman-users%2Bunsubscribe@googlegroups.com
.
For more options, visit this group at
http://groups.google.com/group/foreman-users?hl=en.

3

Works,

after starting only the (obvious) message there is no integrated admin
user

··· On Dec 15, 1:55 pm, Ohad Levy wrote: > can you try the fix inhttp://theforeman.org/issues/465? > > Thanks, > Ohad > > On Wed, Dec 15, 2010 at 2:36 PM, Pieter Baele wrote: > > > I receive the following migration error > > > postgres 8.4 > > puppet 2.6.4 > > > RAILS_ENV=production rake db:migrate > > (in /usr/share/foreman) > > == AddOwnerToHosts: migrating > > ================================================ > > -- add_column(:hosts, :owner_id, :integer) > > -> 0.0010s > > -- add_column(:hosts, :owner_type, :string) > > -> 0.0004s > > -- setting default owner for all hosts > > rake aborted! > > An error has occurred, this and all later migrations canceled: > > > PGError: ERROR: invalid input syntax for integer: "" > > LINE 1: UPDATE "hosts" SET owner_id = '' > > ^ > > : UPDATE "hosts" SET owner_id = '' > > > (See full trace by running task with --trace) > > > Met vriendelijke groeten, > > Pieter Baele > >www.pieterb.be > > > -- > > You received this message because you are subscribed to the Google Groups > > "Foreman users" group. > > To post to this group, send email to foreman-users@googlegroups.com. > > To unsubscribe from this group, send email to > > foreman-users+unsubscribe@googlegroups.com > > . > > For more options, visit this group at > >http://groups.google.com/group/foreman-users?hl=en.