deuspt commented on issue #30079:
URL: https://github.com/apache/superset/issues/30079#issuecomment-2323445306
Seems related with cache interaction, I see such errors following retrieval
attempts e.g.:
```
...
2024-09-01 17:33:40,365:INFO:superset.utils.screenshots:Attempting to get
from cache:
...
2024-09-01 17:33:40,446:INFO:superset.utils.screenshots:Attempting to get
from cache: 9ac7aac76755e14d175d865d1cedcd3c
2024-09-01 17:34:11,728:ERROR:superset.utils.json:JSON is not valid
Expecting value: line 1 column 1 (char 0)
Traceback (most recent call last):
File "/app/superset/utils/json.py", line 244, in loads
return simplejson.loads(
File "/usr/local/lib/python3.10/site-packages/simplejson/__init__.py",
line 514, in loads
return _default_decoder.decode(s)
File "/usr/local/lib/python3.10/site-packages/simplejson/decoder.py", line
386, in decode
obj, end = self.raw_decode(s)
File "/usr/local/lib/python3.10/site-packages/simplejson/decoder.py", line
416, in raw_decode
return self.scan_once(s, idx=_w(s, idx).end())
simplejson.errors.JSONDecodeError: Expecting value: line 1 column 1 (char 0)
2024-09-01 17:34:11,786:INFO:superset.viz:Cache key:
c11beccf261da40e33f4c680892375ea
2024-09-01 17:34:11,789:ERROR:superset.utils.json:JSON is not valid
Expecting value: line 1 column 1 (char 0)
Traceback (most recent call last):
File "/app/superset/utils/json.py", line 244, in loads
return simplejson.loads(
File "/usr/local/lib/python3.10/site-packages/simplejson/__init__.py",
line 514, in loads
return _default_decoder.decode(s)
File "/usr/local/lib/python3.10/site-packages/simplejson/decoder.py", line
386, in decode
obj, end = self.raw_decode(s)
File "/usr/local/lib/python3.10/site-packages/simplejson/decoder.py", line
416, in raw_decode
return self.scan_once(s, idx=_w(s, idx).end())
simplejson.errors.JSONDecodeError: Expecting value: line 1 column 1 (char 0)
2024-09-01 17:34:11,811:WARNING:superset.views.base:Superset.explore_json
This API endpoint is deprecated and will be removed in version 5.0.0
2024-09-01 17:34:11,812:ERROR:superset.utils.json:JSON is not valid
Expecting value: line 1 column 1 (char 0)
Traceback (most recent call last):
File "/app/superset/utils/json.py", line 244, in loads
return simplejson.loads(
File "/usr/local/lib/python3.10/site-packages/simplejson/__init__.py",
line 514, in loads
return _default_decoder.decode(s)
File "/usr/local/lib/python3.10/site-packages/simplejson/decoder.py", line
386, in decode
obj, end = self.raw_decode(s)
File "/usr/local/lib/python3.10/site-packages/simplejson/decoder.py", line
416, in raw_decode
return self.scan_once(s, idx=_w(s, idx).end())
simplejson.errors.JSONDecodeError: Expecting value: line 1 column 1 (char 0)
2024-09-01 17:34:11,942:INFO:superset.viz:Cache key:
5d5c68a6a844ad9a2240ff187701bb5a
2024-09-01 17:34:12,601:WARNING:superset.models.helpers:Unable to parse SQL
to format it, passing it as-is
2024-09-01 17:34:12,748:ERROR:superset.utils.json:JSON is not valid
Expecting value: line 1 column 1 (char 0)
Traceback (most recent call last):
File "/app/superset/utils/json.py", line 244, in loads
return simplejson.loads(
File "/usr/local/lib/python3.10/site-packages/simplejson/__init__.py",
line 514, in loads
return _default_decoder.decode(s)
File "/usr/local/lib/python3.10/site-packages/simplejson/decoder.py", line
386, in decode
obj, end = self.raw_decode(s)
File "/usr/local/lib/python3.10/site-packages/simplejson/decoder.py", line
416, in raw_decode
return self.scan_once(s, idx=_w(s, idx).end())
simplejson.errors.JSONDecodeError: Expecting value: line 1 column 1 (char 0)
...
```
There's also the SQL parsing warning, which may be unrelated.
Besides log pollution with these exceptions, the cache failures also lead to
increasing number of requests to Celery workers in order to regenerate
thumbnails.
--
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]
