hsebastian commented on issue #4142: OperationalError: (sqlite3.OperationalError) no such column: dbs.impersonate_user URL: https://github.com/apache/incubator-superset/issues/4142#issuecomment-354938220 I uninstalled superset and re-installed 0.19.1 with pip. ``` # pip freeze | grep superset superset==0.19.1 ``` When I run `superset db upgrade`, I get. ``` OR:flask_appbuilder.security.sqla.manager:Remove Permission from View Error: 'list' object has no attribute 'permission' 2018-01-03 12:01:49,128:ERROR:flask_appbuilder.security.sqla.manager:Remove Permission from View Error: 'list' object has no attribute 'permission' 2018-01-03 12:01:49,334:ERROR:flask_appbuilder.security.sqla.manager:Remove Permission from View Error: 'list' object has no attribute 'permission' 2018-01-03 12:01:49,632:ERROR:flask_appbuilder.security.sqla.manager:Remove Permission from View Error: 'list' object has no attribute 'permission' 2018-01-03 12:01:49,679:ERROR:flask_appbuilder.security.sqla.manager:Remove Permission from View Error: 'list' object has no attribute 'permission' INFO [alembic.runtime.migration] Context impl SQLiteImpl. INFO [alembic.runtime.migration] Will assume transactional DDL. Traceback (most recent call last): File "/home/ubuntu/work/venv/bin/superset", line 15, in <module> manager.run() File "/home/ubuntu/work/venv/local/lib/python2.7/site-packages/flask_script/__init__.py", line 412, in run result = self.handle(sys.argv[0], sys.argv[1:]) File "/home/ubuntu/work/venv/local/lib/python2.7/site-packages/flask_script/__init__.py", line 383, in handle res = handle(*args, **config) File "/home/ubuntu/work/venv/local/lib/python2.7/site-packages/flask_script/commands.py", line 216, in __call__ return self.run(*args, **kwargs) File "/home/ubuntu/work/venv/local/lib/python2.7/site-packages/flask_migrate/__init__.py", line 244, in upgrade command.upgrade(config, revision, sql=sql, tag=tag) File "/home/ubuntu/work/venv/local/lib/python2.7/site-packages/alembic/command.py", line 254, in upgrade script.run_env() File "/home/ubuntu/work/venv/local/lib/python2.7/site-packages/alembic/script/base.py", line 425, in run_env util.load_python_file(self.dir, 'env.py') File "/home/ubuntu/work/venv/local/lib/python2.7/site-packages/alembic/util/pyfiles.py", line 81, in load_python_file module = load_module_py(module_id, path) File "/home/ubuntu/work/venv/local/lib/python2.7/site-packages/alembic/util/compat.py", line 141, in load_module_py mod = imp.load_source(module_id, path, fp) File "/home/ubuntu/work/venv/local/lib/python2.7/site-packages/superset/migrations/env.py", line 101, in <module> run_migrations_online() File "/home/ubuntu/work/venv/local/lib/python2.7/site-packages/superset/migrations/env.py", line 94, in run_migrations_online context.run_migrations() File "<string>", line 8, in run_migrations File "/home/ubuntu/work/venv/local/lib/python2.7/site-packages/alembic/runtime/environment.py", line 836, in run_migrations self.get_context().run_migrations(**kw) File "/home/ubuntu/work/venv/local/lib/python2.7/site-packages/alembic/runtime/migration.py", line 321, in run_migrations for step in self._migrations_fn(heads, self): File "/home/ubuntu/work/venv/local/lib/python2.7/site-packages/alembic/command.py", line 243, in upgrade return script._upgrade_revs(revision, rev) File "/home/ubuntu/work/venv/local/lib/python2.7/site-packages/alembic/script/base.py", line 338, in _upgrade_revs for script in reversed(list(revs)) File "/usr/lib/python2.7/contextlib.py", line 35, in __exit__ self.gen.throw(type, value, traceback) File "/home/ubuntu/work/venv/local/lib/python2.7/site-packages/alembic/script/base.py", line 174, in _catch_revision_errors compat.raise_from_cause(util.CommandError(resolution)) File "/home/ubuntu/work/venv/local/lib/python2.7/site-packages/alembic/util/compat.py", line 205, in raise_from_cause reraise(type(exception), exception, tb=exc_tb) File "/home/ubuntu/work/venv/local/lib/python2.7/site-packages/alembic/script/base.py", line 143, in _catch_revision_errors yield File "/home/ubuntu/work/venv/local/lib/python2.7/site-packages/alembic/script/base.py", line 334, in _upgrade_revs revs = list(revs) File "/home/ubuntu/work/venv/local/lib/python2.7/site-packages/alembic/script/revision.py", line 645, in _iterate_revisions requested_lowers = self.get_revisions(lower) File "/home/ubuntu/work/venv/local/lib/python2.7/site-packages/alembic/script/revision.py", line 299, in get_revisions return sum([self.get_revisions(id_elem) for id_elem in id_], ()) File "/home/ubuntu/work/venv/local/lib/python2.7/site-packages/alembic/script/revision.py", line 304, in get_revisions for rev_id in resolved_id) File "/home/ubuntu/work/venv/local/lib/python2.7/site-packages/alembic/script/revision.py", line 304, in <genexpr> for rev_id in resolved_id) File "/home/ubuntu/work/venv/local/lib/python2.7/site-packages/alembic/script/revision.py", line 362, in _revision_for_ident resolved_id) alembic.util.exc.CommandError: Can't locate revision identified by '4736ec66ce19' ``` And then I upgraded to the latest version and run the migrations again. I still get `OperationalError: (sqlite3.OperationalError) no such column: dbs.impersonate_user `. @xrmx @mistercrunch any thoughts on what I can try next?
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
