prb219 opened a new issue #11610:
URL: https://github.com/apache/incubator-superset/issues/11610
Hi, I am trying to bring up superset version 0.37.2 while using sqlLite for
metadata. However, the service fails to start with an error
`sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table
sqlatable_user already exists1`
### Actual results
File "/appvenv/bin/superset", line 21, in <module>
superset()
File "/appvenv/lib/python3.6/site-packages/click/core.py", line 829, in
__call__
return self.main(*args, **kwargs)
File "/appvenv/lib/python3.6/site-packages/flask/cli.py", line 586, in main
return super(FlaskGroup, self).main(*args, **kwargs)
File "/appvenv/lib/python3.6/site-packages/click/core.py", line 782, in
main
rv = self.invoke(ctx)
File "/appvenv/lib/python3.6/site-packages/click/core.py", line 1259, in
invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/appvenv/lib/python3.6/site-packages/click/core.py", line 1259, in
invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/appvenv/lib/python3.6/site-packages/click/core.py", line 1066, in
invoke
return ctx.invoke(self.callback, **ctx.params)
File "/appvenv/lib/python3.6/site-packages/click/core.py", line 610, in
invoke
return callback(*args, **kwargs)
File "/appvenv/lib/python3.6/site-packages/click/decorators.py", line 21,
in new_func
return f(get_current_context(), *args, **kwargs)
File "/appvenv/lib/python3.6/site-packages/flask/cli.py", line 426, in
decorator
return __ctx.invoke(f, *args, **kwargs)
File "/appvenv/lib/python3.6/site-packages/click/core.py", line 610, in
invoke
return callback(*args, **kwargs)
File "/appvenv/lib/python3.6/site-packages/flask_migrate/cli.py", line
134, in upgrade
_upgrade(directory, revision, sql, tag, x_arg)
File "/appvenv/lib/python3.6/site-packages/flask_migrate/__init__.py",
line 96, in wrapped
f(*args, **kwargs)
File "/appvenv/lib/python3.6/site-packages/flask_migrate/__init__.py",
line 271, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "/appvenv/lib/python3.6/site-packages/alembic/command.py", line 298,
in upgrade
script.run_env()
File "/appvenv/lib/python3.6/site-packages/alembic/script/base.py", line
489, in run_env
util.load_python_file(self.dir, "env.py")
File "/appvenv/lib/python3.6/site-packages/alembic/util/pyfiles.py", line
98, in load_python_file
module = load_module_py(module_id, path)
File "/appvenv/lib/python3.6/site-packages/alembic/util/compat.py", line
184, 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 "/appvenv/lib/python3.6/site-packages/superset/migrations/env.py",
line 124, in <module>
run_migrations_online()
File "/appvenv/lib/python3.6/site-packages/superset/migrations/env.py",
line 116, in run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File
"/appvenv/lib/python3.6/site-packages/alembic/runtime/environment.py", line
846, in run_migrations
self.get_context().run_migrations(**kw)
File "/appvenv/lib/python3.6/site-packages/alembic/runtime/migration.py",
line 522, in run_migrations
step.migration_fn(**kw)
File
"/appvenv/lib/python3.6/site-packages/superset/migrations/versions/3e1b21cd94a4_change_owner_to_m2m_relation_on_.py",
line 75, in upgrade
sa.PrimaryKeyConstraint("id"),
File "<string>", line 8, in create_table
File "<string>", line 3, in create_table
File "/appvenv/lib/python3.6/site-packages/alembic/operations/ops.py",
line 1252, in create_table
return operations.invoke(op)
File "/appvenv/lib/python3.6/site-packages/alembic/operations/base.py",
line 373, in invoke
return fn(self, operation)
File "/appvenv/lib/python3.6/site-packages/alembic/operations/toimpl.py",
line 101, in create_table
operations.impl.create_table(table)
File "/appvenv/lib/python3.6/site-packages/alembic/ddl/impl.py", line 259,
in create_table
self._exec(schema.CreateTable(table))
File "/appvenv/lib/python3.6/site-packages/alembic/ddl/impl.py", line 141,
in _exec
return conn.execute(construct, *multiparams, **params)
File "/appvenv/lib/python3.6/site-packages/sqlalchemy/engine/base.py",
line 1011, in execute
return meth(self, multiparams, params)
File "/appvenv/lib/python3.6/site-packages/sqlalchemy/sql/ddl.py", line
72, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/appvenv/lib/python3.6/site-packages/sqlalchemy/engine/base.py",
line 1073, in _execute_ddl
compiled,
File "/appvenv/lib/python3.6/site-packages/sqlalchemy/engine/base.py",
line 1317, in _execute_context
e, statement, parameters, cursor, context
File "/appvenv/lib/python3.6/site-packages/sqlalchemy/engine/base.py",
line 1511, in _handle_dbapi_exception
sqlalchemy_exception, with_traceback=exc_info[2], from_=e
File "/appvenv/lib/python3.6/site-packages/sqlalchemy/util/compat.py",
line 182, in raise_
raise exception
File "/appvenv/lib/python3.6/site-packages/sqlalchemy/engine/base.py",
line 1277, in _execute_context
cursor, statement, parameters, context
File "/appvenv/lib/python3.6/site-packages/sqlalchemy/engine/default.py",
line 593, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table
sqlatable_user already exists
#### How to reproduce the bug
1. Try to bring up superset version 0.37.2
2. Configure sqlLite to store metadata info.
### Environment
- superset version: 0.37.2
- python version: python3.6
- node.js version: v10.23.0
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [ Y] I have checked the superset logs for python stacktraces and included
it here as text if there are any.
- [ Y] I have reproduced the issue with at least the latest released version
of superset.
- [ Y] I have checked the issue tracker for the same issue and I haven't
found one similar.
### Additional context
Add any other context about the problem here.
----------------------------------------------------------------
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]
