Flaky TestS3WrongRegionPicked.testS3WrongRegionSelection

[ebyhr]

There's #14568, but opened a new issue because the error message and stacktrace are different.

Error:  io.trino.plugin.hive.s3.TestS3WrongRegionPicked.testS3WrongRegionSelection  Time elapsed: 80.168 s  <<< FAILURE!
io.trino.spi.TrinoException: localhost:32779: java.net.SocketTimeoutException: Read timed out
	at io.trino.plugin.hive.metastore.thrift.ThriftHiveMetastore.getDatabase(ThriftHiveMetastore.java:237)
	at io.trino.plugin.hive.metastore.thrift.BridgingHiveMetastore.getDatabase(BridgingHiveMetastore.java:81)
	at io.trino.plugin.hive.HiveQueryRunner$Builder.populateData(HiveQueryRunner.java:271)
	at io.trino.plugin.hive.HiveQueryRunner$Builder.build(HiveQueryRunner.java:258)
	at io.trino.plugin.hive.s3.S3HiveQueryRunner$Builder.build(S3HiveQueryRunner.java:161)
	at io.trino.plugin.hive.s3.TestS3WrongRegionPicked.testS3WrongRegionSelection(TestS3WrongRegionPicked.java:37)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:568)
	at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:104)
	at org.testng.internal.Invoker.invokeMethod(Invoker.java:645)
	at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:851)
	at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1177)
	at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:129)
	at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:112)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
	at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: org.apache.thrift.transport.TTransportException: localhost:32779: java.net.SocketTimeoutException: Read timed out
	at io.trino.plugin.hive.metastore.thrift.Transport.rewriteException(Transport.java:95)
	at io.trino.plugin.hive.metastore.thrift.Transport$TTransportWrapper.readAll(Transport.java:129)
	at org.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:457)
	at org.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:359)
	at org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:243)
	at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
	at io.trino.hive.thrift.metastore.ThriftHiveMetastore$Client.recvGetDatabase(ThriftHiveMetastore.java:1135)
	at io.trino.hive.thrift.metastore.ThriftHiveMetastore$Client.getDatabase(ThriftHiveMetastore.java:1122)
	at io.trino.plugin.hive.metastore.thrift.ThriftHiveMetastoreClient.getDatabase(ThriftHiveMetastoreClient.java:177)
	at io.trino.plugin.hive.metastore.thrift.ThriftHiveMetastore.lambda$getDatabase$1(ThriftHiveMetastore.java:229)
	at io.trino.plugin.hive.metastore.thrift.ThriftMetastoreApiStats.lambda$wrap$0(ThriftMetastoreApiStats.java:42)
	at io.trino.plugin.hive.util.RetryDriver.run(RetryDriver.java:130)
	at io.trino.plugin.hive.metastore.thrift.ThriftHiveMetastore.getDatabase(ThriftHiveMetastore.java:227)
	... 18 more
	Suppressed: org.apache.thrift.transport.TTransportException: localhost:32779: java.net.SocketTimeoutException: Read timed out
		... 31 more
	Caused by: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out
		at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:171)
		at org.apache.thrift.transport.TTransport.readAll(TTransport.java:100)
		at io.trino.plugin.hive.metastore.thrift.Transport$TTransportWrapper.readAll(Transport.java:126)
		... 29 more
	Caused by: java.net.SocketTimeoutException: Read timed out
		at java.base/sun.nio.ch.NioSocketImpl.timedRead(NioSocketImpl.java:283)
		at java.base/sun.nio.ch.NioSocketImpl.implRead(NioSocketImpl.java:309)
		at java.base/sun.nio.ch.NioSocketImpl.read(NioSocketImpl.java:350)
		at java.base/sun.nio.ch.NioSocketImpl$1.read(NioSocketImpl.java:803)
		at java.base/java.net.Socket$SocketInputStream.read(Socket.java:976)
		at java.base/java.io.BufferedInputStream.fill(BufferedInputStream.java:244)
		at java.base/java.io.BufferedInputStream.read1(BufferedInputStream.java:284)
		at java.base/java.io.BufferedInputStream.read(BufferedInputStream.java:343)
		at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:169)
		... 31 more
Caused by: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out
	at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:171)
	at org.apache.thrift.transport.TTransport.readAll(TTransport.java:100)
	at io.trino.plugin.hive.metastore.thrift.Transport$TTransportWrapper.readAll(Transport.java:126)
	... 29 more
Caused by: java.net.SocketTimeoutException: Read timed out
	at java.base/sun.nio.ch.NioSocketImpl.timedRead(NioSocketImpl.java:283)
	at java.base/sun.nio.ch.NioSocketImpl.implRead(NioSocketImpl.java:309)
	at java.base/sun.nio.ch.NioSocketImpl.read(NioSocketImpl.java:350)
	at java.base/sun.nio.ch.NioSocketImpl$1.read(NioSocketImpl.java:803)
	at java.base/java.net.Socket$SocketInputStream.read(Socket.java:976)
	at java.base/java.io.BufferedInputStream.fill(BufferedInputStream.java:244)
	at java.base/java.io.BufferedInputStream.read1(BufferedInputStream.java:284)
	at java.base/java.io.BufferedInputStream.read(BufferedInputStream.java:343)
	at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:169)
	... 31 more

https://github.com/trinodb/trino/actions/runs/4188979988/jobs/7262488192