singh-ab opened a new issue #12871:
URL: https://github.com/apache/superset/issues/12871
Chart Emails functionality doesn't work after upgrading to superset-1.0.0
### Expected results
Sent chart as an Attachment/Inline in an email to the recipient .
### Actual results
Log from Celery Worker
```
[2021-02-01 13:54:00,197: WARNING/MainProcess] Message: Failed to decode
response from marionette
, retrying in 30 seconds...
Message: Tried to run command without establishing a connection
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/superset/utils/celery.py",
line 50, in session_scope
yield session
File "/usr/local/lib/python3.8/site-packages/superset/tasks/schedules.py",
line 522, in schedule_email_report
deliver_slice(
File "/usr/local/lib/python3.8/site-packages/superset/tasks/schedules.py",
line 456, in deliver_slice
report_content = _get_slice_visualization(slc, delivery_type, session)
File "/usr/local/lib/python3.8/site-packages/superset/tasks/schedules.py",
line 417, in _get_slice_visualization
element = retry_call(
File "/usr/local/lib/python3.8/site-packages/retry/api.py", line 101, in
retry_call
return __retry_internal(partial(f, *args, **kwargs), exceptions, tries,
delay, max_delay, backoff, jitter, logger)
File "/usr/local/lib/python3.8/site-packages/retry/api.py", line 33, in
__retry_internal
return f()
File
"/usr/local/lib/python3.8/site-packages/selenium/webdriver/remote/webdriver.py",
line 564, in find_element_by_class_name
return self.find_element(by=By.CLASS_NAME, value=name)
File
"/usr/local/lib/python3.8/site-packages/selenium/webdriver/remote/webdriver.py",
line 976, in find_element
return self.execute(Command.FIND_ELEMENT, {
File
"/usr/local/lib/python3.8/site-packages/selenium/webdriver/remote/webdriver.py",
line 321, in execute
self.error_handler.check_response(response)
File
"/usr/local/lib/python3.8/site-packages/selenium/webdriver/remote/errorhandler.py",
line 242, in check_response
raise exception_class(message, screen, stacktrace)
selenium.common.exceptions.InvalidSessionIdException: Message: Tried to run
command without establishing a connection
[2021-02-01 13:54:30,174: ERROR/MainProcess] Message: Tried to run command
without establishing a connection
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/superset/utils/celery.py",
line 50, in session_scope
yield session
File "/usr/local/lib/python3.8/site-packages/superset/tasks/schedules.py",
line 522, in schedule_email_report
deliver_slice(
File "/usr/local/lib/python3.8/site-packages/superset/tasks/schedules.py",
line 456, in deliver_slice
report_content = _get_slice_visualization(slc, delivery_type, session)
File "/usr/local/lib/python3.8/site-packages/superset/tasks/schedules.py",
line 417, in _get_slice_visualization
element = retry_call(
File "/usr/local/lib/python3.8/site-packages/retry/api.py", line 101, in
retry_call
return __retry_internal(partial(f, *args, **kwargs), exceptions, tries,
delay, max_delay, backoff, jitter, logger)
File "/usr/local/lib/python3.8/site-packages/retry/api.py", line 33, in
__retry_internal
return f()
File
"/usr/local/lib/python3.8/site-packages/selenium/webdriver/remote/webdriver.py",
line 564, in find_element_by_class_name
return self.find_element(by=By.CLASS_NAME, value=name)
File
"/usr/local/lib/python3.8/site-packages/selenium/webdriver/remote/webdriver.py",
line 976, in find_element
return self.execute(Command.FIND_ELEMENT, {
File
"/usr/local/lib/python3.8/site-packages/selenium/webdriver/remote/webdriver.py",
line 321, in execute
self.error_handler.check_response(response)
File
"/usr/local/lib/python3.8/site-packages/selenium/webdriver/remote/errorhandler.py",
line 242, in check_response
raise exception_class(message, screen, stacktrace)
selenium.common.exceptions.InvalidSessionIdException: Message: Tried to run
command without establishing a connection
[2021-02-01 13:54:30,188: ERROR/MainProcess] Task
email_reports.send[0cd34623-3dcb-4b90-91c2-8583247959ba] raised unexpected:
InvalidSessionIdException('Tried to run command without establishing a
connection', None, None)
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/celery/app/trace.py", line
412, in trace_task
R = retval = fun(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/superset/app.py", line 116,
in __call__
return task_base.__call__(self, *args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/celery/app/trace.py", line
704, in __protected_call__
return self.run(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/superset/tasks/schedules.py",
line 522, in schedule_email_report
deliver_slice(
File "/usr/local/lib/python3.8/site-packages/superset/tasks/schedules.py",
line 456, in deliver_slice
report_content = _get_slice_visualization(slc, delivery_type, session)
File "/usr/local/lib/python3.8/site-packages/superset/tasks/schedules.py",
line 417, in _get_slice_visualization
element = retry_call(
File "/usr/local/lib/python3.8/site-packages/retry/api.py", line 101, in
retry_call
return __retry_internal(partial(f, *args, **kwargs), exceptions, tries,
delay, max_delay, backoff, jitter, logger)
File "/usr/local/lib/python3.8/site-packages/retry/api.py", line 33, in
__retry_internal
return f()
File
"/usr/local/lib/python3.8/site-packages/selenium/webdriver/remote/webdriver.py",
line 564, in find_element_by_class_name
return self.find_element(by=By.CLASS_NAME, value=name)
File
"/usr/local/lib/python3.8/site-packages/selenium/webdriver/remote/webdriver.py",
line 976, in find_element
return self.execute(Command.FIND_ELEMENT, {
File
"/usr/local/lib/python3.8/site-packages/selenium/webdriver/remote/webdriver.py",
line 321, in execute
self.error_handler.check_response(response)
File
"/usr/local/lib/python3.8/site-packages/selenium/webdriver/remote/errorhandler.py",
line 242, in check_response
raise exception_class(message, screen, stacktrace)
selenium.common.exceptions.InvalidSessionIdException: Message: Tried to run
command without establishing a connection
```
#### Screenshots
NA
### Environment
(please complete the following information):
- superset version: `1.0.0`
- python version: `3.8`
- Geckodriver version : `0.24.0`
The following flags are set to enable related functionalities:
```
ENABLE_SCHEDULED_EMAIL_REPORTS = True
EMAIL_NOTIFICATIONS = True
ENABLE_ALERTS = True
SMTP_HOST = "127.0.0.1"
SMTP_STARTTLS = True
SMTP_SSL = False
SMTP_USER = "superset"
SMTP_PORT = 25
SMTP_PASSWORD = "superset"
SMTP_MAIL_FROM = "[email protected]"
EMAIL_REPORTS_WEBDRIVER = 'firefox'
EMAIL_REPORTS_USER = 'admin'
WEBDRIVER_BASEURL = 'http://localhost:8088'
```
----------------------------------------------------------------
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:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
