Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Editing an existing schedule for Chart Email Delivery breaks with an error #8926

Open
visakhmurukes opened this issue Jan 6, 2020 · 7 comments
Open
Labels

Comments

@visakhmurukes
Copy link

@visakhmurukes visakhmurukes commented Jan 6, 2020

Try to modify the schedule of a chart added for email delivery

Expected results

The schedule will get modified based on given input

Actual results

Getting below error

Screenshots

supsersetsched

How to reproduce the bug

Go to Manage -> Chart Email Schedule
Click on edit record option for an existing schedule
Modify the given schedule
On save you get error as given below

Environment

(please complete the following information):

superset version: 0.33.0rc1
python version: 3.6.9

Checklist

Make sure these boxes are checked before submitting your issue - thank you!

  • I have checked the superset logs for python stacktraces and included it here as text if there are any.
  • I have reproduced the issue with at least the latest released version of superset.
  • I have checked the issue tracker for the same issue and I haven't found one similar.

Additional context

Add any other context about the problem here.

@issue-label-bot issue-label-bot bot added the #bug label Jan 6, 2020
@issue-label-bot

This comment has been minimized.

Copy link

@issue-label-bot issue-label-bot bot commented Jan 6, 2020

Issue-Label Bot is automatically applying the label #bug to this issue, with a confidence of 0.95. Please mark this comment with 👍 or 👎 to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

@blcksrx

This comment has been minimized.

Copy link
Contributor

@blcksrx blcksrx commented Jan 6, 2020

Please Update your superset version and the error will be fixed!

@visakhmurukes

This comment has been minimized.

Copy link
Author

@visakhmurukes visakhmurukes commented Jan 8, 2020

Please Update your superset version and the error will be fixed!

I updated. Now the above issue is gone. But instead lots of other functionalities are breaking
Like rendering chart, refreshing druid datasource etc
The error seems to be consistent and is in lines of the below

Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1246, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 581, in do_execute
cursor.execute(statement, parameters)
psycopg2.ProgrammingError: column metrics.is_restricted does not exist
LINE 1: ...type, metrics.description AS metrics_description, metrics.is...

Looks like issue with metadata objects stored in sqlite

@blcksrx

This comment has been minimized.

Copy link
Contributor

@blcksrx blcksrx commented Jan 8, 2020

Actually because of you need to migrate you database to the latest version. Please be sure to follow the documentation

@visakhmurukes

This comment has been minimized.

Copy link
Author

@visakhmurukes visakhmurukes commented Jan 9, 2020

how to migrate the database to latest version?
Can you please point me to the correct documentation?
my superset instance is using postgre as the metadatastore

@blcksrx

This comment has been minimized.

Copy link
Contributor

@blcksrx blcksrx commented Jan 9, 2020

@visakhmurukes

This comment has been minimized.

Copy link
Author

@visakhmurukes visakhmurukes commented Jan 10, 2020

Ok. I finally created a new copy of the db after the upgrade and then it worked. Otherwise it was giving above error.
In my case the metadatastore was initially setup in postgre

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
2 participants
You can’t perform that action at this time.