Migration workflow_engine.0087_relink_crons_to_compatible_issue_workflows faulty

[adepretis]

Self-Hosted Version

25.12.0

CPU Architecture

x86_64

Docker Version

28.5.1

Docker Compose Version

2.40.2

Machine Specification

• My system meets the minimum system requirements of Sentry

Installation Type

Upgrade from 25.10.0

Steps to Reproduce

Run ./install.sh

Expected Result

All good

Actual Result

Upgrade fails because of migration:

Migration workflow_engine.0087_relink_crons_to_compatible_issue_workflows is applied before its dependency monitors.0013_delete_monitor_is_muted_field on database 'default'

Reason seems to be getsentry/sentry@6cae270

I worked around it for now by adding the following to x-sentry-defaults.volumes in docker-compose.yml:

- "./patches/0087_relink_crons_to_compatible_issue_workflows.py:/usr/src/sentry/src/sentry/workflow_engine/migrations/0087_relink_crons_to_compatible_issue_workflows.py:ro"

with ./patches/0087_relink_crons_to_compatible_issue_workflows.py being the previous version of that file.

Migrations did run successful then:

Running migrations for default
Operations to perform:
  Apply all migrations: auth, contenttypes, discover, explore, feedback, flags, hybridcloud, insights, monitors, nodestore, notifications, preprod, prevent, releases, replays, sentry, sessions, sites, social_auth, tempest, uptime, workflow_engine
Running migrations:
  Applying feedback.0007_cleanup_failed_safe_deletes... OK
  Applying hybridcloud.0024_add_project_distribution_scope... OK
  Applying monitors.0011_backfill_monitor_environment_is_muted...Monitors
 OK
  Applying monitors.0012_remove_monitor_is_muted_field... OK
  Applying monitors.0013_delete_monitor_is_muted_field... OK
  Applying preprod.0018_add_preprod_artifact_app_icon_id_field... OK
  Applying preprod.0019_add_tooling_version_fields... OK
  Applying sentry.0997_add_has_trace_metrics_bit_to_project_model... OK
  Applying sentry.0998_add_prebuilt_id_to_dashboards... OK
  Applying sentry.0999_add_extrapolation_mode_to_snuba_query... OK
  Applying prevent.0001_create_prevent_ai_configuration... OK
  Applying prevent.0002_alter_integration_id_not_null... OK
  Applying sentry.1000_add_project_distribution_scope... OK
  Applying sentry.1001_prevent_grouphistory_infinte_recursion... OK
  Applying releases.0002_delete_dual_written_commit_tables... OK
  Applying releases.0003_real_delete_dual_written_commit_tables... OK
  Applying releases.0004_cleanup_failed_safe_deletes... OK
  Applying sentry.1002_group_history_prev_history_remove_db_constraint... OK
  Applying sentry.1003_group_history_prev_history_safe_removal... OK
  Applying sentry.1004_group_history_prev_history_delete... OK
  Applying sentry.1005_add_groupemailthread_project_date_index... OK
  Applying sentry.1006_drop_legacy_incidentseen_incidentsubscription... OK
  Applying sentry.1007_cleanup_failed_safe_deletes... OK
  Applying sentry.1008_loosen_unique_title_contraint... OK
  Applying sentry.1009_add_date_updated_to_organizationmapping... OK
  Applying sentry.1010_add_organizationcontributors_table... OK
  Applying sentry.1011_update_oc_integration_cascade_to_null... OK
  Applying replays.0007_organizationmember_replay_access... OK
  Applying sentry.1012_add_event_id_to_open_period... OK
  Applying sentry.1013_add_repositorysettings_table... OK
  Applying tempest.0003_use_encrypted_char_field... OK
  Applying uptime.0048_delete_uptime_status_columns... OK
  Applying uptime.0049_cleanup_failed_safe_deletes... OK
  Applying workflow_engine.0094_backfill_issue_stream_detector_workflows... OK
  Applying workflow_engine.0095_unique_detectorgroup_group... OK
  Applying workflow_engine.0096_delete_non_single_written_fire_history... OK
  Applying workflow_engine.0097_add_unique_constraint_to_datasource... OK
  Applying workflow_engine.0098_detectorgroup_detector_set_null... OK
  Applying workflow_engine.0099_backfill_metric_issue_detectorgroup... OK
  Applying workflow_engine.0100_move_is_single_written_to_pending... OK
  Applying workflow_engine.0101_remove_is_single_written_field... OK
  Applying workflow_engine.0102_cleanup_failed_safe_deletes... OK
  Applying workflow_engine.0103_add_unique_constraint... OK
  Applying workflow_engine.0104_action_data_fallthrough_type... OK

Event ID

No response

[yujingwyh]

I encountered the same issue. Could you please advise on how to resolve it?

[rwkyqwertee]

I encountered the same issue. Could you please advise on how to resolve it?

1. Create a folder named patches in the root of the git repo
2. Download this file to that folder https://raw.githubusercontent.com/getsentry/sentry/b2246d4d66b5288fb1832c9f655a602e223eac6e/src/sentry/workflow_engine/migrations/0087_relink_crons_to_compatible_issue_workflows.py e.g. wget -O patches/0087_relink_crons_to_compatible_issue_workflows.py https://raw.githubusercontent.com/getsentry/sentry/b2246d4d66b5288fb1832c9f655a602e223eac6e/src/sentry/workflow_engine/migrations/0087_relink_crons_to_compatible_issue_workflows.py
3. Edit docker-compose.yaml look for a line starting x-sentry-defaults then under volumes add - "./patches/0087_relink_crons_to_compatible_issue_workflows.py:/usr/src/sentry/src/sentry/workflow_engine/migrations/0087_relink_crons_to_compatible_issue_workflows.py:ro" This is my git diff

+++ b/docker-compose.yml
@@ -76,6 +76,7 @@ x-sentry-defaults: &sentry_defaults
     - "./sentry:/etc/sentry"
     - "./geoip:/geoip:ro"
     - "./certificates:/usr/local/share/ca-certificates:ro"
+    - "./patches/0087_relink_crons_to_compatible_issue_workflows.py:/usr/src/sentry/src/sentry/workflow_engine/migrations/0087_relink_crons_to_compatible_issue_workflows.py:ro" 
 x-snuba-defaults: &snuba_defaults
   <<: *restart_policy
   depends_on:

4. Run the install script as normal

[janignjic]

I encountered the same issue. Could you please advise on how to resolve it?

1. Create a folder named patches in the root of the git repo
2. Download this file to that folder https://raw.githubusercontent.com/getsentry/sentry/b2246d4d66b5288fb1832c9f655a602e223eac6e/src/sentry/workflow_engine/migrations/0087_relink_crons_to_compatible_issue_workflows.py e.g. wget -O patches/0087_relink_crons_to_compatible_issue_workflows.py https://raw.githubusercontent.com/getsentry/sentry/b2246d4d66b5288fb1832c9f655a602e223eac6e/src/sentry/workflow_engine/migrations/0087_relink_crons_to_compatible_issue_workflows.py
3. Edit docker-compose.yaml look for a line starting x-sentry-defaults then under volumes add - "./patches/0087_relink_crons_to_compatible_issue_workflows.py:/usr/src/sentry/src/sentry/workflow_engine/migrations/0087_relink_crons_to_compatible_issue_workflows.py:ro" This is my git diff

+++ b/docker-compose.yml
@@ -76,6 +76,7 @@ x-sentry-defaults: &sentry_defaults
     - "./sentry:/etc/sentry"
     - "./geoip:/geoip:ro"
     - "./certificates:/usr/local/share/ca-certificates:ro"
+    - "./patches/0087_relink_crons_to_compatible_issue_workflows.py:/usr/src/sentry/src/sentry/workflow_engine/migrations/0087_relink_crons_to_compatible_issue_workflows.py:ro" 
 x-snuba-defaults: &snuba_defaults
   <<: *restart_policy
   depends_on:

4. Run the install script as normal

After the update is successful, should the patches be deleted and the entry removed from docker-compose.yml?

[cocorossello]

I confirm this worked, thanks a lot!

I guess we can remove patch, can we?

[Gazzonyx]

@rwkyqwertee : I owe you a beer. This fixed my self hosted POC that was put on ice a week or two ago.

[Tabll]

+1