Hi Everyone,
when trying to upgrade my AWX instance, I have an issue with the database migration.
By entering into awx-web pod, I can see the following
bash-5.1$ awx-manage showmigrations
auth
0001_initial
0002_alter_permission_name_max_length
0003_alter_user_email_max_length
0004_alter_user_username_opts
0005_alter_user_last_login_null
0006_require_contenttypes_0002
0007_alter_validators_add_error_messages
0008_alter_user_username_max_length
0009_alter_user_last_name_max_length
0010_alter_group_name_max_length
0011_update_proxy_permissions
0012_alter_user_first_name_max_length
conf
0001_initial
0002_v310_copy_tower_settings
0003_v310_JSONField_changes
0004_v320_reencrypt
0005_v330_rename_two_session_settings
0006_v331_ldap_group_type
0007_v380_rename_more_settings
0008_subscriptions
0009_rename_proot_settings
contenttypes
0001_initial
0002_remove_content_type_name
main
0001_initial
0002_squashed_v300_release (18 squashed migrations)
0003_squashed_v300_v303_updates (9 squashed migrations)
0004_squashed_v310_release (6 squashed migrations)
0005_squashed_v310_v313_updates (3 squashed migrations)
0006_v320_release
0007_v320_data_migrations
0008_v320_drop_v1_credential_fields
0009_v322_add_setting_field_for_activity_stream
0010_v322_add_ovirt4_tower_inventory
0011_v322_encrypt_survey_passwords
0012_v322_update_cred_types
0013_v330_multi_credential
0014_v330_saved_launchtime_configs
0015_v330_blank_start_args
0016_v330_non_blank_workflow
0017_v330_move_deprecated_stdout
0018_v330_add_additional_stdout_events
0019_v330_custom_virtualenv
0020_v330_instancegroup_policies
0021_v330_declare_new_rbac_roles
0022_v330_create_new_rbac_roles
0023_v330_inventory_multicred
0024_v330_create_user_session_membership
0025_v330_add_oauth_activity_stream_registrar
0026_v330_delete_authtoken
0027_v330_emitted_events
0028_v330_add_tower_verify
0030_v330_modify_application
0031_v330_encrypt_oauth2_secret
0032_v330_polymorphic_delete
0033_v330_oauth_help_text
0034_v330_delete_user_role
0035_v330_more_oauth2_help_text
0036_v330_credtype_remove_become_methods
0037_v330_remove_legacy_fact_cleanup
0038_v330_add_deleted_activitystream_actor
0039_v330_custom_venv_help_text
0040_v330_unifiedjob_controller_node
0041_v330_update_oauth_refreshtoken
0042_v330_org_member_role_deparent
0043_v330_oauth2accesstoken_modified
0044_v330_add_inventory_update_inventory
0045_v330_instance_managed_by_policy
0046_v330_remove_client_credentials_grant
0047_v330_activitystream_instance
0048_v330_django_created_modified_by_model_name
0049_v330_validate_instance_capacity_adjustment
0050_v340_drop_celery_tables
0051_v340_job_slicing
0052_v340_remove_project_scm_delete_on_next_update
0053_v340_workflow_inventory
0054_v340_workflow_convergence
0055_v340_add_grafana_notification
0056_v350_custom_venv_history
0057_v350_remove_become_method_type
0058_v350_remove_limit_limit
0059_v350_remove_adhoc_limit
0060_v350_update_schedule_uniqueness_constraint
0061_v350_track_native_credentialtype_source
0062_v350_new_playbook_stats
0063_v350_org_host_limits
0064_v350_analytics_state
0065_v350_index_job_status
0066_v350_inventorysource_custom_virtualenv
0067_v350_credential_plugins
0068_v350_index_event_created
0069_v350_generate_unique_install_uuid
0070_v350_gce_instance_id
0071_v350_remove_system_tracking
0072_v350_deprecate_fields
0073_v360_create_instance_group_m2m
0074_v360_migrate_instance_group_relations
0075_v360_remove_old_instance_group_relations
0076_v360_add_new_instance_group_relations
0077_v360_add_default_orderings
0078_v360_clear_sessions_tokens_jt
0079_v360_rm_implicit_oauth2_apps
0080_v360_replace_job_origin
0081_v360_notify_on_start
0082_v360_webhook_http_method
0083_v360_job_branch_override
0084_v360_token_description
0085_v360_add_notificationtemplate_messages
0086_v360_workflow_approval
0087_v360_update_credential_injector_help_text
0088_v360_dashboard_optimizations
0089_v360_new_job_event_types
0090_v360_WFJT_prompts
0091_v360_approval_node_notifications
0092_v360_webhook_mixin
0093_v360_personal_access_tokens
0094_v360_webhook_mixin2
0095_v360_increase_instance_version_length
0096_v360_container_groups
0097_v360_workflowapproval_approved_or_denied_by
0098_v360_rename_cyberark_aim_credential_type
0099_v361_license_cleanup
0100_v370_projectupdate_job_tags
0101_v370_generate_new_uuids_for_iso_nodes
0102_v370_unifiedjob_canceled
0103_v370_remove_computed_fields
0104_v370_cleanup_old_scan_jts
0105_v370_remove_jobevent_parent_and_hosts
0106_v370_remove_inventory_groups_with_active_failures
0107_v370_workflow_convergence_api_toggle
0108_v370_unifiedjob_dependencies_processed
0109_v370_job_template_organization_field
0110_v370_instance_ip_address
0111_v370_delete_channelgroup
0112_v370_workflow_node_identifier
0113_v370_event_bigint
0114_v370_remove_deprecated_manual_inventory_sources
0115_v370_schedule_set_null
0116_v400_remove_hipchat_notifications
0117_v400_remove_cloudforms_inventory
0118_add_remote_archive_scm_type
0119_inventory_plugins
0120_galaxy_credentials
0121_delete_toweranalyticsstate
0122_really_remove_cloudforms_inventory
0123_drop_hg_support
0124_execution_environments
0125_more_ee_modeling_changes
0126_executionenvironment_container_options
0127_reset_pod_spec_override
0128_organiaztion_read_roles_ee_admin
0129_unifiedjob_installed_collections
0130_ee_polymorphic_set_null
0131_undo_org_polymorphic_ee
0132_instancegroup_is_container_group
0133_centrify_vault_credtype
0134_unifiedjob_ansible_version
0135_schedule_sort_fallback_to_id
0136_scm_track_submodules
0137_custom_inventory_scripts_removal_data
0138_custom_inventory_scripts_removal
0139_isolated_removal
0140_rename
0141_remove_isolated_instances
0142_update_ee_image_field_description
0143_hostmetric
0144_event_partitions
0145_deregister_managed_ee_objs
0146_add_insights_inventory
0147_validate_ee_image_field
0148_unifiedjob_receptor_unit_id
0149_remove_inventory_insights_credential
0150_rename_inv_sources_inv_updates
0151_rename_managed_by_tower
0152_instance_node_type
0153_instance_last_seen
0154_set_default_uuid
0155_improved_health_check
0156_capture_mesh_topology
0157_inventory_labels
0158_make_instance_cpu_decimal
0159_deprecate_inventory_source_UoPU_field
0160_alter_schedule_rrule
0161_unifiedjob_host_status_counts
0162_alter_unifiedjob_dependent_jobs
0163_convert_job_tags_to_textfield
0164_remove_inventorysource_update_on_project_update
0165_task_manager_refactor
0166_alter_jobevent_host
0167_project_signature_validation_credential
0168_inventoryupdate_scm_revision
0169_jt_prompt_everything_on_launch
0170_node_and_link_state
0171_add_health_check_started
0172_prevent_instance_fallback
0173_instancegroup_max_limits
0174_ensure_org_ee_admin_roles
0175_workflowjob_is_bulk_job
0176_inventorysource_scm_branch
0177_instance_group_role_addition
0178_instance_group_admin_migration
0179_change_cyberark_plugin_names
0180_add_hostmetric_fields
0181_hostmetricsummarymonthly
0182_constructed_inventory
0183_pre_django_upgrade
[ ] 0184_django_indexes
oauth2_provider
0001_initial
0002_auto_20190406_1805
0003_auto_20201211_1314
0004_auto_20200902_2022
0005_auto_20211222_2352
sessions
0001_initial
sites
0001_initial
0002_alter_domain_unique
social_django
0001_initial (2 squashed migrations)
0002_add_related_name (2 squashed migrations)
0003_alter_email_max_length (2 squashed migrations)
0004_auto_20160423_0400 (2 squashed migrations)
0005_auto_20160727_2333 (1 squashed migrations)
0006_partial
0007_code_timestamp
0008_partial_timestamp
0009_auto_20191118_0520
0010_uid_db_index
sso
0001_initial
0002_expand_provider_options
0003_convert_saml_string_to_list
taggit
0001_initial
0002_auto_20150616_2121
0003_taggeditem_add_unique_index
0004_alter_taggeditem_content_type_alter_taggeditem_tag
0005_auto_20220424_2025
Only 0184_django_indexes is failing
bash-5.1$ awx-manage migrate main
Operations to perform:
Apply all migrations: main
Running migrations:
Applying main.0184_django_indexes…Traceback (most recent call last):
File “/usr/bin/awx-manage”, line 8, in
sys.exit(manage())
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/awx/init.py”, line 200, in manage
execute_from_command_line(sys.argv)
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/core/management/init.py”, line 442, in execute_from_command_line
utility.execute()
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/core/management/init.py”, line 436, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/core/management/base.py”, line 412, in run_from_argv
self.execute(*args, **cmd_options)
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/core/management/base.py”, line 458, in execute
output = self.handle(*args, **options)
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/core/management/base.py”, line 106, in wrapper
res = handle_func(*args, **kwargs)
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/core/management/commands/migrate.py”, line 356, in handle
post_migrate_state = executor.migrate(
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/db/migrations/executor.py”, line 135, in migrate
state = self._migrate_all_forwards(
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/db/migrations/executor.py”, line 167, in _migrate_all_forwards
state = self.apply_migration(
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/db/migrations/executor.py”, line 252, in apply_migration
state = migration.apply(state, schema_editor)
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/db/migrations/migration.py”, line 132, in apply
operation.database_forwards(
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/db/migrations/operations/models.py”, line 977, in database_forwards
raise ValueError(
ValueError: Found wrong number (0) of indexes for main_projectupdateevent(project_update_id, job_created, uuid).
Any ideas?