search

ing-bank / cassandra-jdbc-wrapper

A JDBC wrapper of Java Driver for Apache Cassandra®, which offers a simple JDBC compliant API to work with CQL3.
Apache License 2.0
74 stars 25 forks source link

Can't connect to Astra with "Connection was established but closed as invalid" #67

Open tjlee opened 4 months ago

tjlee commented 4 months ago

Hi,

I'm using the latest JDBC driver and trying to connect to Astra. I was trying to connect to Vector and general ones.

URL:

jdbc:cassandra://dbaas/another_datagrip?user=token&password=AstraCS:$$TOKEN$$&secureconnectbundle=/Users/vasilii.chernov/Projects/secure-connect-another-datagrip.zip

Test Connection

image

Log chunk

2024-06-27 18:27:29,131 [14160048]   INFO - #c.i.e.r.RemoteProcessSupport - SSL MODE is REQUIRE
2024-06-27 18:27:29,131 [14160048]   INFO - #c.i.e.r.RemoteProcessSupport - Setting `verifyServerCertificate` to `false`
2024-06-27 18:27:29,136 [14160053]   WARN - #c.i.e.r.RemoteProcessSupport - SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
2024-06-27 18:27:29,136 [14160053]   WARN - #c.i.e.r.RemoteProcessSupport - SLF4J: Defaulting to no-operation (NOP) logger implementation
2024-06-27 18:27:29,136 [14160053]   WARN - #c.i.e.r.RemoteProcessSupport - SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
2024-06-27 18:27:32,029 [14162946]   INFO - #c.i.e.r.RemoteProcessSupport - Driver: Cassandra JDBC Driver 4.12.0-DataGrip-patch-2
2024-06-27 18:27:32,031 [14162948]   INFO - #c.i.e.r.RemoteProcessSupport - getDatabaseProductName: Cassandra
2024-06-27 18:27:32,171 [14163088]   INFO - #c.i.e.r.RemoteProcessSupport - release_version: 4.0.0.6816
2024-06-27 18:27:32,174 [14163091]   INFO - #c.i.e.r.RemoteProcessSupport - Detected: CASSANDRA 4.0.0.6816
2024-06-27 18:27:32,261 [14163178]   INFO - #c.i.d.c.JdbcEngineUtils - Connection is invalid

Is there any way to get more details to identify the root cause?

maximevw commented 4 months ago

Hello @tjlee,

Could you try with this connection string: jdbc:cassandra:dbaas:///another_datagrip?user=token&password=AstraCS:$$TOKEN$$&secureconnectbundle=/Users/vasilii.chernov/Projects/secure-connect-another-datagrip.zip

It's a little bit confusing to have a successful connection test and a info-level message saying "Connection is invalid"... If there is an error, it seems this one is swallowed here by DataGrip and not displayed neither in the logs, nor in the interface. Maybe, it's possible to set a lower log level to have more details.

tjlee commented 4 months ago

I've tried with the suggested JDBC URL with an extending loggin (by the way, // is used in wrapper tests).

I've got NPE:

2024-06-28 11:21:05,198 [ 320435]   INFO - #c.i.d.d.DatabaseConnectionEstablisher - Connecting to: jdbc:cassandra:dbaas:///another_datagrip?user=token&password=AstraCS:$$TOKEN$$&secureconnectbundle=/Users/vasilii.chernov/Projects/secure-connect-another-datagrip.zip
2024-06-28 11:21:05,205 [ 320442]   INFO - #c.i.e.r.RemoteProcessSupport - 
2024-06-28 11:21:05,208 [ 320445]   INFO - #c.i.e.r.RemoteProcessSupport - Will duplicate streams to log
2024-06-28 11:21:05,209 [ 320446]   INFO - #c.i.d.d.DatabaseConnectionEstablisher - Auth provider: user-pass
2024-06-28 11:21:05,210 [ 320447]   INFO - #c.i.d.d.DatabaseCredentialsAuthProvider - Connecting as: token
2024-06-28 11:21:05,295 [ 320532]   INFO - #c.i.e.r.RemoteProcessSupport - setting driver log level to ALL
2024-06-28 11:21:05,326 [ 320563]   WARN - #c.i.e.r.RemoteProcessSupport - Jun 28, 2024 9:21:05 AM com.intellij.database.remote.jdbc.helpers.JdbcHelperImpl connect
2024-06-28 11:21:05,326 [ 320563]   INFO - #c.i.e.r.RemoteProcessSupport - setting driver log path to null
2024-06-28 11:21:05,326 [ 320563]   WARN - #c.i.e.r.RemoteProcessSupport - INFO: setting driver log level to ALL
2024-06-28 11:21:05,326 [ 320563]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-06-28 11:21:05,326 [ 320563]   WARN - #c.i.e.r.RemoteProcessSupport - Jun 28, 2024 9:21:05 AM com.intellij.database.remote.jdbc.helpers.JdbcHelperImpl connect
2024-06-28 11:21:05,326 [ 320563]   WARN - #c.i.e.r.RemoteProcessSupport - INFO: setting driver log path to null
2024-06-28 11:21:05,326 [ 320563]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-06-28 11:21:05,327 [ 320564]   INFO - #c.i.e.r.RemoteProcessSupport - DriverManager.LogWriter.level=ALL
2024-06-28 11:21:05,327 [ 320564]   WARN - #c.i.e.r.RemoteProcessSupport - Jun 28, 2024 9:21:05 AM com.intellij.database.remote.jdbc.helpers.JdbcHelperImpl setDriverLogLevel
2024-06-28 11:21:05,327 [ 320564]   WARN - #c.i.e.r.RemoteProcessSupport - INFO: DriverManager.LogWriter.level=ALL
2024-06-28 11:21:05,327 [ 320564]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-06-28 11:21:05,327 [ 320564]   INFO - #c.i.e.r.RemoteProcessSupport - com.ing.data.cassandra.level=ALL
2024-06-28 11:21:05,328 [ 320565]   WARN - #c.i.e.r.RemoteProcessSupport - Jun 28, 2024 9:21:05 AM com.intellij.database.remote.jdbc.helpers.JdbcHelperImpl setDriverLogLevel
2024-06-28 11:21:05,328 [ 320565]   WARN - #c.i.e.r.RemoteProcessSupport - INFO: com.ing.data.cassandra.level=ALL
2024-06-28 11:21:05,328 [ 320565]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-06-28 11:21:05,341 [ 320578]   WARN - #c.i.e.r.RemoteProcessSupport - SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
2024-06-28 11:21:05,341 [ 320578]   WARN - #c.i.e.r.RemoteProcessSupport - Jun 28, 2024 9:21:05 AM org.slf4j.helpers.Util report
2024-06-28 11:21:05,341 [ 320578]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING: SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
2024-06-28 11:21:05,341 [ 320578]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-06-28 11:21:05,341 [ 320578]   WARN - #c.i.e.r.RemoteProcessSupport - SLF4J: Defaulting to no-operation (NOP) logger implementation
2024-06-28 11:21:05,341 [ 320578]   WARN - #c.i.e.r.RemoteProcessSupport - Jun 28, 2024 9:21:05 AM org.slf4j.helpers.Util report
2024-06-28 11:21:05,341 [ 320578]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING: SLF4J: Defaulting to no-operation (NOP) logger implementation
2024-06-28 11:21:05,341 [ 320578]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-06-28 11:21:05,342 [ 320579]   WARN - #c.i.e.r.RemoteProcessSupport - SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
2024-06-28 11:21:05,342 [ 320579]   WARN - #c.i.e.r.RemoteProcessSupport - Jun 28, 2024 9:21:05 AM org.slf4j.helpers.Util report
2024-06-28 11:21:05,342 [ 320579]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING: SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
2024-06-28 11:21:05,342 [ 320579]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-06-28 11:21:05,393 [ 320630]   WARN - #c.i.d.d.BaseDatabaseErrorHandler$UnknownErrorInfo - Unexpected error while creating connection.
java.sql.SQLException: Unexpected error while creating connection.
    at com.ing.data.cassandra.jdbc.CassandraDriver.connect(CassandraDriver.java:110)
    at com.intellij.database.remote.jdbc.helpers.JdbcHelperImpl.connect(JdbcHelperImpl.java:790)
    at com.intellij.database.remote.jdbc.impl.RemoteDriverImpl.connect(RemoteDriverImpl.java:153)
    at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
    at java.base/java.lang.reflect.Method.invoke(Method.java:580)
    at java.rmi/sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:360)
    at java.rmi/sun.rmi.transport.Transport$1.run(Transport.java:200)
    at java.rmi/sun.rmi.transport.Transport$1.run(Transport.java:197)
    at java.base/java.security.AccessController.doPrivileged(AccessController.java:714)
    at java.rmi/sun.rmi.transport.Transport.serviceCall(Transport.java:196)
    at java.rmi/sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:598)
    at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:844)
    at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:721)
    at java.base/java.security.AccessController.doPrivileged(AccessController.java:400)
    at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:720)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
    at java.base/java.lang.Thread.run(Thread.java:1583)
    at java.rmi/sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:304)
    at java.rmi/sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:280)
    at java.rmi/sun.rmi.server.UnicastRef.invoke(UnicastRef.java:166)
    at java.rmi/java.rmi.server.RemoteObjectInvocationHandler.invokeRemoteMethod(RemoteObjectInvocationHandler.java:215)
    at java.rmi/java.rmi.server.RemoteObjectInvocationHandler.invoke(RemoteObjectInvocationHandler.java:160)
    at jdk.proxy5/jdk.proxy5.$Proxy212.connect(Unknown Source)
    at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
    at java.base/java.lang.reflect.Method.invoke(Method.java:580)
    at com.intellij.execution.rmi.RemoteUtil.invokeRemote(RemoteUtil.java:153)
    at com.intellij.execution.rmi.RemoteUtil.access$200(RemoteUtil.java:22)
    at com.intellij.execution.rmi.RemoteUtil$1MyHandler.lambda$invoke$0(RemoteUtil.java:135)
    at com.intellij.openapi.util.ClassLoaderUtil.computeWithClassLoader(ClassLoaderUtil.java:31)
    at com.intellij.execution.rmi.RemoteUtil.executeWithClassLoader(RemoteUtil.java:205)
    at com.intellij.execution.rmi.RemoteUtil$1MyHandler.invoke(RemoteUtil.java:135)
    at jdk.proxy5/jdk.proxy5.$Proxy212.connect(Unknown Source)
    at com.intellij.database.dataSource.DatabaseConnectionEstablisher.connect(DatabaseConnectionEstablisher.kt:168)
    at com.intellij.database.dataSource.DatabaseConnectionEstablisher.access$connect(DatabaseConnectionEstablisher.kt:48)
    at com.intellij.database.dataSource.DatabaseConnectionEstablisher$tryConnectInner$2$1.invoke(DatabaseConnectionEstablisher.kt:71)
    at com.intellij.database.dataSource.DatabaseConnectionEstablisher$tryConnectInner$2$1.invoke(DatabaseConnectionEstablisher.kt:71)
    at com.intellij.openapi.progress.CoroutinesKt.blockingContextInner(coroutines.kt:339)
    at com.intellij.openapi.progress.CoroutinesKt$blockingContext$2.invokeSuspend(coroutines.kt:232)
    at com.intellij.openapi.progress.CoroutinesKt$blockingContext$2.invoke(coroutines.kt)
    at com.intellij.openapi.progress.CoroutinesKt$blockingContext$2.invoke(coroutines.kt)
    at kotlinx.coroutines.intrinsics.UndispatchedKt.startUndispatchedOrReturn(Undispatched.kt:62)
    at kotlinx.coroutines.CoroutineScopeKt.coroutineScope(CoroutineScope.kt:261)
    at com.intellij.openapi.progress.CoroutinesKt.blockingContext(coroutines.kt:231)
    at com.intellij.database.dataSource.DatabaseConnectionEstablisher$tryConnectInner$2.invokeSuspend(DatabaseConnectionEstablisher.kt:71)
    at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
    at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:104)
    at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:608)
    at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:873)
    at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:763)
    at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:750)
Caused by: java.lang.NullPointerException
    at com.ing.data.cassandra.jdbc.SessionHolder.createSession(SessionHolder.java:250)
    at com.ing.data.cassandra.jdbc.SessionHolder.<init>(SessionHolder.java:135)
    at com.ing.data.cassandra.jdbc.CassandraDriver$1.load(CassandraDriver.java:69)
    at com.ing.data.cassandra.jdbc.CassandraDriver$1.load(CassandraDriver.java:66)
    at com.github.benmanes.caffeine.cache.LocalLoadingCache.lambda$newMappingFunction$2(LocalLoadingCache.java:145)
    at com.github.benmanes.caffeine.cache.UnboundedLocalCache.lambda$computeIfAbsent$2(UnboundedLocalCache.java:239)
    at java.base/java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1708)
    at com.github.benmanes.caffeine.cache.UnboundedLocalCache.computeIfAbsent(UnboundedLocalCache.java:235)
    at com.github.benmanes.caffeine.cache.LocalCache.computeIfAbsent(LocalCache.java:108)
    at com.github.benmanes.caffeine.cache.LocalLoadingCache.get(LocalLoadingCache.java:56)
    at com.ing.data.cassandra.jdbc.CassandraDriver.connect(CassandraDriver.java:96)
    at com.intellij.database.remote.jdbc.helpers.JdbcHelperImpl.connect(JdbcHelperImpl.java:790)
    at com.intellij.database.remote.jdbc.impl.RemoteDriverImpl.connect(RemoteDriverImpl.java:153)
    at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
    at java.base/java.lang.reflect.Method.invoke(Method.java:580)
    at java.rmi/sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:360)
    at java.rmi/sun.rmi.transport.Transport$1.run(Transport.java:200)
    at java.rmi/sun.rmi.transport.Transport$1.run(Transport.java:197)
    at java.base/java.security.AccessController.doPrivileged(AccessController.java:714)
    at java.rmi/sun.rmi.transport.Transport.serviceCall(Transport.java:196)
    at java.rmi/sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:598)
    at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:844)
    at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:721)
    at java.base/java.security.AccessController.doPrivileged(AccessController.java:400)
    at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:720)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
    at java.base/java.lang.Thread.run(Thread.java:1583)
    Suppressed: com.intellij.database.util.AsyncTask$Companion$FrameData: Async frame data: Test connection -> Connecting to database… -> Prepare connection -> Establish database connection -> Get database credentials -> Perform database connection
maximevw commented 4 months ago

Hello @tjlee, Sorry for the delay. Thank you for this test. It seems there is some regression in connection to AstraDB (this specific point hasn't been tested for a long time...). I'll test this on my side as soon as possible and keep you informed here.

maximevw commented 4 months ago

Hello @tjlee,

Applying the changes included in this commit, I was able to successfully connect to an AstraDB instance using the following simple code snippet with the different connection strings mentioned hereinafter:

public class Application {
    public static void main(String[] args) throws Exception {
        CassandraConnection conn = getAstraConnection();
        Statement statement = conn.createStatement();
        ResultSet rs = statement.executeQuery("SELECT release_version FROM system.local");
        System.out.println("VERSION: " + rs.getString(1));
        rs.close();
        statement.close();
        conn.close();
        System.exit(0);
    }

    public static CassandraConnection getAstraConnection() throws Exception {
        Class.forName("com.ing.data.cassandra.jdbc.CassandraDriver");
        String urlAstra = "jdbc:cassandra://dbaas/kscloud_test?user=token&password=AstraCS:$$TOKEN$$&secureconnectbundle=/tmp/secure-connect-kscloud-test.zip";
        return (CassandraConnection) DriverManager.getConnection(urlAstra);
    }
}

The tested JDBC URLs:

The result of the executed code, in both cases, was:

VERSION: 4.0.11-09ec37c912ed

Let me know if the fix helps in your case.

tjlee commented 4 months ago

@maximevw , thank you for your investigation.

Firstly I thought I messed up JDBC URL but with your code snippet I could connect to both instances.

Secondly, I can confirm, that Test Connection works for jdbc:cassandra:dbaas:///kscloud_test?user=token&password=AstraCS:$$TOKEN$$&secureconnectbundle=/tmp/secure-connect-kscloud-test.zip within DataGrip too.

But, no more. I've got the same error Connection was established but closed as invalid.

The new log:

2024-07-02 09:40:24,906 [65203451]   INFO - #c.i.e.r.RemoteProcessSupport - /Users/vasilii.chernov/Applications/DataGrip.app/Contents/jbr/Contents/Home/bin/java -Djava.rmi.server.hostname=127.0.0.1 -Duser.timezone=UTC -Xmx750m -Xms256m -Djdbc.classpath=/Users/vasilii.chernov/Applications/DataGrip.app/Contents/plugins/DatabaseTools/lib/jdbc-console.jar:/Users/vasilii.chernov/Downloads/cassandra-jdbc-wrapper-4.12.0-bundle.jar --add-exports java.desktop/sun.awt=ALL-UNNAMED --add-exports java.desktop/java.awt.peer=ALL-UNNAMED --add-opens java.desktop/java.awt=ALL-UNNAMED --add-opens=jdk.unsupported/sun.misc=ALL-UNNAMED --add-opens=java.base/java.nio=ALL-UNNAMED --add-opens=java.base/java.util=ALL-UNNAMED -Dfile.encoding=UTF-8 -Dsun.stdout.encoding=UTF-8 -Dsun.stderr.encoding=UTF-8 -classpath /Users/vasilii.chernov/Applications/DataGrip.app/Contents/lib/util_rt.jar:/Users/vasilii.chernov/Applications/DataGrip.app/Contents/lib/util-8.jar:/Users/vasilii.chernov/Applications/DataGrip.app/Contents/lib/groovy.jar:/Users/vasilii.chernov/Applications/DataGrip.app/Contents/plugins/DatabaseTools/lib/jdbc-console.jar:/Users/vasilii.chernov/Applications/DataGrip.app/Contents/plugins/grid-core-impl/lib/jdbc-console-types.jar:/Users/vasilii.chernov/Applications/DataGrip.app/Contents/lib/util.jar:/Users/vasilii.chernov/Applications/DataGrip.app/Contents/lib/bouncy-castle.jar com.intellij.database.remote.RemoteJdbcServer com.ing.data.cassandra.jdbc.CassandraDriver
2024-07-02 09:40:25,538 [65204083]   INFO - #c.i.e.r.RemoteProcessSupport - Using classpath: /Users/vasilii.chernov/Applications/DataGrip.app/Contents/plugins/DatabaseTools/lib/jdbc-console.jar:/Users/vasilii.chernov/Downloads/cassandra-jdbc-wrapper-4.12.0-bundle.jar
2024-07-02 09:40:25,538 [65204083]   INFO - #c.i.e.r.RemoteProcessSupport - and base loader jdk.internal.loader.ClassLoaders$PlatformClassLoader@396e2f39
2024-07-02 09:40:25,745 [65204290]   INFO - #c.i.e.r.RemoteProcessSupport - Desktop actions are jbr-api
2024-07-02 09:40:25,866 [65204411]   INFO - #c.i.e.r.RemoteProcessSupport - Port/ServicesPort/ID: 52904/54841/RemoteDriverImple1bcb6f4
2024-07-02 09:40:25,926 [65204471]   INFO - #c.i.d.d.DatabaseConnectionEstablisher - Connecting to: jdbc:cassandra://dbaas/default_keyspace?user=token&password=AstraCS$$TOKEN$$&secureconnectbundle=/Users/vasilii.chernov/Projects/secure-connect-test-datagrip-astra.zip
2024-07-02 09:40:25,928 [65204473]   INFO - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:25,932 [65204477]   INFO - #c.i.e.r.RemoteProcessSupport - Will duplicate streams to log
2024-07-02 09:40:25,933 [65204478]   INFO - #c.i.d.d.DatabaseConnectionEstablisher - Auth provider: user-pass
2024-07-02 09:40:25,946 [65204491]   INFO - #c.i.d.d.DatabaseCredentialsAuthProvider - No user name provided (may be in url)
2024-07-02 09:40:26,072 [65204617]   INFO - #c.i.e.r.RemoteProcessSupport - setting driver log level to ALL
2024-07-02 09:40:26,113 [65204658]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:26 AM com.intellij.database.remote.jdbc.helpers.JdbcHelperImpl connect
2024-07-02 09:40:26,113 [65204658]   WARN - #c.i.e.r.RemoteProcessSupport - INFO: setting driver log level to ALL
2024-07-02 09:40:26,113 [65204658]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:26,113 [65204658]   INFO - #c.i.e.r.RemoteProcessSupport - setting driver log path to null
2024-07-02 09:40:26,113 [65204658]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:26 AM com.intellij.database.remote.jdbc.helpers.JdbcHelperImpl connect
2024-07-02 09:40:26,113 [65204658]   WARN - #c.i.e.r.RemoteProcessSupport - INFO: setting driver log path to null
2024-07-02 09:40:26,113 [65204658]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:26,114 [65204659]   INFO - #c.i.e.r.RemoteProcessSupport - DriverManager.LogWriter.level=ALL
2024-07-02 09:40:26,115 [65204660]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:26 AM com.intellij.database.remote.jdbc.helpers.JdbcHelperImpl setDriverLogLevel
2024-07-02 09:40:26,115 [65204660]   WARN - #c.i.e.r.RemoteProcessSupport - INFO: DriverManager.LogWriter.level=ALL
2024-07-02 09:40:26,115 [65204660]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:26,115 [65204660]   INFO - #c.i.e.r.RemoteProcessSupport - com.ing.data.cassandra.level=ALL
2024-07-02 09:40:26,115 [65204660]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:26 AM com.intellij.database.remote.jdbc.helpers.JdbcHelperImpl setDriverLogLevel
2024-07-02 09:40:26,115 [65204660]   WARN - #c.i.e.r.RemoteProcessSupport - INFO: com.ing.data.cassandra.level=ALL
2024-07-02 09:40:26,115 [65204660]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:26,129 [65204674]   WARN - #c.i.e.r.RemoteProcessSupport - SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
2024-07-02 09:40:26,130 [65204675]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:26 AM org.slf4j.helpers.Util report
2024-07-02 09:40:26,130 [65204675]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING: SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
2024-07-02 09:40:26,130 [65204675]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:26,130 [65204675]   WARN - #c.i.e.r.RemoteProcessSupport - SLF4J: Defaulting to no-operation (NOP) logger implementation
2024-07-02 09:40:26,130 [65204675]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:26 AM org.slf4j.helpers.Util report
2024-07-02 09:40:26,130 [65204675]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING: SLF4J: Defaulting to no-operation (NOP) logger implementation
2024-07-02 09:40:26,130 [65204675]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:26,130 [65204675]   WARN - #c.i.e.r.RemoteProcessSupport - SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
2024-07-02 09:40:26,131 [65204676]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:26 AM org.slf4j.helpers.Util report
2024-07-02 09:40:26,131 [65204676]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING: SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
2024-07-02 09:40:26,131 [65204676]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:51,945 [65230490]   INFO - #c.i.e.r.RemoteProcessSupport - Driver: Cassandra JDBC Driver 4.12.0
2024-07-02 09:40:51,945 [65230490]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:51 AM com.intellij.database.remote.jdbc.helpers.JdbcHelperDetection detectImpl
2024-07-02 09:40:51,945 [65230490]   WARN - #c.i.e.r.RemoteProcessSupport - INFO: Driver: Cassandra JDBC Driver 4.12.0
2024-07-02 09:40:51,945 [65230490]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:51,947 [65230492]   INFO - #c.i.e.r.RemoteProcessSupport - getDatabaseProductName: Cassandra
2024-07-02 09:40:51,947 [65230492]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:51 AM com.intellij.database.remote.jdbc.helpers.CassJdbcHelper detect
2024-07-02 09:40:51,947 [65230492]   WARN - #c.i.e.r.RemoteProcessSupport - INFO: getDatabaseProductName: Cassandra
2024-07-02 09:40:51,947 [65230492]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,028 [65232573]   WARN - #c.i.e.r.RemoteProcessSupport - DBMS detection failed
2024-07-02 09:40:54,029 [65232574]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM com.intellij.database.remote.jdbc.helpers.JdbcHelperDetection detectImpl
2024-07-02 09:40:54,029 [65232574]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING: DBMS detection failed
2024-07-02 09:40:54,029 [65232574]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,029 [65232574]   WARN - #c.i.e.r.RemoteProcessSupport - java.sql.SQLTransientException: com.datastax.oss.driver.api.core.DriverTimeoutException: Query timed out after PT2S
2024-07-02 09:40:54,029 [65232574]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,029 [65232574]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING: java.sql.SQLTransientException: com.datastax.oss.driver.api.core.DriverTimeoutException: Query timed out after PT2S
2024-07-02 09:40:54,029 [65232574]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,029 [65232574]   WARN - #c.i.e.r.RemoteProcessSupport - at com.ing.data.cassandra.jdbc.CassandraPreparedStatement.<init>(CassandraPreparedStatement.java:151)
2024-07-02 09:40:54,030 [65232575]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,030 [65232575]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at com.ing.data.cassandra.jdbc.CassandraPreparedStatement.<init>(CassandraPreparedStatement.java:151)
2024-07-02 09:40:54,030 [65232575]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,030 [65232575]   WARN - #c.i.e.r.RemoteProcessSupport - at com.ing.data.cassandra.jdbc.CassandraConnection.prepareStatement(CassandraConnection.java:562)
2024-07-02 09:40:54,030 [65232575]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,030 [65232575]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at com.ing.data.cassandra.jdbc.CassandraConnection.prepareStatement(CassandraConnection.java:562)
2024-07-02 09:40:54,030 [65232575]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,030 [65232575]   WARN - #c.i.e.r.RemoteProcessSupport - at com.ing.data.cassandra.jdbc.CassandraConnection.prepareStatement(CassandraConnection.java:540)
2024-07-02 09:40:54,031 [65232576]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,031 [65232576]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at com.ing.data.cassandra.jdbc.CassandraConnection.prepareStatement(CassandraConnection.java:540)
2024-07-02 09:40:54,031 [65232576]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,031 [65232576]   WARN - #c.i.e.r.RemoteProcessSupport - at com.ing.data.cassandra.jdbc.CassandraConnection.prepareStatement(CassandraConnection.java:88)
2024-07-02 09:40:54,031 [65232576]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,031 [65232576]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at com.ing.data.cassandra.jdbc.CassandraConnection.prepareStatement(CassandraConnection.java:88)
2024-07-02 09:40:54,031 [65232576]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,031 [65232576]   WARN - #c.i.e.r.RemoteProcessSupport - at com.intellij.database.remote.jdbc.helpers.JdbcNativeUtil.prepared(JdbcNativeUtil.java:165)
2024-07-02 09:40:54,031 [65232576]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,032 [65232577]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at com.intellij.database.remote.jdbc.helpers.JdbcNativeUtil.prepared(JdbcNativeUtil.java:165)
2024-07-02 09:40:54,032 [65232577]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,032 [65232577]   WARN - #c.i.e.r.RemoteProcessSupport - at com.intellij.database.remote.jdbc.helpers.JdbcNativeUtil.consume(JdbcNativeUtil.java:155)
2024-07-02 09:40:54,032 [65232577]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,032 [65232577]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at com.intellij.database.remote.jdbc.helpers.JdbcNativeUtil.consume(JdbcNativeUtil.java:155)
2024-07-02 09:40:54,032 [65232577]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,032 [65232577]   WARN - #c.i.e.r.RemoteProcessSupport - at com.intellij.database.remote.jdbc.helpers.JdbcNativeUtil.getString(JdbcNativeUtil.java:135)
2024-07-02 09:40:54,032 [65232577]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,032 [65232577]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at com.intellij.database.remote.jdbc.helpers.JdbcNativeUtil.getString(JdbcNativeUtil.java:135)
2024-07-02 09:40:54,032 [65232577]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,032 [65232577]   WARN - #c.i.e.r.RemoteProcessSupport - at com.intellij.database.remote.jdbc.helpers.JdbcNativeUtil.getString(JdbcNativeUtil.java:129)
2024-07-02 09:40:54,032 [65232577]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,032 [65232577]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at com.intellij.database.remote.jdbc.helpers.JdbcNativeUtil.getString(JdbcNativeUtil.java:129)
2024-07-02 09:40:54,032 [65232577]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,032 [65232577]   WARN - #c.i.e.r.RemoteProcessSupport - at com.intellij.database.remote.jdbc.helpers.CassJdbcHelper.create(CassJdbcHelper.java:95)
2024-07-02 09:40:54,033 [65232578]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,033 [65232578]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at com.intellij.database.remote.jdbc.helpers.CassJdbcHelper.create(CassJdbcHelper.java:95)
2024-07-02 09:40:54,033 [65232578]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,033 [65232578]   WARN - #c.i.e.r.RemoteProcessSupport - at com.intellij.database.remote.jdbc.helpers.CassJdbcHelper.detect(CassJdbcHelper.java:90)
2024-07-02 09:40:54,033 [65232578]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,033 [65232578]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at com.intellij.database.remote.jdbc.helpers.CassJdbcHelper.detect(CassJdbcHelper.java:90)
2024-07-02 09:40:54,033 [65232578]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,033 [65232578]   WARN - #c.i.e.r.RemoteProcessSupport - at com.intellij.database.remote.jdbc.helpers.JdbcHelperDetection.detectImpl(JdbcHelperDetection.java:115)
2024-07-02 09:40:54,034 [65232579]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,034 [65232579]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at com.intellij.database.remote.jdbc.helpers.JdbcHelperDetection.detectImpl(JdbcHelperDetection.java:115)
2024-07-02 09:40:54,034 [65232579]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,034 [65232579]   WARN - #c.i.e.r.RemoteProcessSupport - at com.intellij.database.remote.jdbc.helpers.JdbcHelperDetection.detectImpl(JdbcHelperDetection.java:97)
2024-07-02 09:40:54,034 [65232579]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,034 [65232579]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at com.intellij.database.remote.jdbc.helpers.JdbcHelperDetection.detectImpl(JdbcHelperDetection.java:97)
2024-07-02 09:40:54,034 [65232579]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,034 [65232579]   WARN - #c.i.e.r.RemoteProcessSupport - at com.intellij.database.remote.jdbc.helpers.JdbcHelperDetection.detect(JdbcHelperDetection.java:31)
2024-07-02 09:40:54,034 [65232579]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,034 [65232579]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at com.intellij.database.remote.jdbc.helpers.JdbcHelperDetection.detect(JdbcHelperDetection.java:31)
2024-07-02 09:40:54,034 [65232579]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,034 [65232579]   WARN - #c.i.e.r.RemoteProcessSupport - at com.intellij.database.remote.jdbc.impl.RemoteDriverImpl.connect(RemoteDriverImpl.java:156)
2024-07-02 09:40:54,035 [65232580]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,035 [65232580]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at com.intellij.database.remote.jdbc.impl.RemoteDriverImpl.connect(RemoteDriverImpl.java:156)
2024-07-02 09:40:54,035 [65232580]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,035 [65232580]   WARN - #c.i.e.r.RemoteProcessSupport - at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
2024-07-02 09:40:54,035 [65232580]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,035 [65232580]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
2024-07-02 09:40:54,035 [65232580]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,035 [65232580]   WARN - #c.i.e.r.RemoteProcessSupport - at java.base/java.lang.reflect.Method.invoke(Method.java:580)
2024-07-02 09:40:54,035 [65232580]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,035 [65232580]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at java.base/java.lang.reflect.Method.invoke(Method.java:580)
2024-07-02 09:40:54,035 [65232580]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,035 [65232580]   WARN - #c.i.e.r.RemoteProcessSupport - at java.rmi/sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:360)
2024-07-02 09:40:54,036 [65232581]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,036 [65232581]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at java.rmi/sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:360)
2024-07-02 09:40:54,036 [65232581]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,036 [65232581]   WARN - #c.i.e.r.RemoteProcessSupport - at java.rmi/sun.rmi.transport.Transport$1.run(Transport.java:200)
2024-07-02 09:40:54,036 [65232581]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,036 [65232581]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at java.rmi/sun.rmi.transport.Transport$1.run(Transport.java:200)
2024-07-02 09:40:54,036 [65232581]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,036 [65232581]   WARN - #c.i.e.r.RemoteProcessSupport - at java.rmi/sun.rmi.transport.Transport$1.run(Transport.java:197)
2024-07-02 09:40:54,036 [65232581]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,036 [65232581]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at java.rmi/sun.rmi.transport.Transport$1.run(Transport.java:197)
2024-07-02 09:40:54,036 [65232581]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,036 [65232581]   WARN - #c.i.e.r.RemoteProcessSupport - at java.base/java.security.AccessController.doPrivileged(AccessController.java:714)
2024-07-02 09:40:54,036 [65232581]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,037 [65232582]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at java.base/java.security.AccessController.doPrivileged(AccessController.java:714)
2024-07-02 09:40:54,037 [65232582]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,037 [65232582]   WARN - #c.i.e.r.RemoteProcessSupport - at java.rmi/sun.rmi.transport.Transport.serviceCall(Transport.java:196)
2024-07-02 09:40:54,037 [65232582]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,037 [65232582]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at java.rmi/sun.rmi.transport.Transport.serviceCall(Transport.java:196)
2024-07-02 09:40:54,037 [65232582]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,037 [65232582]   WARN - #c.i.e.r.RemoteProcessSupport - at java.rmi/sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:598)
2024-07-02 09:40:54,037 [65232582]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,037 [65232582]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at java.rmi/sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:598)
2024-07-02 09:40:54,037 [65232582]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,037 [65232582]   WARN - #c.i.e.r.RemoteProcessSupport - at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:844)
2024-07-02 09:40:54,037 [65232582]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,037 [65232582]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:844)
2024-07-02 09:40:54,037 [65232582]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,038 [65232583]   WARN - #c.i.e.r.RemoteProcessSupport - at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:721)
2024-07-02 09:40:54,038 [65232583]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,038 [65232583]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:721)
2024-07-02 09:40:54,038 [65232583]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,038 [65232583]   WARN - #c.i.e.r.RemoteProcessSupport - at java.base/java.security.AccessController.doPrivileged(AccessController.java:400)
2024-07-02 09:40:54,038 [65232583]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,038 [65232583]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at java.base/java.security.AccessController.doPrivileged(AccessController.java:400)
2024-07-02 09:40:54,038 [65232583]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,038 [65232583]   WARN - #c.i.e.r.RemoteProcessSupport - at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:720)
2024-07-02 09:40:54,038 [65232583]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,039 [65232584]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:720)
2024-07-02 09:40:54,039 [65232584]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,039 [65232584]   WARN - #c.i.e.r.RemoteProcessSupport - at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
2024-07-02 09:40:54,039 [65232584]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,039 [65232584]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
2024-07-02 09:40:54,039 [65232584]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,039 [65232584]   WARN - #c.i.e.r.RemoteProcessSupport - at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
2024-07-02 09:40:54,039 [65232584]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,039 [65232584]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
2024-07-02 09:40:54,039 [65232584]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,039 [65232584]   WARN - #c.i.e.r.RemoteProcessSupport - at java.base/java.lang.Thread.run(Thread.java:1583)
2024-07-02 09:40:54,039 [65232584]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,040 [65232585]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at java.base/java.lang.Thread.run(Thread.java:1583)
2024-07-02 09:40:54,040 [65232585]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,040 [65232585]   WARN - #c.i.e.r.RemoteProcessSupport - Caused by: com.datastax.oss.driver.api.core.DriverTimeoutException: Query timed out after PT2S
2024-07-02 09:40:54,040 [65232585]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,040 [65232585]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING: Caused by: com.datastax.oss.driver.api.core.DriverTimeoutException: Query timed out after PT2S
2024-07-02 09:40:54,040 [65232585]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,040 [65232585]   WARN - #c.i.e.r.RemoteProcessSupport - at com.datastax.oss.driver.api.core.DriverTimeoutException.copy(DriverTimeoutException.java:34)
2024-07-02 09:40:54,040 [65232585]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,040 [65232585]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at com.datastax.oss.driver.api.core.DriverTimeoutException.copy(DriverTimeoutException.java:34)
2024-07-02 09:40:54,040 [65232585]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,040 [65232585]   WARN - #c.i.e.r.RemoteProcessSupport - at com.datastax.oss.driver.internal.core.util.concurrent.CompletableFutures.getUninterruptibly(CompletableFutures.java:149)
2024-07-02 09:40:54,041 [65232586]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,041 [65232586]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at com.datastax.oss.driver.internal.core.util.concurrent.CompletableFutures.getUninterruptibly(CompletableFutures.java:149)
2024-07-02 09:40:54,041 [65232586]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,041 [65232586]   WARN - #c.i.e.r.RemoteProcessSupport - at com.datastax.oss.driver.internal.core.cql.CqlPrepareSyncProcessor.process(CqlPrepareSyncProcessor.java:59)
2024-07-02 09:40:54,041 [65232586]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,041 [65232586]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at com.datastax.oss.driver.internal.core.cql.CqlPrepareSyncProcessor.process(CqlPrepareSyncProcessor.java:59)
2024-07-02 09:40:54,041 [65232586]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,041 [65232586]   WARN - #c.i.e.r.RemoteProcessSupport - at com.datastax.oss.driver.internal.core.cql.CqlPrepareSyncProcessor.process(CqlPrepareSyncProcessor.java:31)
2024-07-02 09:40:54,041 [65232586]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,041 [65232586]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at com.datastax.oss.driver.internal.core.cql.CqlPrepareSyncProcessor.process(CqlPrepareSyncProcessor.java:31)
2024-07-02 09:40:54,041 [65232586]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,041 [65232586]   WARN - #c.i.e.r.RemoteProcessSupport - at com.datastax.oss.driver.internal.core.session.DefaultSession.execute(DefaultSession.java:230)
2024-07-02 09:40:54,041 [65232586]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,041 [65232586]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at com.datastax.oss.driver.internal.core.session.DefaultSession.execute(DefaultSession.java:230)
2024-07-02 09:40:54,042 [65232587]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,042 [65232587]   WARN - #c.i.e.r.RemoteProcessSupport - at com.datastax.oss.driver.api.core.cql.SyncCqlSession.prepare(SyncCqlSession.java:224)
2024-07-02 09:40:54,042 [65232587]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,042 [65232587]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at com.datastax.oss.driver.api.core.cql.SyncCqlSession.prepare(SyncCqlSession.java:224)
2024-07-02 09:40:54,042 [65232587]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,042 [65232587]   WARN - #c.i.e.r.RemoteProcessSupport - at com.ing.data.cassandra.jdbc.CassandraPreparedStatement.<init>(CassandraPreparedStatement.java:146)
2024-07-02 09:40:54,042 [65232587]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,042 [65232587]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    at com.ing.data.cassandra.jdbc.CassandraPreparedStatement.<init>(CassandraPreparedStatement.java:146)
2024-07-02 09:40:54,042 [65232587]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,042 [65232587]   WARN - #c.i.e.r.RemoteProcessSupport - ... 28 more
2024-07-02 09:40:54,042 [65232587]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM java.lang.Throwable$WrappedPrintStream println
2024-07-02 09:40:54,042 [65232587]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING:    ... 28 more
2024-07-02 09:40:54,042 [65232587]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,043 [65232588]   INFO - #c.i.e.r.RemoteProcessSupport - getDatabaseProductName: Cassandra
2024-07-02 09:40:54,043 [65232588]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM com.intellij.database.remote.jdbc.helpers.CassJdbcHelper detect
2024-07-02 09:40:54,043 [65232588]   WARN - #c.i.e.r.RemoteProcessSupport - INFO: getDatabaseProductName: Cassandra
2024-07-02 09:40:54,043 [65232588]   INFO - #c.i.e.r.RemoteProcessSupport - release_version: 4.0.11
2024-07-02 09:40:54,043 [65232588]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,043 [65232588]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM com.intellij.database.remote.jdbc.helpers.CassJdbcHelper create
2024-07-02 09:40:54,043 [65232588]   WARN - #c.i.e.r.RemoteProcessSupport - INFO: release_version: 4.0.11
2024-07-02 09:40:54,043 [65232588]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,043 [65232588]   INFO - #c.i.e.r.RemoteProcessSupport - Detected: CASSANDRA 4.0.11
2024-07-02 09:40:54,044 [65232589]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 02, 2024 7:40:54 AM com.intellij.database.remote.jdbc.helpers.JdbcHelperDetection detect
2024-07-02 09:40:54,044 [65232589]   WARN - #c.i.e.r.RemoteProcessSupport - INFO: Detected: CASSANDRA 4.0.11
2024-07-02 09:40:54,044 [65232589]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-02 09:40:54,957 [65233502]   INFO - #c.i.d.c.JdbcEngineUtils - Connection is invalid
2024-07-02 09:41:02,803 [65241348]   INFO - #c.i.w.i.i.j.s.JpsGlobalModelSynchronizerImpl - Saving global entities com.intellij.platform.workspace.jps.entities.SdkEntity to files
2024-07-02 09:41:02,803 [65241348]   INFO - #c.i.w.i.i.j.s.JpsGlobalModelSynchronizerImpl - Saving global entities com.intellij.platform.workspace.jps.entities.LibraryEntity to files
2024-07-02 09:41:26,632 [65265177]   INFO - #c.i.e.r.RemoteProcessSupport - Terminating: 127.0.0.1:52904/RemoteDriverImple1bcb6f4
2024-07-02 09:41:26,768 [65265313]   INFO - #c.i.e.r.RemoteProcessSupport - Process finished with exit code 137 (interrupted by signal 9:SIGKILL)
2024-07-02 09:41:30,543 [65269088]   INFO - #c.i.w.i.i.j.s.JpsGlobalModelSynchronizerImpl - Saving global entities com.intellij.platform.workspace.jps.entities.SdkEntity to files
2024-07-02 09:41:30,543 [65269088]   INFO - #c.i.w.i.i.j.s.JpsGlobalModelSynchronizerImpl - Saving global entities com.intellij.platform.workspace.jps.entities.LibraryEntity to files
maximevw commented 4 months ago

Hello @tjlee,

Thank you for providing these new logs, I see an interesting error inside them: java.sql.SQLTransientException: com.datastax.oss.driver.api.core.DriverTimeoutException: Query timed out after PT2S

I got this issue once during my tests. By default, the request timeout is 2 seconds, but sometimes AstraDB takes more than 2 seconds to respond. So, you can try to add the following parameter to your JDBC URL: requesttimeout=5000 to increase the timeout to 5 seconds. If necessary, you can put a bigger timeout value (in millseconds). The full URL becomes: jdbc:cassandra:dbaas:///kscloud_test?user=token&password=AstraCS:$$TOKEN$$&secureconnectbundle=/tmp/secure-connect-kscloud-test.zip&requesttimeout=5000

You can also specify a connecttimeout in milliseconds if necessary following the same principle.

tjlee commented 4 months ago

Thank you for your help.

I've tried with suggested parameters. Still can't execute any query. Got the following in the log:

2024-07-03 21:29:27,304 [ 370745]   INFO - #c.i.e.r.RemoteProcessSupport - /Users/vasilii.chernov/Applications/DataGrip.app/Contents/jbr/Contents/Home/bin/java -Djava.rmi.server.hostname=127.0.0.1 -Duser.timezone=UTC -Xmx750m -Xms256m -Djdbc.classpath=/Users/vasilii.chernov/Applications/DataGrip.app/Contents/plugins/DatabaseTools/lib/jdbc-console.jar:/Users/vasilii.chernov/Downloads/cassandra-jdbc-wrapper-4.12.0-bundle.jar --add-exports java.desktop/sun.awt=ALL-UNNAMED --add-exports java.desktop/java.awt.peer=ALL-UNNAMED --add-opens java.desktop/java.awt=ALL-UNNAMED --add-opens=jdk.unsupported/sun.misc=ALL-UNNAMED --add-opens=java.base/java.nio=ALL-UNNAMED --add-opens=java.base/java.util=ALL-UNNAMED -Dfile.encoding=UTF-8 -Dsun.stdout.encoding=UTF-8 -Dsun.stderr.encoding=UTF-8 -classpath /Users/vasilii.chernov/Applications/DataGrip.app/Contents/lib/util_rt.jar:/Users/vasilii.chernov/Applications/DataGrip.app/Contents/lib/util-8.jar:/Users/vasilii.chernov/Applications/DataGrip.app/Contents/lib/groovy.jar:/Users/vasilii.chernov/Applications/DataGrip.app/Contents/plugins/DatabaseTools/lib/jdbc-console.jar:/Users/vasilii.chernov/Applications/DataGrip.app/Contents/plugins/grid-core-impl/lib/jdbc-console-types.jar:/Users/vasilii.chernov/Applications/DataGrip.app/Contents/lib/util.jar:/Users/vasilii.chernov/Applications/DataGrip.app/Contents/lib/bouncy-castle.jar com.intellij.database.remote.RemoteJdbcServer com.ing.data.cassandra.jdbc.CassandraDriver
2024-07-03 21:29:27,729 [ 371170]   INFO - #c.i.e.r.RemoteProcessSupport - Using classpath: /Users/vasilii.chernov/Applications/DataGrip.app/Contents/plugins/DatabaseTools/lib/jdbc-console.jar:/Users/vasilii.chernov/Downloads/cassandra-jdbc-wrapper-4.12.0-bundle.jar
2024-07-03 21:29:27,729 [ 371170]   INFO - #c.i.e.r.RemoteProcessSupport - and base loader jdk.internal.loader.ClassLoaders$PlatformClassLoader@396e2f39
2024-07-03 21:29:27,860 [ 371301]   INFO - #c.i.e.r.RemoteProcessSupport - Desktop actions are jbr-api
2024-07-03 21:29:27,972 [ 371413]   INFO - #c.i.e.r.RemoteProcessSupport - Port/ServicesPort/ID: 49767/63859/RemoteDriverImplc3c1579d
2024-07-03 21:29:28,022 [ 371463]   INFO - #c.i.d.d.DatabaseConnectionEstablisher - Connecting to: jdbc:cassandra://dbaas/default_keyspace?user=token&password=AstraCS$$TOKEN$$&secureconnectbundle=/Users/vasilii.chernov/Projects/secure-connect-test-datagrip-astra.zip&requesttimeout=20000&connecttimeout=20000
2024-07-03 21:29:28,023 [ 371464]   INFO - #c.i.e.r.RemoteProcessSupport - 
2024-07-03 21:29:28,028 [ 371469]   INFO - #c.i.e.r.RemoteProcessSupport - Will duplicate streams to log
2024-07-03 21:29:28,029 [ 371470]   INFO - #c.i.d.d.DatabaseConnectionEstablisher - Auth provider: user-pass
2024-07-03 21:29:28,044 [ 371485]   INFO - #c.i.d.d.DatabaseCredentialsAuthProvider - No user name provided (may be in url)
2024-07-03 21:29:28,138 [ 371579]   INFO - #c.i.e.r.RemoteProcessSupport - setting driver log level to ALL
2024-07-03 21:29:28,180 [ 371621]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 03, 2024 7:29:28 PM com.intellij.database.remote.jdbc.helpers.JdbcHelperImpl connect
2024-07-03 21:29:28,180 [ 371621]   WARN - #c.i.e.r.RemoteProcessSupport - INFO: setting driver log level to ALL
2024-07-03 21:29:28,180 [ 371621]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-03 21:29:28,180 [ 371621]   INFO - #c.i.e.r.RemoteProcessSupport - setting driver log path to null
2024-07-03 21:29:28,181 [ 371622]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 03, 2024 7:29:28 PM com.intellij.database.remote.jdbc.helpers.JdbcHelperImpl connect
2024-07-03 21:29:28,181 [ 371622]   WARN - #c.i.e.r.RemoteProcessSupport - INFO: setting driver log path to null
2024-07-03 21:29:28,181 [ 371622]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-03 21:29:28,182 [ 371623]   INFO - #c.i.e.r.RemoteProcessSupport - DriverManager.LogWriter.level=ALL
2024-07-03 21:29:28,183 [ 371624]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 03, 2024 7:29:28 PM com.intellij.database.remote.jdbc.helpers.JdbcHelperImpl setDriverLogLevel
2024-07-03 21:29:28,183 [ 371624]   WARN - #c.i.e.r.RemoteProcessSupport - INFO: DriverManager.LogWriter.level=ALL
2024-07-03 21:29:28,183 [ 371624]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-03 21:29:28,183 [ 371624]   INFO - #c.i.e.r.RemoteProcessSupport - com.ing.data.cassandra.level=ALL
2024-07-03 21:29:28,184 [ 371625]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 03, 2024 7:29:28 PM com.intellij.database.remote.jdbc.helpers.JdbcHelperImpl setDriverLogLevel
2024-07-03 21:29:28,184 [ 371625]   WARN - #c.i.e.r.RemoteProcessSupport - INFO: com.ing.data.cassandra.level=ALL
2024-07-03 21:29:28,184 [ 371625]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-03 21:29:28,195 [ 371636]   WARN - #c.i.e.r.RemoteProcessSupport - SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
2024-07-03 21:29:28,195 [ 371636]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 03, 2024 7:29:28 PM org.slf4j.helpers.Util report
2024-07-03 21:29:28,195 [ 371636]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING: SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
2024-07-03 21:29:28,195 [ 371636]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-03 21:29:28,195 [ 371636]   WARN - #c.i.e.r.RemoteProcessSupport - SLF4J: Defaulting to no-operation (NOP) logger implementation
2024-07-03 21:29:28,196 [ 371637]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 03, 2024 7:29:28 PM org.slf4j.helpers.Util report
2024-07-03 21:29:28,196 [ 371637]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING: SLF4J: Defaulting to no-operation (NOP) logger implementation
2024-07-03 21:29:28,196 [ 371637]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-03 21:29:28,196 [ 371637]   WARN - #c.i.e.r.RemoteProcessSupport - SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
2024-07-03 21:29:28,196 [ 371637]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 03, 2024 7:29:28 PM org.slf4j.helpers.Util report
2024-07-03 21:29:28,196 [ 371637]   WARN - #c.i.e.r.RemoteProcessSupport - WARNING: SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
2024-07-03 21:29:28,196 [ 371637]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-03 21:29:34,603 [ 378044]   INFO - #c.i.e.r.RemoteProcessSupport - Driver: Cassandra JDBC Driver 4.12.0
2024-07-03 21:29:34,603 [ 378044]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 03, 2024 7:29:34 PM com.intellij.database.remote.jdbc.helpers.JdbcHelperDetection detectImpl
2024-07-03 21:29:34,603 [ 378044]   WARN - #c.i.e.r.RemoteProcessSupport - INFO: Driver: Cassandra JDBC Driver 4.12.0
2024-07-03 21:29:34,603 [ 378044]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-03 21:29:34,605 [ 378046]   INFO - #c.i.e.r.RemoteProcessSupport - getDatabaseProductName: Cassandra
2024-07-03 21:29:34,605 [ 378046]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 03, 2024 7:29:34 PM com.intellij.database.remote.jdbc.helpers.CassJdbcHelper detect
2024-07-03 21:29:34,605 [ 378046]   WARN - #c.i.e.r.RemoteProcessSupport - INFO: getDatabaseProductName: Cassandra
2024-07-03 21:29:34,605 [ 378046]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-03 21:29:34,995 [ 378436]   INFO - #c.i.e.r.RemoteProcessSupport - release_version: 4.0.11-09ec37c912ed
2024-07-03 21:29:34,996 [ 378437]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 03, 2024 7:29:34 PM com.intellij.database.remote.jdbc.helpers.CassJdbcHelper create
2024-07-03 21:29:34,996 [ 378437]   WARN - #c.i.e.r.RemoteProcessSupport - INFO: release_version: 4.0.11-09ec37c912ed
2024-07-03 21:29:34,996 [ 378437]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-03 21:29:34,998 [ 378439]   INFO - #c.i.e.r.RemoteProcessSupport - Detected: CASSANDRA 4.0.11
2024-07-03 21:29:34,998 [ 378439]   WARN - #c.i.e.r.RemoteProcessSupport - Jul 03, 2024 7:29:34 PM com.intellij.database.remote.jdbc.helpers.JdbcHelperDetection detect
2024-07-03 21:29:34,998 [ 378439]   WARN - #c.i.e.r.RemoteProcessSupport - INFO: Detected: CASSANDRA 4.0.11
2024-07-03 21:29:34,998 [ 378439]   WARN - #c.i.e.r.RemoteProcessSupport - 
2024-07-03 21:29:35,177 [ 378618]   INFO - #c.i.d.c.JdbcEngineUtils - Connection is invalid
2024-07-03 21:29:52,167 [ 395608]   INFO - #c.i.e.r.RemoteProcessSupport - Process finished with exit code 1
maximevw commented 4 months ago

@tjlee Hmmm... we're back to the start. The issue seems to come from JdbcEngineUtils producing the error "Connection is invalid". But, since DataGrip is not open-source, I can't provide help on what happen in this specific class and causing the error. I noticed the logs just above the error seem to demonstrate the connection is correctly established in a first time and that some queries (to get the database version for example) are successfully executed, I guess.

I'll be happy to fix the root cause of the error if it's due to a bug in this JDBC driver, but unfortunately, I have no clue on it for the moment.

Maybe @kornilova203 could help to understand what is happening here.

tjlee commented 4 months ago

Yes, it could be an error in DataGrip itself. Let's wait for an answer from @kornilova203