Error with long request to remote postres server

Hi, I have problem.

When I am executing long request to remote server (more than 20 seconds), after 20 seconds executing I get error

2019-10-22 18:27:12,336 [6747223] WARN - ution.rmi.RemoteProcessSupport - java.rmi.ConnectException: Connection refused to host: 127.0.0.1; nested exception is: 
2019-10-22 18:27:12,336 [6747223] WARN - ution.rmi.RemoteProcessSupport - java.net.ConnectException: Connection refused (Connection refused)
2019-10-22 18:27:12,336 [6747223] WARN - ution.rmi.RemoteProcessSupport - at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:619)
2019-10-22 18:27:12,336 [6747223] WARN - ution.rmi.RemoteProcessSupport - at sun.rmi.transport.tcp.TCPChannel.createConnection(TCPChannel.java:216)
2019-10-22 18:27:12,336 [6747223] WARN - ution.rmi.RemoteProcessSupport - at sun.rmi.transport.tcp.TCPChannel.newConnection(TCPChannel.java:202)
2019-10-22 18:27:12,336 [6747223] WARN - ution.rmi.RemoteProcessSupport - at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:129)
2019-10-22 18:27:12,336 [6747223] WARN - ution.rmi.RemoteProcessSupport - at java.rmi.server.RemoteObjectInvocationHandler.invokeRemoteMethod(RemoteObjectInvocationHandler.java:227)
2019-10-22 18:27:12,336 [6747223] WARN - ution.rmi.RemoteProcessSupport - at java.rmi.server.RemoteObjectInvocationHandler.invoke(RemoteObjectInvocationHandler.java:179)
2019-10-22 18:27:12,336 [6747223] WARN - ution.rmi.RemoteProcessSupport - at com.sun.proxy.$Proxy1.ping(Unknown Source)
2019-10-22 18:27:12,336 [6747223] WARN - ution.rmi.RemoteProcessSupport - at com.intellij.execution.rmi.RemoteServer.start(RemoteServer.java:94)
2019-10-22 18:27:12,336 [6747223] WARN - ution.rmi.RemoteProcessSupport - at com.intellij.database.remote.RemoteJdbcServerBase.setupAndStart(RemoteJdbcServerBase.java:19)
2019-10-22 18:27:12,336 [6747223] WARN - ution.rmi.RemoteProcessSupport - at com.intellij.database.remote.RemoteJdbcServer.main(RemoteJdbcServer.java:14)
2019-10-22 18:27:12,336 [6747223] WARN - ution.rmi.RemoteProcessSupport - Caused by: java.net.ConnectException: Connection refused (Connection refused)
2019-10-22 18:27:12,336 [6747223] WARN - ution.rmi.RemoteProcessSupport - at java.net.PlainSocketImpl.socketConnect(Native Method)
2019-10-22 18:27:12,336 [6747223] WARN - ution.rmi.RemoteProcessSupport - at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
2019-10-22 18:27:12,336 [6747223] WARN - ution.rmi.RemoteProcessSupport - at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
2019-10-22 18:27:12,336 [6747223] WARN - ution.rmi.RemoteProcessSupport - at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
2019-10-22 18:27:12,337 [6747224] WARN - ution.rmi.RemoteProcessSupport - at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
2019-10-22 18:27:12,337 [6747224] WARN - ution.rmi.RemoteProcessSupport - at java.net.Socket.connect(Socket.java:589)
2019-10-22 18:27:12,337 [6747224] WARN - ution.rmi.RemoteProcessSupport - at java.net.Socket.connect(Socket.java:538)
2019-10-22 18:27:12,337 [6747224] WARN - ution.rmi.RemoteProcessSupport - at java.net.Socket.<init>(Socket.java:434)
2019-10-22 18:27:12,337 [6747224] WARN - ution.rmi.RemoteProcessSupport - at java.net.Socket.<init>(Socket.java:211)

 

Short request are successful.

All timeouts (connectionTimeout, socketTimeout and e.g.) I set more than 20 seconds

 

 

5 comments
Comment actions Permalink

Hi, Liu Pei Pei

statement_timeout and idle_in_transaction_session_timeout have value "0". This means that these features are disabled.

0
Comment actions Permalink

@Andrew,

Do you connect via SSH tunnel?

0
Comment actions Permalink

No, without SSH tunnel.

0
Comment actions Permalink

@Andrew,

Don't you configure `statement_timeout` per session or per user?

Could you execute the same long query via psql cli?

0

Please sign in to leave a comment.