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 2020/07/19 04:16:44 UTC
[GitHub] [incubator-superset] labelhero opened a new issue #10364: Superset upgrade from 0.35 to 0.36 failed
labelhero opened a new issue #10364:
URL: https://github.com/apache/incubator-superset/issues/10364
A clear and concise description of what the bug is.
### Expected results
Upgraded to 0.36 version with existing dashboards, charts, databases, users etc.,
### Actual results
Failed "superset db upgrade"
#### Screenshots
If applicable, add screenshots to help explain your problem.
#### How to reproduce the bug
1. pip install apache-superset upgrade
2. superset db upgrade
3. I see there are new fields added to "tables", "dbs","slices" which is causing issue.
4. Unable to retain dashboards and charts.
Error:
```
INFO:superset.utils.logging_configurator:logging was configured successfully
/usr/local/lib/python3.6/site-packages/flask_caching/__init__.py:202: UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively disabled.
"Flask-Caching: CACHE_TYPE is set to null, "
/usr/local/lib/python3.6/site-packages/pymysql/cursors.py:170: Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.")
result = self._query(query)
DEBUG:asyncio:Using selector: EpollSelector
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1278, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.6/site-packages/pymysql/cursors.py", line 170, in execute
result = self._query(query)
File "/usr/local/lib/python3.6/site-packages/pymysql/cursors.py", line 328, in _query
conn.query(q)
File "/usr/local/lib/python3.6/site-packages/pymysql/connections.py", line 517, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.6/site-packages/pymysql/connections.py", line 732, in _read_query_result
result.read()
File "/usr/local/lib/python3.6/site-packages/pymysql/connections.py", line 1075, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.6/site-packages/pymysql/connections.py", line 684, in _read_packet
packet.check_error()
File "/usr/local/lib/python3.6/site-packages/pymysql/protocol.py", line 220, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.6/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (1054, "Unknown column 'dbs.server_cert' in 'field list'")
```
### Environment
(please complete the following information):
- superset version: `0.35`
- python version: `3.6`
- Mysql 8.0.17
### Checklist
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.
### Additional context
Manually updating each table is tedious task.
How to upgrade to latest version of superset without manually updating the Mysql tables?
----------------------------------------------------------------
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.
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] [incubator-superset] tierzhang commented on issue #10364: Superset upgrade from 0.35 to 0.36 failed
Posted by GitBox <gi...@apache.org>.
tierzhang commented on issue #10364:
URL: https://github.com/apache/incubator-superset/issues/10364#issuecomment-661578951
I have a "runtime error Working outside of application context." and "flask-caching cache_type is set to null" bug too about v0.36 after installation, however v0.35.2 has no error or bug under the same environment.
When I using v0.36, Superset could run development mode on localhost, but it can't run by uwsgi for network-use.
Probably there are something wrong with packages of v0.36?
## Environment:
CentOS 8
Python 3.6
PostgreSQL 12
----------------------------------------------------------------
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.
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] [incubator-superset] dbech commented on issue #10364: Superset upgrade from 0.35 to 0.36 failed
Posted by GitBox <gi...@apache.org>.
dbech commented on issue #10364:
URL: https://github.com/apache/incubator-superset/issues/10364#issuecomment-664099322
@labelhero I'm having the same problem, did you ever find a solution? Or even just a copy of what the database schema should be?
----------------------------------------------------------------
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.
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] [incubator-superset] stale[bot] commented on issue #10364: Superset upgrade from 0.35 to 0.36 failed
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #10364:
URL: https://github.com/apache/incubator-superset/issues/10364#issuecomment-734495187
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue `.pinned` to prevent stale bot from closing the issue.
----------------------------------------------------------------
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.
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] [incubator-superset] dbech commented on issue #10364: Superset upgrade from 0.35 to 0.36 failed
Posted by GitBox <gi...@apache.org>.
dbech commented on issue #10364:
URL: https://github.com/apache/incubator-superset/issues/10364#issuecomment-665376698
I attempted a manual database migration also by spinning up a fresh install of 0.36 and comparing the database to my own. I got it pretty close to working but it seems like there's some data that needs to be encrypted now which I couldn't correct.
Best of luck with your attempt
----------------------------------------------------------------
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.
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] [incubator-superset] labelhero commented on issue #10364: Superset upgrade from 0.35 to 0.36 failed
Posted by GitBox <gi...@apache.org>.
labelhero commented on issue #10364:
URL: https://github.com/apache/incubator-superset/issues/10364#issuecomment-665353099
@mistercrunch I uninstalled pymysql and install mysqlclient but issue still persists. @dbech no solution as of now, however planning some workarounds like manual db migrations.
```
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1278, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 206, in execute
res = self._query(query)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 319, in _query
db.query(q)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 259, in query
_mysql.connection.query(self, query)
MySQLdb._exceptions.OperationalError: (1054, "Unknown column 'dbs.server_cert' in 'field list'")
```
----------------------------------------------------------------
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.
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] [incubator-superset] issue-label-bot[bot] commented on issue #10364: Superset upgrade from 0.35 to 0.36 failed
Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #10364:
URL: https://github.com/apache/incubator-superset/issues/10364#issuecomment-660584057
Issue-Label Bot is automatically applying the label `#bug` to this issue, with a confidence of 0.87. Please mark this comment with :thumbsup: or :thumbsdown: to give our bot feedback!
Links: [app homepage](https://github.com/marketplace/issue-label-bot), [dashboard](https://mlbot.net/data/apache/incubator-superset) and [code](https://github.com/hamelsmu/MLapp) for this bot.
----------------------------------------------------------------
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.
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] [incubator-superset] labelhero commented on issue #10364: Superset upgrade from 0.35 to 0.36 failed
Posted by GitBox <gi...@apache.org>.
labelhero commented on issue #10364:
URL: https://github.com/apache/incubator-superset/issues/10364#issuecomment-663599560
Can someone please help here..
----------------------------------------------------------------
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.
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] [incubator-superset] mistercrunch commented on issue #10364: Superset upgrade from 0.35 to 0.36 failed
Posted by GitBox <gi...@apache.org>.
mistercrunch commented on issue #10364:
URL: https://github.com/apache/incubator-superset/issues/10364#issuecomment-663788083
I also see `dbs.server_cert` which looks like a local fork thing as it's not in our fork as far as I can tell.
----------------------------------------------------------------
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.
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] [incubator-superset] labelhero commented on issue #10364: Superset upgrade from 0.35 to 0.36 failed
Posted by GitBox <gi...@apache.org>.
labelhero commented on issue #10364:
URL: https://github.com/apache/incubator-superset/issues/10364#issuecomment-694978522
Hi,
Can someone please provide update here. Do you think upgrading to 0.37.1 version fixes anything here?
@dbech were you able to solve this issue?
----------------------------------------------------------------
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.
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] [incubator-superset] dbech commented on issue #10364: Superset upgrade from 0.35 to 0.36 failed
Posted by GitBox <gi...@apache.org>.
dbech commented on issue #10364:
URL: https://github.com/apache/incubator-superset/issues/10364#issuecomment-697291442
I wasn't able to solve the issue, I ended up moving to a different product
----------------------------------------------------------------
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.
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] [incubator-superset] mistercrunch commented on issue #10364: Superset upgrade from 0.35 to 0.36 failed
Posted by GitBox <gi...@apache.org>.
mistercrunch commented on issue #10364:
URL: https://github.com/apache/incubator-superset/issues/10364#issuecomment-663787913
Is see `pymysql`, I think we recommend `mysqlclient` ...
----------------------------------------------------------------
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.
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