From: | Emi Lu <emilu(at)encs(dot)concordia(dot)ca> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Fwd: dblink server closed the connection unexpectedly - Exception |
Date: | 2011-04-06 20:42:57 |
Message-ID: | 4D9CD051.1090103@encs.concordia.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2011-04-06 20:52:44 | Re: Postgres-9.x - ADODB - PHP |
Previous Message | Rich Shepard | 2011-04-06 20:30:55 | Re: Postgres-9.x - ADODB - PHP |