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
Please sign in to leave a comment.
Have you set the timeout for postgres server? Check out this: https://dba.stackexchange.com/questions/164419/is-it-possible-to-limit-timeout-on-postgres-server
Hi, Liu Pei Pei
statement_timeout and idle_in_transaction_session_timeout have value "0". This means that these features are disabled.
@Andrew,
Do you connect via SSH tunnel?
No, without SSH tunnel.
@Andrew,
Don't you configure `statement_timeout` per session or per user?
Could you execute the same long query via psql cli?