vatsrahul1001 opened a new pull request, #47435:
URL: https://github.com/apache/airflow/pull/47435
Miration is failing when tried migration from 2.10 to 3.0.0. As a fix
updated table name from dataset to dataset_alias in migration script
**Stacktrace**
```
Traceback (most recent call last):
File "/usr/local/bin/airflow", line 10, in <module>
sys.exit(main())
File "/opt/airflow/airflow/__main__.py", line 58, in main
args.func(args)
File "/opt/airflow/airflow/cli/cli_config.py", line 49, in command
return func(*args, **kwargs)
File "/opt/airflow/airflow/utils/cli.py", line 112, in wrapper
return f(*args, **kwargs)
File "/opt/airflow/airflow/utils/providers_configuration_loader.py", line
55, in wrapped_function
return func(*args, **kwargs)
File "/opt/airflow/airflow/cli/commands/local_commands/db_command.py",
line 197, in migratedb
run_db_migrate_command(args, db.upgradedb, _REVISION_HEADS_MAP)
File "/opt/airflow/airflow/cli/commands/local_commands/db_command.py",
line 125, in run_db_migrate_command
command(
File "/opt/airflow/airflow/utils/session.py", line 101, in wrapper
return func(*args, session=session, **kwargs)
File "/opt/airflow/airflow/utils/db.py", line 1169, in upgradedb
command.upgrade(config, revision=to_revision or "heads")
File "/usr/local/lib/python3.9/site-packages/alembic/command.py", line
408, in upgrade
script.run_env()
File "/usr/local/lib/python3.9/site-packages/alembic/script/base.py", line
586, in run_env
util.load_python_file(self.dir, "env.py")
File "/usr/local/lib/python3.9/site-packages/alembic/util/pyfiles.py",
line 95, in load_python_file
module = load_module_py(module_id, path)
File "/usr/local/lib/python3.9/site-packages/alembic/util/pyfiles.py",
line 113, in load_module_py
spec.loader.exec_module(module) # type: ignore
File "<frozen importlib._bootstrap_external>", line 850, in exec_module
File "<frozen importlib._bootstrap>", line 228, in
_call_with_frames_removed
File "/opt/airflow/airflow/migrations/env.py", line 139, in <module>
run_migrations_online()
File "/opt/airflow/airflow/migrations/env.py", line 133, in
run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File
"/usr/local/lib/python3.9/site-packages/alembic/runtime/environment.py", line
946, in run_migrations
self.get_context().run_migrations(**kw)
File
"/usr/local/lib/python3.9/site-packages/alembic/runtime/migration.py", line
623, in run_migrations
step.migration_fn(**kw)
File
"/opt/airflow/airflow/migrations/versions/0039_3_0_0_tweak_assetaliasmodel_to_match_asset.py",
line 69, in upgrade
batch_op.alter_column("group", type_=_STRING_COLUMN_TYPE,
default="asset", nullable=False)
File "/usr/local/lib/python3.9/contextlib.py", line 126, in __exit__
next(self.gen)
File "/usr/local/lib/python3.9/site-packages/alembic/operations/base.py",
line 397, in batch_alter_table
impl.flush()
File "/usr/local/lib/python3.9/site-packages/alembic/operations/batch.py",
line 115, in flush
fn(*arg, **kw)
File "/usr/local/lib/python3.9/site-packages/alembic/ddl/postgresql.py",
line 188, in alter_column
super().alter_column(
File "/usr/local/lib/python3.9/site-packages/alembic/ddl/impl.py", line
281, in alter_column
self._exec(
File "/usr/local/lib/python3.9/site-packages/alembic/ddl/impl.py", line
247, in _exec
return conn.execute(construct, params)
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/future/engine.py",
line 286, in execute
return self._execute_20(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py",
line 1710, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/ddl.py", line
80, in _execute_on_connection
return connection._execute_ddl(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py",
line 1477, in _execute_ddl
ret = self._execute_context(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py",
line 1953, in _execute_context
self._handle_dbapi_exception(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py",
line 2134, in _handle_dbapi_exception
util.raise_(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py",
line 211, in raise_
raise exception
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py",
line 1910, in _execute_context
self.dialect.do_execute(
File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line
736, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) column
"group" of relation "dataset_alias" contains null values
```
**Migration worked after fix**
![Uploading image.png…]()
<!-- Please keep an empty line above the dashes. -->
---
**^ Add meaningful description above**
Read the **[Pull Request
Guidelines](https://github.com/apache/airflow/blob/main/contributing-docs/05_pull_requests.rst#pull-request-guidelines)**
for more information.
In case of fundamental code changes, an Airflow Improvement Proposal
([AIP](https://cwiki.apache.org/confluence/display/AIRFLOW/Airflow+Improvement+Proposals))
is needed.
In case of a new dependency, check compliance with the [ASF 3rd Party
License Policy](https://www.apache.org/legal/resolved.html#category-x).
In case of backwards incompatible changes please leave a note in a
newsfragment file, named `{pr_number}.significant.rst` or
`{issue_number}.significant.rst`, in
[newsfragments](https://github.com/apache/airflow/tree/main/newsfragments).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
