Data Grip Error: Java.net related error message while quering Follow
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
Please sign in to leave a comment.
Please follow: https://youtrack.jetbrains.com/issue/DBE-6043
[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
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!
In my case I restarted DataGrip and it works! by luck!
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.
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
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).