Mathieu Pillard

### Description We have the following tasks registered through the `adhoc` queue: - `olympia.translations.tasks.update_outgoing_url` - `olympia.versions.tasks.delete_list_theme_previews` - `olympia.versions.tasks.hard_delete_versions` - `olympia.activity.tasks.create_ratinglog` - `olympia.files.tasks.extract_host_permissions` - `olympia.lib.crypto.tasks.bump_and_resign_addons` They also have some associated commands...

[Task]: Add mechanism allowing Operations to mass-disable all langpacks for a particular version

2

### Description As an admin, I want to be able to yank a specific langpack release, for all languages. This should prompt for a version string, find all langpacks versions...

### Description https://github.com/mozilla/addons/issues/14820 removed obsolete labels on **mozilla/addons** repos, we agreed to simplify some of the remaining ones by renaming them according [to the spreadsheet](https://docs.google.com/spreadsheets/d/18TLUQEWtUMB8N3uXlK4uPsfrXurgG0yolezC8ngCdy4/edit#gid=496567224). ### Acceptance Criteria ```[tasklist] ###...

Squash some old migrations

4

We have a bunch of migrations that were played in all envs a long time ago. We should look into [squashing them](https://docs.djangoproject.com/en/4.1/topics/migrations/#migration-squashing) to reduce time spent setting up the database...

[Task]: Make it possible to add or edit soft-blocks in the admin

3

### Description Depends on https://github.com/mozilla/addons/issues/15012 Make it possible to add and edit whether a version is soft or hard-blocked in the admin, with logging about the change. This is unlikely...

[Bug]: Some values of the `color` parameter in search API trigger a 500

4

### What happened? When using the `color` parameter in the add-ons search API, we don't handle the following cases well: - Empty `color` parameter https://addons-dev.allizom.org/api/v5/addons/search/?type=statictheme&color= - Some invalid `color` parameter...

### Description As discovered while working on https://github.com/mozilla/addons/issues/15024 the version list view in devhub makes too many queries: several are duplicated, some scale with the number of versions (which needs...

[Bug]: Intermittent CI failures related to docker mount points

3

### What happened? CI intermittently fails with ``` > [pip_development 1/1] RUN --mount=type=bind,source=./requirements/prod.txt,target=/data/olympia/requirements/prod.txt --mount=type=bind,source=./requirements/dev.txt,target=/data/olympia/requirements/dev.txt --mount=type=bind,source=package.json,target=/data/olympia/package.json --mount=type=bind,source=package-lock.json,target=/data/olympia/package-lock.json --mount=type=cache,target=/deps/cache/,uid=9500,gid=9500 --mount=type=cache,target=/deps/cache/npm,uid=9500,gid=9500 > RUN \ 116 | >>> # Files required to install pip...

[Task]: Raise an exception when trying to save an ActivityLog without a user

1

### Description Since the [beginning of time](4bb9602b67d) addons-server has had the [following code](https://github.com/mozilla/addons-server/blob/686ad55a2d8429d16ce9bafe77afd9a5cc26b41e/src/olympia/activity/models.py#L340-L342) when creating an activity log: ```python user = kw.get('user', core.get_user()) if not user: log.warning('Activity log called with...

[Task]: Upgrade to Elasticsearch 8.x locally

1

### Description We need to update to Elasticsearch 8.x as 7.x is going to be EOL this year. Client libraries should be updated first, then we'll need to see if...