I refresh data incrementally and use 13 partitions, the datasource is trino server. When it executes, trino dashboard can see a lot of Finshing query, the sql is as follows
select node_version from system.runtime.nodes where coordinator=true
It's state is FINSHING, and will be changed to "EXTERNAL ERROR — ABANDONED_QUERY" after 5 MINS.
When the sql is stuck in the FINSHING state, Trino Coordinator can't resolve new query, all the new query are stuck in QUEUED state. And this time, Coordinator node laod is not high.
After 5 minutes, the query state is changed to "EXTERNAL ERROR — ABANDONED_QUERY". And other queued query is recovered.
I suspect the problem is that the connection is not closed after select nodeversion query executes.
I want know what means this query, and how can i resolve this problem?
on:
Remove / Copy Visual issue - July 2025 Desktop Iss...
on:
URL is not filtering on field parameter
on:
URGENT!! Paginated Report not loading on Mozilla F...