SNOW-2226852: Non-daemon threads currently preventing JVM termination

[padhia]

Please answer these questions before submitting your issue.
In order to accurately debug the issue this information is required. Thanks!

1. What version of JDBC driver are you using?
   3.25.1

2. What operating system and processor architecture are you using?
   MacOS/arm64, also Linux/X64

3. What version of Java are you using?
   21.0.4

4. What did you do?
   I upgraded Snowflake JDBC driver from 3.24.0 to 3.25.1 on a few JVM applications. All of these (command-line) applications now fail to terminate and issue the message:

Non-daemon threads currently preventing JVM termination: - 49: Thread[#49,pool-1-thread-1,5,main]
 -  - 53: Thread[#53,pool-1-thread-4,5,main]
 -  - 51: Thread[#51,pool-1-thread-2,5,main]
 -  - 52: Thread[#52,pool-1-thread-3,5,main]
 -  - 55: Thread[#55,DestroyJavaVM,5,main]

Note: No other changes were made to the application. Falling back to 3.24.0 version restores the previous behavior (i.e., the JVM terminates on application exit). Version 3.25.0 also seems to have the same issue as 3.25.1

5. What did you expect to see?

The applications should exit gracefully after processing. Now they require SIGTERM to terminate them

6. Can you set logging to DEBUG and collect the logs?

I tried setting logging to DEBUG and then TRACE, but it did not produce any output -- maybe because some JVM threads were still running

[sfc-gh-sghosh]

Hello @padhia ,

Thanks for raising the issue, could you please explain further the issue in details, could you send a sample repro for this issue ?

Regards,
Sujan

[padhia]

Hello Sujan, below is a simple JDBC program in Scala. This program runs fine with Snowflake JDBC versions below 3.25.0

//> using dep org.tpolecat::doobie-core::1.0.0-RC10
//> using dep net.snowflake:snowflake-jdbc:3.25.1
//> using javaOpt --add-opens=java.base/java.nio=org.apache.arrow.memory.core,ALL-UNNAMED

import cats.effect.*
import doobie.*
import doobie.syntax.all.*

val xa = Transactor.fromDriverManager[IO](
  "net.snowflake.client.jdbc.SnowflakeDriver",
  "jdbc:snowflake://xxxxxxxx.snowflakecomputing.com/?user=xxxxx&password=xxxxxxxxx",
  None
)

object TestJDBC extends IOApp.Simple:
  val run =
    sql"select current_user()"
      .query[String]
      .unique
      .transact(xa)
      .map(println)

To run this simple program, put the contents in a file and use scala-cli to run as scala-cli test.scala

[sfc-gh-sghosh]

Thank you @padhia ,

We’ve reproduced the issue, and confirmed that it’s a regression in JDBC 3.25.0. We are investigating and will work on a fix.

[sfc-gh-rkowalski]

Hi, this was fixed in #2297 and released in JDBC 3.26.0