Jockxtar commented on issue #30596:
URL: https://github.com/apache/superset/issues/30596#issuecomment-2493147203
Hi, I'm still getting this error (or a very similar one) when trying to
upgrade to the lastest version (4.1.1) from 4.0.2.
It happens when executing "superset db upgrade".
Here is the context:
```
WARNI [alembic.env] SQLite Database support for metadata databases will
be removed in a future version of Superset.
INFO [alembic.env] Starting the migration scripts.
INFO [alembic.runtime.migration] Context impl SQLiteImpl.
INFO [alembic.runtime.migration] Will assume transactional DDL.
INFO [alembic.runtime.migration] Running upgrade 4a33124c18ad ->
58d051681a3b, Add catalog_perm to tables
Traceback (most recent call last):
File
"/opt/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py",
line 1910, in _execute_context
self.dialect.do_execute(
File
"/opt/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py",
line 736, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: duplicate column name: catalog_perm
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/opt/superset/venv/bin/superset", line 8, in <module>
sys.exit(superset())
File "/opt/superset/venv/lib/python3.10/site-packages/click/core.py", line
1157, in __call__
return self.main(*args, **kwargs)
File "/opt/superset/venv/lib/python3.10/site-packages/click/core.py", line
1078, in main
rv = self.invoke(ctx)
File "/opt/superset/venv/lib/python3.10/site-packages/click/core.py", line
1688, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/opt/superset/venv/lib/python3.10/site-packages/click/core.py", line
1688, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/opt/superset/venv/lib/python3.10/site-packages/click/core.py", line
1434, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/opt/superset/venv/lib/python3.10/site-packages/click/core.py", line
783, in invoke
return __callback(*args, **kwargs)
File "/opt/superset/venv/lib/python3.10/site-packages/click/decorators.py",
line 33, in new_func
return f(get_current_context(), *args, **kwargs)
File "/opt/superset/venv/lib/python3.10/site-packages/flask/cli.py", line
358, in decorator
return __ctx.invoke(f, *args, **kwargs)
File "/opt/superset/venv/lib/python3.10/site-packages/click/core.py", line
783, in invoke
return __callback(*args, **kwargs)
File "/opt/superset/venv/lib/python3.10/site-packages/flask_migrate/cli.py",
line 149, in upgrade
_upgrade(directory, revision, sql, tag, x_arg)
File
"/opt/superset/venv/lib/python3.10/site-packages/flask_migrate/__init__.py",
line 98, in wrapped
f(*args, **kwargs)
File
"/opt/superset/venv/lib/python3.10/site-packages/flask_migrate/__init__.py",
line 185, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "/opt/superset/venv/lib/python3.10/site-packages/alembic/command.py",
line 406, in upgrade
script.run_env()
File
"/opt/superset/venv/lib/python3.10/site-packages/alembic/script/base.py", line
582, in run_env
util.load_python_file(self.dir, "env.py")
File
"/opt/superset/venv/lib/python3.10/site-packages/alembic/util/pyfiles.py", line
95, in load_python_file
module = load_module_py(module_id, path)
File
"/opt/superset/venv/lib/python3.10/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 883, in exec_module
File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
File
"/opt/superset/venv/lib/python3.10/site-packages/superset/extensions/../migrations/env.py",
line 142, in <module>
run_migrations_online()
File
"/opt/superset/venv/lib/python3.10/site-packages/superset/extensions/../migrations/env.py",
line 133, in run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File
"/opt/superset/venv/lib/python3.10/site-packages/alembic/runtime/environment.py",
line 946, in run_migrations
self.get_context().run_migrations(**kw)
File
"/opt/superset/venv/lib/python3.10/site-packages/alembic/runtime/migration.py",
line 628, in run_migrations
step.migration_fn(**kw)
File
"/opt/superset/venv/lib/python3.10/site-packages/superset/migrations/versions/2024-05-01_10-52_58d051681a3b_add_catalog_perm_to_tables.py",
line 39, in upgrade
op.add_column(
File "<string>", line 8, in add_column
File "<string>", line 3, in add_column
File
"/opt/superset/venv/lib/python3.10/site-packages/alembic/operations/ops.py",
line 2142, in add_column
return operations.invoke(op)
File
"/opt/superset/venv/lib/python3.10/site-packages/alembic/operations/base.py",
line 442, in invoke
return fn(self, operation)
File
"/opt/superset/venv/lib/python3.10/site-packages/alembic/operations/toimpl.py",
line 171, in add_column
operations.impl.add_column(table_name, column, schema=schema, **kw)
File "/opt/superset/venv/lib/python3.10/site-packages/alembic/ddl/impl.py",
line 337, in add_column
self._exec(base.AddColumn(table_name, column, schema=schema))
File "/opt/superset/venv/lib/python3.10/site-packages/alembic/ddl/impl.py",
line 210, in _exec
return conn.execute(construct, params)
File
"/opt/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py",
line 1385, in execute
return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS)
File
"/opt/superset/venv/lib/python3.10/site-packages/sqlalchemy/sql/ddl.py", line
80, in _execute_on_connection
return connection._execute_ddl(
File
"/opt/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py",
line 1477, in _execute_ddl
ret = self._execute_context(
File
"/opt/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py",
line 1953, in _execute_context
self._handle_dbapi_exception(
File
"/opt/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py",
line 2134, in _handle_dbapi_exception
util.raise_(
File
"/opt/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py",
line 211, in raise_
raise exception
File
"/opt/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py",
line 1910, in _execute_context
self.dialect.do_execute(
File
"/opt/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py",
line 736, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) duplicate column
name: catalog_perm
[SQL: ALTER TABLE tables ADD COLUMN catalog_perm VARCHAR(1000)]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
```
--
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
