Lowsp00f opened a new issue, #32375:
URL: https://github.com/apache/superset/issues/32375
### Bug description
1. Try update superset in docker-compose from 4.0.1 to 5.0
2. In terminal next steps -
2.1 docker-compose down
2.2 git pull origin master
2.3 docker-compose up - following next errors:
`superset_init | INFO [alembic.runtime.migration] Running upgrade
678eefb4ab44 -> c22cb5c2e546, empty message
superset_init | INFO [alembic] Adding column avatar_url to table
user_attribute...
superset_init | INFO [alembic.runtime.migration] Running upgrade
c22cb5c2e546 -> 5ad7321c2169, mig new csv upload perm
superset_init | INFO [alembic.runtime.migration] Running upgrade
5ad7321c2169 -> d60591c5515f, mig new excel upload perm
superset_init | INFO [alembic.runtime.migration] Running upgrade
d60591c5515f -> 5f57af97bc3f, Add catalog column
superset_init | INFO [alembic] Adding column catalog to table
tables...
superset_init | INFO [alembic] Adding column catalog to table
query...
superset_init | INFO [alembic] Adding column catalog to table
saved_query...
superset_init | INFO [alembic] Adding column catalog to table
tab_state...
superset_init | INFO [alembic] Adding column catalog to table
table_schema...
superset_init | INFO [alembic.runtime.migration] Running upgrade
5f57af97bc3f -> 3dfd0e78650e, add_query_sql_editor_id_index
superset_init | INFO [alembic.runtime.migration] Running upgrade
5f57af97bc3f -> 4a33124c18ad, mig new columnar upload perm
superset_init | INFO [alembic.runtime.migration] Running upgrade
4a33124c18ad -> 58d051681a3b, Add catalog_perm to tables
superset_init | INFO [alembic] Adding column catalog_perm to table
tables...
superset_init | INFO [alembic] Adding column catalog_perm to table
slices...
superset_init | Traceback (most recent call last):
superset_init | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy_utils/types/encrypted/encrypted_type.py",
line 126, in decrypt
superset_init | decrypted = decrypted.decode('utf-8')
superset_init | ^^^^^^^^^^^^^^^^^^^^^^^^^
superset_init | UnicodeDecodeError: 'utf-8' codec can't decode byte
0xfe in position 0: invalid start byte
superset_init |
superset_init | During handling of the above exception, another
exception occurred:
superset_init |
superset_init | Traceback (most recent call last):
superset_init | File "/app/.venv/bin/superset", line 10, in
<module>
superset_init | sys.exit(superset())
superset_init | ^^^^^^^^^^
superset_init | File
"/app/.venv/lib/python3.11/site-packages/click/core.py", line 1157, in __call__
superset_init | return self.main(*args, **kwargs)
superset_init | ^^^^^^^^^^^^^^^^^^^^^^^^^^
superset_init | File
"/app/.venv/lib/python3.11/site-packages/click/core.py", line 1078, in main
superset_init | rv = self.invoke(ctx)
superset_init | ^^^^^^^^^^^^^^^^
superset_init | File
"/app/.venv/lib/python3.11/site-packages/click/core.py", line 1688, in invoke
superset_init | return
_process_result(sub_ctx.command.invoke(sub_ctx))
superset_init |
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
superset_init | File
"/app/.venv/lib/python3.11/site-packages/click/core.py", line 1688, in invoke
superset_init | return
_process_result(sub_ctx.command.invoke(sub_ctx))
superset_init |
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
superset_init | File
"/app/.venv/lib/python3.11/site-packages/click/core.py", line 1434, in invoke
superset_init | return ctx.invoke(self.callback, **ctx.params)
superset_init | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
superset_init | File
"/app/.venv/lib/python3.11/site-packages/click/core.py", line 783, in invoke
superset_init | return __callback(*args, **kwargs)
superset_init | ^^^^^^^^^^^^^^^^^^^^^^^^^^^
superset_init | File
"/app/.venv/lib/python3.11/site-packages/click/decorators.py", line 33, in
new_func
superset_init | return f(get_current_context(), *args, **kwargs)
superset_init | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
superset_init | File
"/app/.venv/lib/python3.11/site-packages/flask/cli.py", line 358, in decorator
superset_init | return __ctx.invoke(f, *args, **kwargs)
superset_init | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
superset_init | File
"/app/.venv/lib/python3.11/site-packages/click/core.py", line 783, in invoke
superset_init | return __callback(*args, **kwargs)
superset_init | ^^^^^^^^^^^^^^^^^^^^^^^^^^^
superset_init | File
"/app/.venv/lib/python3.11/site-packages/flask_migrate/cli.py", line 149, in
upgrade
superset_init | _upgrade(directory, revision, sql, tag, x_arg)
superset_init | File
"/app/.venv/lib/python3.11/site-packages/flask_migrate/__init__.py", line 98,
in wrapped
superset_init | f(*args, **kwargs)
superset_init | File
"/app/.venv/lib/python3.11/site-packages/flask_migrate/__init__.py", line 185,
in upgrade
superset_init | command.upgrade(config, revision, sql=sql,
tag=tag)
superset_init | File
"/app/.venv/lib/python3.11/site-packages/alembic/command.py", line 406, in
upgrade
superset_init | script.run_env()
superset_init | File
"/app/.venv/lib/python3.11/site-packages/alembic/script/base.py", line 586, in
run_env
superset_init | util.load_python_file(self.dir, "env.py")
superset_init | File
"/app/.venv/lib/python3.11/site-packages/alembic/util/pyfiles.py", line 95, in
load_python_file
superset_init | module = load_module_py(module_id, path)
superset_init | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
superset_init | File
"/app/.venv/lib/python3.11/site-packages/alembic/util/pyfiles.py", line 113, in
load_module_py
superset_init | spec.loader.exec_module(module) # type: ignore
superset_init | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
superset_init | File "<frozen importlib._bootstrap_external>",
line 940, in exec_module
superset_init | File "<frozen importlib._bootstrap>", line 241, in
_call_with_frames_removed
superset_init | File
"/app/.venv/lib/python3.11/site-packages/superset/extensions/../migrations/env.py",
line 142, in <module>
superset_init | run_migrations_online()
superset_init | File
"/app/.venv/lib/python3.11/site-packages/superset/extensions/../migrations/env.py",
line 133, in run_migrations_online
superset_init | context.run_migrations()
superset_init | File "<string>", line 8, in run_migrations
superset_init | File
"/app/.venv/lib/python3.11/site-packages/alembic/runtime/environment.py", line
946, in run_migrations
superset_init | self.get_context().run_migrations(**kw)
superset_init | File
"/app/.venv/lib/python3.11/site-packages/alembic/runtime/migration.py", line
623, in run_migrations
superset_init | step.migration_fn(**kw)
superset_init | File
"/app/.venv/lib/python3.11/site-packages/superset/migrations/versions/2024-05-01_10-52_58d051681a3b_add_catalog_perm_to_tables.py",
line 45, in upgrade
superset_init | upgrade_catalog_perms(engines={"postgresql"})
superset_init | File
"/app/.venv/lib/python3.11/site-packages/superset/migrations/shared/catalogs.py",
line 374, in upgrade_catalog_perms
superset_init | for database in session.query(Database).all():
superset_init | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
superset_init | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2773,
in all
superset_init | return self._iter().all()
superset_init | ^^^^^^^^^^^^^^^^^^
superset_init | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/result.py", line
1476, in all
superset_init | return self._allrows()
superset_init | ^^^^^^^^^^^^^^^
superset_init | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/result.py", line
401, in _allrows
superset_init | rows = self._fetchall_impl()
superset_init | ^^^^^^^^^^^^^^^^^^^^^
superset_init | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/result.py", line
1389, in _fetchall_impl
superset_init | return self._real_result._fetchall_impl()
superset_init | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
superset_init | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/result.py", line
1813, in _fetchall_impl
superset_init | return list(self.iterator)
superset_init | ^^^^^^^^^^^^^^^^^^^
superset_init | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/orm/loading.py", line 147,
in chunks
superset_init | fetch = cursor._raw_all_rows()
superset_init | ^^^^^^^^^^^^^^^^^^^^^^
superset_init | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/result.py", line
393, in _raw_all_rows
superset_init | return [make_row(row) for row in rows]
superset_init | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
superset_init | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/result.py", line
393, in <listcomp>
superset_init | return [make_row(row) for row in rows]
superset_init | ^^^^^^^^^^^^^
superset_init | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/sql/type_api.py", line
1718, in process
superset_init | return process_value(impl_processor(value),
dialect)
superset_init |
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
superset_init | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy_utils/types/encrypted/encrypted_type.py",
line 479, in process_result_value
superset_init | value =
super().process_result_value(value=value, dialect=dialect)
superset_init |
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
superset_init | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy_utils/types/encrypted/encrypted_type.py",
line 424, in process_result_value
superset_init | decrypted_value = self.engine.decrypt(value)
superset_init | ^^^^^^^^^^^^^^^^^^^^^^^^^^
superset_init | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy_utils/types/encrypted/encrypted_type.py",
line 128, in decrypt
superset_init | raise ValueError('Invalid decryption key')`
How i can fix that error?
Clear installation 5.0 success.Upgrade from 4.0.1 with empty metadata to 5.0
success.
### Screenshots/recordings
_No response_
### Superset version
master / latest-dev
### Python version
3.9
### Node version
16
### Browser
Chrome
### Additional context
_No response_
### Checklist
- [ ] I have searched Superset docs and Slack and didn't find a solution to
my problem.
- [ ] I have searched the GitHub issue tracker and didn't find a similar bug
report.
- [ ] I have checked Superset's logs for errors and if I found a relevant
Python stacktrace, I included it here as text in the "additional context"
section.
--
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]
