Make sure these boxes are checked before submitting your issue - thank you!
- [ ] I have checked the superset logs for python stacktraces and included it
here as text if any
- [ ] I have reproduced the issue with at least the latest released version of
superset
- [ ] I have checked the issue tracker for the same issue and I haven't found
one similar
### Superset version
[root@fcecsldbg02 ~]# superset version
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Superset 0.23.2
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
[root@fcecsldbg02 ~]# python -V
Python 2.7.13
[root@fcecsldbg02 ~]# sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 28 09:23:16 2018
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL>
create user superset and Give the following authority.
grant connect to superset;
grant create session to superset;
grant resource to superset;
grant CREATE MATERIALIZED VIEW to superset;
grant create any table to superset;
grant dba to superset;
### Expected results
Normal execution
### Actual results
[root@fcecsldbg02 ~]# superset db upgrade
INFO [alembic.runtime.migration] Context impl OracleImpl.
INFO [alembic.runtime.migration] Will assume non-transactional DDL.
INFO [alembic.runtime.migration] Running upgrade -> 4e6a06bad7a8, Init
INFO [alembic.runtime.migration] Running upgrade 4e6a06bad7a8 -> 5a7bad26f2a7,
empty message
INFO [alembic.runtime.migration] Running upgrade 5a7bad26f2a7 -> 1e2841a4128,
empty message
INFO [alembic.runtime.migration] Running upgrade 1e2841a4128 -> 2929af7925ed,
TZ offsets in data sources
INFO [alembic.runtime.migration] Running upgrade 2929af7925ed -> 289ce07647b,
Add encrypted password field
INFO [alembic.runtime.migration] Running upgrade 289ce07647b -> 1a48a5411020,
adding slug to dash
INFO [alembic.runtime.migration] Running upgrade 1a48a5411020 -> 315b3f4da9b0,
adding log model
INFO [alembic.runtime.migration] Running upgrade 315b3f4da9b0 -> 55179c7f25c7,
sqla_descr
INFO [alembic.runtime.migration] Running upgrade 55179c7f25c7 -> 12d55656cbca,
is_featured
INFO [alembic.runtime.migration] Running upgrade 12d55656cbca -> 2591d77e9831,
user_id
INFO [alembic.runtime.migration] Running upgrade 2591d77e9831 -> 8e80a26a31db,
empty message
INFO [alembic.runtime.migration] Running upgrade 8e80a26a31db -> 7dbf98566af7,
empty message
INFO [alembic.runtime.migration] Running upgrade 7dbf98566af7 -> 43df8de3a5f4,
empty message
INFO [alembic.runtime.migration] Running upgrade 43df8de3a5f4 -> d827694c7555,
css templates
INFO [alembic.runtime.migration] Running upgrade d827694c7555 -> 430039611635,
log more
INFO [alembic.runtime.migration] Running upgrade 430039611635 -> 18e88e1cc004,
making audit nullable
INFO [alembic.runtime.migration] Running upgrade 18e88e1cc004 -> 836c0bf75904,
cache_timeouts
INFO [alembic.runtime.migration] Running upgrade 18e88e1cc004 -> a2d606a761d9,
adding favstar model
INFO [alembic.runtime.migration] Running upgrade a2d606a761d9, 836c0bf75904 ->
d2424a248d63, empty message
INFO [alembic.runtime.migration] Running upgrade d2424a248d63 -> 763d4b211ec9,
fixing audit fk
INFO [alembic.runtime.migration] Running upgrade d2424a248d63 -> 1d2ddd543133,
log dt
INFO [alembic.runtime.migration] Running upgrade 1d2ddd543133, 763d4b211ec9 ->
fee7b758c130, empty message
INFO [alembic.runtime.migration] Running upgrade fee7b758c130 -> 867bf4f117f9,
Adding extra field to Database model
INFO [alembic.runtime.migration] Running upgrade 867bf4f117f9 -> bb51420eaf83,
add schema to table model
INFO [alembic.runtime.migration] Running upgrade bb51420eaf83 -> b4456560d4f3,
change_table_unique_constraint
INFO [alembic.runtime.migration] Running upgrade b4456560d4f3 -> 4fa88fe24e94,
owners_many_to_many
INFO [alembic.runtime.migration] Running upgrade 4fa88fe24e94 -> c3a8f8611885,
Materializing permission
Traceback (most recent call last):
File "/usr/local/python2.7/bin/superset", line 15, in <module>
manager.run()
File
"/usr/local/python2.7/lib/python2.7/site-packages/flask_script/__init__.py",
line 417, in run
result = self.handle(argv[0], argv[1:])
File
"/usr/local/python2.7/lib/python2.7/site-packages/flask_script/__init__.py",
line 386, in handle
res = handle(*args, **config)
File
"/usr/local/python2.7/lib/python2.7/site-packages/flask_script/commands.py",
line 216, in __call__
return self.run(*args, **kwargs)
File
"/usr/local/python2.7/lib/python2.7/site-packages/flask_migrate/__init__.py",
line 259, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "/usr/local/python2.7/lib/python2.7/site-packages/alembic/command.py",
line 254, in upgrade
script.run_env()
File
"/usr/local/python2.7/lib/python2.7/site-packages/alembic/script/base.py", line
427, in run_env
util.load_python_file(self.dir, 'env.py')
File
"/usr/local/python2.7/lib/python2.7/site-packages/alembic/util/pyfiles.py",
line 81, in load_python_file
module = load_module_py(module_id, path)
File
"/usr/local/python2.7/lib/python2.7/site-packages/alembic/util/compat.py", line
141, in load_module_py
mod = imp.load_source(module_id, path, fp)
File
"/usr/local/python2.7/lib/python2.7/site-packages/superset/migrations/env.py",
line 101, in <module>
run_migrations_online()
File
"/usr/local/python2.7/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
"/usr/local/python2.7/lib/python2.7/site-packages/alembic/runtime/environment.py",
line 836, in run_migrations
self.get_context().run_migrations(**kw)
File
"/usr/local/python2.7/lib/python2.7/site-packages/alembic/runtime/migration.py",
line 351, in run_migrations
% step)
alembic.util.exc.CommandError: Migration "upgrade 4fa88fe24e94 -> c3a8f8611885,
Materializing permission" has left an uncommitted transaction opened;
transactional_ddl is False so Alembic is not committing transactions
[root@fcecsldbg02 ~]#
### Steps to reproduce
[ Full content available at:
https://github.com/apache/incubator-superset/issues/5752 ]
This message was relayed via gitbox.apache.org for [email protected]
