We only run unit tests against MySQL, Postgres and SQLite. I did a bit of digging and this should help: https://github.com/apache/incubator-superset/pull/3256
Would you mind trying this patch against your Oracle environment? Max On Mon, Aug 7, 2017 at 10:52 AM, Lian Jiang <jiangok2...@gmail.com> wrote: > https://groups.google.com/forum/#!msg/sqlalchemy/kHoQTK1Zvyw/gHKpPnAIBAAJ > describes a similar issue. Is superset setup tested using oracle db? > Thanks. > > On Fri, Aug 4, 2017 at 10:40 PM, Lian Jiang <jiangok2...@gmail.com> wrote: > > > To scale superset, I am migrating the metadata from sqlite to oracle > > database. I used oracle connection string for SQLALCHEMY_DATABASE_URI in > > config.py but superset cannot start due to this error: > > > > > > Traceback (most recent call last): > > File "/Users/lianjia/repo/supersetdev/env/lib/python2.7/ > > site-packages/Flask_AppBuilder-1.9.1-py2.7.egg/ > flask_appbuilder/security/sqla/manager.py", > > line 74, in create_db > > inspector = Inspector.from_engine(engine) > > File "/Users/lianjia/repo/supersetdev/env/lib/python2.7/ > > site-packages/sqlalchemy/engine/reflection.py", line 135, in from_engine > > return Inspector(bind) > > File "/Users/lianjia/repo/supersetdev/env/lib/python2.7/ > > site-packages/sqlalchemy/engine/reflection.py", line 109, in __init__ > > bind.connect().close() > > File "/Users/lianjia/repo/supersetdev/env/lib/python2.7/ > > site-packages/sqlalchemy/engine/base.py", line 2091, in connect > > return self._connection_cls(self, **kwargs) > > File "/Users/lianjia/repo/supersetdev/env/lib/python2.7/ > > site-packages/sqlalchemy/engine/base.py", line 90, in __init__ > > if connection is not None else engine.raw_connection() > > File "/Users/lianjia/repo/supersetdev/env/lib/python2.7/ > > site-packages/sqlalchemy/engine/base.py", line 2177, in raw_connection > > self.pool.unique_connection, _connection) > > File "/Users/lianjia/repo/supersetdev/env/lib/python2.7/ > > site-packages/sqlalchemy/engine/base.py", line 2147, in > _wrap_pool_connect > > return fn() > > File "/Users/lianjia/repo/supersetdev/env/lib/python2.7/ > > site-packages/sqlalchemy/pool.py", line 328, in unique_connection > > return _ConnectionFairy._checkout(self) > > File "/Users/lianjia/repo/supersetdev/env/lib/python2.7/ > > site-packages/sqlalchemy/pool.py", line 804, in _checkout > > raise exc.InvalidRequestError("This connection is closed") > > InvalidRequestError: This connection is closed > > > > The exception seems to indicate something wrong with pooling. > > > > I have tested that a flask appbuilder app using the same oracle > connection > > string can start and create all metadata tables. Not sure what's > different > > for superset. Any clue? > > > > Appreciate so much! > > > > >
