quarry to python 3.7
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	rook
	Aug 10 2021, 2:58 PM

Description

upgrade quarry to python 3.7 along with any libs that can be upgraded along the way

Details

Subject	Repo	Branch	Lines +/-
update celery worker to allow for celery v5	operations/puppet	production	+33 -1
upgrade quarry to python 3.7	analytics/quarry/web	buster-2	+40 -398
upgrade quarry to python 3.7	analytics/quarry/web	buster	+40 -398
upgrade quarry to python 3.7	analytics/quarry/web	master	+34 -394

Customize query in gerrit

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Open		None	T288982 Productionize quarry a bit
		Resolved		rook	T288528 quarry to python 3.7

Event Timeline

rook created this task.Aug 10 2021, 2:58 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptAug 10 2021, 2:58 PM

Change 711150 had a related patch set uploaded (by Michael DiPietro; author: Michael DiPietro):

[analytics/quarry/web@master] upgrade quarry to python 3.7

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

gerritbot added a project: Patch-For-Review.Aug 10 2021, 3:07 PM

Change 711208 had a related patch set uploaded (by Michael DiPietro; author: Michael DiPietro):

[analytics/quarry/web@buster] upgrade quarry to python 3.7

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

Change 711150 abandoned by Michael DiPietro:

[analytics/quarry/web@master] upgrade quarry to python 3.7

Reason:

moving to another branch, https://gerrit.wikimedia.org/r/c/analytics/quarry/web/+/711208/

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

• Bstorm merged a task: T288249: update python for quarry.Aug 16 2021, 5:16 PM

• Bstorm added a parent task: T288982: Productionize quarry a bit.Aug 16 2021, 6:30 PM

Change 711208 merged by jenkins-bot:

[analytics/quarry/web@buster] upgrade quarry to python 3.7

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

Maintenance_bot removed a project: Patch-For-Review.Aug 16 2021, 9:10 PM

• nskaggs moved this task from Backlog to FY2021/2022-Q1 on the Quarry board.Aug 23 2021, 3:48 PM

• nskaggs edited projects, added Quarry (FY2021/2022-Q1); removed Quarry.

Change 714609 had a related patch set uploaded (by Michael DiPietro; author: Michael DiPietro):

[analytics/quarry/web@buster-2] upgrade quarry to python 3.7

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

gerritbot added a project: Patch-For-Review.Aug 24 2021, 5:06 PM

Change 714609 abandoned by Michael DiPietro:

[analytics/quarry/web@buster-2] upgrade quarry to python 3.7

Reason:

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

Maintenance_bot removed a project: Patch-For-Review.Aug 24 2021, 7:10 PM

Now the buster instances are using the travis DB, we will need to update the database to the latest right before moving to the new hosts:

root@quarry-db-01:~# mysqldump quarry | mysql -h vuylalotiaz.svc.trove.eqiad1.wikimedia.cloud -p quarry -u quarry

root@quarry-db-01:~# mysql -h  vuylalotiaz.svc.trove.eqiad1.wikimedia.cloud -p quarry -u quarry
MariaDB [quarry]> alter table query_revision drop column dbs;

Mentioned in SAL (#wikimedia-cloud) [2021-09-01T13:07:39Z] <mdipietro> Updated to Debian Buster/python 3.7 T288528