Skip to content

Airflow DB 3.x migration issue while upgrading OpenMetadata 1.11.x #24949

@harshsoni2024

Description

@harshsoni2024

Affected module
OpenMetadata 1.11.x upgrade migrations

Describe the bug
Below erros related to Airflow 3.x are seen while migrating OpenMetadata to version >=1.11.0

2025-12-19 15:53:18.974 | sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1305, 'FUNCTION airflow_db.uuid_generate_v7 does not exist')
2025-12-19 15:53:18.974 | [SQL: 
2025-12-19 15:53:18.974 |             UPDATE task_instance
2025-12-19 15:53:18.974 |             SET id = uuid_generate_v7(coalesce(queued_dttm, start_date, NOW(3)))
2025-12-19 15:53:18.974 |             WHERE id IS NULL
2025-12-19 15:53:18.974 |         ]
2025-12-19 15:53:18.974 | (Background on this error at: https://sqlalche.me/e/14/e3q8)
2025-12-19 15:53:19.267 | SimpleAuthManager configured - user: admin:admin
2025-12-19 15:53:19.267 | Setting password for admin in /opt/airflow/simple_auth_manager_passwords.json...
2025-12-19 15:53:19.363 | Password set for admin
2025-12-19 15:53:19.368 | SimpleAuthManager user created with custom password
2025-12-19 15:53:19.374 | Starting Airflow 3.x components...
2025-12-19 15:53:21.394 | ERROR: You need to migrate the database. Please run `airflow db migrate`. Make sure the command is run using Airflow version 3.1.2.

To Resolve
Please refer below doc on OpenMetadata 1.11.x breaking changes to resolve this conflict.
https://docs.open-metadata.org/latest/deployment/upgrade#breaking-changes

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions