justmike1 commented on issue #29582:
URL: https://github.com/apache/superset/issues/29582#issuecomment-2226810029
I successfully connected to another schema using:
```py
SQLALCHEMY_ENGINE_OPTIONS = {
'connect_args': {'options': '-csearch_path=newtest'}
}
```
but now I recieve:
```(shell)
2024-07-13 15:34:08 INFO [alembic.runtime.migration] Running upgrade ->
4e6a06bad7a8, Init
2024-07-13 15:34:08 Traceback (most recent call last):
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1910, in
_execute_context
2024-07-13 15:34:08 self.dialect.do_execute(
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 736, in
do_execute
2024-07-13 15:34:08 cursor.execute(statement, parameters)
2024-07-13 15:34:08 psycopg2.errors.UndefinedTable: relation "ab_user" does
not exist
2024-07-13 15:34:08
2024-07-13 15:34:08
2024-07-13 15:34:08 The above exception was the direct cause of the
following exception:
2024-07-13 15:34:08
2024-07-13 15:34:08 Traceback (most recent call last):
2024-07-13 15:34:08 File "/usr/bin/superset", line 8, in <module>
2024-07-13 15:34:08 sys.exit(superset())
2024-07-13 15:34:08 ^^^^^^^^^^
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/click/core.py", line 1157, in __call__
2024-07-13 15:34:08 return self.main(*args, **kwargs)
2024-07-13 15:34:08 ^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/click/core.py", line 1078, in main
2024-07-13 15:34:08 rv = self.invoke(ctx)
2024-07-13 15:34:08 ^^^^^^^^^^^^^^^^
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/click/core.py", line 1688, in invoke
2024-07-13 15:34:08 return
_process_result(sub_ctx.command.invoke(sub_ctx))
2024-07-13 15:34:08
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/click/core.py", line 1688, in invoke
2024-07-13 15:34:08 return
_process_result(sub_ctx.command.invoke(sub_ctx))
2024-07-13 15:34:08
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/click/core.py", line 1434, in invoke
2024-07-13 15:34:08 return ctx.invoke(self.callback, **ctx.params)
2024-07-13 15:34:08 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/click/core.py", line 783, in invoke
2024-07-13 15:34:08 return __callback(*args, **kwargs)
2024-07-13 15:34:08 ^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/click/decorators.py", line 33, in new_func
2024-07-13 15:34:08 return f(get_current_context(), *args, **kwargs)
2024-07-13 15:34:08 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-07-13 15:34:08 File "/usr/lib/python3.11/site-packages/flask/cli.py",
line 357, in decorator
2024-07-13 15:34:08 return __ctx.invoke(f, *args, **kwargs)
2024-07-13 15:34:08 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/click/core.py", line 783, in invoke
2024-07-13 15:34:08 return __callback(*args, **kwargs)
2024-07-13 15:34:08 ^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/flask_migrate/cli.py", line 149, in upgrade
2024-07-13 15:34:08 _upgrade(directory, revision, sql, tag, x_arg)
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/flask_migrate/__init__.py", line 98, in
wrapped
2024-07-13 15:34:08 f(*args, **kwargs)
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/flask_migrate/__init__.py", line 185, in
upgrade
2024-07-13 15:34:08 command.upgrade(config, revision, sql=sql, tag=tag)
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/alembic/command.py", line 406, in upgrade
2024-07-13 15:34:08 script.run_env()
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/alembic/script/base.py", line 582, in run_env
2024-07-13 15:34:08 util.load_python_file(self.dir, "env.py")
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/alembic/util/pyfiles.py", line 95, in
load_python_file
2024-07-13 15:34:08 module = load_module_py(module_id, path)
2024-07-13 15:34:08 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/alembic/util/pyfiles.py", line 113, in
load_module_py
2024-07-13 15:34:08 spec.loader.exec_module(module) # type: ignore
2024-07-13 15:34:08 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-07-13 15:34:08 File "<frozen importlib._bootstrap_external>", line
940, in exec_module
2024-07-13 15:34:08 File "<frozen importlib._bootstrap>", line 241, in
_call_with_frames_removed
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/superset/extensions/../migrations/env.py",
line 127, in <module>
2024-07-13 15:34:08 run_migrations_online()
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/superset/extensions/../migrations/env.py",
line 119, in run_migrations_online
2024-07-13 15:34:08 context.run_migrations()
2024-07-13 15:34:08 File "<string>", line 8, in run_migrations
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/alembic/runtime/environment.py", line 946,
in run_migrations
2024-07-13 15:34:08 self.get_context().run_migrations(**kw)
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/alembic/runtime/migration.py", line 628, in
run_migrations
2024-07-13 15:34:08 step.migration_fn(**kw)
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/superset/migrations/versions/2015-09-21_17-30_4e6a06bad7a8_init.py",
line 35, in upgrade
2024-07-13 15:34:08 op.create_table(
2024-07-13 15:34:08 File "<string>", line 8, in create_table
2024-07-13 15:34:08 File "<string>", line 3, in create_table
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/alembic/operations/ops.py", line 1311, in
create_table
2024-07-13 15:34:08 return operations.invoke(op)
2024-07-13 15:34:08 ^^^^^^^^^^^^^^^^^^^^^
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/alembic/operations/base.py", line 442, in
invoke
2024-07-13 15:34:08 return fn(self, operation)
2024-07-13 15:34:08 ^^^^^^^^^^^^^^^^^^^
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/alembic/operations/toimpl.py", line 131, in
create_table
2024-07-13 15:34:08 operations.impl.create_table(table)
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/alembic/ddl/impl.py", line 369, in
create_table
2024-07-13 15:34:08 self._exec(schema.CreateTable(table))
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/alembic/ddl/impl.py", line 210, in _exec
2024-07-13 15:34:08 return conn.execute(construct, params)
2024-07-13 15:34:08 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1385, in
execute
2024-07-13 15:34:08 return meth(self, multiparams, params,
_EMPTY_EXECUTION_OPTS)
2024-07-13 15:34:08
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/sqlalchemy/sql/ddl.py", line 80, in
_execute_on_connection
2024-07-13 15:34:08 return connection._execute_ddl(
2024-07-13 15:34:08 ^^^^^^^^^^^^^^^^^^^^^^^^
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1477, in
_execute_ddl
2024-07-13 15:34:08 ret = self._execute_context(
2024-07-13 15:34:08 ^^^^^^^^^^^^^^^^^^^^^^
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1953, in
_execute_context
2024-07-13 15:34:08 self._handle_dbapi_exception(
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2134, in
_handle_dbapi_exception
2024-07-13 15:34:08 util.raise_(
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/sqlalchemy/util/compat.py", line 211, in
raise_
2024-07-13 15:34:08 raise exception
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1910, in
_execute_context
2024-07-13 15:34:08 self.dialect.do_execute(
2024-07-13 15:34:08 File
"/usr/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 736, in
do_execute
2024-07-13 15:34:08 cursor.execute(statement, parameters)
2024-07-13 15:34:08 sqlalchemy.exc.ProgrammingError:
(psycopg2.errors.UndefinedTable) relation "ab_user" does not exist
2024-07-13 15:34:08
2024-07-13 15:34:08 [SQL:
2024-07-13 15:34:08 CREATE TABLE clusters (
2024-07-13 15:34:08 created_on TIMESTAMP WITHOUT TIME ZONE NOT NULL,
2024-07-13 15:34:08 changed_on TIMESTAMP WITHOUT TIME ZONE NOT NULL,
2024-07-13 15:34:08 id SERIAL NOT NULL,
2024-07-13 15:34:08 cluster_name VARCHAR(250),
2024-07-13 15:34:08 coordinator_host VARCHAR(255),
2024-07-13 15:34:08 coordinator_port INTEGER,
2024-07-13 15:34:08 coordinator_endpoint VARCHAR(255),
2024-07-13 15:34:08 broker_host VARCHAR(255),
2024-07-13 15:34:08 broker_port INTEGER,
2024-07-13 15:34:08 broker_endpoint VARCHAR(255),
2024-07-13 15:34:08 metadata_last_refreshed TIMESTAMP WITHOUT TIME ZONE,
2024-07-13 15:34:08 created_by_fk INTEGER,
2024-07-13 15:34:08 changed_by_fk INTEGER,
2024-07-13 15:34:08 PRIMARY KEY (id),
2024-07-13 15:34:08 UNIQUE (cluster_name),
2024-07-13 15:34:08 FOREIGN KEY(created_by_fk) REFERENCES ab_user (id),
2024-07-13 15:34:08 FOREIGN KEY(changed_by_fk) REFERENCES ab_user (id)
2024-07-13 15:34:08 )
2024-07-13 15:34:08
2024-07-13 15:34:08 ]
```
--
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]
