brachipa commented on pull request #9944:
URL:
https://github.com/apache/incubator-superset/pull/9944#issuecomment-702375245
Same for me, it doesn't work, also by trying `superset alert`
I see this exception in logs
```stacktrace
[2020-10-01 20:17:45,040: INFO/ForkPoolWorker-1] Processing alert ID: 2
[2020-10-01 20:17:45,042: DEBUG/ForkPoolWorker-1] Parsing with sqlparse
statement: select 1,0,5,55
[2020-10-01 20:17:45,044: INFO/ForkPoolWorker-1] Evaluating SQL for alert
<2:brachi>
[2020-10-01 20:17:45,045: DEBUG/ForkPoolWorker-1]
Database.get_sqla_engine(). Masked URL:
postgresql://superset:XXXXXXXXXX@db:5432/superset
[2020-10-01 20:17:45,054: INFO/ForkPoolWorker-1] Triggering alert: <2:brachi>
[2020-10-01 20:17:45,057: ERROR/ForkPoolWorker-1] Task
alerts.run_query[72f7c16b-ba6f-4836-916d-222fb3146641] raised unexpected:
OSError(99, 'Cannot assign requested address')
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/celery/app/trace.py", line
412, in trace_task
R = retval = fun(*args, **kwargs)
File "/app/superset/app.py", line 115, in __call__
return task_base.__call__(self, *args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/celery/app/trace.py", line
704, in __protected_call__
return self.run(*args, **kwargs)
File "/app/superset/tasks/schedules.py", line 554, in schedule_alert_query
if run_alert_query(schedule, dbsession):
File "/app/superset/tasks/schedules.py", line 648, in run_alert_query
deliver_alert(alert)
File "/app/superset/tasks/schedules.py", line 607, in deliver_alert
_deliver_email(alert.recipients, deliver_as_group, subject, body, data,
images)
File "/app/superset/tasks/schedules.py", line 132, in _deliver_email
dryrun=config["SCHEDULED_EMAIL_DEBUG_MODE"],
File "/app/superset/utils/core.py", line 787, in send_email_smtp
send_mime_email(smtp_mail_from, recipients, msg, config, dryrun=dryrun)
File "/app/superset/utils/core.py", line 808, in send_mime_email
else smtplib.SMTP(smtp_host, smtp_port)
File "/usr/local/lib/python3.6/smtplib.py", line 251, in __init__
(code, msg) = self.connect(host, port)
File "/usr/local/lib/python3.6/smtplib.py", line 336, in connect
self.sock = self._get_socket(host, port, self.timeout)
File "/usr/local/lib/python3.6/smtplib.py", line 307, in _get_socket
self.source_address)
File "/usr/local/lib/python3.6/socket.py", line 724, in create_connection
raise err
File "/usr/local/lib/python3.6/socket.py", line 713, in create_connection
sock.connect(sa)
OSError: [Errno 99] Cannot assign requested address
```
----------------------------------------------------------------
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]
