Re: Freeze break request: Add second datanommer server dns
On Wed, Sep 15, 2021 at 10:27 PM Kevin Fenzi wrote: > On Wed, Sep 15, 2021 at 10:15:22PM +0100, Mark O'Brien wrote: > > > > The PR is here https://pagure.io/fedora-infra/ansible/pull-request/795 > > I didn't add it here because I thought (incorrectly?) an FBR wasn't > needed > > as this is all new. > > Yeah, thats not freeze breaking, I just thought it would be handy to see > that info also. :) > > > > Also, is this something worth also doing in staging? > > > > > > > I don't think we need it for staging as it's only a temporary measure for > > the migration. > > Well, then what happens to db-datanommer01.stg long term? it will be the > old install? Don't we need to convert it someday? > Staging was already done on the same server to test the migration scripts. > > kevin > ___ infrastructure mailing list -- infrastructure@lists.fedoraproject.org To unsubscribe send an email to infrastructure-le...@lists.fedoraproject.org Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/infrastructure@lists.fedoraproject.org Do not reply to spam on the list, report it: https://pagure.io/fedora-infrastructure
Re: Freeze break request: Add second datanommer server dns
On Wed, Sep 15, 2021 at 10:15:22PM +0100, Mark O'Brien wrote: > > The PR is here https://pagure.io/fedora-infra/ansible/pull-request/795 > I didn't add it here because I thought (incorrectly?) an FBR wasn't needed > as this is all new. Yeah, thats not freeze breaking, I just thought it would be handy to see that info also. :) > > Also, is this something worth also doing in staging? > > > > I don't think we need it for staging as it's only a temporary measure for > the migration. Well, then what happens to db-datanommer01.stg long term? it will be the old install? Don't we need to convert it someday? kevin signature.asc Description: PGP signature ___ infrastructure mailing list -- infrastructure@lists.fedoraproject.org To unsubscribe send an email to infrastructure-le...@lists.fedoraproject.org Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/infrastructure@lists.fedoraproject.org Do not reply to spam on the list, report it: https://pagure.io/fedora-infrastructure
Re: Freeze break request: Add second datanommer server dns
On Wed, Sep 15, 2021 at 6:55 PM Kevin Fenzi wrote: > On Wed, Sep 15, 2021 at 05:13:16PM +0100, Mark O'Brien wrote: > > Hi All, > > > > I have a dns patch for review. > > > > We would like to add a second datanommer db server > > so that we can migrate the current database to it and > > make some changes such as adding the timescaledb > > plugin to improve performance. This second server would > > allow the migration to happen without affecting the main > > prod server. > > > > The patch is available to view here: > > https://gist.github.com/markobrien1/1b242fb8e27da07253550abf328a5e8e > > > > Please chime in with comments or +1's > > +1 with a few comments... > Thank you > > You could also do a PR with the ansible changes. ;) > > Should be adding to inventory/inventory and > inventory/host_vars/db-datanommer02.iad.fedoraproject.org > and > playbooks/groups/postgresql-server.yml > (unless this deployment isn't using that role/playbook, I don't know if > it is) > The PR is here https://pagure.io/fedora-infra/ansible/pull-request/795 I didn't add it here because I thought (incorrectly?) an FBR wasn't needed as this is all new. > > Also, is this something worth also doing in staging? > I don't think we need it for staging as it's only a temporary measure for the migration. > > kevin > Mark ___ infrastructure mailing list -- infrastructure@lists.fedoraproject.org To unsubscribe send an email to infrastructure-le...@lists.fedoraproject.org Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/infrastructure@lists.fedoraproject.org Do not reply to spam on the list, report it: https://pagure.io/fedora-infrastructure
Re: Freeze Break Request: Blockerbugs Hotfix to Deal With RHBZ Change
On 15/09/21 17:38, Till Maas wrote: > On Mon, Sep 13, 2021 at 12:49:21PM -0600, Tim Flink wrote: > >> +# this is a hotfix hack to work around the sudden config change in >> rhbz where the max >> +# number of bugs returned for a query is 20 >> +# it seems to be working for now but may need more work going >> forward >> +while last_query_len == BUGZILLA_QUERY_LIMIT: >> + >> +new_query = self.get_bz_query(tracker, last_update, >> offset=len(buglist)) >> +new_buglist = self.bz.query(new_query) >> +buglist.extend(new_buglist) >> +last_query_len = len(new_buglist) > FYI: This algorithm has a race condition, see also: > https://github.com/python-bugzilla/python-bugzilla/issues/149#issuecomment-918213094 > > Cheers > Till From the API docs: > If you set the limit equal to zero, then all matching results will be > returned instead I suppose setting limit=0 would be enough. I made some local tests with review-stats code (which is also affected by bz change) and that seems to work. However, review-stats uses a logged-in user for the query, I don't know if that's the case for blockerbugs also. Mattia ___ infrastructure mailing list -- infrastructure@lists.fedoraproject.org To unsubscribe send an email to infrastructure-le...@lists.fedoraproject.org Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/infrastructure@lists.fedoraproject.org Do not reply to spam on the list, report it: https://pagure.io/fedora-infrastructure
Re: Freeze break request: Add second datanommer server dns
On Wed, Sep 15, 2021 at 05:13:16PM +0100, Mark O'Brien wrote: > Hi All, > > I have a dns patch for review. > > We would like to add a second datanommer db server > so that we can migrate the current database to it and > make some changes such as adding the timescaledb > plugin to improve performance. This second server would > allow the migration to happen without affecting the main > prod server. > > The patch is available to view here: > https://gist.github.com/markobrien1/1b242fb8e27da07253550abf328a5e8e > > Please chime in with comments or +1's +1 with a few comments... You could also do a PR with the ansible changes. ;) Should be adding to inventory/inventory and inventory/host_vars/db-datanommer02.iad.fedoraproject.org and playbooks/groups/postgresql-server.yml (unless this deployment isn't using that role/playbook, I don't know if it is) Also, is this something worth also doing in staging? kevin signature.asc Description: PGP signature ___ infrastructure mailing list -- infrastructure@lists.fedoraproject.org To unsubscribe send an email to infrastructure-le...@lists.fedoraproject.org Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/infrastructure@lists.fedoraproject.org Do not reply to spam on the list, report it: https://pagure.io/fedora-infrastructure
Re: Freeze break request: Add second datanommer server dns
On Wed, 15 Sept 2021 at 12:53, Stephen John Smoogen wrote: > > +1 from sysadmin-main smoogen thanks for doing reverse DNS. > > On Wed, 15 Sept 2021 at 12:13, Mark O'Brien wrote: > > > > Hi All, > > > > I have a dns patch for review. > > > > We would like to add a second datanommer db server > > so that we can migrate the current database to it and > > make some changes such as adding the timescaledb > > plugin to improve performance. This second server would > > allow the migration to happen without affecting the main > > prod server. > > > > The patch is available to view here: > > https://gist.github.com/markobrien1/1b242fb8e27da07253550abf328a5e8e > > > > Please chime in with comments or +1's > > > > > > Thanks, > > Mark > > ___ > > infrastructure mailing list -- infrastructure@lists.fedoraproject.org > > To unsubscribe send an email to infrastructure-le...@lists.fedoraproject.org > > Fedora Code of Conduct: > > https://docs.fedoraproject.org/en-US/project/code-of-conduct/ > > List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines > > List Archives: > > https://lists.fedoraproject.org/archives/list/infrastructure@lists.fedoraproject.org > > Do not reply to spam on the list, report it: > > https://pagure.io/fedora-infrastructure > > > > -- > Stephen J Smoogen. > I've seen things you people wouldn't believe. Flame wars in > sci.astro.orion. I have seen SPAM filters overload because of Godwin's > Law. All those moments will be lost in time... like posts on a BBS... > time to shutdown -h now. -- Stephen J Smoogen. I've seen things you people wouldn't believe. Flame wars in sci.astro.orion. I have seen SPAM filters overload because of Godwin's Law. All those moments will be lost in time... like posts on a BBS... time to shutdown -h now. ___ infrastructure mailing list -- infrastructure@lists.fedoraproject.org To unsubscribe send an email to infrastructure-le...@lists.fedoraproject.org Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/infrastructure@lists.fedoraproject.org Do not reply to spam on the list, report it: https://pagure.io/fedora-infrastructure
Re: Freeze break request: Add second datanommer server dns
+1 from sysadmin-main smoogen On Wed, 15 Sept 2021 at 12:13, Mark O'Brien wrote: > > Hi All, > > I have a dns patch for review. > > We would like to add a second datanommer db server > so that we can migrate the current database to it and > make some changes such as adding the timescaledb > plugin to improve performance. This second server would > allow the migration to happen without affecting the main > prod server. > > The patch is available to view here: > https://gist.github.com/markobrien1/1b242fb8e27da07253550abf328a5e8e > > Please chime in with comments or +1's > > > Thanks, > Mark > ___ > infrastructure mailing list -- infrastructure@lists.fedoraproject.org > To unsubscribe send an email to infrastructure-le...@lists.fedoraproject.org > Fedora Code of Conduct: > https://docs.fedoraproject.org/en-US/project/code-of-conduct/ > List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines > List Archives: > https://lists.fedoraproject.org/archives/list/infrastructure@lists.fedoraproject.org > Do not reply to spam on the list, report it: > https://pagure.io/fedora-infrastructure -- Stephen J Smoogen. I've seen things you people wouldn't believe. Flame wars in sci.astro.orion. I have seen SPAM filters overload because of Godwin's Law. All those moments will be lost in time... like posts on a BBS... time to shutdown -h now. ___ infrastructure mailing list -- infrastructure@lists.fedoraproject.org To unsubscribe send an email to infrastructure-le...@lists.fedoraproject.org Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/infrastructure@lists.fedoraproject.org Do not reply to spam on the list, report it: https://pagure.io/fedora-infrastructure
Freeze break request: Add second datanommer server dns
Hi All, I have a dns patch for review. We would like to add a second datanommer db server so that we can migrate the current database to it and make some changes such as adding the timescaledb plugin to improve performance. This second server would allow the migration to happen without affecting the main prod server. The patch is available to view here: https://gist.github.com/markobrien1/1b242fb8e27da07253550abf328a5e8e Please chime in with comments or +1's Thanks, Mark ___ infrastructure mailing list -- infrastructure@lists.fedoraproject.org To unsubscribe send an email to infrastructure-le...@lists.fedoraproject.org Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/infrastructure@lists.fedoraproject.org Do not reply to spam on the list, report it: https://pagure.io/fedora-infrastructure
Re: Freeze Break Request: Blockerbugs Hotfix to Deal With RHBZ Change
On Mon, Sep 13, 2021 at 12:49:21PM -0600, Tim Flink wrote: > +# this is a hotfix hack to work around the sudden config change in > rhbz where the max > +# number of bugs returned for a query is 20 > +# it seems to be working for now but may need more work going forward > +while last_query_len == BUGZILLA_QUERY_LIMIT: > + > +new_query = self.get_bz_query(tracker, last_update, > offset=len(buglist)) > +new_buglist = self.bz.query(new_query) > +buglist.extend(new_buglist) > +last_query_len = len(new_buglist) FYI: This algorithm has a race condition, see also: https://github.com/python-bugzilla/python-bugzilla/issues/149#issuecomment-918213094 Cheers Till ___ infrastructure mailing list -- infrastructure@lists.fedoraproject.org To unsubscribe send an email to infrastructure-le...@lists.fedoraproject.org Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/infrastructure@lists.fedoraproject.org Do not reply to spam on the list, report it: https://pagure.io/fedora-infrastructure
Re: Freeze Break Request: Blockerbugs Hotfix to Deal With RHBZ Change
On Wed, Sep 15, 2021 at 01:12:07PM -, Kamil Páral wrote: > > For now, I've kept the limit to 20 because I was having trouble getting > > more than 20 > > to work for me. > > For anyone interested - we found out that only logged-in users can receive > more than 20 responses per query. For anonymous queries, the max limit is 20. > I had a bugzilla token configured, that's why I had no troubles raising the > limit to 100, while it didn't work for Tim because he didn't have any token. Fun one! Thanks for the info, Pierre ___ infrastructure mailing list -- infrastructure@lists.fedoraproject.org To unsubscribe send an email to infrastructure-le...@lists.fedoraproject.org Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/infrastructure@lists.fedoraproject.org Do not reply to spam on the list, report it: https://pagure.io/fedora-infrastructure
Re: Freeze Break Request: Blockerbugs Hotfix to Deal With RHBZ Change
> For now, I've kept the limit to 20 because I was having trouble getting more > than 20 > to work for me. For anyone interested - we found out that only logged-in users can receive more than 20 responses per query. For anonymous queries, the max limit is 20. I had a bugzilla token configured, that's why I had no troubles raising the limit to 100, while it didn't work for Tim because he didn't have any token. ___ infrastructure mailing list -- infrastructure@lists.fedoraproject.org To unsubscribe send an email to infrastructure-le...@lists.fedoraproject.org Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/infrastructure@lists.fedoraproject.org Do not reply to spam on the list, report it: https://pagure.io/fedora-infrastructure
Re: FBR: Enable CentOS Stream in MirrorManager
On Mon, Sep 06, 2021 at 08:01:40PM +0200, Adrian Reber wrote: > Over the last weeks we prepared adding CentOS Stream to Fedora's > MirrorManager instance and are now at a point where we would like to > push the changes to ansible. > > The current state can be seen at: > > http://mirrors.stg.centos.org/metalink?repo=centos-baseos-9-stream=x86_64 > > (https just broke over the weekend) > > To enable CentOS Stream in MirrorManager not only configuration file > changes are necessary, but it also requires an update of all software > components. This is mainly due to the fact that CentOS Stream is using > an empty topdir. (topdir in MirrorManager are things like 'epel/' or > 'fedora/linux' or 'fedora-secondary/'). > > Unfortunately all code assumed that topdir is not '' and hard-coded the > removal of a slash all over the place. > > All corresponding projects have been update to handle empty topdirs. > > To apply https://pagure.io/fedora-infra/ansible/pull-request/775 for > prod I need this FBR. > > There are risks doing code changes like this during a freeze. So far I > have not seen any problems in staging, but staging is not using using > MirrorManager as thoroughly as prod. I don't expect any major problems > with this change. > > I hope someone from the CentOS team can weigh if this is very time > critical to get running or if we can wait until after the freeze. This is now active and I am able to use it on my CentOS Stream 9 VM with: metalink=https://mirrors.centos.org/metalink?repo=centos-baseos-9-stream=x86_64 metalink=https://mirrors.centos.org/metalink?repo=centos-appstream-9-stream=x86_64 metalink=https://mirrors.centos.org/metalink?repo=centos-crb-9-stream=x86_64 Let me know if something does not work as expected. Adrian ___ infrastructure mailing list -- infrastructure@lists.fedoraproject.org To unsubscribe send an email to infrastructure-le...@lists.fedoraproject.org Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/infrastructure@lists.fedoraproject.org Do not reply to spam on the list, report it: https://pagure.io/fedora-infrastructure