Re: postgresql-9.0 Windows service stops after database transaction
| От | adrian.kitchingman@dse.vic.gov.au |
|---|---|
| Тема | Re: postgresql-9.0 Windows service stops after database transaction |
| Дата | |
| Msg-id | OF5D70F426.0AC1CA7C-ONCA2577AA.0082B85A-CA2577AB.00009A1D@nre.vic.gov.au обсуждение исходный текст |
| Ответ на | Re: postgresql-9.0 Windows service stops after database transaction (Thom Brown <thom@linux.com>) |
| Ответы |
Re: postgresql-9.0 Windows service stops after database
transaction
(Craig Ringer <craig@postnewspapers.com.au>)
|
| Список | pgsql-performance |
Hi again Thom
Just a quick update regarding my previous reply to you. I managed to do a deeper uninstall of Postgresql 8.3 with these following steps.
* Remove the Registry entries. (HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-8.3) and (HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Services\postgresql-8.3)
* Remove the postgresql-8.3 service. (sc delete postgresql-8.3)
This didn't fix the problem although the 8.3 service is now no longer present in Windows Services nor in pgAdmin. Below is the complete log output when the original error occurs and the 9.0 service is shut down. All I did was delete the content of a table and this is what happens.
2010-09-27 09:52:48 EST LOG: unexpected EOF on client connection
2010-09-27 09:53:05 EST LOG: unexpected EOF on client connection
2010-09-27 09:53:19 EST LOG: server process (PID 2564) was terminated by exception 0xC0000005
2010-09-27 09:53:19 EST HINT: See C include file "ntstatus.h" for a description of the hexadecimal value.
2010-09-27 09:53:19 EST LOG: terminating any other active server processes
2010-09-27 09:53:19 EST WARNING: terminating connection because of crash of another server process
2010-09-27 09:53:19 EST DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2010-09-27 09:53:19 EST HINT: In a moment you should be able to reconnect to the database and repeat your command.
2010-09-27 09:53:19 EST WARNING: terminating connection because of crash of another server process
2010-09-27 09:53:19 EST DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2010-09-27 09:53:19 EST HINT: In a moment you should be able to reconnect to the database and repeat your command.
2010-09-27 09:53:19 EST WARNING: terminating connection because of crash of another server process
2010-09-27 09:53:19 EST DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2010-09-27 09:53:19 EST HINT: In a moment you should be able to reconnect to the database and repeat your command.
2010-09-27 09:53:19 EST LOG: all server processes terminated; reinitializing
2010-09-27 09:53:29 EST FATAL: pre-existing shared memory block is still in use
2010-09-27 09:53:29 EST HINT: Check if there are any old server processes still running, and terminate them.
Thanks again.
Cheers
Adrian
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Adrian Kitchingman, Aquatic Spatial Scientist | Arthur Rylah Institute, Dept of Sustainability and Environment
123 Brown St, Heidelberg, Victoria, Australia, 3084 | ph: + (03) 9450 8716 | fax: + (03) 9450 8799
~~~~~~~~~~~~~~~~~~~~~~~~~~~~ <°)))>< ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: Thom Brown <thom@linux.com>
To: adrian.kitchingman@dse.vic.gov.au
Cc: pgsql-performance@postgresql.org
Date: 24/09/2010 05:05 PM
Subject: Re: [PERFORM] postgresql-9.0 Windows service stops after database transaction
On 24 September 2010 05:39, <adrian.kitchingman@dse.vic.gov.au> wrote:
> Hi all
>
> I've have a strange problem with my Windows postgresql-9.0 service stopping
> after any transaction which manipulates tables in any database (Deleting
> records, Inserting records, bulk importing via \copy, etc). This problem
> occurs regardless whether I'm accessing the database server via pgAdmin III
> on a client machine or the server itself as well as through the command
> prompt. The end result it that I have to constantly restart the postgresql
> service after any transactions. Sometime there is a slight delay allowing a
> couple of transactions but the service is always eventually stopped.
>
> The problem appears to have started when I changed permissions on my machine
> to allow the user 'postgres' access to the C drive following the
> instructions in the last post of this thread:
> http://www.jitterbit.com/PhpBB/viewtopic.php?f=5&t=869
>
> The specs of postres environment are:
>
> Windows XP SP3
> PostgreSQL 9.0.0, compiled by Visual C++ build 1500, 32-bit
> pgAdmin III 1.12.0 (Sep17 2010, rev: REL-1_12_0)
> PostGIS 2.0SVN
>
> Hope someone can shed some light on this issue.
What appears in the logs?
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
Just a quick update regarding my previous reply to you. I managed to do a deeper uninstall of Postgresql 8.3 with these following steps.
* Remove the Registry entries. (HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-8.3) and (HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Services\postgresql-8.3)
* Remove the postgresql-8.3 service. (sc delete postgresql-8.3)
This didn't fix the problem although the 8.3 service is now no longer present in Windows Services nor in pgAdmin. Below is the complete log output when the original error occurs and the 9.0 service is shut down. All I did was delete the content of a table and this is what happens.
2010-09-27 09:52:48 EST LOG: unexpected EOF on client connection
2010-09-27 09:53:05 EST LOG: unexpected EOF on client connection
2010-09-27 09:53:19 EST LOG: server process (PID 2564) was terminated by exception 0xC0000005
2010-09-27 09:53:19 EST HINT: See C include file "ntstatus.h" for a description of the hexadecimal value.
2010-09-27 09:53:19 EST LOG: terminating any other active server processes
2010-09-27 09:53:19 EST WARNING: terminating connection because of crash of another server process
2010-09-27 09:53:19 EST DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2010-09-27 09:53:19 EST HINT: In a moment you should be able to reconnect to the database and repeat your command.
2010-09-27 09:53:19 EST WARNING: terminating connection because of crash of another server process
2010-09-27 09:53:19 EST DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2010-09-27 09:53:19 EST HINT: In a moment you should be able to reconnect to the database and repeat your command.
2010-09-27 09:53:19 EST WARNING: terminating connection because of crash of another server process
2010-09-27 09:53:19 EST DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2010-09-27 09:53:19 EST HINT: In a moment you should be able to reconnect to the database and repeat your command.
2010-09-27 09:53:19 EST LOG: all server processes terminated; reinitializing
2010-09-27 09:53:29 EST FATAL: pre-existing shared memory block is still in use
2010-09-27 09:53:29 EST HINT: Check if there are any old server processes still running, and terminate them.
Thanks again.
Cheers
Adrian
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Adrian Kitchingman, Aquatic Spatial Scientist | Arthur Rylah Institute, Dept of Sustainability and Environment
123 Brown St, Heidelberg, Victoria, Australia, 3084 | ph: + (03) 9450 8716 | fax: + (03) 9450 8799
~~~~~~~~~~~~~~~~~~~~~~~~~~~~ <°)))>< ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: Thom Brown <thom@linux.com>
To: adrian.kitchingman@dse.vic.gov.au
Cc: pgsql-performance@postgresql.org
Date: 24/09/2010 05:05 PM
Subject: Re: [PERFORM] postgresql-9.0 Windows service stops after database transaction
On 24 September 2010 05:39, <adrian.kitchingman@dse.vic.gov.au> wrote:
> Hi all
>
> I've have a strange problem with my Windows postgresql-9.0 service stopping
> after any transaction which manipulates tables in any database (Deleting
> records, Inserting records, bulk importing via \copy, etc). This problem
> occurs regardless whether I'm accessing the database server via pgAdmin III
> on a client machine or the server itself as well as through the command
> prompt. The end result it that I have to constantly restart the postgresql
> service after any transactions. Sometime there is a slight delay allowing a
> couple of transactions but the service is always eventually stopped.
>
> The problem appears to have started when I changed permissions on my machine
> to allow the user 'postgres' access to the C drive following the
> instructions in the last post of this thread:
> http://www.jitterbit.com/PhpBB/viewtopic.php?f=5&t=869
>
> The specs of postres environment are:
>
> Windows XP SP3
> PostgreSQL 9.0.0, compiled by Visual C++ build 1500, 32-bit
> pgAdmin III 1.12.0 (Sep17 2010, rev: REL-1_12_0)
> PostGIS 2.0SVN
>
> Hope someone can shed some light on this issue.
What appears in the logs?
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
Notice:
This email and any attachments may contain information that is personal, confidential,
legally privileged and/or copyright. No part of it should be reproduced, adapted or communicated without the prior written consent of the copyright owner.
It is the responsibility of the recipient to check for and remove viruses.
If you have received this email in error, please notify the sender by return email, delete it from your system and destroy any copies. You are not authorised to use, communicate or rely on the information contained in this email.
Please consider the environment before printing this email.
В списке pgsql-performance по дате отправления:
Предыдущее
От: adrian.kitchingman@dse.vic.gov.auДата:
Сообщение: Re: postgresql-9.0 Windows service stops after database transaction