Data Grip Error: Java.net related error message while quering

Answered

I frequently encounter error message below while using data grid to get data from a database. The error message only shows up for certain query (with date-related string or integer) but not others. The error message would pop up 30-40 minutes into the query. 

 

[2018-03-04 18:57:30] java.net.SocketException: Connection reset
[2018-03-04 18:57:32] java.net.ConnectException: Connection refused: connect
[2018-03-04 18:57:33] java.net.ConnectException: Connection refused: connect

7 comments
Comment actions Permalink

[2018-11-13 11:05:36] completed in 7 s 25 ms
[2018-11-13 11:05:36] [08S01] Communications link failure
[2018-11-13 11:05:36] The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
[2018-11-13 11:05:36] java.net.ConnectException: Connection refused: connect

These errors are preventing me to create a simple select query on a small table. I can't use the product

1
Comment actions Permalink

I get this same issue.  Nothing seems to fix it, driving me nuts.  DataGrip used to work, but I just get this error now, and have done for the last month or so.

1
Comment actions Permalink

Hello, I experienced a similar error on the Mac, and this is what worked for me. Go to (apple in top left) > system preferences > mySQL (what I was using) > turn on active instance.

This worked for me, hope it works for you too!

0
Comment actions Permalink

In my case I restarted DataGrip and it works! by luck!

0
Comment actions Permalink

I have also been getting the same issue for the past few months now.

I've never had this issue in 2019.

=== About ===
Build version: DataGrip 2019.3.3 Build #DB-193.6494.42 February 12, 2020
Java version: 11.0.5+10-b520.38amd64
Operating System: Linux (4.17.2-041702-generic, amd64)
JVM version: OpenJDK 64-Bit Server VM JetBrains s.r.o

0
Comment actions Permalink

How long your queries run? It looks like that connection is dropped on server side due to timeout.

See how it works for PostgreSQL https://stackoverflow.com/questions/31359000/how-to-cancel-long-running-query-in-postgresql-with-jdbc (cron task kills all long running queries by pid).

0

Please sign in to leave a comment.