dblink server closed the connection unexpectedly - Exception

Started by Emi Luabout 15 years ago2 messagesgeneral
Jump to latest
#1Emi Lu
emilu@encs.concordia.ca

Hello,

I got the following exception from dblink query:
==================================================
sql>...
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>

Note: "sql>" is changed to "i>"

When re-start database server, the error disappear automatically.

Could someone let me what may cause this exception please?

Thanks alot!

--
Emi

#2Emi Lu
emilu@encs.concordia.ca
In reply to: Emi Lu (#1)
Fwd: dblink server closed the connection unexpectedly - Exception

Hello,

I got the following exception from dblink query:
==================================================
sql>...
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>

Note: "sql>" is changed to "i>"

When re-start database server, the error disappear automatically.

Could someone let me what may cause this exception please?

Found an online doc saying:
===============================
2.3 Port-Scanning Via Remote Access
When a connection attempt fails, dblink throws an sqlclient unable to
establish sqlconnection exception including an explanation of the error.
Examples of these details are listed below.
SELECT * FROM dblink_connect(�host=1.2.3.4
port=5678
user=name
password=secret
dbname=abc
connect_timeout=10�);

Port is open
DETAIL: server closed the connection unexpectedly This probably means
the server terminated abnormally before or while processing the request

In a real example, how do I interpret this? Still what may cause "Port
is open" exception?

Thanks alot!

--
Emi