JeanBaptisteINITIATIVES edited a comment on issue #9736:
URL:
https://github.com/apache/incubator-superset/issues/9736#issuecomment-623878554
> Please provide a detailed error description and/or log. What is the output
of 'superset db upgrade'? If it succeeded, did you also run 'superset init'
subsequently?
@rumbin , this is the error log when running 'superset db upgrade' AFTER
changing the config.py (my mistake...) 👍
```
logging was configured successfully
INFO:superset.utils.logging_configurator:logging was configured successfully
/home/superset/superset/lib/python3.6/site-packages/flask_caching/__init__.py:189:
UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively
disabled.
"Flask-Caching: CACHE_TYPE is set to null, "
INFO [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO [alembic.runtime.migration] Will assume transactional DDL.
INFO [alembic.runtime.migration] Running upgrade def97f26fdfb ->
11c737c17cc6, deprecate_restricted_metrics
INFO [alembic.runtime.migration] Running upgrade 11c737c17cc6 ->
258b5280a45e, form strip leading and trailing whitespace
INFO [alembic.runtime.migration] Running upgrade 258b5280a45e ->
1495eb914ad3, time range
INFO [alembic.runtime.migration] Running upgrade 1495eb914ad3 ->
b6fa807eac07, make_names_non_nullable
INFO [alembic.runtime.migration] Running upgrade b6fa807eac07 ->
cca2f5d568c8, add encrypted_extra to dbs
INFO [alembic.runtime.migration] Running upgrade cca2f5d568c8 ->
c2acd2cf3df2, alter type of dbs encrypted_extra
INFO [alembic.runtime.migration] Running upgrade c2acd2cf3df2 ->
78ee127d0d1d, reconvert legacy filters into adhoc
INFO [alembic.runtime.migration] Running upgrade 78ee127d0d1d ->
db4b49eb0782, Add tables for SQL Lab state
INFO [alembic.runtime.migration] Running upgrade db4b49eb0782 ->
5afa9079866a, serialize_schema_permissions.py
INFO [alembic.runtime.migration] Running upgrade 5afa9079866a ->
89115a40e8ea, Change table schema description to long text
INFO [alembic.runtime.migration] Running upgrade 89115a40e8ea ->
817e1c9b09d0, add_not_null_to_dbs_sqlalchemy_url
INFO [alembic.runtime.migration] Running upgrade 817e1c9b09d0 ->
e96dbf2cfef0, datasource_cluster_fk
Traceback (most recent call last):
File "/home/superset/superset/bin/superset", line 21, in <module>
superset()
File "/home/superset/superset/lib/python3.6/site-packages/click/core.py",
line 722, in __call__
return self.main(*args, **kwargs)
File "/home/superset/superset/lib/python3.6/site-packages/flask/cli.py",
line 586, in main
return super(FlaskGroup, self).main(*args, **kwargs)
File "/home/superset/superset/lib/python3.6/site-packages/click/core.py",
line 697, in main
rv = self.invoke(ctx)
File "/home/superset/superset/lib/python3.6/site-packages/click/core.py",
line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/home/superset/superset/lib/python3.6/site-packages/click/core.py",
line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/home/superset/superset/lib/python3.6/site-packages/click/core.py",
line 895, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/home/superset/superset/lib/python3.6/site-packages/click/core.py",
line 535, in invoke
return callback(*args, **kwargs)
File
"/home/superset/superset/lib/python3.6/site-packages/click/decorators.py", line
17, in new_func
return f(get_current_context(), *args, **kwargs)
File "/home/superset/superset/lib/python3.6/site-packages/flask/cli.py",
line 426, in decorator
return __ctx.invoke(f, *args, **kwargs)
File "/home/superset/superset/lib/python3.6/site-packages/click/core.py",
line 535, in invoke
return callback(*args, **kwargs)
File
"/home/superset/superset/lib/python3.6/site-packages/flask_migrate/cli.py",
line 134, in upgrade
_upgrade(directory, revision, sql, tag, x_arg)
File
"/home/superset/superset/lib/python3.6/site-packages/flask_migrate/__init__.py",
line 95, in wrapped
f(*args, **kwargs)
File
"/home/superset/superset/lib/python3.6/site-packages/flask_migrate/__init__.py",
line 280, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File
"/home/superset/superset/lib/python3.6/site-packages/alembic/command.py", line
298, in upgrade
script.run_env()
File
"/home/superset/superset/lib/python3.6/site-packages/alembic/script/base.py",
line 489, in run_env
util.load_python_file(self.dir, "env.py")
File
"/home/superset/superset/lib/python3.6/site-packages/alembic/util/pyfiles.py",
line 98, in load_python_file
module = load_module_py(module_id, path)
File
"/home/superset/superset/lib/python3.6/site-packages/alembic/util/compat.py",
line 173, in load_module_py
spec.loader.exec_module(module)
File "<frozen importlib._bootstrap_external>", line 678, in exec_module
File "<frozen importlib._bootstrap>", line 219, in
_call_with_frames_removed
File
"/home/superset/superset/lib/python3.6/site-packages/superset/migrations/env.py",
line 115, in <module>
run_migrations_online()
File
"/home/superset/superset/lib/python3.6/site-packages/superset/migrations/env.py",
line 107, in run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File
"/home/superset/superset/lib/python3.6/site-packages/alembic/runtime/environment.py",
line 846, in run_migrations
self.get_context().run_migrations(**kw)
File
"/home/superset/superset/lib/python3.6/site-packages/alembic/runtime/migration.py",
line 518, in run_migrations
step.migration_fn(**kw)
File
"/home/superset/superset/lib/python3.6/site-packages/superset/migrations/versions/e96dbf2cfef0_datasource_cluster_fk.py",
line 76, in upgrade
"fk_datasources_cluster_id_clusters", "clusters", ["cluster_id"], ["id"]
File "/usr/lib/python3.6/contextlib.py", line 88, in __exit__
next(self.gen)
File
"/home/superset/superset/lib/python3.6/site-packages/alembic/operations/base.py",
line 325, in batch_alter_table
impl.flush()
File
"/home/superset/superset/lib/python3.6/site-packages/alembic/operations/batch.py",
line 79, in flush
fn(*arg, **kw)
File
"/home/superset/superset/lib/python3.6/site-packages/alembic/ddl/impl.py", line
241, in drop_constraint
self._exec(schema.DropConstraint(const))
File
"/home/superset/superset/lib/python3.6/site-packages/alembic/ddl/impl.py", line
134, in _exec
return conn.execute(construct, *multiparams, **params)
File
"/home/superset/superset/lib/python3.6/site-packages/sqlalchemy/engine/base.py",
line 982, in execute
return meth(self, multiparams, params)
File
"/home/superset/superset/lib/python3.6/site-packages/sqlalchemy/sql/ddl.py",
line 72, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File
"/home/superset/superset/lib/python3.6/site-packages/sqlalchemy/engine/base.py",
line 1037, in _execute_ddl
else None,
File "<string>", line 1, in <lambda>
File
"/home/superset/superset/lib/python3.6/site-packages/sqlalchemy/sql/elements.py",
line 462, in compile
return self._compiler(dialect, bind=bind, **kw)
File
"/home/superset/superset/lib/python3.6/site-packages/sqlalchemy/sql/ddl.py",
line 29, in _compiler
return dialect.ddl_compiler(dialect, self, **kw)
File
"/home/superset/superset/lib/python3.6/site-packages/sqlalchemy/sql/compiler.py",
line 319, in __init__
self.string = self.process(self.statement, **compile_kwargs)
File
"/home/superset/superset/lib/python3.6/site-packages/sqlalchemy/sql/compiler.py",
line 350, in process
return obj._compiler_dispatch(self, **kwargs)
File
"/home/superset/superset/lib/python3.6/site-packages/sqlalchemy/ext/compiler.py",
line 436, in <lambda>
lambda *arg, **kw: existing(*arg, **kw),
File
"/home/superset/superset/lib/python3.6/site-packages/sqlalchemy/ext/compiler.py",
line 478, in __call__
return fn(element, compiler, **kw)
File
"/home/superset/superset/lib/python3.6/site-packages/sqlalchemy/ext/compiler.py",
line 423, in _wrap_existing_dispatch
return existing_dispatch(element, compiler, **kw)
File
"/home/superset/superset/lib/python3.6/site-packages/sqlalchemy/sql/visitors.py",
line 92, in _compiler_dispatch
return meth(self, **kw)
File
"/home/superset/superset/lib/python3.6/site-packages/sqlalchemy/sql/compiler.py",
line 3092, in visit_drop_constraint
"it has no name" % drop.element
sqlalchemy.exc.CompileError: Can't emit DROP CONSTRAINT for constraint
UniqueConstraint(); it has no name
```
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
