[GitHub] [superset] francisco-pjbank edited a comment on issue #16373: When listing saved queries an exception occurs Table not serializable

Fri, 20 Aug 2021 07:00:15 -0700 


francisco-pjbank edited a comment on issue #16373:
URL: https://github.com/apache/superset/issues/16373#issuecomment-902688550


   Hi, I set the following features to False and it seems that the problem is 
partially solved. It may be a good idea to set those feature flags to False in 
default superset/config.py.
   
   "ALLOW_DASHBOARD_DOMAIN_SHARDING": False,
   "ENABLE_REACT_CRUD_VIEWS": False,
   
   It looks like that it occurs depending on the type of API call.
   
   Go to the welcome page and check no list is loaded and the exception 
`TypeError('Object of type %s is not JSON serializable'` occurs:
   
   ```
   2021-08-20 13:56:12,727:INFO:werkzeug:127.0.0.1 - - [20/Aug/2021 13:56:12] 
"GET /superset/welcome/ HTTP/1.1" 200 -
   2021-08-20 13:56:14,071:INFO:werkzeug:127.0.0.1 - - [20/Aug/2021 13:56:14] 
"GET /superset/recent_activity/1/?limit=6 HTTP/1.1" 200 -
   2021-08-20 13:56:14,180:ERROR:root:Object of type Table is not JSON 
serializable
   Traceback (most recent call last):
     File 
"/usr/local/lib/python3.8/dist-packages/flask_appbuilder/api/__init__.py", line 
85, in wraps
       return f(self, *args, **kwargs)
     File 
"/usr/local/lib/python3.8/dist-packages/flask_appbuilder/api/__init__.py", line 
155, in wraps
       return f(self, *args, **kwargs)
     File 
"/usr/local/lib/python3.8/dist-packages/flask_appbuilder/api/__init__.py", line 
1592, in get_list
       return self.get_list_headless(**kwargs)
     File "/usr/local/lib/python3.8/dist-packages/superset/utils/log.py", line 
228, in wrapper
       value = f(*args, **kwargs)
     File "/usr/local/lib/python3.8/dist-packages/superset/views/base_api.py", 
line 406, in get_list_headless
       duration, response = time_function(super().get_list_headless, **kwargs)
     File "/usr/local/lib/python3.8/dist-packages/superset/utils/core.py", line 
1407, in time_function
       response = func(*args, **kwargs)
     File 
"/usr/local/lib/python3.8/dist-packages/flask_appbuilder/api/__init__.py", line 
1498, in get_list_headless
       return self.response(200, **_response)
     File 
"/usr/local/lib/python3.8/dist-packages/flask_appbuilder/api/__init__.py", line 
672, in response
       _ret_json = jsonify(kwargs)
     File 
"/home/ubuntu/.local/lib/python3.8/site-packages/flask/json/__init__.py", line 
321, in jsonify
       dumps(data, indent=indent, separators=separators) + '\n',
     File 
"/home/ubuntu/.local/lib/python3.8/site-packages/flask/json/__init__.py", line 
179, in dumps
       rv = _json.dumps(obj, **kwargs)
     File "/usr/lib/python3/dist-packages/simplejson/__init__.py", line 385, in 
dumps
       return cls(
     File "/usr/lib/python3/dist-packages/simplejson/encoder.py", line 296, in 
encode
       chunks = self.iterencode(o, _one_shot=True)
     File "/usr/lib/python3/dist-packages/simplejson/encoder.py", line 378, in 
iterencode
       return _iterencode(o, 0)
     File 
"/home/ubuntu/.local/lib/python3.8/site-packages/flask/json/__init__.py", line 
81, in default
       return _json.JSONEncoder.default(self, o)
     File "/usr/lib/python3/dist-packages/simplejson/encoder.py", line 272, in 
default
       raise TypeError('Object of type %s is not JSON serializable' %
   TypeError: Object of type Table is not JSON serializable
   2021-08-20 13:56:14,181:INFO:werkzeug:127.0.0.1 - - [20/Aug/2021 13:56:14] 
"GET 
/api/v1/dashboard/?q=(filters:!((col:created_by,opr:rel_o_m,value:%271%27)),order_column:changed_on_delta_humanized,order_direction:desc,page:0,page_size:3)
 HTTP/1.1" 200 -
   2021-08-20 13:56:14,183:INFO:werkzeug:127.0.0.1 - - [20/Aug/2021 13:56:14] 
"GET 
/api/v1/saved_query/?q=(filters:!((col:created_by,opr:rel_o_m,value:%271%27)),order_column:changed_on_delta_humanized,order_direction:desc,page:0,page_size:3)
 HTTP/1.1" 500 -
   2021-08-20 13:56:14,184:INFO:werkzeug:127.0.0.1 - - [20/Aug/2021 13:56:14] 
"GET 
/api/v1/chart/?q=(filters:!((col:created_by,opr:rel_o_m,value:%271%27)),order_column:changed_on_delta_humanized,order_direction:desc,page:0,page_size:3)
 HTTP/1.1" 200 -
   2021-08-20 13:56:14,508:INFO:werkzeug:127.0.0.1 - - [20/Aug/2021 13:56:14] 
"GET /api/v1/saved_query/_info?q=(keys:!(permissions)) HTTP/1.1" 200 -
   2021-08-20 13:56:14,538:INFO:werkzeug:127.0.0.1 - - [20/Aug/2021 13:56:14] 
"GET /api/v1/dashboard/_info?q=(keys:!(permissions)) HTTP/1.1" 200 -
   2021-08-20 13:56:14,569:INFO:werkzeug:127.0.0.1 - - [20/Aug/2021 13:56:14] 
"GET /api/v1/chart/_info?q=(keys:!(permissions)) HTTP/1.1" 200 -
   2021-08-20 13:56:14,572:INFO:werkzeug:127.0.0.1 - - [20/Aug/2021 13:56:14] 
"GET /api/v1/chart/favorite_status/?q=!(1) HTTP/1.1" 200 -
   ```
   
![image](https://user-images.githubusercontent.com/83026156/130240917-dff174e3-1ef9-4b8d-a564-db1cf246b031.png)
   
   Now go to SQL Lab-> Saved Queries and the problem will persist. API call 
sequence with error
   
   ```
   2021-08-20 13:45:58,462:INFO:werkzeug:127.0.0.1 - - [20/Aug/2021 13:45:58] 
"GET /api/v1/saved_query/distinct/schema?q=() HTTP/1.1" 200 -
   2021-08-20 13:45:58,471:ERROR:root:Object of type Table is not JSON 
serializable
   Traceback (most recent call last):
     File 
"/usr/local/lib/python3.8/dist-packages/flask_appbuilder/api/__init__.py", line 
85, in wraps
       return f(self, *args, **kwargs)
     File 
"/usr/local/lib/python3.8/dist-packages/flask_appbuilder/api/__init__.py", line 
155, in wraps
       return f(self, *args, **kwargs)
     File 
"/usr/local/lib/python3.8/dist-packages/flask_appbuilder/api/__init__.py", line 
1592, in get_list
       return self.get_list_headless(**kwargs)
     File "/usr/local/lib/python3.8/dist-packages/superset/utils/log.py", line 
228, in wrapper
       value = f(*args, **kwargs)
     File "/usr/local/lib/python3.8/dist-packages/superset/views/base_api.py", 
line 406, in get_list_headless
       duration, response = time_function(super().get_list_headless, **kwargs)
     File "/usr/local/lib/python3.8/dist-packages/superset/utils/core.py", line 
1407, in time_function
       response = func(*args, **kwargs)
     File 
"/usr/local/lib/python3.8/dist-packages/flask_appbuilder/api/__init__.py", line 
1498, in get_list_headless
       return self.response(200, **_response)
     File 
"/usr/local/lib/python3.8/dist-packages/flask_appbuilder/api/__init__.py", line 
672, in response
       _ret_json = jsonify(kwargs)
     File 
"/home/ubuntu/.local/lib/python3.8/site-packages/flask/json/__init__.py", line 
321, in jsonify
       dumps(data, indent=indent, separators=separators) + '\n',
     File 
"/home/ubuntu/.local/lib/python3.8/site-packages/flask/json/__init__.py", line 
179, in dumps
       rv = _json.dumps(obj, **kwargs)
     File "/usr/lib/python3/dist-packages/simplejson/__init__.py", line 385, in 
dumps
       return cls(
     File "/usr/lib/python3/dist-packages/simplejson/encoder.py", line 296, in 
encode
       chunks = self.iterencode(o, _one_shot=True)
     File "/usr/lib/python3/dist-packages/simplejson/encoder.py", line 378, in 
iterencode
       return _iterencode(o, 0)
     File 
"/home/ubuntu/.local/lib/python3.8/site-packages/flask/json/__init__.py", line 
81, in default
       return _json.JSONEncoder.default(self, o)
     File "/usr/lib/python3/dist-packages/simplejson/encoder.py", line 272, in 
default
       raise TypeError('Object of type %s is not JSON serializable' %
   TypeError: Object of type Table is not JSON serializable
   2021-08-20 13:45:58,472:INFO:werkzeug:127.0.0.1 - - [20/Aug/2021 13:45:58] 
"GET /api/v1/saved_query/related/database?q=() HTTP/1.1" 200 -
   2021-08-20 13:45:58,473:INFO:werkzeug:127.0.0.1 - - [20/Aug/2021 13:45:58] 
"GET /api/v1/saved_query/_info?q=(keys:!(permissions)) HTTP/1.1" 200 -
   2021-08-20 13:45:58,474:INFO:werkzeug:127.0.0.1 - - [20/Aug/2021 13:45:58] 
"GET 
/api/v1/saved_query/?q=(order_column:changed_on_delta_humanized,order_direction:desc,page:0,page_size:25)
 HTTP/1.1" 500 -
   ```
   Press F5 (reload) on same page and the list appears:
   
   
![image](https://user-images.githubusercontent.com/83026156/130239257-5dc6e586-ac5f-4ece-b5a1-9f59775f6731.png)
   
   ```
   2021-08-20 13:54:56,310:INFO:werkzeug:127.0.0.1 - - [20/Aug/2021 13:54:56] 
"GET 
/savedqueryview/list/?pageIndex=0&sortColumn=changed_on_delta_humanized&sortOrder=desc
 HTTP/1.1" 200 -
   2021-08-20 13:54:57,108:INFO:werkzeug:127.0.0.1 - - [20/Aug/2021 13:54:57] 
"GET /static/assets/images/favicon.png HTTP/1.1" 200 -
   ```
   


-- 
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]

Reply via email to