Page MenuHomePhabricator
Create Task
Maniphest T336174

Release a new version of wmfmariadbpy
Closed, ResolvedPublic
Actions

Description

Once db1215 is the active master (T335014) we need to release a new version of this package with this change: https://gerrit.wikimedia.org/r/c/operations/software/wmfmariadbpy/+/917320

Details

Related Changes in Gerrit:
SubjectRepoBranchLines +/-
Prepare for the new release of 0.10operations/software/wmfmariadbpymaster+8 -1
Customize query in gerrit

Related Objects
Search...

Event Timeline

• Marostegui created this task.May 8 2023, 2:19 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMay 8 2023, 2:19 PM
• Marostegui triaged this task as Medium priority.May 8 2023, 2:19 PM
• Marostegui moved this task from Triage to Blocked on the DBA board.
• Marostegui raised the priority of this task from Medium to High.May 9 2023, 6:07 AM
• Marostegui moved this task from Blocked to Ready on the DBA board.

@Ladsgroup please proceed

Ladsgroup added a comment.May 9 2023, 9:46 AM

I can do the release but I haven't packaged anything for production before. That's going to be fun.

gerritbot added a comment.May 11 2023, 2:26 PM

Change 919079 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):

[operations/software/wmfmariadbpy@master] Prepare for the new release of 0.10

https://gerrit.wikimedia.org/r/919079

gerritbot added a project: Patch-For-Review.May 11 2023, 2:26 PM
Ladsgroup moved this task from Ready to In progress on the DBA board.May 11 2023, 2:27 PM
gerritbot added a comment.May 11 2023, 4:47 PM

Change 919079 merged by jenkins-bot:

[operations/software/wmfmariadbpy@master] Prepare for the new release of 0.10

https://gerrit.wikimedia.org/r/919079

Ladsgroup mentioned this in rOSMDbf04082a3cad: Prepare for the new release of 0.10.May 11 2023, 4:48 PM
Maintenance_bot removed a project: Patch-For-Review.May 11 2023, 5:12 PM
Ladsgroup added a comment.May 15 2023, 10:51 AM
ladsgroup@build2001:~/wmfmariadbpy$  ls  -la /var/cache/pbuilder/result/bullseye-amd64/*mariadbpy*
-rw-r--r-- 1 ladsgroup wikidev 15272 May 15 10:49 /var/cache/pbuilder/result/bullseye-amd64/python3-wmfmariadbpy_0.10_amd64.deb
-rw-r--r-- 1 ladsgroup wikidev  4840 May 15 10:49 /var/cache/pbuilder/result/bullseye-amd64/python3-wmfmariadbpy-remote_0.10_amd64.deb
-rw-r--r-- 1 ladsgroup wikidev  6993 May 15 10:49 /var/cache/pbuilder/result/bullseye-amd64/wmfmariadbpy_0.10_amd64.buildinfo
-rw-r--r-- 1 ladsgroup wikidev  2760 May 15 10:49 /var/cache/pbuilder/result/bullseye-amd64/wmfmariadbpy_0.10_amd64.changes
-rw-r--r-- 1 ladsgroup wikidev   881 May 15 10:49 /var/cache/pbuilder/result/bullseye-amd64/wmfmariadbpy_0.10.dsc
-rw-r--r-- 1 ladsgroup wikidev  1204 May 15 10:49 /var/cache/pbuilder/result/bullseye-amd64/wmfmariadbpy_0.10_source.changes
-rw-r--r-- 1 ladsgroup wikidev 40500 May 15 10:49 /var/cache/pbuilder/result/bullseye-amd64/wmfmariadbpy_0.10.tar.xz
-rw-r--r-- 1 ladsgroup wikidev 15352 May 15 10:49 /var/cache/pbuilder/result/bullseye-amd64/wmfmariadbpy-admin_0.10_amd64.deb
-rw-r--r-- 1 ladsgroup wikidev  7344 May 15 10:49 /var/cache/pbuilder/result/bullseye-amd64/wmfmariadbpy-common_0.10_amd64.deb
• Marostegui mentioned this in T334455: Failover all db1115 services to db1215.May 16 2023, 7:02 AM
Ladsgroup added a comment.May 16 2023, 9:41 AM

I hope I did it right:

root@apt1001:/home/ladsgroup/wmfmariadbpy# reprepro -C main include bullseye-wikimedia wmfmariadbpy_0.10_amd64.changes
Exporting indices...
Deleting files no longer referenced...
Ladsgroup added a comment.May 17 2023, 3:53 PM

Built the deploy manifest. Gonna push it now:

comment: T336174
fixes:
  bullseye: '0.10'
  buster: ''
  stretch: ''
libraries: []
source: wmfmariadbpy
transitions: {}
update_type: tool
Ladsgroup closed this task as Resolved.May 17 2023, 4:02 PM
Ladsgroup moved this task from In progress to Done on the DBA board.
ladsgroup@cumin1001:~$ sudo debdeploy deploy -u 2023-05-17-wmfmariadbpy.yaml -s bullseye
Rolling out wmfmariadbpy:
Non-daemon update, no service restart needed

python3-wmfmariadbpy-remote was updated: 0.9+deb11u1 -> 0.10
  cumin1001.eqiad.wmnet (1 hosts)

wmfmariadbpy-admin was updated: 0.9+deb11u1 -> 0.10
  cumin1001.eqiad.wmnet (1 hosts)

python3-wmfmariadbpy was updated: 0.9+deb11u1 -> 0.10
  cumin1001.eqiad.wmnet (1 hosts)

These hosts are already up-to-date:
  cumin2002.codfw.wmnet (1 hosts)

python3-wmfmariadbpy-remote was updated: 0.9+deb11u1 -> 0.10
  cloudcumin2001.codfw.wmnet,cloudcumin1001.eqiad.wmnet (2 hosts)

python3-wmfmariadbpy was updated: 0.9+deb11u1 -> 0.10
  backup2002.codfw.wmnet,backup1002.eqiad.wmnet,backupmon1001.eqiad.wm
net,dbprov[2001-2004].codfw.wmnet,dbprov[1001-1004].eqiad.wmnet (11
hosts)

wmfmariadbpy-common was updated: 0.9+deb11u1 -> 0.10
  clouddb[1014-1016,1019-1021].eqiad.wmnet,cloudservices1004.wikimedia
.org,db[2096-2101,2104-2105,2107-2108,2110,2113-2115,2117-2118,2122-21
23,2127,2131,2133,2136-2137,2140-2143,2145-2149,2151-2153,2155,2158,21
63-2167,2170-2172,2174-2176,2178-2180,2182-2183,2185-2187].codfw.wmnet
,db[1106,1119,1122,1124-1126,1129-1134,1136,1139,1141-1142,1148,1150-1
151,1154,1156,1160-1162,1171-1173,1177-1180,1183-1185,1192,1196,1198-1
200,1202,1206,1210-1211,1215,1217-1220,1222-1225].eqiad.wmnet,dbstore[
1003,1005,1007].eqiad.wmnet,es[2022,2026,2028-2030].codfw.wmnet,es[102
1,1025-1026,1030-1032,1034].eqiad.wmnet,pc2013.codfw.wmnet,pc[1011,101
3-1014].eqiad.wmnet (134 hosts)

python3-wmfmariadbpy was updated: 0.9+deb11u1 -> 0.10
  clouddb[1014-1016,1019-1021].eqiad.wmnet,cloudservices1004.wikimedia
.org,db[2096-2101,2104-2105,2107-2108,2110,2113-2115,2117-2118,2122-21
23,2127,2131,2133,2136-2137,2140-2143,2145-2149,2151-2153,2155,2158,21
63-2167,2170-2172,2174-2176,2178-2180,2182-2183,2185-2187].codfw.wmnet
,db[1106,1119,1122,1124-1126,1129-1134,1136,1139,1141-1142,1148,1150-1
151,1154,1156,1160-1162,1171-1173,1177-1180,1183-1185,1192,1196,1198-1
200,1202,1206,1210-1211,1215,1217-1220,1222-1225].eqiad.wmnet,dbstore[
1003,1005,1007].eqiad.wmnet,es[2022,2026,2028-2030].codfw.wmnet,es[102
1,1025-1026,1030-1032,1034].eqiad.wmnet,pc2013.codfw.wmnet,pc[1011,101
3-1014].eqiad.wmnet (134 hosts)

python3-wmfmariadbpy was updated: 0.9+deb11u1 -> 0.10
  clouddb[1013,1017-1018].eqiad.wmnet,cloudservices[2004-2005]-dev.wik
imedia.org,cloudservices1005.wikimedia.org,db[2102-2103,2106,2109,2111
-2112,2116,2119-2121,2124-2126,2128-2130,2132,2134-2135,2138-2139,2144
,2150,2154,2156-2157,2159-2162,2168-2169,2173,2177,2181,2184].codfw.wm
net,db[1112,1118,1121,1127-1128,1135,1137-1138,1140,1143-1147,1149,115
2-1153,1155,1157-1159,1163-1170,1174-1176,1181-1182,1186-1191,1193-119
5,1197,1201,1203-1205,1207,1209,1212-1214,1216,1221].eqiad.wmnet,es[20
20-2021,2023-2025,2027,2031-2034].codfw.wmnet,es[1020,1022-1024,1027-1
029,1033].eqiad.wmnet,pc[2011-2012,2014].codfw.wmnet,pc1012.eqiad.wmne
t (119 hosts)

wmfmariadbpy-common was updated: 0.9+deb11u1 -> 0.10
  clouddb[1013,1017-1018].eqiad.wmnet,cloudservices[2004-2005]-dev.wik
imedia.org,cloudservices1005.wikimedia.org,db[2102-2103,2106,2109,2111
-2112,2116,2119-2121,2124-2126,2128-2130,2132,2134-2135,2138-2139,2144
,2150,2154,2156-2157,2159-2162,2168-2169,2173,2177,2181,2184].codfw.wm
net,db[1112,1118,1121,1127-1128,1135,1137-1138,1140,1143-1147,1149,115
2-1153,1155,1157-1159,1163-1170,1174-1176,1181-1182,1186-1191,1193-119
5,1197,1201,1203-1205,1207,1209,1212-1214,1216,1221].eqiad.wmnet,es[20
20-2021,2023-2025,2027,2031-2034].codfw.wmnet,es[1020,1022-1024,1027-1
029,1033].eqiad.wmnet,pc[2011-2012,2014].codfw.wmnet,pc1012.eqiad.wmne
t (119 hosts)

Could not decode JSON response for
cloudswift1001.eqiad.wmnet
Expecting value: line 1 column 1 (char 0)
The package to be updated isn't installed on these hosts:
  acmechief2001.codfw.wmnet,acmechief1001.eqiad.wmnet,acmechief-
test2001.codfw.wmnet,acmechief-test1001.eqiad.wmnet,an-
conf[1001-1003].eqiad.wmnet,an-coord[1003-1004].eqiad.wmnet,an-
db[1001-1002].eqiad.wmnet,an-mariadb[1001-1002].eqiad.wmnet,an-
presto[1001-1015].eqiad.wmnet,an-test-client1002.eqiad.wmnet,an-test-
druid1001.eqiad.wmnet,an-test-presto1001.eqiad.wmnet,an-test-
worker1001.eqiad.wmnet,an-tool[1005,1007,1010-1011].eqiad.wmnet,aphlic
t2001.codfw.wmnet,aphlict1002.eqiad.wmnet,arclamp2001.codfw.wmnet,arcl
amp1001.eqiad.wmnet,aux-k8s-ctrl[1001-1002].eqiad.wmnet,aux-k8s-etcd[1
001-1003].eqiad.wmnet,aux-k8s-worker[1001-1002].eqiad.wmnet,backup[200
1,2003-2011].codfw.wmnet,backup[1001,1003-1009].eqiad.wmnet,bast[1003,
2002,3006,4004,5003,6002].wikimedia.org,build2001.codfw.wmnet,centrall
og2002.codfw.wmnet,centrallog1002.eqiad.wmnet,cephosd[1001-1005].eqiad
.wmnet,cloudbackup[1001-1002]-dev.eqiad.wmnet,cloudbackup[2001-2002].c
odfw.wmnet,cloudcephosd[1001-1005,1010,1021,1025-1034].eqiad.wmnet,clo
udcontrol2001-dev.codfw.wmnet,cloudcontrol[2004-2005]-dev.wikimedia.or
g,cloudcontrol[1005-1007].wikimedia.org,clouddb2002-dev.codfw.wmnet,cl
ouddumps[1001-1002].wikimedia.org,cloudelastic[1001-1006].wikimedia.or
g,cloudgw[2002-2003]-dev.codfw.wmnet,cloudgw[1001-1002].eqiad.wmnet,cl
oudlb[2001-2003]-dev.codfw.wmnet,cloudnet[2005-2006]-dev.codfw.wmnet,c
loudnet[1005-1006].eqiad.wmnet,cloudrabbit[1001-1003].wikimedia.org,cl
oudvirt[2001-2003]-dev.codfw.wmnet,cloudvirt[1025-1061].eqiad.wmnet,cl
oudvirt-wdqs[1001-1003].eqiad.wmnet,cloudvirtlocal[1001-1003].eqiad.wm
net,conf[1007-1009].eqiad.wmnet,cp[2027-2042].codfw.wmnet,cp[6001-6016
].drmrs.wmnet,cp[1075-1090].eqiad.wmnet,cp[5017-5032].eqsin.wmnet,cp[3
050-3065].esams.wmnet,cp[4037-4052].ulsfo.wmnet,cuminunpriv1001.eqiad.
wmnet,datahubsearch[1001-1003].eqiad.wmnet,db1208.eqiad.wmnet,dborch10
01.wikimedia.org,dbproxy[2001-2004].codfw.wmnet,dbproxy[1012-1021].eqi
ad.wmnet,dns[1001-1003,2004-2006,3001-3002,4003-4004,5003-5004,6001-60
02].wikimedia.org,doc2002.codfw.wmnet,doc1003.eqiad.wmnet,doh[1001-100
2,2001-2002,3001-3002,4001-4002,5001-5002,6001-6002].wikimedia.org,dru
id[1009-1011].eqiad.wmnet,dse-k8s-ctrl[1001-1002].eqiad.wmnet,dse-k8s-
etcd[1001-1003].eqiad.wmnet,dse-k8s-worker[1001-1008].eqiad.wmnet,dump
sdata[1006-1007].eqiad.wmnet,durum[2001-2002].codfw.wmnet,durum[6001-6
002].drmrs.wmnet,durum[1001-1002].eqiad.wmnet,durum[5001-5002].eqsin.w
mnet,durum[3001-3002].esams.wmnet,durum[4001-4002].ulsfo.wmnet,elastic
[2037-2048,2050-2086].codfw.wmnet,elastic[1053-1102].eqiad.wmnet,ether
pad1003.eqiad.wmnet,failoid2002.codfw.wmnet,failoid1002.eqiad.wmnet,ga
neti[2009-2022,2024-2032].codfw.wmnet,ganeti[6001-6004].drmrs.wmnet,ga
neti[1009-1034].eqiad.wmnet,ganeti[5004-5007].eqsin.wmnet,ganeti[3001-
3003].esams.wmnet,ganeti[4005-4008].ulsfo.wmnet,ganeti-test[2001-2003]
.codfw.wmnet,gerrit1003.wikimedia.org,gitlab[1003-1004,2002-2003].wiki
media.org,gitlab-runner[2002-2004].codfw.wmnet,gitlab-runner[1002-1004
].eqiad.wmnet,graphite2004.codfw.wmnet,graphite1005.eqiad.wmnet,htmldu
mper1001.eqiad.wmnet,idm[1001,2001].wikimedia.org,idm-
test1001.wikimedia.org,idp[1002,2002].wikimedia.org,idp-test[1002,2002
].wikimedia.org,install[1004,2004,3002,4002,5002,6002].wikimedia.org,i
rc[1002,2002].wikimedia.org,kafka-jumbo[1010-1015].eqiad.wmnet,kafka-
logging[2001-2005].codfw.wmnet,kafka-
logging[1001-1005].eqiad.wmnet,kafka-
main[2001-2005].codfw.wmnet,kafka-main[1001-1005].eqiad.wmnet,kafka-
stretch[2001-2002].codfw.wmnet,kafka-
stretch[1001-1002].eqiad.wmnet,kafka-test[1006-1010].eqiad.wmnet,kafka
mon2003.codfw.wmnet,kafkamon1003.eqiad.wmnet,karapace1001.eqiad.wmnet,
krb2002.codfw.wmnet,krb1001.eqiad.wmnet,kubemaster[2001-2002].codfw.wm
net,kubemaster[1001-1002].eqiad.wmnet,kubernetes[2005-2024].codfw.wmne
t,kubernetes[1005-1024].eqiad.wmnet,kubestage[2001-2002].codfw.wmnet,k
ubestage[1003-1004].eqiad.wmnet,kubestagemaster2001.codfw.wmnet,kubest
agemaster1001.eqiad.wmnet,kubestagetcd[2001-2003].codfw.wmnet,kubestag
etcd[1004-1006].eqiad.wmnet,kubetcd[2004-2006].codfw.wmnet,kubetcd[100
4-1006].eqiad.wmnet,ldap-
replica[1003-1004,2005-2006].wikimedia.org,ldap-rw[1001,2001].wikimedi
a.org,logstash[2001-2003,2023-2037].codfw.wmnet,logstash[1010-1012,102
3-1037].eqiad.wmnet,lvs[2009-2012].codfw.wmnet,lvs[6001-6003].drmrs.wm
net,lvs[1013-1020].eqiad.wmnet,lvs[5004-5006].eqsin.wmnet,lvs[3005-300
7].esams.wmnet,lvs[4008-4010].ulsfo.wmnet,mc[2038-2055].codfw.wmnet,mc
[1037-1054].eqiad.wmnet,mc-gp[2001-2003].codfw.wmnet,mc-
gp[1001-1003].eqiad.wmnet,mc-wf[2001-2002].codfw.wmnet,mc-wf[1001-1002
].eqiad.wmnet,mirror1001.wikimedia.org,miscweb2003.codfw.wmnet,miscweb
1003.eqiad.wmnet,ml-cache[2001-2003].codfw.wmnet,ml-
cache[1001-1003].eqiad.wmnet,ml-etcd[2001-2003].codfw.wmnet,ml-
etcd[1001-1003].eqiad.wmnet,ml-serve[2001-2008].codfw.wmnet,ml-
serve[1001-1008].eqiad.wmnet,ml-serve-ctrl[2001-2002].codfw.wmnet,ml-
serve-ctrl[1001-1002].eqiad.wmnet,ml-
staging[2001-2002].codfw.wmnet,ml-staging-
ctrl[2001-2002].codfw.wmnet,ml-staging-
etcd[2001-2003].codfw.wmnet,moscovium.eqiad.wmnet,moss-
fe2001.codfw.wmnet,moss-fe1001.eqiad.wmnet,ms-
backup[2001-2002].codfw.wmnet,ms-backup[1001-1002].eqiad.wmnet,ms-
be[2040-2073].codfw.wmnet,ms-be[1040-1075].eqiad.wmnet,ms-
fe[2010-2014].codfw.wmnet,ms-fe[1010-1014].eqiad.wmnet,mx[1001,2001].w
ikimedia.org,ncredir[2001-2002].codfw.wmnet,ncredir[6001-6002].drmrs.w
mnet,ncredir[1001-1002].eqiad.wmnet,ncredir[5001-5002].eqsin.wmnet,ncr
edir[3001-3002].esams.wmnet,ncredir[4001-4002].ulsfo.wmnet,netbox2002.
codfw.wmnet,netbox1002.eqiad.wmnet,netbox-dev2002.codfw.wmnet,netboxdb
2002.codfw.wmnet,netboxdb1002.eqiad.wmnet,netflow2002.codfw.wmnet,netf
low6001.drmrs.wmnet,netflow1002.eqiad.wmnet,netflow5002.eqsin.wmnet,ne
tflow3002.esams.wmnet,netflow4002.ulsfo.wmnet,netmon[1003,2002].wikime
dia.org,people2002.codfw.wmnet,people1003.eqiad.wmnet,ping2003.codfw.w
mnet,ping1003.eqiad.wmnet,ping3003.esams.wmnet,pki2002.codfw.wmnet,pki
1001.eqiad.wmnet,pki-root1001.eqiad.wmnet,prometheus[2005-2006].codfw.
wmnet,prometheus6002.drmrs.wmnet,prometheus[1005-1006].eqiad.wmnet,pro
metheus5002.eqsin.wmnet,prometheus3002.esams.wmnet,prometheus4002.ulsf
o.wmnet,puppetboard2002.codfw.wmnet,puppetboard1002.eqiad.wmnet,pybal-
test2003.codfw.wmnet,rdb[2007-2010].codfw.wmnet,rdb[1009-1012].eqiad.w
mnet,relforge[1003-1004].eqiad.wmnet,rpki2002.codfw.wmnet,rpki1001.eqi
ad.wmnet,sretest2002.codfw.wmnet,sretest1001.eqiad.wmnet,stat[1009-101
0].eqiad.wmnet,thanos-be[2001-2004].codfw.wmnet,thanos-
be[1001-1004].eqiad.wmnet,thanos-fe[2001-2004].codfw.wmnet,thanos-fe[1
001-1004].eqiad.wmnet,urldownloader[1003-1004,2003-2004].wikimedia.org
,vrts2001.codfw.wmnet,vrts1001.eqiad.wmnet,wdqs[2013-2020,2022].codfw.
wmnet,webperf2003.codfw.wmnet,webperf1003.eqiad.wmnet (988 hosts)


The following hosts were unreachable:
cloudswift1001.eqiad.wmnet

Holy jeez that was scary.

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits