jayakrishnankk commented on issue #19496:
URL: https://github.com/apache/superset/issues/19496#issuecomment-1096888109
Same problem for us.
We were testing release version 1.5
```
INFO [alembic.runtime.migration] Running upgrade 5afbb1a5849b ->
b8d3a24d9131, New dataset models
Traceback (most recent call last):
File "/usr/local/bin/superset", line 33, in <module>
sys.exit(load_entry_point('apache-superset', 'console_scripts',
'superset')())
File "/usr/local/lib/python3.8/site-packages/click/core.py", line 829, in
__call__
return self.main(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/flask/cli.py", line 586, in
main
return super(FlaskGroup, self).main(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/click/core.py", line 782, in
main
rv = self.invoke(ctx)
File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1259, in
invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1259, in
invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1066, in
invoke
return ctx.invoke(self.callback, **ctx.params)
File "/usr/local/lib/python3.8/site-packages/click/core.py", line 610, in
invoke
return callback(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/click/decorators.py", line
21, in new_func
return f(get_current_context(), *args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/flask/cli.py", line 426, in
decorator
return __ctx.invoke(f, *args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/click/core.py", line 610, in
invoke
return callback(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/flask_migrate/cli.py", line
149, in upgrade
_upgrade(directory, revision, sql, tag, x_arg)
File "/usr/local/lib/python3.8/site-packages/flask_migrate/__init__.py",
line 98, in wrapped
f(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/flask_migrate/__init__.py",
line 185, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "/usr/local/lib/python3.8/site-packages/alembic/command.py", line
294, in upgrade
script.run_env()
File "/usr/local/lib/python3.8/site-packages/alembic/script/base.py", line
490, in run_env
util.load_python_file(self.dir, "env.py")
File "/usr/local/lib/python3.8/site-packages/alembic/util/pyfiles.py",
line 97, in load_python_file
module = load_module_py(module_id, path)
File "/usr/local/lib/python3.8/site-packages/alembic/util/compat.py", line
184, in load_module_py
spec.loader.exec_module(module)
File "<frozen importlib._bootstrap_external>", line 843, in exec_module
File "<frozen importlib._bootstrap>", line 219, in
_call_with_frames_removed
File "/app/superset/extensions/../migrations/env.py", line 126, in <module>
run_migrations_online()
File "/app/superset/extensions/../migrations/env.py", line 118, in
run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File
"/usr/local/lib/python3.8/site-packages/alembic/runtime/environment.py", line
813, in run_migrations
self.get_context().run_migrations(**kw)
File
"/usr/local/lib/python3.8/site-packages/alembic/runtime/migration.py", line
561, in run_migrations
step.migration_fn(**kw)
File
"/app/superset/migrations/versions/b8d3a24d9131_new_dataset_models.py", line
632, in upgrade
after_insert(target=dataset)
File
"/app/superset/migrations/versions/b8d3a24d9131_new_dataset_models.py", line
430, in after_insert
tables = load_or_create_tables(
File
"/app/superset/migrations/versions/b8d3a24d9131_new_dataset_models.py", line
291, in load_or_create_tables
column_metadata = inspector.get_columns(table.table, schema=table.schema)
File
"/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/reflection.py", line
390, in get_columns
col_defs = self.dialect.get_columns(
File "<string>", line 2, in get_columns
File
"/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/reflection.py", line
52, in cache
ret = fn(self, con, *args, **kw)
File
"/usr/local/lib/python3.8/site-packages/sqlalchemy/dialects/postgresql/base.py",
line 3037, in get_columns
table_oid = self.get_table_oid(
File "<string>", line 2, in get_table_oid
File
"/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/reflection.py", line
52, in cache
ret = fn(self, con, *args, **kw)
File
"/usr/local/lib/python3.8/site-packages/sqlalchemy/dialects/postgresql/base.py",
line 2952, in get_table_oid
raise exc.NoSuchTableError(table_name)
sqlalchemy.exc.NoSuchTableError: get_periodfacts
```
Here get_periodfacts is a function in the postgres database, used in a
dataset definition in superset datasets.
@amitmiran137 , @villebro
--
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]
