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 2021/08/18 03:41:22 UTC

[GitHub] [superset] beis0118 opened a new issue #16311: Database error Instance is not bound to a Session; attribute refresh operation cannot proceed (Background on this error at: http://sqlalche.me/e/13/bhk3)

beis0118 opened a new issue #16311:
URL: https://github.com/apache/superset/issues/16311


   When i use the sqllab to query my data from databases(such as mysql and clickhouse) , the bug in title happened.
   
   ### Expected results
   
   Get the right data from my databases.
   
   ### Actual results
   
   Database error Instance <Query at 0x1b8f2ec1e50> is not bound to a Session; attribute refresh operation cannot proceed (Background on this error at: http://sqlalche.me/e/13/bhk3).
   
   #### Screenshots
   
   ![image](https://user-images.githubusercontent.com/59128541/129832948-8d915fad-10a2-4e7d-8fb0-c4432bac2f16.png)
   ![image](https://user-images.githubusercontent.com/59128541/129833035-b645d8d0-cbf5-4657-baca-f341cb403f68.png)
   
   #### How to resolve the bug
   
   1. Go to 'superset/views/core'
   2. Find th method '_sql_json_sync'
   3. annotation two line:
   `            
   payload = json.dumps(
                   apply_display_max_row_limit(data),
                   default=utils.pessimistic_json_iso_dttm_ser,
                   ignore_nan=True,
                   encoding=None,
               )
   `
   with
   `            
   payload = json.dumps(
                   apply_display_max_row_limit(data),
                   default=utils.pessimistic_json_iso_dttm_ser,
                   #ignore_nan=True,
                   #encoding=None,
               )
   `
   


-- 
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: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


[GitHub] [superset] junlincc edited a comment on issue #16311: [sqllab]Database error Instance is not bound to a Session

Posted by GitBox <gi...@apache.org>.
junlincc edited a comment on issue #16311:
URL: https://github.com/apache/superset/issues/16311#issuecomment-900808953


   could you provide 1) version of superset, 2)which db exactly that causes this error,3) are you able to reproduce this by using one of our sample datasets? 
   
   @betodealmeida 🙏


-- 
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: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


[GitHub] [superset] junlincc edited a comment on issue #16311: [sqllab]Database error Instance is not bound to a Session

Posted by GitBox <gi...@apache.org>.
junlincc edited a comment on issue #16311:
URL: https://github.com/apache/superset/issues/16311#issuecomment-900808953


   could you provide 1) version of superset, 2)which db exactly that causes this error,3) are you able to reproduce this by using one of our sample datasets? 
   
   @betodealmeida 🙏 looping in our data expert


-- 
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: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


[GitHub] [superset] beis0118 commented on issue #16311: [sqllab]Database error Instance is not bound to a Session

Posted by GitBox <gi...@apache.org>.
beis0118 commented on issue #16311:
URL: https://github.com/apache/superset/issues/16311#issuecomment-900818469


   > could you provide 1) version of superset, 2)which db exactly that causes this error,3) are you able to reproduce this by using one of our sample datasets?
   > 
   > @betodealmeida 🙏 looping in our data expert
   
   Here: 
   1. Superset version: 1.2.0 (clone from the master branch)
   2. ClickHouse and Mysql data from examples.
   3. Do you mean this?
   ![image](https://user-images.githubusercontent.com/59128541/129841022-fed34a0b-a2ee-4ccd-99fc-2c357a7fa654.png)
   It looks good.
   


-- 
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: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


[GitHub] [superset] junlincc commented on issue #16311: [sqllab]Database error Instance is not bound to a Session

Posted by GitBox <gi...@apache.org>.
junlincc commented on issue #16311:
URL: https://github.com/apache/superset/issues/16311#issuecomment-900808953


   could you provide 1) version of superset, 2)which db exactly that causes this error,3) are you able to reproduce this by using one of our sample datasets? 


-- 
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: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


[GitHub] [superset] beis0118 commented on issue #16311: [sqllab]Database error Instance is not bound to a Session

Posted by GitBox <gi...@apache.org>.
beis0118 commented on issue #16311:
URL: https://github.com/apache/superset/issues/16311#issuecomment-900818469


   > could you provide 1) version of superset, 2)which db exactly that causes this error,3) are you able to reproduce this by using one of our sample datasets?
   > 
   > @betodealmeida 🙏 looping in our data expert
   
   Here: 
   1. Superset version: 1.2.0 (clone from the master branch)
   2. ClickHouse and Mysql data from examples.
   3. Do you mean this?
   ![image](https://user-images.githubusercontent.com/59128541/129841022-fed34a0b-a2ee-4ccd-99fc-2c357a7fa654.png)
   It looks good.
   


-- 
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: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


[GitHub] [superset] junlincc commented on issue #16311: [sqllab]Database error Instance is not bound to a Session

Posted by GitBox <gi...@apache.org>.
junlincc commented on issue #16311:
URL: https://github.com/apache/superset/issues/16311#issuecomment-900808953


   could you provide 1) version of superset, 2)which db exactly that causes this error,3) are you able to reproduce this by using one of our sample datasets? 


-- 
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: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


[GitHub] [superset] junlincc edited a comment on issue #16311: [sqllab]Database error Instance is not bound to a Session

Posted by GitBox <gi...@apache.org>.
junlincc edited a comment on issue #16311:
URL: https://github.com/apache/superset/issues/16311#issuecomment-900808953






-- 
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: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org