[foreman-users] 2.4-3.0 upgrade stuck

2016-07-07 Thread sinux shen
Hey guys, when I upgrade katello from 2.4 to 3.0, I found it stuck at "update_puppet_repository_distributors (this may take a while)" Upgrade Step: import_puppet_modules (this may take a while) ... Upgrade Step: import_subscriptions (this may take a while) ... Upgrade Step:

[foreman-users] can not download the RHEL repos

2017-02-09 Thread sinux shen
Hey there, I have exported and uploaded the RHEL subscriptions to foreman and make it as an 3rd party SAM, now I can see all the RHEL products, I have done this before by using our previous RHEL subscriptions and can download RHEL 6server repos successfully, after our subscription expire, (I

[foreman-users] Re: can not download the RHEL repos

2017-02-09 Thread sinux shen
Ms x86_64 6Server", I can sync all the contents though. On Friday, February 10, 2017 at 11:26:28 AM UTC+8, sinux shen wrote: > > Hey there, > > I have exported and uploaded the RHEL subscriptions to foreman and make it > as an 3rd party SAM, now I can see all the RHEL prod

[foreman-users] search host very slow in foreman

2016-09-13 Thread sinux shen
Hey guys, I have been suffered for this for quite a while, we are using katello 3.0 with foreman 1.11.3, we have around 400+ hosts added in the system, but every time when I search a specific host in the search bar, it response me very very slow, still work though, just took me like 30 secs or

Re: [foreman-users] search host very slow in foreman

2016-09-21 Thread sinux shen
help. On Wednesday, September 21, 2016 at 9:47:02 PM UTC+8, Chris Duryee wrote: > > > > On 09/21/2016 09:24 AM, sinux shen wrote: > > Hi, Lukas & Ohad, > > > > Thanks for the help, we do turned the slow log on and we found the heavy > > SQ

Re: [foreman-users] search host very slow in foreman

2016-09-19 Thread sinux shen
_id" AND "environments"."id" IN (2, 3, 4, 8, 5) \ LEFT OUTER JOIN "architectures" ON "architectures"."id" = "hosts"."architecture_id" \ LEFT OUTER JOIN "compute_resources" ON "compute_resources"."id&qu

Re: [foreman-users] search host very slow in foreman

2016-09-21 Thread sinux shen
.host_id = hosts.id)) -> Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=0 loops=13776)One-Time Filter: false -> Index Scan using index_host_status_on_host_id on host_status (cost=0.00..0.34 rows=4 width=50) (actual time=0.001..0.002 rows=4 loops=13776) Index

Re: [foreman-users] search host very slow in foreman

2016-09-19 Thread sinux shen
I just simply search a specific hostname in the search bar, for example “foo”, and then have to wait for a long time, normally 20~30 secs, I will try to turn the slow query on and see what happened. Thanks -Sinux > On Sep 14, 2016, at 3:59 PM, Lukas Zapletal wrote: > >> what