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 2022/10/18 17:41:17 UTC
[GitHub] [superset] M3gar00 opened a new issue, #21865: Superset not stopping when I press stop button.
M3gar00 opened a new issue, #21865:
URL: https://github.com/apache/superset/issues/21865
I'm attempting to run a simple test query:
```SELECT count(*) from table_x;```
I'm currently sitting at `22:35:59.00` and counting.
I've reset the server multiple times (I'm working on a different problem that has required the server to be re-deployed).
#### How to reproduce the bug
No clue, this query has worked almost instantaneously in the past.
### Expected results
The query to A) run quickly and B) stop when I hit the stop button.
### Actual results
The query is still going, and I get an error of `Failed at stopping query. z-Bk9XLonv` when I click on Stop.
#### Screenshots
### Environment
- Chrome Version 106.0.5249.103 (Official Build) (arm64)
- superset version: `2.0.0`
- any feature flags active:
FEATURE_FLAGS = {
"ALERT_REPORTS": True,
"DASHBOARD_RBAC": True,
}
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [x] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [?] I have reproduced the issue with at least the latest released version of superset.
- I have found the issue in issue tracker, and there was no resolution posted. Issue: [Link](https://github.com/apache/superset/issues/18787)
### Additional context
I started another query in a tab (Similar to the first), and I recorded the logs from when the query started:
--
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.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
Re: [I] Superset not stopping when I press stop button. [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #21865: Superset not stopping when I press stop button.
URL: https://github.com/apache/superset/issues/21865
--
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] Lucian63 commented on issue #21865: Superset not stopping when I press stop button.
Posted by "Lucian63 (via GitHub)" <gi...@apache.org>.
Lucian63 commented on issue #21865:
URL: https://github.com/apache/superset/issues/21865#issuecomment-1571053223
Hi @eschutho, we ran into the same issue in Production that "Stop" button doesn't response in v2.1.0 Superset. We are using the "Clickhouse" as the database. Could you help to check whether this is enabled or not? If not, is there any ETA? Appreciate your help in advance.
--
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] villebro commented on issue #21865: Superset not stopping when I press stop button.
Posted by "villebro (via GitHub)" <gi...@apache.org>.
villebro commented on issue #21865:
URL: https://github.com/apache/superset/issues/21865#issuecomment-1551658504
Hi, I'm looking into this, and I can indeed confirm that the queries appear to execute regardless of the stop button having been pushed. This may somehow be related to the migration of the query stopper from the legacy view to the v1 API.
--
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] phihung commented on issue #21865: Superset not stopping when I press stop button.
Posted by GitBox <gi...@apache.org>.
phihung commented on issue #21865:
URL: https://github.com/apache/superset/issues/21865#issuecomment-1306760034
I have the same problem with `superset + trino`.
Even after the trino query was time-out (I even tried restarting trino container), superset UI keeps showing "running".
`POST /stop_query` results on 422 UNPROCESSABLE ENTITY error.
--
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
Re: [I] Superset not stopping when I press stop button. [superset]
Posted by "hcai (via GitHub)" <gi...@apache.org>.
hcai commented on issue #21865:
URL: https://github.com/apache/superset/issues/21865#issuecomment-1854457478
We use MySql and Superset 3.0.2, the stop button only works if they queries are executed in synchronous mode
--
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] eschutho commented on issue #21865: Superset not stopping when I press stop button.
Posted by "eschutho (via GitHub)" <gi...@apache.org>.
eschutho commented on issue #21865:
URL: https://github.com/apache/superset/issues/21865#issuecomment-1472453262
> When I use SQL Lab with Impala as the data source, I often encounter the following error message when I click the stop button during query execution:Failed at stopping query. WUJFsUIaJ
Impala stop query was implemented recently in https://github.com/apache/superset/pull/22635. You can test this out on the 2.1 release.
--
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] hughhhh commented on issue #21865: Superset not stopping when I press stop button.
Posted by GitBox <gi...@apache.org>.
hughhhh commented on issue #21865:
URL: https://github.com/apache/superset/issues/21865#issuecomment-1344687919
currently tested this locally on the same build, and I'm able to properly stop the query
https://user-images.githubusercontent.com/27827808/206781569-923244b0-3f0d-454a-961e-fbb5a3a44657.mov
--
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] christianxiaobai commented on issue #21865: Superset not stopping when I press stop button.
Posted by "christianxiaobai (via GitHub)" <gi...@apache.org>.
christianxiaobai commented on issue #21865:
URL: https://github.com/apache/superset/issues/21865#issuecomment-1455704042
When I use SQL Lab with Impala as the data source, I often encounter the following error message when I click the stop button during query execution:Failed at stopping query. WUJFsUIaJ
--
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] eschutho commented on issue #21865: Superset not stopping when I press stop button.
Posted by "eschutho (via GitHub)" <gi...@apache.org>.
eschutho commented on issue #21865:
URL: https://github.com/apache/superset/issues/21865#issuecomment-1542896082
ccing @villebro - he mentioned that he can test out Trino.
--
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] MateusCastello commented on issue #21865: Superset not stopping when I press stop button.
Posted by "MateusCastello (via GitHub)" <gi...@apache.org>.
MateusCastello commented on issue #21865:
URL: https://github.com/apache/superset/issues/21865#issuecomment-1513151218
I'm having the same problem with `superset + trino` on Superset 2.1.0
--
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] lgingerich commented on issue #21865: Superset not stopping when I press stop button.
Posted by GitBox <gi...@apache.org>.
lgingerich commented on issue #21865:
URL: https://github.com/apache/superset/issues/21865#issuecomment-1379540692
Hello @eschutho, you mentioned above that some databases haven't been enabled yet with stop query functionality. Has it been enabled for Google BigQuery yet?
I am using Google BigQuery and the stop query functionality isn't working for me, but I want to make sure it's not another issue causing this.
--
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
Re: [I] Superset not stopping when I press stop button. [superset]
Posted by "shubhamverma6594 (via GitHub)" <gi...@apache.org>.
shubhamverma6594 commented on issue #21865:
URL: https://github.com/apache/superset/issues/21865#issuecomment-1830949645
Hi @eschutho @Lucian63, stop query functionality for Bigquery has not been implemented yet
--
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] eschutho commented on issue #21865: Superset not stopping when I press stop button.
Posted by GitBox <gi...@apache.org>.
eschutho commented on issue #21865:
URL: https://github.com/apache/superset/issues/21865#issuecomment-1282931608
HI, what database are you running the query on? Some databases haven't been enabled yet with stop query functionality.
--
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] iabhinavkaundal commented on issue #21865: Superset not stopping when I press stop button.
Posted by "iabhinavkaundal (via GitHub)" <gi...@apache.org>.
iabhinavkaundal commented on issue #21865:
URL: https://github.com/apache/superset/issues/21865#issuecomment-1465484496
> Hello Team, We have added Mysql and Postgresql in my machine and we are facing the same issue on "Failed at stopping query. D-pibT97ZN". Please help 
Please help in this as we are stuck
--
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
Re: [I] Superset not stopping when I press stop button. [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #21865:
URL: https://github.com/apache/superset/issues/21865#issuecomment-2073615510
Closing this since it's a confluence of databases being reported (some have been fixed, some maybe not), and it's on a no-longer-supported version of Superset, and it's been stale for upward of 6 months. If anyone is still facing these issues, please post a new Issue with a single database and updated context. Thanks for understanding.
--
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] eschutho commented on issue #21865: Superset not stopping when I press stop button.
Posted by GitBox <gi...@apache.org>.
eschutho commented on issue #21865:
URL: https://github.com/apache/superset/issues/21865#issuecomment-1396116249
Right now, I see the cancel functionality in mysql, postgres, redshift, snowflake and trino. So, no, I don't see the method built out for BigQuery yet @lgingerich.
--
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] M3gar00 commented on issue #21865: Superset not stopping when I press stop button.
Posted by GitBox <gi...@apache.org>.
M3gar00 commented on issue #21865:
URL: https://github.com/apache/superset/issues/21865#issuecomment-1282946210
@eschutho Sorry, I should have included that in my OP. I'm using MySQL.
--
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] iabhinavkaundal commented on issue #21865: Superset not stopping when I press stop button.
Posted by "iabhinavkaundal (via GitHub)" <gi...@apache.org>.
iabhinavkaundal commented on issue #21865:
URL: https://github.com/apache/superset/issues/21865#issuecomment-1463241221
Hello Team,
We have added Mysql and Postgresql in my machine and it facing the same issue on "Failed at stopping query. D-pibT97ZN".
Please help
--
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] eschutho commented on issue #21865: Superset not stopping when I press stop button.
Posted by "eschutho (via GitHub)" <gi...@apache.org>.
eschutho commented on issue #21865:
URL: https://github.com/apache/superset/issues/21865#issuecomment-1652684880
> Hi @eschutho, we ran into the same issue in Production that "Stop" button doesn't response in v2.1.0 Superset. We are using the "Clickhouse" as the database. Could you help to check whether this is enabled or not? If not, is there any ETA? Appreciate your help in advance.
Hi @Lucian63, stop query functionality for clickhouse has not been implemented yet. We're open to PRs though!
--
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] villebro commented on issue #21865: Superset not stopping when I press stop button.
Posted by "villebro (via GitHub)" <gi...@apache.org>.
villebro commented on issue #21865:
URL: https://github.com/apache/superset/issues/21865#issuecomment-1607964789
Following up here - I looked into this but I wasn't able to figure out what's going wrong. The problem is the related code paths are very convoluted right now, and there's a lot of room for improvement. So I can definitely work on this and clean it up some, but I'm not sure when I'll be able to do so (I don't want to set unrealistic expectations). So if someone wants to pick this up before then and needs help, let me know so I can walk you through what I'd personally do to fix this.
--
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] eschutho commented on issue #21865: Superset not stopping when I press stop button.
Posted by "eschutho (via GitHub)" <gi...@apache.org>.
eschutho commented on issue #21865:
URL: https://github.com/apache/superset/issues/21865#issuecomment-1472451837
The `failed at stopping query` error can happen when the query has already finished its execution before the request to stop the execution reached the database. Can you try running a very long query to make sure that that isn't the case?
--
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] eschutho commented on issue #21865: Superset not stopping when I press stop button.
Posted by GitBox <gi...@apache.org>.
eschutho commented on issue #21865:
URL: https://github.com/apache/superset/issues/21865#issuecomment-1338608743
@M3gar00 Yeah, MySQL should work for this. We'll have to test more on both MySQL and Trino.
--
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] laserninja commented on issue #21865: Superset not stopping when I press stop button.
Posted by "laserninja (via GitHub)" <gi...@apache.org>.
laserninja commented on issue #21865:
URL: https://github.com/apache/superset/issues/21865#issuecomment-1519455304
For me too the stop from Superset 2.0.1 UI is not propagating to Trino 400. I am getting 200 response on the stop query endpoint in the logs though.
`"POST /superset/stop_query/ HTTP/1.1" 200`
Even after stoping the query from Superset, I see in the logs that the app tries to get the status on the query
`2023-04-24 05:43:56,316:DEBUG:urllib3.connectionpool:https://superset.trino.xxxx:443 "GET /v1/statement/executing/20230424_054324_00045_rv546/y04452f3f81f5c61269e8aa1f82ca9b345ae76c48/30 HTTP/1.1" 200 878`
--
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] rusackas commented on issue #21865: Superset not stopping when I press stop button.
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #21865:
URL: https://github.com/apache/superset/issues/21865#issuecomment-1607893163
Pinging a few other folks from the DB Rolodex for good measure: @cccs-tom @john-bodley @sujiplr
They all use Trino according to the [DB Rolodex](https://docs.google.com/spreadsheets/d/1U1qxiLvOX0kBTUGME1AHHi6Ywel6ECF8xk_Qy-V9R8c/edit#gid=0), which anyone here can get in on, btw ;)
I haven't looked into the issue at all, but Impala had a similar problem not so long ago, in case this sheds any insight.
https://github.com/apache/superset/pull/22635/files
--
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