You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2022/02/27 11:05:01 UTC

[GitHub] [superset] balsilliy opened a new issue #18954: An error occurred while creating datasets: Fatal error

balsilliy opened a new issue #18954:
URL: https://github.com/apache/superset/issues/18954


   Envs: docker superset 1.4.1  + clickhouse
   when add dataset from clickhouse, An error occurred while creating datasets: Fatal error
   clickhouse database created by :  MaterializeMySQL from mysql
   
   2022-02-27 10:53:51,412:ERROR:root:'NoneType' object has no attribute 'reflect'
   Traceback (most recent call last):
     File "/usr/local/lib/python3.8/site-packages/flask_appbuilder/api/__init__.py", line 85, in wraps
       return f(self, *args, **kwargs)
     File "/usr/local/lib/python3.8/site-packages/superset/views/base_api.py", line 85, in wraps
       raise ex
     File "/usr/local/lib/python3.8/site-packages/superset/views/base_api.py", line 82, in wraps
       duration, response = time_function(f, self, *args, **kwargs)
     File "/usr/local/lib/python3.8/site-packages/superset/utils/core.py", line 1468, in time_function
       response = func(*args, **kwargs)
     File "/usr/local/lib/python3.8/site-packages/superset/utils/log.py", line 242, in wrapper
       value = f(*args, **kwargs)
     File "/usr/local/lib/python3.8/site-packages/superset/datasets/api.py", line 252, in post
       new_model = CreateDatasetCommand(g.user, item).run()
     File "/usr/local/lib/python3.8/site-packages/superset/datasets/commands/create.py", line 46, in run
       self.validate()
     File "/usr/local/lib/python3.8/site-packages/superset/datasets/commands/create.py", line 86, in validate
       if database and not DatasetDAO.validate_table_exists(
     File "/usr/local/lib/python3.8/site-packages/superset/datasets/dao.py", line 81, in validate_table_exists
       database.get_table(table_name, schema=schema)
     File "/usr/local/lib/python3.8/site-packages/superset/models/core.py", line 645, in get_table
       return Table(
     File "<string>", line 2, in __new__
     File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/deprecations.py", line 139, in warned
       return fn(*args, **kwargs)
     File "/usr/local/lib/python3.8/site-packages/sqlalchemy/sql/schema.py", line 563, in __new__
       metadata._remove_table(name, schema)
     File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
       compat.raise_(
     File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
       raise exception
     File "/usr/local/lib/python3.8/site-packages/sqlalchemy/sql/schema.py", line 558, in __new__
       table._init(name, metadata, *args, **kw)
     File "/usr/local/lib/python3.8/site-packages/sqlalchemy/sql/schema.py", line 647, in _init
       self._autoload(
     File "/usr/local/lib/python3.8/site-packages/sqlalchemy/sql/schema.py", line 670, in _autoload
       autoload_with.run_callable(
     File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2212, in run_callable
       return conn.run_callable(callable_, *args, **kwargs)
     File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1653, in run_callable
       return callable_(self, *args, **kwargs)
     File "/usr/local/lib/python3.8/site-packages/clickhouse_sqlalchemy/drivers/base.py", line 829, in reflecttable
       self._reflect_engine(connection, table.name, table)
     File "/usr/local/lib/python3.8/site-packages/clickhouse_sqlalchemy/drivers/base.py", line 841, in _reflect_engine
       engine = engine_cls.reflect(table, **e)
   AttributeError: 'NoneType' object has no attribute 'reflect'


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


[GitHub] [superset] balsilliy commented on issue #18954: clickhouse MaterializeMySQL An error occurred while creating datasets: Fatal error

Posted by GitBox <gi...@apache.org>.
balsilliy commented on issue #18954:
URL: https://github.com/apache/superset/issues/18954#issuecomment-1056040052


   ^_^


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


[GitHub] [superset] balsilliy commented on issue #18954: clickhouse MaterializeMySQL An error occurred while creating datasets: Fatal error

Posted by GitBox <gi...@apache.org>.
balsilliy commented on issue #18954:
URL: https://github.com/apache/superset/issues/18954#issuecomment-1055030242


   <img width="1108" alt="image" src="https://user-images.githubusercontent.com/26002425/156109399-0e36652d-806b-437a-8123-53c06805d229.png">
   


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org