Skip site navigation (1) Skip section navigation (2)

Re: postgresql-9.0 Windows service stops after database transaction

From: adrian(dot)kitchingman(at)dse(dot)vic(dot)gov(dot)au
To: Thom Brown <thom(at)linux(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: postgresql-9.0 Windows service stops after database transaction
Date: 2010-09-26 23:18:17
Message-ID: OFCBF28187.47271435-ONCA2577AA.007F1363-CA2577AA.00800457@nre.vic.gov.au (view raw or flat)
Thread:
Lists: pgsql-performance
Hi Thom

Thanks for the reply and the log seems to have shed some light. Looks like 
I have my old postgres 8.3 service still running concurrently which is 
interfering with the new 9.0 service. This is the message that comes up a 
lot in the log.

2010-09-24 15:39:34 EST LOG:  unexpected EOF on client connection
2010-09-24 15:39:37 EST LOG:  unexpected EOF on client connection
2010-09-24 15:39:37 EST LOG:  unexpected EOF on client connection
2010-09-24 15:40:07 EST LOG:  server process (PID 3724) was terminated by 
exception 0xC0000005
2010-09-24 15:40:07 EST HINT:  See C include file "ntstatus.h" for a 
description of the hexadecimal value.
2010-09-24 15:40:07 EST LOG:  terminating any other active server 
processes
2010-09-24 15:40:07 EST WARNING:  terminating connection because of crash 
of another server process
2010-09-24 15:40:07 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-24 15:40:07 EST HINT:  In a moment you should be able to reconnect 
to the database and repeat your command.

It's a bit strange though because I did do an uninstall of the postgres 
8.3 before installing the 9.0. The 8.3 service is still present in Windows 
Services but I've disabled with with no effect on the problem. I notice it 
still is also listed as a separate server in pgAdmin but when it's 
activated it refers to the 9.0 databases. I'm guessing that I have to do a 
deeper uninstall of the 8.3 service. Do you have any pointers on how to go 
about this?

Cheers

Adrian





From:   Thom Brown <thom(at)linux(dot)com>
To:     adrian(dot)kitchingman(at)dse(dot)vic(dot)gov(dot)au
Cc:     pgsql-performance(at)postgresql(dot)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(dot)kitchingman(at)dse(dot)vic(dot)gov(dot)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.

In response to

pgsql-performance by date

Next:From: adrian.kitchingmanDate: 2010-09-27 00:06:34
Subject: Re: postgresql-9.0 Windows service stops after database transaction
Previous:From: Robert HaasDate: 2010-09-26 04:02:27
Subject: Re: Is disableing nested_loops a bad idea ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group