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 2019/02/22 08:51:56 UTC
[GitHub] lhyundeadsoul opened a new issue #6931:
sqlalchemy.exc.NoSuchTableError occur when press 'Sync columns from
datasource' button
lhyundeadsoul opened a new issue #6931: sqlalchemy.exc.NoSuchTableError occur when press 'Sync columns from datasource' button
URL: https://github.com/apache/incubator-superset/issues/6931
<!--
Licensed to the Apache Software Foundation (ASF) under one
or more contributor license agreements. See the NOTICE file
distributed with this work for additional information
regarding copyright ownership. The ASF licenses this file
to you under the Apache License, Version 2.0 (the
"License"); you may not use this file except in compliance
with the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing,
software distributed under the License is distributed on an
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
KIND, either express or implied. See the License for the
specific language governing permissions and limitations
under the License.
-->
Make sure these boxes are checked before submitting your issue - thank you!
- [x] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [x] I have reproduced the issue with at least the latest released version of superset.
- [x] I have checked the issue tracker for the same issue and I haven't found one similar.
### Superset version
0.999.0dev ` more ./superset/assets/package.json``installed by docker `
### Expected results
I would like to sync superset table columns from datasource table columns because of new column addition in datasource.
![image](https://user-images.githubusercontent.com/5850103/53230280-4a05e880-36c1-11e9-8256-61805ad07147.png)
but when i press 'Sync columns from datasource' button, I got an error
`sqlalchemy.exc.NoSuchTableError: dwd_gd_trvl_frontdoor_sn_di`
nevertheless, table`dwd_gd_trvl_frontdoor_sn_di` is actually exsited.
### Actual results
> 2019-02-22 08:35:34,057:INFO:werkzeug:30.30.78.192 - - [22/Feb/2019 08:35:34] "GET /datasource/external_metadata/table/26/ HTTP/1.1" 500 -
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2309, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2295, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1741, in handle_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python3.6/site-packages/flask/_compat.py", line 35, in reraise
raise value
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2292, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1815, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1718, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python3.6/site-packages/flask/_compat.py", line 35, in reraise
raise value
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1813, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1799, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/home/superset/superset/views/datasource.py", line 42, in external_metadata
return self.json_response(orm_datasource.external_metadata())
File "/home/superset/superset/connectors/sqla/models.py", line 384, in external_metadata
cols = self.database.get_columns(self.table_name, schema=self.schema)
File "/home/superset/superset/models/core.py", line 1028, in get_columns
return self.inspector.get_columns(table_name, schema)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/reflection.py", line 369, in get_columns
**kw)
File "<string>", line 2, in get_columns
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/reflection.py", line 54, in cache
ret = fn(self, con, *args, **kw)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/dialects/postgresql/base.py", line 2512, in get_columns
info_cache=kw.get('info_cache'))
File "<string>", line 2, in get_table_oid
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/reflection.py", line 54, in cache
ret = fn(self, con, *args, **kw)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/dialects/postgresql/base.py", line 2438, in get_table_oid
raise exc.NoSuchTableError(table_name)
sqlalchemy.exc.NoSuchTableError: dwd_gd_trvl_frontdoor_sn_di
### Steps to reproduce
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org