[GitHub] jgbolger opened a new issue #3464: Issue using Oracle DB as superset database - Error running a migration script

[gi...@git.apache.org]

jgbolger opened a new issue #3464: Issue using Oracle DB as superset database - Error running a migration script
URL: https://github.com/apache/incubator-superset/issues/3464
 
 
   Make sure these boxes are checked before submitting your issue - thank you!
   
   - [i] I have checked the superset logs for python stacktraces and included it here as text if any
   - [i] I have reproduced the issue with at least the latest released version of superset
   - [i] I have checked the issue tracker for the same issue and I haven't found one similar
   
   
   ### Superset version
   0.19.1
   
   ### Expected results
   "superset db upgrade" command completes
   
   ### Actual results
   Error running one of the migration scripts
   
   It is worth noting that this works fine when I use the default SQL Lite instance. It is only when I change to use Oracle.
   
   ### Steps to reproduce
   **1. Set db connection in superset_config.py**
   SQLALCHEMY_DATABASE_URI = 'oracle://user:password@hostname:1521/XE'
   
   Oracle db instance is Oracle XE 11g.
   
   **2. Run superset db upgrade
   
   Log error:
   
   > Loaded your LOCAL configuration at [/etc/superset/superset_config.py]
   > 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/bin/superset", line 15, in <module>
   >     manager.run()
   >   File "/usr/local/lib/python3.6/site-packages/flask_script/__init__.py", line 412, in run
   >     result = self.handle(sys.argv[0], sys.argv[1:])
   >   File "/usr/local/lib/python3.6/site-packages/flask_script/__init__.py", line 383, in handle
   >     res = handle(*args, **config)
   >   File "/usr/local/lib/python3.6/site-packages/flask_script/commands.py", line 216, in __call__
   >     return self.run(*args, **kwargs)
   >   File "/usr/local/lib/python3.6/site-packages/flask_migrate/__init__.py", line 244, in upgrade
   >     command.upgrade(config, revision, sql=sql, tag=tag)
   >   File "/usr/local/lib/python3.6/site-packages/alembic/command.py", line 254, in upgrade
   >     script.run_env()
   >   File "/usr/local/lib/python3.6/site-packages/alembic/script/base.py", line 425, in run_env
   >     util.load_python_file(self.dir, 'env.py')
   >   File "/usr/local/lib/python3.6/site-packages/alembic/util/pyfiles.py", line 93, in load_python_file
   >     module = load_module_py(module_id, path)
   >   File "/usr/local/lib/python3.6/site-packages/alembic/util/compat.py", line 64, in load_module_py
   >     module_id, path).load_module(module_id)
   >   File "<frozen importlib._bootstrap_external>", line 399, in _check_name_wrapper
   >   File "<frozen importlib._bootstrap_external>", line 823, in load_module
   >   File "<frozen importlib._bootstrap_external>", line 682, in load_module
   >   File "<frozen importlib._bootstrap>", line 251, in _load_module_shim
   >   File "<frozen importlib._bootstrap>", line 675, in _load
   >   File "<frozen importlib._bootstrap>", line 655, in _load_unlocked
   >   File "<frozen importlib._bootstrap_external>", line 678, in exec_module
   >   File "<frozen importlib._bootstrap>", line 205, in _call_with_frames_removed
   >   File "/usr/local/lib/python3.6/site-packages/superset/migrations/env.py", line 101, in <module>
   >     run_migrations_online()
   >   File "/usr/local/lib/python3.6/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/lib/python3.6/site-packages/alembic/runtime/environment.py", line 836, in run_migrations
   >     self.get_context().run_migrations(**kw)
   >   File "/usr/local/lib/python3.6/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 tran
   > sactions
   > 
 
----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services