使用Hikari连接池时会定期报Warning

[moonlighf]

springboot项目中使用Hikari连接池通过jdbc连接，默认30分钟（max-lifetime）会尝试关闭空闲连接，但是关闭时候会报如下warning，请问如何解决？
Kyuubi版本：1.6.1

o.a.k.s.o.a.t.t.TIOStreamTransport       - Error closing output stream.
java.net.SocketException: Socket closed
	at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:118) ~[na:1.8.0_432]
	at java.net.SocketOutputStream.write(SocketOutputStream.java:155) ~[na:1.8.0_432]
	at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) ~[na:1.8.0_432]
	at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140) ~[na:1.8.0_432]
	at java.io.FilterOutputStream.close(FilterOutputStream.java:158) ~[na:1.8.0_432]
	at org.apache.kyuubi.shade.org.apache.thrift.transport.TIOStreamTransport.close(TIOStreamTransport.java:110) ~[kyuubi-hive-jdbc-shaded-1.4.0-incubating.jar:1.4.0-incubating]
	at org.apache.kyuubi.shade.org.apache.thrift.transport.TSocket.close(TSocket.java:235) [kyuubi-hive-jdbc-shaded-1.4.0-incubating.jar:1.4.0-incubating]
	at org.apache.kyuubi.shade.org.apache.thrift.transport.TSaslTransport.close(TSaslTransport.java:402) [kyuubi-hive-jdbc-shaded-1.4.0-incubating.jar:1.4.0-incubating]
	at org.apache.kyuubi.shade.org.apache.thrift.transport.TSaslClientTransport.close(TSaslClientTransport.java:37) [kyuubi-hive-jdbc-shaded-1.4.0-incubating.jar:1.4.0-incubating]
	at org.apache.kyuubi.jdbc.hive.KyuubiConnection.close(KyuubiConnection.java:929) [kyuubi-hive-jdbc-shaded-1.4.0-incubating.jar:1.4.0-incubating]
	at com.zaxxer.hikari.pool.PoolBase.quietlyCloseConnection(PoolBase.java:143) [HikariCP-4.0.3.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.lambda$closeConnection$1(HikariPool.java:451) [HikariCP-4.0.3.jar:na]

[pan3793]

it's a bug inherited from hive, and has been fixed in #3152, you can simply upgrade the Kyuubi JDBC driver to 1.9.3, it should be compatible with the old Kyuubi server.

[moonlighf]

@pan3793 Do I need to set other parameters in the jdbc url? I tried to directly change the version of Kyuubi to 1.9.3, but I still get this warning

<dependency>
      <groupId>org.apache.kyuubi</groupId>
      <artifactId>kyuubi-hive-jdbc-shaded</artifactId>
      <version>1.9.3</version>
</dependency>

2024-12-03 20:11:55.559  WARN --- [nnection closer] o.a.k.s.t.transport.TIOStreamTransport   : Error closing output stream.
java.net.SocketException: Socket closed
	at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:118) ~[na:1.8.0_432]
	at java.net.SocketOutputStream.write(SocketOutputStream.java:155) ~[na:1.8.0_432]
	at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) ~[na:1.8.0_432]
	at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140) ~[na:1.8.0_432]
	at java.io.FilterOutputStream.close(FilterOutputStream.java:158) ~[na:1.8.0_432]
	at org.apache.kyuubi.shaded.thrift.transport.TIOStreamTransport.close(TIOStreamTransport.java:157) ~[kyuubi-hive-jdbc-shaded-1.9.3.jar:1.9.3]
	at org.apache.kyuubi.shaded.thrift.transport.TSocket.close(TSocket.java:264) [kyuubi-hive-jdbc-shaded-1.9.3.jar:1.9.3]
	at org.apache.kyuubi.shaded.thrift.transport.TSaslTransport.close(TSaslTransport.java:364) [kyuubi-hive-jdbc-shaded-1.9.3.jar:1.9.3]
	at org.apache.kyuubi.shaded.thrift.transport.TSaslClientTransport.close(TSaslClientTransport.java:39) [kyuubi-hive-jdbc-shaded-1.9.3.jar:1.9.3]
	at org.apache.kyuubi.jdbc.hive.KyuubiConnection.close(KyuubiConnection.java:1079) [kyuubi-hive-jdbc-shaded-1.9.3.jar:1.9.3]
	at com.zaxxer.hikari.pool.PoolBase.quietlyCloseConnection(PoolBase.java:143) [HikariCP-4.0.3.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.lambda$closeConnection$1(HikariPool.java:451) [HikariCP-4.0.3.jar:na]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_432]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_432]
	at java.lang.Thread.run(Thread.java:750) ~[na:1.8.0_432]

[pan3793]

after the fixing, the default socket timeout should be infinite, you may need to investigate on other directions if this does not solve your problem

[moonlighf]

Can I set the socket timeout manually? What parameter should I add in jdbc url？I just set up the following

jdbc:hive2://xxxxxxx&session.global.queryTimeout=300

[pan3793]

soemthing like jdbc:hive2://host:port/db;socketTimeout=180000