CWJ-NB opened a new issue #17755:
URL: https://github.com/apache/superset/issues/17755
`superset_config.py`，This is the configuration of the copied official
website.
```python
from celery.schedules import crontab
class CeleryConfig(object):
BROKER_URL = 'redis://localhost:6379/0'
CELERY_IMPORTS = (
'superset.sql_lab',
'superset.tasks',
)
CELERY_RESULT_BACKEND = 'redis://localhost:6379/0'
CELERYD_LOG_LEVEL = 'DEBUG'
CELERYD_PREFETCH_MULTIPLIER = 10
CELERY_ACKS_LATE = True
CELERY_ANNOTATIONS = {
'sql_lab.get_sql_results': {
'rate_limit': '100/s',
},
'email_reports.send': {
'rate_limit': '1/s',
'time_limit': 120,
'soft_time_limit': 150,
'ignore_result': True,
},
}
CELERYBEAT_SCHEDULE = {
'email_reports.schedule_hourly': {
'task': 'email_reports.schedule_hourly',
'schedule': crontab(minute=1, hour='*'),
},
}
CELERY_CONFIG = CeleryConfig
```
**Error message when executing celery**:
```
PS D:\Anaconda3\install\envs\superset_env\Lib\site-packages> celery
--app=superset.tasks.celery_app:app worker --pool=prefork -O fair -c 4
Loaded your LOCAL configuration at
[D:\Anaconda3\install\envs\superset_env\Lib\site-packages\superset_config.py]
logging was configured successfully
2021-12-15 10:53:53,421:INFO:superset.utils.logging_configurator:logging was
configured successfully
2021-12-15 10:53:53,439:INFO:root:Configured event logger of type <class
'superset.utils.log.DBEventLogger'>
-------------- celery@LAPTOP-49KFCB95 v4.4.6 (cliffs)
--- ***** -----
-- ******* ---- Windows-10-10.0.19041-SP0 2021-12-15 10:53:55
- *** --- * ---
- ** ---------- [config]
- ** ---------- .> app: __main__:0x208fe907748
- ** ---------- .> transport: redis://localhost:6379/0
- ** ---------- .> results: redis://localhost:6379/0
- *** --- * --- .> concurrency: 4 (prefork)
-- ******* ---- .> task events: OFF (enable -E to monitor tasks in this
worker)
--- ***** -----
-------------- [queues]
.> celery exchange=celery(direct) key=celery
[2021-12-15 10:53:59,319: ERROR/SpawnPoolWorker-4] Process SpawnPoolWorker-4
Traceback (most recent call last):
File
"D:\Anaconda3\install\envs\superset_env\Lib\site-packages\billiard\process.py",
line 327, in _bootstrap
self.run()
File
"D:\Anaconda3\install\envs\superset_env\Lib\site-packages\billiard\process.py",
line 114, in run
self._target(*self._args, **self._kwargs)
File
"D:\Anaconda3\install\envs\superset_env\Lib\site-packages\billiard\pool.py",
line 289, in __call__
self.after_fork()
File
"D:\Anaconda3\install\envs\superset_env\Lib\site-packages\billiard\pool.py",
line 421, in after_fork
self.initializer(*self.initargs)
File
"D:\Anaconda3\install\envs\superset_env\lib\site-packages\celery\concurrency\prefork.py",
line 55, in process_initializer
app.loader.init_worker()
File
"D:\Anaconda3\install\envs\superset_env\lib\site-packages\celery\loaders\base.py",
line 114, in init_worker
self.import_default_modules()
File
"D:\Anaconda3\install\envs\superset_env\lib\site-packages\celery\loaders\base.py",
line 109, in import_default_modules
return [self.import_task_module(m) for m in self.default_modules]
File
"D:\Anaconda3\install\envs\superset_env\lib\site-packages\celery\loaders\base.py",
line 109, in <listcomp>
return [self.import_task_module(m) for m in self.default_modules]
File
"D:\Anaconda3\install\envs\superset_env\lib\site-packages\celery\loaders\base.py",
line 89, in import_task_module
return self.import_from_cwd(module)
File
"D:\Anaconda3\install\envs\superset_env\lib\site-packages\celery\loaders\base.py",
line 98, in import_from_cwd
package=package,
File
"D:\Anaconda3\install\envs\superset_env\lib\site-packages\celery\utils\imports.py",
line 111, in import_from_cwd
return imp(module, package=package)
File
"D:\Anaconda3\install\envs\superset_env\lib\site-packages\celery\loaders\base.py",
line 92, in import_module
return importlib.import_module(module, package=package)
File "D:\Anaconda3\install\envs\superset_env\lib\importlib\__init__.py",
line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "<frozen importlib._bootstrap>", line 1006, in _gcd_import
File "<frozen importlib._bootstrap>", line 983, in _find_and_load
File "<frozen importlib._bootstrap>", line 967, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 677, in _load_unlocked
File "<frozen importlib._bootstrap_external>", line 728, in exec_module
File "<frozen importlib._bootstrap>", line 219, in
_call_with_frames_removed
File
"D:\Anaconda3\install\envs\superset_env\Lib\site-packages\superset\sql_lab.py",
line 37, in <module>
from superset.db_engine_specs import BaseEngineSpec
File
"D:\Anaconda3\install\envs\superset_env\Lib\site-packages\superset\db_engine_specs\__init__.py",
line 43, in <module>
from superset.db_engine_specs.base import BaseEngineSpec
File
"D:\Anaconda3\install\envs\superset_env\Lib\site-packages\superset\db_engine_specs\base.py",
line 61, in <module>
from superset.models.sql_lab import Query
File
"D:\Anaconda3\install\envs\superset_env\Lib\site-packages\superset\models\__init__.py",
line 17, in <module>
from . import (
File
"D:\Anaconda3\install\envs\superset_env\Lib\site-packages\superset\models\alerts.py",
line 55, in <module>
class Alert(Model, AuditMixinNullable):
File
"D:\Anaconda3\install\envs\superset_env\Lib\site-packages\superset\models\alerts.py",
line 68, in Alert
owners = relationship(security_manager.user_model, secondary=alert_owner)
File
"D:\Anaconda3\install\envs\superset_env\Lib\site-packages\werkzeug\local.py",
line 347, in __getattr__
return getattr(self._get_current_object(), name)
AttributeError: 'NoneType' object has no attribute 'user_model'
Process SpawnPoolWorker-4:
Traceback (most recent call last):
File
"D:\Anaconda3\install\envs\superset_env\Lib\site-packages\billiard\process.py",
line 327, in _bootstrap
self.run()
File
"D:\Anaconda3\install\envs\superset_env\Lib\site-packages\billiard\process.py",
line 114, in run
self._target(*self._args, **self._kwargs)
File
"D:\Anaconda3\install\envs\superset_env\Lib\site-packages\billiard\pool.py",
line 289, in __call__
self.after_fork()
File
"D:\Anaconda3\install\envs\superset_env\Lib\site-packages\billiard\pool.py",
line 421, in after_fork
self.initializer(*self.initargs)
File
"D:\Anaconda3\install\envs\superset_env\lib\site-packages\celery\concurrency\prefork.py",
line 55, in process_initializer
app.loader.init_worker()
File
"D:\Anaconda3\install\envs\superset_env\lib\site-packages\celery\loaders\base.py",
line 114, in init_worker
self.import_default_modules()
File
"D:\Anaconda3\install\envs\superset_env\lib\site-packages\celery\loaders\base.py",
line 109, in import_default_modules
return [self.import_task_module(m) for m in self.default_modules]
File
"D:\Anaconda3\install\envs\superset_env\lib\site-packages\celery\loaders\base.py",
line 109, in <listcomp>
return [self.import_task_module(m) for m in self.default_modules]
File
"D:\Anaconda3\install\envs\superset_env\lib\site-packages\celery\loaders\base.py",
line 89, in import_task_module
return self.import_from_cwd(module)
[2021-12-15 10:53:59,322: ERROR/SpawnPoolWorker-2] Process SpawnPoolWorker-2
Traceback (most recent call last):
```
OS：Windows 10
Superset Version：1.3.2
How should this problem be solved?
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
