Trino Error: "nodes is empty" - java.lang.IllegalArgumentException: nodes is empty

[xhuynx]

I'm encountering a java.lang.IllegalArgumentException with the message "nodes is empty" in Trino when running SQL queries with 2 worker.
My sample sql 'ALTER TABLE table EXECUTE optimize(file_size_threshold => '512MB')'
or insert statement.

Note: If the query run on single node, it works fine. but If run on over 2 nodes, it will be error.
Now I stopped worker and run on 1 node on coordinator.

Can anyone help me for this issue? Thank in advance.

The error logs:

java.lang.IllegalArgumentException: nodes is empty
at com.google.common.base.Preconditions.checkArgument(Preconditions.java:141)
at io.trino.sql.planner.NodePartitioningManager.createArbitraryBucketToNode(NodePartitioningManager.java:357)
at io.trino.sql.planner.NodePartitioningManager.getBucketNodeMap(NodePartitioningManager.java:255)
at io.trino.sql.planner.NodePartitioningManager.getBucketCount(NodePartitioningManager.java:239)
at io.trino.operator.exchange.LocalExchange.getBucketCount(LocalExchange.java:292)
at io.trino.operator.exchange.LocalExchange.createPartitionFunction(LocalExchange.java:265)
at io.trino.operator.exchange.LocalExchange.lambda$new$15(LocalExchange.java:183)
at io.trino.operator.exchange.LocalExchange.createSink(LocalExchange.java:336)
at io.trino.operator.exchange.LocalExchange$LocalExchangeSinkFactory.createSink(LocalExchange.java:461)
at io.trino.operator.exchange.LocalExchangeSinkOperator$LocalExchangeSinkOperatorFactory.createOperator(LocalExchangeSinkOperator.java:57)
at io.trino.operator.DriverFactory.createDriver(DriverFactory.java:107)
at io.trino.execution.SqlTaskExecution$DriverSplitRunnerFactory.createDriver(SqlTaskExecution.java:667)
at io.trino.execution.SqlTaskExecution$DriverSplitRunner.processFor(SqlTaskExecution.java:878)
at io.trino.execution.executor.dedicated.SplitProcessor.run(SplitProcessor.java:77)
at io.trino.execution.executor.dedicated.TaskEntry$VersionEmbedderBridge.lambda$run$0(TaskEntry.java:201)
at io.trino.$gen.Trino_476____20250619_045505_2.run(Unknown Source)
at io.trino.execution.executor.dedicated.TaskEntry$VersionEmbedderBridge.run(TaskEntry.java:202)
at io.trino.execution.executor.scheduler.FairScheduler.runTask(FairScheduler.java:177)
at io.trino.execution.executor.scheduler.FairScheduler.lambda$submit$0(FairScheduler.java:164)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:545)
at com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:128)
at com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:74)
at com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:80)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1095)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:619)
at java.base/java.lang.Thread.run(Thread.java:1447)