Re: Freeze break request: Add second datanommer server dns

2021-09-15 Thread Mark O'Brien
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

2021-09-15 Thread Kevin Fenzi
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

2021-09-15 Thread Mark O'Brien
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

2021-09-15 Thread Mattia Verga
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

2021-09-15 Thread Kevin Fenzi
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

2021-09-15 Thread Stephen John Smoogen
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

2021-09-15 Thread Stephen John Smoogen
+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

2021-09-15 Thread Mark O'Brien
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

2021-09-15 Thread Till Maas
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

2021-09-15 Thread Pierre-Yves Chibon
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

2021-09-15 Thread Kamil Páral
> 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

2021-09-15 Thread Adrian Reber
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