Fwd: dblink server closed the connection unexpectedly - Exception

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

Browse pgsql-general by date

  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