GiannisDimitriou edited a comment on issue #5953:
URL:
https://github.com/apache/incubator-superset/issues/5953#issuecomment-671962136
@mistercrunch
I am experiencing the same issue on superset metadata db (postgres).
Lot of the connections are on "idle in transaction" state meaning that the
handling of the transaction from Superset site is not optimal.
Another observation is that the query for all those "idle in transaction"
transactions is the same as shown below, if that helps pinpoint the issue.
`SELECT
slices.created_on AS slices_created_on ,
slices.changed_on AS slices_changed_on ,
slices.id AS slices_id ,
slices.slice_name AS slices_slice_name ,
slices.datasource_id AS slices_datasource_id ,
slices.datasource_type AS slices_datasource_type ,
slices.datasource_name AS slices_datasource_name ,
slices.viz_type AS slices_viz_type ,
slices.params AS slices_params ,
slices.description AS slices_description ,
slices.cache_timeout AS slices_cache_timeout ,
slices.perm AS slices_perm ,
slices.schema_perm AS slices_schema_perm ,
slices.created_by_fk AS slices_created_by_fk ,
slices.changed_by_fk AS slices_changed_by_fk ,
tables_1.created_on AS tables_1_created_on ,
tables_1.changed_on AS tables_1_changed_on ,
tables_1.id AS tables_1_id ,
tables_1.description AS tables_1_description ,
tables_1.default_endpoint AS tables_1_default_endpoint ,
tables_1.is_featured AS tables_1_is_featured ,
tables_1.filter_select_enabled AS tables_1_filter_select_enabled ,
tables_1."offset" AS tables_1_offset ,
tables_1.cache_timeout AS tables_1_cache_timeout ,
tables_1.params AS tables_1_params ,
tables_1.perm AS tables_1_perm ,
tables_1.schema_perm AS tables_1_schema_perm ,
tables_1.table_name AS tables_1_table_name ,
tables_1.main_dttm_col AS tables_1_main_dttm_col ,
tables_1.database_id AS tables_1_database_id ,
tables_1.fetch_values_predicate AS tables_1_fetch_values_predicate,
tables_1.schema AS tables_1_schema ,
tables_1.sql AS tables_1_sql ,
tables_1.is_sqllab_view AS tables_1_is_sqllab_view ,
tables_1.template_params AS tables_1_template_params ,
tables_1.created_by_fk AS tables_1_created_by_fk ,
tables_1.changed_by_fk AS tables_1_changed_by_fk
FROM
slices
LEFT OUTER JOIN
tables AS tables_1
ON
slices.datasource_id = tables_1.id
AND slices.datasource_type = $1
WHERE
slices.id = $2`
Superset version 0.37.0rc1
----------------------------------------------------------------
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
