Ghost smart proxy

Support
1

I created a smart proxy, dhcp.foo. I then rebuilt that host, changing the
domain, making it dhcp.bar.
Now, I've got my new smart proxy, dhcp.bar, AND my old dhcp.foo showing.
When I try to delete dhcp.foo, I get this error:
ERROR: column hosts.content_source_id does not exist LINE 1: …ts" WHERE
"hosts"."type" IN ('Host::Managed') AND "hosts"."c… ^

Any idea how I can force the removal of this ghost proxy?

2

We have the same problem. Did you find any fixes for this?

joi, 2 martie 2017, 14:51:25 UTC+2, Dru Roland a scris:

··· > > I created a smart proxy, dhcp.foo. I then rebuilt that host, changing the > domain, making it dhcp.bar. > Now, I've got my new smart proxy, dhcp.bar, AND my old dhcp.foo showing. > When I try to delete dhcp.foo, I get this error: > ERROR: column hosts.content_source_id does not exist LINE 1: ...ts" WHERE > "hosts"."type" IN ('Host::Managed') AND "hosts"."c... ^ > > Any idea how I can force the removal of this ghost proxy? >
3

I believe this is the same issue I reported
here? Bug #19010: Unable to delete smart-proxies - Katello - Foreman

··· On Thursday, March 2, 2017 at 7:51:25 AM UTC-5, Dru Roland wrote: > > I created a smart proxy, dhcp.foo. I then rebuilt that host, changing the > domain, making it dhcp.bar. > Now, I've got my new smart proxy, dhcp.bar, AND my old dhcp.foo showing. > When I try to delete dhcp.foo, I get this error: > ERROR: column hosts.content_source_id does not exist LINE 1: ...ts" WHERE > "hosts"."type" IN ('Host::Managed') AND "hosts"."c... ^ > > Any idea how I can force the removal of this ghost proxy? >