Data refresh make trino server can't resolve query task

[MilkWang]

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?

[MilkWang]

[Anonymous]

Hi @MilkWang ,

Does this problem occur intermittently?

I have not been able to reproduce this issue and have not received feedback from other users with similar experiences to yours at this time. Does it still exist?

Best Regards,
Community Support Team _ Caitlyn