DataGrip Hangs on connecting to Any MySQL DataSource

Datagrip v 2019.1

java 10 2018-03-20

I tried MySQL JDBC drivers v 5 and 8

This happened suddenly, without changing anything about the configuration. There were no Mac updates, except Slack. I've updated from 2018.1 to 2019.1 as well as the latest version of Java. These updates did not solve the issue. This happens when trying to connect to Local databases and remote databases. Datagrip hangs on connecting to database forever.

Logs:

2019-06-05 13:33:08,029 [ 80805] INFO - ution.rmi.RemoteProcessSupport - Port/ID: 14823/RemoteDriverImplea10c53b 
2019-06-05 13:33:08,054 [ 80830] INFO - urce.DatabaseConnectionManager - Connecting as: vagrant
2019-06-05 13:33:08,054 [ 80830] INFO - urce.DatabaseConnectionManager - Connecting to: jdbc:mysql://localhost:3306/master 
2019-06-05 13:33:08,348 [ 81124] INFO - ution.rmi.RemoteProcessSupport - /Applications/DataGrip.app/Contents/jdk/Contents/Home/jre/bin/java -Djava.net.preferIPv4Stack=true -Djava.rmi.server.hostname=127.0.0.1 -Duser.timezone=UTC -Dfile.encoding=UTF-8 -classpath "/Applications/DataGrip.app/Contents/lib/util.jar:/Applications/DataGrip.app/Contents/lib/trove4j.jar:/Applications/DataGrip.app/Contents/lib/groovy-all-2.4.15.jar:/Applications/DataGrip.app/Contents/plugins/DatabaseTools/lib/jdbc-console.jar:/Applications/DataGrip.app/Contents/plugins/DatabaseTools/lib/dekaf-single-2.0.0.390.jar:/Users/user/Library/Preferences/DataGrip2019.1/jdbc-drivers/MySQL Connector/J 8/8.0.15/mysql-connector-java-8.0.15.jar" com.intellij.database.remote.RemoteJdbcServer com.mysql.cj.jdbc.Driver
2019-06-05 13:33:08,546 [ 81322] INFO - ution.rmi.RemoteProcessSupport - Port/ID: 9704/RemoteDriverImpl20cbf9a4
2019-06-05 13:33:08,645 [ 81421] INFO - ution.rmi.RemoteProcessSupport - Terminating: 9704/RemoteDriverImpl20cbf9a4
2019-06-05 13:33:08,702 [ 81478] INFO - ution.rmi.RemoteProcessSupport - Process finished with exit code 137 (interrupted by signal 9: SIGKILL)
2019-06-05 13:33:09,609 [ 82385] WARN - ij.database.util.LoaderContext - Merging different contexts
2019-06-05 13:33:09,609 [ 82385] INFO - ution.rmi.RemoteProcessSupport - Terminating: 14823/RemoteDriverImplea10c53b
2019-06-05 13:33:09,655 [ 82431] INFO - ution.rmi.RemoteProcessSupport - Process finished with exit code 137 (interrupted by signal 9: SIGKILL)
2019-06-05 13:33:09,655 [ 82431] WARN - urce.DatabaseConnectionManager - java.rmi.UnmarshalException: Error unmarshaling return header; nested exception is:
java.io.EOFException
2019-06-05 13:33:09,656 [ 82432] WARN - urce.DatabaseConnectionManager - Null connection returned for: jdbc:mysql://localhost:3306/master 
2019-06-05 13:33:09,681 [ 82457] INFO - ution.rmi.RemoteProcessSupport - /Applications/DataGrip.app/Contents/jdk/Contents/Home/jre/bin/java -Djava.net.preferIPv4Stack=true -Djava.rmi.server.hostname=127.0.0.1 -Duser.timezone=UTC -Dfile.encoding=UTF-8 -classpath "/Applications/DataGrip.app/Contents/lib/util.jar:/Applications/DataGrip.app/Contents/lib/trove4j.jar:/Applications/DataGrip.app/Contents/lib/groovy-all-2.4.15.jar:/Applications/DataGrip.app/Contents/plugins/DatabaseTools/lib/jdbc-console.jar:/Applications/DataGrip.app/Contents/plugins/DatabaseTools/lib/dekaf-single-2.0.0.390.jar:/Users/user/Library/Preferences/DataGrip2019.1/jdbc-drivers/MySQL Connector/J 8/8.0.15/mysql-connector-java-8.0.15.jar" com.intellij.database.remote.RemoteJdbcServer com.mysql.cj.jdbc.Driver
2019-06-05 13:33:09,877 [ 82653] INFO - ution.rmi.RemoteProcessSupport - Port/ID: 11346/RemoteDriverImplb6cefb47
2019-06-05 13:33:09,902 [ 82678] INFO - urce.DatabaseConnectionManager - Connecting as: vagrant
2019-06-05 13:33:09,902 [ 82678] INFO - urce.DatabaseConnectionManager - Connecting to: jdbc:mysql://localhost:3306/master 
2019-06-05 13:36:50,323 [ 303099] INFO - ntellij.util.proxy.CommonProxy - <html>You have JVM property "socksProxyHost" set to "localhost".<br>This may lead to incorrect behaviour. Proxy should be set in Settings | HTTP Proxy<br>This JVM property is old and its usage is not recommended by Oracle.<br>(Note: It could have been assigned by some code dynamically.)
2019-06-05 13:38:01,663 [ 374439] INFO - mponents.impl.stores.StoreUtil - saveProjectsAndApp took 166 ms
2019-06-05 13:42:28,153 [ 640929] INFO - ntellij.util.proxy.CommonProxy - <html>You have JVM property "socksProxyHost" set to "localhost".<br>This may lead to incorrect behaviour. Proxy should be set in Settings | HTTP Proxy<br>This JVM property is old and its usage is not recommended by Oracle.<br>(Note: It could have been assigned by some code dynamically.)
2019-06-05 13:46:59,940 [ 912716] INFO - ntellij.util.proxy.CommonProxy - <html>You have JVM property "socksProxyHost" set to "localhost".<br>This may lead to incorrect behaviour. Proxy should be set in Settings | HTTP Proxy<br>This JVM property is old and its usage is not recommended by Oracle.<br>(Note: It could have been assigned by some code dynamically.)
2019-06-05 13:52:48,153 [1260929] INFO - ntellij.util.proxy.CommonProxy - <html>You have JVM property "socksProxyHost" set to "localhost".<br>This may lead to incorrect behaviour. Proxy should be set in Settings | HTTP Proxy<br>This JVM property is old and its usage is not recommended by Oracle.<br>(Note: It could have been assigned by some code dynamically.)
2019-06-05 13:58:06,559 [1579335] INFO - ution.rmi.RemoteProcessSupport - Terminating: 11346/RemoteDriverImplb6cefb47
2019-06-05 13:58:06,612 [1579388] WARN - urce.DatabaseConnectionManager - java.rmi.UnmarshalException: Error unmarshaling return header; nested exception is:
java.io.EOFException
2019-06-05 13:58:06,612 [1579388] INFO - ution.rmi.RemoteProcessSupport - Process finished with exit code 137 (interrupted by signal 9: SIGKILL)
2019-06-05 13:58:06,612 [1579388] WARN - urce.DatabaseConnectionManager - Null connection returned for: jdbc:mysql://localhost:3306/master 
2019-06-05 13:58:07,290 [1580066] INFO - ution.rmi.RemoteProcessSupport - Terminating: 34439/RemoteDriverImpl25725316
2019-06-05 13:58:07,337 [1580113] WARN - urce.DatabaseConnectionManager - java.rmi.UnmarshalException: Error unmarshaling return header; nested exception is:
java.io.EOFException
2019-06-05 13:58:07,337 [1580113] INFO - ution.rmi.RemoteProcessSupport - Process finished with exit code 137 (interrupted by signal 9: SIGKILL)
2019-06-05 13:58:07,338 [1580114] WARN - urce.DatabaseConnectionManager - Null connection returned for: jdbc:mysql://localhost:3306/master 
2019-06-05 13:58:10,048 [1582824] INFO - mponents.impl.stores.StoreUtil - saveProjectsAndApp took 37 ms
2019-06-05 14:00:50,142 [1742918] INFO - mponents.impl.stores.StoreUtil - saveProjectsAndApp took 20 ms 

 

1 comment

@Kfox,

According to your logs:

You have JVM property "socksProxyHost" set to "localhost".<br>This may lead to incorrect behaviour.

Do you want to connect to MySQL via socket? How do you verify that your MySQL server is up and running?

0

Please sign in to leave a comment.