PRamia commented on issue #5294: [SIP-3] Scheduled email reports for Slices / Dashboards URL: https://github.com/apache/incubator-superset/pull/5294#issuecomment-584639038 > > @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('[[email protected]](mailto:[email protected])', '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 i am getting the same error. Could you (or other smart guy) how to fix this issue? trying hard to get the Emails working but no way.
---------------------------------------------------------------- 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] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
