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/08/06 14:48:14 UTC
[GitHub] [incubator-superset] ganesh8614 commented on issue #5294: [SIP-3]
Scheduled email reports for Slices / Dashboards
ganesh8614 commented on issue #5294: [SIP-3] Scheduled email reports for Slices / Dashboards
URL: https://github.com/apache/incubator-superset/pull/5294#issuecomment-518702591
> @mahendra I tried the email report feature, i am not seeing any errors in the geckodriver.log or nohup for celery worker or superset logs. But i am not getting any emails sent. I checked
> send_email_smtp('[recipient@gmail.com](mailto:recipient@gmail.com)', 'Hello', 'Test content', app.config)
> is sending the email . So my email configuration is working. Where else should i look for issues?
After performing the configuration tried to run the below command and getting the error:
celery worker --app=superset.tasks.celery_app:app --pool=prefork -Ofair -c 4
******Error Details************************
_sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: BEGIN IMMEDIATE TRANSACTION]
(Background on this error at: http://sqlalche.me/e/e3q8)
[2019-08-06 20:15:27,255: WARNING/MainProcess] consumer: Connection to broker lost. Trying to re-establish the connection...
Traceback (most recent call last):
File "d:\apache_superset\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1244, in _execute_context
cursor, statement, parameters, context
File "d:\apache_superset\venv\lib\site-packages\sqlalchemy\engine\default.py", line 552, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: database is locked
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "d:\apache_superset\venv\lib\site-packages\celery\worker\consumer\consumer.py", line 318, in start
blueprint.start(self)
File "d:\apache_superset\venv\lib\site-packages\celery\bootsteps.py", line 119, in start
step.start(parent)
File "d:\apache_superset\venv\lib\site-packages\celery\worker\consumer\consumer.py", line 596, in start
c.loop(*c.loop_args())
File "d:\apache_superset\venv\lib\site-packages\celery\worker\loops.py", line 121, in synloop
connection.drain_events(timeout=2.0)
File "d:\apache_superset\venv\lib\site-packages\kombu\connection.py", line 315, in drain_events
return self.transport.drain_events(self.connection, **kwargs)
File "d:\apache_superset\venv\lib\site-packages\kombu\transport\virtual\base.py", line 963, in drain_events
get(self._deliver, timeout=timeout)
File "d:\apache_superset\venv\lib\site-packages\kombu\utils\scheduling.py", line 56, in get
return self.fun(resource, callback, **kwargs)
File "d:\apache_superset\venv\lib\site-packages\kombu\transport\virtual\base.py", line 1001, in _drain_channel
return channel.drain_events(callback=callback, timeout=timeout)
File "d:\apache_superset\venv\lib\site-packages\kombu\transport\virtual\base.py", line 745, in drain_events
return self._poll(self.cycle, callback, timeout=timeout)
File "d:\apache_superset\venv\lib\site-packages\kombu\transport\virtual\base.py", line 402, in _poll
return cycle.get(callback)
File "d:\apache_superset\venv\lib\site-packages\kombu\utils\scheduling.py", line 56, in get
return self.fun(resource, callback, **kwargs)
File "d:\apache_superset\venv\lib\site-packages\kombu\transport\virtual\base.py", line 405, in _get_and_deliver
message = self._get(queue)
File "d:\apache_superset\venv\lib\site-packages\kombu\transport\sqlalchemy\__init__.py", line 96, in _get
self.session.execute('BEGIN IMMEDIATE TRANSACTION')
File "d:\apache_superset\venv\lib\site-packages\sqlalchemy\orm\session.py", line 1269, in execute
clause, params or {}
File "d:\apache_superset\venv\lib\site-packages\sqlalchemy\engine\base.py", line 988, in execute
return meth(self, multiparams, params)
File "d:\apache_superset\venv\lib\site-packages\sqlalchemy\sql\elements.py", line 287, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "d:\apache_superset\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1107, in _execute_clauseelement
distilled_params,
File "d:\apache_superset\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1248, in _execute_context
e, statement, parameters, cursor, context
File "d:\apache_superset\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1466, in _handle_dbapi_exception
util.raise_from_cause(sqlalchemy_exception, exc_info)
File "d:\apache_superset\venv\lib\site-packages\sqlalchemy\util\compat.py", line 398, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "d:\apache_superset\venv\lib\site-packages\sqlalchemy\util\compat.py", line 152, in reraise
raise value.with_traceback(tb)
File "d:\apache_superset\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1244, in _execute_context
cursor, statement, parameters, context
File "d:\apache_superset\venv\lib\site-packages\sqlalchemy\engine\default.py", line 552, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: BEGIN IMMEDIATE TRANSACTION]
(Background on this error at: http://sqlalche.me/e/e3q8)_
Thanks
Ganesh
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org