postgres 3.7 unexpected closing of connections

Started by Andrew Macleanalmost 17 years ago6 messagesgeneral

andrew.amaclean@gmail.com

almost 17 years ago

I have the following error message:

"Error connecting to the server: server closed the connection unexpectedly.
This probably means that the server terminated abnormally before or
while processing the request.
"
It happens intermittently both when using pgAdminIII and when using QT
so it is not a pgAdminIII issue.

Often the connection seems to succeed but you get a series of error
messages like the one above when attempting to open a database. It
seems to be a timing issue.

This does not happen with postgresql-8.3.5 but does happen with
postgresql-8.3.7. I used the One-click installer from EnterpriseDB and
am running Vista SP1.

Has anyone any ideas on how to fix this? it is really annoying because
it is intermittent.
I have done a complete reinstallation and deleted everything before
reinstalling it. Lucky it is only a test installation!

Andrew

--
___________________________________________
Andrew J. P. Maclean
Centre for Autonomous Systems
The Rose Street Building J04
The University of Sydney 2006 NSW
AUSTRALIA
Ph: +61 2 9351 3283
Fax: +61 2 9351 7474
URL: http://www.acfr.usyd.edu.au/
___________________________________________

Scott Marlowe

scott.marlowe@gmail.com

almost 17 years ago

In reply to: Andrew Maclean (#1)

Re: postgres 3.7 unexpected closing of connections

On Wed, May 13, 2009 at 5:36 PM, Andrew Maclean
<andrew.amaclean@gmail.com> wrote:

I have the following error message:

"Error connecting to the server: server closed the connection unexpectedly.
This probably means that the server terminated abnormally before or
while processing the request.
"
It happens intermittently both when using pgAdminIII and when using QT
so it is not a pgAdminIII issue.

Often the connection seems to succeed but you get a series of error
messages like the one above when attempting to open a database. It
seems to be a timing issue.

This does not happen with postgresql-8.3.5 but does happen with
postgresql-8.3.7. I used the One-click installer from EnterpriseDB and
am running Vista SP1.

First suspect when running on windows is antivirus software.

Andrew Maclean

a.maclean@cas.edu.au

almost 17 years ago

In reply to: Scott Marlowe (#2)

Re: postgres 3.7 unexpected closing of connections

Actually it is happening on two different Vista platforms one running McAfee
and the other Symantec.

Andrew

-----Original Message-----
From: Scott Marlowe [mailto:scott.marlowe@gmail.com]
Sent: Thursday, 14 May 2009 09:40
To: a.maclean@cas.edu.au
Cc: General
Subject: Re: [GENERAL] postgres 3.7 unexpected closing of connections

On Wed, May 13, 2009 at 5:36 PM, Andrew Maclean
<andrew.amaclean@gmail.com> wrote:

I have the following error message:

"Error connecting to the server: server closed the connection

unexpectedly.

This probably means that the server terminated abnormally before or
while processing the request.
"
It happens intermittently both when using pgAdminIII and when using QT
so it is not a pgAdminIII issue.

Often the connection seems to succeed but you get a series of error
messages like the one above when attempting to open a database. It
seems to be a timing issue.

This does not happen with postgresql-8.3.5 but does happen with
postgresql-8.3.7. I used the One-click installer from EnterpriseDB and
am running Vista SP1.

First suspect when running on windows is antivirus software.

Andrew Maclean

a.maclean@cas.edu.au

almost 17 years ago

In reply to: Scott Marlowe (#2)

Re: postgres 3.7 unexpected closing of connections

I'll check this out but I am puzzled as to why it suddenly appeared after
upgrading.

On Wed, May 13, 2009 at 5:36 PM, Andrew Maclean
<andrew.amaclean@gmail.com> wrote:

I have the following error message:

"Error connecting to the server: server closed the connection

unexpectedly.

This probably means that the server terminated abnormally before or
while processing the request.
"
It happens intermittently both when using pgAdminIII and when using QT
so it is not a pgAdminIII issue.

Often the connection seems to succeed but you get a series of error
messages like the one above when attempting to open a database. It
seems to be a timing issue.

This does not happen with postgresql-8.3.5 but does happen with
postgresql-8.3.7. I used the One-click installer from EnterpriseDB and
am running Vista SP1.

First suspect when running on windows is antivirus software.

Andrew Maclean

andrew.amaclean@gmail.com

almost 17 years ago

In reply to: Andrew Maclean (#1)

Re: postgres 3.7 unexpected closing of connections

I did a fresh installation after deleting every reference to postgres
and pgAdmin in the registry and removing the relevant folders.
It looks as if the installation fails when loading additional modules.
I also think host should be localhost at this stage.

Here is a portion of the log that shows a definite error:
***********************************************************************************************************

Script output:
Starting postgresql-8.3
Service postgresql-8.3 started successfully
startserver.vbs ran to completion

Script stderr:

Loading additional SQL modules...
Executing cscript
Script exit code: 2

Script output:
Installing pl/pgsql in the template1 databases...
psql: could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "???" and accepting
TCP/IP connections on port 5432?

Failed to install pl/pgsql in the 'template1' database
Installing the adminpack module in the postgres database...
psql: could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "???" and accepting
TCP/IP connections on port 5432?

Failed to install the 'adminpack' module in the 'postgres' database
loadmodules.vbs ran to completion

Script stderr:
Program ended with an error exit code

Error running cscript //NoLogo "C:\Program
Files\PostgreSQL\8.3\installer\server\loadmodules.vbs" "postgres" ""
"C:\Program Files\PostgreSQL\8.3" "C:\Program
Files\PostgreSQL\8.3\data" 5432 : Program ended with an error exit
code
Error running cscript //NoLogo "C:\Program
Files\PostgreSQL\8.3\installer\server\loadmodules.vbs" "postgres" "x"
"C:\Program Files\PostgreSQL\8.3" "C:\Program
Files\PostgreSQL\8.3\data" 5432 : Program ended with an error exit
code
Write the data directory to the ini file...
Write the port number, service ID, locale and superuser to the ini file...
***********************************************************************************************************

On Thu, May 14, 2009 at 9:57 AM, Andrew Maclean <a.maclean@cas.edu.au> wrote:

I'll check this out but I am puzzled as to why it suddenly appeared after
upgrading.

-----Original Message-----
From: Scott Marlowe [mailto:scott.marlowe@gmail.com]
Sent: Thursday, 14 May 2009 09:40
To: a.maclean@cas.edu.au
Cc: General
Subject: Re: [GENERAL] postgres 3.7 unexpected closing of connections

On Wed, May 13, 2009 at 5:36 PM, Andrew Maclean
<andrew.amaclean@gmail.com> wrote:

I have the following error message:

"Error connecting to the server: server closed the connection

unexpectedly.

This probably means that the server terminated abnormally before or
while processing the request.
"
It happens intermittently both when using pgAdminIII and when using QT
so it is not a pgAdminIII issue.

Often the connection seems to succeed but you get a series of error
messages like the one above when attempting to open a database. It
seems to be a timing issue.

This does not happen with postgresql-8.3.5 but does happen with
postgresql-8.3.7. I used the One-click installer from EnterpriseDB and
am running Vista SP1.

First suspect when running on windows is antivirus software.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Import Notes

Reply to msg id not found: -4000255863800879191@unknownmsgid

Andrew Maclean

andrew.amaclean@gmail.com

almost 17 years ago

In reply to: Andrew Maclean (#5)

Re: postgres 3.7 unexpected closing of connections

I tried the pgInstaller instead of the One Click Installer and
everything installed correctly.

Andrew

On Thu, May 14, 2009 at 10:34 AM, Andrew Maclean
<andrew.amaclean@gmail.com> wrote:

I did a fresh installation after deleting every reference to postgres
and pgAdmin in the registry and removing the relevant folders.
It looks as if the installation fails when loading additional modules.
I also think host should be localhost at this stage.

Here is a portion of the log that shows a definite error:
***********************************************************************************************************

Script output:
Starting postgresql-8.3
Service postgresql-8.3 started successfully
startserver.vbs ran to completion

Script stderr:

Loading additional SQL modules...
Executing cscript
Script exit code: 2

Script output:
Installing pl/pgsql in the template1 databases...
psql: could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "???" and accepting
TCP/IP connections on port 5432?

Failed to install pl/pgsql in the 'template1' database
Installing the adminpack module in the postgres database...
psql: could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "???" and accepting
TCP/IP connections on port 5432?

Failed to install the 'adminpack' module in the 'postgres' database
loadmodules.vbs ran to completion

Script stderr:
Program ended with an error exit code

Error running cscript //NoLogo "C:\Program
Files\PostgreSQL\8.3\installer\server\loadmodules.vbs" "postgres" ""
"C:\Program Files\PostgreSQL\8.3" "C:\Program
Files\PostgreSQL\8.3\data" 5432 : Program ended with an error exit
code
Error running cscript //NoLogo "C:\Program
Files\PostgreSQL\8.3\installer\server\loadmodules.vbs" "postgres" "x"
"C:\Program Files\PostgreSQL\8.3" "C:\Program
Files\PostgreSQL\8.3\data" 5432 : Program ended with an error exit
code
Write the data directory to the ini file...
Write the port number, service ID, locale and superuser to the ini file...
***********************************************************************************************************

On Thu, May 14, 2009 at 9:57 AM, Andrew Maclean <a.maclean@cas.edu.au> wrote:

I'll check this out but I am puzzled as to why it suddenly appeared after
upgrading.

-----Original Message-----
From: Scott Marlowe [mailto:scott.marlowe@gmail.com]
Sent: Thursday, 14 May 2009 09:40
To: a.maclean@cas.edu.au
Cc: General
Subject: Re: [GENERAL] postgres 3.7 unexpected closing of connections

On Wed, May 13, 2009 at 5:36 PM, Andrew Maclean
<andrew.amaclean@gmail.com> wrote:

I have the following error message:

"Error connecting to the server: server closed the connection

unexpectedly.

This probably means that the server terminated abnormally before or
while processing the request.
"
It happens intermittently both when using pgAdminIII and when using QT
so it is not a pgAdminIII issue.

Often the connection seems to succeed but you get a series of error
messages like the one above when attempting to open a database. It
seems to be a timing issue.

This does not happen with postgresql-8.3.5 but does happen with
postgresql-8.3.7. I used the One-click installer from EnterpriseDB and
am running Vista SP1.

First suspect when running on windows is antivirus software.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
___________________________________________
Andrew J. P. Maclean
Centre for Autonomous Systems
The Rose Street Building J04
The University of Sydney 2006 NSW
AUSTRALIA
Ph: +61 2 9351 3283
Fax: +61 2 9351 7474
URL: http://www.acfr.usyd.edu.au/
___________________________________________