The following table lists the database versions with brief descriptions of each.
The "TC Version" column gives the Taskcluster version in which this database version was introduced. The compatibility invariant dictates that the DB version is compatible with all code from the previous major version through this one. For example, if DB version 0123 was introduced in Taskcluster version v59.7.1, then it is compatible with all Taskcluster versions v58.0.0 through v59.7.1. If this invariant is violated, it must be indicated clearly in the changelog.
| DB Version | TC Version | Description |
|---|---|---|
| 0001 | v28.0.0 | fake wigets table for DB deployment testing |
| 0002 | v28.1.0 | define all taskcluster-lib-entities tables and functions |
| 0003 | v28.1.0 | define all taskcluster-lib-azqueue tables and functions |
| 0004 | v28.1.0 | fix typestamps in azure_queue_messages |
| 0005 | v28.2.0 | fix ordering of results returned from azure_queue_get |
| 0006 | v28.2.0 | update azure_queue_count to count only non-expired rows |
| 0007 | v28.2.0 | bugfix for .._scan taskcluster-lib-entities methods |
| 0008 | v29.3.0 | introduce encode/decode_composite_key, encode/decode_string_key, and entity_buf_encode/decode |
| 0009 | v29.3.0 | purge-cache phase 2 |
| 0010 | v29.4.0 | worker-manager worker pools phase 2 |
| 0011 | v30.0.0 | drop widgets table from version 1 |
| 0012 | v30.1.0 | worker-manager workers phase 2 |
| 0013 | v31.0.0 | add capacity to worker pools |
| 0014 | v31.0.0 | add secret to workers |
| 0015 | v32.0.0 | add sha512 function |
| 0016 | v32.0.0 | add uuid_to_slugid and slugid_to_uuid functions |
| 0017 | v32.0.0 | notify phase 2 step 1+2 |
| 0018 | v33.0.0 | index phase 2 step 1 |
| 0019 | v34.0.0 | queue artifacts phase 2 step 1 (slow migration: about 20μs per row in table queue_artifacts_entities) |
| 0020 | v34.0.0 | queue tasks phase 2 step 1 (slow migration: 700-2000μs per row in table queue_tasks_entities) |
| 0021 | v34.0.0 | queue task groups phase 2 step 1 |
| 0022 | v34.0.0 | queue task dependencies phase 2 step 1 (slow migration: 10μs per row in table queue_task_dependency_entities) |
| 0023 | v35.0.0 | github builds phase 2 |
| 0024 | v35.0.0 | queue artifacts phase 2 step 2 |
| 0025 | v35.0.0 | auth roles phase 2 |
| 0026 | v35.0.0 | index phase 2 step 2 |
| 0027 | v35.0.0 | web-server github access tokens phase 2 step 1+2 |
| 0028 | v35.0.0 | queue tasks, task groups, dependencies phase 2 step 2 |
| 0029 | v35.0.0 | worker-manager worker pools phase 2 |
| 0030 | v35.0.0 | bugfix for sha512() |
| 0031 | v35.0.0 | bugfix for get_worker_pool_errors_for_worker_pool |
| 0032 | v36.0.0 | hooks last-fire phase 2 |
| 0033 | v36.0.0 | hooks queues phase 2 |
| 0034 | v36.0.0 | add crypto container functions entity_to_crypto_container_v0 and encrypted_entity_buf_encode |
| 0035 | v36.0.0 | hooks hooks phase 2 |
| 0036 | v36.0.0 | github integrations phase 2 |
| 0037 | v36.0.0 | github checks phase 2 |
| 0038 | v36.0.0 | web-server sessions phase 2 |
| 0039 | v36.0.0 | web-server authorization codes phase 2 |
| 0040 | v36.0.0 | web-server access tokens phase 2 |
| 0041 | v36.0.0 | auth clients phase 2 |
| 0042 | v36.0.0 | secrets phase 2 |
| 0043 | v36.0.0 | queue workers phase 2 |
| 0044 | v36.0.0 | queue worker types phase 2 |
| 0045 | v36.0.0 | queue provisioners phase 2 |
| 0046 | v37.0.0 | fix get_dependent_tasks to return tasks in order |
| 0047 | v37.2.0 | add get_non_stopped_workers db function |
| 0048 | v37.3.0 | Add an index on state in the workers table |
| 0049 | v37.3.0 | Remove unnecessary etag columns from DB tables |
| 0050 | v37.3.0 | Use worker_pool_id instead of provisioner_id / worker_type for purge-cache |
| 0051 | v37.3.0 | update get_non_stopped_workers db function to include all fields |
| 0052 | v37.4.0 | deprecate get_workers |
| 0053 | v39.0.0 | Use task_queue_id instead of provisioner_id / worker_type in queues |
| 0054 | v39.0.0 | Add objects table and functions |
| 0055 | v39.0.0 | Insert object into database, raising P0004 if name already exists, but entire row not identical. |
| 0056 | v39.1.0 | Add objects.upload_id, upload_expires, and ready columns |
| 0057 | v39.1.1 | add get_queue_artifacts_paginated with index-based pagination |
| 0058 | v39.1.1 | make create_github_check idempotent |
| 0059 | v39.2.0 | Add task_queue_id column to tasks table and populate with online migration |
| 0060 | v39.2.0 | Drop provisioner_id / worker_type in queues and only use task_queue_id instead |
| 0061 | v40.0.0 | Deprecate functions that use provisioner_id/worker_type and add equivalents using task_queue_id instead, for tasks table |
| 0062 | v41.0.0 | add update_queue_artifact_2 to update artifact storage-type as well |
| 0063 | v41.0.0 | Add project_id to tasks table |
| 0064 | v41.0.1 | Add queue_worker_seen and queue_task_queue_seen functions |
| 0065 | v43.0.0 | add delete_indexed_task |
| 0066 | v43.0.0 | add get_non_stopped_workers_with_quarantine to include quarantine info from the queue |
| 0067 | v43.0.0 | add secure storage of object hashes |
| 0068 | v43.1.0 | add queue_artifact_present |
| 0069 | v44.8.3 | update get_queue_artifacts_paginated with improved index usage |
| 0070 | v44.10.0 | add get_worker_pool_with_capacity_and_counts_by_state, get_worker_pools_with_capacity_and_counts_by_state, and update_worker_pool_with_capacity_and_counts_by_state functions to get worker counts and capacity by state for worker pools |
| 0071 | v44.11.0 | add provider filter to get_non_stopped_workers_quntil |
| 0072 | v44.12.0 | add last_date_active to queue_workers |
| 0073 | v44.15.0 | include worker manager data to in queue worker responses |
| 0074 | v44.15.3 | get task queue(s) via worker manager service |
| 0075 | v44.15.4 | fix get_task_queue_wm args |
| 0076 | v44.16.0 | get github check by check suite id and check run id |
| 0077 | v44.17.0 | create additional functions to filter workers on state and quarantined status |
| 0078 | v44.18.0 | fix filtering of static workers based on quarantined status |
| 0079 | v46.0.0 | Speed up hooks fetching last fires by date |
| 0080 | v46.1.1 | fix duplicate entries in queue_workers join with workers table |
| 0081 | v48.0.0 | seal task group to prevent new tasks from being added to it |
| 0082 | v48.2.0 | cancel multiple tasks for a given taskGroupId |
| 0083 | v48.3.0 | Allow adding metadata to quarantined workers |
| 0084 | v49.1.0 | Fetch expired artifacts |
| 0085 | v50.1.0 | Store pull request number in github builds table |
| 0086 | v50.1.2 | Filter github builds in db |
| 0087 | v53.2.0 | add queue information to get_non_stopped_workers_quntil_providers |
| 0088 | v54.0.0 | Include task last run state in the hooks_last_fires table |
| 0089 | v55.1.0 | github checks fetching to use indexes |
| 0090 | v55.3.0 | prepare queue for upcoming migration and refactoring |
| 0091 | v56.0.0 | Migrate existing azure queue messages into new tables in a reversible way |
| 0092 | v56.0.0 | deadline message should not be removed when task is resolved |
| 0093 | v56.0.2 | Fix queue methods visibility issue, that was introduced in 91 |
| 0094 | v57.1.0 | fetch pending and claimed tasks for task queue |
| 0095 | v58.0.0 | Removing queue migration compat columns |
| 0096 | v58.0.0 | Worker pool errors statistics |
| 0097 | v59.2.0 | Worker pools extra stats |
| 0098 | v64.1.0 | Add batched tasks fetching |
| 0099 | v64.1.0 | Add more batched tasks fetching |
| 0100 | v64.2.4 | Improves speed for batched tasks fetching |