Обсуждение: postgres 3.7 unexpected closing of connections
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/ ___________________________________________
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.
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.
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.
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/
___________________________________________
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/ > ___________________________________________ > -- ___________________________________________ 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/ ___________________________________________